Showing posts with label e-Business Suite:Troubleshooting. Show all posts
Showing posts with label e-Business Suite:Troubleshooting. Show all posts

Monday, July 4, 2011

How to Gather HTTP Header Information From a Client PC

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
how to capture HTTP Header information from the client browser



Internet Explorer - ieHTTPHeaders


Please download ieHTTPHeaders from http://www.blunck.se/iehttpheaders.html



a:- Install the downloaded executable
b:- Open a new Internet Explorer session

c:- Activate the IEHTTPHeader window by selecting
"View/Explorer Bar/ieHTTPHeaders"
From your Internet Explorer menu bar. This will bring up a Window of HTTP header data that will accumulate as you navigate from place to place.

d:- Replicate the problem as directed in the SR.
e:- Click the "HEADERS VIEW" tab in the ieHTTPHeaders window
f:- Right click the "HEADERS VIEW" page and choose save
e:- Upload the file created.

Firefox - Live HTTP Headers

LiveHTTP headers is available as an xpi, under the installation tab:  http://livehttpheaders.mozdev.org 



a:- Install the downloaded executable
b:- Open a new Mozilla Firefox session

c:- Enable LiveHTTPheaders by choosing  "Tools / LiveHTTPHeaders".
This will bring up a Window of HTTP header data that will accumulate as you navigate from place to place.

d:- Replicate the problem as directed in the SR.

e:- Click the "Save All" button and upload the file created.





    

Get Oracle Certifications for all Exams
Free Online Exams.com

Tuesday, June 21, 2011

ORA-00600: internal error code, arguments: [xschkmk:!dict], [], [], [], [], [],

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem Description: Runnng data pump on ERP instance gave ORA-600 error


While running expdp on ERP instance, I am getting ORA-33272: Analytic workspace ZPB.ZPBANNOT cannot be opened
ORA-00600 internal error code , arguments [xschkmk:!dict]



Explanation:


set serverout on
call dbms_aw.execute('aw list');
call dbms_aw.execute('aw attach ZPB.ZPBANNOT ro; aw list');
call dbms_aw.execute('shw statlen(name)');

SQL> set serverout on
SQL> call dbms_aw.execute('aw list');
EXPRESS R/O UNCHANGED SYS.EXPRESS

Call completed.

SQL> call dbms_aw.execute('aw attach ZPB.ZPBANNOT ro; aw list');
call dbms_aw.execute('aw attach ZPB.ZPBANNOT ro; aw list')
*
ERROR at line 1:
ORA-33272: Analytic workspace ZPB.ZPBANNOT cannot be opened.
ORA-00600: internal error code, arguments: [xschkmk:!dict], [], [], [], [], [],
[], []
ORA-06512: at "SYS.DBMS_AW", line 93
ORA-06512: at "SYS.DBMS_AW", line 122


SQL> call dbms_aw.execute('shw statlen(name)');
call dbms_aw.execute('shw statlen(name)')
*
ERROR at line 1:
ORA-34496: The NAME dimension is available only when you have an active
analytic workspace.
ORA-06512: at "SYS.DBMS_AW", line 93
ORA-06512: at "SYS.DBMS_AW", line 122

SQL>


The object affected is a so-called 'Analytical Workspace' (AW for short)
where the Oracle OLAP option is storing its data.
During the exp (either via exp or expdp) an OLAP routine is internally
triggered in order to perform the export for the AW's that are part of the objects
to be exported. When the system tries to open one of them, it is failing.
In order to see how bad the damage is, can you please perform the following steps
for me as SYS:


The AW affected is used by Enterprise Planning and Budgetting
which is in turn part of Oracle Financials.



Solution:


The Analytical Workspace (AW) ZPBANNOT owned by the user ZPB is
no longer accessible and therefor damaged beyond repair.

The AW is physicall stored in a table call AW$ZPBANNOT. So what I would suggest to do is
go for a backup and restore this table to another schema to see (using the commands
given blow) whether the AW can be opened. If this is the case, then restore to production
and then make sure that the users are made aware of that as there may be a discrepancy in the data
between what is lost and what is in the restored AW.
The other alternative is (to be discussed with the users) whether there is a possibility
to re-generate this AW by reloading the data . But I am no EPB specialist,
so this is not something that I am in a position to comment.



    
Get Oracle Certifications for all Exams
Free Online Exams.com

Saturday, June 18, 2011

Users cannot run arabic FSG reports in gl or report manager

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 view XML input using XSl stylesheet. Please correct the error
and click Refresh button, or try again later

