Problem Note 56010: "ERROR: A rename/delete/replace attempt is not allowed for a data set ... in a referential integrity constraint" occurs when you migrate a data store
When you migrate a data store to SAS® OpRisk VaR 6.1M1 under certain conditions, a recursive path reference can occur, which might result in the failure to migrate the data store. The conditions are as follows:
- The archive uses a folder instead of a ZIP file.
- The servers involved are running a UNIX operating system.
When this issue occurs, errors and warnings like the following might occur.
ERROR: A rename/delete/replace attempt is not allowed for a data set involved in
a referential integrity constraint. DESTDIR.DATA_VERSION.DATA
WARNING: Skipping data set due to error.
ERROR: A rename/delete/replace attempt is not allowed for a data set involved in
a referential integrity constraint. DESTDIR.DATA_VERSION_HIER.DATA
WARNING: Skipping data set due to error.
ERROR: An I/O error has occurred on file DESTDIR.PARALLEL_SERVERS.DATA.
ERROR: UNIX errno = 0.
ERROR: Data set DESTDIR.PARALLEL_SERVERS was not created/replaced due to errors.
Here is an example of a recursive path in the migration log:
WARNING: No logical assign for filename <filename>.
/opt/SAS/BACKUP/Archivio_DataStore/VaR_DS/migrationRoot_/migrationRoot/migration
Root/migrationRoot/migrationRoot/migrationRoot/migrationRoot/migrationRoot/migra
tionRoot/migrationRoot/migrationRoot/migrationRoot/migrationRoot/migrationRoot/m
igrationRoot/migrationRoot/migrationRoot/migrationRoot/migrationRoot/migrationRo
ot/migrationRoot/migrationRoot/migrationRoot/migrationRoot/migrationRoot/migrati
onRoot/migrationRoot/migrationRoot/migrationRoot/migrationRoot/migrationRoot/mig
rationRoot/migrationRoot/migrationRoot/migrationRoot/migrationRoot/migrationRoot
/migrationRoot/migrationRoot/migrationRoot/migrationRoot/migrationRoot/migration
Root/migrationRoot/migrationRoot/migrationRoot/migrationRoot/migrationRoot/migra
tionRoot/migrationRoot/migrationRoot/migrationRoot/migrationRoot/migrationRoot/m
igrationRoot/migrationRoot/migrationRoot/migrationRoot/migrationRoot/migrationRo
ot/migrationRoot/migrationRoot/migrationRoot/migrationRoot/migrationRoot/migrati
onRoot/migrationRoot/main/var_folders.sas7bdat
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS OpRisk VaR | 64-bit Enabled AIX | 6.1_M1 | 6.1_M2 | 9.4 TS1M2 | 9.4 TS1M3 |
64-bit Enabled Solaris | 6.1_M1 | 6.1_M2 | 9.4 TS1M2 | 9.4 TS1M3 |
HP-UX IPF | 6.1_M1 | 6.1_M2 | 9.4 TS1M2 | 9.4 TS1M3 |
Linux for x64 | 6.1_M1 | 6.1_M2 | 9.4 TS1M2 | 9.4 TS1M3 |
Solaris for x64 | 6.1_M1 | 6.1_M2 | 9.4 TS1M2 | 9.4 TS1M3 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Topic: | Analytics ==> Financial Analysis
|
Date Modified: | 2016-11-17 10:48:43 |
Date Created: | 2015-06-17 13:39:07 |