Toad World® Forums

Code tester : Error in Install or Upgrade repository


#1

Code Tester encountered one or more problems attempting to install,
upgrade or remove the backend. The details are listed below.
If you do not think that the problem is caused by some aspect
of your own environment (no privileges on tablespace, would
be one such cause), please click on the button above to send
support the error report.

Invalid objects

NONE

Problems with installation of necessary data

QU_VERIFY.VERIFY_INSTALL failed
ORA-04045: errors during recompilation/revalidation of APPS.QU_CONFIG
ORA-01775: looping chain of synonyms
ORA-06508: PL/SQL: could not find program unit being called: “APPS.QU_CONFIG”
ORA-06512: at “APPS.QU_VERIFY”, line 3723
ORA-06512: at “APPS.QU_VERIFY”, line 3740
ORA-06512: at “APPS.QU_VERIFY”, line 3952
ORA-06512: at line 4

Install environment

Oracle Version:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE 12.1.0.2.0 Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production

Windows Version:
Windows 10 (Version 10.0, Build 0, 64-bit Edition)

Task body

@C:\Program Files\Quest Software\Toad for Oracle 2017 R2 Edition\Code Tester for Oracle 3.2\Code\qu_uninstall
@C:\Program Files\Quest Software\Toad for Oracle 2017 R2 Edition\Code Tester for Oracle 3.2\Code\qu_install
@C:\Program Files\Quest Software\Toad for Oracle 2017 R2 Edition\Code Tester for Oracle 3.2\Code\qu_uninstall_synonyms
@C:\Program Files\Quest Software\Toad for Oracle 2017 R2 Edition\Code Tester for Oracle 3.2\Code\qu_access
REM <guiaction>qu_verify_synonyms</guiaction><guimessage>Non existing public synonyms</guimessage>


#2

hey, did you find a solution to this problem ?


#3

Hi Safraz,

Such problem need the further investigation because of it is directly connected to the actual database setup. The ORA-01775 indicates we should start with investigation of all the objects with such name including synonyms in all schemas and especially all the versions of such object if we are using the Oracle Based Redefinition feature optionally. Such information help us identify why we can’t create or replace public synonym for this object.

Regards,

Viťa


#4

Hi Drabek,

Appreciate your prompt response. QU_CONFIG body is encrypted. All i could get about the errors was

Body 181 17 PLS-00905: object APPS.QU_TEST_CASE_XP is invalid
Body 193 17 PLS-00905: object APPS.QU_TEST_CASE_XP is invalid
Body 662 29 PLS-00905: object APPS.QU_TEST_ELEMENT_XP is invalid
Body 663 35 PLS-00905: object APPS.QU_TEST_CASE_XP is invalid
Body 664 31 PLS-00905: object APPS.QU_HARNESS_XP is invalid
Body 665 35 PLS-00905: object APPS.QU_OUTCOME_XP is invalid
Body 667 30 PLS-00905: object APPS.QU_TEST_ELEMENT_XP is invalid
Body 1804 32 PLS-00905: object APPS.QU_GENERATE is invalid