ASB XE3/32/64 DLL running [Compiled on 05/06/2018 1:03:04 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][] DB Manager created gcmsmaansingh827ccb0eea8a706c4c34a16891f84e7brctcr0018144181380175177000685618144153099000678218138103360000037822019/0016718144-18138#2019/0016714/12/20220T Executing Savedata webservice ----------------------------- Received JSON : {"savedata":{"axpapp":"gcms","username":"maansingh","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"rctcr","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"court_code":"18144","trans_ccode":"18138"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"fromcourt":"1751770006856","fromccode":"18144","transcourt":"1530990006782","transccode":"18138","trn_rcms_caseregid":"10336000003782","case_no":"2019/00167","requestno":"18144-18138#2019/00167","decision_date":"14/12/2022","status":"0","transContFld":"T"}}]}]}} Verifying username and password User Name : maansingh Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app' U=maansingh Time elapsed = 15 Password checking along with max.no of login specified in app.xml update axusers set logintry = 0 where lower(username) = :U Time elapsed = 6 Result : Verifying completed... Page Access Category : User Name : maansingh Select sysdate as sdt from dual Time elapsed = 5 dt=23/01/2023 13:59:30 Select sysdate as sdt from dual Time elapsed = 4 Select usergroup from AXUSERLEVELGROUPS WHERE (lower(username) =:U) and ((startdate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') >= startdate) or (startdate is null)) and ((enddate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') <= enddate) or (enddate is null)) U=maansingh dt=23/01/2023 13:59:30 dt=23/01/2023 13:59:30 Time elapsed = 13 User Groups: rcsatadmin select userroles from axusergroups where groupname in ( 'rcsatadmin' ) Time elapsed = 5 User Roles : rcsat_admin Loading App/User vars reading the props xml Step3 Sql : select props from axprops where lower(name)= :name order by blobno Paramval : app ParamTYpe : c Param List : name select props from axprops where lower(name)= :name order by blobno Time elapsed = 4 Step4 axprops\stm size:4235 Step4-123456 images\Generalized Court Management SystemINRF500250000F00000F Step4-4 Step5 Step6 Step9 fetched the props xml 10010000-1000000 2 Evaluating firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1}) Calling function firesql username=maansingh select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1 username=maansingh Time elapsed = 9 Result of firesql = Result = Evaluating sqlget({m2},{court_name}) Calling function sqlget Result of sqlget = Rajasthan Civil Services Appellate Tribunal Court,Jodhpur Result = Rajasthan Civil Services Appellate Tribunal Court,Jodhpur Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1}) Calling function firesql username=maansingh select a.court_type from v_axcourts a where a.paxusername= :username order by 1 username=maansingh Time elapsed = 6 Result of firesql = Result = Evaluating sqlget({m3},{court_type}) Calling function sqlget Result of sqlget = Jodhpur Result = Jodhpur Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1}) Calling function firesql username=maansingh select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1 username=maansingh Time elapsed = 5 Result of firesql = Result = Evaluating sqlget({m4},{court_name_mastid}) Calling function sqlget Result of sqlget = 1751770006856 Result = 1751770006856 Evaluating firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username}) Calling function firesql select a1.axusersid from axusers a1 where a1.username=:username username=maansingh Time elapsed = 6 Result of firesql = Result = Evaluating sqlget({m4},{axusersid}) Calling function sqlget Result of sqlget = 1624010006193 Result = 1624010006193 Evaluating firesql({m4},{select :username as uname from dual}) Calling function firesql select :username as uname from dual username=maansingh Time elapsed = 6 Result of firesql = Result = Evaluating sqlget({m4},{uname}) Calling function sqlget Result of sqlget = maansingh Result = maansingh Evaluating firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1}) Calling function firesql select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1 username=maansingh Time elapsed = 5 Result of firesql = Result = Evaluating sqlget({m4},{COURT_CODE}) Calling function sqlget Result of sqlget = 18144 Result = 18144 Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'}) Calling function firesql select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ' Time elapsed = 6 Result of firesql = Result = Evaluating sqlget({m2},{STATE_NAME}) Calling function sqlget Result of sqlget = ???????? Result = ???????? Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1}) Calling function firesql username=maansingh SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=maansingh Time elapsed = 8 Result of firesql = Result = Evaluating sqlget({m7},{DISTNAMEENG}) Calling function sqlget Result of sqlget = Jodhpur Result = Jodhpur Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1}) Calling function firesql username=maansingh SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=maansingh Time elapsed = 6 Result of firesql = Result = Evaluating sqlget({m8},{COURT_CATEGOTY}) Calling function sqlget Result of sqlget = 1319880000000 Result = 1319880000000 Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid}) Calling function firesql login_userid=1624010006193 select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid login_userid=1624010006193 Time elapsed = 10 Result of firesql = Result = Evaluating sqlget({m4},{department_mastid}) Calling function sqlget Result of sqlget = 1714990007202 Result = 1714990007202 Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1}) Calling function firesql select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1 username=maansingh Time elapsed = 7 Result of firesql = Result = Evaluating sqlget({m3},{court_type_mastid}) Calling function sqlget Result of sqlget = 1751220006551 Result = 1751220006551 Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username }) Calling function firesql username=maansingh select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username username=maansingh Time elapsed = 10 Result of firesql = Result = Evaluating sqlget({m4},{groupname}) Calling function sqlget Result of sqlget = rcsatadmin Result = rcsatadmin Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual}) Calling function firesql select to_date('30/01/2021','DD/MM/RRRR') dd from dual Time elapsed = 6 Result of firesql = Result = Evaluating sqlget({a1},{dd}) Calling function sqlget Result of sqlget = 30/01/2021 Result = 30/01/2021 Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0}) Calling function firesql username=maansingh SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0 username=maansingh Time elapsed = 11 Result of firesql = Result = Evaluating sqlget({P1},{ct}) Calling function sqlget Result of sqlget = 0 Result = 0 3 completed LoadAppVars Password validation done successfully select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('rcsat_admin') and lower(sname)='rctcr' and stype = 't' ) Time elapsed = 22 Error : Savedata webservice completed Freeing DbCall Resources Freeing Action Obj Resources Closing connection # 1#Saving to log Param Type = c username=maansingh Param Type = c calledon=23/01/2023 13:59:16 Param Type = c callfinished=23/01/2023 13:59:17 Param Type = n recordid=0 Param Type = c servicename=Saving data Param Type = c serviceresult=User does not have access to this structure... Param Type = n timetaken=525 Param Type = n dbtimetaken=243 insert into axmwslog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken) values (null,:username,to_date(:calledon,'dd/mm/yyyy hh24:mi:ss'),to_date(:callfinished,'dd/mm/yyyy hh24:mi:ss'),null,:recordid,:servicename,:serviceresult,:timetaken,:dbtimetaken) Freeing AxProvider Resources Freeing DbManager Resources