RRCLEANUP Doesn't Remove Orphan Records Of Foreign Key Constraint On Self Referential Table
(Doc ID 3023262.1)
Last updated on MAY 27, 2024
Applies to:
Siebel CRM - Version 24.1 and laterInformation in this document applies to any platform.
Symptoms
Repository export failed due to orphan records and running RRCleanup utility doesn't remove orphan records of foreign key constraint on self referential table
Repimexp.log shows the below error
2024-05-03 09:01:09 Data verification failed.
2024-05-03 09:01:09 Error in doExport (RtxNdVerify).
2024-05-03 09:01:09 Error in Main function.
2024-05-03 09:01:09 Data verification failed.
2024-05-03 09:01:09 Error in doExport (RtxNdVerify).
2024-05-03 09:01:09 Error in Main function.
The issue can be reproduced at will with the following steps:
1. Ran the below Command to export repository from development environment
D:\siebel\ses\siebsrvr\bin\repimexp.exe /a E /u SADMIN /p *** /c crmdev_DSN /d SIEBEL /r "Siebel Repository" /f D:\siebel\ses\dbsrvr\ORACLE\repository.dat /v Y /l D: \siebel\ses\dbsrvr\ORACLE\repository.log
2. It creates dat file with "Data verification failed" error due to many orphan records.
3. Ran the RRCleanup utility to delete the orphan using below comamnd , but still getting the same validation errors.
RRCleanup.exe -t SIEBEL -u SADMIN -p *** -o pfcrmdev_DSN -a Y -s D:\Siebel\ses\siebsrvr -b R -d Oracle
RRCleanup.exe -t SIEBEL -u SADMIN -p *** -o pfcrmdev_DSN -a Y -s D:\Siebel\ses\siebsrvr -b B -d Oracle
RRCleanup.exe -t SIEBEL -u SADMIN -p *** -o pfcrmdev_DSN -a Y -s D:\Siebel\ses\siebsrvr -b B -d Oracle
Changes
N/A
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |