Thursday, April 9, 2020

Autoconfig error:ORA-06512: at "APPS.AD_ZD_ADOP"

WARNING: [AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.

AutoConfig could not successfully execute the following scripts:
Directory: /test/applmgr/fs2/FMW_Home/webtier/perl/bin/perl -I
/test/applmgr/fs2/FMW_Home/webtier/perl/lib/5.10.0 -I
/test/applmgr/fs2/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I
/test/applmgr/fs2/EBSapps/appl/au/12.0.0/perl -I
/test/applmgr/fs2/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi
/test/inst/fs2/inst/apps/TEST_test01/admin/install
txkGenADOPWrapper.pl    INSTE8_APPLY       1
AutoConfig is exiting with status 1
AutoConfig execution completed on Mon Jan 28 14:43:46 2019
Time taken for AutoConfig execution to complete : 2 mins  8 secs

SQL> SQL> Connected.
SQL> SELECT ad_zd_adop.get_node_type('test01') FROM DUAL
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.AD_ZD_ADOP", line 3062
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
STACK TRACE
at /test/applmgr/fs2/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168

TXK::TechstackDB::getSQLValue('TXK::TechstackDB=HASH(0x281ba90)', 'SELECT
ad_zd_adop.get_node_type(\'test01\') FROM DUAL') called at
/test/inst/fs2/inst/apps/TEST_test01/admin/install/txkGenADOPWrapper.pl line 506

main::getNodeType() called at
/test/inst/fs2/inst/apps/TEST_test01/admin/install/txkGenADOPWrapper.pl line 202

eval {...} called at
/test/inst/fs2/inst/apps/TEST_test01/admin/install/txkGenADOPWrapper.pl line 143
)
ERRORCODE = 1 ERRORCODE_END
.end std out.
.end err out.
****************************************************


Solution
========

As per Mos Document id#2212698.1,  Please Disable the "s_web_admin_status" parameter on
the application context file and rerun the autoconfig.



[aptest@test01 <RUN> ]pwd
/test/inst/fs2/inst/apps/TEST_test01/appl/admin
[aptest@test01 <RUN> ]grep -i s_web_admin_status TEST_test01.xml
<oa_service_group_status
oa_var="s_web_admin_status">enabled</oa_service_group_status>
[aptest@test01 <RUN> ]$


[aptest@test01 <RUN> ]pwd
/test/inst/fs2/inst/apps/TEST_test01/appl/admin
[aptest@test01 <RUN> ]diff TEST_test01.xml_bkpsri TEST_test01.xml

1011c1011

<             <oa_service_group_status
oa_var="s_web_admin_status">enabled</oa_service_group_status>
---

>             <oa_service_group_status
oa_var="s_web_admin_status">disabled</oa_service_group_status>

[aptest@test01 <RUN> ]$


Autoconfig success

No comments:

Post a Comment

[ERROR]: The value of s_patch_service_name is not set correctly in atleast one of the context files.

[ERROR]: The value of s_patch_service_name is not set correctly in atleast one of the context files. I got the issue below wh...