use WebAdi to upload Journals :the connection to the server is unavailable, Please contact your support representative

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

On 11.5.10.2 When attempting to use WebAdi to upload Journals,

the following error occurs:

ERROR
-----------------------
"The connection to the server is unavailable, Please contact your support representative"


Due to this issue, Unable to upload the data for one month

Solution:

1.Follow up the instructions for applying patch 5711361 in a Test instance first.

This patch inluded in
Applications Technology 11i.ATG_PF.H.delta.6 (patch 5903765)
Applications Technology 11i.ATG_PF.H.delta.5 (patch 5473858)

2.Assign responsibility Desktop Integration Responsibility for users work on WebADi
You can refer to note 287080.1


3.Retest your issue

4.Migrate solution as appropriate

Get Oracle Certifications for all Exams
Free Online Exams.com

Rapidwiz is failing with error 'Unable to validate apps user/group

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:

When attempting to perform a Multi - Node Install of the E-Bsuiness Suite Release 12.1.1 , the Rapidwizard is failing for the DB-Tier with error :

...
Unable to validate apps user/group applmgr/dba Provide a valid apps user/group for the installation
...

Explanation:






Rapidwiz is validating the Username of the APPS-Tier on the DB-Tier Server, although the APPS-Tier Server resides on a different node. The APPLMGR User is created with a valid Username and belonging to the correct group on the APPS-Tier Server.

Example :
Server 1 = DB-Tier Node : username oracle group dba
Server 2 = APPS-Tier Node : username applmgr group dba

Solution:

Solution

To get this failure fixed, please implement following Workaround :

1.) Create a new User with the name 'applmgr' on DB node.

2.) Add the new User 'applmgr' to the group 'dba'.

3.) Start the Rapidwizard for the Multi-Node-Installation again.

Get Oracle Certifications for all Exams
Free Online Exams.com

RC-20200 Fatal: Could Not Find Unzip

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:


While installing Oracle apps R12, the below error occur:




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

Solution

To resolve this error, ensure that the version of the "unzip" utility is equal or greater than "5.5.2" and less than version "6.0" (but not equal to "6.0").

Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-01578: ORACLE data block corrupted on a Dictionary Table

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem Description: ORA-01578: ORACLE data block corrupted  

We got the corruption on “trigger$” table in system tablespace,

 dbv found one block got corrupted.
 database got crashed and unable to start.
trigger$ table got corrupted,we used _system_enabled_trigger=false

 We can use hidden parameter _system_enabled_trigger=False and restarted the database.

Alert log file:

Mon Apr 27 15:06:01 2009
Errors in file /bdump/sid_ora_19549.trc:
ORA-12012: error on auto execute of job 7382
ORA-01578: ORACLE data block corrupted (file # 3, block # 91063)
ORA-01110: data file 3: '/system03.dbf'
Mon Apr 27 15:07:02 2009
MMON: terminating instance due to error 472
Instance terminated by MMON, pid = 7586

Solution:

When a dictionary table is corrupted the only valid option is restoring and recovering from a backup besides there is no way to recreate the dictionary

Can’t use DBMS_REPAIR against dictionary tables

Information at dictionary level cannot be ignored. It could cause other issues. Using DBMS_REPAIR against dictionary tables causes logical dictionary corruption

Get Oracle Certifications for all Exams
Free Online Exams.com

FAILED: file fwk_tbx_lookup_types_tl.xdf on worker 1 while applying RUP 6

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:

After merging the pre_req  ,RUP6 and post-req patches together and apply the new merged patch,  

We got the below Error while applying RUP6.
we are running this patch using adctrl distributed=y.

FAILED: file fwk_tbx_lookup_types_tl.xdf on worker 1.
FAILED: file fwk_tbx_lookup_codes_b.xdf on worker 2.

Note DOC ID 5347952 did not help

Solution:

merge the pre-req patches alone and apply it then apply the RUP6 patch and then apply the post-req patches

apply the pre-req patches alone first and then apply the RUP6 patch and check whether issue got resolved or not

if it does not work, do the below:


1. Run scripts manually:

adjava -Xmx512M -nojit oracle.apps.fnd.odf2.FndXdfCmp ak ak apps apps_pwd
thin
"(DESCRIPTION=(ADDRESS=(PROTO =tcp)(HOST=<i.e. us.oracle.com>)(PORT=<db_por
t#>)
(CONNECT_DATA=(SERVICE_NAME=<i.e oracle.com)(INSTANCE_NAME=<SID_NAME>)))"
table
<full path to $FND_TOP/patch/115/fwk_tbx_lookup_types_tl.xdf
<full path to $FND_TOP/patch/115/xdf_xsl

adjava -Xmx512M -nojit oracle.apps.fnd.odf2.FndXdfCmp ak ak apps apps_pwd
thin
"(DESCRIPTION=(ADDRESS=(PROTO =tcp)(HOST=<i.e. us.oracle.com>)(PORT=
<db_port#>)
(CONNECT_DATA=(SERVICE_NAME=<i.e oracle.com)(INSTANCE_NAME=<SID_NAME>)))"
table
<full path to $FND_TOP/patch/115/fwk_tbx_lookup_codes_b.xdf
<full path to $FND_TOP/patch/115/xdf_xsl

2. Run adctrl and skip failed workers;

3. Continue adaptch;

Replace the entries by the ones from your environment.

Get Oracle Certifications for all Exams
Free Online Exams.com

ldap_bind: Invalid credentials,Orion Launcher Could not get OID connection javax.naming.AuthenticationException: [LDAP: error code 49 - Invalid Credentials]

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:

When login to SSO page we get unexpected error

Error:

OID HOST:
OID PORT: 389
SSO SERVER DN: orclApplicationCommonName=ORASSO_SSOSERVER,cn=SSO,cn=Products,cn=
OracleContext
OID USE SSL: N
SSO SERVER PASSWORD: Tl5cvq1x

ldapbind -h hostname -p 389 -D
orclApplicationCommonName=ORASSO_SSOSERVER,cn=SSO,cn=Products,cn=OracleContext
-w Tl5cvq1x
ldap_bind: Invalid credentials

ssoServer.logs

[ERROR] Orion Launcher Check the OID server, hostname:389 availability
Wed May 20 16:15:24 GMT+04:00 2009 [ERROR] Orion Launcher Could not get OID connection
javax.naming.AuthenticationException: [LDAP: error code 49 - Invalid Credentials]

Explanation:

Incorrect configuration between SSO and OID server.

Solution:

Define correct password at OID level for orclApplicationCommonName=ORASSO_SSOSERVER

1.       Open oidadmin tool and login as orcladmin user.

2. Navigate to:

From "Entry Management" Click "cn=OracleContext"
Then "cn=Products"
Then "cn=sso"
Do click on orclApplicationCommonName=ORASSO_SSOSERVER

Look in the right frame attribute userpassword it appears hide. So retype
password Tl5cvq1x and do click on “Apply” button.

3. Restart components on infra:

opmnctl stopall
opmnctl startall

4. Test ldapbind in command prompt:

/u01/vatdev/m2poc_oid/bin/ldapbind -h hostname -p 389 -D
orclApplicationCommonName=ORASSO_SSOSERVER,cn=SSO,cn=Products,cn=OracleContext
-w Tl5cvq1x

5. If that work then try to authentication using SSO and DAS:

http://hostname:7778/pls/orasso
http://hostname:7778/oiddas

References:

Note 315534.1 - How to Verify that SSO can Communicate with OID

Get Oracle Certifications for all Exams
Free Online Exams.com

Problem Description: Error in Workflow PAXWFHRU/806 3205: 'PASYSADMIN' is not a valid role or user name.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    

Problem Description: Error in Workflow PAXWFHRU/806 3205: 'PASYSADMIN' is not a valid role or user name. 

Error in Workflow POAPPRV/74-778 ORA-06512: at line 

Error in Workflow POAPPRV/239-233 3103: Attribute 'DOCUMENT_ID' does not exist for item 'POAPPRV/239-233'.

Error in Workflow WCAPPRV/2009-164 ORA-01403: no data found ORA-01403: no data found

Error in Workflow PAXWFHRU/806 3205: 'PASYSADMIN' is not a valid role or user name.

An Error occurred in the following Workflow. Item Type = PAXWFHRU Item Key = 806 User Key = Error Name = WFNTF_ROLE Error Message = 3205: 'PASYSADMIN' is not a valid role or user name. Error Stack = Wf_Notification.Send(PASYSADMIN, PAXWFHRU, MSG_ASSIGNMENT_UPD_FAIL, WF_ENGINE.CB) Wf_Engine_Util.Notification_Send(PAXWFHRU, 806, 189353, PAXWFHRU:MSG_ASSIGNMENT_UPD_FAIL) Wf_Engine_Util.Notification(PAXWFHRU, 806, 189353, RUN) Activity Id = 189353 Activity Label = PROCESS_ASSIGNMENT_CHANGES:NTF_ASSIGNMENT_UPD_FAIL Result Code = #EXCEPTION Notification Id = Assigned User =

Solution:

As per note Error In Workflow PAXWFHRU/1194 3205: 'PASYSADMIN' Is Not A Valid Role Or User Name. Where is PASYSADMIN Defined? (Doc ID 1320112.1):

Oracle® Projects Implementation Guide Release 12.1 states:

Implementing the PA: HR Related Updates Workflow
You need to define the PASYSADMIN user. The PASYSADMIN user will receive notifications sent by the PA: HR Related Updates workflow processes. For information on defining users, see System Administration Setup Tasks, Oracle Applications System Administrator's Guide – Configuration.

