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
