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="mobileuser1" password="f86bd3b581d1c9b322bb9349df5e753d" seed="" axpapp="dmis"><axpapp>dmis</axpapp><username>mobileuser1</username><password>f86bd3b581d1c9b322bb9349df5e753d</password><seed></seed><s></s><transid>tscaf</transid><recordid>0</recordid><recdata></recdata><data transid="tscaf" recordid="0"><axp_recid1 rowno="001">0</axp_recid1><regno rowno="001">0</regno><calamity rowno="001">FIRE(VILLAGE FIRE)</calamity><SCHEME rowno="001">Gratuitous Relief</SCHEME><CATEGORYS rowno="001">Grievous Injury Requiring hospitalization</CATEGORYS><SUBCATEGORY rowno="001">Hospitalization for more than a week</SUBCATEGORY><QUANTITY rowno="001">1</QUANTITY><ASSISTAMT rowno="001">16000</ASSISTAMT><aadhaarno rowno="001"></aadhaarno><janaadhaarno rowno="001">4581373360</janaadhaarno><ackno rowno="001"></ackno><memberid rowno="001">0</memberid><bhamashah rowno="001"></bhamashah><ssoid rowno="001">MLKHODAELECTRICAL</ssoid><applicantname rowno="001">KOSHALYA BAI MEENA</applicantname><afhname rowno="001">RAMRATAN MEENA</afhname><dob rowno="001">01/01/2009</dob><age rowno="001">17</age><gender rowno="001">Female</gender><category rowno="001"></category><mobileno rowno="001">7891375346</mobileno><email rowno="001"></email><dist rowno="001">Dausa</dist><tehsil rowno="001">Lalsot</tehsil><ruralurban rowno="001">Rural</ruralurban><city rowno="001"></city><ward rowno="001"></ward><pansamiti rowno="001">Lalsot</pansamiti><grampanchayat rowno="001">Suratpura</grampanchayat><village rowno="001">Suratpura</village><streetname rowno="001">KHODA KI DHANI SURATPURA LALSOT DAUSA</streetname><houseno rowno="001">0</houseno><disasterdist rowno="001">Dausa</disasterdist><disastertehsil rowno="001">Lalsot</disastertehsil><disasterrural rowno="001">Rural</disasterrural><disastercity rowno="001"></disastercity><disasterward rowno="001"></disasterward><disasterpansamiti rowno="001">Lalsot</disasterpansamiti><disastergrampanchayat rowno="001">Suratpura</disastergrampanchayat><disastervillage rowno="001">Suratpura</disastervillage><disasterstreetname rowno="001">KHODA KI DHANI SURATPURA LALSOT DAUSA</disasterstreetname><disasterflatno rowno="001">0</disasterflatno><disasdate rowno="001">26/04/2026</disasdate><disasterdetail rowno="001">?? ?? ???? ???? 7 ?????? ???, 3 ????, 1 ????, ???? ???? ?? ?????, ???? ?? ????, ??? ???? ????? ?? ??? ?? ?? ??? ?? ???</disasterdetail><disasterarea rowno="001">KHODA KI DHANI SURATPURA LALSOT DAUSA</disasterarea><disasteraddress rowno="001"></disasteraddress><bankname rowno="001">RAJASTHAN GRAMIN BANK</bankname><branchname rowno="001">MANDAWARI</branchname><accountno rowno="001">83074911920</accountno><ifsc rowno="001">RMGB0000395</ifsc><axp_recid2 rowno="001">0</axp_recid2><name rowno="001">??????? ??? ????</name><relationapplicant rowno="001">?????</relationapplicant><personage rowno="001">18</personage><address rowno="001">KHODA KI DHANI SURATPURA LALSOT DAUSA</address><maritalstatus rowno="001">UnMarried</maritalstatus><axp_recid4 rowno="001">0</axp_recid4><attachname rowno="001">Doctor Prescription</attachname><description rowno="001">?? ?? ???? ???? 7 ?????? ???, 3 ????, 1 ????, ???? ???? ?? ?????, ???? ?? ????, ??? ???? ????? ?? ??? ?? ?? ??? ?? ???</description><axp_gridattach_4 rowno="001">DOCTOR REPORTS.pdf</axp_gridattach_4><axp_recid4 rowno="002">0</axp_recid4><attachname rowno="002">Relational Attachment</attachname><description rowno="002">Relational Attachment1</description><axp_gridattach_4 rowno="002">K AADHAR.pdf</axp_gridattach_4><axp_recid5 rowno="001">0</axp_recid5><attribute rowno="001">cause of injury</attribute><attvalue rowno="001">HAND  EFFECTED TO FIRE</attvalue><axp_recid6 rowno="001">0</axp_recid6><markto rowno="001">Patwari</markto><marktouser rowno="001"></marktouser><viewcode rowno="001"></viewcode><remark rowno="001"></remark></data></transaction>

