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
<transaction username="parveenbor" password="827ccb0eea8a706c4c34a16891f84e7b" seed="" axpapp="gcms"><axpapp>gcms</axpapp><username>parveenbor</username><password>827ccb0eea8a706c4c34a16891f84e7b</password><seed></seed><s></s><transid>rbold</transid><recordid>0</recordid><recdata></recdata><data transid="rbold" recordid="0"><axp_recid1 rowno="001">0</axp_recid1><court_name rowno="001">11599000000000</court_name><court_code rowno="001">10006</court_code><pcaseregid rowno="001">0</pcaseregid><institution_date rowno="001">11/07/2025</institution_date><case_no rowno="001">1997/205</case_no><priority rowno="001">No</priority><x_case_no rowno="001"></x_case_no><land_area rowno="001">2</land_area><district_name rowno="001">10206000000005</district_name><tehsil_name rowno="001">1004667</tehsil_name><village_name rowno="001">1084141</village_name><panchayat_name rowno="001">??? ?????? </panchayat_name><section_group rowno="001">230 RTA</section_group><sectionid rowno="001">16</sectionid><case_type rowno="001">10985000000030</case_type><case_type_code rowno="001"></case_type_code><bench_type rowno="001">1000571</bench_type><bench_name rowno="001">1000613</bench_name><benchcode rowno="001"></benchcode><act_name rowno="001">10199000000860</act_name><act_code rowno="001"></act_code><case_purpose_name rowno="001">10033000000815</case_purpose_name><case_purpose_code rowno="001"></case_purpose_code><prvcaseno rowno="001"></prvcaseno><baj_no rowno="001">2002/113</baj_no><hearingdate rowno="001">18/07/2025</hearingdate><usercode rowno="001">25</usercode><stay_application rowno="001">No</stay_application><urgent_hearing rowno="001">No</urgent_hearing><miyad rowno="001">Yes</miyad><link_case rowno="001"></link_case><axp_recid3 rowno="001">0</axp_recid3><appellant_type rowno="001">18308000000000</appellant_type><appellant_name rowno="001">????????? ?????</appellant_name><aprelationship rowno="001">?????</aprelationship><father_husband_name rowno="001">????? ???? ???? ????? </father_husband_name><phone1 rowno="001"></phone1><appellant_email rowno="001"></appellant_email><appellant_otherid rowno="001"></appellant_otherid><appellant_gender rowno="001"></appellant_gender><acategory rowno="001">18707000000000</acategory><appellant_address rowno="001">??????-??????-??????? ????? ?????? ???? ?????</appellant_address><astate_name rowno="001">10206000000000</astate_name><adistrict_name rowno="001">10206000000005</adistrict_name><atehsil_name rowno="001">1004667</atehsil_name><aprimarycheck rowno="001">YES</aprimarycheck><app_inactive rowno="001">NO</app_inactive><axp_recid4 rowno="001">0</axp_recid4><respondent_type rowno="001">18308000000000</respondent_type><respondent_name rowno="001">???? ?????</respondent_name><relationship rowno="001">?????</relationship><rfather_husband_name rowno="001">???? ?????? ????</rfather_husband_name><respondent_phone1 rowno="001"></respondent_phone1><respondent_email rowno="001"></respondent_email><respondent_otherid rowno="001"></respondent_otherid><respondent_gender rowno="001"></respondent_gender><rcategory rowno="001">18707000000000</rcategory><respondent_address rowno="001">??????-?????? ?? ?????, ??????-??????? ????? ?????? ???? ?????</respondent_address><rstate_name rowno="001">10206000000000</rstate_name><rdistrict_name rowno="001">10206000000005</rdistrict_name><rtehsil_name rowno="001">1004667</rtehsil_name><rprimarycheck rowno="001">YES</rprimarycheck><res_inactive rowno="001">NO</res_inactive><axp_recid5 rowno="001">0</axp_recid5><advocate_mastid rowno="001">7540</advocate_mastid><advcontact rowno="001">9829521170</advcontact><advocate_type rowno="001">18312000000000</advocate_type><adv_inactive rowno="001">NO</adv_inactive><axp_recid5 rowno="002"></axp_recid5><advocate_mastid rowno="002">7685</advocate_mastid><advcontact rowno="002">9887028983</advcontact><advocate_type rowno="002">18311000000000</advocate_type><adv_inactive rowno="002">NO</adv_inactive><axp_recid7 rowno="001">0</axp_recid7><ldistrict_name rowno="001">10206000000005</ldistrict_name><lcourt_type rowno="001">10206000000014</lcourt_type><lcourt_name rowno="001">13289000000053</lcourt_name><lcase_no rowno="001">1997/22</lcase_no><ldecision_date rowno="001">03/07/1997</ldecision_date><pappellant_name rowno="001">????????? ?????</pappellant_name><prespondent_name rowno="001">???? ?????</prespondent_name><caveatno rowno="001"></caveatno><lact_name rowno="001">0</lact_name><lsection_name rowno="001">0</lsection_name><axp_recid7 rowno="002">0</axp_recid7><ldistrict_name rowno="002">10206000000005</ldistrict_name><lcourt_type rowno="002">10206000000015</lcourt_type><lcourt_name rowno="002">12233000000164</lcourt_name><lcase_no rowno="002">1996/1</lcase_no><ldecision_date rowno="002">29/11/1996</ldecision_date><pappellant_name rowno="002">???? ?????</pappellant_name><prespondent_name rowno="002">????????? ?????</prespondent_name><caveatno rowno="002"></caveatno><lact_name rowno="002">0</lact_name><lsection_name rowno="002">0</lsection_name><axp_recid9 rowno="001">0</axp_recid9><linked_case_no rowno="001"></linked_case_no><primary_appellant rowno="001">????????? ?????</primary_appellant><primary_respondent rowno="001">???? ?????</primary_respondent></data></transaction>

