Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Friday, August 26, 2011

OTM HTTP-400 Bad Request

Some users reported HTTP-400 Bad Request errors in ERPOTMD1. Here's what was happening:

1. If the first window you open was an OTM instance, everything worked fine.

2. If you started E-Business Suite and then accessed OTM, HTTP-400 Bad Request would result.

3. This was happening in IE8, Firefox6.

4. Apache error.log showed:

[Wed Aug 24 14:41:43 2011] [error] [client 3.75.208.77] request failed: error reading the headers


I googled and found this:

http://allthingsunix.inside.quest.com/thread.jspa?threadID=4667

This post advised:

request headers can be quite long, try setting

LimitRequestFieldsize 12392


in the server context.

See http://httpd.apache.org/docs/2.2/mod/core.html#limitrequestfieldsize

So I checked the value of this variable in Apache httpd.conf and found that it was set to:

LimitRequestFieldSize 2048
LimitRequestLine 4096


I changed it to

LimitRequestFieldSize 20480
LimitRequestLine 40960


And bounced Apache and Weblogic.

Problem was resolved. For official confirmation from Oracle about this fix, I logged SR. Oracle OTM Development was ok with this change.

Wednesday, August 17, 2011

adgendbc.sh java.sql.SQLException: Invalid number format for port number

Bimal asked me about this one. While running adconfig on an R12 clone, the following error was being reported:

Unique constraint error (00001) is OK if key already exists

Creating the DBC file...
java.sql.SQLException: SO Exception was generated
Database connection to jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=R1213q2.justanexample.com)(PORT=1553)))(CONNECT_DATA=)) failed
ADD call failed with exit code 1

Updating Server Security Authentication
java.sql.SQLException: Invalid number format for port number
Database connection to jdbc:oracle:thin:@host_name:port_number:database failed
Updating Server Security Authentication failed with exit code 1
Restoring DBC file from backed up location $INST_TOP/appltmp/TXK/R1213q2_Wed_Aug_17_14_32_2011.dbc

adgendbc.sh ended at Wed Aug 17 14:32:04 EDT 2011

adgendbc.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.
****************************************************

We noticed the blank CONNECT_DATA and did node cleanup and re-ran autoconfig. However it still failed:

Unique constraint error (00001) is OK if key already exists

Creating the DBC file...
java.sql.SQLRecoverableException: No more data to read from socket raised getting GUEST_USER_PWD - ignoring
java.sql.SQLRecoverableException: No more data to read from socket- Database error performing ADD

ADD call failed with exit code 1

Updating Server Security Authentication
java.sql.SQLException: Invalid number format for port number
Database connection to jdbc:oracle:thin:@host_name:port_number:database failed
Updating Server Security Authentication failed with exit code 1
Restoring DBC file from backed up location $INST_TOP/appltmp/TXK/R1213q2_Wed_Aug_17_16_11_2011.dbc

adgendbc.sh ended at Wed Aug 17 16:11:16 EDT 2011

adgendbc.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.
Unable to update GUEST_USER_PWD in database to GUEST/ORACLE - java.sql.SQLRecoverableException: No more data to read from socket

After a lot of searching in My Oracle Support I found this article: Adgendbc Fails With Database Connection Failure [ID 1302708.1]. It asked us to do this:

The following change to the database parameters allows Autoconfig, and specifically adgenfbc.sh, to complete successfully. Please make this change and then re-run autoconfig.

alter system set JAVA_JIT_ENABLED= FALSE scope = both;

We did this, but the error still appeared.

So we bounced the database. After bouncing the database it worked fine:


$ cd $INST_TOP/admin/install
$ ./adgendbc.sh

adgendbc.sh started at Wed Aug 17 16:20:52 EDT 2011


Enter the APPS username: apps

Enter the APPS password:

SQL*Plus: Release 10.1.0.5.0 - Production on Wed Aug 17 16:21:02 2011

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

Enter value for 1: Enter value for 2: Enter value for 3: Connected.
[ APPS_DATABASE_ID ]
Application Id : 0
Profile Value : orpogpq2
Level Name: SITE
INFO : Updated/created profile option value.
.

PL/SQL procedure successfully completed.


Commit complete.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options


==============================
* * * * DBC PARAMETERS * * * *
==============================
fnd_jdbc_buffer_min=1
fnd_jdbc_buffer_max=5
fnd_jdbc_buffer_decay_interval=300
fnd_jdbc_buffer_decay_size=5
fnd_jdbc_usable_check=false
fnd_jdbc_context_check=true
fnd_jdbc_plsql_reset=false



====================================
* * * * NO CUSTOM PARAMETERS * * * *
====================================



Unique constraint error (00001) is OK if key already exists

Creating the DBC file...
ADD executed successfully - $INST_TOP/appl/fnd/12.0.0/secure/orpogpq2.dbc

Updating Server Security Authentication
AUTHENTICATION SECURE executed successfully - $INST_TOP/appl/fnd/12.0.0/secure/R1213q2.dbc

adgendbc.sh ended at Wed Aug 17 16:21:39 EDT 2011

adgendbc.sh exiting with status 0
ERRORCODE = 0 ERRORCODE_END