Tuesday, May 8, 2012

XML Report Error ( java.lang.reflect.InvocationTargetException ) or ( oracle.xdo.parser.v2.XMLParseException: Expected name instead of . )

XML Report Log Error Message

Template code: TEMPLATE_NAME
Template app:  GMI
Language:      en
Territory:     00
Output type:   PDF
[5/8/12 1:56:05 PM] [UNEXPECTED] [347969:RT17367773] java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:517)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:224)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:177)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1044)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:997)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)
at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1657)
at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:967)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5888)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3438)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3527)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:247)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:157)
Caused by: oracle.xdo.parser.v2.XMLParseException: Expected name instead of  .
at oracle.xdo.parser.v2.XMLError.flushErrors1(XMLError.java:337)
at oracle.xdo.parser.v2.XMLReader.scanNameChars(XMLReader.java:1061)
at oracle.xdo.parser.v2.XMLReader.scanQName(XMLReader.java:1871)
at oracle.xdo.parser.v2.XMLReader.getEntity(XMLReader.java:2125)
at oracle.xdo.parser.v2.NonValidatingParser.parseContentEntityRef(NonValidatingParser.java:1654)
at oracle.xdo.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1272)
at oracle.xdo.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:338)
at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:285)
at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java:289)
... 16 more
Reason -
Some Column having the special chr contents

Solution-
Remove the special chr from the report columns or use replace function for removing the special chr at report level.

Wednesday, April 18, 2012

ORA-01031 insufficient privileges sysdba login

Error
$ sqlplus /nolog
SQL>conn sys/xxx as sysdba;
error: "ORA-01031: insufficient privileges" 

Solution

$ORACLE_SID=oracle
$export ORACLE_SID
$ORACLE_HOME=/db/oracle/9.2.0
$export ORACLE_HOME
$cd /db/oracle/9.2.0/dbs
$mv orapworacle9i orapworacle9i_bk
$cd /db/oracle/9.2.0/bin
$orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=xxx entries=40
$ sqlplus /nolog
SQL>conn sys/xxx as sysdba;
Connected to an idle instance.
Check the metalink Document

SYSDBA and SYSOPER Privileges in Oracle [ID 50507.1]
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=50507.1

Monday, April 9, 2012

EM install failed AIX 6.1 Database 11gR1

bash-3.00$ emca -config dbcontrol db -repos recreate
STARTED EMCA at Apr 10, 2012 12:34:14 AM
EM Configuration Assistant, Version 11.1.0.7.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
Enter the following information:
Database SID: STAR
Unhandled exception
Type=Segmentation error vmState=0x00000000
J9Generic_Signal_Number=00000004 Signal_Number=0000000b Error_Value=00000000 Signal_Code=00000033
Handler1=09001000A03E0C78 Handler2=09001000A03D8538
R0=0000000000000000 R1=0FFFFFFFFFFFDF70 R2=0000000000000001 R3=0000000000000017
R4=0700000000353830 R5=00000000000000B8 R6=0000000000000000 R7=0000000000000018
R8=0000000000000000 R9=0000000000000001 R10=00000001101EC908 R11=09000000009B2C38
R12=00000001101CF0E4 R13=0000000110015FA0 R14=0000000111562800 R15=000000011016BF00
R16=0000000110A02270 R17=00000001122F39E8 R18=09001000A03E43B0 R19=0700000000000FA0
R20=000000011148FD08 R21=0000000111562968 R22=0000000000000032 R23=000000000000002A
R24=00000000995188BE R25=07000000003533C8 R26=FFFFFFFFFFFFFFFF R27=0000000000000017
R28=070000000035FF48 R29=0000000000000001 R30=0000000000000016 R31=0000000000000000
IAR=09000000009B2C38 LR=00000001101ECABC MSR=A00000000000D032 CTR=09000000009B2C38
CR=8458508420000003 FPSCR=8202000000000000 XER=2000000382020000
FPR0 0000000800000008 (f: 8.000000, d: 1.697597e-313)
FPR1 41e0000000000000 (f: 0.000000, d: 2.147484e+09)
FPR2 3fe8000000000000 (f: 0.000000, d: 7.500000e-01)
FPR3 3fee666660000000 (f: 1610612736.000000, d: 9.500000e-01)
FPR4 4530000000000000 (f: 0.000000, d: 1.934281e+25)
FPR5 4530000000000000 (f: 0.000000, d: 1.934281e+25)
FPR6 3ff0000000000000 (f: 0.000000, d: 1.000000e+00)
FPR7 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR8 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR9 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR10 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR11 4026000000000000 (f: 0.000000, d: 1.100000e+01)
FPR12 3fe8000000000000 (f: 0.000000, d: 7.500000e-01)
FPR13 4020800000000000 (f: 0.000000, d: 8.250000e+00)
FPR14 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR15 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR16 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR17 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR18 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR19 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR20 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR21 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR22 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR23 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR24 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR25 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR26 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR27 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR28 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR29 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR30 0000000000000000 (f: 0.000000, d: 0.000000e+00)
FPR31 0000000000000000 (f: 0.000000, d: 0.000000e+00)
Module=/pd/Star/db/tech_st/11.1.0/jdk/jre/bin/libj9jit23.so
Module_base_address=0900000000988000
Target=2_30_20070131_11312_BHdSMr (AIX 6.1)
CPU=ppc64 (32 logical CPUs) (0x7b8000000 RAM)
JVMDUMP006I Processing Dump Event "gpf", detail "" - Please Wait.
JVMDUMP007I JVM Requesting System Dump using '/pd/Star/db/tech_st/11.1.0/bin/core.20120410.003419.9437226.dmp'
JVMDUMP010I System Dump written to /pd/Star/db/tech_st/11.1.0/bin/core.20120410.003419.9437226.dmp
JVMDUMP007I JVM Requesting Snap Dump using '/pd/Star/db/tech_st/11.1.0/bin/Snap0001.20120410.003419.9437226.trc'
JVMDUMP010I Snap Dump written to /pd/Star/db/tech_st/11.1.0/bin/Snap0001.20120410.003419.9437226.trc
JVMDUMP007I JVM Requesting Java Dump using '/pd/Star/db/tech_st/11.1.0/bin/javacore.20120410.003419.9437226.txt'
JVMDUMP010I Java Dump written to /pd/Star/db/tech_st/11.1.0/bin/javacore.20120410.003419.9437226.txt
JVMDUMP013I Processed Dump Event "gpf", detail "".

----

bash-3.00$ java -version
java version "1.6.0"
Java(TM) SE Runtime Environment (build pap3260-20071123_01)
IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 AIX ppc-32 jvmap3260-20071121_15015 (JIT enabled)
J9VM - 20071121_015015_bHdSMR
JIT  - r9_20071121_1330
GC   - 20071031_AA)
JCL  - 20071118_01

---

The solution for this error is run below command before starting the task
export JAVA_COMPILER=NONE