My Oracle Support Banner

Empty Bind_Param In A DB XML Leads To Upload Failure (Doc ID 1448609.1)

Last updated on MAY 06, 2022

Applies to:

Oracle Transportation Management - Version 6.2.4 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 = '<VALUE1>',UPDATE_DATE = '<DATE TIME>',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 = '<VALUE1>',INSERT_DATE = '<DATE TIME>',SAVED_QUERY_GID = '<VALUE2>',USE_IN_FINDER = 'N',BIND_PARAM = ,DOMAIN_NAME = '<DOMAIN>',SAVED_QUERY_XID = '<VALUE2>',QUERY_NAME = 'glog.server.query.order.OrderReleaseQuery',USER_QUERY_NAME = '<VALUE2>',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 = '<VALUE2>' ) Failed python exec: (c.execute("update SAVED_QUERY set INSERT_USER = '<VALUE1>',UPDATE_DATE = '<DATE TIME>',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 = '<VALUE1>',INSERT_DATE = '<DATE TIME>',SAVED_QUERY_GID = '<VALUE2>',USE_IN_FINDER = 'N',BIND_PARAM = ,DOMAIN_NAME = '<DOMAIN>',SAVED_QUERY_XID = '<VALUE2>',QUERY_NAME = 'glog.server.query.order.OrderReleaseQuery',USER_QUERY_NAME = '<VALUE2>',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 = '<VALUE2>' "))

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.