Problem with JAS

felipecorrea

Active Member
hi there,
I have problem with consulting the grid in the jas, i have Micrsoft JDBC for sql2000 server.
also my performance is pretty damage this is the log
please help me

2004-07-27 16:36:41.406 [Pooled ORB request dispatch WorkerThread] LIB : ***** File [E:\JDEdwardsOneWorld\webclient\web\logs\jas.log] opened
2004-07-27 16:36:41.406 [Pooled ORB request dispatch WorkerThread] LIB : SysInfo: Windows 2000 5.0 x86 JavaInfo: IBM Corporation 1.2.2 (J2RE 1.2.2 IBM build cn122-20011129was (JIT enabled: jitc))
2004-07-27 16:36:41.406 [Pooled ORB request dispatch WorkerThread] JAS : OneWorld JAS startup initiated
2004-07-27 16:36:41.421 [Pooled ORB request dispatch WorkerThread] JAS : JDBC Driver is registered. Major Version <2> Minor Version <2>
2004-07-27 16:36:41.703 [Pooled ORB request dispatch WorkerThread] JAS : OneWorld JAS startup complete
2004-07-28 07:56:10.125 [Worker#9] JAS : Security Server return error status: 1/Unknown User
2004-07-28 07:56:24.781 [Worker#12] JAS : Security Server return error status: 2/Invalid Password
2004-07-28 07:56:33.125 [Worker#11] JDBC : Transaction Pricing deactivated !
2004-07-28 07:56:54.953 [Thread-9] NET : JdeNetMessageDispatcher: msgType 359invalid, JDENET message will be discarded
2004-07-28 07:59:57.656 [Thread-9] NET : JdeNetMessageDispatcher: msgType 359invalid, JDENET message will be discarded
2004-07-28 08:00:58.671 [Thread-9] NET : JdeNetMessageDispatcher: msgType 359invalid, JDENET message will be discarded
2004-07-28 08:01:28.156 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@98abf92c] KERNEL : *ERROR* CallObject@135279f4: COSE#1000 Request timeout: timeout after 90000ms host P03XELOGIC:6009(1141) SocID:2082 PID:2988 BSFN:F4201_CURRENCY user:pRDVIRTUAL Env:JPD7333
2004-07-28 08:01:28.796 [Thread-9] NET : JdeNetMessageDispatcher: msgType 359invalid, JDENET message will be discarded
2004-07-28 08:02:29.609 [Thread-9] NET : JdeNetMessageDispatcher: msgType 359invalid, JDENET message will be discarded
2004-07-28 08:03:30.640 [Thread-9] NET : JdeNetMessageDispatcher: msgType 359invalid, JDENET message will be discarded
2004-07-28 08:04:00.125 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@98abf92c] KERNEL : *ERROR* CallObject@135279f4: COSE#1000 Request timeout: timeout after 90000ms host P03XELOGIC:6009(1141) SocID:2082 PID:2776 BSFN:F4201_CURRENCY user:pRDVIRTUAL Env:JPD7333
2004-07-28 08:04:00.125 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@98abf92c] KERNEL : *ERROR* CallObject@135279f4: The business function being executed is causing a problem user:pRDVIRTUAL Env:JPD7333
2004-07-28 08:04:00.125 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@98abf92c] JAS : Trigger: has errors2:The business function being executed is causing a problem
2004-07-28 08:04:00.156 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@98abf92c] JAS : trying getJASResultSet
2004-07-28 08:04:00.171 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@98abf92c] JAS : trying jdbcProxy while !(dbRequest.isViewNextPage()|isTableFetchNext()|dbRequest.isViewFetchNext())
java.util.MissingResourceException: Can't find resource for base name OWResource, locale en_US
at java.util.ResourceBundle.getBundle(ResourceBundle.java:434)
at java.util.ResourceBundle.getBundle(ResourceBundle.java:350)
at com.jdedwards.jas.JASException.toString(Unknown Source)
at java.lang.String.valueOf(String.java(Compiled Code))
at java.io.PrintWriter.print(PrintWriter.java:380)
at java.io.PrintWriter.println(PrintWriter.java:499)
at java.lang.Throwable.printStackTrace(Throwable.java:210)
at com.jdedwards.system.lib.LogFile.println(Unknown Source)
at com.jdedwards.system.lib.LogFile.writeLog(Unknown Source)
at com.jdedwards.system.lib.Logger.writeLog(Unknown Source)
at com.jdedwards.system.lib.Logger.log(Unknown Source)
at com.jdedwards.jas.JDBCProxy.getJASResultSet(Unknown Source)
at com.jdedwards.jas.JDBCProxy.jdbcProxy(Unknown Source)
at com.jdedwards.jas.JDEQueries.processServerRequest(Unknown Source)
at java.lang.reflect.Method.invoke(Native Method)
at com.jdedwards.jas.ServletProxy.callServerComponent(Unknown Source)
at com.jdedwards.jas.ServletProxy.ServletProxy(Unknown Source)
at com.jdedwards.jas.ServletProxy.dispatch(Unknown Source)
at com.jdedwards.jas.net.NetConnection.callJAS(Unknown Source)
at com.jdedwards.jas.net.NetManager.processRequest(Unknown Source)
at com.jdedwards.jas.net.NetManager.callJAS(Unknown Source)
at com.jdedwards.jas.net.NetManager.callJAS(Unknown Source)
at com.jdedwards.jas.net.NetManager.fetch(Unknown Source)
at com.jdedwards.jas.net.NetManager.fetch(Unknown Source)
at com.jdedwards.runtime.model.BusinessView.fetchDetailData(Unknown Source)
at com.jdedwards.runtime.engine.form.FindBrowseEngine.fetchDetailData(Unknown Source)
at com.jdedwards.runtime.engine.form.FindBrowseEngine.processFind(Unknown Source)
at com.jdedwards.runtime.vtcomponent.form.VTForm.processFind(Unknown Source)
at com.jdedwards.runtime.engine.ButtonEngine.onClick(Unknown Source)
at com.jdedwards.runtime.vtcomponent.VTHyperMenuExit.sysPressButton(Unknown Source)
at com.jdedwards.runtime.vtcomponent.VTHyperMenuExit.onClick(Unknown Source)
at com.jdedwards.runtime.vtcomponent.VTHyperMenuExit.processVirtualEvent(Unknown Source)
at com.jdedwards.runtime.virtual.OWVirtual.processVTEvent(Unknown Source)
at com.jdedwards.runtime.virtual.OWVirtual.processEventLoop(Unknown Source)
at com.jdedwards.runtime.virtual.OWVirtual.run(Unknown Source)
at com.jdedwards.base.util.ThreadPool$WorkerThread.run(Unknown Source)
2004-07-28 08:17:14.734 [Thread-9] NET : JdeNetMessageDispatcher: msgType 359invalid, JDENET message will be discarded
2004-07-28 08:18:15.656 [Thread-9] NET : JdeNetMessageDispatcher: msgType 359invalid, JDENET message will be discarded
2004-07-28 08:19:58.312 [Thread-9] NET : JdeNetMessageDispatcher: msgType 359invalid, JDENET message will be discarded
2004-07-28 08:20:58.671 [Thread-9] NET : JdeNetMessageDispatcher: msgType 359invalid, JDENET message will be discarded
2004-07-28 08:21:28.812 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@dce2f991] KERNEL : *ERROR* CallObject@3a2d7996: COSE#1000 Request timeout: timeout after 90000ms host P03XELOGIC:6009(1141) SocID:2082 PID:2968 BSFN:F4211_CURRENCY user:pRDVIRTUAL Env:JPD7333
2004-07-28 08:21:29.390 [Thread-9] NET : JdeNetMessageDispatcher: msgType 359invalid, JDENET message will be discarded
2004-07-28 08:22:29.703 [Thread-9] NET : JdeNetMessageDispatcher: msgType 359invalid, JDENET message will be discarded
2004-07-28 08:23:30.609 [Thread-9] NET : JdeNetMessageDispatcher: msgType 359invalid, JDENET message will be discarded
2004-07-28 08:24:00.187 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@dce2f991] KERNEL : *ERROR* CallObject@3a2d7996: COSE#1000 Request timeout: timeout after 90000ms host P03XELOGIC:6009(1141) SocID:2082 PID:1716 BSFN:F4211_CURRENCY user:pRDVIRTUAL Env:JPD7333
2004-07-28 08:24:00.187 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@dce2f991] KERNEL : *ERROR* CallObject@3a2d7996: The business function being executed is causing a problem user:pRDVIRTUAL Env:JPD7333
2004-07-28 08:24:00.187 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@dce2f991] JAS : Trigger: has errors2:The business function being executed is causing a problem
2004-07-28 08:24:00.187 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@dce2f991] JAS : trying getJASResultSet
2004-07-28 08:24:00.187 [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@dce2f991] JAS : trying jdbcProxy while !(dbRequest.isViewNextPage()|isTableFetchNext()|dbRequest.isViewFetchNext())
java.util.MissingResourceException: Can't find resource for base name OWResource, locale en_US
at java.util.ResourceBundle.getBundle(ResourceBundle.java:434)
at java.util.ResourceBundle.getBundle(ResourceBundle.java:350)
at com.jdedwards.jas.JASException.toString(Unknown Source)
at java.lang.String.valueOf(String.java(Compiled Code))
at java.io.PrintWriter.print(PrintWriter.java:380)
at java.io.PrintWriter.println(PrintWriter.java:499)
at java.lang.Throwable.printStackTrace(Throwable.java:210)
at com.jdedwards.system.lib.LogFile.println(Unknown Source)
at com.jdedwards.system.lib.LogFile.writeLog(Unknown Source)
at com.jdedwards.system.lib.Logger.writeLog(Unknown Source)
at com.jdedwards.system.lib.Logger.log(Unknown Source)
at com.jdedwards.jas.JDBCProxy.getJASResultSet(Unknown Source)
at com.jdedwards.jas.JDBCProxy.jdbcProxy(Unknown Source)
at com.jdedwards.jas.JDEQueries.processServerRequest(Unknown Source)
at java.lang.reflect.Method.invoke(Native Method)
at com.jdedwards.jas.ServletProxy.callServerComponent(Unknown Source)
at com.jdedwards.jas.ServletProxy.ServletProxy(Unknown Source)
at com.jdedwards.jas.ServletProxy.dispatch(Unknown Source)
at com.jdedwards.jas.net.NetConnection.callJAS(Unknown Source)
at com.jdedwards.jas.net.NetManager.processRequest(Unknown Source)
at com.jdedwards.jas.net.NetManager.callJAS(Unknown Source)
at com.jdedwards.jas.net.NetManager.callJAS(Unknown Source)
at com.jdedwards.jas.net.NetManager.fetch(Unknown Source)
at com.jdedwards.jas.net.NetManager.fetch(Unknown Source)
at com.jdedwards.runtime.model.BusinessView.fetchDetailData(Unknown Source)
at com.jdedwards.runtime.engine.form.FindBrowseEngine.fetchDetailData(Unknown Source)
at com.jdedwards.runtime.engine.form.FindBrowseEngine.processFind(Unknown Source)
at com.jdedwards.runtime.vtcomponent.form.VTForm.processFind(Unknown Source)
at com.jdedwards.runtime.engine.ButtonEngine.onClick(Unknown Source)
at com.jdedwards.runtime.vtcomponent.VTHyperMenuExit.sysPressButton(Unknown Source)
at com.jdedwards.runtime.vtcomponent.VTHyperMenuExit.onClick(Unknown Source)
at com.jdedwards.runtime.vtcomponent.VTHyperMenuExit.processVirtualEvent(Unknown Source)
at com.jdedwards.runtime.virtual.OWVirtual.processVTEvent(Unknown Source)
at com.jdedwards.runtime.virtual.OWVirtual.processEventLoop(Unknown Source)
at com.jdedwards.runtime.virtual.OWVirtual.run(Unknown Source)
at com.jdedwards.base.util.ThreadPool$WorkerThread.run(Unknown Source)
 