So it sounds like a user is created in the System Administrator responsibility | Security | User | Define User name = PASYSADMIN that has an active email address. Once defined, then these workflows should complete successfully.

References:

Error In Workflow PAXWFHRU/1194 3205: 'PASYSADMIN' Is Not A Valid Role Or User Name. Where is PASYSADMIN Defined? (Doc ID 1320112.1)

Get Oracle Certifications for all Exams
Free Online Exams.com

APP-AR-42536 this transaction is associated with at least one or end-dated GL account. Please correct the account.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    APP-AR-42536 this transaction is associated with at least one or end-dated GL account. Please correct the account.

Correct the receivable account assignment (receivable A/C CC is valid in GL)

Auto invoice Import program is not recognizing valid receivable code combination 6005-0000-121100-000000-0000-000-000-000

System is not allowing completing transaction today
error message: "APP-AR-42536 this transaction is associated with at
least one or end-dated GL account. Please correct
the account."

We were not able to enter single AR Receipt, AR Transaction and could not import AR transactions so delayed the period closing.

Symptoms:

>Submit Auto Invoice master Program
>Open transaction 13514 & click "Complete" Button

Log files:

Autoinvoice_Import_Program_020709.txt

Contains:

RAXTRX module: Auto invoice Import Program

Error calling afpoget() - AR_ALLOW_TRX_LINE_EXEMPTIONS

Solution:

Correct the receivable account assignment (receivable A/C CC is valid in GL

Get Oracle Certifications for all Exams
Free Online Exams.com

Workflow notification mailer gets down frequently. An unexpected RuntimeException or Throwable occurred -> java.lang.StackOverflowError

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    Workflow notification mailer gets down frequently. An unexpected RuntimeException or Throwable occurred -> java.lang.StackOverflowError

Symptoms:

The inbound processing is currently disabled and it is working fine. If the inbound processing enabled then it goes down frequently.

Workflow notification getting deactivated periodically.

 Inbound notification is not getting processed.

Log files:

Mailer log file:
---------------------

[May 16, 2009 4:49:41 PM GMT+04:00]:1242478181396:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1::-1:-1:UNEXPECTED:[SVC-GSM-WFMLRSVC-77086-10006 : oracle.apps.fnd.cp.gsc.Processor.run()]:An unexpected RuntimeException or Throwable occurred -> java.lang.StackOverflowError

[May 18, 2009 12:50:40 PM GMT+04:00]:1242636640373:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1::-1:ERROR:[SVC-GSM-WFMLRSVC-77269-10006 : oracle.apps.fnd.cp.gsc.Processor.performError(ProcessorException)]:Maximum number of errors have occurred for this processing thread.

FNDCPGSC73666.txt

## Detail 0 ##
JBO-30003: The application pool (dwcp1576oracle.apps.fnd.wf.worklist.server.WorklistAM) failed to checkout an application module due to the following exception:
oracle.jbo.JboException:JBO-29000:Unexpected exception caught: oracle.apps.fnd.framework.OAException, msg=Application: FND, Message Name: SQL_PLSQL_ERROR. Tokens: ROUTINE = AppsConnectionManager.appsInitialize(int,int,int,int,Connection):-1,-1,-1,0,oracle.jdbc.driver.OracleConnection@1f11cbf; REASON = java.sql.SQLException: ORA-20001: Oracle error -6508: ORA-04061: existing state of package body "APPS.FND_PROFILE" has been invalidated
ORA-04065: not executed, altered or dropped package body "APPS.FND_PROFILE"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_PROFILE"
has been detected in FND_GLOBAL.INITIALIZE.
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.FND_GLOBAL", line 101
ORA-06512: at "APPS.FND_GLOBAL", line 1147
ORA-06512: at "APPS.FND_GLOBAL", line 620

Solution:

1.

Make sure the following patches are applied: Patch.6720592. And Patch.4747557 and Patch 6940918 and Patch 6218989 and Patch 6441940

Bug.6720592: NOTIFICATION MAILER TIME OUT MESSAGES,
NEEDS RESTART AND MAILER PERFORMANCE ISSUE AFTER RUP5

Oracle consolidated many workflow performance fixes into this one
patch 6720592 and it includes all the objects required so it can be applied to RUP4 and above.
It is considered kind of a baseline for workflow after RUP4 or RUP5 or RUP6.

Patch 4747557 :11.5.10.CU2: 4725438: STACKOVERFLOWEXCEPTION WHEN PROCESSING NOTIFICATION RESPONSES

Patch 6940918 1OFF:11IRU4:6511028: WORKFLOW CONTAINERS CONSUMING LOT OF TEMP TABLE SPACE

Patch 6218989 1OFF:6032403:ATG RUP5:11.5.10.2.5:SESSION TIMEOUT IN ICX_SESSIONS

Patch 6441940 MAILER WITH NON-NULL CORR ID DOES NOT PROCESS MESSAGES AFTER ATG PF.H RUP 5

2.

1. set the following Mailer parameters as recommended.

Processor Close on Read timeout -- Set it to Y
Inbound thread count -- Set it to 1.

2. Bounce the WF Notification Mailer.
3. Run the following Concurrent request:

Name: "Move messages from Exception to Normal Queue of Workflow Agent"
Parameter Value: WF_NOTIFICATION_OUT as the Agent Name.
4. Re-test the issue.

3. If the instance is not patches to ATG.RUP.5 or 6 then edit the workflow mailer service / click on the advanced button / increase the inbound and outbound threads to 2 / click next to complete and save and re test

References:

Bug.6720592: NOTIFICATION MAILER TIME OUT MESSAGES,
NEEDS RESTART AND MAILER PERFORMANCE ISSUE AFTER RUP5

Article-ID: Note 340402.1
Title: JMAILER java.lang.StackOverflowError - keeps crashing

Article-ID: Note 305574.1
Title: Mailer errors out with JAVA.LANG.STACKOVERFLOWERROR

Article-ID: Note 735812.1
Title: Performance Issues Caused by WF_EVENT_OJMSTEXT_QH.DEQUEUE
Procedure

Get Oracle Certifications for all Exams
Free Online Exams.com

workflow notification mailer is consuming 100%CPU performance degradation till loss of service javax.mail.MessagingException: 451 Timeout waiting for client input

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    workflow notification mailer is consuming 100%CPU performance degradation till loss of service javax.mail.MessagingException: 451 Timeout waiting for client input

Workflow Mailer java process is consuming 100% of CPU on Apps server which degrades the performance and bounce is needed.

javax.mail.MessagingException: 451 Timeout waiting for client input

Log files:

wf_output.log

Filename = <a href="http://sew.oraclecorp.com/SEW/fileDownload?forceDownload=0&fileURL=https%3A%2F%2Fgtcr.oracle.com%2Fgtcr-dir%2Fgtcr_546379931%2F7583240.992%2Fwf_output.zip"target="_blank">https://gtcr.oracle.com/gtcr-dir/gtcr_546379931/7583240.992/wf_output.zip</a>

MT+04:00]:1241533971006:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:Servername:IPAddress:-1:-1:ERROR:[SVC-GSM-WFMLRSVC-73035-10006 : oracle.apps.fnd.wf.mailer.SMTPOutboundProcessor.send(Message)]:Problem encountered when sending to {[["USERNAME" <Email>]]} -> javax.mail.MessagingException: 451 Timeout waiting for client input

[May 5, 2009 6:32:51 PM GMT+04:00]:1241533971007:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:Servername:IPAddress:-1:-1:ERROR:[SVC-GSM-WFMLRSVC-73035-10006 : oracle.apps.fnd.wf.mailer.SMTPMessageHandler.sendMessages(String)]:MessagingException -> javax.mail.MessagingException: 451 Timeout waiting for client input

[May 5, 2009 6:33:28 PM GMT+04:00]:1241534008921:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:Servername:IPAddress:-1:-1:ERROR:[SVC-GSM-WFMLRSVC-73035-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.readNewMessages()]:Connection to the INBOX has been lost

[May 14, 2009 12:54:27 AM GMT+04:00]:1242248067600:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:Servername:IPAddress:-1:-1:ERROR:[SVC-GSM-WFMLRSVC-73490-10006 : oracle.apps.fnd.wf.mailer.SMTPMessageHandler.sendMessages(String)]:Not sending notification 20985431 because could not locate the row in the notification table
[May 14, 2009 12:54:32 AM GMT+04:00]:1242248072987:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:Servername:IPAddress:-1:-1:UNEXPECTED:[fnd.wf.mailer.URLMIMETagListener]:oracle.apps.fnd.wf.mailer.URLMIMETagListener.editStyleRef(HTMLTagEvent, String) Making a connection to {http://sid.dubaiworld.ae:80/OA_HTML/cabo/images/cache/cmbts.gif)} returned {404 - Not Found}. Leaving as a reference
[May 14, 2009 2:25:01 AM GMT+04:00]:1242253501108:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:Servername:IPAddress:-1:-1:ERROR:[SVC-GSM-WFMLRSVC-73490-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.moveMessage(Message, String)]:Source folder {INBOX} is not open.
[May 14, 2009 2:25:24 AM GMT+04:00]:1242253524409:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:Servername:IPAddress:-1:-1:ERROR:[SVC-GSM-WFMLRSVC-73490-10006 : oracle.apps.fnd.wf.mailer.SMTPOutboundProcessor.send(Message)]:Problem encountered when sending to {[["ABDULLA, KHALID ABDULREDHA ABDULLA" <Khaled.AbdulRedha@jafza.ae>]]} -> javax.mail.MessagingException: 451 Timeout waiting for client input

[May 8, 2009 10:10:47 PM GMT+04:00]:1241806247678:Thread[Thread-0,1,main]:0:-1:Servername:IPAddress:-1:-1:ERROR:[fnd.common.ErrorStack]:java.sql.SQLException: ORA-01033: ORACLE initialization or shutdown in progress

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:410)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:260)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:371)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:551)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:351)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1194)
at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:976)
at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:868)
at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:857)
at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:586)
at oracle.apps.fnd.security.DBConnObj.<init>(DBConnObj.java:246)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at oracle.apps.fnd.common.Pool.createObject(Pool.java:1287)
at oracle.apps.fnd.common.Pool.createAvailableObject(Pool.java:2225)
at oracle.apps.fnd.common.Pool.resize(Pool.java:2103)
at oracle.apps.fnd.common.Pool.run(Pool.java:1985)
at java.lang.Thread.run(Thread.java:534)

