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
Article Type
Technical Solution


Environment

Issue



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
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
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

saharaImportExport_294007.sql (32 kBytes)

Supplemental Materials

SourceETrack
Value1136467
Descriptionimport 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