Oracle View import fails when correlation objects with type-2 dimension changes. Replacement SQL query is required as a remedy. Testing rev.

Problem

Oracle View import fails when correlation objects with type-2 dimension changes. Replacement SQL query is required as a remedy. Testing rev.

Error Message

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.




Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)