Executing Savedata webservice
-----------------------------
Received JSON : {"savedata":{"axpapp":"dmis","username":"mobileuser1","password":"f86bd3b581d1c9b322bb9349df5e753d","seed":"","s":"","transid":"tscaf","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"regno":"0","calamity":"FIRE(VILLAGE FIRE)","SCHEME":"Gratuitous Relief","CATEGORYS":"Grievous Injury Requiring hospitalization","SUBCATEGORY":"Hospitalization for more than a week","QUANTITY":"1","ASSISTAMT":"16000","aadhaarno":"","janaadhaarno":"4581373360","ackno":"","memberid":"0","bhamashah":"","ssoid":"MLKHODAELECTRICAL","applicantname":"KOSHALYA BAI MEENA","afhname":"RAMRATAN MEENA","dob":"01/01/2009","age":"17","gender":"Female","category":"","mobileno":"7891375346","email":"","dist":"Dausa","tehsil":"Lalsot","ruralurban":"Rural","city":"","ward":"","pansamiti":"Lalsot","grampanchayat":"Suratpura","village":"Suratpura","streetname":"KHODA KI DHANI SURATPURA LALSOT DAUSA","houseno":"0","disasterdist":"Dausa","disastertehsil":"Lalsot","disasterrural":"Rural","disastercity":"","disasterward":"","disasterpansamiti":"Lalsot","disastergrampanchayat":"Suratpura","disastervillage":"Suratpura","disasterstreetname":"KHODA KI DHANI SURATPURA LALSOT DAUSA","disasterflatno":"0","disasdate":"26/04/2026","disasterdetail":"?? ?? ???? ???? 7 ?????? ???, 3 ????, 1 ????, ???? ???? ?? ?????, ???? ?? ????, ??? ???? ????? ?? ??? ?? ?? ??? ?? ???","disasterarea":"KHODA KI DHANI SURATPURA LALSOT DAUSA","disasteraddress":"","bankname":"RAJASTHAN GRAMIN BANK","branchname":"MANDAWARI","accountno":"83074911920","ifsc":"RMGB0000395"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"name":"??????? ??? ????","relationapplicant":"?????","personage":"18","address":"KHODA KI DHANI SURATPURA LALSOT DAUSA","maritalstatus":"UnMarried"}}]},{"axp_recid3":[]},{"axp_recid4":[{"rowno":"001","text":"0","columns":{"attachname":"Doctor Prescription","description":"?? ?? ???? ???? 7 ?????? ???, 3 ????, 1 ????, ???? ???? ?? ?????, ???? ?? ????, ??? ???? ????? ?? ??? ?? ?? ??? ?? ???","axp_gridattach_4":"DOCTOR REPORTS.pdf"}},{"rowno":"002","text":"0","columns":{"attachname":"Relational Attachment","description":"Relational Attachment1","axp_gridattach_4":"K AADHAR.pdf"}}]},{"axp_recid5":[{"rowno":"001","text":"0","columns":{"attribute":"cause of injury","attvalue":"HAND  EFFECTED TO FIRE"}}]},{"axp_recid6":[{"rowno":"001","text":"0","columns":{"markto":"Patwari","marktouser":"","viewcode":"","remark":""}}]}]}}
Verifying username and password
User Name : mobileuser1
Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app'
U=mobileuser1
Result : ORA-00904: "B"."MAXLOGINTRY": invalid identifier
User Name : mobileuser1
Select * from AXUSERS WHERE lower(username) =:U 
U=mobileuser1
Time elapsed = 31
Password checking
Result : 
Verifying completed...
Page Access Category : 
User Name : mobileuser1
Select sysdate as sdt from dual
Time elapsed = 16
dt=04/05/2026 18:08:58
Select sysdate as sdt from dual
Time elapsed = 15
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=mobileuser1
dt=04/05/2026 18:08:58
dt=04/05/2026 18:08:58
Time elapsed = 31
User Groups: mobileuser
select userroles from axusergroups where groupname in ( 'mobileuser' )
Time elapsed = 0
User Roles : mobileuser
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 = 15
Step4
axprops\stm size:4334
Step4-123456
<root updatedon="21/11/2025 21:22:01" name="app" caption="app" appverno="9.6.0.0" updusername="" updatedby="admin"><props LocalNum="93"><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="">Disaster Management &amp; Relief Department</name><img></img><envvar><currency>INR</currency><millions>F</millions><siteno></siteno><oraerrfrom></oraerrfrom><oraerrto></oraerrto><postauto>F</postauto><cursep>,</cursep></envvar><currencies><INR></INR></currencies><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><appvars><usrrole value="" param="f" hidden="false"><l>firesql({m2},{select a3.valuecode from axusers a1,axuserdistrictdtl a2,cm_lov_values a3 where a1.axusersid=a2.axusersid(+) and a1.USERNAME= :username and A1.USERTYPE=a3.cm_lov_valuesid group by a3.valuecode})</l><l>usrrole := sqlget({m2},{valuecode})</l></usrrole><usrpatwar value="" param="f" hidden="false"><l>firesql({m3},{select LISTAGG(A3.PATWAR_ENG, ',') WITHIN GROUP (ORDER BY A3.PATWAR_ENG) AS patwar from axusers a1,axuserdistrictdtl a2,cm_rvnu_patwar a3 where A1.AXUSERSID = A2.AXUSERSID and  A3.CM_RVNU_PATWARID = A2.PATWAR and A1.USERNAME = :username })</l><l>usrpatwar := sqlget({m3},{patwar})</l></usrpatwar><usrdistnm value="" param="f" hidden="false"><l>firesql({x},{Select distnm from VW_USRDTL where usrnm = :username and rownum=1})</l><l>usrdistnm := sqlget({x},{distnm})</l></usrdistnm><usrtehnm value="" param="f" hidden="false"><l>firesql({x},{Select tehnm from VW_USRDTL where usrnm = :username and rownum=1})</l><l>usrtehnm := sqlget({x},{tehnm})</l></usrtehnm><usrilrnm value="" param="f" hidden="false"><l>firesql({x},{Select ilrnm from VW_USRDTL where usrnm = :username and rownum=1})</l><l>usrilrnm := sqlget({x},{ilrnm})</l></usrilrnm><usrpatnm value="" param="f" hidden="false"><l>firesql({x},{Select patnm from VW_USRDTL where usrnm = :username and rownum=1})</l><l>usrpatnm := sqlget({x},{patnm})</l></usrpatnm><usrdistid value="" param="f" hidden="false"><l>firesql({d1},{Select distinct nvl(X2.DISTRICT,0) distid from axusers x1,axuserdistrictdtl x2 where X1.AXUSERSID = x2.AXUSERSID(+) and x1.username = :username and rownum=1})</l><l>usrdistid := sqlget({d1},{distid})</l></usrdistid><usrdept value="" param="f" hidden="false"><l>firesql({A1},{select nvl(A2.DEPTNAME,'0') DEPTNAME  from axusers a1,axuserdept a2 where A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username and rownum=1})</l><l>usrdept := sqlget({A1},{DEPTNAME})</l></usrdept><usrofc value="" param="f" hidden="false"><l>firesql({A1},{select nvl(A2.OFFICENAME,'0') OFFICENAME  from axusers a1,axuserdept a2 where A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username and rownum=1})</l><l>usrofc := sqlget({A1},{OFFICENAME})</l></usrofc><usrdeptnm value="" param="f" hidden="false"><l>firesql({A1},{select case when a3.DEPTNAME is null then 'ALL' else a3.DEPTNAME end as DEPTNAME   from axusers a1,axuserdept a2,cm_department a3 where A3.CM_DEPARTMENTID(+) = A2.DEPTNAME and A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username })</l><l>usrdeptnm := sqlget({A1},{DEPTNAME})</l></usrdeptnm><usrofcnm value="" param="f" hidden="false"><l>firesql({A1},{Select 'ALL' OFCNAME from dual where :usrofc = 0 UNION Select OFCNAME from cm_office where cm_officeid = :usrofc})</l><l>usrofcnm := sqlget({A1},{OFCNAME})</l></usrofcnm><urole value="" param="f" hidden="false"><l>firesql({m2},{Select x2.usergroup from axusers x1,AXUSERLEVELGROUPS x2 where x1.axusersid = x2.axusersid and x1.username = :username})</l><l>urole := sqlget({m2},{usergroup})</l></urole><usrpatid value="" param="f" hidden="false"><l>firesql({x},{Select PATID from VW_USRDTL where usrnm = :username and rownum=1})</l><l>usrpatid := sqlget({x},{PATID})</l></usrpatid></appvars></props></root>
Step4-4
Step5
Step6
Step9
fetched the props xml
9060000-1000000
2
   Evaluating firesql({m2},{select a3.valuecode from axusers a1,axuserdistrictdtl a2,cm_lov_values a3 where a1.axusersid=a2.axusersid(+) and a1.USERNAME= :username and A1.USERTYPE=a3.cm_lov_valuesid group by a3.valuecode})
   Calling function firesql
username=mobileuser1
select a3.valuecode from axusers a1,axuserdistrictdtl a2,cm_lov_values a3 where a1.axusersid=a2.axusersid(+) and a1.USERNAME= :username and A1.USERTYPE=a3.cm_lov_valuesid group by a3.valuecode
username=mobileuser1
Time elapsed = 234
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m2},{valuecode})
   Calling function sqlget
   Result of sqlget = mobileuser
   Result = mobileuser
   Evaluating firesql({m3},{select LISTAGG(A3.PATWAR_ENG, ',') WITHIN GROUP (ORDER BY A3.PATWAR_ENG) AS patwar from axusers a1,axuserdistrictdtl a2,cm_rvnu_patwar a3 where A1.AXUSERSID = A2.AXUSERSID and  A3.CM_RVNU_PATWARID = A2.PATWAR and A1.USERNAME = :username })
   Calling function firesql