It looks like your JAS server can not communicate with your enterprise server or one of the kernels on your enterprise server. Check that your JAS server can PING your enterprise server. Then check to see that you are not having any kernel issues on the server. Also, please post your JAS.INI and JDE.INI from the enterprise server. Please remember to remove any passwords from the files.

Was this working ever before?

Dan
 
thanks for the reply.
My JAS can comunicate wiht the enterprise but when im doing a find on the web, the server can't resolve the find.
i think maybe there's a problem wiht the kernel.

there's my jde.ini an jas.ini
 

Attachments

  • 76318-jas.ini
    3.4 KB · Views: 194
sorry my jde.ini (enterprise)
 

Attachments

  • 76319-Jde.ini
    7.5 KB · Views: 168
Hello Felipe,

The it appears there are two errors reported in the jasdebug you attached. the first is


NET : JdeNetMessageDispatcher: msgType 359invalid, JDENET message will be discarded


It appears that JDENET is receiving some spurious messages that it cannot process and therefore ignores. It could be a message from the call object kernel responding to the busienss function call, but it is hard to tell.

Also note that F4201_CURRENCY is a Trigger Business Function, so I'm not sure if it should require a call object kernel to run it. Peoplesoft has reported an issue with this business function in SAR 6626151.


Sorry I can't be of more help.