[May 8, 2009 10:10:47 PM GMT+04:00]:1241806247678:Thread[Thread-0,1,main]:0:-1:Servername:IPAddress:-1:-1:ERROR:[fnd.common.ErrorStack]:SECURITY_APPL_LOGIN_FAILED

alert.log

Completed: ALTER DATABASE BACKUP CONTROLFILE TO '/backup1/sidbak/onln_bkp/ctrlSID2.ctl.162.1304'
Wed May 13 23:59:10 2009
Some indexes or index [sub]partitions of table HR.PER_EMPDIR_PEOPLE have been marked unusable
Thu May 14 00:03:47 2009
Some indexes or index [sub]partitions of table HR.PER_EMPDIR_ASSIGNMENTS have been marked unusable
Thu May 14 00:03:52 2009
Some indexes or index [sub]partitions of table HR.PER_EMPDIR_ORGANIZATIONS have been marked unusable
Thu May 14 00:03:56 2009
Some indexes or index [sub]partitions of table HR.PER_EMPDIR_PHONES have been marked unusable
Thu May 14 00:04:27 2009
Some indexes or index [sub]partitions of table HR.PER_EMPDIR_POSITIONS have been marked unusable
Thu May 14 00:04:28 2009
Thread 2 advanced to log sequence 69442
Current log# 8 seq# 69442 mem# 0: /u02/sid/siddata/log08.dbf
Thu May 14 00:04:30 2009
Some indexes or index [sub]partitions of table HR.PER_EMPDIR_JOBS have been marked unusable
Thu May 14 00:04:32 2009
Some indexes or index [sub]partitions of table HR.PER_EMPDIR_LOCATIONS have been marked unusable
Thu May 14 00:04:36 2009
Some indexes or index [sub]partitions of table HR.PER_EMPDIR_LOCATIONS_TL have been marked unusable
Thu May 14 01:30:23 2009
Thread 2 advanced to log sequence 69443
Current log# 10 seq# 69443 mem# 0: /u02/sid/siddata/log10.dbf
Thu May 14 01:34:32 2009
Thread 2 advanced to log sequence 69444
Current log# 9 seq# 69444 mem# 0: /u02/sid/siddata/log09.dbf
Thu May 14 02:25:00 2009
ORA-01555 caused by SQL statement below (SQL ID: dsphq1qsnymv8, Query Duration=1242253500 sec, SCN: 0x010e.b4f05697):
Thu May 14 02:25:00 2009
BEGIN WF_EVENT_OJMSTEXT_QH.DEQUEUE(:1, :2, :3); END;

Solution:

You are experiencing Bug.6511028 - WORKFLOW SERVICE CONTAINER CONSUMING A LOT OF TEMPORARY SEGEMENTS
The patch for your version which is 11.5.10 + ATG RUP4 is patch# 6940918

Other work around might help as below:

-          Caused by the failure of Mailer in processing the notifications

-          Run Ready messages in WF_DEFERRED queue manually

-          reduce the chatting between the SMTP server and java mailer by going to OAM, Mailer Configuration, Step 2 - check the box for Processor Close on Read Timeout

- Run the workflow deferred agent listener from sqlplus in order to process all the events

a. Source APPSORA.env so you can run sqlplus from any location and use the $FND_TOP env variable:

. APPSORA.env

b. Login to sqlplus as the apps user:

sqlplus apps/apps

c. Make a script of the following and run it logged in as apps. It will create a file called
debug.log showing what it is doing as it dequeues. Failing events will also be enqueued on the
WF_ERROR queue:

================Begin Script========================

@$FND_TOP/patch/115/sql/wfdbginit.sql 1 %
spool debug.log;
exec wf_log_pkg.wf_debug_flag := true;
exec fnd_log.g_current_runtime_level := 1;

begin

wf_event.listen(p_agent_name => 'WF_DEFERRED');
end;
/
col module format a15 ;
col message_text format a40;

commit;
@$FND_TOP/patch/115/sql/wfdbgprnt.sql wf.plsql.%

select fnd_debug_util.get_trace_file_name() tracefile from dual;

spool off;

================End Script===========================

Note: This script will take time because there are several events in the WF_DEFERRED queue.

B. Rebuild and clean.

a. Shutdown the Workflow Mailer Service and Workflow Agent Listener Service then run the following:

sqlplus apps/apps @$FND_TOP/sql/wfevqcln.sql WF_DEFERRED oracle.apps.wf.notification.%

OR based on your patch level

sqlplus apps/apps @$FND_TOP/sql/wfevqcln.sql WF_DEFERRED oracle.apps.wf.notification.% 0 (CU 2 and above)

b. Conditionally required for ATG RUP4 and above Oracle Alert users:

NOTE: APPLSYS is assumed to be the schema storing the Workflow tables. Please substitute the correct schema name if necessary.

1. Backup the Oracle Alert messages that are unprocessed on the WF_NOTIFICATION_OUT.

ASSUMPTION: The corrupt messages are not belonging to Oracle Alert.

create table APPLSYS.AQ$WF_NOTIFICATION_OUT_BAK as select * from APPLSYS.AQ$WF_NOTIFICATION_OUT where CORR_ID like
'APPS:ALR%' and msg_state in ('READY','WAIT');

2. Confirm that all Oracle Alert messages have been backup:

set linesize 155;
set pagesize 200;
set verify off;
SELECT COUNT(*),
substr(corr_id,1,45) corr_id,
msg_state
FROM applsys.aq$wf_notification_out
WHERE corr_id LIKE 'APPS:ALR%'
AND msg_state IN('READY', 'WAIT')
GROUP BY corr_id,
msg_state;

Compare:

set linesize 155;
set pagesize 200;
set verify off;
SELECT COUNT(*),
substr(corr_id,1,45) corr_id,
msg_state
FROM applsys.aq$wf_notification_out_bak
WHERE corr_id LIKE 'APPS:ALR%'
AND msg_state IN('READY', 'WAIT')
GROUP BY corr_id,
msg_state;


3. Drop the WF_NOTIFICATION_OUT queue to remove all the other messages:

sqlplus apps/apps

Exec dbms_aqadm.stop_queue( queue_name => 'APPLSYS.WF_NOTIFICATION_OUT', wait => FALSE);

exec dbms_aqadm.drop_queue_table( queue_table => 'APPLSYS.WF_NOTIFICATION_OUT', force => TRUE);

4. Recreate WF_NOTIFICATION_OUT as it need to exist for $FND_TOP/patch/115/sql/wfntfqup.sql to run successfully. See the steps :

i. Run the following to recreate the JMS queues:

sqlplus APPSusr/APPSpwd @wfjmsqc2.sql FNDusr FNDpwd

Example:

sqlplus apps/apps @$FND_TOP/patch/115/sql/wfjmsqc2.sql applsys apps


ii. Add the subscribers:

sqlplus APPSusr/APPSpwd @wfmqsubc2.sql FNDusr FNDpwd

Example Syntax:

sqlplus apps/apps @$FND_TOP/patch/115/sql/wfmqsubc2.sql APPLSYS APPS

c. Required by ALL: Now run to repopulate the WF_NOTIFICATION_OUT queue:

sqlplus usr/passwd@db @$FND_TOP/patch/115/sql/wfntfqup APPSusr APPSpw FNDusr

Example Syntax:

sqlplus apps/apps @$FND_TOP/patch/115/sql/wfntfqup APPS apps APPLSYS


5. Required for Oracle Alert: Make the following into a script and run it from the apps schema. It will ONLY put Oracle Alert messages that are unprocessed on the WF_NOTIFICATION_OUT queue.


===============Begin Script=============================

set serveroutput on size 100000;
declare
x_out_queue varchar2(80) := 'APPLSYS.WF_NOTIFICATION_OUT';
x_enqueue_options dbms_aq.enqueue_options_t;
x_message_properties dbms_aq.message_properties_t;
x_msgid RAW(16);
i number := 0;
p_event SYS.AQ$_JMS_TEXT_MESSAGE;

cursor msg is
select * from APPLSYS.AQ$WF_NOTIFICATION_OUT_BAK
where msg_state in ('READY','WAIT');

begin

for m1 in msg loop

x_out_queue := 'APPLSYS.'||m1.queue;
x_message_properties.correlation := m1.corr_id;
--x_message_properties.original_msgid := m1.msg_id;
x_message_properties.priority := m1.msg_priority;

x_message_properties.recipient_list(1) := sys.aq$_agent(m1.consumer_name,
null,
0);
if (m1.msg_state = 'WAIT') and (m1.delay > sysdate) then
x_message_properties.delay := ((sysdate - m1.delay)*86400);
else
x_message_properties.delay := 0;
end if;
--dbms_output.put_line('msg.msgid = ' || m1.msg_id);

