Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Exception during ksc_copy_request command

Highlighted

Exception during ksc_copy_request command

Hi All,

 

We have in our workflow a step to automatically create another request type and attach it to this request.

The Ksc_copy_request command was working fine.

 

Suddenly today, when go to that particular execution step, it throws exception as below.

 

Beginning command: KSC Copy Request
Running PL/SQL procedure KCRT_REQUEST_UTIL.COPY_REQUEST
Summary of parameters:
FROM_REQUEST_ID=66884
REQUEST_TYPE_ID=31500
WORKFLOW_ID=
COPY_FIELDS=Y
COPY_NOTES=Y
CREATE_REFERENCE=Y
REF_RELATIONSHIP_ID=15
STATUS_NAME=
SUBMIT=Y
PROCESS_RULE=Y
USER_ID=134391
VALIDATION_NAME=
Exception occured during execution: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "PPM.KCRT_REQUEST_UTIL", line 2342
ORA-06512: at line 1

 

 

Any idea on this? I saw similar thread, where they had a workaround of setting the COPY_FIELDS=N..but that again didnt help.

 

Thanks
Sakthi

2 REPLIES

Re: Exception during ksc_copy_request command

After trial-and-error, found that the exception is caught due to REFERENCE creation. When I set to N for create reference, it creates the request type. But what would be the reason for creating reference to throw the exception?

 

Thanks

Sakthi

Re: Exception during ksc_copy_request command

Found the cause for this problem. Its the data corruption at the references level (Knta_references).

 

Thanks
Sakthi.

//Add this to "OnDomLoad" event