SQL Error after Upgrading to Tools 9.1.4.2

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

Heather,

Is it possible that the view (V4211E) is corrupt? Have you tried (backing it up) deleting it and rebuilding it?

Warning: <font color="red"> deleting would be a last resort as you will probably have to reconnect the view everywhere it is used. </font>

--------------------
Thanks, Peter

"Give a person a fish, feed them for a day, teach them how to fish, feed them for a lifetime."

E9.1 TR9.1.2.1, Enterprise Server: Sun, Database Server: Sun, Oracle DB: 11g, Weblogic.
Create!form 7

Deleting may not be a good idea ...
JDE Objects are identified not just by object name, but also but unique identifiers. For instance the SIAPPLID for V4211E is 66490.

Have you done this before with success on a standard JDE View Object?

Larry,

You do have a valid point. I have not done that with any standard JDE object, but I have done it with custom objects. Your post reminded me that I think I had to re-connect the rebuilt object where it was used.