Executing Savedata webservice
-----------------------------
Received JSON : {"savedata":{"axpapp":"gcms","username":"parveenbor","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"rbold","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"court_name":"11599000000000","court_code":"10006","pcaseregid":"0","institution_date":"11/07/2025","case_no":"1997/205","priority":"No","x_case_no":"","land_area":"2","district_name":"10206000000005","tehsil_name":"1004667","village_name":"1084141","panchayat_name":"??? ?????? ","section_group":"230 RTA","sectionid":"16","case_type":"10985000000030","case_type_code":"","bench_type":"1000571","bench_name":"1000613","benchcode":"","act_name":"10199000000860","act_code":"","case_purpose_name":"10033000000815","case_purpose_code":"","prvcaseno":"","baj_no":"2002/113","hearingdate":"18/07/2025","usercode":"25","stay_application":"No","urgent_hearing":"No","miyad":"Yes","link_case":""}}]},{"axp_recid3":[{"rowno":"001","text":"0","columns":{"appellant_type":"18308000000000","appellant_name":"????????? ?????","aprelationship":"?????","father_husband_name":"????? ???? ???? ????? ","phone1":"","appellant_email":"","appellant_otherid":"","appellant_gender":"","acategory":"18707000000000","appellant_address":"??????-??????-??????? ????? ?????? ???? ?????","astate_name":"10206000000000","adistrict_name":"10206000000005","atehsil_name":"1004667","aprimarycheck":"YES","app_inactive":"NO"}}]},{"axp_recid4":[{"rowno":"001","text":"0","columns":{"respondent_type":"18308000000000","respondent_name":"???? ?????","relationship":"?????","rfather_husband_name":"???? ?????? ????","respondent_phone1":"","respondent_email":"","respondent_otherid":"","respondent_gender":"","rcategory":"18707000000000","respondent_address":"??????-?????? ?? ?????, ??????-??????? ????? ?????? ???? ?????","rstate_name":"10206000000000","rdistrict_name":"10206000000005","rtehsil_name":"1004667","rprimarycheck":"YES","res_inactive":"NO"}}]},{"axp_recid5":[{"rowno":"001","text":"0","columns":{"advocate_mastid":"7540","advcontact":"9829521170","advocate_type":"18312000000000","adv_inactive":"NO"}},{"rowno":"002","text":"","columns":{"advocate_mastid":"7685","advcontact":"9887028983","advocate_type":"18311000000000","adv_inactive":"NO"}}]},{"axp_recid7":[{"rowno":"001","text":"0","columns":{"ldistrict_name":"10206000000005","lcourt_type":"10206000000014","lcourt_name":"13289000000053","lcase_no":"1997/22","ldecision_date":"03/07/1997","pappellant_name":"????????? ?????","prespondent_name":"???? ?????","caveatno":"","lact_name":"0","lsection_name":"0"}},{"rowno":"002","text":"0","columns":{"ldistrict_name":"10206000000005","lcourt_type":"10206000000015","lcourt_name":"12233000000164","lcase_no":"1996/1","ldecision_date":"29/11/1996","pappellant_name":"???? ?????","prespondent_name":"????????? ?????","caveatno":"","lact_name":"0","lsection_name":"0"}}]},{"axp_recid9":[{"rowno":"001","text":"0","columns":{"linked_case_no":"","primary_appellant":"????????? ?????","primary_respondent":"???? ?????"}}]}]}}
Verifying username and password
User Name : parveenbor
Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app'
U=parveenbor
Time elapsed = 18
Password checking along with max.no of login specified in app.xml
update axusers set logintry = 0 where lower(username) = :U
Time elapsed = 7
Result : 
Verifying completed...
Page Access Category : 
User Name : parveenbor
Select sysdate as sdt from dual
Time elapsed = 4
dt=11/07/2025 12:21:45
Select sysdate as sdt from dual
Time elapsed = 3
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=parveenbor
dt=11/07/2025 12:21:45
dt=11/07/2025 12:21:45
Time elapsed = 9
User Groups: rb_admin
select userroles from axusergroups where groupname in ( 'rb_admin' )
Time elapsed = 3
User Roles : rb_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 = 3
Step4
axprops\stm size:4235
Step4-123456
<root updatedon="11/07/2025 12:13:14" name="app" caption="app" appverno="10.1.0.0" updusername="" updatedby="admin"><props LocalNum="748"><app color="$00EBF5F4" font="Tahoma,8"/><head font="Tahoma,12,tfff" color="$00DDE8E7"/><gridhead color="$00FFE8E8" font=""/><gridrow oddrowcolor="$00FEFCFA" evenrowcolor="$00FEF3ED"></gridrow><imgsfolder>images\</imgsfolder><container color="$00E8F1F0"/><name fontname="" fontsize="" fontbold="" fontitalic="" fontunderline="" fontcolor="" fontstrikeout="">Generalized Court Management System</name><img></img><envvar><currency>INR</currency><millions>F</millions><siteno></siteno><oraerrfrom>500</oraerrfrom><oraerrto>250000</oraerrto><postauto>F</postauto><finyrst></finyrst><finyred></finyred><cursep></cursep></envvar><currencies><INR></INR></currencies><appvars><m_courtname value="" param="f" hidden="false"><l>firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})</l><l>m_courtname := sqlget({m2},{court_name})</l></m_courtname><m_courttype value="" param="f" hidden="false"><l>firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})</l><l>m_courttype := sqlget({m3},{court_type})</l></m_courttype><m_courtid value="" param="f" hidden="false"><l>firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})</l><l>m_courtid := sqlget({m4},{court_name_mastid})</l></m_courtid><login_userid value="" param="f" hidden="false"><l>firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})</l><l>login_userid := sqlget({m4},{axusersid})</l></login_userid><u_name value="" param="f" hidden="false"><l>firesql({m4},{select :username as uname from dual})</l><l>u_name := sqlget({m4},{uname})</l></u_name><m_courtcode value="" param="f" hidden="false"><l>firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})</l><l>m_courtcode := sqlget({m4},{COURT_CODE})</l></m_courtcode><m_statename value="" param="f" hidden="false"><l>firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})</l><l>m_statename := sqlget({m2},{STATE_NAME})</l></m_statename><m_distname value="" param="f" hidden="false"><l>firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})</l><l>m_distName := sqlget({m7},{DISTNAMEENG})</l></m_distname><m_courtcatid value="" param="f" hidden="false"><l>firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})</l><l>m_courtcatid := sqlget({m8},{COURT_CATEGOTY})</l></m_courtcatid><m_deptid value="" param="f" hidden="false"><l>firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})</l><l>m_deptid := sqlget({m4},{department_mastid})</l></m_deptid><m_courttypeid value="" param="f" hidden="false"><l>firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})</l><l>m_courttypeid := sqlget({m3},{court_type_mastid})</l></m_courttypeid><urole value="" param="f" hidden="false"><l>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 })</l><l>urole := sqlget({m4},{groupname})</l></urole><m_cutoffdt value="" param="f" hidden="false"><l>firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})</l><l>m_cutoffdt := sqlget({a1},{dd})</l></m_cutoffdt><m_offcount value="" param="f" hidden="false"><l>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})</l><l>m_offcount := sqlget({P1},{ct})</l></m_offcount></appvars><readonlyprops readonly_fontcolor="clBlack" readonly_bgcolor="clWindow"/><gfont/><mail><host></host><port></port><userid></userid><password></password></mail><pwdsetting><maxlogintry>0</maxlogintry><pwdexpdays>0</pwdexpdays><pwdalertdays>0</pwdalertdays><pwdminchars>0</pwdminchars><pwdprevnos>0</pwdprevnos><ispwdalphanum>F</ispwdalphanum></pwdsetting></props></root>
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=parveenbor
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=parveenbor
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m2},{court_name})
   Calling function sqlget
   Result of sqlget = BOARD OF REVENUE,AJMER
   Result = BOARD OF REVENUE,AJMER
   Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
   Calling function firesql
