No announcement yet.

Issue 1 after Migration from 5.0 to 5.5 CU3+RU#01

  • Filter
  • Time
  • Show
Clear All
new posts

  • Issue 1 after Migration from 5.0 to 5.5 CU3+RU#01

    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
    at oracle.jdbc.ttc7.TTIoer.processError( 89)
    at oracle.jdbc.ttc7.Oall7.receive(
    at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol .java:1957)
    at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe (

    Note: - If you look at 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.