Oracle World: Oct 10, 2011

Monday, October 10, 2011

How to Trace / Debug the OUI (runInstaller) for a Grid Control Installation

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:
How to Trace / Debug the OUI (runInstaller) for a Grid Control Installation

Solution:

When installing Grid Control components (Agent, OMS, Repository), it is sometimes necessary to run the installer in a debug mode in order to obtain the necessary troubleshooting data.

To set the OUI for debug mode, follow these steps:
1. Check the file /etc/oraInst.loc or /var/opt/oracle/oraInst.loc to determine the location of the OraInventory/logs directory.
Rename the existing logs directory and create a new one.
2. Start the OUI using the following command
./runInstaller -debug -logLevel finest >inst1.out 2>inst2.out

3. Let the installation proceed until the error occurs again.
4. Compress the following into one single zip file and upload:
inst1.out
inst2.out
/oraInventroy/logs/* (files and subdirectories)
from all (db, oms, agent)
ORACLE_HOMES/cfgtoolslog/* (files and subdirectories)
from
oms_ORACLE_HOME/sysman/log
5. Upload the zip file to Metalink when you create the SR.

References:

How to Trace / Debug the OUI (runInstaller) for a Grid Control Installation [ID 351737.1]

Get Oracle Certifications for all Exams
Free Online Exams.com

Issue in launching multiple IE8 sessions for SSO Protected applications

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: Issue in launching multiple IE8 sessions for SSO Protected applications

Symptoms:
Find below steps to reproduce the problem with default oiddas

1. Open IE browse and access the OIDDAS page
2. Click on Login button and provide the credentials
3. Open a new IE browser windows/tab
4. access the OIDDAS page

you will not be challenged in IE8. But in IE6 the user will be challenged with credentials page.

"-nomerge' option with IE8 is not a acceptable solution as we cannot request end users to perform the same. Our applications are internet based.

Solution:

This is an expected behavior with sso, this is how OSSO works with cookies.

It is how all single sign-on systems work with cookies.IE8 just works like firefox does.

The "-nomerge" is the only option and then only valid for IE8. If you want E6 behaviour with SSO "-nomerge" is the solution.

On the other hand having multiple users on the same PC is not a secure solution. So you want a proper solution suggest you to look at Oracle Enterprise Single Sign-On Kiosk Manager to use together with OSSO.

Get Oracle Certifications for all Exams
Free Online Exams.com

HOW TO HANDLE CORE DUMPS ON UNIX

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: HOW TO HANDLE CORE DUMPS ON UNIX

Symptoms:

A core dump is an image copy of the state of a process, which is produced if
the process attempts to do something not allowed by the Operating System. The process information is written to a file named "core", which is usually
created in the current working directory of the process.

Some of the things a program might attempt to do that would cause a core dump
include: trying to execute an illegal/unknown instruction, trying to access
memory outside the allowed range, or trying to use an unavailable resource.

A core file contains much information to aid in determining why a process
crashed. One of the things contained in a core file is a called stack trace,
which identifies what commands a process has, or was attempting to execute.

Sometimes a trace file is automatically produced by an Oracle process, and is
normally indicated with an ORA-07445 error. When this occurs, a file with the extension ".trc" will be produced. To find this file, check your
init.ora for the parameters "user_dump_dest" and "background_dump_dest".
The trace file will typically be located in one of these directories.

A trace file is not always produced automatically, and the solution of this
article will discuss how to manually produce a call stack trace.

Search Words:
=============

segmentation fault
ORA-7445
dbx gdb dde adb sdb debug
debugger

Log files:

Solution:

Before attempting to manually create a stack trace from a core file, please
verify the following:

* Your swap space is 2 to 3 times the amount of physical memory (RAM)
installed on the system, or whichever is greater of the following
2 items: 1GB or 2 times the size of all SGAs combined.

You can approximate the size of an SGA with this formula:

((db_block_size * db_block_buffers)+shared_pool+log_buffers)/.9

For help with how to check swap space, refer to PRE 1016233.6.

* You are using a supported compiler/linker. Check the Installation
Guide for Operating System requirements.

NOTE: On Solaris systems, make sure that "/usr/ccs/bin" is
before "/usr/ucb" in the PATH environment variable.
You can confirm this using the following command:

% which ld

The path returned should be "/usr/ccs/bin/ld".

* You have at least 50MB of free space available in "/tmp".

Creating a Stack Trace from a Core File
=======================================

To create a stack trace from a core file, perform the following steps:

1. Determine which executable program caused the core dump:

To determine which executable caused a core dump, change to the
directory where the core file is located, and use the "file"
command.

For example, if you had a core file in your home directory,
"/home/user", use the following commands:

% cd /home/user
% file core

core: ELF 32-bit MSB core file SPARC Version 1, from 'sqlplus'

The "from" information indicates that 'sqlplus' caused the core
dump.

(a) If your system does not display "from" information when using
the "file" command, and your are NOT using SCO UNIX, try the
following command instead:

% cd /home/user
% strings core | head -10

CORE
CORE
CORE
sqlplus <<----- first executable program sqlplus -h system-23_getm TERM=xterms console ORACLE_HOME guicommon/tk2 /SQLPlus/mesg/SP2US.msb This will display the first 10 text entries in the core file. Start at the first line and look for an entry which is an executable program. In the example above, 'sqlplus' caused the core dump. (b) If you are using SCO UNIX, use the following command instead: % cd /home/user % strings core | head -75 | tail -25 2. Determine which debugger exists on your system. There are many different debuggers in the UNIX world. Look at the list below of the most common debuggers, then check your system for one of them. Common debuggers ================ dbx, gdb, dde, adb, sdb, debug If these debuggers exist on your system, they would most likely be located in one of the following directories: /bin, /usr/bin, /opt/langtools/bin, /usr/ccs/bin, /usr/ucb To search your system for a debugger, you can use the "which" command, which will search only the directories in your current PATH, or the "find" command, which can search the entire system. For example, to search for the dbx debugger: % which dbx no dbx ... % find / -name "dbx" -print /usr/ccs/bin/dbx 3. Now that you have located a debugger, you are ready to use it to produce the stack trace. The Unix command "script" will capture the output of a terminal session and write it to a file. You will use "script" to capture the output of the debugger as shown below. First change directories to the location where the core file is located. 4. The next step depends upon which debugger you are using: (a) If you are NOT using the "dde" or "debug" debugger, do this: ------------------------------------------------------------ % script mystack.trc % $ORACLE_HOME/bin/ core

where is the debugger you are using, and
is the executable program which caused the core dump.

(b) If you are using the "dde" debugger, use this command:
------------------------------------------------------

% script mystack.trc
% dde -ui line core $ORACLE_HOME/bin/

(c) If you are using the "debug" debugger, use this command:
--------------------------------------------------------

% script mystack.trc
% debug -c core $ORACLE_HOME/bin/

where is not entered, unless "debug" starts
an X window session, in which case equals
"-i c".

5. Now look at the table below and find your debugger in the first
column, then enter the command in the second column to produce the
stack trace.

debugger command to produce stack
======== ========================
dbx where
gdb bt
dde tb
adb $c
sdb t
debug stack

6. Exit the debugger program:

- if you are using the "adb" debugger, exit using -D

- if you are using any of the other debuggers, exit with the
command "q"

7. After exiting the debugger, issue the command "exit" at the shell
prompt. You should receive a "Script Done" message.

You now have a stack trace in the file named "mystack.trc", and you can send
this file to Oracle Support for further analysis.

Solution Explanation:
=====================

The call stack trace in the "mystack.trc" file can be useful to Oracle Support
in determining why a core dump from an Oracle product occurred.

References:

HOW TO HANDLE CORE DUMPS ON UNIX [ID 1007808.6]

Get Oracle Certifications for all Exams
Free Online Exams.com

"Purge Concurrent Request And/Or Manager Data" Fails With "Signal 11"

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:
"Purge Concurrent Request And/Or Manager Data" Fails With "Signal 11"

Symptoms:
Running "Purge Concurrent Request and/or Manager Data" with the following parameters
Entity=All
Mode=Age
Mode Value=21

Causes the request to fail as follows:

+---------------------------------------------------------------------------+
Application Object Library: Version : 11.5.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

FNDCPPUR module: Purge Concurrent Request and/or Manager Data
+---------------------------------------------------------------------------+

Current system time is 05-FEB-2008 09:49:41

+---------------------------------------------------------------------------+

Purged 386 entrie(s) from FND_CONCURRENT_REQUESTS :-05-FEB-2008 09:50:03
Purged 0 entrie(s) from FND_FILE_TEMP :-05-FEB-2008 09:50:03
/u02/PROD/appltop/fnd/11.5.0/bin/FNDCPPUR
Program was terminated by signal 11

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 05-FEB-2008 09:50:04

+---------------------------------------------------------------------------+

Solution:

Missing the entry in the tnsnames.ora or file pointing the same listener
The application listener has to be started in all nodes. if SALORAPRD1 and SALORARG1 is the same node then and the customer is using the same application listener then they have to be the entry in the tnsnames.ora or ifile pointing the same listener, so he has to change then the entries of SALORAPRD1 pointing to salorarg1 or the node when is pointing the listener.

for example for FNDFS_SALORAPRD1.pace.internal the right entry have to be similar that

FNDFS_SALORAPRD1.pace.internal=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=salorarg1.pace.internal)(PORT=1626))
(CONNECT_DATA=
(SID=FNDFS)
)
)
References:

"Purge Concurrent Request And/Or Manager Data" Fails With "Signal 11" [ID 556118.1]

Get Oracle Certifications for all Exams
Free Online Exams.com

FNDCPPUR (Purge Concurrent Request and/or Manager Data) Program was terminated by signal 11

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:
FNDCPPUR (Purge Concurrent Request and/or Manager Data) Program was terminated by signal 11

Symptoms:
EBS 11.5.10.2 running on HP-UX PA-RISC (64-bit)
RAC Database - 2 nodes and Application --- > Shared APPL_TOP with 2 nodes

FNDCPPUR (Purge Concurrent Request and/or Manager Data) Program was terminated by signal 11

Log files:
+---------------------------------------------------------------------------+
Application Object Library: Version : 11.5.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

FNDCPPUR module: Purge Concurrent Request and/or Manager Data
+---------------------------------------------------------------------------+

Current system time is 23-NOV-2010 12:58:48

+---------------------------------------------------------------------------+

/APPL_TOP/ezwp/ezwpappl/fnd/11.5.0/bin/FNDCPPUR
Program was terminated by signal 11

+---------------------------------------------------------------------------+
Executing request completion options...

Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 23-NOV-2010 12:58:55

+---------------------------------------------------------------------------+

FileName
----------------
Purge_Concurrent_Request_and_o_231110.txt

FileComment
----------------------

Solution:

Per Bug 2713549:
If rows have been removed from fnd_concurrent_processes without removing
their fnd_env_context counterparts, then the fnd_env_context rows would need
to be cleaned up manually. Bring down the managers, truncate the fnd_env_context table, and
then restart the managers. This will start you off with a clean slate.

References:

"Purge Concurrent Request And/Or Manager Data" Fails With "Signal 11" [ID 556118.1]

Get Oracle Certifications for all Exams
Free Online Exams.com

How To create and associate a temporary file with a temporary tablespace on a read-only physical standby database

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:

How To create and associate a temporary file with a temporary tablespace on a read-only physical standby database

Symptoms:
Create a Temporary Tablespace
To create temporary tablespace files, find the temporary tablespaces from the dba_tablespaces view. For all of the temporary tablespaces defined in the primary database, datafiles will need to be added in the logical standby database. This is because the temporary tablespace files are not backed up or copied to the standby site

Solution:

To create a temporary tablespace for use on a read-only physical standby database

If you did not have a temporary tablespace on the primary database when you created the physical standby database, perform the following steps on the primary database:
1. Enter the following SQL statement:
2. SQL> CREATE TEMPORARY TABLESPACE temp1
3. TEMPFILE '/disk1/oracle/dbs/temp1.dbf'
4. SIZE 20M REUSE
5. EXTENT MANAGEMENT LOCAL UNIFORM SIZE 16M;
6.
2. Switch the log to send the redo data to the standby database:
SQL> ALTER SYSTEM SWITCH LOGFILE;
To create and associate a temporary file with a temporary tablespace on a read-only physical standby database

The redo data that is generated on the primary database automatically creates the temporary tablespace in the standby control file after the archived redo log is applied to the physical standby database. However, even if the temporary tablespace existed on the primary database before you created the physical standby database, you must use the ADD TEMPFILE clause to actually create the disk file on the standby database.

On the physical standby database, perform the following steps:
1. Start managed recovery, if necessary, and apply the archived redo logs by entering the following SQL statement:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE;

2. Cancel managed recovery and open the physical standby database for read-only access using the following SQL statements:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> ALTER DATABASE OPEN READ ONLY;

Opening the physical standby database for read-only access allows you to add a temporary file. Because adding a temporary file does not generate redo data, it is allowed for a database that is open for read-only access.
3. Create a temporary file for the temporary tablespace. The size and names for the files can differ from the primary database. For example:
SQL> ALTER TABLESPACE temp1
ADD TEMPFILE '/disk1/oracle/dbs/s_temp1.dbf'
SIZE 10M REUSE;

Get Oracle Certifications for all Exams
Free Online Exams.com

XML reports with big sizes ends up with error.

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 reports with big sizes ends up with error.

Log files:
Template code: XXFINARXAGE_XML
Template app: XXFIN
Language: en
Territory: 00
Output type: EXCEL
[2/22/10 12:16:17 PM] [UNEXPECTED] [15011:RT4231247] java.util.NoSuchElementException
at java.util.Vector.lastElement(Vector.java:477)
at oracle.apps.xdo.template.fo.elements.table.FOTableBody.doLayout(FOTableBody.java:189)
at oracle.apps.xdo.template.fo.elements.table.FOTableBody.doLayout(FOTableBody.java:76)
at oracle.apps.xdo.template.fo.elements.table.FOTable.doLayout(FOTable.java:166)
at oracle.apps.xdo.template.fo.elements.FOBlock.doLayout(FOBlock.java:263)
at oracle.apps.xdo.template.fo.elements.FOBlock.doLayout(FOBlock.java:188)
at oracle.apps.xdo.template.fo.elements.FOBlock.doLayout(FOBlock.java:106)
at oracle.apps.xdo.template.fo.elements.FOFlow.doLayout(FOFlow.java:81)
at oracle.apps.xdo.template.fo.elements.FormattingEngine.startLayout(FormattingEngine.java:163)
at oracle.apps.xdo.template.fo.elements.FormattingEngine.run(FormattingEngine.java:98)
at oracle.apps.xdo.template.fo.FOHandler.endElement(FOHandler.java:395)
at oracle.xml.parser.v2.XMLContentHandler.endElement(XMLContentHandler.java:196)
at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1212)
at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:301)
at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:268)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:149)
at oracle.apps.xdo.template.fo.FOProcessingEngine.process(FOProcessingEngine.java:279)
at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:1022)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5975)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3555)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3614)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:247)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:153)

Solution:

How to Configure the Account Analysis Report in Release 12 for Large Reports (Doc ID 737311.1)
Step 2 and 3 are applicable for both R11 and R12 .

The Oracle E-Business Suite Release 12 includes a new version of the Account Analysis Report as part of the Subledger Accounting and General Ledger application, implementing the XML Publisher technology for data gathering as well as report generation.
The data is extracted and generated into an XML format using a Data Template, extracted via the Java program XDODTEXE. Subsequent to that, the layout is then generated using the Output Post Processor (OPP) concurrent manager.
A typical problem for application user's of these reports is the fact that it is likely to fail when generating the report for very large data sets so the environment needs to be configured properly to handle that.
1. Set the Scalable Option to on for these programs.
--> This prevents the following error in the Subledger Accounting program's log:
Calling XDO Data Engine...
****Warning!!! Due to high volume of data, got out of memory exception...***
****Please retry with scalable option or modify the Data template to run in scalable mode...***

The scalability option is set by performing these steps:
1. As System Administrator: Navigate to Concurrent->Program->Define
2. Query up the report: Account Analysis Report
3. Add a parameter named ScalableFlag:
 Value Set: yes_no
 Default Value: Yes
 Select check boxes Enable and Required
 Do not select the check box Displayed, or users could turn this off at runtime.
 Token needs to be ScalableFlag (this is a case sensitive value).

Complete these steps for both the application General Ledger and the Subledger Accounting concurrent program definitions.
2. Configure the XML Publisher Administrator Configuration settings. This prevents "java.lang.OutOfMemoryError" errors in the Output Post Processor log associated to
the Subledger Accounting program.
o As XML Publisher Administrator navigate to Administration->Configuration.
o Under Temporary Directory pick a temporary file location on your concurrent processing node. This should be at least 5GB or 20x larger than largest XML data file you generate
o Under FO Processing, set:
 Use XML Publisher's XSLT processor set to True
 Enable scalable feature of XSLT processor set to False (see #4 below),
 Enable XSLT runtime optimization set to True

3. Configure the Output Post Processor's JVM. These steps set the JVM to 2GB.
This setting prevents the error "java.lang.OutOfMemoryError: Java heap space"
in the Output Post Processor's log associated to the Subledger Accounting Program.
Since EBS uses a 32-bit JRE using values greater than 2GB is not going to help.
Addressable memory maxes out between 1GB and 2GB for 32-bit JRE.
o Login to SQL*Plus as APPS.
o SQL>update FND_CP_SERVICES set DEVELOPER_PARAMETERS =
'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx2048m'
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');
o Bounce the concurrent managers.

4. With the addition of Patch 7599031 XML PUBLISHER SUM(CURRENT-GROUP()) FAILS, the FO Processing option Enable scalable feature of XSLT processor can be safely set to True at the Template level (for large reports), enabling improved JAVA heap utilization.
We still recommend this remain false at Site level. This has the advantage of faster performance by not using temporary files for XSLT processing for small to medium reports.
5. Apply Patch 7687414 REHOSTING XDOPARSER 10.1.0.5 WITH FIX FOR BUG 7586025, 7339075. This patch upgrades the Java Developers Kit (XDK) which is used by XML Publisher for sorting.
6. Test the reports.

References:

How to Configure the Account Analysis Report in Release 12 for Large Reports [ID 737311.1]

Get Oracle Certifications for all Exams
Free Online Exams.com

Crs not starting up, crsd.bin process was hanging.

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: Crs not starting up, crsd.bin process was hanging.

Solution:

Kill crsd.bin process on working node.

Suggested to apply latest 10.2.0.5 patchset at least on crs home and monitor the system for couple of days.

If similar problem occurs again then take the pstack output of crsd.bin process on both the nodes.

Get Oracle Certifications for all Exams
Free Online Exams.com

FRM-30312: Failed to compile the library

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 applying this patch 5739724, following error is encountered: -
The following Oracle Forms objects did not generate successfully:
au resource ARXPLCOM.pll
au resource ARXTXSTD.pll
ar forms/US RAXSTDTE.fmx
ar forms/US RAXSUDTE.fmx
FRM-30312: Failed to compile the library

Symptoms:
On : 11.5.10.2 version, Installation Issues

When attempting to compile, the following error occurs.

Errors:
-----
Compiling library ARXTXSTD...
Invalidating Package Spec TAX_STANDARD......
Invalidating Package Body TAX_STANDARD......
Invalidating Function Body ARXTXSTD_REVISION......
Compiling Package Spec TAX_STANDARD......
Compiling Package Body TAX_STANDARD......
ERROR 302 at line 14, column 22
component 'GET' must be declared
ERROR 0 at line 14, column 11
Statement ignored
Compiling Function Body ARXTXSTD_REVISION......
Closing library ARXTXSTD...
Compilation errors on TAX_STANDARD:
PL/SQL ERROR 302 at line 14, column 22
component 'GET' must be declared
PL/SQL ERROR 0 at line 14, column 11
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.
-----
Compiling library ARXPLCOM...
Compilation errors on AR_COMMON_INIT_PROFILES:
PL/SQL ERROR 302 at line 117, column 25
component 'VALUE' must be declared
PL/SQL ERROR 0 at line 117, column 8
Statement ignored
PL/SQL ERROR 302 at line 120, column 25
component 'VALUE' must be declared
PL/SQL ERROR 0 at line 120, column 8
Statement ignored
PL/SQL ERROR 302 at line 123, column 25
component 'VALUE' must be declared
PL/SQL ERROR 0 at line 123, column 8
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library

Log files:
11i.AR.O

Errors:
-----
Compiling library ARXTXSTD...
Invalidating Package Spec TAX_STANDARD......
Invalidating Package Body TAX_STANDARD......
Invalidating Function Body ARXTXSTD_REVISION......
Compiling Package Spec TAX_STANDARD......
Compiling Package Body TAX_STANDARD......
ERROR 302 at line 14, column 22
component 'GET' must be declared
ERROR 0 at line 14, column 11
Statement ignored
Compiling Function Body ARXTXSTD_REVISION......
Closing library ARXTXSTD...
Compilation errors on TAX_STANDARD:
PL/SQL ERROR 302 at line 14, column 22
component 'GET' must be declared
PL/SQL ERROR 0 at line 14, column 11
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.
-----
Compiling library ARXPLCOM...
Compilation errors on AR_COMMON_INIT_PROFILES:
PL/SQL ERROR 302 at line 117, column 25
component 'VALUE' must be declared
PL/SQL ERROR 0 at line 117, column 8
Statement ignored
PL/SQL ERROR 302 at line 120, column 25
component 'VALUE' must be declared
PL/SQL ERROR 0 at line 120, column 8
Statement ignored
PL/SQL ERROR 302 at line 123, column 25
component 'VALUE' must be declared
PL/SQL ERROR 0 at line 123, column 8
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.
-----
-----
Invalids:
OWNER OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------------------ -------------------
CTXSYS OKC_REP_CONTRACT_TEXT_IDX_CTX PACKAGE BODY
APPS OKS_CCENCRYPTION_PKG PACKAGE BODY
APPS CS_PARTYMERGE_PKG PACKAGE BODY
APPS CZ_IMP_SINGLE_DEBUG PACKAGE BODY
APPS XXFZDOCUPD PACKAGE BODY
APPS XXHR_EZW_HP_INTERFACE PACKAGE BODY
APPS XXFZ_LIC_PRC_PKG PACKAGE BODY
APPS XXIMS_HP_PN_LIVELEASE_INT_PKG PACKAGE BODY
APPS XXIMS_HP_CRM_PRICE_EXT_PKG PACKAGE BODY
APPS XXIMS_HP_CRM_REV_EXT_PKG PACKAGE BODY
APPS XXIMS_HP_GL_BAL_EXT_PKG PACKAGE BODY
APPS EUL5_B090428091814Q1V1 VIEW
APPS EUL5_B090428090613Q1V1 VIEW
APPS EUL5_B090428090152Q1V1 VIEW
APPS EUL5_B090428090315Q1V1 VIEW
APPS XXFIN_MASTER_PERIOD_DETAIL_V VIEW
APPS XXFIN_FA_PERIOD_DETAILS_V VIEW
APPS XXFIN_INV_PERIOD_DETAILS_V VIEW
APPS XXFIN_ACCT_PREIOD_STS_DTLS VIEW
APPS XXFIN_ACCT_PERIOD_STS_V VIEW
APPS XXFZ_WEB_CONSULTANT_UPLOAD_PKG PACKAGE BODY
APPS XXCONV_PN_LEASE_CONV_PKG PACKAGE BODY
APPS XXESRV_CLIENT_DIRECTORY_PKG PACKAGE BODY
APPS XXCED_GIS_PKG PACKAGE BODY
APPS XXFIN_COA_VALUE_DTLS_MASTER_V VIEW
APPS XXFIN_SEGMENT_VALUES_MASTER_V VIEW
APPS XXFZ_EHS_CLIENT_EXP PACKAGE BODY
APPS XXFZ_WEB_LOOKUP_VALUES PACKAGE BODY
APPS XXFZ_WEB_ENQUIRY_UPLOAD_PKG PACKAGE BODY
APPS XXCONV_DW_AR_RECEIPTS_PKG PACKAGE BODY
APPS XXIMS_GL_EXTRACT_HYP_INTER_PKG PACKAGE BODY
APPS XXCONV_DW_AR_TRX_PKG PACKAGE BODY
APPS XXFZ_OTC_TO_AR_IFACE_PATCH PACKAGE BODY
APPS XXCONV_GENERIC PACKAGE BODY
APPS DBMS_AW_BUILD PACKAGE BODY
APPS BIM_I_LEAD_MGMT_PVT PACKAGE BODY
APPS PN_CC_SYNC_PKG PACKAGE BODY
APPS HZ_IMP_LOAD_WRAPPER PACKAGE BODY
APPS WF_JAVA_DEFERRED SYNONYM
APPS PN_EXP_TO_EAM_PVT PACKAGE BODY
APPS PA_PROJ_TRANSFERS_VIEW VIEW
APPS APS_VALIDATE PROCEDURE
JUNK_PS WWSSO_PSTORE_EX SYNONYM
JUNK_PS WWSSO_API_PRIVATE SYNONYM
JUNK_PS WWSSO_API SYNONYM
JUNK_PS WWCTX_API_VPD SYNONYM
XXFIN XXFIN_FA_DEPRN_PERIODS VIEW
XXFIN XXFIN_ORGANIZATION_DEFINITIONS VIEW
XXFIN XXFIN_ORG_ACCT_PERIODS_V VIEW
XXFIN XXFIN_FA_BOOK_CONTROLS VIEW
XXIMS XXIMS_HR_EMP_INTERFACE PACKAGE BODY
XXCONV XXUPDDB_PROC PROCEDURE
XXHR_R XXHR_UDFS_PKG PACKAGE BODY
XXIDCAUSER T_CARD_FLOW TRIGGER

54 rows selected.
-----
-----
VERT.pld 115.3.1150.2 2000/01/17
ARXPLCOM.pld 115.68.15104.6 2008/01/17
-----
ARXTXSTD.pld 115.4 2003/05/27
-----
RAXSTDTE.fmx RAXSTDTE.fmb: 115.10 11-Oct-2006
-----
RAXSUDTE.fmx RAXSUDTE.fmb: 115.30 11-Oct-2006
-----
-----
RDA:
HZ_IMP_LOAD_WRAPPER ARHLWRPB.pls 115.52 BODY INVALID 25-Nov-2010

Invalid Referenced Objects:
XXFIN_ACCT_PERIOD_STS_V ORA-02019: connection description for remote database not found
XXFIN_ACCT_PERIOD_STS_V ORA-12541: TNS:no listener
XXFIN_MASTER_PERIOD_DETAIL_VORA-04063: view "APPS.XXFIN_ACCT_PERIOD_STS_V" has errors

Solution:

When you have custom code, don't attach any product libraries to CUSTOM.pll.

Please follow the solution from this Note 468860.1 - Error Generating Library "Resource/Arxplcom.Plx" From Input File.

1. Remove customization from CUSTOM.pll. (If you don't have the standard custom.pll I can send it to you, just let me know)
2. Use adadmin to generate custom.pll
if it compiled successfully, please use adadmin to generate other.

References:

Note 468860.1 - Error Generating Library "Resource/Arxplcom.Plx" From Input File.

Get Oracle Certifications for all Exams
Free Online Exams.com

Incorrect Error Message while trying to attach a File by typing in the file 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:
Incorrect Error Message while trying to attach a File by typing in the file name

Symptoms:
Customer has upgraded from 7.0 to 8.0. In Siebel 8.0, while trying to attach files, if the user types in the File Name, instead of selecting the file from “Add Attachments” dialog box, the following error message is displayed:

“Siebel Error Message SBL-DBC-00111: An error has occurred writing to a record. Please continue or ask your systems administrator to check your application configuration if the problem persists.”

Whereas in Siebel 7.0, if the same action is done, the following error message is displayed:

“Siebel Error Message SBL-UIF-00359: Please use the file selection menu to select a file.”

Solution:

The reported behavior by the customer seems to be a new product defect in Siebel 8.0. The same behavior was reproducible Standard 8.0. with the following steps:

1. In "Service Request Attachment List Applet", creat a new record from Applet Menu.

2. Type in some characters for the "Attachment Name" column and try to save it.

3. It will the same error (SBL-DBC-00111) that the customer has mentioned.

Then, on testing in Standard 7.8, following the same steps as above, got a different error message like below, which is much more readable format for end-users:

"Siebel Error Message SBL-UIF-00359: Please use the file selection menu to select a file."

Hence the behavior reported by the customer should be a product defect in 8.0.
Solution

A new bug #- 12-1PG85NN has been logged to address this behavior. Please note that bugs will be considered and prioritized only for future releases.

As a workaround, you may consider writing a script in PreWriteRecord of the Attachment BC to generate an error message as required. For example:
function BusComp_PreWriteRecord ()
{
if (this.GetFieldValue("ActivityFileDeferFlg")== "")
{
TheApplication().RaiseErrorText("Please use the file selection menu to select a file.");
return (CancelOperation)
}
return (ContinueOperation);
}

References:

Incorrect Error Message while trying to attach a File by typing in the file name [ID 730567.1]

Get Oracle Certifications for all Exams
Free Online Exams.com

SBL-SVC-00184 Error When Attempting to Add Attachments in Siebel Application

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: SBL-SVC-00184 Error When Attempting to Add Attachments in Siebel Application

Symptoms:
It was reported that end users were not able to add an attachment file or a correspondence model in the Siebel application.

The following error message was displayed:
"Error occurred while creating file in filesystem. Please contact your system administrator.(SBL-SVC-00184)"

A review of the application logs and the following error was seen:
In the database it was found that every data record in S_ACCNT_ATT had FILE_DEFER_FLG set to 'R'. This was found with the following query:
Error Error 1 2005-05-27 10:45:31 SQLError: sqlstate 23502: [IBM][CLI Driver][DB2/NT] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=6, TABLEID=5391, COLNO=9" is not allowed. SQLSTATE=23502

SELECT FILE_NAME, FILE_DEFER_FLG FROM S_ACCNT_ATT

Solution:

Cause
The cause of this was an incorrect specification of the Siebel File System pathname in the Siebel Server.
The Siebel File System pathname had been specified with a RELATIVE path.

1. On the database where the error message occurred, each row of S_ACCNT_ATT has FILE_DEFER_FLG = 'R'. The same values were found on a database where the attachment functionality works.

2. When trying to add an attachment to an account through the user interface the following error occurs:
'Not possible to find the file 'name.doc' in the system file specified (SBL-UIF-00230)'
When querying the record for the new attachment using SQL SELECT on the database the following values are found:

FILE_DEFER_FLG = 'R', but the columns FILE_DATE and FILE_SIZE are empty.
It was also observed that the corresponding compressed .SAF file was not created in the Siebel File System.

Solution
The solution for this behavior is to correct the definition of the Siebel File System pathname in the Siebel Server. This will eliminate the error message and allow attachments to be created by the end users.
The Siebel File System pathname must be specified with the complete absolute pathname.

For more information about defining the Siebel File System pathname please refer to the following documentation:
* Siebel Server Installation Guide for Microsoft Windows (Version 7.5.3 -> 8.1.1) > Preparing for the Installation > Planning Your Siebel Deployment > Creating a File System / Creating the File System
* Siebel Server Administration Guide (Version 7.5.3 -> 8.1.1) > Siebel Server Infrastructure Administration > Administering the Siebel File System >Moving the Siebel File System

References:

SBL-SVC-00184 Error When Attempting to Add Attachments in Siebel Application [ID 493885.1]

Get Oracle Certifications for all Exams
Free Online Exams.com

(SBL-DBC-00111) ORA-01400: cannot insert NULL into ("SIEBEL"."S_ACTIVITY_ATT"."FILE_DEFER FLG")

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: file attachment error
[1] An error has occurred writing to a record.
Please continue or ask your systems administrator to check your application configuration if the file problem persists (SBL-DBC-00111)
[2] ORA-01400: cannot insert NULL into ("SIEBEL"."S_ACTIVITY_ATT"."FILE_DEFER FLG")

All the folders in the Siebel File System have read, write, execute access.

Symptoms:
Users are using the file menu to select the file. While selecting the file we're getting the same error. No manual typing in file name field.

Log files:
PSCcObjMgr_enu_0039_40894474_vanilla.log
(and this indeed has no custom colums searching for .X_)

SQLParseAndExecute Statement 4 00001a6e4c982962:26299 2010-09-22 11:15:00

INSERT INTO SIEBEL.S_SR_ATT (
CONFLICT_ID,
DB_LAST_UPD_SRC,
DB_LAST_UPD,
LAST_UPD,
CREATED,
LAST_UPD_BY,
CREATED_BY,
MODIFICATION_NUM,
ROW_ID,
PAR_ROW_ID,
FILE_AUTO_UPD_FLG,
FILE_DOCK_REQ_FLG,
FILE_NAME,
FILE_REV_NUM,
FILE_SRC_TYPE)
VALUES (:1, :2, current_date, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14)

SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 1: 0
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 2: User
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 3: 09/22/2010 07:13:46
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 4: 09/22/2010 07:13:46
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 5: 1-38WZS
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 6: 1-38WZS
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 7: 0
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 8: 1-4XPHKH
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 9: 1-2JM67M
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 10: Y
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 11: N
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 12: test
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 13: 0
SQLParseAndExecute Bind Vars 4 00001a6e4c982962:26299 2010-09-22 11:15:00 14: FILE
SQLParseAndExecute Execute 5 00001a6e4c982962:26299 2010-09-22 11:15:00 OCIStmtExecute: DML error or affected 0 rows
ObjMgrBusCompLog Error 1 00001a6e4c982962:26299 2010-09-22 11:15:00 (oracon.cpp (3255)) SBL-DBC-00111: An error has occurred writing to a record.

Please continue or ask your systems administrator to check your application configuration if the problem persists.
SQLParseAndExecute Execute 5 00001a6e4c982962:26299 2010-09-22 11:15:00 ORA-01400: cannot insert NULL into ("SIEBEL"."S_SR_ATT"."FILE_DEFER_FLG")

ObjMgrSqlLog Detail 4 00001a6e4c982962:26298 2010-09-22 11:15:00
***** SQL Statement Write Time: 0.013 seconds *****

Solution:

The cause of all the error messages was an incorrect specification of the Siebel File System pathname in the Siebel Server. It was specified with a relative pathname.

1. On the database where the error message occurred, each row of S_ACCNT_ATT has FILE_DEFER_FLG = 'R'. The same values were found on a database where the attachment functionality works.

2. When trying to add an attachment to an account through the user interface the following error occurs:
'Not possible to find the file 'name.doc' in the system file specified (SBL-UIF-00230)'
When querying the record for the new attachment using SQL SELECT on the database the following values are found:

FILE_DEFER_FLG = 'R', but the columns FILE_DATE and FILE_SIZE are empty.
It was also observed that the corresponding compressed .SAF file was not created in the Siebel File System.

Solution

Correcting the definition of the Siebel File System pathname in the Siebel Server will eliminate the error message. The Siebel File System pathname must be specified with the complete absolute pathname.

For more information about defining the Siebel File System pathname please refer to the following documentation:

Workaround could be setting a postdefault of "R" for each *FileDeferFlg field in every *attachment business component to assure the required column is always populated

References:

Get Oracle Certifications for all Exams
Free Online Exams.com

How to Configure the Account Analysis Report in Release 12 for Large Reports

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:
How to Configure the Account Analysis Report in Release 12 for Large Reports

Solution:

The Oracle E-Business Suite Release 12 includes a new version of the Account Analysis Report as part of the Subledger Accounting and General Ledger application, implementing the XML Publisher technology for data gathering as well as report generation.
The data is extracted and generated into an XML format using a Data Template, extracted via the Java program XDODTEXE. Subsequent to that, the layout is then generated using the Output Post Processor (OPP) concurrent manager.
A typical problem for application user's of these reports is the fact that it is likely to fail when generating the report for very large data sets so the environment needs to be configured properly to handle that.
1. Set the Scalable Option to on for these programs.
--> This prevents the following error in the Subledger Accounting program's log:
Calling XDO Data Engine...
****Warning!!! Due to high volume of data, got out of memory exception...***
****Please retry with scalable option or modify the Data template to run in scalable mode...***

The scalability option is set by performing these steps:
1. As System Administrator: Navigate to Concurrent->Program->Define
2. Query up the report: Account Analysis Report
3. Add a parameter named ScalableFlag:
 Value Set: yes_no
 Default Value: Yes
 Select check boxes Enable and Required
 Do not select the check box Displayed, or users could turn this off at runtime.
 Token needs to be ScalableFlag (this is a case sensitive value).

Complete these steps for both the application General Ledger and the Subledger Accounting concurrent program definitions.
2. Configure the XML Publisher Administrator Configuration settings. This prevents "java.lang.OutOfMemoryError" errors in the Output Post Processor log associated to
the Subledger Accounting program.
o As XML Publisher Administrator navigate to Administration->Configuration.
o Under Temporary Directory pick a temporary file location on your concurrent processing node. This should be at least 5GB or 20x larger than largest XML data file you generate
o Under FO Processing, set:
 Use XML Publisher's XSLT processor set to True
 Enable scalable feature of XSLT processor set to False (see #4 below),
 Enable XSLT runtime optimization set to True

3. Configure the Output Post Processor's JVM. These steps set the JVM to 2GB.
This setting prevents the error "java.lang.OutOfMemoryError: Java heap space"
in the Output Post Processor's log associated to the Subledger Accounting Program.
Since EBS uses a 32-bit JRE using values greater than 2GB is not going to help.
Addressable memory maxes out between 1GB and 2GB for 32-bit JRE.
o Login to SQL*Plus as APPS.
o SQL>update FND_CP_SERVICES set DEVELOPER_PARAMETERS =
'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx2048m'
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');
o Bounce the concurrent managers.

4. With the addition of Patch 7599031 XML PUBLISHER SUM(CURRENT-GROUP()) FAILS, the FO Processing option Enable scalable feature of XSLT processor can be safely set to True at the Template level (for large reports), enabling improved JAVA heap utilization.
We still recommend this remain false at Site level. This has the advantage of faster performance by not using temporary files for XSLT processing for small to medium reports.
5. Apply Patch 7687414 REHOSTING XDOPARSER 10.1.0.5 WITH FIX FOR BUG 7586025, 7339075. This patch upgrades the Java Developers Kit (XDK) which is used by XML Publisher for sorting.
6. Test the reports.

References:

How to Configure the Account Analysis Report in Release 12 for Large Reports [ID 737311.1]

Get Oracle Certifications for all Exams
Free Online Exams.com

emagent consuming very high CPU affecting the performance

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: emagent consuming very high CPU affecting the performance

Log files:
emagent.nohup
------------

--- Standalone agent
----- Sun Jul 18 14:31:45 2010::Agent Launched with PID 4583 at time Sun Jul 18 14:31:45 2010 -----
----- Sun Jul 18 14:31:45 2010::Time elapsed between Launch of Watchdog process and execing EMAgent is 2 secs -----
(pid=4583): starting emagent version 10.2.0.5.0
(pid=4583): emagent started successfully
----- Sun Jul 18 14:34:19 2010::Checking status of EMAgent : 4583 -----
(pid=4583): emagent now exiting normally
----- Sun Jul 18 14:34:28 2010::Checking status of EMAgent : 4583 -----
----- Sun Jul 18 14:34:28 2010::EMAgent exited at Sun Jul 18 14:34:28 2010 with return value 0. -----
----- Sun Jul 18 14:34:28 2010::EMAgent was shutdown normally. -----
----- Sun Jul 18 14:34:28 2010::Exiting watchdog loop
-----
--- Standalone agent
----- Sun Jul 18 14:34:44 2010::Agent Launched with PID 6598 at time Sun Jul 18 14:34:44 2010 -----
----- Sun Jul 18 14:34:44 2010::Time elapsed between Launch of Watchdog process and execing EMAgent is 1 secs -----
(pid=6598): starting emagent version 10.2.0.5.0
(pid=6598): emagent started successfully
URLTiming: Using SunX509
(pid=6598): emagent now exiting normally

emagent.trc
-----------
2010-07-18 17:34:32,339 Thread-20274 WARN fetchlets.OJMX: Error communicating with SOAP server using URL: http://jdtpap01.dubaiworld.ae:12508/JMXSoapAdapter/JMXSoapAdapter
2010-07-18 17:34:32,339 Thread-20274 WARN fetchlets.OJMX: SOAP test failed, error:4294967295, host:port:oracle_home:oc4jInstanceName:jvmId:mgmtWebSite is: jdtpap01.dubaiworld.ae::/u01/app/oracle/products/OAS/mid:customs:1:default-web-site
2010-07-18 17:34:32,339 Thread-20274 ERROR engine: [oc4jjvm,DT_PROD_APP1.jdtpap01.dubaiworld.ae_customs_JVM_1,MemoryPools] : nmeegd_GetMetricData failed : Error communicating with server.
2010-07-18 17:34:32,339 Thread-20274 WARN collector: Error exit. Error message: Error communicating with server.
2010-07-18 17:34:32,353 Thread-20274 WARN fetchlets.OJMX: Got HTTP Status: 401
2010-07-18 17:34:32,353 Thread-20274 WARN fetchlets.OJMX: Error communicating with SOAP server using URL: http://jdtpap01.dubaiworld.ae:12508/JMXSoapAdapter/JMXSoapAdapter
2010-07-18 17:34:32,353 Thread-20274 WARN fetchlets.OJMX: SOAP test failed, error:4294967295, host:port:oracle_home:oc4jInstanceName:jvmId:mgmtWebSite is: jdtpap01.dubaiworld.ae::/u01/app/oracle/products/OAS/mid:customs:1:default-web-site
2010-07-18 17:34:32,353 Thread-20274 ERROR engine: [oc4jjvm,DT_PROD_APP1.jdtpap01.dubaiworld.ae_customs_JVM_1,GarbageCollectors] : nmeegd_GetMetricData failed : Error communicating with server.
2010-07-18 17:34:32,353 Thread-20274 WARN collector: Error exit. Error message: Error communicating with server.
2010-07-18 17:34:58,199 Thread-20322 WARN fetchlets.OJMX: Got HTTP Status: 401
2010-07-18 17:34:58,200 Thread-20322 WARN fetchlets.OJMX: Error communicating with SOAP server using URL: http://jdtpap01.dubaiworld.ae:12507/JMXSoapAdapter/JMXSoapAdapter
2010-07-18 17:34:58,200 Thread-20322 WARN fetchlets.OJMX: SOAP test failed, error:4294967295, host:port:oracle_home:oc4jInstanceName:jvmId:mgmtWebSite is: jdtpap01.dubaiworld.ae::/u01/app/oracle/products/OAS/mid:mdtwebserv:1:default-web-site
2010-07-18 17:34:58,200 Thread-20322 ERROR engine: [oc4jjvm,DT_PROD_APP1.jdtpap01.dubaiworld.ae_mdtwebserv_JVM_1,Threads_Raw] : nmeegd_GetMetricData failed : Error communicating with server.
2010-07-18 17:34:58,200 Thread-20322 ERROR engine: [DT_PROD_APP1.jdtpap01.dubaiworld.ae_mdtwebserv_JVM_1,oc4jjvm] Failure in step [0] : Threads_Raw. Error communicating with server.. Stopping execution
2010-07-18 17:34:58,200 Thread-20322 ERROR engine: [DT_PROD_APP1.jdtpap01.dubaiworld.ae_mdtwebserv_JVM_1,oc4jjvm] : Threads : nmeeam_GetMetricData failed
2010-07-18 17:34:58,200 Thread-20322 ERROR engine: [oc4jjvm,DT_PROD_APP1.jdtpap01.dubaiworld.ae_mdtwebserv_JVM_1,Threads] : nmeegd_GetMetricData failed : Error communicating with server.
2010-07-18 17:34:58,200 Thread-20322 WARN collector: Error exit. Error message: Error communicating with server.
2010-07-18 17:34:58,213 Thread-20322 WARN fetchlets.OJMX: Got HTTP Status: 401
2010-07-18 17:34:58,213 Thread-20322 WARN fetchlets.OJMX: Error communicating with SOAP server using URL: http://jdtpap01.dubaiworld.ae:12507/JMXSoapAdapter/JMXSoapAdapter
2010-07-18 17:34:58,213 Thread-20322 WARN fetchlets.OJMX: SOAP test failed, error:4294967295, host:port:oracle_home:oc4jInstanceName:jvmId:mgmtWebSite is: jdtpap01.dubaiworld.ae::/u01/app/oracle/products/OAS/mid:mdtwebserv:1:default-web-site
2010-07-18 17:34:58,213 Thread-20322 ERROR engine: [oc4jjvm,DT_PROD_APP1.jdtpap01.dubaiworld.ae_mdtwebserv_JVM_1,Threads_Raw] : nmeegd_GetMetricData failed : Error communicating with server.
2010-07-18 17:34:58,213 Thread-20322 WARN collector: Error exit. Error message: Error communicating with server.
2010-07-18 17:34:58,226 Thread-20322 WARN fetchlets.OJMX: Got HTTP Status: 401
2010-07-18 17:34:58,226 Thread-20322 WARN fetchlets.OJMX: Error communicating with SOAP server using URL: http://jdtpap01.dubaiworld.ae:12507/JMXSoapAdapter/JMXSoapAdapter
2010-07-18 17:34:58,226 Thread-20322 WARN fetchlets.OJMX: SOAP test failed, error:4294967295, host:port:oracle_home:oc4jInstanceName:jvmId:mgmtWebSite is: jdtpap01.dubaiworld.ae::/u01/app/oracle/products/OAS/mid:mdtwebserv:1:default-web-site
2010-07-18 17:34:58,227 Thread-20322 ERROR engine: [oc4jjvm,DT_PROD_APP1.jdtpap01.dubaiworld.ae_mdtwebserv_JVM_1,DeadlockedThreads] : nmeegd_GetMetricData failed : Error communicating with server.
2010-07-18 17:34:58,227 Thread-20322 WARN collector: Error exit. Error message: Error communicating with server.
2010-07-18 17:35:12,361 Thread-4 WARN http: nmehl_httpListener: signaled to exit from emctl
2010-07-18 17:35:13,371 Thread-4 WARN : Signalled to Exit Normally. Signaled to exit from emctl

Solution:

1. Set the below parameters in the AGENT_HOME/bin/commonenv file:
# Agent memory growth and monitoring
EMAGENT_RECYCLE_MAXMEMORY=1700 #recycle at max memory over 1700 MB
export EMAGENT_RECYCLE_MAXMEMORY
EMAGENT_MAXMEM_INCREASE=10 #recycle if memory grows over 10 MB during check period
export EMAGENT_MAXMEM_INCREASE
EMAGENT_MEMCHECK_HOURS=240 #check memory every 240 hours
export EMAGENT_MEMCHECK_HOURS
+If this file doesn't exist, please create commonenv file using any text editor.
This should be able to make the agent stable.
2. Restart the agent and check if agent still consumes high CPU
2. Apply the patch 6608425 and increase collection interval for oc4jjvm metrics as per note 430366.1
References:

Bug 9270034: AGENT CONSUMES CPU RESOURCES (IN SPIKES) MONITORING APP-TIER TARGETS

Get Oracle Certifications for all Exams
Free Online Exams.com

You have insufficient privileges for the current operation. Please contact your System Administrator

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:

You have insufficient privileges for the current operation. Please contact your System Administrator

Symptoms:

On : 11.5.10.2 version, Core HR - General

When attempting to update an Event,
the following error occurs.

ERROR
-----------------------

You have insufficient priveleges for the current operation. Please contact your system
Administrator.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility : UAE HRMS Manager
2. Select : Work Structures > Calendar Events > Enter and Maintain Events
3. The search screen appear.
4. Customer select Type - Public Holiday
5. A list of Event Name appear.
6. Click Update Icon and the error below appear.

Solution:

The issue is caused by a incorrect setup [function needs to be added to "PER_CALENDAR_EVENTS"and notPER_CALENDAR_EVENT Please note there a "s" difference.].
- Delete the function under the menu save it and then re-enter the function under the same menu.
- Bounce the apache/middle tier, clear the cache from Functional administrator responsibility
- Verify the issue.

References:

Bug 10149174 - INSUFFICIENT PRIVILEGES ERROR WHILE UPDATING CALENDAR EVENTS

Insufficient Privileges Error While Updating Calendar Events (Doc ID 1277714.1)

Insufficient Privileges For the Current Operation: Update Calendar Event (Doc ID 406373.1)

Get Oracle Certifications for all Exams
Free Online Exams.com

How to generate trace file for Invoice workbench

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: How to generate trace file for Invoice workbench

Solution:

How to generate trace file for Invoice workbench

- Navigation:

Responsibility = System Administrator
Security > Profile
User: Enter User name of the user facing the issue.
Query the Profile: FND: Diagnostics
Set the FND:Diagnostics profile to Yes at User level.

- Login into Self Service under the same user used to set the profile value.

- Navigate to the point immediately before the error is received, if any.

- Click the diagnostic icon at the top of the page. Two options are displayed:

Show Log
Set Trace Level

- Select 'Set Trace Level'

- Click Go.

- A page with a set of options is displayed.

Disable Trace
Trace (regular)
Trace with binds
Trace with waits
Trace with binds and waits

- Choose Trace with binds and waits

- Click Save.

- Return back to the page and reproduce the error, if any.

- Turn off Trace.

Select the Diagnostic icon.
Click on option: Set Trace Level
Click Go
Select : Disable Trace

- Note the trace id numbers - there will be more than one and exit the Application

- To determine where the raw trace files are located from SQLPlus:
SELECT value
FROM v$parameter
WHERE name = 'user_dump_dest';
The trace id numbers will be part of the name of the trace files.

- Run TKPROF procedure on the raw trace files. For example, hrab51_ora_18190.trc is the name of the raw trace file and trace1.txt is the name of the TKPROF file.

tkprof hrab51_ora_18190.trc explain=apps/ sort=‘(prsela,exeela,fchela)

References:

Note 980711.1.

Get Oracle Certifications for all Exams
Free Online Exams.com

cannot write: Text file busy, Out of memory. Root102.sh fails and crashes the system on 10.2.0.5 crs, ONS GOES OFFLINE WHEN CRS IS UPGRADED FROM 10201-10202-10205

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: cannot write: Text file busy, Out of memory. Root102.sh fails and crashes the system on 10.2.0.5 crs, ONS GOES OFFLINE WHEN CRS IS UPGRADED FROM 10201-10202-10205

Symptoms:
Two Node RAC
CRS upgrades to 10205. OUI succesfully completed.
While running root102.sh on one node hangs and crashes the system.

crsctl query crs softwareversion
CRS software version on node [ServerNAme] is [10.2.0.4.0] NOT 10.2.0.5 !!!

/u01/app/crs/product/10g/OPatch/opatch lsinventory
Exception in thread "main" java.lang.NoClassDefFoundError: OsInfo
Invoking OPatch 10.2.0.4.9

Oracle Interim Patch Installer version 10.2.0.4.9
Copyright (c) 2009, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/crs/product/10g
Central Inventory : /u01/app/oraInventory
from : /var/opt/oracle/oraInst.loc
OPatch version : 10.2.0.4.9
OUI version : 10.2.0.5.0
OUI location : /u01/app/crs/product/10g/oui
Log file location : /u01/app/crs/product/10g/cfgtoollogs/opatch/opatch2010-10-26_09-02-15AM.log

Patch history file: /u01/app/crs/product/10g/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /u01/app/crs/product/10g/cfgtoollogs/opatch/lsinv/lsinventory2010-10-26_09-02-15AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (2):

Oracle Clusterware 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 4 10.2.0.5.0
There are 2 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.
Log files:
*
After applying 10205, the ons is failed to start with the below error.
I could see that in ocr.config file the port is different.

I had commented the below to avoid the ocr registry check for starting ons.

Ocr registered port for ons is 4948 and in ons.config is 6106. We have not done any changes in the port configuration.

useocr=on

Number of configuration nodes retrieved: 2
0: {node = pdppdb03, port = 4948}
Remote port for local node in local config does not match that from OCR.
Remote port for local node in local config does not match that from OCR.
Number of configuration nodes retrieved: 2
0: {node = pdppdb03, port = 4948}
Remote port for local node in local config does not match that from OCR.
onsctl: ons failed to start
**
/u01/app/crs/product/10g/install/root102.sh

mv: /u01/app/crs/product/10g/./lib/libnnz10.so: cannot write: Text file busy

mv: /u01/app/crs/product/10g/./lib/libclntsh.so.10.1: cannot write: Text file busy

mv: /u01/app/crs/product/10g/./lib/libocr10.so: cannot write: Text file busy

mv: /u01/app/crs/product/10g/./lib/libocrb10.so: cannot write: Text file busy

mv: /u01/app/crs/product/10g/./lib/libocrutl10.so: cannot write: Text file busy

mv: /u01/app/crs/product/10g/./lib/libhasgen10.so: cannot write: Text file busy

Completed patching clusterware files to /u01/app/crs/product/10g

rmdir: /u01/app/crs/product/10g/install/patch102/lib: Directory not empty

rmdir: /u01/app/crs/product/10g/install/patch102: Directory not empty

Relinking some shared libraries.

Out of memory.

Stop.

Out of memory.

Stop.

Relinking of patched files is complete.

Copying reboot_toc to /var/opt/oracle/bin for HPUX

WARNING: directory '/u01/app/crs/product' is not owned by root

WARNING: directory '/u01/app/crs' is not owned by root

WARNING: directory '/u01/app' is not owned by root

Preparing to recopy patched init and RC scripts

Solution:

Ocr registered port for ons is 4948 and in ons.config is 6106

The CRS port was held by other process.

The workaround is:
Workaround is to sync the OCR with the port in ons.config. Once this is done, ons will be back online

Can you try to sync the OCR with the port in ons.config to check if we can bring the ONS online or not?

There is no way we can have the ons.config file automaitcally change.

As per document Doc ID 759895.1 you can do either of the following :

Edit your crs1_ons_config_current.config to have remoteport=4948 that matches OCR registered ONS ports
-or-
Change the OCR using racgons commands (options, remove_config & add-config)to change the ONS port from 4948 to 6200.

Found several internal bugs logged for this issue with 10.2.0.5 and ONS port getting changed problems.

Bug 8925749: 10205 LINUX: ONS GOES OFFLINE WHEN CRS IS UPGRADED FROM 10201-10202-10205
Bug 9653027: HPI-SG-10205: OUTPUT OF "ONSCTL DEBUG" DOESN'T SHOW ANY "SERVER CONNECTIONS"
Bug 9861426: 10.2.0.5.0_LINUX.Z64_100418.100622:-ONS RESOURCES ARE OFFLINE AFTER PATCHING CRS

As per internal updates given in bugs this issue was identified during internal testing ofpatchset install and so was decided to cite itin release notes as known issues.
Workaround remains same as suggested before.
or
Simply modify the ons.configfile as follows:
Replace the line remoteport=value with useocr=on
This workaround also applies when OCR is enabled, by default, for existinginstallations.

You can stop just ONS resource with crs_stop ; then modify ONS (ons.config or racgons) and start ONS back with crs_start ;

References:

Doc ID 759895.1

Get Oracle Certifications for all Exams
Free Online Exams.com

How To Create A Debug Log File In An AR Form

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: How To Create A Debug Log File In An AR Form

Symptoms:
The purpose of this document is to enable the customer to produce
logfiles that will allow more meaningful diagnosis of forms related problems.

The Debug Log file gives details of the packages that are being used on the
process when an error occurs.

A majority of the AR forms have the debug feature enabled.
For instance:
Transactions workbench (ARXTWMAI)
Receipts workbench (ARXRWMAI)
Collections (ARXCWMAI)

Solution:

As of 11.5.10 and ARP_STANDARD (ARPLSTDB.pls) 115.36, we have replaced much of
the content of ARP_STANDARD.DEBUG with calls to FND_LOG.STRING.

To turn on the debugging:
Set the following profiles:
FND: Debug Log Enabled = YES
FND: Debug Log Filename = NULL
FND: Debug Log Level = STATEMENT (most detailed log)
FND: Debug Log Module = % or ar% or even ar.arp_auto_rule%

If you have applied Patch 3140000 - 11.5.10 MAINTENANCE PACK, the profile names have changed:
'FND: Debug Log Enabled' been replaced by 'FND: Log Enabled'
and 'FND: Debug Log Level' has been replaced by 'FND: Log Level'

Additional FND debugging tips can be reviewed in Note 433199.1

If you are on 11.5.9 and below, you need to enable profile option
'AR: Enable Debug Message Output' at user level to be able to produce
a debug logfile through setting AR_DEBUG_FLAG.
This can be done in your Receivables Responsibility through
Control > Profile Options.

1.
Navigate to the form where there is a problem/error.
Start with the steps to reproduce the issue.
Stop just before the problem/error occurs.
Don't hit the key that will invoke the error.

2.
On the menu, click help/diagnostic/examine (11.5) or
help/tools/examine (10.7 and 11.0).

3.
Change block field, then choose from the list of values: PARAMETER

4.
For the field, then TYPE in: AR_DEBUG_FLAG

There is no LOV for this field. Explicitly type in AR_DEBUG_FLAG.

5.
For the value, then TYPE in:
FS

There must be the blanks between FS, the path, and the file name.

a)
FS
FS creates a file, displaying Forms and Server debug messages.

b)

This is where the AR Debug Log file will be written to.

To find out where the log file must be saved, type the following in
SQL*Plus:

select value from v$parameter
where upper(name) = 'UTL_FILE_DIR';

It should return something similar to
VALUE
--------------------------------------------------------------------------------
/sqlcom/inbound, /sqlcom/outbound, /sqlcom/log, /sqlcom/out

Type in a path exactly as shown in the output of the select statement.

If value returned is *, it should be allowed to write the log to any directory.
The directory should have the correct permissions, privileges (write privileges)
.

c) Decide what to call the debug log file. For example, debug2.dbg

If the file specified already exists, the new debug messages will be
appended to it. In general, it is recommended to define a new debug file for
each problem reported.

d)

Full example:
Block: PARAMETER
Field: AR_DEBUG_FLAG
Value: FS /sqlcom/log debug2.dbg

6. To turn on Trace: go to menu, click on help/diagnostics/trace.
This can be skipped if a Trace is not needed.

7.
Continue to navigate through the form as started under 1. and reproduce
the problem/error.
Once done, exit the form.

8.
To turn off Trace: go to menu, click on help/diagnostics/trace

9.
Go to the directory where your AR Debug Log is located.
This is the path entered in step 5.

10.
Go to the directory where the Trace is located.

To find out where the Trace is written (if there was no message with the
description of the path and filename, when you enabled/disabled Trace),
type the following in SQL*Plus:

select value from v$parameter
where name='user_dump_dest';

11.
Upload AR Debug Log and raw and tk-proffed Trace to Metalink in your Service
Request (TAR).

Comments:
Trace is NOT required to activate AR_DEBUG_FLAG.
So if a Trace is not needed, steps 6, 8 and 10 can be skipped.

References:

Note 152164.1 How To Create A Debug Log File In An AR Form

Get Oracle Certifications for all Exams
Free Online Exams.com

Is there a 64 Bit for Siebel application?

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: Is there a 64 Bit for Siebel application?

Symptoms:
trying to install Siebel on Sun SParc 64 bit OS.

Solution:

Siebel application is a 32-bit application; there is no Siebel 64-bit for Solaris SPARC.
And since Siebel Application is 32-bit application, it will only work with 32 bit database client. So please install and use Oracle client 32-bit and add the respective 32-bit library path on siebenv.sh/siebenv.csh etc.

Get Oracle Certifications for all Exams
Free Online Exams.com

How to troubleshoot hanging jdbc sessions from application connect pool

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: How to troubleshoot hanging jdbc sessions from application connect pool

Symptoms:
Oracle Application server 10.1.3.4 (default jdbc=10.1.0.5)

Hibernate Framework is being used.

Application is not using jdbc API directly. Application is using application server connection pool managed by datasource.

this is a description for set parameters:
we have min connections - 30
inital chache - 30
max connections - 150
incatvity time out - 120

based on this it should be the following:

Log files:
* application.log:
contains errors like this:
11/01/10 19:11:14.166 M2 Declaration webExternal: Broken pipe (errno:32)
11/01/10 19:11:14.167 M2 Declaration webExternal: Servlet error
java.io.IOException: Broken pipe (errno:32)
at sun.nio.ch.FileDispatcher.write0(Native Method)
at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:29)
at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:104)
at sun.nio.ch.IOUtil.write(IOUtil.java:75)
at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:302)
at java.nio.channels.Channels.write(Channels.java:60)
at java.nio.channels.Channels.access$000(Channels.java:47)
at java.nio.channels.Channels$1.write(Channels.java:134)
at com.evermind.server.http.AJPOutputStream.endRequest(AJPOutputStream.java:117)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:317)
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)

* same errors are seen in application_internal.log
11/01/10 19:00:59.927 M2 Declaration webInternal-SSO: Broken pipe (errno:32)
11/01/10 19:00:59.928 M2 Declaration webInternal-SSO: Servlet error
java.io.IOException: Broken pipe (errno:32)
at sun.nio.ch.FileDispatcher.write0(Native Method)
...

* system-application.log:
same errors:
11/01/10 09:58:43.964 dms: Servlet error
java.io.IOException: Broken pipe (errno:32)
at sun.nio.ch.FileDispatcher.write0(Native Method)
at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:29)
..

* log.xml contains a lot like this:

2011-01-10T19:28:04.237+04:00
webservices
OWS-04046

1
jdpuap01.dubaiworld.ae
172.30.112.30
service
197
appsoau

M2 Declaration webInternal-SSO
M2 Declaration Internal-SSO-0.28.0.12
WebServiceCouriorSoapHttpPort
WebServiceCourior

1294673283:172.30.112.30:17491:0:1952

Caught exception while handling request: org.springframework.orm.hibernate3.HibernateOptimisticLockingFailureException: Object of class [com.pcfc.customs.declaration.domain.Declaration] with identifier [7471565]: optimistic locking failed; nested exception is org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [com.pcfc.customs.declaration.domain.Declaration#7471565] org.springframework.orm.hibernate3.HibernateOptimisticLockingFailureException: Object of class [com.pcfc.customs.declaration.domain.Declaration] with identifier [7471565]: optimistic locking failed; nested exception is org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [com.pcfc.customs.declaration.domain.Declaration#7471565]

* Customs~UAT_Customs~Customs~1.log: i assume this is stdout of OC4J(opmn/logs) and contains full thread stacks.

contains errors like this:
11/01/10 18:22:03 java.lang.RuntimeException: failed to evaluate: =Class.new();
11/01/10 18:22:03 Continuing ...
11/01/10 18:22:03 java.lang.InstantiationException: java.math.BigInteger
11/01/10 18:22:03 Continuing ...

will analyze thread dumps with timestamps..

I definitely see a number of threads that are 'hanging' (waiting on the server)
for example the following PreparedStatement objects I found in both thread stacks.. (note that these are not all,but some that I tested to be duplicate:
seconddump.txt: - locked <1fffffff550d7720> (a oracle.jdbc.driver.T4CPreparedStatement)
seconddump.txt: - locked <1fffffff4e1a71f0> (a oracle.jdbc.driver.T4CPreparedStatement)
seconddump.txt: - locked <1fffffff550f55d0> (a oracle.jdbc.driver.T4CPreparedStatement)
seconddump.txt: - locked <1fffffff53c11d50> (a oracle.jdbc.driver.T4CPreparedStatement)
seconddump.txt: - locked <1fffffff4e2d6208> (a oracle.jdbc.driver.T4CPreparedStatement)
seconddump.txt: - locked <1fffffff4cbf5848> (a oracle.jdbc.driver.T4CPreparedStatement)
seconddump.txt: - locked <1fffffff52ad3798> (a oracle.jdbc.driver.T4CPreparedStatement)
seconddump.txt: - locked <1fffffff4f9655b8> (a oracle.jdbc.driver.T4CPreparedStatement)
seconddump.txt: - locked <1fffffff48f25e80> (a oracle.jdbc.driver.T4CPreparedStatement)
seconddump.txt: - locked <1fffffff513656a0> (a oracle.jdbc.driver.T4CPreparedStatement)
seconddump.txt: - locked <1fffffff5514eea0> (a oracle.jdbc.driver.T4CPreparedStatement)
seconddump.txt: - locked <1fffffff4b790ec0> (a oracle.jdbc.driver.T4CPreparedStatement)
seconddump.txt: - locked <1fffffff4b74f128> (a oracle.jdbc.driver.T4CPreparedStatement)
seconddump.txt: - locked <1fffffff4b1887f8> (a oracle.jdbc.driver.T4CPreparedStatement)
seconddump.txt: - locked <1fffffff4b73e188> (a oracle.jdbc.driver.T4CPreparedStatement)
seconddump.txt: - locked <1fffffff4beabb98> (a oracle.jdbc.driver.T4CPreparedStatement)
seconddump.txt: - locked <1fffffff53b4f398> (a oracle.jdbc.driver.T4CPreparedStatement)
seconddump.txt: - locked <1fffffff4b182a70> (a oracle.jdbc.driver.T4CPreparedStatement)
seconddump.txt: - locked <1fffffff4c573d20> (a oracle.jdbc.driver.T4CPreparedStatement)
seconddump.txt: - locked <1fffffff4c5c7ab8> (a oracle.jdbc.driver.T4CPreparedStatement)
seconddump.txt: - locked <1fffffff4b1991e0> (a oracle.jdbc.driver.T4CPreparedStatement)

so it seems that this is taking at least 3 minutes for the RDBMS to process the query... I guess this is what is causing the problem.
I assume this is no real leak but more threads that are spending a lot of time..

Solution:

There are different approaches to this problem.
1. Either your threads are busy on the connections itself or are busy processing
==> for this a kill -3 (on unix/linux) might help you furhter==> this to see if threads are stuck.
2. You have a Connection leak in your application.
This means your thread finished working but did not call the close() on the Connection. (this should normally return a Connection to the pool)
Normally one should code the close() request in a finally block. This to ensure that the code is executed no matter if Exceptions occur.
Solutions could be:
what is configurable is to have an abandonedConnnectionTimeout.

http://download.oracle.com/docs/cd/B25221_05/web.1013/b14427/datasrc.htm#sthref407
Note that if you want to use this feature, you'll need to apply a patch to the OC4J instance (that is using JDBC 10.1.0.5):
Note 730096.1: Timeout of Implicit Connection Cache Causes Deadlock

This because you risk hitting a deadlock when setting abandoned or timetolive timeouts..

When you have hit the limit, can you check:
2.1. What is the OC4J home page showing on the Connections? (and number of threads)?

2.2. Also use dmstool to check the number of open and closed connection calls:

2.2.1 cd $ORACLE_HOME/bin
2.2.2. dmstool -list | grep jdbc or dmstool -list | find "JDBC"
==> this output all things we can monitor
2.2.3. monitor the open and closed and completed requests:
for example in my case:
dmstool -q /tcleyman-lap/OC4J:12501:6003/JDBC/Driver/ConnectionOpenCount.count
dmstool -q /tcleyman-lap/OC4J:12501:6003/JDBC/Driver/ConnectionCloseCount.count
dmstool -q /tcleyman-lap/OC4J:12501:6003/JDBC/Driver/ConnectionCreate.completed

2.3. Did you also check v$session/v$session_wait on database side?
Does this confirm the number of connections opened from OC4J side?
Do you see a number of Connections in waiting for a longer time?

2.4. can you do a couple of kill -3 on the java process (OC4J)?
maybe 3 with 1 minute interval.

*** Issue is resolved by running dbms_stats

issue was caused by queries spending a lot of time in RDBMS.
Seems this was due to index usage, stats were not updated.

References:

Note 402480.1: How To Ensure No ResultSet/Connection/Statement Leaks Exist in Your JDBC Code

Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-06502: PL/SQL: numeric or value error: NULL index table key value,ORA-06512: at "APPS.FA_RX_PUBLISH", line 2153.

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:
On : 11.5.10.2 version, Reports Issues

When attempting to run report for Unapplied Receipts Journal ,
the following error occurs.

ERROR
-----------------------
One or more post-processing actions failed. Consult the OPP service log for details.

Error executing cursor.
ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at "APPS.FA_RX_PUBLISH", line 2153.

Symptoms:
Go to AR receivable manager responsibility.
View menu request->single request and run the below reports.

1) Unapplied Receipts Journal
2) Unapplied and Unresolved Receipts Register

Log files:
See the following error: One or more post-processing actions failed. Consult the OPP service log for details.

Filename = FNDOPP94524.txt
See the following:
Caused by: oracle.xdo.parser.v2.XMLParseException: Start of root element expected.
at oracle.xdo.parser.v2.XMLError.flushErrors1(XMLError.java:324)
at oracle.xdo.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:319)
at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:281)
at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java:266)
... 17 more

Solution:

Issue may be caused due to insufficient memory and incorrect setups in XML Publisher
please follow the action plan in a test environment:
1.
Navigation Path : XML Publisher Administration responsibility
-> Tab : Administration
-> Configuration
-> Properties
-> General
-> Temporary Directory
.
Please specify a directory that has plenty of space.

-> Tab : Data Definition
-> Search for the data definition:
Name: Subledger Period Close Exceptions Report
Application: Subledger Accounting
-> View the data definition
-> On the View Data Definition page, click on the Edit Configuration button (similar
navigation path for Templates)
-> Properties
-> FO Processing
.
2.
Set the following:
Use XML Publisher's XSLT processor = TRUE
Enable scalable feature of XSLT processor = TRUE

3.
Please change the Output for the ARXSGPO and ARXSGP concurrent programs to XML and save
(Sysadmin\Concurrent\Program\Define). Both programs need to be set to XML

4.
Restart the Concurrent Managers

References:

Note 869522.1: Statement Generation Program ending in XDOException "java.lang.reflect.InvocationTargetException".

Get Oracle Certifications for all Exams
Free Online Exams.com

How to generate Form Level Trace and AR Debug log for diagnoses

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: How to generate Form Level Trace and AR Debug log for diagnoses

Solution:

How to generate Form Level Trace and AR Debug log for diagnoses:

Step 1 Setup AR Debug log per Note 152164.1 How To Create A Debug Log File
In An AR Form.

Step 2 Setup Form Level trace

a) Navigate to the form where problem occurs. Begin duplication steps but
Stop steps just before problem occurs.

Goto menubar, Help/Diagnostics/Trace, Select 'With binds and waits'

b) Continue with steps to recreate problem/error. Then Immediately turn
off trace. Goto menubar, Help/Diagnostics/Trace, Select "No trace"

c) How to obtain Trace file if no location/filename were provided when
enabled Trace:

Run script in SQLPlus for trace file location:

SELECT value FROM v$parameter
WHERE name='user_dump_dest';

d) Upload raw and TKprof'd Trace and AR Debug log to this Service Request

References:

Note 152164.1

Get Oracle Certifications for all Exams
Free Online Exams.com

SBL-BPR-00158: Cannot execute workflow process definition 'DC EPG Batch Assignment'.

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: SBL-BPR-00158: Cannot execute workflow process definition 'DC EPG Batch Assignment'.

Symptoms:
when we ran from UI, its in queue & when we ran from comd prompt & we got below error:
srvrmgr:sitsiebsrvr> run task for comp WfProcBatchMgr with SearchSpec = '[Status]="Submitted" AND [DC Security Rating] = "Special Profile"', ProcessName = 'DC EPG RR Declaration Assignment'

run task for comp WfProcBatchMgr with SearchSpec = '[Status]="Submitted" AND [DC Security Rating] = "Special Profile"', ProcessName = 'DC EPG RR Declaration Assignment'
SBL-ADM-60070: Error reported on server 'sitsiebsrvr' follows:
SBL-SVR-01042: Internal: Communication protocol error while instantiating new task SBL-OMS-00203: Error 6750366 invoking method "RunBatch" for Business Service "Workflow Process Manager"
SBL-OMS-00203: Error 6750366 invoking method "RunBatch" for Business Service "Workflow Process Manager"
SBL-OMS-00107: Object manager error: ([0] Cannot execute workflow process definition 'DC EPG RR Declaration Assignment'.(SBL-BPR-00158) (0x67009e))
SBL-OMS-00203: Error (null) invoking method "(null)" for Business Service "(null)"

Solution:

workflow might not be active.
Can you please check for any expiration date for the workflow.
More details can be found in the Doc ID:478671.1.

References:

Doc ID:478671.1.

Get Oracle Certifications for all Exams
Free Online Exams.com

How To Correct Misclassified Accounts in General Ledger in 11i

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: How To Correct Misclassified Accounts in General Ledger in 11i

Inherit Segment Value Attributes’, which is completed with fatal errors PERF0005: Oracle error detected in glnupd() - ORA-01407: cannot update ("GL"."GL_SEGVAL_INHERIT_INT_2020"."DETAIL_PO

On : 11.5.10.2 version, Setup forms and programs

When attempting to run the Program - Inherit Segment Value Attributes, the following error occurs.
PERF0005: Oracle error detected in glnupd() - ORA-01407: cannot update ("GL"."GL_SEGVAL_INHERIT_INT_2020"."DETAIL_PO

Symptoms:

The issue can be reproduced at will with the following steps:
1. Reports : Request : Standard

Log files:
LOG FILE
-----------------------
Filename = Program___Inherit_Segment_Valu_211210.txt
See the following error:
PERF0005: Oracle error detected in glnupd() - ORA-01407: cannot update ("GL"."GL_SEGVAL_INHERIT_INT_2020"."DETAIL_PO

Solution:

The problem could be occuring because the customer is missing some
values from the value set.

To check if values are missing from the value set, see the following script:
SELECT cc.code_combination_id, cc.segmentX
FROM gl_code_combinations cc
WHERE cc.chart_of_accounts_id =
AND cc.segmentX not in
(SELECT 1
FROM fnd_flex_valuesffv
WHERE ffv.flex_value_set_id =
AND ffv.summary_flag = decode(nvl(cc.template_id, -1), -1, 'N',
'Y')
AND ffv.flex_value = cc.segmentX)

segmentX = segment1, segment2, segment3....etc.

You can get the FLEX_VALUE_SET_ID by going to the Value Set form,
query up the segments and do the equivalent of
Help->Tools->Examine.

To Correct Misclassified Accounts in General Ledger in 11i
Please follow the below steps to accomplish your task --

This script is for situations where only a few values are affected but many combinations.
It should be used in its entirety. Copy and paste it into a text file
called comb.sql and ftp or copy it to the server you are running the sql from
and run it there. This is for versions up to 11i only.

REM Changing account types script by Simon Goddard 02-APRIL-2002
PROMPT To run this sql you will need to know the name of your Set of Books
PROMPT the name of the 'Natural account segment'
PROMPT and the Account Type you are changing from and to.
PROMPT WARNING: make sure your finance department have taken the initial steps 1- 7
PROMPT to correct the Misclassified Accounts for all sets of books according to the manual
PROMPT or the note 1050920.6.

select set_of_books_id books_id, name books_name, chart_of_accounts_id chart_id
from gl_sets_of_books;

PROMPT select the chart_id of the set of books you need to change from
PROMPT results above. Ensure journals have been posted for all sets of books affected.
ACCEPT chart_id number PROMPT 'Chart_id: '

select application_column_name segment_num, segment_name
from fnd_id_flex_segments_vl
where id_flex_num=&&chart_id
and (ID_FLEX_CODE='GL#')
and (APPLICATION_ID=101);

PROMPT This gives the column names for all segments.
PROMPT Enter the Account segment from segment_num above as SEGMENT#
ACCEPT segment_num Char PROMPT 'SEGMENT#: '

select code_combination_id ccid, account_type
from gl_code_combinations
where &&segment_num = '&&acct_value'
and chart_of_accounts_id = &&chart_id;

PROMPT This gives a list of what the account type is currently set to
PROMPT store these results as backup
PROMPT To update the combinations press enter else CTRL C
ACCEPT endbit PROMPT 'continue:'

Update gl_code_combinations
set account_type = '&&New_Account_Type'
where &&segment_num = '&&acct_value'
and chart_of_accounts_id = &&chart_id
and account_type= '&Â¤t_account_type';
commit;
select code_combination_id ccid, account_type
from gl_code_combinations
where &&segment_num = '&&acct_value'
and chart_of_accounts_id = &&chart_id;

Clear Buffer

References:

Note 248842.1 - Scripts To Troubleshoot The Error ORA-1407 When Running The Inherit Segment Value Attributes Program

Get Oracle Certifications for all Exams
Free Online Exams.com

Scripts To Troubleshoot The Error ORA-1407 When Running The Inherit Segment Value Attributes Program

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:

Scripts To Troubleshoot The Error ORA-1407 When Running The Inherit Segment Value Attributes Program

Solution:

The Inherit Segment Value Attributes Program terminates with fatal errors.
The log file shows the following information:

...
>> glnupd() 11-SEP-2003 11:38:02
PERF0005: Oracle error detected in glnupd() - ORA-01407: cannot update ("
GL"."GL_SEGVAL_INHERIT_INT_62997"."DETAIL_P

GSVI0004: The Segment Value Inheritance program terminated with fatal errors.
...

ORA-01407: cannot update mandatory (NOT NULL) column to NULL

Run the following queries and provide the information to Oracle Support.

1. Find the different accounting structures defined, use the following script:

select id_flex_structure_name, id_flex_num
from fnd_id_flex_structures_vl
where id_flex_code = 'GL#';

2. Find the identification (set_of_books_id) of corresponding set of books. Use
the following query:

col sob format 9999999
col coa format 9999999
col name format a35
col curr format a3
Select set_of_books_id sob, chart_of_accounts_id coa, name, currency_code curr
from gl_sets_of_books
order by 1;

3. Use the identification of the flexfield found in step 1 to execute the
following query. It gives the accounting structure and displays the name of
each part of the structure and its corresponding database column.:

col app_col format a12
col segment format a15
col num format 999
col value_set format a25
select s.segment_name segment
, s.application_column_name app_col
, s.segment_num num
, s.flex_value_set_id
, f.flex_value_set_name value_set
from fnd_id_flex_segments s
, fnd_flex_value_sets f
where s.id_flex_num = &id_flex_num
and s.application_id = 101
and s.id_flex_code = 'GL#'
and s.flex_value_set_id = f.flex_value_set_id
order by s.segment_num;

4. Check that every segment value used in an account combination exists in a
value set.
Replace segmentN and flex_value_set_id appropriately. This statement needs to be
executed for every segment in the chart of accounts.
SELECT cc.code_combination_id, cc.segmentN
FROM gl_code_combinations cc
WHERE cc.chart_of_accounts_id = &chart_of_accounts_id
AND NOT EXISTS (
SELECT ffv.flex_value
FROM fnd_flex_values ffv
WHERE ffv.flex_value_set_id = &flex_value_set_id_of_segmentN
AND ffv.flex_value = cc.segmentN);

5. Determine order of segment qualifiers.
SELECT rownum, value_attribute_type
FROM (
SELECT value_attribute_type
FROM fnd_flex_validation_qualifiers
WHERE id_flex_code = 'GL#'
AND id_flex_application_id = 101
AND flex_value_set_id = &flex_value_set_id_of_natural_account_segment
ORDER BY assignment_date, value_attribute_type);

6. Check that every segment value has a valid value for the detail posting
allowed and detail budgeting allowed qualifiers.
SELECT flex_value_set_id, flex_value
from fnd_flex_values
where flex_value_set_id in
(select flex_value_set_id
from fnd_id_flex_segments
where application_id = 101
and id_flex_code = 'GL#'
and id_flex_num = &chart_of_accounts_id)
and (substr(compiled_value_attributes, 1, 1) IS NULL
or substr(compiled_value_attributes, 3, 1) IS NULL);

7. Check that every segment value in an independent value set does not have a
parent segment value.
SELECT flex_value_set_id, flex_value
from fnd_flex_values
where flex_value_set_id in
(select fnd.flex_value_set_id
from fnd_id_flex_segments fnd, fnd_flex_value_sets fvs
where fnd.application_id = 101
and fnd.id_flex_code = 'GL#'
and fnd.id_flex_num = &chart_of_accounts_id
and fvs.flex_value_set_id = fnd.flex_value_set_id
and fvs.validation_type = 'I')
and parent_flex_value_low is not null;

8. Execute the programs $FND_TOP/sql/afffckff.sql and $FND_TOP/sql/afffcvst.sql.

References:

Scripts To Troubleshoot The Error ORA-1407 When Running The Inherit Segment Value Attributes Program [ID 248842.1]

Get Oracle Certifications for all Exams
Free Online Exams.com

Siebel Version: 8.0.0.8, Statement Of Issue: Facing performance when navigating in eService Application.

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:
Siebel Version: 8.0.0.8, Statement Of Issue: Facing performance when navigating in eService Application.

Symptoms:
Performance is causing when accessing following BCs:

DC ECR Request: 7 sec
Person: 2 sec
DC ECR Facility: 6 sec

All the threee BCs have in common:
1. Large number of columns queried in the sql
2. Sort order specified.

Log files:
Start time: 2011-01-18 11:20:21

Task Id: 22020428
Process Id and Thread Id: 16882 231
Process Id and Thread Id (Hex): 41f2 e7

Version: 8.0.0.8 [20430] ENU

First two lines of log:

2021 2011-01-18 11:20:21 0000-00-00 00:00:00 +0400 00000000 001 003f 0001 09 PSeServiceObjMgr_enu 22020428 16882 231 /u01/app/siebel/product/8.0.0/siebsrvr/enterprises/uatsiebelent/pcrfap01/log/PSeServiceObjMgr_enu_0021_22020428.log 8.0.0.8 [20430] ENU
TaskConfig TaskCfgParamInit 3 000000d24d3141f2:0 2011-01-18 11:20:21 The Parameters for the current task (22020428) are :

Last two lines of log:

ObjMgrBusServiceLog InvokeMethod 4 000037a74d3362d0:0 2011-01-18 11:21:25 Begin: Business Service 'Web Engine State Properties' invoke method: 'IsFrameless' at b5f0e30
ObjMgrBusServiceLog InvokeMethod 4 000037a74d3362d0:0 2011-01-18 11:21:25 Business Service 'Web Engine State Properties' invoke method 'IsFra

Longest running SQLs :

***** SQL Statement Execute Time for SQL Cursor with ID B6AD110: 3.829 seconds *****
***** SQL Statement Execute Time for SQL Cursor with ID B718470: 3.762 seconds *****
***** SQL Statement Execute Time for SQL Cursor with ID B718470: 3.037 seconds *****
***** SQL Statement Execute Time for SQL Cursor with ID B718470: 3.002 seconds *****

=================================

Log File name >>> New_Fac_PSeServiceObjMgr_ecr_enu_0029_30408760.log

Start time: 2011-01-18 11:53:59
End time: 0000-00-00 00:00:00

Task Id: 30408760
Process Id and Thread Id: 16952 47
Process Id and Thread Id (Hex): 4238 2f

Version: 8.0.0.8 [20430] ENU

First two lines of log:

2021 2011-01-18 11:53:59 0000-00-00 00:00:00 +0400 00000000 001 003f 0001 09 PSeServiceObjMgr_ecr_enu 30408760 16952 47 /u01/app/siebel/product/8.0.0/siebsrvr/enterprises/uatsiebelent/pcrfap01/log/PSeServiceObjMgr_ecr_enu_0029_30408760.log 8.0.0.8 [20430] ENU
TaskConfig TaskCfgParamInit 3 000000244d314238:0 2011-01-18 11:53:59 The Parameters for the current task (30408760) are :

Last two lines of log:

ProcessRequest ProcessRequestDetail 4 00007daa4d313276:0 2011-01-18 11:58:13 SWE Command Processor - Handle user request: SWECmd=GetCachedFrame;SWEACn=28194;SWEC=21;SWEFrame=top._sweclient._sweviewbar;
ProcessR

Longest running SQLs:
***** SQL Statement Execute Time for SQL Cursor with ID F5D8210: 6.753 seconds *****
***** SQL Statement Execute Time for SQL Cursor with ID F557EF0: 6.584 seconds *****
***** SQL Statement Execute Time for SQL Cursor with ID F557EF0: 6.580 seconds *****
***** SQL Statement Execute Time for SQL Cursor with ID F55B070: 6.576 seconds *****

EventContext >>

EventContext EvtCtxView 3 00007d9d4d313276:0 2011-01-18 11:57:02 DC ECR Amend Terms View
EventContext EvtCtxApplet 4 00007d9f4d313276:0 2011-01-18 11:57:17 DC ECR Amend Terms Conditions Applet (eService) (DCWriteRecord)
EventContext EvtCtxView 3 00007d9f4d313276:0 2011-01-18 11:57:17 DC ECR Amend Create Facilities View (eService)
EventContext EvtCtxApplet 4 00007e724d31327a:0 2011-01-18 11:57:45 DC ECR Amend Request Form Applet (eService) (WriteRecord)
EventContext EvtCtxApplet 4 00007da84d313276:0 2011-01-18 11:58:00 DC ECR Amend Request Form Applet (eService) (Submit)
EventContext EvtCtxView 3 000000524d314238:0 2011-01-18 11:58:13 DC ECR Amend Confirmation View (eService)

================

Log File name >>> Track_Req_PSeServiceObjMgr_enu_0021_22020443.log

Start time: 2011-01-18 11:27:20

Task Id: 22020443
Process Id and Thread Id: 16882 241
Process Id and Thread Id (Hex): 41f2 f1

Version: 8.0.0.8 [20430] ENU

First two lines of log:

2021 2011-01-18 11:27:20 0000-00-00 00:00:00 +0400 00000000 001 003f 0001 09 PSeServiceObjMgr_enu 22020443 16882 241 /u01/app/siebel/product/8.0.0/siebsrvr/enterprises/uatsiebelent/pcrfap01/log/PSeServiceObjMgr_enu_0021_22020443.log 8.0.0.8 [20430] ENU
TaskConfig TaskCfgParamInit 3 000001494d3141f2:0 2011-01-18 11:27:20 The Parameters for the current task (22020443) are :

Last two lines of log:

ObjMgrBusServiceLog InvokeMethod 4 000038474d3362d0:0 2011-01-18 11:28:11 Business Service 'Web Engine State Properties' invoke method 'IsFrameless' Execute Time: 0.000 seconds.
ObjMgrBusServiceLog InvokeMethod 4 000038474d3362d0:0 2011-01-18 11:28:11 End: Bus

EventContext trace >>>

EventContext EvtCtxView 3 000038154d3362d0:0 2011-01-18 11:27:20 PUB GOV Home Page View (eService)
EventContext EvtCtxScreen 3 000038154d3362d0:0 2011-01-18 11:27:20 no accessible views found for screen PUB GOV Home Screen (eService)
EventContext EvtCtxView 3 000038324d3362d0:0 2011-01-18 11:27:43 DC ECR Amend Track Registration View (eService)
EventContext EvtCtxApplet 4 000038344d3362d0:0 2011-01-18 11:27:51 DC ECR Amend Track Registration Applet (eService) (NewQuery)
EventContext EvtCtxApplet 4 000038354d3362d0:0 2011-01-18 11:27:51 DC ECR Amend Track Registration Applet (eService) (ExecuteQuery)
EventContext EvtCtxApplet 4 000038364d3362d0:0 2011-01-18 11:27:51 DC ECR Amend Track Registration Applet (eService) (DCContinue)
EventContext EvtCtxView 3 000038364d3362d0:0 2011-01-18 11:27:51 DC ECR Amend User Creation Vew (eService)
EventContext EvtCtxApplet 4 0000383b4d3362d0:0 2011-01-18 11:27:54 DC ECR Amend New User Creation Applet (eService) (Drilldown)
EventContext EvtCtxView 3 0000383b4d3362d0:0 2011-01-18 11:27:54 DC ECR Amend User Creation Detail View (eService)
EventContext EvtCtxApplet 4 0000383f4d3362d0:0 2011-01-18 11:27:55 DC ECR Amend User Roles Creation List Applet (eService) (NewRecord)
EventContext EvtCtxApplet 4 000038404d3362d0:0 2011-01-18 11:27:55 DC ECR Amend User Roles Creation List Applet (eService) (WriteRecord)
EventContext EvtCtxApplet 4 000038414d3362d0:0 2011-01-18 11:27:55 DC ECR Amend New User Creation Form Applet (eService) (WriteRecord)
EventContext EvtCtxView 3 000038414d3362d0:0 2011-01-18 11:27:56 DC ECR Amend User Creation Vew (eService)
EventContext EvtCtxApplet 4 000038444d3362d0:0 2011-01-18 11:27:59 DC ECR Amend Request Form Applet (eService) (WriteRecord)
EventContext EvtCtxApplet 4 000038454d3362d0:0 2011-01-18 11:27:59 DC ECR Amend Request Form Applet (eService) (Submit)
EventContext EvtCtxView 3 000001654d3141f2:0 2011-01-18 11:28:11 DC ECR Amend Confirmation View (eService)

Longest Running SQLs >>

Solution:

Facing performance when navigating in eService Application.
Issue is resolved now after creating indexes on the extension tables.

Get Oracle Certifications for all Exams
Free Online Exams.com