Regards.

Jim.
 
Felipe,
The problem is that the BSFN (F4201_CURRENCY) is not finishing the transaction, so you get a timeout error, this will hang the transaction. Can you turn on you logs in SAW for the user that is performing the process, you can see the PID of the kerner and turn it on (JDEDebugLog), the user make the transaction and then turn off the log again. please send this logs. Maybe you can also see de jde.log of the kernel, you can have an error in you trigger library.
Some questions:
1. The problem starts after a full package or update package?
2. Do you make any changes to the F4201 trigger?
3. Is any other aplication that insert/update data in F4201 have the same problem?
 
here´s the enterpise log, but the odbc exits¿

1640/2064 Tue Jul 27 09:48:27 2004 IPCPUB.C3121
process 1640 (jdenet_k) registered in entry 1

1640/2064 Tue Jul 27 09:48:28 2004 JDEKDISP.C963
INITIALIZING CALL OBJECT KERNEL

1640/2064 Tue Jul 27 15:15:42 2004 jdbodbc.C684
ODB0000045 - SQLDriverConnect failed. DSN: FinancieroPD - CLTA

1640/2064 Tue Jul 27 15:15:42 2004 jdbodbc.C685
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified - SQLSTATE: IM002

1640/2064 Tue Jul 27 15:16:43 2004 JDEKDISP.C2038
KNT0000008 - Timeout on client query for user-password

