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 gcmsSDO_Bhinder_PRO827ccb0eea8a706c4c34a16891f84e7btrccr194460000104341944600001043412615500071721814103/11/20252025/341F0???????21000633132430000016541101388???????17999000000000100049223/12/20251000082188,53No116/251944600001043618308000000000????????????????????? N/A18707000000000??????-??????? ????? ?????? ???? ??????10206000000000100063313243000001654YESNO1944600001043718308000000000?????? ???? ????????? ??? N/A18707000000000??????-??????? ????? ?????? ???? ??????10206000000000100063313243000001654YESNO194460000104351935330004604999999999918311000000000NO19446000010434?????????????? ???? 00 Executing Savedata webservice ----------------------------- Received JSON : {"savedata":{"axpapp":"gcms","username":"SDO_Bhinder_PRO","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"trccr","recordid":"19446000010434","recdata":[{"axp_recid1":[{"rowno":"001","text":"19446000010434","columns":{"court_name":"1261550007172","court_code":"18141","institution_date":"03/11/2025","case_no":"2025/341","istransfer":"F","trans_court":"","trans_courtcode":"","transreqid":"0","x_case_no":"","land_area":"???????","land_areaid":"2","district_name":"1000633","tehsil_name":"13243000001654","village_name":"1101388","panchayat_name":"???????","case_type":"17999000000000","case_type_code":"","case_purpose_name":"1000492","case_purpose_code":"","last_hearing_date":"23/12/2025","act_name":"1000082","act_code":"","section_name":"188,53","stay_application":"No","mcase_no":"116/25","link_case":"","casedescription":""}}]},{"axp_recid3":[{"rowno":"001","text":"19446000010436","columns":{"appellant_type":"18308000000000","appellant_name":"????????","aprelationship":"?????","father_husband_name":"???????? ","phone1":"","appellant_email":"","appellant_otherid":"","appellant_gender":"N/A","acategory":"18707000000000","appellant_address":"??????-??????? ????? ?????? ???? ??????","astate_name":"10206000000000","adistrict_name":"1000633","atehsil_name":"13243000001654","aprimarycheck":"YES","app_inactive":"NO"}}]},{"axp_recid4":[{"rowno":"001","text":"19446000010437","columns":{"respondent_type":"18308000000000","respondent_name":"?????? ???? ","relationship":"?????","rfather_husband_name":"???? ??? ","respondent_phone1":"","respondent_email":"","respondent_otherid":"","respondent_gender":"N/A","rcategory":"18707000000000","respondent_address":"??????-??????? ????? ?????? ???? ??????","rstate_name":"10206000000000","rdistrict_name":"1000633","rtehsil_name":"13243000001654","rprimarycheck":"YES","res_inactive":"NO"}}]},{"axp_recid5":[{"rowno":"001","text":"19446000010435","columns":{"advocate_mastid":"1935330004604","advcontactcr":"9999999999","advocate_type":"18311000000000","adv_inactive":"NO"}}]},{"axp_recid8":[{"rowno":"001","text":"19446000010434","columns":{"linked_case_no":"","primary_appellant":"????????","primary_respondent":"?????? ???? ","app_adv_mastid":"0","resp_adv_mastid":"0"}}]}]}} Verifying username and password User Name : SDO_Bhinder_PRO Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app' U=sdo_bhinder_pro Time elapsed = 16 Password checking along with max.no of login specified in app.xml update axusers set logintry = 0 where lower(username) = :U Time elapsed = 3 Result : Verifying completed... Page Access Category : User Name : sdo_bhinder_pro Select sysdate as sdt from dual Time elapsed = 2 dt=03/12/2025 14:39:36 Select sysdate as sdt from dual Time elapsed = 2 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=sdo_bhinder_pro dt=03/12/2025 14:39:36 dt=03/12/2025 14:39:36 Time elapsed = 5 User Groups: court_admin select userroles from axusergroups where groupname in ( 'court_admin' ) Time elapsed = 2 User Roles : court_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 = 2 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=SDO_Bhinder_PRO select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1 username=SDO_Bhinder_PRO Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m2},{court_name}) Calling function sqlget Result of sqlget = ????? ???????,??????,?????? Result = ????? ???????,??????,?????? Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1}) Calling function firesql username=SDO_Bhinder_PRO select a.court_type from v_axcourts a where a.paxusername= :username order by 1 username=SDO_Bhinder_PRO Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m3},{court_type}) Calling function sqlget Result of sqlget = SDO Result = SDO Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1}) Calling function firesql username=SDO_Bhinder_PRO select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1 username=SDO_Bhinder_PRO Time elapsed = 4 Result of firesql = Result = Evaluating sqlget({m4},{court_name_mastid}) Calling function sqlget Result of sqlget = 1261550007172 Result = 1261550007172 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=SDO_Bhinder_PRO Time elapsed = 2 Result of firesql = Result = Evaluating sqlget({m4},{axusersid}) Calling function sqlget Result of sqlget = 1489770008383 Result = 1489770008383 Evaluating firesql({m4},{select :username as uname from dual}) Calling function firesql select :username as uname from dual username=SDO_Bhinder_PRO Time elapsed = 7 Result of firesql = Result = Evaluating sqlget({m4},{uname}) Calling function sqlget Result of sqlget = SDO_Bhinder_PRO Result = SDO_Bhinder_PRO 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=SDO_Bhinder_PRO Time elapsed = 4 Result of firesql = Result = Evaluating sqlget({m4},{COURT_CODE}) Calling function sqlget Result of sqlget = 18141 Result = 18141 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 = 2 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=SDO_Bhinder_PRO SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=SDO_Bhinder_PRO Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m7},{DISTNAMEENG}) Calling function sqlget Result of sqlget = Udaipur Result = Udaipur Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1}) Calling function firesql username=SDO_Bhinder_PRO SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=SDO_Bhinder_PRO Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m8},{COURT_CATEGOTY}) Calling function sqlget Result of sqlget = 10593000000007 Result = 10593000000007 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=1489770008383 select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid login_userid=1489770008383 Time elapsed = 5 Result of firesql = Result = Evaluating sqlget({m4},{department_mastid}) Calling function sqlget Result of sqlget = 1579880000000 Result = 1579880000000 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=SDO_Bhinder_PRO Time elapsed = 2 Result of firesql = Result = Evaluating sqlget({m3},{court_type_mastid}) Calling function sqlget Result of sqlget = 10823000000000 Result = 10823000000000 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=SDO_Bhinder_PRO 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=SDO_Bhinder_PRO Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m4},{groupname}) Calling function sqlget Result of sqlget = court_admin Result = court_admin 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 = 2 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=SDO_Bhinder_PRO 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=SDO_Bhinder_PRO Time elapsed = 6 Result of firesql = Result = Evaluating sqlget({P1},{ct}) Calling function sqlget Result of sqlget = 5 Result = 5 3 completed LoadAppVars Password validation done successfully select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_admin') and lower(sname)='trccr' and stype = 't' ) Time elapsed = 2 select Props from axuseraccess where lower(rname)='court_admin' and lower(sname)='trccr' and stype = 't' Time elapsed = 3 Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno Paramval : court_admin,trccr,t ParamTYpe : ccc Param List : rname sname stype select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno Time elapsed = 2 Reading data from stream Executing GetTransControlString Executing GetTransControl Creating DbCall Structure xml not received from client Step3 Sql : select props from tstructs where lower(name)= :name order by blobno Paramval : trccr ParamTYpe : c Param List : name select props from tstructs where lower(name)= :name order by blobno Time elapsed = 3 Step4 tstructs\stm size:9253 Step4-0 Step4-1 Step4-2 Step4-3 Step4-4 Step5 Step6 Step9 select lpad(' ', 250, ' ') LVAL from dual Time elapsed = 4 select lpad(' ', 250, ' ') LVAL from dual Time elapsed = 2 select lpad(' ', 250, ' ') LVAL from dual Time elapsed = 3 Evaluating date() Result = Evaluating iif(reqcheck = 0, {T}, { Already Approved/Rejected}) Result = Evaluating m_courtname Result = Evaluating iif(recordid > 0 ,secaseno , newcaseno ) Result = Evaluating {Yes} Result = Evaluating {ADVOCATE} Result = Evaluating iif(isempty(pcasedesc) = {T}, upper(trim(casedescription)), pcasedesc) Result = Evaluating last_hearing_date Result = Evaluating court_code+case_no Result = Evaluating IIF( recordid > 0,{T},{T}) Result = Evaluating IIF(case_decision_date = {NULL} , {T},{Modification Not allowed here}) Result = Evaluating 0 Result = Evaluating {F} Result = Evaluating iif(recordid>0,{Case Reg Updated},{New Case Registration}) Result = Evaluating {F} Result = Evaluating iif(appellant_type={सरकार},{सरकार},appellant_name) Result = Evaluating dstnam Result = Evaluating UPPER(aprimarycheck) Result = Evaluating {NO} Result = Evaluating IIF(( (lower(aprimarycheck)={yes}) & ( lower(app_inactive)={no}) ),1,0) Result = Evaluating appellant_name+atehsil_name Result = Evaluating upper(rprimarycheck) Result = Evaluating {NO} Result = Evaluating IIF(( (lower(rprimarycheck) = {yes}) & ( lower(res_inactive) = {no}) ),1,0) Result = Evaluating respondent_name+rtehsil_name Result = Evaluating IIF(lower(primarycheck)={yes},1,0) Result = Evaluating acttemp Result = Evaluating ldecision_datetemp Result = Evaluating IIF( ldecision_date > institution_date,{Decision Date Should be Less then Institution Date},{T}) Result = Evaluating IIF( isempty(caveatno) = {T} , 0,1) Result = Evaluating 1 Result = Evaluating link_case Result = Evaluating total({aprimarycheckcal}) Result = Evaluating total({rprimarycheckcal}) Result = Evaluating total({lcntvalue}) Result = select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout) tid=trccr adxinout=o Time elapsed = 3 select * from trn_rcms_casereg where trn_rcms_caseregid=0 Time elapsed = 4 select * from Axusers where 1=2 Time elapsed = 3 select distinct(fldname) from AxTempUserFields Time elapsed = 2 select * from AxAttachWorkflow where lower(transid) = 'trccr' Time elapsed = 2 Step3 Sql : select props from tstructs where lower(name)= :name order by blobno Paramval : tchdh ParamTYpe : c Param List : name select props from tstructs where lower(name)= :name order by blobno Time elapsed = 2 Step4 tstructs\stm size:1907 Step4-0 Step4-1 Step4-2 Step4-3 Step4-4 Step5 Step6 Step9 Post on approve = False select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout) tid=tchdh adxinout=o Time elapsed = 3 select * from trn_rcms_case_hist where trn_rcms_case_histid=0 Time elapsed = 3 Step3 Sql : select props from tstructs where lower(name)= :name order by blobno Paramval : tsrcf ParamTYpe : c Param List : name select props from tstructs where lower(name)= :name order by blobno Time elapsed = 1 Step4 tstructs\stm size:4166 Step4-0 Step4-1 Step4-2 Step4-3 Step4-4 Step5 Step6 Step9 Post on approve = False select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout) tid=tsrcf adxinout=o Time elapsed = 3 select * from trn_rcms_hearing where trn_rcms_hearingid=0 Time elapsed = 3 Evaluating date() Result = Evaluating { AND a1.court_code = :m_courtcode } Result = Evaluating m_courtname Result = Evaluating case_purpose_name Result = Evaluating {NO} Result = Evaluating {Feedback Submitted} Result = Loading genmaps Step3 Sql : select props from tstructs where lower(name)= :name order by blobno Paramval : tchdh ParamTYpe : c Param List : name select props from tstructs where lower(name)= :name order by blobno Time elapsed = 1 Step4 tstructs\stm size:1907 Step4-0 Step4-1 Step4-2 Step4-3 Step4-4 Step5 Step6 Step9 Post on approve = False select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout) tid=tchdh adxinout=o Time elapsed = 2 select * from trn_rcms_case_hist where trn_rcms_case_histid=0 Time elapsed = 2 Creating Action object Submitting data to dbcall Submiting & Registering data Registering Global variables data Registering Global variables data over Error : Savedata webservice completed Freeing DbCall Resources Freeing Store data