Pageviews

Saturday, October 29, 2016

Data AccessException: com.thortech.xl.orb.dataaccess.tcDataAccessException: DB_READ_FAILEDDetail: Description: ORA-00936: missing expression SQL State: 42000Vendor Code: 936Additional Debug Info:com.thortech.xl.orb.dataaccess.tcDataAccessException

Issue - 

Data AccessException:SQL State: 42000Vendor Code: 936Additional Debug Info:com.thortech.xl.orb.dataaccess.tcDataAccessException

com.thortech.xl.orb.dataaccess.tcDataAccessException: DB_READ_FAILEDDetail: SQL: = Description: ORA-00936: missing expression

Solution - 

Correct the Mapping of adapter variables in Process Task.

This issue is typically due to incorrect mapping of Columns in Process Task Adapter.

Mostly this issue occurs when Process task's Adapter Variable is mapped with wrong Column_Name/Table_Name required in Adapter. Check the Process Task Adapter Mapping and its literal value for Process Form - Column_Name/Table_Name. The column name and table name must be exactly same as provided in Process Form.

For example :

Child Table name = UD_SIEBEL_C
Child Table Column Name = UD_SIEBEL_C_USER_LOGIN

So your adapter mapping must contain same/exact value as provided in Process Form.

In my case I configured the wrong Child Process form column_name in my Process Task's Adapter mapping , which is required to update the Child Process Form's column value.

Let's say Instead of "UD_SIEBEL_C_USER_LOGIN", I configured it to UD_SIEBEL_C_U_LOGIN

No comments:

Post a Comment