DBMS_AQ.ENQUEUE(
queue_name => x_out_queue,
enqueue_options => x_enqueue_options,
message_properties => x_message_properties,
payload => m1.user_data,
msgid => x_msgid); /* OUT*/

--dbms_output.put_line('x_msgid = ' || x_msgid);

if i = 20 then
i := 0;
commit;
else
i := i + 1;
end if;
end loop;

commit;
exception
when others then
dbms_output.put_line('sqlerrm = ' || sqlerrm);
end;
/

=========End Script======================================


6. Confirm that all Oracle Alert messages are back on the wf_notification_out queue:

set linesize 155;
set pagesize 200;
set verify off;
SELECT COUNT(*),
substr(corr_id,1,45) corr_id,
msg_state
FROM applsys.aq$wf_notification_out
WHERE corr_id LIKE 'APPS:ALR%'
AND msg_state IN('READY', 'WAIT')
GROUP BY corr_id,
msg_state;

d. Create Index on WF Queue Tables

NOTE: The index tablespace can be determined by running the following select. Please ignore any ora-0955 errors as the only missing index is WF_NOTIFICATION_OUT_N1. Use the same tablespace_name as the one that belongs to WF_NOTIFICATION_IN_N1:

select tablespace_name, index_name from dba_indexes where index_name like 'WF_%_N1';

sqlplus usr/passwd@db @$FND_TOP/patch/115/sql/wfqidxc FNDusr FNDpwd tablespace_name

OR based on your patch level

sqlplus usr/passwd@db @$FND_TOP/patch/115/sql/wfqidxc2 FNDusr FNDpwd tablespace_name

Example Syntax:

sqlplus apps/apps @$FND_TOP/patch/115/sql/wfqidxc APPLSYS APPS USER_IDX

sqlplus apps/apps @$FND_TOP/patch/115/sql/wfqidxc2 APPLSYS APPS APPS_TS_QUEUES

e. Work Flow Histograms Creation Script.

sqlplus usr/passwd@db @$FND_TOP/patch/115/sql/wfhistc FNDusr

Example Syntax:

sqlplus apps/apps @$FND_TOP/patch/115/sql/wfhistc APPLSYS

f. Then restart the Workflow Mailer Service and Workflow Agent Listener Service.

References:

Note.567762.1 Gen EVENTS.P-1151 Ext/Pub Performance Issues with Workflow Service Container
Bug 6511028 - WORKFLOW SERVICE CONTAINER CONSUMING A LOT OF TEMPORARY SEGEMENTS
Bug 6940918 1OFF:11IRU4:6511028 : WORKFLOW CONTAINERS CONSUMING LOT OF TEMP TABLE SPACE

Get Oracle Certifications for all Exams
Free Online Exams.com

HIGH CPU USAGE PROBLEM WITH AGGRESPY(SPY) applied on the top of SOA 10.1.3.4

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:

HIGH CPU USAGE PROBLEM WITH AGGRESPY(SPY) applied on the top of SOA 10.1.3.4

Symptoms:

opmn.log shows  SOA components are continuously restarting.

Log files:

Opmn.log

opmn.log:8526:09/04/11 14:23:45 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8528:09/04/12 08:26:34 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8530:09/04/12 08:27:24 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8532:09/04/12 08:28:14 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8534:09/04/12 08:29:04 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8536:09/04/12 08:29:54 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8538:09/04/12 08:30:44 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8546:09/04/22 10:06:11 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8548:09/04/22 10:07:01 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8550:09/04/22 10:07:51 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8552:09/04/22 10:08:41 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8554:09/04/22 10:09:31 [libopmnoc4j] OC4J ping attempt timed out
opmn.log:8556:09/04/22 10:10:21 [libopmnoc4j] OC4J ping attempt timed out

BPEL~oc4j_soa~default_group~1.log


Group is not found.
Group "group" is not found in realm "jazn.com"
Please, verify that given group name "group" exists in realm "jazn.com". Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable.

at oracle.tip.pc.services.identity.jazn.BPMAuthorizationServiceImpl.lookupGroup(BPMAuthorizationServiceImpl.java:235)
at oracle.tip.pc.services.identity.jazn.xml.XMLIdentityService.lookupGroup(XMLIdentityService.java:175)
at oracle.bpel.services.workflow.task.impl.TaskUtil.getUsersinAsssignment(TaskUtil.java:185)
at oracle.bpel.services.workflow.task.impl.TaskUtil.randomPickCurrentAssignee(TaskUtil.java:156)
at oracle.bpel.services.workflow.task.impl.TaskUtil.randomPickCurrentAssignee(TaskUtil.java:143)
at oracle.bpel.services.workflow.task.impl.TaskUtil.getCurrentAssignee(TaskUtil.java:131)
at oracle.bpel.services.workflow.verification.impl.VerificationService.isTopmostUser(VerificationService.java:2915)
at oracle.bpel.services.workflow.verification.impl.VerificationService.getRoleBasedGroupActions(VerificationService.java:2649)
at oracle.bpel.services.workflow.verification.impl.VerificationService.getTaskSystemActions(VerificationService.java:1257)
...
<2009-04-20 14:53:33,485> <WARN> <default.collaxa.cube.services> <::> The value parameter passed in Predicate.addClause contains Strings, and will be deprecated. Please pass List of ITaskAssingee.
09/04/20 14:53:41 Remote User is: null------------------------------------------
09/04/20 14:53:41 Normal login with username: User------------------------------------------
09/04/20 14:54:45 Remote User is: null------------------------------------------
09/04/20 14:54:48 Remote User is: null------------------------------------------
09/04/20 14:54:48 Normal login with username: User------------------------------------------
09/04/20 14:54:48 Remote User is: null------------------------------------------
09/04/20 14:55:13 Remote User is: null------------------------------------------
09/04/20 14:55:13 Normal login with username: User------------------------------------------
<2009-04-20 14:55:13,258> <ERROR> <declaration.collaxa.cube.services> <PCException::<init>> Identity Service Authentication failure.
<2009-04-20 14:55:13,258> <ERROR> <declaration.collaxa.cube.services> <PCException::<init>> Identity Service Authentication failure.
<2009-04-20 14:55:13,259> <ERROR> <declaration.collaxa.cube.services> <PCException::<init>> Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable.
<2009-04-20 14:55:13,259> <ERROR> <declaration.collaxa.cube.services> <::> WorkflowService:: VerificationService.authenticateUser: error: Identity Service Authentication failure.
<2009-04-20 14:55:13,259> <ERROR> <declaration.collaxa.cube.services> <::> Identity Service Authentication failure.
<2009-04-20 14:55:13,259> <ERROR> <declaration.collaxa.cube.services> <::> Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable.
<2009-04-20 14:55:13,259> <ERROR> <declaration.collaxa.cube.services> <::> ORABPEL-30501
<2009-04-20 14:55:13,259> <ERROR> <declaration.collaxa.cube.services> <::>
<2009-04-20 14:55:13,259> <ERROR> <declaration.collaxa.cube.services> <::> Error in authenticating user.
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> Error in authenticating and creating a workflow context for user jazn.com/User
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> Check the underlying exception and correct the error. Contact oracle support if error is not fixable.
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::>
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> at oracle.bpel.services.workflow.verification.impl.VerificationService.authenticateUser(VerificationService.java:375)
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> at oracle.bpel.services.workflow.query.impl.TaskQueryService.authenticate(TaskQueryService.java:159)
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> at worklistapp.servlets.Login.handleRequest(Login.java:137)
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> at worklistapp.servlets.BaseServlet.doPost(BaseServlet.java:157)
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
...
...
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> at java.lang.Thread.run(Thread.java:595)
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> Caused by: ORABPEL-10528
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::>
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> Identity Service Authentication failure.
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> Identity Service Authentication failure.
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable.
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::>
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> at oracle.tip.pc.services.identity.jazn.xml.XMLAuthenticationService.authenticateUser(XMLAuthenticationService.java:150)
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> at oracle.tip.pc.services.identity.jazn.xml.XMLIdentityService.authenticateUser(XMLIdentityService.java:426)
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> at oracle.bpel.services.workflow.verification.impl.VerificationService.authenticateUser(VerificationService.java:341)
<2009-04-20 14:55:13,260> <ERROR> <declaration.collaxa.cube.services> <::> ... 14 more
<2009-04-20 14:55:13,260> <ERROR> <oracle.bpel.services.workflow> <::> Identity Service Authentication failure.
Identity Service Authentication failure.
Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable.

ORABPEL-10528

Identity Service Authentication failure.
Identity Service Authentication failure.

Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable.

at oracle.tip.pc.services.identity.jazn.xml.XMLAuthenticationService.authenticateUser(XMLAuthenticationService.java:150)
at oracle.tip.pc.services.identity.jazn.xml.XMLIdentityService.authenticateUser(XMLIdentityService.java:426)
at oracle.bpel.services.workflow.verification.impl.VerificationService.authenticateUser(VerificationService.java:341)
at oracle.bpel.services.workflow.query.impl.TaskQueryService.authenticate(TaskQueryService.java:159)
at worklistapp.servlets.Login.handleRequest(Login.java:137)
at worklistapp.servlets.BaseServlet.doPost(BaseServlet.java:157)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)
09/04/20 14:55:15 Remote User is: null------------------------------------------
09/04/20 14:55:15 Normal login with username: User------------------------------------------
...


~SOA_~default_group~1.log

