COBOL batch programs not running

Problem:

After installing PeopleSoft Financials, the COBOL batch programs not running.

Solution:

1. Download Micro Focus Cobol Net Express Edition from:

http://www.download.com/Net-Express-with-NET/3000-2069_4-10866201.html
http://microfocus.com/products/netexpress/
http://microfocus.com/products/netexpresswithnet/index.asp

2. Install Micro Focus Cobol Net Express With .Net on the batch server. Disable the option to install .Net, as it will require Microsoft Visual Studio 2008.

Post-install checks fail after installing

Problem:

After installing Oracle Applications E-Business Suite 11.5.10.2 on Windows, the post installation checks (HTTP Check, JSP Check, PHP Check) fail.

Solution:

Install Microsoft XML (msxml3.msi) located in downloadsXML.

Could not start Service Manager

Problem:

Concurrent manager not starting on ebusinesstest. Checked Metalink Doc ID:  Note:104452.1 (Subject:  Troubleshooting Concurrent Manager (Unix specific). Changed to /u0/oracle/testcomn/admin/log/TEST_ebusinesstest ($APPLCSF/$APPLLOG) and check last .mgr file (TEST_0424.mgr). It showed the following error message:

Starting PASMGR Concurrent Manager                 : 24-APR-2009 12:29:17
Spawned Process 18408
Could not start Service Manager FNDSM_EBUSINESSTEST_TEST. The TNS alias could not be located, the listener process on EBUSINESSTEST could not be contacted, or the listener failed to spawn the Service Manager process.
Routine AFPEIM encountered an error while starting concurrent manager PASMGR with library /u0/oracle/testappl/pa/11.5.0/bin/PALIBR.
Check that your system has enough resources to start a concurrent manager process. Contact your system admi : 24-APR-2009 12:29:17
                     Process monitor session ended : 24-APR-2009 12:29:17

Solution:

Checked Metalink for message ‘Could not start Service Manager’. Checked Metalink Doc ID:  423170.1 (Subject:  Concurrent Manager Fails to Start Because of a ‘Could not start Service Manager FNDSM__’ Error)

To implement the solution, please execute the following steps:

1. Download and apply patch 3830807: ” PATCH 3293983 NEEDS TO INCLUDE ALL THE MAKEFILES UNDER THE 8.0.6 ORACLE_HOME”.

2. Launch adadmin and choose the task to relink all product executables.

3. Startup the Concurrent Manager.

The Concurrent Manager should start without any errors. There should be no errors in the 8.0.6 listener log file.

AC-50480: Internal error occurred: java.sql.SQLException: ORA-00001: unique constraint (APPLSYS.FND_TNS_ALIASES_U2) violated

Problem:

When running AutoConfig on database tier, the follow error appears in the log file:

=======================================================
[ Config tool : /u0/oracle/testdb/9.2.0/appsutil/bin/adgentns.pl ]
   Command            : /u0/oracle/testdb/9.2.0/Apache/perl/bin/perl -I /u0/oracle/testdb/9.2.0/Apache/perl/lib/5.00503:/u0/oracle/testdb/9.2.0/Apache/perl/lib/site_perl/5.005:/u0/oracle/testdb/9.2.0/appsutil/perl  /u0/oracle/testdb/9.2.0/appsutil/bin/adgentns.pl PASSWORD  contextfile=/u0/oracle/testdb/9.2.0/appsutil/TEST_ebusinesstest.xml
   Action             : execute
SCRIPT RETURNED:
#######################################################
                   Generate Tns Names
#######################################################
    Using java command: /u0/oracle/testdb/9.2.0/jdk/bin/java
    JAVA_HOME         :
    Java version      : 1.3.1_11
    Classpath         : /u0/oracle/testdb/9.2.0/jdk/jre/lib/rt.jar:/u0/oracle/testdb/9.2.0/jdk/jre/lib/i18n.jar:/u0/oracle/testdb/9.2.0/jdk/lib/dt.jar:/u0/oracle/testdb/9.2.0/jdk/lib/tools.jar:/u0/oracle/testdb/9.2.0/jdbc/lib/classes12.jar:/u0/oracle/testdb/9.2.0/appsutil/java/xmlparserv2.zip:/u0/oracle/testdb/9.2.0/appsutil/java
Loading ORACLE_HOME environment from /u0/oracle/testdb/9.2.0
Logfile: /u0/oracle/testdb/9.2.0/appsutil/log/TEST_ebusinesstest/04061541/NetServiceHandler.log
AC-50480: Internal error occurred: java.sql.SQLException: ORA-00001: unique constraint (APPLSYS.FND_TNS_ALIASES_U2) violated
ORA-06512: at "APPS.FND_APP_SYSTEM", line 931
ORA-06512: at "APPS.FND_NET_SERVICES", line 399
ORA-06512: at "APPS.FND_NET_SERVICES", line 675
ORA-06512: at "APPS.FND_NET_SERVICES", line 1097
ORA-06512: at line 1
Error generating tnsnames.ora from the database, temperory tnsnames.ora will be generated using templates
Instantiating templates
tnsnames.ora instantiated
listener.ora instantiated
adgentns.pl exiting with status 2
ERRORCODE = 2 ERRORCODE_END

Solution:

To implement the solution, please execute the following steps:

1. Be sure to have a valid backup.

2. Open an environment shell and set the Applications Environment

3. cd $AD_TOP/bin

4. perl <AD_TOP>/bin/adgentns.pl appspass=<APPSpwd> contextfile=<CONTEXT> -removesystem

5. Open a new shell and set the Database Environment

6. Run adconfig at the dbTier

7. Open a new shell and set the Applications Environment and also run autoconfig at the appsTier

Subject:  Autoconfig Fails with:ORA-00001: unique constraint (APPLSYS.FND_TNS_ALIASES_U2) violated

Doc ID:  416182.1

CopyUpdateProject fails

Problem:

In Change Assistant, the CopyUpdateProject step fails:

Step Failed at: Copy Update Project

Contents of E:tempsoftwareupdateFSCM900_MP5{bb2f249c-b59c-11dd-aaa1-aa1d90f67f05}FSCM900_MP5.log:

PeopleSoft Project Command Line
Copy From File
Project Name: FSCM900_MP5
Tools Release: 8.49.15
2008-12-08 : 10.55.54

-CT Source Database Type = MICROSFT
-CS Source Database Server =
-CD Source Database Name = FSDMO
-CO Source Database Operator = VP1
-FP File Path = E:/staging/softwareupdateFSCM900_MP5{bb2f249c-b59c-11dd-aaa1-aa1d90f67f05}
-CL Commit Limit = 100
-AF Keep Target Audit Flags = 1
-DDL Keep Target DDL = 1
-CFD Keep Target Chartfield PageField Display Size = 1
-CFF Keep Target Chartfield DbField Format = 1
-PPL Keep Target Portal Structure Permission List = 1
-OBJ Object Types = All
-LNG Languages = ENG,COMMON

Project FSCM900_MP5 already exists, continuing processing, switch set to overwrite.
Transforming XML. Please be patient.
Processing Language : English
Processing Language : COMMON

Records Application Upgrade Copy started: 2008-12-08-10.58.38

Contents of E:tempsoftwareupdateFSCM900_MP5{bb2f249c-b59c-11dd-aaa1-aa1d90f67f05}FSCM900_MP5_CA.log

Command Line: E:PSOFTFS900binclientwinx86pside.exe -CT MICROSFT -CS -CD FSDMO -CO VP1 -CP * -PJFF FSCM900_MP5 -FP E:/staging/softwareupdateFSCM900_MP5{bb2f249c-b59c-11dd-aaa1-aa1d90f67f05} -LF E:tempsoftwareupdateFSCM900_MP5{bb2f249c-b59c-11dd-aaa1-aa1d90f67f05}FSCM900_MP5.log -CL 100 -AF 1 -DDL 1 -OBJ All -LNG ENG,COMMON -PPL 1 -CFD 1 -CFF 1 -HIDE -QUIET -SS NO -SN NO

Solution:

1. Batch server was running. Stopped batch server and restarted the CopyUpdateProject step.
2. Batch server started, and then restarted the CopyUpdateProject step.
3. Application server was running, stopped it and then restarted the CopyUpdateProject step.

(Advised by consultant) Skipped this step as it was previously deployed under IBM WebSphere.

AC-50207: Fatal: Failed to execute one or more of the config tools during Context Value Management

Problem:

When running AutoConfig on application tier:

AC-50207: Fatal: Failed to execute one or more of the config tools during Context Value Management
Deactivating Context Value Management System.
Restored the Context file in :
        /u0/oracle/testappl/admin/TEST_ebusinesstest.xml
Aborting the running of Context Value Management
Error occured before Context Value Management could be completed
ERROR: Context Value Management Failed.
Terminate.

Solution:

LD_ASSUME_KERNEL not set.

export LD_ASSUME_KERNEL=2.4.19

Error updating master archive

Problem:

When applying patch 4104924, the following error appears:

AutoPatch error:
ERROR
[code language="1"][/code]
[/code]
 Running adjopy.class
AutoPatch error:
Error updating master archive

Solution:

LD_ASSUME_KERNEL not set

export LD_ASSUME_KERNEL=2.4.19

Unable to initialize threads

Problem:

Running adstpall.sh returns the following error:
[applmgr@ebusinesstest TEST_ebusinesstest]$ ./adstpall.sh apps/apps
You are running adstpall.sh version 115.17
/u0/oracle/testcomn/util/jre/1.1.8/bin/../lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so)
Unable to initialize threads: cannot find class java/lang/Thread
Could not create Java VM
Check logfile /u0/oracle/testcomn/admin/log/TEST_ebusinesstest/04061425.log for details
Exiting with status 1
[applmgr@ebusinesstest TEST_ebusinesstest]$

Solution:

Subject:        GLIBC_2.0 not defined in file libc.so.6

Note:275161.1

export LD_ASSUME_KERNEL=2.4.19

Cannot complete applications logon

Problem:

Cannot complete applications logon.  You may have entered an invalid applications password, or there may have been a database connect error.

Solution:

Use Metalink Doc ID: 153053.1 to reset the SYSADMIN password to WELCOME.

Internal Server Error

Problem:

Internal Server Error when trying to log in to Oracle Applications

Solution:

Ran out of tablespace. Checked alert log to tablespaces to extend.