JASDEBUG not generating sql statements

[CNC Guy]

Hi all,

We are on E1 8.10 Websphere 5.0 on UNIX. We've turned on DEBUG on our JAS server but it is not writing the detailed activities in the jasdebug.log and there are no SQL level activities being written. Can somebody suggest the reason for the same. I am attaching the jas.ini, jdelog.properties and the jasdebug.log.

Please help

Tks in advance,
CNC Guy
E1 8.10 Websphere 5.0 on UNIX


.........................................

================jasdebug.log=========================================

28 Feb 2007 04:52:02,837 [Servlet.Engine.Transports : 2] ERROR: {com.jdedwards.system.none} - SecurityServer already exists, no override allowed

============================================================================


------------------jdelog.properties------------------

# This is a sample configuration file for root configuration

jdelog.rootLogger=ERROR,JDELOG,JASLOG
jdelog.loggerFactory=com.jdedwards.base.logging.log4j.JdeLoggerFactory
jdelog.reloadInterval=60

# These are the settings for file handlers.
jdelog.handler.JDELOG=com.jdedwards.base.logging.log4j.FileHandler
jdelog.handler.JDELOG.File=/opt/psft/WebSphere/AppServer/installedApps/myserver1/EA_JS_81_my

server1.ear/webclient.war/logs/jderoot.log
jdelog.handler.JDELOG.Level=ERROR
jdelog.handler.JDELOG.Append=FALSE
jdelog.handler.JDELOG.MaxBackupIndex=1
jdelog.handler.JDELOG.MaxFileSize=10MB
jdelog.handler.JDELOG.format=com.jdedwards.base.logging.log4j.DefaultFormat

# These are the settings for file handlers.
jdelog.handler.JASLOG=com.jdedwards.base.logging.log4j.FileHandler
jdelog.handler.JASLOG.File=/opt/psft/WebSphere/AppServer/installedApps/myserver1/EA_JS_81_my

server1.ear/webclient.war/logs/jas.log
jdelog.handler.JASLOG.Level=ERROR
jdelog.handler.JASLOG.Append=TRUE
jdelog.handler.JASLOG.MaxBackupIndex=1
jdelog.handler.JASLOG.MaxFileSize=10MB
jdelog.handler.JASLOG.format=com.jdedwards.base.logging.log4j.DefaultFormat

#This is added for debug logging. Please uncomment following to start debug.
jdelog.Debug=DEBUG, jasdebug
jdelog.handler.jasdebug=com.jdedwards.base.logging.log4j.FileHandler
jdelog.handler.jasdebug.File=/opt/psft/WebSphere/AppServer/installedApps/myserver1/EA_JS_81_

myserver1.ear/webclient.war/logs/jasdebug.log
jdelog.handler.jasdebug.Level=DEBUG


-----------------------------------------------------------------


**********************JAS.INI****************************

# Please refer to the JAS Installation Guide for detailed information on
# this file.
#
#


[SECURITY]
DataSource=SY810
SecurityServer=myserver
UseLogonCookie=FALSE
CookieLifeTime=7
SSOEnabled=FALSE
SSOUserIDOnly=FALSE
# set password only if SSOUserIDOnly is set to TRUE
Password=

[OWWEB]
PathCodes=('DV810')
MO QUEUE=/opt/psft/WebSphere/AppServer/installedApps/myserver1/EA_JS_81_myserver1.ear/webclient.war/moqueue
MAXUser=200
UseMOWinNTShare=FALSE
SystemDateFormat=MDE
SystemDateSeparator=/

# The HelpPath key determines where JAS looks for help files.
# Syntax: "http://[machine]/[path]/".
# Note, if you specify "/jde/owhelp/", this machine is assumed.
HelpPath=/jde/owhelp/

[CACHE]
# These intervals are in milliseconds. For example, 60000ms = 1 minute
UserSession=2400000
ResultSet=60000
#CacheCheck=60000
CacheCheck=300000




[SERVER COMPONENTS]
#
# Do not modify this section
#
com.jdedwards.jas.UserManager
com.jdedwards.jas.JDBCProxy
com.jdedwards.jas.JDEORB
com.jdedwards.jas.DDValidation
com.jdedwards.jas.security.SecurityBroker
com.jdedwards.jas.UDCJDBC
com.jdedwards.jas.JDEUDCText
com.jdedwards.jas.JDEUpdates
com.jdedwards.jas.JDEQueries
com.jdedwards.jas.JDEOWDirect
com.jdedwards.jas.ServerQuery
com.jdedwards.jas.JDESignon
com.jdedwards.runtime.virtual.MAFComponentLoader