An invalid character was found in text content
Error processing resource 



"FSG: Database Codeset" profile does not exist while it is mandatory where the codeset is non utf-8.

Running the Program - publish FSG report:
RGFSGXML module: Program - Publish FSG Report

+------------- 1) PUBLISH -------------+
Beginning post-processing of request 521394 on node ERPDEV at 04-FEB-2010 14:19:05.
Post-processing of request 521394 failed at 04-FEB-2010 14:19:16 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.

Publisher log shows the error:
[2/4/10 2:19:16 PM] [UNEXPECTED] [28569:RT521394] java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:517)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:224)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:177)
at
.....

oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:172)
Caused by: java.io.UTFDataFormatException: Invalid UTF8 encoding.

Codeset is:
ISO-8859-6

"FSG: Database Codeset" profile does not exist. 



This is causing the issue as XML is using a wrong codeset to generate the output.
The logfile confirms:
oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:172)
Caused by: java.io.UTFDataFormatException: Invalid UTF8 encoding.






Explanation:


On : 12.0.6 version, Core Functionality

When attempting to submit and publish an FSG report in arabic, the following error occurs.
Submitting this report shows waring in completion.
Also Submitting the report in report manager seems to complete fine, but little squares are shown instead of arabic data



The profile is mandatory when the codeset is a non utf-8 one. 


Solution: Define "FSG: Database Codeset" profile, point it to the correct codeset and retest. 


1. Change the setup as following:
Go to "Application Developer" -> Profile and create a new profile with:
Name: RG_XML_CODESET
Application: Application Report Generator
User Profile Name: FSG: Database Codeset
Description: Database Codeset
Active Dates Start: 01/01/1951
All check boxes should be checked.
Save

2. Go to "System Administrator" -> Profiles -> System and query all profiles with name starting with "FSG%".
Go to the profile "FSG: Database Codeset" , enter your codeset value ISO-8859-6 at the site level and save. 



Reference:


Note 470233.1 'Generating Fsg Xml Publisher Report Ends in 'Invalid UTF8 Encoding' Error' -is relevant for the issue, shows how to check the codeset. This is most probably set incorrectly.


    
Get Oracle Certifications for all Exams
Free Online Exams.com

Wednesday, June 15, 2011

OPMN Report Error 'BAD STRING' When Checking the Apps Services Status on Solaris

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: OPMN Report Error 'BAD STRING' When Checking the Apps Services Status on Solaris
 cd $ADMIN_SCRIPTS_HOME

./adopmnctl.sh status & ./adapcctl.sh fails with the following error:


./adopmnctl.sh status

You are running adopmnctl.sh version 120.4.12000000.3

Checking status of OPMN managed processes...
Bad string
Unable to connect to opmn.
Opmn may not be up.

adopmnctl.sh: exiting with status 0

*******

Cause:

The opmnctl script makes use of the UNIX command "tr" as

MODIFIED_ORA_CONFIG_HOME="`echo $ORACLE_CONFIG_HOME | tr -d "[:space:]"`"

While running adopmnctl.sh, the environment file .env under $ORA_CONFIG_HOME/10.1.3 is sourced.
.env gets instantiated from template iAS_1013_env.tmp under $AD_TOP.

The template file has env variable PATH variable defined as $ORACLE_HOME/bin:$ORACLE_CONFIG_HOME/opmn/bin:$ORACLE_CONFIG_HOME/Apache/Apache/bin:$ORACLE_HOME/Apache/Apache/bin:$ORACLE_HOME/oui/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/appsutil/jdk/bin:$ORACLE_HOME/jdk/jre/bin:$ORACLE_HOME/perl/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:$PATH"

The "tr" command from /usr/bin is picked up for execution as per the PATH environment variable. As per Solaris documentation mentioned below to use "tr" command, /usr/xpg4/bin should be used. This is the root cause of the bug.

On Solaris, if the command "tr" from /usr/bin is used, the character class expressions "[:space:]" is not recognized in multibyte support environment (MSE).
As per Solaris documentations, in such cases, the "tr" command from /usr/xpg4/bin should be used.


For Solaris documentation:
You can see the note below in manual pages for tr command by executing `man tr` command.

Note: /usr/bin/tr supports character class expressions only in singlebyte locales. Use /usr/xpg4/bin/tr to support these expressions in any locale.



Solution:


Take backup for /usr/bin/tr
copy /usr/xpg4/bin/tr /usr/bin


    
Get Oracle Certifications for all Exams
Free Online Exams.com