username=mobileuser1
select LISTAGG(A3.PATWAR_ENG, ',') WITHIN GROUP (ORDER BY A3.PATWAR_ENG) AS patwar from axusers a1,axuserdistrictdtl a2,cm_rvnu_patwar a3 where A1.AXUSERSID = A2.AXUSERSID and  A3.CM_RVNU_PATWARID = A2.PATWAR and A1.USERNAME = :username
username=mobileuser1
Time elapsed = 32
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{patwar})
   Calling function sqlget
   Result of sqlget = 
   Result = 
   Evaluating firesql({x},{Select distnm from VW_USRDTL where usrnm = :username and rownum=1})
   Calling function firesql
username=mobileuser1
Select distnm from VW_USRDTL where usrnm = :username and rownum=1
username=mobileuser1
Time elapsed = 32
   Result of firesql = 
   Result = 
   Evaluating  sqlget({x},{distnm})
   Calling function sqlget
   Result of sqlget = ALL
   Result = ALL
   Evaluating firesql({x},{Select tehnm from VW_USRDTL where usrnm = :username and rownum=1})
   Calling function firesql
Select tehnm from VW_USRDTL where usrnm = :username and rownum=1
username=mobileuser1
Time elapsed = 47
   Result of firesql = 
   Result = 
   Evaluating  sqlget({x},{tehnm})
   Calling function sqlget
   Result of sqlget = ALL
   Result = ALL
   Evaluating firesql({x},{Select ilrnm from VW_USRDTL where usrnm = :username and rownum=1})
   Calling function firesql