1640/2064 Tue Jul 27 15:16:43 2004 JDB_DRVM.C680
JDB9900164 - Failed to connect to FinancieroPD - CLTA

1640/2064 Tue Jul 27 15:16:43 2004 JTP_CM.C283
JDB9909003 - Could not init connect.

1640/2064 Tue Jul 27 15:16:43 2004 JTP_TM.C960
JDB9909100 - Get connect info failed: Transaction ID =

1640/2064 Tue Jul 27 15:16:43 2004 JDB_RQ1.C1797
JDB3100013 - Failed to get connectinfo

1640/2064 Tue Jul 27 15:16:43 2004 JDEKINIT.C311
CALLOBJ0000001 - Invalid hEnv, probably freed due to transaction timeout.

1640/2064 Thu Jul 29 11:49:20 2004 JDEKDISP.C939
KNT0000099 - JDEK_DispatchCallObjectMessage: Pooled Connection: 01640048 timed out!

1640/2064 Thu Jul 29 11:49:20 2004 jdeksec.c3212
KNT0000306 - JDENET Error = eAssociateKernelNotExist
 
This log is in the Enterprise Server, I imagine that there are different machines. The user that make the transactions has a user in the database, can you access it in the enterprise server, using this ODBC name?
Do you have the answers of the other questions?
Do you work in Brazil?
 
hi, thanks for the reply
Im solve this problem updating the odbc on the enterprise, but my performace is to slow....
i have this question, if somebody have microsoft jdbc drivers for sql200 server, what is the perfect sintax in the tnsnames.sql? just because this happend to me:
I have two nets, once's is for backup and the olther is for produccion this nets are the same in everething.
in the bacukps all of my querys works but in the production doesn't fine, when im change the tnsnames.sql the querys works but im having troubles wiht others(in production net), and in the logs everything is fine.....
and also i have timeout errors....
what should i do?
can you send me your configuration of the tnsnames.sql
 
Back
Top