zackhu9
Member
We recently upgraded from 900 on as400 to 920 on oracle.Customer ledge inquiry does not work in the new version. I traced the sqlstatement to the following:
Notice the where clause has a double address book number and to make it worse, they are bound to different values. Hence, nothing is retrieved. I check the log for our 900 environment, it's only showing one address book in the where clause.
We are on tools release 9.2.2.4
Any guidance is appreciated.
SELECT RPSDCT,RPACR,RPCDS,RPVINV,RPFAP,RPNETTCID,RPJCL,RPVR01,RPCDSA,RPDIVJ,RPCTL,RPAAP,RPADSA,RPPST,RPAR10,RPOMOD,RPMCU,RPRMDS,RPRYIN,RPRF,RPPO,RPAR04,RPAG,RPDCT,RPDDJ,RPDDEX,RPPYID,RPAR05,RPDGJ,RPDRF,RPCO,RPSHPN,RPNETST,RPKCO,RPPWPG,RPADSC,RPAN8,RPDDNJ,RPAR03,RPAR09,RPSFX,RPSFXO,RPCRCD,RPISTR,RPPA8,RPPOST,RPODOC,RPGLC,RPCRR,RPRMK,RPNETDOC,RPNETRC5,RPSDOC,RPAR06,RPOKCO,RPOSFX,RPICU,RPPKCO,RPAR07,RPVDGJ,RPAR01,RPSMTJ,RPSKCO,RPPYR,RPDOC,RPAR08,RPDICJ,RPCRRM,RPBCRC,RPICUT,RPODCT,RPRMR1,RPURRF,RPPDCT,RPAR02,RPAID,RPKCOO FROM TESTDTA.F03B11 WHERE (((RPAN8 = ? AND RPAN8 = ? ))) ORDER BY RPAN8 ASC , RPDCT ASC , RPDOC ASC , RPKCO ASC , RPSFX ASC
23 May 2018 11:53:22,471 [Line -1] [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@63dfed31] [APP ] JDE - [JDBJ] SQL statement parameter marker values are :
23 May 2018 11:53:22,471 [Line -1] [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@63dfed31] [APP ] JDE - [JDBJ] Param1 : 1_Types.NUMERIC,
23 May 2018 11:53:22,471 [Line -1] [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@63dfed31] [APP ] JDE - [JDBJ] Param2 : 11386316_Types.NUMERIC,
Notice the where clause has a double address book number and to make it worse, they are bound to different values. Hence, nothing is retrieved. I check the log for our 900 environment, it's only showing one address book in the where clause.
We are on tools release 9.2.2.4
Any guidance is appreciated.
SELECT RPSDCT,RPACR,RPCDS,RPVINV,RPFAP,RPNETTCID,RPJCL,RPVR01,RPCDSA,RPDIVJ,RPCTL,RPAAP,RPADSA,RPPST,RPAR10,RPOMOD,RPMCU,RPRMDS,RPRYIN,RPRF,RPPO,RPAR04,RPAG,RPDCT,RPDDJ,RPDDEX,RPPYID,RPAR05,RPDGJ,RPDRF,RPCO,RPSHPN,RPNETST,RPKCO,RPPWPG,RPADSC,RPAN8,RPDDNJ,RPAR03,RPAR09,RPSFX,RPSFXO,RPCRCD,RPISTR,RPPA8,RPPOST,RPODOC,RPGLC,RPCRR,RPRMK,RPNETDOC,RPNETRC5,RPSDOC,RPAR06,RPOKCO,RPOSFX,RPICU,RPPKCO,RPAR07,RPVDGJ,RPAR01,RPSMTJ,RPSKCO,RPPYR,RPDOC,RPAR08,RPDICJ,RPCRRM,RPBCRC,RPICUT,RPODCT,RPRMR1,RPURRF,RPPDCT,RPAR02,RPAID,RPKCOO FROM TESTDTA.F03B11 WHERE (((RPAN8 = ? AND RPAN8 = ? ))) ORDER BY RPAN8 ASC , RPDCT ASC , RPDOC ASC , RPKCO ASC , RPSFX ASC
23 May 2018 11:53:22,471 [Line -1] [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@63dfed31] [APP ] JDE - [JDBJ] SQL statement parameter marker values are :
23 May 2018 11:53:22,471 [Line -1] [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@63dfed31] [APP ] JDE - [JDBJ] Param1 : 1_Types.NUMERIC,
23 May 2018 11:53:22,471 [Line -1] [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@63dfed31] [APP ] JDE - [JDBJ] Param2 : 11386316_Types.NUMERIC,