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:

 

 

INSERT

INTO CMN_CUSTOM_SCRIPTS (

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?

 

Thanks.

Outcomes