RSS

Category Archives: Action_Plan

Action_Plan: steps to achieve a goal

XML Publisher Report Errors Due To: JAVA.IO.UNSUPPORTEDENCODINGEXCEPTION: &ENCODING

XML Publisher Report Errors Due To: JAVA.IO.UNSUPPORTEDENCODINGEXCEPTION: &ENCODING

APPLIES TO:
BI Publisher (formerly XML Publisher) – Version 10.1.3.2.0 to 11.1.1.5.0 [Release 10.1 to 11.1]
Oracle Application Object Library – Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
SYMPTOMS:
Using XML Publisher to generate a custom report.
You created an RDF report, configured it as a concurrent program,
changed output to XML and created a .rtf template in XML Publisher in order to have output in .pdf
When run, no output is generated.
The OPP log contains errors Caused by: java.io.UnsupportedEncodingException: &Encoding

CAUSE:
Incorrect encoding value in the report’s prolog

SOLUTION:
To resolve the issue:

1.Open the custom report in the Report Builder

2.Go to the property pallette of the Report

3.Remove the xml prologue value

4.Save the changes

5.Retest the issue.

 

Reference:

Doc ID 1051228.1

 

Tags: ,

compile jsp in EBS R12

compile jsp in EBS R12

Compile a jsp page:
cd $OA_HTML
$FND_TOP/patch/115/bin/ojspCompile.pl –compile -s ‘xxxx.jsp’ -log err.log –flush

Compile all jsp pages:
$FND_TOP/patch/115/bin/ojspCompile.pl –compile  –flush -p 4

Enable Automatic Compilation of JSP pages in R12
edit the $CONTEXT_FILE
Change value for the entry s_jsp_main_mode from justrun to recompile

run AutoConfig, restart the web tier services.

 

Tags:

Unable to determine SMTP server to use: set FND_SMTP_HOST

Problem:
Unable to determine SMTP server to use: set FND_SMTP_HOST

Symptoms:
– report ends with Warning
-the report log file shows ==> 1) PUBLISH ————-+ Emailing output to xx@xxx.xxx
– with consulting OPP log file shows ==> [UNEXPECTED] [51410:RT648550] oracle.apps.fnd.cp.opp.PostProcessorException: Unable to determine SMTP server to use: set FND_SMTP_HOST

Solution:
Change the profile option :
FND: SMTP Host –-> Give your smtp server name or IP
FND: SMTP Port –-> give your smtp server port (By default – 25).

 
1 Comment

Posted by on September 3, 2014 in Action_Plan, apps_dba, E-Business Suite

 

Tags: , , , ,

XML Report Publisher Fails With java.lang.OutOfMemoryError

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

Symptoms:
– report ends with Warning
– with consulting OPP log file shows ==> Caused by: java.lang.OutOfMemoryError: Java heap space

Solution:
1. First test how much memory you can create in OS using the following command
$java -mx2700m -version

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

3. Increase the Heap Space per Process to 1024 or to maximum result of OS command:
update FND_CP_SERVICES
set DEVELOPER_PARAMETERS =’J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx1024m’
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME = ‘FNDCPOPP’);
commit;

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

5. Restart the concurrent managers
 

Tags: , , , , , , ,

Gaps Resolving in DataGuard Physical Standby Using RMAN Incremental Backup

1) defer log transfer from Primary Database
SQL>alter system set log_archive_dest_state_2=’DEFER’ scope=MEMORY;

2) record last sequence from Primary and Standby
SQL> archive log list;
or use sql:
SQL> SELECT ARCH.THREAD# “Thread”, ARCH.SEQUENCE# “Last Sequence Received”, APPL.SEQUENCE# “Last Sequence Applied”, (ARCH.SEQUENCE# – APPL.SEQUENCE#) “Difference” FROM (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#))ARCH, (SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL WHERE ARCH.THREAD# = APPL.THREAD# ORDER BY 1;

3) record last SCN
SQL> select to_char(current_scn) from v$database;
e.g.:
Primary==> 5973814619607
Standby==> 5973624753925

you can also know when the gap happens by:
SQL>select scn_to_timestamp(5973624753925) from dual;

4) stop log apply on Standby
SQL>alter database recover managed standby database cancel;

5)Perform Rman Incremental backup from Primary database to backup the gap starting from Standby SCN
RMAN>run {
allocate channel c1 type disk format ‘/tmp/gapresolve/%U.rmb’;
backup incremental from scn 5973624753925 database;
}

