Error: Error creating process control file; An unknown error occured while copying the control file. - When Account Data Upload (ADU)

Sometimes after an upgrade or refresh, when ADU is first run, the client will get the following error message:
“Error creating process control file; An unknown error occured while copying the control file.” 
 
This usually indicates an issue with the upload sequence.

This error occurs because ADU is trying to create a folder in the upload directory that already exists.

The sequence numbers on the new database may already exist in the upload directory, and the error happens when it tries to create an upload directory that already exists.

What you can do is update the sequence number:
   - When you know what the next sequence number should be, you will need to increment up to that number.

Here is an example: 
  • Find the last ADU that was run for the upload in question (BBS - 00048)
  • Look in  PL SQL Developer to find the sequence (Sequences folder)
  • Find the sequence: BBS_UPLOAD_ID_SEQ
  • Right-click on it, choose Edit
  • Set the "Next Number" field to the value that you want 
  • Press apply.

Environment

 RSR

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.