...
09/04/20 14:49:09 Caused by: org.hibernate.TransactionException: JDBC rollback failed
09/04/20 14:49:09 at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:170)
09/04/20 14:49:09 at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:589)
09/04/20 14:49:09 at org.springframework.transaction.support.AbstractPlatformTransactionManager.doRollbackOnCommitException(AbstractPlatformTransactionManager.java:792)
09/04/20 14:49:09 at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:679)
09/04/20 14:49:09 at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:621)
09/04/20 14:49:09 at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:311)
09/04/20 14:49:09 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:117)
09/04/20 14:49:09 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
09/04/20 14:49:09 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
09/04/20 14:49:09 at $Proxy135.saveUploadedDocument(Unknown Source)
09/04/20 14:49:09 at sun.reflect.GeneratedMethodAccessor15030.invoke(Unknown Source)
09/04/20 14:49:09 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
09/04/20 14:49:09 at java.lang.reflect.Method.invoke(Method.java:585)
09/04/20 14:49:09 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:299)
09/04/20 14:49:09 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)
09/04/20 14:49:09 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)
09/04/20 14:49:09 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
09/04/20 14:49:09 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
09/04/20 14:49:09 at com.ksevindik.auditing.interceptor.ServiceAuditLogInterceptor.invoke(ServiceAuditLogInterceptor.java:43)
09/04/20 14:49:09 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
09/04/20 14:49:09 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
09/04/20 14:49:09 at $Proxy136.saveUploadedDocument(Unknown Source)
09/04/20 14:49:09 at com.pcfc.customs.customer.common.web.action.UploadDocumentAction.executeInvokeMethod(UploadDocumentAction.java:410)
09/04/20 14:49:09 ... 41 more
09/04/20 14:49:09 Caused by: java.sql.SQLException: Attempt to use an invalid handle : 'oracle_jdbc_driver_LogicalConnection_Proxy@278340'.
09/04/20 14:49:09 at oracle.oc4j.sql.spi.ConnectionHandle.oc4j_intercept(ConnectionHandle.java:286)
09/04/20 14:49:09 at oracle.oc4j.sql.spi.ConnectionHandle.rollback(ConnectionHandle.java:148)
09/04/20 14:49:09 at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
09/04/20 14:49:09 at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
09/04/20 14:49:09 ... 63 more

 BPEL~oc4j_soa~default_group~2.log

....
<2009-04-01 19:05:15,163> <ERROR> <declaration.collaxa.cube.engine.dispatch> <BaseScheduledWorker::process> Failed to handle dispatch message ... exception ORABPEL-05002

Message handle error.
An exception occurred while attempting to process the message "com.collaxa.cube.engine.dispatch.message.instance.ExpirationMessage"; the exception is: Instance not found in datasource.
The process domain was unable to fetch the instance with key "11701441" from the datasource.
Please check that the instance key "11701441" refers to a valid instance that has been started and not removed from the process domain.


ORABPEL-05002

Message handle error.
An exception occurred while attempting to process the message "com.collaxa.cube.engine.dispatch.message.instance.ExpirationMessage"; the exception is: Instance not found in datasource.
The process domain was unable to fetch the instance with key "11701441" from the datasource.
Please check that the instance key "11701441" refers to a valid instance that has been started and not removed from the process domain.


at com.collaxa.cube.engine.dispatch.DispatchHelper.handleMessage(DispatchHelper.java:171)
at com.collaxa.cube.engine.dispatch.BaseScheduledWorker.process(BaseScheduledWorker.java:70)
at com.collaxa.cube.engine.ejb.impl.WorkerBean.onMessage(WorkerBean.java:86)
at sun.reflect.GeneratedMethodAccessor51.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.evermind.server.ejb.interceptor.joinpoint.EJBJoinPointImpl.invoke(EJBJoinPointImpl.java:35)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInterceptor.invoke(DMSInterceptor.java:52)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.SetContextActionInterceptor.invoke(SetContextActionInterceptor.java:44)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.InvocationContextPool.invoke(InvocationContextPool.java:55)
at oracle.j2ee.connector.messageinflow.MessageEndpointImpl.OC4J_invokeMethod(MessageEndpointImpl.java:297)
at WorkerBean_EndPointProxy_4bin6i8.onMessage(Unknown Source)
at oracle.j2ee.ra.jms.generic.WorkConsumer.run(WorkConsumer.java:266)
at oracle.j2ee.connector.work.WorkWrapper.runTargetWork(WorkWrapper.java:242)
at oracle.j2ee.connector.work.WorkWrapper.doWork(WorkWrapper.java:215)
at oracle.j2ee.connector.work.WorkWrapper.run(WorkWrapper.java:190)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:814)
at java.lang.Thread.run(Thread.java:595)
09/04/01 22:32:22 pFaultMessage is org.collaxa.thirdparty.apache.wsif.base.WSIFDefaultMessage@1bf36ff name:DPPException
09/04/01 22:32:22 QName string is DPPException
09/04/01 22:32:22 pFaultMessage is org.collaxa.thirdparty.apache.wsif.base.WSIFDefaultMessage@1bcca5d name:DPPException
09/04/01 22:32:22 QName string is DPPException
09/04/01 22:32:40 pFaultMessage is org.collaxa.thirdparty.apache.wsif.base.WSIFDefaultMessage@1de9d38 name:DPPException
09/04/01 22:32:40 QName string is DPPException

--------
09/04/01 23:14:20 Stop process
--------
09/04/01 23:14:41 Shutting down...

<2009-04-01 23:14:44,618> <INFO> <collaxa> <ServerManager::uninit> Shutting down all domains
<2009-04-01 23:14:45,810> <INFO> <default.collaxa.cube.engine> <AdapterStats::uninit:Done uninitializing Adapter statistics holder for engine > default
<2009-04-01 23:14:45,837> <INFO> <default.collaxa.cube.engine> <AdaptorManager::unload> Uninitialized adaptors for platform 'ias_10g', datasource 'oracle'
<2009-04-01 23:14:45,837> <INFO> <default.collaxa.cube.engine> <CubeEngine::uninit> Uninitialized BPEL domain "default"
<2009-04-01 23:14:45,837> <INFO> <default.collaxa.cube.engine> <CubeEngine::unload> Unloaded BPEL domain "default"
<2009-04-01 23:14:46,652> <INFO> <collaxa> <ServerManager::uninit> Done shutting down all domains
Apr 1, 2009 11:14:47 PM org.collaxa.thirdparty.jgroups.blocks.PullPushAdapter run
WARNING: [<null>] channel closed, exception is ChannelClosedException
09/04/01 23:16:19 WARNING: MessageDrivenHome.waitForListeners Timeout waiting for listener threads to finish

Solution:

Patch 7670088: HIGH CPU USAGE PROBLEM WITH AGGRESPY(SPY) applied on the top of SOA 10.1.3.4 MLR# 6 installation

References:

Note. 761675.1 " OracleAS 10g OPMN Restarts OC4J Instance After "OC4J Ping Attempt Timed Out" Error "

Get Oracle Certifications for all Exams
Free Online Exams.com

Configuration Assistant “Repository Upgrade" Failed while Upgrade my existent EMGC 10.2.0.4 to R5 10.2.0.5

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Configuration Assistant “Repository Upgrade" Failed while Upgrade my existent EMGC 10.2.0.4 to R5 10.2.0.5

Upgrade my existent EMGC 10.2.0.4 to R5 10.2.0.5

while Patching the OMS home, and on the configuration menu, the following error occured

Configuration Assistant " Repository Upgrade" Failed

Symptoms:

Sysman password has been changed from the sql plus.

Log files:

CfmLogger_2009-06-05_12-37-19-AM.log

Running setSchemaStatus: BEGIN EMD_MAINTENANCE.SET_VERSION('_UPGRADE_','0','0','SYSTEM',EMD_MAINTENANCE.G_STATUS_UPGRADING);END;

Could not connect to SYSMAN/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))): ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin)

INFO: oracle.sysman.top.oms: Command Error:----------
INFO: oracle.sysman.top.oms:
SEVERE: oracle.sysman.top.oms:CfwException in Run OS Command:Command: /u01/app/oracle/product/emgrid/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))) -action upgrade -no_transx -no_verify -verbose -repos_user sysman -output_file /u01/app/oracle/product/emgrid/oms10g/sysman/log/emrepmgr.log.10.2.0.5.0 failed. Exit code: expected [0 ], but got 50

emrepmgr.log.10.2.0.5.0.*
-------------------------------
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod)))

[05-06-2009 00:40:55] Validating for Repos User ...

SQL*Plus: Release 10.1.0.5.0 - Production on Fri Jun 5 00:40:56 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /
Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[05-06-2009 00:40:56] Return code = 1.
[05-06-2009 00:40:56] Failed
[05-06-2009 00:40:56] Repos User does not exist..

SQL>
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[05-06-2009 00:40:57] Checking repository version..
[05-06-2009 00:40:57] Running setSchemaStatus: BEGIN EMD_MAINTENANCE.SET_VERSION('_UPGRADE_','0','0','SYSTEM',EMD_MAINTENANCE.G_STATUS_UPGRADING);END;

[05-06-2009 00:40:57] Could not connect to SYSMAN/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))): ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin)



emoms.trc

2009-06-04 21:40:53,962 [AJPRequestHandler-ApplicationServerThread-11] ERROR conn.ConnectionService verifyRepositoryEx.878 - Invalid Connection Pool. ERROR = Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod)))



CfmLogger_2009-06-05_12-37-19-AM.log

Running setSchemaStatus: BEGIN EMD_MAINTENANCE.SET_VERSION('_UPGRADE_','0','0','SYSTEM',EMD_MAINTENANCE.G_STATUS_UPGRADING);END;

Could not connect to SYSMAN/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))): ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin)

