JDBCProxy.jdbcProxy()>>>response is good(execute()) -> , status = 3,

aniln

Member
I see below message in jas.log. Can anyone please help me fix the issue?
After displaying the entry screen (On web) the form is in 'Processing" mode continuously.
SELECT CCCALD,CCARFJ,CCCO,CCBKTX,CCUPMJ,CCUPMT,CCPNC,CCPID,CCDFF,CCAPPN,CCDTPN,CCUSER,CCDOT2,CCNAME,CCARPN,CCDFYJ,CCAPFJ,CCJOBN,CCPNF,CCABIN,CCCRCD FROM JDEData910.F0010 ORDER BY CCCO ASC
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] SELECT SCUGRP,SCENHV,SCWSTPNAME,SCWSTPVAL FROM JDESY910.F954001 WHERE ((SCUGRP = ? AND SCENHV = ? AND SCWSTPNAME = ? ))
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] SQL statement parameter marker values are :
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] Param1 : DEMO _Types.VARCHAR,
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] Param2 : DEMO910 _Types.VARCHAR,
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] Param3 : ONEVIEW_BIP_CONN _Types.VARCHAR,
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] SELECT LMLL,LMRLS,LMPATHCD,LMENHV01 FROM JDESY910.F00941 WHERE (LMLL = ? )
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] SQL statement parameter marker values are :
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] Param1 : DEMO910 _Types.VARCHAR,
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] SELECT T1.RLFRROLE,T1.RLFUROLE1,T2.AUROLEDESC,T1.RLEXPIRDATE,T2.AUSEQNO,T2.AULNGP,T2.AUUSER FROM JDESY910.F0093 T0, JDESY910.F95921 T1, JDESY910.F00926 T2 WHERE ((T1.RLTOROLE = ? AND EXISTS( SELECT T0.LLLL FROM JDESY910.F0093 T0, JDESY910.F00941 T1 WHERE ((T1.LMENHV01 = ? AND T1.LMPATHCD IN ( ? ) AND T0.LLUSER = RLFRROLE)) AND (T0.LLLL = T1.LMLL) ) AND T0.LLLL = ? AND (T2.AULNGP = ? OR T2.AULNGP = ? ) AND T1.RLEFFDATE <= ? AND (T1.RLEXPIRDATE = ? OR T1.RLEXPIRDATE > ? ) AND T1.RLFUROLE1 = ? )) AND (T0.LLUSER = T1.RLFRROLE AND T1.RLFRROLE = T2.AUUSER) ORDER BY T2.AUSEQNO DESC
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] SQL statement parameter marker values are :
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] Param1 : DEMO _Types.VARCHAR,
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] Param2 : 1 _Types.VARCHAR,
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] Param3 : DEMO _Types.VARCHAR,
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] Param4 : DEMO910 _Types.VARCHAR,
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] Param5 : _Types.VARCHAR,
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] Param6 : _Types.VARCHAR,
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] Param7 : 115216_Types.INTEGER,
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] Param8 : 0_Types.INTEGER,
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] Param9 : 115216_Types.INTEGER,
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] Param10 : 1_Types.VARCHAR,
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] SELECT SCUGRP,SCENHV,SCWSTPNAME,SCWSTPVAL FROM JDESY910.F954001 WHERE ((SCUGRP = ? AND SCENHV = ? AND SCWSTPNAME = ? ))
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] SQL statement parameter marker values are :
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] Param1 : DEMOROLE _Types.VARCHAR,
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] Param2 : DEMO910 _Types.VARCHAR,
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] Param3 : ONEVIEW_BIP_CONN _Types.VARCHAR,
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] SELECT SCUGRP,SCENHV,SCWSTPNAME,SCWSTPVAL FROM JDESY910.F954001 WHERE ((SCUGRP = ? AND SCENHV = ? AND SCWSTPNAME = ? ))
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] SQL statement parameter marker values are :
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] Param1 : *PUBLIC _Types.VARCHAR,
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] Param2 : DEMO910 _Types.VARCHAR,
04 Aug 2015 14:23:19,592 [APP ] - [JDBJ] Param3 : ONEVIEW_BIP_CONN _Types.VARCHAR,
04 Aug 2015 14:23:19,592 [APP ] - [RUNTIME] EUR:EURConfigManager:resolveConnnectionInfo:invalid connection
04 Aug 2015 14:23:19,608 [APP ] - [RUNTIME] EUR:EURContext:isEnabledAppRelease:true
04 Aug 2015 14:23:19,608 [APP ] - [RUNTIME] EUR:EURContext:isEnabledEnviroment:false
04 Aug 2015 14:23:19,623 [APP ] - [RUNTIME] WL:WatchlistManager:getManager:Obtaining the WatchlistManager singleton
04 Aug 2015 14:23:22,413 [APP ] - [RUNTIME] WL:WatchlistManager:getManager:Obtaining the WatchlistManager singleton
04 Aug 2015 14:23:22,413 [APP ] - [RUNTIME] WL:WLMetaDataManager:loadWatchlistForUserByDropdown: :DEMO
04 Aug 2015 14:23:22,413 [APP ] - [JAS] JDBCProxy.jdbcProxy(): Operation is executed under an auto commit JDBj logical connection for Usersession ID: 6354536857713501184 | UserName : DEMO, Environment : DEMO910, User Role : *ALL
04 Aug 2015 14:23:22,413 [APP ] - [JDBJ] SELECT WLOID,WLWOOBNMS,WLWOOBNML,WLWLDDITM,WLOMRBLOB,WLAQOID,WLOBNM,WLFMNM,WLVER,WLTASKNM,WLWOUSER,WLCHOT,WLWOLNTYP FROM JDEVL910.F952420 WHERE ((WLWOSUBCAT = ? AND WLWOUSER = ? AND WLWLDDITM = ? )) ORDER BY WLWOLNTYP ASC , WLWOOBNMS ASC
04 Aug 2015 14:23:22,413 [APP ] - [JDBJ] SQL statement parameter marker values are :
04 Aug 2015 14:23:22,413 [APP ] - [JDBJ] Param1 : WATCHLIST _Types.VARCHAR,
04 Aug 2015 14:23:22,413 [APP ] - [JDBJ] Param2 : DEMO _Types.VARCHAR,
04 Aug 2015 14:23:22,413 [APP ] - [JDBJ] Param3 : 1_Types.VARCHAR,
04 Aug 2015 14:23:22,413 [APP ] - [JAS] JDBCProxy.jdbcProxy()>>>response is good(execute()) -> , status = 3, nextpageid = -1, data = JASResultSet is returning 0 rows
04 Aug 2015 14:23:22,413 [APP ] - [RUNTIME] WL:WLMetaDataManager:loadWatchlistForUserByDropdown: :0
04 Aug 2015 14:23:37,436 [APP ] - [RUNTIME] WL:WatchlistManager:getManager:Obtaining the WatchlistManager singleton
04 Aug 2015 14:23:37,436 [APP ] - [RUNTIME] WL:WLMetaDataManager:loadWatchlistForUserByDropdown: :DEMO
04 Aug 2015 14:23:37,436 [APP ] - [JAS] JDBCProxy.jdbcProxy(): Operation is executed under an auto commit JDBj logical connection for Usersession ID: 6354536857713501184 | UserName : DEMO, Environment : DEMO910, User Role : *ALL
04 Aug 2015 14:23:37,436 [APP ] - [JDBJ] SELECT WLOID,WLWOOBNMS,WLWOOBNML,WLWLDDITM,WLOMRBLOB,WLAQOID,WLOBNM,WLFMNM,WLVER,WLTASKNM,WLWOUSER,WLCHOT,WLWOLNTYP FROM JDEVL910.F952420 WHERE ((WLWOSUBCAT = ? AND WLWOUSER = ? AND WLWLDDITM = ? )) ORDER BY WLWOLNTYP ASC , WLWOOBNMS ASC
04 Aug 2015 14:23:37,436 [APP ] - [JDBJ] SQL statement parameter marker values are :
04 Aug 2015 14:23:37,436 [APP ] - [JDBJ] Param1 : WATCHLIST _Types.VARCHAR,
04 Aug 2015 14:23:37,451 [APP ] - [JDBJ] Param2 : DEMO _Types.VARCHAR,
04 Aug 2015 14:23:37,451 [APP ] - [JDBJ] Param3 : 1_Types.VARCHAR,
04 Aug 2015 14:23:37,451 [APP ] - [JAS] JDBCProxy.jdbcProxy()>>>response is good(execute()) -> , status = 3, nextpageid = -1, data = JASResultSet is returning 0 rows
04 Aug 2015 14:23:37,451 [APP ] - [RUNTIME] WL:WLMetaDataManager:loadWatchlistForUserByDropdown: :0
04 Aug 2015 14:23:52,521 [APP ] - [RUNTIME] WL:WatchlistManager:getManager:Obtaining the WatchlistManager singleton
04 Aug 2015 14:23:52,521 [APP ] - [RUNTIME] WL:WLMetaDataManager:loadWatchlistForUserByDropdown: :DEMO
04 Aug 2015 14:23:52,521 [APP ] - [JAS] JDBCProxy.jdbcProxy(): Operation is executed under an auto commit JDBj logical connection for Usersession ID: 6354536857713501184 | UserName : DEMO, Environment : DEMO910, User Role : *ALL
04 Aug 2015 14:24:07,536 [APP ] - [JDBJ] SELECT WLOID,WLWOOBNMS,WLWOOBNML,WLWLDDITM,WLOMRBLOB,WLAQOID,WLOBNM,WLFMNM,WLVER,WLTASKNM,WLWOUSER,WLCHOT,WLWOLNTYP FROM JDEVL910.F952420 WHERE ((WLWOSUBCAT = ? AND WLWOUSER = ? AND WLWLDDITM = ? )) ORDER BY WLWOLNTYP ASC , WLWOOBNMS ASC
04 Aug 2015 14:24:07,536 [APP ] - [JDBJ] SQL statement parameter marker values are :
04 Aug 2015 14:24:07,536 [APP ] - [JDBJ] Param1 : WATCHLIST _Types.VARCHAR,
04 Aug 2015 14:24:07,536 [APP ] - [JDBJ] Param2 : DEMO _Types.VARCHAR,
04 Aug 2015 14:24:07,536 [APP ] - [JDBJ] Param3 : 1_Types.VARCHAR,
04 Aug 2015 14:24:07,552 [APP ] - [JAS] JDBCProxy.jdbcProxy()>>>response is good(execute()) -> , status = 3, nextpageid = -1, data = JASResultSet is returning 0 rows
04 Aug 2015 14:24:07,552 [APP ] - [RUNTIME] WL:WLMetaDataManager:loadWatchlistForUserByDropdown: :0
 
Back
Top