Tweet
Issues after Migration from 5.0 to 5.5 CU3+RU#01
1 -Creation of Shipment group fails.
Error Message: - java.sql.SQLException: ORA-00936: missing expression
Error Stacktrace: - java.sql.SQLException: ORA-00936: missing expression
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:2 89)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol .java:1957)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe (TTC7Protocol.java:88
Note: - If you look at glog.app.log file after you see this exception on UI (Please enable the SQL in your SYSTEM log to view this in the log), you would find the following SQL query being generated i.e. " SELECT con.contact_gid, con.location_gid, con.contact_gid, con.contact_xid FROM CONTACT con WHERE (con.is_primary_contact='Y') AND (con.location_gid IN ())". Here the value to con.location_gid in not being passed. I guess you should see '?' within the bracket for e.g. con.location_gid IN (?) which on runtime will get replaced with the actual value. An SR is already raised for this issue, will you update you once a resolved.
1 -Creation of Shipment group fails.
Error Message: - java.sql.SQLException: ORA-00936: missing expression
Error Stacktrace: - java.sql.SQLException: ORA-00936: missing expression
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:2 89)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol .java:1957)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe (TTC7Protocol.java:88
Note: - If you look at glog.app.log file after you see this exception on UI (Please enable the SQL in your SYSTEM log to view this in the log), you would find the following SQL query being generated i.e. " SELECT con.contact_gid, con.location_gid, con.contact_gid, con.contact_xid FROM CONTACT con WHERE (con.is_primary_contact='Y') AND (con.location_gid IN ())". Here the value to con.location_gid in not being passed. I guess you should see '?' within the bracket for e.g. con.location_gid IN (?) which on runtime will get replaced with the actual value. An SR is already raised for this issue, will you update you once a resolved.