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

Wednesday, October 31, 2007

ORA-06502: PL/SQL: numeric or value error: associative array shape is not consistent with session parameters

During peak usage today, in the newly upgraded 11.5.10.2/10.2.0.3 instance, users were unable to login to E-Business Suite and reported errors like Internal Server Error, or

You have encountered an unexpected error. Please contact the System Administrator for assistance

Following error was logged in jserv.log:

[Oct 31, 2007 10:19:12 AM EDT]:1193840352057:Thread[Thread-1045,10,main]:-1:-1:justanexample.com:192.168.4.1
:8000:16680:UNEXPECTED:[fnd.framework.OAException]:Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java
.sql.SQLException: ORA-20001: Oracle error -6502: ORA-06502: PL/SQL: numeric or
value error: associative array shape is not consistent with session parameters
has been detected in fnd_global.put(PERMISSION_CODE,FND_PERMIT_0001).
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.FND_GLOBAL", line 240
ORA-06512: at "APPS.FND_GLOBAL", line 428
ORA-06512: at "APPS.FND_GLOBAL", line 447
ORA-06512: at "APPS.FND_GLOBAL", line 2376
ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 821
ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 1127
ORA-06512: at "APPS.FND_AOLJ_UTIL", line 421
ORA-06512: at line 1

I logged SR 6604364.992 for a possible solution. They suggested a few things but we solved it on our own. Here's the content of the TAR towards the end:

Vikram:

We have not faced the problem again after applying the DB patch 5890966 mentioned in the begining of the TAR. I have also run autoconfig after ensuring the value of s_sesstimeout / 60*1000 does not result in a decimal number. Soft close this SR for 15 days, just in case we get the error again.

- Vikram



19-NOV-07 15:16:00 GMT

(Update for record id(s): 110662639,110663600)

CAUSE DETERMINATION
===================
Upgrade to 10.2.0.3 results in
ORA-20001: Oracle error -6502: ORA-06502: PL/SQL: numeric or
value error: associative array shape is not consistent with session parameters

during peak load

CAUSE JUSTIFICATION
===================
The following justifies how the issue is related to this specific customer:

This is explained in the following bug:
Bug 5890966 - INTERMITTENT ORA-06502 DURING PEAK LOADING - is the cause of this issue on RDBMS 10.2.0.3

Note 455882.1 Expenses Workflow Error: "ORA-06502: PL/SQL: numeric or
value error: associative array shape is not consistent with
session parameters has been detected in fnd_global.
put(CONC_LOGIN_ID,-1)"

Note 436084.1 ORA-6502 Associative Array Shape Is Not Consistent After
Applying Oracle Database Patch

ISSUE CLARIFICATION
===================
-- Problem Statement:
On 11.5.10.2 in Production:
When attempting to login to Apps 11i after upgrade to RUP5 at peak load,
the following error occurs:

ERROR
-----------------------
Internal Server error 500

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps at peak load:
1. Login to Apps 11i after upgrade to RUP5

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot login at peak load

19-NOV-07 15:19:04 GMT

(Update for record id(s): 110663613,110663621)

PROPOSED SOLUTION(S)
====================
Apply Patch 5890966 - INTERMITTENT ORA-06502 DURING PEAK LOADING

PROPOSED SOLUTION JUSTIFICATION(S)
==================================
Note 455882.1 Expenses Workflow Error: "ORA-06502: PL/SQL: numeric or
value error: associative array shape is not consistent with
session parameters has been detected in fnd_global.
put(CONC_LOGIN_ID,-1)"

Note 436084.1 ORA-6502 Associative Array Shape Is Not Consistent After
Applying Oracle Database Patch

SOLUTION / ACTION PLAN
======================
-- To implement the solution, please execute the following steps::
Apply Patch 5890966 - INTERMITTENT ORA-06502 DURING PEAK LOADING on top of RDBMS 10.2.0.3



19-NOV-07 15:41:03 GMT

(Update for record id(s): 110665240)

KNOWLEDGE CONTENT
=================
Created a new note: Note 467688.1 Associative Array Shape Is Not Consistent With Session Parameter at Peak Load

1 comment:

Anonymous said...

Hi Vik

Can you tell me the significance of ...
after ensuring the value of s_sesstimeout / 60*1000 does not result in a decimal number.

Regards, Martin