Error at F43090

[lluisenric]

Hello.
I have a problem with F43090 file.
When press buttom Ok in P4310, display this message: "Commit failed or was canceled. Transaction not committed. See jde.log for more information". The message in jde.log: "1508/1448 Mon Sep 06 15:16:22 2004 JDBODBC.C2135
[IBM][Controlador ODBC de iSeries Access][DB2 UDB]SQL0514 - Sentencia preparada QZ8836C99315ED7CAA no encontrada. - SQLSTATE: S1000

1508/1448 Mon Sep 06 15:16:22 2004 jdb_drvm.c938
JDB9900401 - Failed to execute db request

1508/1448 Mon Sep 06 15:16:34 2004 JDBODBC.C5439
ODB0000071 - SQLPrepare failed

1508/1448 Mon Sep 06 15:16:34 2004 JDBODBC.C5439
[IBM][Controlador ODBC de iSeries Access][DB2 UDB]SQL0516 - Sentencia preparada QZ8836CFBB859D27A8 no encontrada. - SQLSTATE: S1000

1508/1448 Mon Sep 06 15:16:34 2004 jdb_drvm.c938
JDB9900401 - Failed to execute db request

1508/1448 Mon Sep 06 15:16:34 2004 jdb_exet.c2546
JDB3600011 - Failed to perform Update for F43090

1508/1448 Mon Sep 06 15:16:35 2004 jdb_exet.c5992
JDB9900849 - Failed to commit user

1508/1448 Mon Sep 06 15:16:35 2004 DLG_MSGB.CPP190
Commit Failed or was Canceled. Transaction not committed."
One suggestion?.
Thanks and i'sorry for my very bad english.
Lluis Enric.
XE update 7 / AS400

 

[Florian_iORGA]

Hola Lluis,

I'm not an expert in SQL and DB2 issues but you may have a problem with the way F43090-"Item/Vendor relationships" is defined in the AS. You could check the table and it's logical files.

The Purchase Order entry program P4310 deals with F43090 because you've got a "1" in the 5th processing option ("Performance fournisseurs, in french) of the 3rd tab ("Interfaces"). If so, the system tries to create/update a record in F43090 according to the new order. If you blank out this processing option, you will probably be able to validate the order.

Hope this helps,
Florian.