username=parveenbor
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=parveenbor
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type})
   Calling function sqlget
   Result of sqlget = Revenue Board
   Result = Revenue Board
   Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
   Calling function firesql
username=parveenbor
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=parveenbor
Time elapsed = 4
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{court_name_mastid})
   Calling function sqlget
   Result of sqlget = 11599000000000
   Result = 11599000000000
   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=parveenbor
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{axusersid})
   Calling function sqlget
   Result of sqlget = 1464220000274
   Result = 1464220000274
   Evaluating firesql({m4},{select :username as uname from dual})
   Calling function firesql
select :username as uname from dual
username=parveenbor
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{uname})
   Calling function sqlget
   Result of sqlget = parveenbor
   Result = parveenbor
   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=parveenbor
Time elapsed = 4
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{COURT_CODE})
   Calling function sqlget
   Result of sqlget = 10006
   Result = 10006
   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 = 4
   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=parveenbor
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=parveenbor
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m7},{DISTNAMEENG})
   Calling function sqlget
   Result of sqlget = Ajmer
   Result = Ajmer
   Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
   Calling function firesql
username=parveenbor
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=parveenbor
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=1464220000274
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1464220000274
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=parveenbor
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type_mastid})
   Calling function sqlget
   Result of sqlget = 10206000000012
   Result = 10206000000012
   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=parveenbor
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=parveenbor
Time elapsed = 9
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{groupname})
   Calling function sqlget
   Result of sqlget = rb_admin
   Result = rb_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 = 3
   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=parveenbor
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=parveenbor
Time elapsed = 10
   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 ('rb_admin') and lower(sname)='rbold' and stype = 't' )

Time elapsed = 2
Error : 
Savedata webservice completed


Freeing DbCall Resources
Freeing Action Obj Resources
Closing connection
# 1#Saving to log
Param Type = c
username=parveenbor
Param Type = c
calledon=11/07/2025 12:21:46
Param Type = c
callfinished=11/07/2025 12:21:47
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=293
Param Type = n
dbtimetaken=200
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