[JDENET]
# Enterprise Server JDENET port
serviceNameConnect=6012

# JAS Server JDENET Listening port
serviceNameListen=6012

# Maximum number of dedicated kernel types
maxKernelRanges=1


# Time out value for requests sent to the Enterprise Server
enterpriseServerTimeout=90000

# Directory for JDENET temporary file
tempFileDir=/opt/psft/tmp

# Clustered logical datasource retry interval
ClusterRetryInterval=60000


# Dedicated Kernel Definitions
[JDENET_KERNEL_DEF1]
krnlName=XAPI Kernel
processClassName=com.jdedwards.runtime.virtual.xapi.PublishedMessageProcessor
startMessageRange=15001
endMessageRange=15250
maxNumberOfThread=3


[SERVER]
# Enterprise Server and port providing Glossary Text information
glossaryTextServer=myserver:6012

# Encoding scheme
# 1252- English and Western European
# 932- Japanese
# 950- Traditional Chinese
# 936- Simplified Chinese
# 949- Korean
codePage=1252

[LOGS]
#rtdebugTrace=FALSE
rtdebugTrace=TRUE
rtlog=/opt/psft/WebSphere/AppServer/installedApps/myserver1/EA_JS_81_myserver1.ear/webclient.war/logs/rt.log
rtdebug=/opt/psft/WebSphere/AppServer/installedApps/myserver1/EA_JS_81_myserver1.ear/webclient.war/logs/rtdebug.log
rtlogType=All
#or =BSFN|TableIO|SYSFUNC|MISC|ER|EVENT|THREAD (any combination).


# The STDERR and STDOUT keys must point to the same directory that was supplied for the
# STDERR and STDOUT fields when defining the WebSphere Application Server.
# This is usually the directory under B7333.
#
stderr=/opt/psft/WebSphere/AppServer/installedApps/myserver1/EA_JS_81_myserver1.ear/webclient.war/logs/stderr.txt
stdout=/opt/psft/WebSphere/AppServer/installedApps/myserver1/EA_JS_81_myserver1.ear/webclient.war/logs/stdout.txt

[JAS INSTANCE]
# This is for JAS redirector only
# RoundRobin will be used as default if ther is no entry in [JAS WEIGHT].
# If redirect based on JAS instance weight, then each instance's weight must specified,
# otherwise, weight 0 will be assumed, which means the server will not get
# any redirected request
# example: JAS1=http://127.0.0.1/jde
# Note: in this example, "JAS1" is the key, if weight will be given,
# this key must be used in [JAS WEIGHT] section to match this JAS instance

[JAS WEIGHT]
# The key must match the key in [JAS INSTANCE] section
# example: JAS1=2
# The weight is ratio based, for example:
# JAS1=2
# JAS2=1
# That means JAS1 will take as twice load as JAS2


[REDIRECTOR]
# interval unit is milliseconds
Interval=5000
# This is the location that Redirector will redirect to, if no server is available.
# If it is empty, redirect will display a simple page tells user that no server is available
# example: NoServerAvailableURL=http://servername/path/noserver.html
NoServerAvailableURL=

[TRANSACTIONS]
# Configuration settings to customize transaction processing within JAS.

# ReapInterval : Interval in minutes of how often the TransactionReaper
# should check for abandoned transactions.
# Valid values: Integer from 1 to n
# Default: 5 minutes
# MaxAge : Maximum age in minutes of a transaction. Transactions
# older than this will be rolled back by the
# TransactionReaper.
# Valid values: Integer from 1 to n
# Default: 10 minutes
#

ReapInterval=5
MaxAge=10

[ERPINTERACTIVITY]
#interactivity level. valid values are: LOW, MEDIUM, and HIGH
InteractivityLevel=HIGH
# whether multiple browsers fetch is enabled
MultipleBrowserEnabled=TRUE
# the maximum number of open browsers for each user
MaxOpenBrowsers=5
# the number of records fetched for each database fetch before getting a system warning
DBFetchLimitBeforeWarning=2000


***********************************************************

 

[euane]

Have you restarted your services?. This might very well be th issue.

 

[CNC Guy]

Hi,

Thanks . Is there a way to increase level in the JASDEBUG log?

Thanks,
CNC Guy
E1 8.10
UNIX, DB2

 

[champion_peng]

Hi, CNC_GUY, I can give the bad news for this issue.
I had consult Oracle Customer Connection, They said that this maybe is a bug for web debug log. And he had raise a SAR for this issue.
If you want to see debug log ,you only have to use Fat CLient. If you want to debug power form, that is not possible to debug it. BTW, the web dev is likly to have the same issue .