Select ilrnm from VW_USRDTL where usrnm = :username and rownum=1
username=mobileuser1
Time elapsed = 31
   Result of firesql = 
   Result = 
   Evaluating  sqlget({x},{ilrnm})
   Calling function sqlget
   Result of sqlget = ALL
   Result = ALL
   Evaluating firesql({x},{Select patnm from VW_USRDTL where usrnm = :username and rownum=1})
   Calling function firesql
Select patnm from VW_USRDTL where usrnm = :username and rownum=1
username=mobileuser1
Time elapsed = 31
   Result of firesql = 
   Result = 
   Evaluating  sqlget({x},{patnm})
   Calling function sqlget
   Result of sqlget = ALL
   Result = ALL
   Evaluating firesql({d1},{Select distinct nvl(X2.DISTRICT,0) distid from axusers x1,axuserdistrictdtl x2 where X1.AXUSERSID = x2.AXUSERSID(+) and x1.username = :username and rownum=1})
   Calling function firesql
username=mobileuser1
Select distinct nvl(X2.DISTRICT,0) distid from axusers x1,axuserdistrictdtl x2 where X1.AXUSERSID = x2.AXUSERSID(+) and x1.username = :username and rownum=1
username=mobileuser1
Time elapsed = 31
   Result of firesql = 
   Result = 
   Evaluating  sqlget({d1},{distid})
   Calling function sqlget
   Result of sqlget = 0
   Result = 0
   Evaluating firesql({A1},{select nvl(A2.DEPTNAME,'0') DEPTNAME  from axusers a1,axuserdept a2 where A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username and rownum=1})
   Calling function firesql
