Oracle View import fails when correlation objects with type-2 dimension changes. Replacement SQL query is required as a remedy. Testing rev.
| Article:TECH55432 | | | Created: 2007-01-10 | | | Updated: 2007-01-28 | | | Article URL http://www.symantec.com/docs/TECH55432 |
Problem
Oracle View import fails when correlation objects with type-2 dimension changes. Replacement SQL query is required as a remedy. Testing rev.
Error
Error: ORA-01427: single-row subquery returns more than one row
ORA-06512: at "SAHARA_APP.CORRELATE_OBJECTS", line 64
ORA-06512: at "SAHARA_APP.CORRELATE_NODES_AND_OBJECTS", line 32
ORA-06512: at line 1 (DBD ERROR: OCIStmtExecute)
Solution
Oracle View import fails when correlation objects
with type-2 dimension changes.
Replacement SQL query is required as a remedy.
Rename and copy the attached file to the /opt/VRTSccer/erdb/scripts/ directory.
Download the attached file saharaImportExport_294007.sql and save it to a temporary directory.
This will be used to update the Import / Export views request.
Follow the steps below:
1) Download and save the saharaImportExport_294007.sql file into /tmp
2) Using the Solaris command mv
Replacement SQL query is required as a remedy.
Rename and copy the attached file to the /opt/VRTSccer/erdb/scripts/ directory.
Download the attached file saharaImportExport_294007.sql and save it to a temporary directory.
This will be used to update the Import / Export views request.
Follow the steps below:
1) Download and save the saharaImportExport_294007.sql file into /tmp
2) Using the Solaris command mv
a) rename
"saharaImportExport.sql" located in /opt/VRTSccer/erdb/scripts/ to
saharaImportExport.sql.org
3) using the Solaris command cp
a) copy
/tmp/saharaImportExport_294007.sql to the CCER database scripts directory
located in /opt/VRTSccer/erdb/scripts/ as saharaImportExport.sql
4) cd /opt/VRTSccer/bin/
5) . ./setenv.sh
5) . ./setenv.sh
Note: the preceding
period is required to source the environment
6) run 'sqlplus sys/password as sysdba @
/opt/VRTSccer/erdb/scripts/saharaImportExport.sql'
Note: Where password is
equal to the true password for user sys
Failure to enter the correct
password will result in an error. For example:
ERROR:
ORA-12546: TNS:permission
denied
Proper execution of the script will result in view import
functionality running as expected.
Attachments
|
|
| Source | ETrack |
| Value | 1136467 |
| Description | import fails when correlation objects with type-2 dimension changes |
Legacy ID
294007
Article URL http://www.symantec.com/docs/TECH55432
Terms of use for this information are found in Legal Notices
Thank you.