hjphillips
Member
We are in the process of upgrading to tools 9.1.4.2 from 8.98.2.
In Work with Shipments (P4915) we are seeing an SQL error: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0199 - Keyword WHERE not expected. Valid tokens: FULL LEFT CROSS INNER RIGHT
Has anyone else expirienced this issue? We are running on an AS400 (V6.1), EnterpriseOne Applications 9.0 and seeing the issue only with tools 9.1.4.2.
The error is occurring when the following SQL statement is run:
SELECT T0.SDKCOO, T0.SDDOCO, T0.SDDCTO, T0.SDLNID, T0.SDSFXO, T0.SDMCU, T0.SDCO, T0.SDAN8, T0.SDSHAN, T0.SDDRQJ, T0.SDTRDJ, T0.SDPDDJ, T0.SDADDJ, T0.SDCNDJ, T0.SDPEFJ, T0.SDVR01, T0.SDVR02, T0.SDITM, T0.SDLITM, T0.SDAITM, T0.SDLOCN, T0.SDLOTN, T0.SDDSC1, T0.SDDSC2, T0.SDLNTY, T0.SDNXTR, T0.SDLTTR, T0.SDEMCU, T0.SDKTLN, T0.SDRKIT, T0.SDUOM, T0.SDUORG, T0.SDSOQS, T0.SDSOBK, T0.SDSOCN, T0.SDSONE, T0.SDQTYT, T0.SDCOMM, T0.SDUPRC, T0.SDAEXP, T0.SDUNCS, T0.SDECST, T0.SDPSN, T0.SDATXT, T0.SDBACK, T0.SDSBAL, T0.SDAPTS, T0.SDCARS, T0.SDCNID, T0.SDFRTH, T0.SDSHCM, T0.SDSHCN, T0.SDSERN, T0.SDUOM1, T0.SDPQOR, T0.SDUOM2, T0.SDSQOR, T0.SDUOM4, T0.SDSO02, T0.SDSO04, T0.SDSO07, T0.SDSO11, T0.SDSWMS, T0.SDCRCD, T0.SDCRR, T0.SDFUP, T0.SDFEA, T0.SDFUC, T0.SDFEC, T0.SDUSER, T0.SDPID, T0.SDJOBN, T0.SDUPMJ, T0.SDTDAY, T0.SDSO16, T0.SDCORD, T0.SDSHPN, T0.SDBCRC, T0.SDOPDJ, T0.SDKITID, T1.TPDOCO, T1.TPDCTO, T1.TPKCOO, T1.TPLNID, T1.TPOTDOMAIN, T1.TPOTBSHPN FROM ( ( DVDTA/F4211 T0 LEFT OUTER JOIN DVDTA/F49T211 T1 ON T0.SDKCOO = T1.TPKCOO AND T0.SDDOCO = T1.TPDOCO AND T0.SDDCTO = T1.TPDCTO AND T0.SDLNID = T1.TPLNID ) WHERE ( T0.SDDOCO = 8566239.000000 AND T0.SDDCTO = 'SE' AND T0.SDKCOO = '00002' AND T0.SDLNID = 1000.000000 )
The SQL generated has an extra parentheses after the FROM. The SQL is from a vanilla business view (V4211E) which is a SQL 92 left outer join. The error occurs on all applications/reports that use this view.
We have opened a call with Oracle, but have not gotten them to replicate the issue.
Any assistance would be great.
Thank you.
Heather
AS400 (VR6.1), E1 apps 9.0, tools 9.1.4.2
In Work with Shipments (P4915) we are seeing an SQL error: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0199 - Keyword WHERE not expected. Valid tokens: FULL LEFT CROSS INNER RIGHT
Has anyone else expirienced this issue? We are running on an AS400 (V6.1), EnterpriseOne Applications 9.0 and seeing the issue only with tools 9.1.4.2.
The error is occurring when the following SQL statement is run:
SELECT T0.SDKCOO, T0.SDDOCO, T0.SDDCTO, T0.SDLNID, T0.SDSFXO, T0.SDMCU, T0.SDCO, T0.SDAN8, T0.SDSHAN, T0.SDDRQJ, T0.SDTRDJ, T0.SDPDDJ, T0.SDADDJ, T0.SDCNDJ, T0.SDPEFJ, T0.SDVR01, T0.SDVR02, T0.SDITM, T0.SDLITM, T0.SDAITM, T0.SDLOCN, T0.SDLOTN, T0.SDDSC1, T0.SDDSC2, T0.SDLNTY, T0.SDNXTR, T0.SDLTTR, T0.SDEMCU, T0.SDKTLN, T0.SDRKIT, T0.SDUOM, T0.SDUORG, T0.SDSOQS, T0.SDSOBK, T0.SDSOCN, T0.SDSONE, T0.SDQTYT, T0.SDCOMM, T0.SDUPRC, T0.SDAEXP, T0.SDUNCS, T0.SDECST, T0.SDPSN, T0.SDATXT, T0.SDBACK, T0.SDSBAL, T0.SDAPTS, T0.SDCARS, T0.SDCNID, T0.SDFRTH, T0.SDSHCM, T0.SDSHCN, T0.SDSERN, T0.SDUOM1, T0.SDPQOR, T0.SDUOM2, T0.SDSQOR, T0.SDUOM4, T0.SDSO02, T0.SDSO04, T0.SDSO07, T0.SDSO11, T0.SDSWMS, T0.SDCRCD, T0.SDCRR, T0.SDFUP, T0.SDFEA, T0.SDFUC, T0.SDFEC, T0.SDUSER, T0.SDPID, T0.SDJOBN, T0.SDUPMJ, T0.SDTDAY, T0.SDSO16, T0.SDCORD, T0.SDSHPN, T0.SDBCRC, T0.SDOPDJ, T0.SDKITID, T1.TPDOCO, T1.TPDCTO, T1.TPKCOO, T1.TPLNID, T1.TPOTDOMAIN, T1.TPOTBSHPN FROM ( ( DVDTA/F4211 T0 LEFT OUTER JOIN DVDTA/F49T211 T1 ON T0.SDKCOO = T1.TPKCOO AND T0.SDDOCO = T1.TPDOCO AND T0.SDDCTO = T1.TPDCTO AND T0.SDLNID = T1.TPLNID ) WHERE ( T0.SDDOCO = 8566239.000000 AND T0.SDDCTO = 'SE' AND T0.SDKCOO = '00002' AND T0.SDLNID = 1000.000000 )
The SQL generated has an extra parentheses after the FROM. The SQL is from a vanilla business view (V4211E) which is a SQL 92 left outer join. The error occurs on all applications/reports that use this view.
We have opened a call with Oracle, but have not gotten them to replicate the issue.
Any assistance would be great.
Thank you.
Heather
AS400 (VR6.1), E1 apps 9.0, tools 9.1.4.2