#34388
Dario Parente
Miembro

Sigo el hilo de este problema de la importacion de articulos.

Quisiera saber si como primer medida esta claro que hay un bug en libertya 10.03 con respecto a la forma de importar articulos.

He probado de varias forma con respecto al archivo cvs y no importa nada, exactamente como le pasa a este usuario que ya lo expuso aca.
En el curso incluso que he tomado tampoco anduvo cuando se tarto el tema de importacion.
Dejo un error que he tomado del log a ver si pueden ayudarme a solucionarlo y que los campos funcionen para la importacion.

El erroe que da es.

Code:
——————————-
===========> DB.saveError: DBExecuteErrorrr – ERROR: insert or update on table “i_product” violates foreign key constraint “cbpartner_iproduct”
Detail: Key (c_bpartner_id)=(3) is not present in table “c_bpartner”. [52]
——————————-
===========> ImpFormat.updateDB: I_Product_ID=1013631 – rows updated=-1 [52]
——————————-
===========> DB.executeUpdate: Update=UPDATE I_Product SET Value=’3743T’,Name=’ACOPLE DE EXTREMO DIRECCION’,PriceList=254.42,C_BPartner_ID=3,M_Product_Category_ID=0,IsActive=’Y’,Processed=’N’,I_IsImported=’N’,Updated=CURRENT_TIMESTAMP,UpdatedBy=1010717 WHERE I_Product_ID=1013632 [null] [52]
org.postgresql.util.PSQLException: ERROR: insert or update on table “i_product” violates foreign key constraint “cbpartner_iproduct”
Detail: Key (c_bpartner_id)=(3) is not present in table “c_bpartner”.; State=23503; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:437)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:307)
at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:467)
at $Proxy1.executeUpdate(Unknown Source)
at org.openXpertya.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:227)
at org.openXpertya.util.DB.executeUpdate(DB.java:839)
at org.openXpertya.util.DB.executeUpdate(DB.java:786)
at org.openXpertya.impexp.ImpFormat.updateDB(ImpFormat.java:739)
at org.openXpertya.apps.form.VFileImport.cmd_process(VFileImport.java:551)
at org.openXpertya.apps.form.VFileImport.access$000(VFileImport.java:65)
at org.openXpertya.apps.form.VFileImport$1.construct(VFileImport.java:331)
at org.openXpertya.apps.SwingWorker$2.run(SwingWorker.java:45)
at java.lang.Thread.run(Unknown Source)

——————————-
===========> DB.saveError: DBExecuteErrorrr – ERROR: insert or update on table “i_product” violates foreign key constraint “cbpartner_iproduct”
Detail: Key (c_bpartner_id)=(3) is not present in table “c_bpartner”. [52]
——————————-
===========> ImpFormat.updateDB: I_Product_ID=1013632 – rows updated=-1 [52]
——————————-
===========> DB.executeUpdate: Update=UPDATE I_Product SET Value=’3745T’,Name=’ACOPLE DE EXTREMO DIRECCION’,PriceList=0,C_BPartner_ID=3,M_Product_Category_ID=0,IsActive=’Y’,Processed=’N’,I_IsImported=’N’,Updated=CURRENT_TIMESTAMP,UpdatedBy=1010717 WHERE I_Product_ID=1013633 [null] [52]
org.postgresql.util.PSQLException: ERROR: insert or update on table “i_product” violates foreign key constraint “cbpartner_iproduct”
Detail: Key (c_bpartner_id)=(3) is not present in table “c_bpartner”.; State=23503; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:437)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:307)
at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:467)
at $Proxy1.executeUpdate(Unknown Source)
at org.openXpertya.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:227)
at org.openXpertya.util.DB.executeUpdate(DB.java:839)
at org.openXpertya.util.DB.executeUpdate(DB.java:786)
at org.openXpertya.impexp.ImpFormat.updateDB(ImpFormat.java:739)
at org.openXpertya.apps.form.VFileImport.cmd_process(VFileImport.java:551)
at org.openXpertya.apps.form.VFileImport.access$000(VFileImport.java:65)
at org.openXpertya.apps.form.VFileImport$1.construct(VFileImport.java:331)
at org.openXpertya.apps.SwingWorker$2.run(SwingWorker.java:45)
at java.lang.Thread.run(Unknown Source)

disculpen si s largo.
Gracias
Dario