For more information, please refer to this announcement explaining best practices for getting answers to questions.
Unique Constraint error while running TCC Export
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">
<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>