AnsweredAssumed Answered

Error when copying process

Question asked by derrickat on Nov 20, 2014
Latest reply on Dec 5, 2014 by derrickat

We are receiving the following error in the DB when trying to copy a process using Save As. We've tried all three statuses of the process (Active, Draft, On Hold). The process is called as a subprocess by another process.


Here is the error:


Error Message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-22921: length of input buffer is smaller than amount requested

ORA-06512: at "NIKU.BPM_COPY_PROCESS_PKG", line 644


That package calls this insert statement:





id, script_text, language_code,

created_date, created_by, last_updated_date, last_updated_by )

VALUES (v_next_script_id

  , v_script_text

  , 'gel'

  , p_created_date

  , p_created_by

  , p_created_date

  , p_created_by);


It looks like it is the script_text field that is causing the issue, but it is a CLOB and should be plenty large enough to store the incoming value.


Any thoughts?