Concurrent Reports in Running Normal Forever status after 11.2.0.4 Database upgrade

      We observed that the Concurrent Reports in Running Normal Forever status after 11.2.0.4 Database upgrade, Below were the steps done to fix the issue.

1.We have run the below command as per metalink document  R12 : Concurrent Reports in Running Normal Forever (Doc ID 1337005.1) and was able to fix the issue
[appstest@test001]$ $INST_TOP/ora/10.1.2/bin/appsrwrun.sh userid=apps/xxx  mode=character report=$FND_TOP/reports/US/FNDSCURS.rdf batch=yes destype=file desname=./ddr2.out desformat=$FND_TOP/reports/HPL pagesize=132x66 traceopts=trace_all tracefile=ddr2.trc tracemode=trace_replace
2. The appsrwrun script was showing below error when we have checked the trace file ddr2.trc
[2016/3/7 3:30:59:794] Exception 54005 (): Unable to create cache directory /ebs/oracle/TEST/inst/apps/appstest@test001/logs/ora/10.1.2/reports/cache
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
        at oracle.reports.utility.Utility.newRWException(Utility.java:758)
        at oracle.reports.cache.RWCache.start(RWCache.java:70)
        at oracle.reports.server.RWServer.startServer(RWServer.java:801)
        at oracle.reports.server.RWServer.run(RWServer.java:293)
        at java.lang.Thread.run(Thread.java:534)
3. Cache file on server was missing which I have created and submitted the active users again which completed normally.
[appstest@test001]$ mkdir -p /ebs/oracle/TEST/inst/apps/TEST_test001/logs/ora/10.1.2/network

Comments

Post a Comment

Popular posts from this blog

Steps to run Autoconfig for patch File system 12.2

1.       To run Autoconfig from the patch file system you must disable trigger ebs_login prior to running autoconfig. SQL> show user; USER is "SYSTEM" SQL> alter trigger ebs_logon disable; Trigger altered. 2.       Now run autoconfig with the patch env sourced [appltest@test001]$ echo $FILE_EDITION [appltest@test001]$patch [appltest@test001]$ adautocfg.sh Make sure Autoconfig completes ok      3. Enable the login trigger “alter trigger ebs_logon enable”                  SQL> conn system/Oracle4u                  Connected.                SQL> SQL> alter trigger ebs_logon enable;                 Trigger altered.
Read more

txkCfgUtlfileDir.pl -mode=getUtlFileDir as per Cloning Oracle E-Business Suite Release 12.1 with Multitenant Database using Rapid Clone (Doc ID 2560690.1) errors with ERRORMSG: Invalid APPS database user credentials

 txkCfgUtlfileDir.pl -mode=getUtlFileDir as per Cloning Oracle E-Business Suite Release 12.1 with Multitenant Database using Rapid Clone (Doc ID 2560690.1) errors with ERRORMSG: Invalid APPS database user credentials validate_apps_password.log Pattern found... ================ EXIT STATUS: 1 Invalid APPS database user credentials. Solution Check  lsnrctl status <listener_name>,check files under $TNS_ADMIN,check environment,Check if case sensitive login is enabled and if enabled,disable it
Read more

ADOP fs_clone failing with ERROR: Managed Server's are not in sync between file system context and DB context

 adop fs_clone failing with below error. +++++++++++++++++++++++++ configProperty id = Server11 Count for NodeIterator nextNode = 3 ERROR: Managed Server's are not in sync between file system context and DB context ERROR: Update Moveplan Fail START: Inside exitClone.... Updating status INCOMPLETE for ApplywlsTechStack START: Updating status INCOMPLETE for action ApplywlsTechStack END: Updated status INCOMPLETE for action ApplywlsTechStack SOLUTION Please follow the solution in  Doc ID 2232990.1  and advise accordingly To resolve the issue test the following steps in a development instance and then migrate accordingly: 1. Unlock the configuration in the weblogic console via the following steps: A. Open a browser and enter the weblogic console URL eg: https ://localhost:port/console as the administrator. B. Navigate to the weblogic server administration Applications Configuration console. C. Unlock the weblogic server configuration by clicking 'Release Configuration' option.
Read more