6) Take a buckup from the current Primary Control file
SQL>alter database create standby controlfile as ‘/tmp/gapresolve_standby.ctl’;
7) transfer the backup spices and control file to Standby machine
$scp file user@machine:/directory
$scp /tmp/gapresolve/*.rmb oracle@sdbypc:/tmp/gapresolve/

8)start Standby db
SQL>startup nomount

9) allocate Standby database control file
SQL>show parameter control_files
==> /oracle_home/dbs/stdbycontrol.dbf

10)replace it with Primary backed up control file
$cp /tmp/gapresolve_standby.ctl /oracle_home/dbs/stdbycontrol.dbf
10) mount Standy database in standby state
SQL>alter database mount standby database;

11)start rman on standby
$rman target=/

12)catalog backup spices
RMAN>catalog start with ‘/tmp/gapresolve’;

13) recover the database
RMAN>recover database;

14) in some new created datafile need to be restored first, so a error massage came:
RMAN-03002: failure of recover command at 08/23/2014 12:41:19
RMAN-06094: datafile 61 must be restored
so just restore that file by:
RMAN>restore datafile 61;

15) rman recovery ends with and error that requesting current log file, we can ignore this error

16) on Standby database, check the current SCN
SQL> select to_char(current_scn) from v$database;

17) on Standby database, resume log apply
SQL> alter database recover managed standby database disconnect from session;

18) on Primary, resume log transfer
alter system set log_archive_dest_state_2=’ENABLE’ scope=MEMORY;

19)frequently check the scn
SQL> select to_char(current_scn) from v$database;

 
 

Tags: , , , , ,

R12- Unable to Authenticate Session

this is one of the common problem with common solution

On the target “Cloned” of a E-Business Suite Release 12.1.3, the logon is failing with following error :

Unable to Authenticate Session

SOLUTION:

1. Clear the Browser cache.

2. Stop all Browser sessions.

3. Start a new Browser session and logon to the Instance.

 

Tags: , , ,

R12 after clone Error -FRM-92101 – on OEL5.7

after cloning R12 instance on OEL 5.7 64bit to TEST instance and when I started services normally, an error apprears when access the forms, getting the following error

FRM-92101: There was a failure in the Forms Server during startup. This could happen due to invalid configuration. Please look into the web-server log file for details

 
Java Exception
oracle.forms.net.ConnectionException:Forms sessionfailed during startup:no response from runtime process
at oracle.forms.net.ConnectionException.createConnectionException(Unknown Source)
at oracle.forms.net.HTTPNStream.getResponse(Unknown source)
at oracle.forms.net.HTTPNStream.doFlush(Unknown Source)
at oracle.forms.net.HTTPNStream.flush(Unknown Source)
at java.io.DataOutputStream.flush(Unknown source)
…………………………………………………………..

I have looked into the forms server log file which is given below

$LOG_HOME/ora/10.1.3/opmn/forms_default_group_1/formsstd.out

and found the following error

FormsServlet init():
configFileName: /u01/DEV/inst/apps/DEV_mkhots06/ora/10.1.2/forms/server/appsweb.cfg
testMode: false
Oracle Containers for J2EE 10g (10.1.3.4.0) initialized
ListenerServlet init()
Forms session <1> aborted: runtime process failed during startup with errors <ORACLE_HOME>/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

Forms session <2> aborted: runtime process failed during startup with errors <ORACLE_HOME>/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

Forms session <3> aborted: runtime process failed during startup with errors <ORACLE_HOME>/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

Cause:

The Actual cause of this error for my test instance is that openmotif package not installed along with pre-requisites for R12 in TEST instance server.

rpm -Uhv binutils-2.17.50.0.6-6.0.1.el5.x86_64.rpm
rpm -Uhv xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm
rpm -Uhv openmotif21-2.1.30-11.EL5.i386.rpm

then after that i hav relinked the frmweb executable of forms server after shutting the apps services by giving the following commands

$cd $ADMIN_SCRIPTS_HOME

$adstpall.sh apps/

Then

$cd $ORACLE_HOME/forms/lib

$make -f ins_forms.mk install

Then restarted the services using adstrtal.sh apps/

Now there is no issue of form errors and was able to access the forms from my TEST instance.

 

Tags: , ,