INFO: oracle.sysman.top.oms: Command Error:----------
INFO: oracle.sysman.top.oms:
SEVERE: oracle.sysman.top.oms:CfwException in Run OS Command:Command: /u01/app/oracle/product/emgrid/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))) -action upgrade -no_transx -no_verify -verbose -repos_user sysman -output_file /u01/app/oracle/product/emgrid/oms10g/sysman/log/emrepmgr.log.10.2.0.5.0 failed. Exit code: expected [0 ], but got 50
SEVERE: oracle.sysman.top.oms:Schema Upgrade Failed. Installation Terminated! Exception: Command: /u01/app/oracle/product/emgrid/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))) -action upgrade -no_transx -no_verify -verbose -repos_user sysman -output_file /u01/app/oracle/product/emgrid/oms10g/sysman/log/emrepmgr.log.10.2.0.5.0 failed. Exit code: expected [0 ], but got 50
WARNING: oracle.sysman.top.oms:EmcpPlug:startProcessing:Exception in runner=Command: /u01/app/oracle/product/emgrid/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))) -action upgrade -no_transx -no_verify -verbose -repos_user sysman -output_file /u01/app/oracle/product/emgrid/oms10g/sysman/log/emrepmgr.log.10.2.0.5.0 failed. Exit code: expected [0 ], but got 50
INFO: oracle.sysman.top.oms:EmcpPlug:invoke:Completed EmcpPlug invoke method on an aggregate=oracle.sysman.top.oms for Action=patchsetConfiguration in step=1:microstep=0
INFO: oracle.sysman.top.oms:Internal PlugIn for {Micro Step state:step:1:patchsetConfiguration in CfmAggregateInstance: oracle.sysman.top.oms:10.2.0.5.0:common:family=CFM:oh=/u01/app/oracle/product/emgrid/oms10g:label=3} failed with an unhandled exception:
java.lang.Exception: Command: /u01/app/oracle/product/emgrid/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))) -action upgrade -no_transx -no_verify -verbose -repos_user sysman -output_file /u01/app/oracle/product/emgrid/oms10g/sysman/log/emrepmgr.log.10.2.0.5.0 failed. Exit code: expected [0 ], but got 50
at oracle.sysman.emcp.util.EmcpPlug.startProcessing(EmcpPlug.java:389)
at oracle.sysman.emcp.util.EmcpPlug.invoke(EmcpPlug.java:360)
at oracle.sysman.emCfg.core.PerformMicroStep.runJavaClass(PerformMicroStep.java:540)
at oracle.sysman.emCfg.core.PerformMicroStep.executeMicroStep(PerformMicroStep.java:120)

Solution:

Use the right procedure to change the sysman password

References:

Note 803063.1

book E14646-01 

Get Oracle Certifications for all Exams
Free Online Exams.com

FRM-92150 : Web Client Version Too New after migrating from Jinitiation to J2SE (j2se16013).

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    

FRM-92150 : Web Client Version Too New after migrating from Jinitiation to J2SE (j2se16013). and upgraded the forms session from patchset 17 to 18

Symptoms:

1. 1st time start of the forms session no issue.
2. logout and relogin.
3. opens forms session getting FRM-92150

 

Solution:

Use adadmin utility to :
- regenerate jar files - select YES when prompted to force generation of jar files.
- relink FND binaries
- recompile apps schema (recommended)
- regenerate FND forms and pll's

2. Clear Oracle jinitiator cache on client machine - typically c:\programs\oracle\jinit...\jcache .
3. Clear browser cache.
4. Bounce Oracle application services.
5. Re-test the issue.

If the above does not work, go for the below:

1. relink f60webmx executable and retest. If the issue still exists please go to step 2.
adrelink.sh force=y link_debug=y "fnd f60webmx"

2. follow the Note 209810.1 How to Relink Oracle Applications 11i Programs After Upgrade or Patch of the UNIX Operating System to relink the Oracle8 (8.0.6) programs and relink the Oracle Applications 11i programs.

If the above does not work, go for the below:

Apply Developer 6i patch for patchset 19 :-
6194129
Additional Patches:-
7423534 -( This patch need to be applied first in Additional Patches)
8402746
6125732
6857221
7657973
7343387 (Interoperability Patch)

Please also review the Note 788151.1 After Applying Forms 6i Patchset : FRM-92150 : Web Client Version Too New.

References:

Note 788151.1 After Applying Forms 6i Patchset : FRM-92150 : Web Client Version Too New
Note 469329.1 After Applying Forms 6i Patchset : FRM-92150 : Web Client Version Too New
Note 148428.1 Cannot log into Oracle Applications Getting FRM-92150 WEB .

Get Oracle Certifications for all Exams
Free Online Exams.com

How to get Output Post Processor log file

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

How to get Output Post Processor log file:

a. Navigate to Concurrent Manager Administer -> Select the Output Post Processor.

b. Choose the "Processes" button. Select the process that was active during the time you are interested in.

c. Choose the "Manager Log" button.

Get Oracle Certifications for all Exams
Free Online Exams.com

XML publisher completing in Warning when data size is big. One or more post processing actions failed java.lang.OutOfMemoryError

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    XML publisher completing in Warning when data size is big. One or more post processing actions failed java.lang.OutOfMemoryError

XML Publisher Report completes in Warning when data size is big with generic message, one or more post processing actions failed. Consult the opp log for details.

Using 11.5.10.2 RUP 6 , XML Publisher Report completes in Warning when data size is big with generic message,one or more post processing actions failed.consult the opp log for details.

REP-0151: Duplicate argument specification for keyword 'REPORT'.

 

Log files:

FILE NAME: FNDOPP80221.txt
--------------------------------------------------

