When I am testing my Task by clicking the Pause button I got
the error saying that "An error has occurred
while pausing the current task. (SBL-BPR-00527)" . I got this error
only for one my main Task and not for all other sub Tasks. I tried to compare
all of them and I seen only the difference is number of steps in my main Task.
I reviewd the log file generated and also seen an error on pausing the Task "Value too long for field 'Long Value'
(maximum size 16350). (SBL-DAT-00235)".
I tested by removing some of the task view and sub task steps
and then tried, surprisingly this time I didn’t faced any issue with pausing
the Task.
Based on analysing the log file and testing by reducing the
number of Task steps I understand that The
issue behind this error is when the application tries to write a new record in
the "Workflow InstanceEx Props Helper" business component "Long
Value" field and it mapped to LONG_VAL column in S_WFA_INST_PROP table.
The type of this column in this Table is Long and the length 0, this
means siebel is store max string length of 16,383 characters.
I have modified the Data type of the field ‘Long Value’ in
the BC from ‘DTYPE_NOTE’ to ‘DTYPE_CLOB’ as suggested by oracle support then
this issue got fixed.
Cheers,
Prakash