username=mobileuser1
select nvl(A2.DEPTNAME,'0') DEPTNAME  from axusers a1,axuserdept a2 where A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username and rownum=1
username=mobileuser1
Time elapsed = 15
   Result of firesql = 
   Result = 
   Evaluating  sqlget({A1},{DEPTNAME})
   Calling function sqlget
   Result of sqlget = 0
   Result = 0
   Evaluating firesql({A1},{select nvl(A2.OFFICENAME,'0') OFFICENAME  from axusers a1,axuserdept a2 where A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username and rownum=1})
   Calling function firesql
select nvl(A2.OFFICENAME,'0') OFFICENAME  from axusers a1,axuserdept a2 where A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username and rownum=1
username=mobileuser1
Time elapsed = 32
   Result of firesql = 
   Result = 
   Evaluating  sqlget({A1},{OFFICENAME})
   Calling function sqlget
   Result of sqlget = 0
   Result = 0
   Evaluating firesql({A1},{select case when a3.DEPTNAME is null then 'ALL' else a3.DEPTNAME end as DEPTNAME   from axusers a1,axuserdept a2,cm_department a3 where A3.CM_DEPARTMENTID(+) = A2.DEPTNAME and A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username })
   Calling function firesql
select case when a3.DEPTNAME is null then 'ALL' else a3.DEPTNAME end as DEPTNAME   from axusers a1,axuserdept a2,cm_department a3 where A3.CM_DEPARTMENTID(+) = A2.DEPTNAME and A1.AXUSERSID = A2.AXUSERSID(+) and A1.USERNAME = :username
username=mobileuser1
Time elapsed = 31
   Result of firesql = 
   Result = 
   Evaluating  sqlget({A1},{DEPTNAME})
   Calling function sqlget
   Result of sqlget = ALL
   Result = ALL
   Evaluating firesql({A1},{Select 'ALL' OFCNAME from dual where :usrofc = 0 UNION Select OFCNAME from cm_office where cm_officeid = :usrofc})
   Calling function firesql
usrofc=0
Select 'ALL' OFCNAME from dual where :usrofc = 0 UNION Select OFCNAME from cm_office where cm_officeid = :usrofc
usrofc=0
usrofc=0
Time elapsed = 15
   Result of firesql = 
   Result = 
   Evaluating  sqlget({A1},{OFCNAME})
   Calling function sqlget
   Result of sqlget = ALL
   Result = ALL
   Evaluating firesql({m2},{Select x2.usergroup from axusers x1,AXUSERLEVELGROUPS x2 where x1.axusersid = x2.axusersid and x1.username = :username})
   Calling function firesql
Select x2.usergroup from axusers x1,AXUSERLEVELGROUPS x2 where x1.axusersid = x2.axusersid and x1.username = :username
username=mobileuser1
Time elapsed = 31
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m2},{usergroup})
   Calling function sqlget
   Result of sqlget = mobileuser
   Result = mobileuser
   Evaluating firesql({x},{Select PATID from VW_USRDTL where usrnm = :username and rownum=1})
   Calling function firesql
Select PATID from VW_USRDTL where usrnm = :username and rownum=1
username=mobileuser1
Time elapsed = 31
   Result of firesql = 
   Result = 
   Evaluating  sqlget({x},{PATID})
   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 ('mobileuser') and lower(sname)='tscaf' and stype = 't' )

Time elapsed = 16
select Props from axuseraccess where lower(rname)='mobileuser' and lower(sname)='tscaf' and stype = 't'
Time elapsed = 15
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno

Paramval : mobileuser,tscaf,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 = 16
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 : tscaf
ParamTYpe : c
Param List : name

select props from tstructs where lower(name)= :name  order by blobno

Time elapsed = 0
Step4
tstructs\stm size:11883
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
select lpad(' ', 250, ' ') LVAL from dual
Time elapsed = 15
select lpad(' ', 250, ' ') LVAL from dual
Time elapsed = 15
   Evaluating recordid
   Result = 
   Evaluating userroles
   Result = 
   Evaluating username
   Result = 
   Evaluating usrdistid
   Result = 
   Evaluating date()
   Result = 
   Evaluating iif(age > 17,{T},{ should be greater then or equal 18})
   Result = 
   Evaluating iif(getlength(mobileno) < 10 , {Mobile Number should be of 10 Digit},{T})
   Result = 
   Evaluating iif(ruralurban = {Urban},iif(isempty(city)={T},{ is mandatory},{T}), {T})
   Result = 
   Evaluating iif(ruralurban = {Rural},iif( isempty(pansamiti) ={T}, { is mandatory},{T}),{T})
   Result = 
   Evaluating iif(ruralurban = {Rural}, iif(isempty(grampanchayat) = {T},{ is mandatory},{T}),{T})
   Result = 
   Evaluating iif(ruralurban={Rural},iif(isempty(Village) = {T}, {is mandatory},{T}),{T})
   Result = 
   Evaluating iif(ruralurban = {Urban},iif(isempty(disastercity)={T},{ is mandatory},{T}), {T})
   Result = 
   Evaluating iif(disasterrural = {Rural},iif( isempty(disasterpansamiti) ={T}, { is mandatory},{T}),{T})
   Result = 
   Evaluating iif(disasterrural = {Rural}, iif(isempty(disastergrampanchayat) = {T},{ is mandatory},{T}),{T})
   Result = 
   Evaluating date()
   Result = 
   Evaluating iif(isempty(disasdate) = {T},{ empty not allowed},iif( disasdate >todaydt,{Future Date Not Allowed},{T} ))
   Result = 
   Evaluating scheme+ssoid
   Result = 
   Evaluating {0}
   Result = 
   Evaluating iif(ismandtory = {Yes}, iif(isempty(description) = {T},{ and attachment is mandatory},{T}),{T})
   Result = 
   Evaluating iif(recordid > 0 & isempty(samvat)={T},{ is Mandatory! },{T})
   Result = 
   Evaluating {Create}
   Result = 
   Evaluating iif(action = {Recommend and Forward} & isempty(markto)={T},{ is mandatory},{T})
   Result = 
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=tscaf
adxinout=o
Time elapsed = 16
select * from cm_activityform where cm_activityformid=0
Time elapsed = 16
select * from Axusers where 1=2
Time elapsed = 0
select distinct(fldname) from AxTempUserFields
Time elapsed = 16
select * from AxAttachWorkflow where lower(transid) = 'tscaf'
Time elapsed = 16
Step3
Sql : select props from tstructs where lower(name)= :name  order by blobno

Paramval : tacwk
ParamTYpe : c
Param List : name

select props from tstructs where lower(name)= :name  order by blobno

Time elapsed = 0
Step4
tstructs\stm size:1693
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=tacwk
adxinout=o
Time elapsed = 15
select * from trn_actionhistory where trn_actionhistoryid=0
Time elapsed = 16
Loading genmaps
Creating Action object
Submitting data to dbcall
Submiting & Registering data 
Registering Global variables data 
Registering Global variables data over
Setting values over
DB Call Validate and save

>>Validating tscaf

>>Frame No 1
recid = 
Evaluating - recordid
   recordid = 0
recid after validation = 0
status = 
recid=0
select flag from CM_ACTIVITYFORM where CM_ACTIVITYFORMID = :recid

recid=0
Time elapsed = 16
isedit = 
recid=0
select (case when flag in (0,3) then 'T' else 'F' end) isedit from CM_ACTIVITYFORM where 
CM_ACTIVITYFORMID = :recid

recid=0
Time elapsed = 16
usrole = 
Evaluating - userroles
   userroles = mobileuser
usrole after validation = mobileuser
usr = 
Evaluating - username
   username = mobileuser1
usr after validation = mobileuser1
usrdistid = 
Evaluating - usrdistid
   usrdistid = 0
usrdistid after validation = 0
dist = Dausa
select  a1.cm_districtid, a1.districtname from cm_district a1 
order by a1.districtname

Time elapsed = 16
regprefix = 
dist=Dausa
select 'AR'||'/'||(SUBSTR(upper( :dist ), 1, 4))||'/'||extract(year from sysdate )||'/' as pref 
from dual

dist=Dausa
Time elapsed = 17
regprefix after validation = AR/DAUS/2026/
regno = 0
regdate = 
recid=0
select TRUNC(CREATEDON) from CM_ACTIVITYFORM where CM_ACTIVITYFORMID = 
:recid

recid=0
Time elapsed = 32
regdate after validation = 30/12/1899
todaydt = 
Evaluating - date()
   Result of date = 04/05/2026
todaydt after validation = 04/05/2026
calamity = FIRE(VILLAGE FIRE)
select CM_DISASTERTYPEID,upper(DISASTERNAME) DISASTERNAME,DISASTERNAMEHN from cm_disastertype 
where  isactive = 'T' and IS4OTHERRELIEF = 'T' 
order by DISASTERNAME

Time elapsed = 16
calamityid = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
calamityid after validation = 12584000000000
scheme = Gratuitous Relief
Select c2.cm_lov_valuesid,C2.VALUECODE from cm_lov_values c2,cm_lov c1
where C1.CM_LOVID = C2.CM_LOVID and C1.LISTCODE = 'schemename' and upper(C2.ACTIVE) = upper('Yes') 
order by C2.VALUECODE

Time elapsed = 16
schemeid = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
schemeid after validation = 12704000000014
categorys = Grievous Injury Requiring hospitalization
schemeid=12704000000014
Select A2.CM_SCHEMECATEGORYID, A2.SCHCATEGORYENG from cm_schemecategory a2,mst_subcategory a1 where A1.CATEGORY = A2.CM_SCHEMECATEGORYID and A1.SCHEME = :schemeid

schemeid=12704000000014
Time elapsed = 32
categoryid = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
categoryid after validation = 14109000000024
quantity = 1
subcategory = Hospitalization for more than a week
schemeid=12704000000014
categoryid=14109000000024
select A2.MST_SUBCATEGORYDTLID, A2.SUBCATEGORY,A2.ASSITAMT  from mst_subcategorydtl a2,mst_subcategory a1
where A2.MST_SUBCATEGORYID = A1.MST_SUBCATEGORYID and A1.SCHEME = :schemeid and A1.CATEGORY = :categoryid

schemeid=12704000000014
categoryid=14109000000024
Time elapsed = 31
subcatid = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
subcatid after validation = 14336000000014
assistamt = 16000
applicantname = KOSHALYA BAI MEENA
afhname = RAMRATAN MEENA
dob = 01/01/2009
age = 17
dob=01-Jan-2009
select  decode(to_char(to_date( :dob, 'dd/mm/yyyy'),'yyyy'),1900,0,floor 
(months_between(sysdate, :dob)/12))age from dual

dob=01-Jan-2009
dob=01-Jan-2009
Time elapsed = 16
Evaluating - iif(age > 17,{T},{ should be greater then or equal 18})
   age = 17
   Result of iif =  should be greater then or equal 18
Age (In Years) should be greater then or equal 18
Validate error msg : Age (In Years) should be greater then or equal 18
Validate error msg1 : Age (In Years) should be greater then or equal 18
Validate error msg2 : Age (In Years) should be greater then or equal 18
DB Call error msg : Age (In Years) should be greater then or equal 18
Error : 
Savedata webservice completed


Freeing DbCall Resources
Freeing Store data
Freeing DD Map
Freeing Provide Link
Freeing Validate
Freeing Parser
Freeing Poststr
Freeing Maxrows
Freeing Fnames
Freeing NewMaxRows
Freeing tlines
Freeing workquery
Freeing Struct
Freeing EventList
Freeing Tree Obj
Freeing Workflow Obj
Freeing DbCall Completed
Freeing Action Obj Resources
Closing connection
# 1#Saving to log
Param Type = c
username=mobileuser1
Param Type = c
calledon=04/05/2026 18:08:50
Param Type = c
callfinished=04/05/2026 18:08:56
Param Type = c
structname=tscaf
Param Type = n
recordid=0
Param Type = c
servicename=Saving data
Param Type = c
serviceresult=Age (In Years) should be greater then or equal 18  Age (In Years) should be greater then or equal 18
Param Type = n
timetaken=5094
Param Type = n
dbtimetaken=1175
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'),:structname,:recordid,:servicename,:serviceresult,:timetaken,:dbtimetaken)

Freeing AxProvider Resources
Freeing DbManager Resources