[6/17/09 6:54:42 AM] [main] Starting GSF service with concurrent process id = 80221.
[6/17/09 6:54:42 AM] [main] Initialization Parameters: oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=5
[6/17/09 6:54:42 AM] [Thread-12] Service thread starting up.
[6/17/09 6:54:42 AM] [Thread-13] Service thread starting up.
[6/17/09 8:32:38 AM] [OPPServiceThread1] Post-processing request 6012285.
[6/17/09 8:32:39 AM] [80221:RT6012285] Executing post-processing actions for request 6012285.
[6/17/09 8:32:39 AM] [80221:RT6012285] Starting XML Publisher post-processing action.
[6/17/09 8:32:39 AM] [80221:RT6012285]
Template code: XXFINARXAGE
Template app: XXFIN
Language: en
Territory: US
Output type: PDF
[061709_083239910][][EXCEPTION] [DEBUG] ------- Preferences defined PreferenceStore -------
[061709_083239911][][EXCEPTION] [DEBUG] ------- Environment variables stored in EnvironmentStore -------
[061709_083239911][][EXCEPTION] [DEBUG] [FND_JDBC_IDLE_THRESHOLD.LOW]:[-1]
[061709_083239911][][EXCEPTION] [DEBUG] [SECURITY_GROUP_ID]:[0]
[061709_083239911][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_DECAY_INTERVAL]:[60]
[061709_083239912][][EXCEPTION] [DEBUG] [NLS_CHARACTERSET]:[UTF8]
[061709_083239912][][EXCEPTION] [DEBUG] [RESP_APPL_ID]:[-1]
[061709_083239912][][EXCEPTION] [DEBUG] [NLS_LANGUAGE]:[AMERICAN]
[061709_083239912][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MIN]:[1]
[061709_083239912][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MAX]:[2]
[061709_083239912][][EXCEPTION] [DEBUG] [NLS_NUMERIC_CHARACTERS]:[.,]
[061709_083239912][][EXCEPTION] [DEBUG] [APPS_JDBC_URL]:[jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=jaorddu1.dpa.co.ae)(PORT=1541)))(CONNECT_DATA=(SID=PTYD)))]
[061709_083239912][][EXCEPTION] [DEBUG] [RESP_ID]:[-1]
[061709_083239913][][EXCEPTION] [DEBUG] [FND_MAX_JDBC_CONNECTIONS]:[500]
[061709_083239913][][EXCEPTION] [DEBUG] [FND_JDBC_USABLE_CHECK]:[true]
[061709_083239913][][EXCEPTION] [DEBUG] [USER_ID]:[-1]
[061709_083239913][][EXCEPTION] [DEBUG] [NLS_TERRITORY]:[AMERICA]
[061709_083239913][][EXCEPTION] [DEBUG] [FND_JDBC_PLSQL_RESET]:[false]
[061709_083239913][][EXCEPTION] [DEBUG] [FND_JDBC_CONTEXT_CHECK]:[true]
[061709_083239913][][EXCEPTION] [DEBUG] [NLS_DATE_FORMAT]:[DD-MON-RR]
[061709_083239913][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_DECAY_SIZE]:[1]
[061709_083239914][][EXCEPTION] [DEBUG] [FND_JDBC_IDLE_THRESHOLD.HIGH]:[-1]
[061709_083239914][][EXCEPTION] [DEBUG] [NLS_SORT]:[BINARY]
[061709_083239914][][EXCEPTION] [DEBUG] [NLS_DATE_LANGUAGE]:[AMERICAN]
[061709_083239914][][EXCEPTION] [DEBUG] [LOGIN_ID]:[-1]
[061709_083239914][][EXCEPTION] [DEBUG] ------- Properties stored in Java System Properties -------
[061709_083239914][][EXCEPTION] [DEBUG] [APPLTMP]:[/u03/ptyd/ptydcomn/temp]
[061709_083239914][][EXCEPTION] [DEBUG] [java.runtime.name]:[Java(TM) 2 Runtime Environment, Standard Edition]
[061709_083239914][][EXCEPTION] [DEBUG] [sun.boot.library.path]:[/opt/java1.4/jre/lib/PA_RISC2.0]
[061709_083239915][][EXCEPTION] [DEBUG] [java.vm.version]:[1.4.2 1.4.2.09-050713-05:46-PA_RISC2.0 PA2.0 (aCC_AP)]
[061709_083239915][][EXCEPTION] [DEBUG] [OVERRIDE_DBC]:[true]
[061709_083239916][][EXCEPTION] [DEBUG] [dbcfile]:[/u03/ptyd/ptydappl/fnd/11.5.0/secure/PTYD_jaoradu1/jaorddu1_ptyd.dbc]
[061709_083239916][][EXCEPTION] [DEBUG] [java.vm.vendor]:[Hewlett-Packard Company]
[061709_083239916][][EXCEPTION] [DEBUG] [java.vendor.url]:[http://www.hp.com/go/Java]
[061709_083239916][][EXCEPTION] [DEBUG] [path.separator]:[:]
[061709_083239916][][EXCEPTION] [DEBUG] [APPLCSF]:[/u03/ptyd/ptydcomn/admin]
[061709_083239916][][EXCEPTION] [DEBUG] [java.vm.name]:[Java HotSpot(TM) Server VM]
[061709_083239916][][EXCEPTION] [DEBUG] [file.encoding.pkg]:[sun.io]
[061709_083239916][][EXCEPTION] [DEBUG] [sun.os.patch.level]:[unknown]
[061709_083239917][][EXCEPTION] [DEBUG] [user.dir]:[/u03/ptyd/ptydcomn/admin/log/PTYD_jaoradu1]
[061709_083239917][][EXCEPTION] [DEBUG] [java.vm.specification.name]:[Java Virtual Machine Specification]
[061709_083239917][][EXCEPTION] [DEBUG] [java.runtime.version]:[1.4.2.09-050713-03:34]
[061709_083239917][][EXCEPTION] [DEBUG] [java.awt.graphicsenv]:[sun.awt.X11GraphicsEnvironment]
[061709_083239917][][EXCEPTION] [DEBUG] [java.endorsed.dirs]:[/opt/java1.4/jre/lib/endorsed]
[061709_083239917][][EXCEPTION] [DEBUG] [os.arch]:[PA_RISC2.0]
[061709_083239917][][EXCEPTION] [DEBUG] [JTFDBCFILE]:[/u03/ptyd/ptydappl/fnd/11.5.0/secure/PTYD_jaoradu1/jaorddu1_ptyd.dbc]
[061709_083239917][][EXCEPTION] [DEBUG] [java.io.tmpdir]:[/var/tmp/]
[061709_083239918][][EXCEPTION] [DEBUG] [line.separator]:[
]
[061709_083239918][][EXCEPTION] [DEBUG] [java.vm.specification.vendor]:[Sun Microsystems Inc.]
[061709_083239918][][EXCEPTION] [DEBUG] [os.name]:[HP-UX]
[061709_083239918][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MIN]:[1]
[061709_083239918][][EXCEPTION] [DEBUG] [sun.java2d.fontpath]:[]
[061709_083239918][][EXCEPTION] [DEBUG] [cpid]:[80221]
[061709_083239918][][EXCEPTION] [DEBUG] [runtime]:[aCC_AP]
[061709_083239918][][EXCEPTION] [DEBUG] [java.library.path]:[/opt/java1.4/jre/lib/PA_RISC2.0:/opt/java1.4/jre/lib/PA_RISC2.0/server:/opt/java1.4/jre/../lib/PA_RISC2.0:/u03/ptyd/ptydora/iAS/lib:/u03/ptyd/ptydora/8.0.6/network/jre11/lib/PA_RISC/native_threads:/u03/ptyd/ptydappl/cz/11.5.0/bin::/u03/ptyd/ptydora/8.0.6/lib:/usr/lib:/usr/lib]
[061709_083239919][][EXCEPTION] [DEBUG] [java.specification.name]:[Java Platform API Specification]
[061709_083239919][][EXCEPTION] [DEBUG] [java.class.version]:[48.0]
[061709_083239919][][EXCEPTION] [DEBUG] [java.util.prefs.PreferencesFactory]:[java.util.prefs.FileSystemPreferencesFactory]
[061709_083239919][][EXCEPTION] [DEBUG] [os.version]:[B.11.23]
[061709_083239919][][EXCEPTION] [DEBUG] [LONG_RUNNING_JVM]:[true]
[061709_083239919][][EXCEPTION] [DEBUG] [user.home]:[/home/applptyd]
[061709_083239919][][EXCEPTION] [DEBUG] [user.timezone]:[GMT+04:00]
[061709_083239920][][EXCEPTION] [DEBUG] [java.awt.printerjob]:[sun.print.PSPrinterJob]
[061709_083239920][][EXCEPTION] [DEBUG] [file.encoding]:[8859_1]
[061709_083239920][][EXCEPTION] [DEBUG] [java.specification.version]:[1.4]
[061709_083239920][][EXCEPTION] [DEBUG] [CACHEMODE]:[DISTRIBUTED]
[061709_083239920][][EXCEPTION] [DEBUG] [user.name]:[applptyd]
[061709_083239920][][EXCEPTION] [DEBUG] [java.class.path]:[/opt/java1.4/lib/dt.jar:/opt/java1.4/lib/tools.jar:/opt/java1.4/jre/lib/rt.jar:/opt/java1.4/jre/lib/charsets.jar:/u03/ptyd/ptydcomn/java/appsborg2.zip:/u03/ptyd/ptydcomn/java/apps.zip:/u03/ptyd/ptydora/8.0.6/forms60/java:/u03/ptyd/ptydcomn/java]
[061709_083239920][][EXCEPTION] [DEBUG] [DBCFILE]:[/u03/ptyd/ptydappl/fnd/11.5.0/secure/PTYD_jaoradu1/jaorddu1_ptyd.dbc]
[061709_083239921][][EXCEPTION] [DEBUG] [java.vm.specification.version]:[1.0]
[061709_083239921][][EXCEPTION] [DEBUG] [java.home]:[/opt/java1.4/jre]
[061709_083239921][][EXCEPTION] [DEBUG] [sun.arch.data.model]:[32]
[061709_083239921][][EXCEPTION] [DEBUG] [user.language]:[en]
[061709_083239922][][EXCEPTION] [DEBUG] [java.specification.vendor]:[Sun Microsystems Inc.]
[061709_083239922][][EXCEPTION] [DEBUG] [java.vm.info]:[mixed mode]
[061709_083239922][][EXCEPTION] [DEBUG] [logfile]:[/u03/ptyd/ptydcomn/admin/log/PTYD_jaoradu1/FNDOPP80221.txt]
[061709_083239922][][EXCEPTION] [DEBUG] [java.version]:[1.4.2.09]
[061709_083239922][][EXCEPTION] [DEBUG] [java.ext.dirs]:[/opt/java1.4/jre/lib/ext]
[061709_083239922][][EXCEPTION] [DEBUG] [sun.boot.class.path]:[/opt/java1.4/jre/lib/rt.jar:/opt/java1.4/jre/lib/i18n.jar:/opt/java1.4/jre/lib/sunrsasign.jar:/opt/java1.4/jre/lib/jsse.jar:/opt/java1.4/jre/lib/jce.jar:/opt/java1.4/jre/lib/charsets.jar:/opt/java1.4/jre/classes]
[061709_083239922][][EXCEPTION] [DEBUG] [java.vendor]:[Hewlett-Packard Co.]
[061709_083239923][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MAX]:[2]
[061709_083239923][][EXCEPTION] [DEBUG] [file.separator]:[/]
[061709_083239923][][EXCEPTION] [DEBUG] [java.vendor.url.bug]:[http://www.hp.com/go/Java]
[061709_083239923][][EXCEPTION] [DEBUG] [sun.io.unicode.encoding]:[UnicodeBig]
[061709_083239923][][EXCEPTION] [DEBUG] [sun.cpu.endian]:[big]
[061709_083239923][][EXCEPTION] [DEBUG] [APPLOUT]:[out/PTYD_jaoradu1]
[061709_083239923][][EXCEPTION] [DEBUG] [sun.cpu.isalist]:[pa2.0 pa1.2 pa1.1 pa1.0]
[6/17/09 8:37:44 AM] [UNEXPECTED] [80221:RT6012285] java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:517)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:224)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:177)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1044)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:997)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)
at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1657)
at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:967)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5888)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3438)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3527)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:247)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:157)
Caused by: java.lang.OutOfMemoryError

[6/17/09 8:37:45 AM] [80221:RT6012285] Completed post-processing actions for request 6012285.
[6/17/09 10:47:54 AM] [OPPServiceThread1] Post-processing request 6012954.
[6/17/09 10:47:55 AM] [80221:RT6012954] Executing post-processing actions for request 6012954.
[6/17/09 10:47:55 AM] [80221:RT6012954] Starting XML Publisher post-processing action.
[6/17/09 10:47:55 AM] [80221:RT6012954]
Template code: XXFINPLXXNOFFEM
Template app: PN
Language: en
Territory: US
Output type: PDF
[6/17/09 10:48:04 AM] [80221:RT6012954] XML Publisher post-processing action complete.
[6/17/09 10:48:04 AM] [80221:RT6012954] Completed post-processing actions for request 6012954.
[6/17/09 1:52:58 PM] [OPPServiceThread1] Post-processing request 6043871.
[6/17/09 1:52:58 PM] [80221:RT6043871] Executing post-processing actions for request 6043871.
[6/17/09 1:52:58 PM] [80221:RT6043871] Starting XML Publisher post-processing action.
[6/17/09 1:52:58 PM] [80221:RT6043871]
Template code: XXFINARXAGE
Template app: XXFIN
Language: en
Territory: US
Output type: PDF
java.lang.OutOfMemoryError
java.lang.OutOfMemoryError
[6/17/09 1:54:54 PM] [UNEXPECTED] [80221:RT6043871] java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:517)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:224)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:177)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1044)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:997)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)
at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1657)
at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:967)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5888)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3438)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3527)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:247)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:157)
Caused by: java.lang.OutOfMemoryError

[6/17/09 1:54:54 PM] [80221:RT6043871] Completed post-processing actions for request 6043871.
[6/17/09 2:53:31 PM] [OPPServiceThread1] Post-processing request 6049888.
[6/17/09 3:04:15 PM] [OPPServiceThread0] Post-processing request 6050871.
[6/17/09 3:27:26 PM] [OPPServiceThread1] Post-processing request 6056871.
[6/17/09 3:27:26 PM] [80221:RT6056871] Executing post-processing actions for request 6056871.
[6/17/09 3:27:26 PM] [80221:RT6056871] Starting XML Publisher post-processing action.
[6/17/09 3:27:26 PM] [80221:RT6056871]
Template code: XXFINARXAGE
Template app: XXFIN
Language: en
Territory: US
Output type: PDF
[6/17/09 3:27:34 PM] [80221:RT6056871] XML Publisher post-processing action complete.
[6/17/09 3:27:34 PM] [80221:RT6056871] Completed post-processing actions for request 6056871.
[6/17/09 3:30:16 PM] [OPPServiceThread0] Post-processing request 6057871.
[6/17/09 3:36:09 PM] [OPPServiceThread0] Post-processing request 6056874.

Solution:

1. Determine what the heap size per OPP process is currently:
select DEVELOPER_PARAMETERS from FND_CP_SERVICES
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

2. The default should be: J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx512m

3. Increase the Heap Space per Process to 1024:

update FND_CP_SERVICES
set DEVELOPER_PARAMETERS ='J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx1024m'
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

4. Increase the values for these profiles for at least 2 hours each:
Concurrent:OPP Process Timeout
Concurrent:OPP Response Timeout

5.Run cmclean.sql and bounce the concurrent managers

References:

Note 304099.1 Using J2SE Version 5.0 with Oracle E-Business Suite 11i
Note 401561.1 Using J2SE Version 6.0 with Oracle E-Business Suite 11i
Note 315477.1 Ext/Pub XML Report Publisher Fails With java.lang.OutOfMemoryError:This note could work for this since they are on BIP 5.6.1
Note 371303.1 Ext/Pub Xml Publisher Receives Out Of Memory Java Error After Running A Number Of Jobs:
Note 387190.1 Ext/Pub Output Post Processor Fails with java.lang.OutOfMemoryError for Large Reports:
Note 549990.1 Int/Pub Java.Lang.Out of memoryerror Java Heap Space When Running Large Bi Pub Reports:

Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-20001 Unable to call fnd_ldap_wrapper.update_user, unable to use sso

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    

ORA-20001 Unable to call fnd_ldap_wrapper.update_user, unable to use sso

Symptoms:

1. Successfully applied SSO patch p6117031 as a part of post patch of RUP6.

2. While updating the users password from frontend got the following error.

Unable to call fnd_ldap_wrapper.update_user due to the following reason:
ORA-20001: Unable to call fnd_ldap_wrapper.create_user due to the following
reason:An unexpected error occurred. Please contact your System Administrator

while updating the password with FNDCPASS, it give errors OID is not registered.


3. Done the following deregister and register to SSO/OID

i. txkrun.pl -script=SetSSOReg \
-deregistersso=Yes \

--- successfully executed this script

ii. txkrun.pl -script=SetSSOReg \
-deregisteroid=Yes \

--- successfully executed this script


iii. txkrun.pl -script=SetSSOReg \
-registersso=Yes \


iv. txkrun.pl -script=SetSSOReg \
-registeroid=Yes \

-- This give as partner application already registered.


But SSO login is not working and also update/Create user give same error.

Link on the fly means to have profile ''Applications SSO Auto Link User' to Enabled in order to populate -at first login- USER_GUID column in FND_USER table as long as the user exists in OID and has an orclguid, regardless if you are using WNA or other 3rd party LDAP integration. You really need to have the user in OID and have a valid orclguid otherwise you won't be able to perform the authentication. At this moment the user is not in OID so the link on the fly is not working.

Log files:

Review the FND: Debug files while reproducing the issue by

Connected as System Administrator, modify the following system profiles:
FND: Debug Log Enabled Yes
FND: Debug Log Filename <empty>
FND: Debug Log Level STATEMENT
FND: Debug Log Mode Asynchronous with Cross-Tier Sequencing
FND: Debug Log Module % or fnd%

There is no need to stop and restart E-Business Suite.

All log information will be created in the table FND_LOG_MESSAGES. A typical query might be

SQL> select module||' '||message_text from fnd_log_messages
order by timestamp;

Solution:

1 Applications SSO type profile was set to SSWA instead of SSWA w/SSO so SSO login page was not working. Change it to SSWA w/SSO and we will get the SSO login page.

- However, after doing that the SSO authentication didn't work. This was because Link on the fly feature was disabled. We set 'Applications SSO Auto Link User' to Enabled, but still the same problem and the error came up when updating the password for the users.

2  Then the user did not exist in OID so the SSO authentication could not be performed.

 follow chapter 'Migrating Data between Oracle E-Business Suite Release 11i and Oracle Internet Directory' from Note 261914.1 and then to set profile Applications SSO Auto Link User' to Enabled This way Link on the fly feature should take care of the user password and authentication.

3  removereference

4 txkrun.pl -script=SetSSOReg -provtmp=$FND_TOP/admin/template/ProvBiDiNoCreation.tmp

References:

Follow chapter 'Migrating Data between Oracle E-Business Suite Release 11i and Oracle Internet Directory' from Note 261914.1

Get Oracle Certifications for all Exams
Free Online Exams.com

Databases shows status is down “There has been a user-initiated shutdown”

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    databases shows status is down “There has been a user-initiated shutdown”

Symptoms:

After Upgrading EMGC to 10.2.0.5, some databases shows status is down with "There has been a user-initiated shutdown." while databases are really UP

Log files:

emagent_perl.trc:
-------------------------
maxRowCount.pl: Mon Jun 15 15:29:04 2009: ERROR: Max Count Value not set properly in file /u01/app/oracle/product/agent10g/sysman/config/esa/database.properties line no. 68

emdctl.trc
-----------------

2008-08-04 13:49:40,163 Thread-1 ERROR main: nmectla_agentctl: Error connecting to http://jctpdb01.dubaiworld.ae:3872/emd/main/. Returning status code 1
2

2008-12-02 07:02:48,343 Thread-1 ERROR http: 6: Unable to initialize ssl connection with server, aborting connection attempt

emoms.trc:
----------------
2009-06-14 16:46:41,588 [EMUI_16_46_41_/console/targets$ctxType=Hosts] ERROR target.TargetData getTargets.958 - ORA-20001: Error in get_metrics_summary: ORA-28112: failed to execute policy function
ORA-06512: at "SYSMAN.EMD_MNTR", line 9666
ORA-06512: at line 1

java.sql.SQLException: ORA-20001: Error in get_metrics_summary: ORA-28112: failed to execute policy function
ORA-06512: at "SYSMAN.EMD_MNTR", line 9666
ORA-06512: at line 1

2009-06-15 15:20:10,871 [EMUI_15_20_10_/console/database/instance/sitemap] ERROR svlt.PageHandler handleRequest.640 - java.lang.NullPointerException
java.lang.NullPointerException

2009-06-15 15:20:10,855 [EMUI_15_20_10_/console/database/instance/sitemap] ERROR perf.sitemap logp.251 - Failed to initialize object: ORA-28112: failed to execute policy function
ORA-06512: at "SYSMAN.EMD_DATABASE", line 1166
ORA-06512: at line 1

2009-06-15 15:00:17,967 [AJPRequestHandler-ApplicationServerThread-957] ERROR eml.OMSHandshake processFailure.843 - OMSHandshake failed.(AGENT URL = https://pebpbp02.dubaiworld.ae:3872/emd/main/)(ERROR = INTERNAL_ERROR)(CAUSE =java.sql.SQLException: ORA-28112: failed to execute policy function

2009-06-15 14:43:22,151 [EMUI_14_43_22_/console/database/instance/instanceActivity] ERROR perf.instAct logp.251 - oracle.sysman.emo.perf.metric.eng.MetricCollectorTimeoutException

emagent.trc
-------------------
2009-06-15 15:29:03,246 Thread-20 ERROR : (nmecmgr.c,3207):Memory 0x0 encountered, expect struct_id=11011

Solution:

Hitting a Bug 5890966 for DB versions 10.2.0.2 and 10.2.0.3, so we need to apply one-off patch for the DB and another one for the agent

-- To implement the solution, please execute the following steps::
1.Download the needed patch:
- There are patches for Bug 5890966 for DB versions 10.2.0.2 and 10.2.0.3.
- download the one-off Patch 5890966 or upgrade to 10.2.0.4 version for the
target database.
- download Patch 7012242 for the agent.
- Check if there are any errors while accessing the job activity tab in grid
control.
2.Stop the OMS
3.stop the agent
4 .Follow the instructions the in Readme and apply the patchs
5.Restart all EM components and monitor again the error.

Get Oracle Certifications for all Exams
Free Online Exams.com