Error Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P:OI2DL65P

Error:

OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P:OI2DL65P
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.


Solution:

[obiee@pan OBIS]$ pwd
/OBIEE/middleware/oracle/user_projects/domains/bi12/config/fmwconfig/biconfig/OBIS
[obiee@opera OBIS]$ ls -ltr
total 28
-rw-r----- 1 obiee dba 22401 Dec 26 11:06 NQSConfig.INI
-rw-r----- 1 obiee dba  1500 Dec 26 18:49 logconfig.xml
[obiee@pan OBIS]$ cp -rf NQSConfig.INI NQSConfig-org.INI
[obiee@pan OBIS]$ ls -ltr
total 52

Add below parameter.

[obiee@pan OBIS]$ ls
logconfig.xml  NQSConfig.INI  NQSConfig-org.INI
[obiee@opera OBIS]$ grep  EVALUATE_SUPPORT_LEVEL NQSConfig.INI
# EVALUATE_SUPPORT_LEVEL:
EVALUATE_SUPPORT_LEVEL = 2;
[obiee@pan OBIS]$

Restart BI services.

ORA-04063: Package Body APPS.FND_PROFILE Has Errors

Error:-


Cause: afpodbinit failed due to ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped package body "APPS.ICX_SEC"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.ICX_SEC"
ORA-06512: at "APPS.FND_PROFILE", l.


The SQL statement being executed at the time of the error was: begin fnd_global.bless_next_init('FND_PERMIT_0000'); fnd_global.initialize(:session_id, :user_id, :resp_id, :resp_appl_id, :security_group_id, :site_id, :login_id, :conc_login_id, :prog_appl_id, :conc_program_id, :conc_request_id, :conc_priority_request, :form_id, :form_application_id, :conc_process_id, :conc_queue_id, :queue_appl_id, :server_id); fnd_profile.put('ORG_ID', :org_id); fnd_profile.put('MFG_ORGANIZATION_ID', :mfg_org_id); fnd_profile.put('MFG_CHART_OF_ACCOUNTS_ID', :coa); fnd_profile.put('APPS_MAINTENANCE_MODE', :amm); end; and was executed from the file &ERRFILE.


Solution:-

SQL> alter package apps.ICX_SEC compile;

Package altered.

SQL> alter package apps.ICX_SEC compile body;

Package body altered.

SQL> show  error
No errors.
SQL> alter package apps.FND_PROFILE compile;

Package altered.

SQL> show error
No errors.
SQL> alter package apps.FND_PROFILE compile body;

Package body altered.

SQL> show error
No errors.
SQL> exit


Run Autoconfig at application.