Category Archives: MFGP - Page 2

AutoConfig could not successfully execute adgendbc.cmd

Problem: When running AutoConfig on the application tier, the following error occurs:

  -     90% completed
ERROR while running Apply...

Checked D:\ORACLE\PROD\inst\apps\PROD_testsrv2\admin\log\09061401\adconfig.log:
  [SETUP PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: D:\ORACLE\PROD\inst\apps\PROD_testsrv2\admin\install
      adgendbc.cmd            INSTE8_SETUP       1

Possible solution: Disable JAVA_JIT_ENABLED

SQL> show parameter jit

NAME                                 TYPE        VALUE
------------------------------------ ----------- ----------------
java_jit_enabled                     boolean     TRUE

SQL> alter system set JAVA_JIT_ENABLED=FALSE scope=both;

System altered.

SQL>

Reference: Adgendbc Fails With Database Connection Failure (Doc ID 1302708.1)

Perl lib version (5.10.0) doesn’t match executable version (v5.8.5)

Problem: When running adcfgclone, the following error occurs:

Complete port information available at D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\out\PROD_testsrv2\portpool.lst

Creating the new Database Context file from :
  D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\template\adxdbctx.tmp

The new database context file has been created :
  D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\PROD_testsrv2.xml

Log file located at D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\CloneContext_0906103441.log
Check Clone Context logfile D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\CloneContext_0906103441.log for details.

Running Rapid Clone with command:
perl D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\adclone.pl java=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\..\jre mode=apply stage=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone component=dbTier method=CUSTOM dbctxtg=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\PROD_testsrv2.xml showProgress contextValidated=true
Running:
perl D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\adclone.pl java=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\..\jre mode=apply stage=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone component=dbTier method=CUSTOM dbctxtg=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\PROD_testsrv2.xml showProgress contextValidated=true
Perl lib version (5.10.0) doesn't match executable version (v5.8.5) at d:/ORACLE/PROD/db/tech_st/11.2.0/perl/lib/Config.pm line 46.
Compilation failed in require at D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone
\bin\adclone.pl line 34.
BEGIN failed--compilation aborted at D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\adclone.pl line 34.

 ERROR: Failed to execute D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\adclone.pl

 Please check logfile.



Solution: May need to set PERL5LIB before running adcfgclone.

set PERL5LIB=D:\ORACLE\PROD\db\tech_st\11.2.0\perl\lib\5.10.0;D:\ORACLE\PROD\db\tech_st\11.2.0\perl\site_perl\5.10.0;D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\perl
cd /d D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin
d:\ORACLE\PROD\db\tech_st\11.2.0\perl\bin\perl.exe adcfgclone.pl dbTier

RC-20011: Fatal: Failed to Retrieve OS name

Problem: When running adcfgclone on Windows 2008, the following error occurs:

D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin>d:\ORACLE\PROD\db\tech_st\11.2.0\perl\bin\perl.exe adcfgclone.pl dbTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.31.12010000.8

Enter the APPS password : apps


Running:
D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\..\jre\bin\java.exe -Xmx600M
 -cp D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\jlib\java;D:\ORACLE\PROD\db
\tech_st\11.2.0\appsutil\clone\jlib\xmlparserv2.jar;D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\jlib\ojdbc5.jar oracle.apps.ad.context.CloneContext -e D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\..\context\db\CTXORIG.xml -validate -pairsfile C:\Users\ADMINI~1\AppData\Local\Temp\1\adpairsfile_4724.lst -stage
 D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone  2> C:\Users\ADMINI~1\AppData\Local\Temp\1\adcfgclone_4724.err && echo %ERRORLEVEL% > C:\Users\ADMINI~1\AppData\Local\Temp\1\adcfgclone_4724.res
RC-20011: Fatal: Failed to retrieve OS name. The following OS string returned from System.getProperty("os.name") is unknown: Windows Server 2008 R2
Can't open Exception in thread "main" java.lang.ExceptionInInitializerError:
Invalid argument

D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin>

Solution: Apply patch 11071569 on source system, then copy to target system. Then rerun adcfgclone.

Reference: How to Overcome Windows 2008 Being Unrecognised by AutoConfig and rapid Clone? (Doc ID 1270782.

 

 

FAILED: File FNDGFU.exe While Running Patch 9239095

Problem: While running patch 9239095, the following error occurs:

Assigned: file FNDGFU.exe   on worker  1 for product fnd username APPLSYS.

   FAILED: file FNDGFU.exe   on worker  1 for product fnd username APPLSYS.

 Deferred: file FNDGFU.exe   on worker  1 for product fnd username APPLSYS.

          (Deferment number 1 for this job)

Checked D:\ORACLE\MFGPR12\apps\apps_st\appl\admin\MFGP\log\ adwork001.log

ORA-01653: unable to extend table APPLSYS.FND_LOBS by 16 in tablespace APPS_TS_MEDIA

D:\oracle\MFGPR12\apps\apps_st\appl\fa\12.0.0\help\US\FA00019109.htm: upload failed

 

AD Worker error:

The above program failed with error code 1.

See the AD Worker log file and/or the program log file for details.

 Solution: Add datafile to APPS_TS_MEDIA tablespace:

select tablespace_name, file_name, bytes/1024/1024 from dba_data_files 
where tablespace_name = 'APPS_TS_MEDIA';

alter tablespace apps_ts_media add datafile 
'D:\ORACLE\MFGP\MFGPDB\ORADATA\MFGP\A_MEDIA02.DBF' size 1200M;

 

ORA-20011: Approximate NDV failed: ORA-00600: internal error code Running adstats.sql

Problem:While running adstats.sql, the following error occurs:

--------------------------------------------------
--- adstats.sql started at 2013-09-03 14:08:43 ---


Checking for the DB version and collecting statistics ...

declare
*
ERROR at line 1:
ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments:
[1350], [1], [23], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_STATS", line 24889
ORA-06512: at "SYS.DBMS_STATS", line 25430
ORA-06512: at line 3
ORA-06512: at line 33


Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – Production 
With the Partitioning, OLAP, Data Mining and Real Application Testing options

D:\ORACLE\MFGPR12\db\tech_st\11.2.0> 

Solution: Bounce database, then retry script.

Note: Make sure that you have at least 1.5 GB of free default temporary tablespace.

Problem: While running adbldxml.pl, the following error occurs:

D:\ORACLE\PRODR12\db\tech_st\11.2.0>perl D:\ORACLE\PRODR12\db\tech_st\11.2.0\appsutil\bin\adbldxml.pl

Starting context file generation for db tier..

D:ORACLEPRODR12dbtech_st11.2.0binsqlplus.exe: not found

D:ORACLEPRODR12dbtech_st11.2.0bintnsping.exe: not found

ERROR: while running command : D:\ORACLE\PRODR12\db\tech_st\11.2.0\bin\tnsping.exe

Failed to execute the specified command.

Verify that the command can be executed from the command prompt.

Solution: Use perl located in %ORACLE_HOME%\perl\bin. Do not use perl bundled with MKS Toolkit.

e.g. D:\ORACLE\PRODR12\db\tech_st\11.2.0\perl\bin\perl D:\ORACLE\PRODR12\db\tech_st\11.2.0\appsutil\bin\adbldxml.pl

RC-20200: Fatal: Could not find Unzip

Problem: While running admkappsutil.pl, the following error occurs:

D:\ORACLE\PRODR12\apps\apps_st\appl>perl D:\ORACLE\PRODR12\apps\apps_st\appl\ad\12.0.0\bin\admkappsutil.pl
Starting the generation of appsutil.zip

Log file located at D:\oracle\PRODR12\inst\apps\PROD_vasusrv\admin\log\MakeAppsUtil_09031037.log
output located at D:\oracle\PRODR12\inst\apps\PROD_vasusrv\admin\out\appsutil.zip

RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.

Please make sure you have UnZip 5.X in your path and try again...
MakeAppsUtil completed with errors, Please check logfile for more information.

Solution: Download unzip for your platform from Info-Zip (http://www.info-zip.org). For Windows 2003, download unz552xn.exe). For Windows 2008 64-bit, download the 64-bit version (unz552xn-x64.exe). Or see the readme: ftp://ftp.info-zip.org/pub/infozip/win32/readme

ftp://ftp.info-zip.org/pub/infozip/win32/

 

FAILED: File czhist.sql While Running Patch 6678700

Problem: While running patch 6678700, the following error occurs:

FAILED: file czhist.sql   on worker  1.

Solution: Execute the following commands:

sqlplus / as sysdba 
EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE('APPLSYS','FND_STATTAB');

Then retest issue (use adctrl option 2 restart failed worker)

Reference: Script Czhist.Sql Fails During Application Of Patch 6678700 (Doc ID 1281478.1)

FAILED: File fem_bal_nacc_hier_l2_mv.xdf While Running Patch 6678700

Problem: While running patch 6678700, the following error occurs:

FAILED: file fem_bal_nacc_hier_l2_mv.xdf on worker  1.

Solution: Use adctrl hidden option ‘8’ to skip the failed worker and complete the upgrade. Then, apply patch 10406817  “ORA-54015 APPLYING FEM_BAL_NACC_HIER_L2_MV.XDF ON ORACLE 11GR2 DATABASE” after the upgrade.

Reference: Patch Fails on Fem_bal_nacc_hier_l2_mv.xdf After Upgrade to Oracle 11.2.0.2 Database (Doc ID 1284055.1)

 

FAILED: File apaphuhf.sql While Running Patch 6678700

Problem: While running patch 6678700, the following error occurs:

ATTENTION: All workers either have failed or are waiting:

           FAILED: file apaphuhf.sql on worker  2.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Checking the worker log file showed:

sqlplus -s APPS/***** @D:\oracle\MFGP\apps\apps_st\appl\ap\12.0.0\patch\115\sql\

apaphuhf.sql &un_ap &batchsize 2 2

Error:
Program exited with status 1

Cause: The program terminated, returning status code 1.

Action: Check your installation manual for the meaning of this code on this 
operating system.

DECLARE
*
ERROR at line 1:
ORA-00001: unique constraint (AP.AP_PAYMENT_HISTORY_U2) violated
ORA-06512: at line 55

Solution: There is a duplicate value in the “REV_PMT_HIST_ID” column in the AP_PAYMENT_HISTORY_U2. Locate the duplicate value and set it to null.