Uploading Data Using DB.XML Generates An ORA-00936 Error (Doc ID 1448608.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 6.2.4 and later   [Release: 6.2 and later ]
Information in this document applies to any platform.

Symptoms

When trying to upload a db.xml file, that has been exported from another system with the same version, the upload fails with the error :

DatabaseError error: ORA-00936: missing expression Failed sql statement: (update SAVED_QUERY set INSERT_USER = 'EP.ADMIN',UPDATE_DATE = '2011-12-01 13:22:10',SQL_FIND_ALL = 'select order_movement_gid from order_movement where order_release_gid = $GID and perspective = ''B'' order by order_movement_gid',UPDATE_USER = 'EP.ADMIN',INSERT_DATE = '2011-05-18 08:23:07',SAVED_QUERY_GID = 'EP.SHENKER_ALL_OM_ON_OR',USE_IN_FINDER = 'N',BIND_PARAM = ,DOMAIN_NAME = 'EP',SAVED_QUERY_XID = 'SHENKER_ALL_OM_ON_OR',QUERY_NAME = 'glog.server.query.order.OrderReleaseQuery',USER_QUERY_NAME = 'SHENKER_ALL_OM_ON_OR',IS_CONDITION = 'Y',IS_HIDDEN_FOR_MILESTONES = 'N',SQL_CHECK_ONE = 'select order_movement_gid from order_movement where order_release_gid = $GID and perspective = ''B'' order by order_movement_gid' where SAVED_QUERY_GID = 'EP.SHENKER_ALL_OM_ON_OR' ) Failed python exec: (c.execute("update SAVED_QUERY set INSERT_USER = 'EP.ADMIN',UPDATE_DATE = '2011-12-01 13:22:10',SQL_FIND_ALL = 'select order_movement_gid from order_movement where order_release_gid = $GID and perspective = ''B'' order by order_movement_gid',UPDATE_USER = 'EP.ADMIN',INSERT_DATE = '2011-05-18 08:23:07',SAVED_QUERY_GID = 'EP.SHENKER_ALL_OM_ON_OR',USE_IN_FINDER = 'N',BIND_PARAM = ,DOMAIN_NAME = 'EP',SAVED_QUERY_XID = 'SHENKER_ALL_OM_ON_OR',QUERY_NAME = 'glog.server.query.order.OrderReleaseQuery',USER_QUERY_NAME = 'SHENKER_ALL_OM_ON_OR',IS_CONDITION = 'Y',IS_HIDDEN_FOR_MILESTONES = 'N',SQL_CHECK_ONE = 'select order_movement_gid from order_movement where order_release_gid = $GID and perspective = ''B'' order by order_movement_gid' where SAVED_QUERY_GID = 'EP.SHENKER_ALL_OM_ON_OR' "))

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms