You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Unique Constraint error while running TCC Export

edited Jul 3, 2017 11:33AM in Taleo Enterprise 5 comments

Content

Hello Folks,

While extracting New-Hire information from the Taleo system using the TCC script i'm facing Unique Constraint issue. 
Wondering if anyone else has also had similar problem so their insight can help! 

I have also come across a bug which talks about this - Bug 23140166.

*This error is encountered only when there are filters (Applications,CSWLatestStep,Name; Applications,CSWLatestStatus,Name) added to the export.

Error encountered:

[<Content xmlns="http://www.taleo.com/ws/integration/toolkit/2005/07"&gt;

  <ExportErrors>

    <Error>

      <Code>ServerError</Code>

      <Subcode>itk:ExportQueryExecutionError</Subcode>

      <Reason>An error occurred during the query execution: ORA-00001: unique constraint (S01CAESARS.W$AKSENO_PASS_NO_UI) violated</Reason>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!