CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Get a message JAS_MSG347 when inquiring P09200 (Account Ledger Inquiry)

edited Jan 22, 2014 7:43AM in CNC, DB and Operating System - JDE1 (MOSC) 6 commentsAnswered
Hi EveryOne,
I have a user that inquire mostly the P09200 for a specific account : xxxx.yy.zz and Ledger type 1 = AA, Ledger Type 2 = CA, From Date = 01/12/2013, Thru Date = 31/12/2013. When the user hit "find" button, the result take more than 2 or 3 minutes, and that results a jas error (JAS_MSG37). After investigating on the issue, I found note ID 1064582.1 explain that, a parameter should be changed in  JDBJ.ini ex. 
[JDBj-RUNTIME PROPERTIES]
resultSetTimeout=300000

In our system the default value "resultSetTimeout=60000"

What I discover after doing more tests, if I do the same inquiry by using my group "CNCADMIN" I get the result less than a minute, and no error message but If I do the with the same group as the user assigned to "

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center