Empty Bind_Param In A DB XML Leads To Upload Failure (Doc ID 1448609.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

1. When trying to upload a db.xml file, that has a missing Bind_Parm, 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' "))

When removing/populating data in the bind_param field on the xml, the error does not occur and the transmission is 'successful', but the data is not inserted into the db.

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