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">Housing</SCHEME><CATEGORYS rowno="001">Cattle shed attached with house</CATEGORYS><SUBCATEGORY rowno="001">Shed</SUBCATEGORY><QUANTITY rowno="001">31</QUANTITY><ASSISTAMT rowno="001">93000</ASSISTAMT><aadhaarno rowno="001"></aadhaarno><janaadhaarno rowno="001">5035641427</janaadhaarno><ackno rowno="001"></ackno><memberid rowno="001">0</memberid><bhamashah rowno="001"></bhamashah><ssoid rowno="001">BASANTM2222</ssoid><applicantname rowno="001">SURESH</applicantname><afhname rowno="001">LOKA</afhname><dob rowno="001">01/01/1966</dob><age rowno="001">60</age><gender rowno="001">Male</gender><category rowno="001"></category><mobileno rowno="001">9785437259</mobileno><email rowno="001"></email><dist rowno="001">Bharatpur</dist><tehsil rowno="001">Rudawal</tehsil><ruralurban rowno="001">Rural</ruralurban><city rowno="001"></city><ward rowno="001"></ward><pansamiti rowno="001">Rupwas</pansamiti><grampanchayat rowno="001">Rudawal</grampanchayat><village rowno="001">Rudawal</village><streetname rowno="001">???????</streetname><houseno rowno="001">0</houseno><disasterdist rowno="001">Bharatpur</disasterdist><disastertehsil rowno="001">Rudawal</disastertehsil><disasterrural rowno="001">Rural</disasterrural><disastercity rowno="001"></disastercity><disasterward rowno="001"></disasterward><disasterpansamiti rowno="001">Rupwas</disasterpansamiti><disastergrampanchayat rowno="001">Rudawal</disastergrampanchayat><disastervillage rowno="001">Rudawal</disastervillage><disasterstreetname rowno="001">???????</disasterstreetname><disasterflatno rowno="001">0</disasterflatno><disasdate rowno="001">31/06/2026</disasdate><disasterdetail rowno="001">????? ????? ????? ????? ????? ?????????? ,??? , ?????? ,???? ,???? ,??? ,???? ?????? ,???? ???? ,???? ???? ,???? ????????? ,???? ,??? ???? ??????</disasterdetail><disasterarea rowno="001">??????? ,????? - ?????? ???? - ??????</disasterarea><disasteraddress rowno="001">??????? ,????? - ?????? ???? - ?????? ????????  pin. 321402</disasteraddress><bankname rowno="001">PUNJAB NATIONAL BANK</bankname><branchname rowno="001">DISTT BHARATPUR</branchname><accountno rowno="001">0931000100065894</accountno><ifsc rowno="001">PUNB0093100</ifsc><axp_recid4 rowno="001">0</axp_recid4><attachname rowno="001">Patwari Report (Authorized construction &amp; damage category)</attachname><description rowno="001">Patwari Report (Authorized construction &amp; damage category)*</description><axp_gridattach_4 rowno="001">REPURT.pdf</axp_gridattach_4><axp_recid4 rowno="001">0</axp_recid4><attachname rowno="001">Patwari Report (Authorized construction &amp; damage category)</attachname><description rowno="001">Patwari Report (Authorized construction &amp; damage category)*</description><axp_gridattach_4 rowno="001">REPURT.pdf</axp_gridattach_4><axp_recid4 rowno="001">0</axp_recid4><attachname rowno="001">Patwari Report (Authorized construction &amp; damage category)</attachname><description rowno="001">Patwari Report (Authorized construction &amp; damage category)*</description><axp_gridattach_4 rowno="001">REPURT.pdf</axp_gridattach_4><axp_recid4 rowno="001">0</axp_recid4><attachname rowno="001">Patwari Report (Authorized construction &amp; damage category)</attachname><description rowno="001">Patwari Report (Authorized construction &amp; damage category)*</description><axp_gridattach_4 rowno="001">REPURT.pdf</axp_gridattach_4><axp_recid5 rowno="001">0</axp_recid5><attribute rowno="001">Cause of Damage</attribute><attvalue rowno="001">????? ????? ????? ????? ????? ?????????? ,??? , ?????? ,???? ,???? ,??? ,???? ?????? ,???? ???? ,???? ???? ,???? ????????? ,???? ,??? ???? ??????   </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":"Housing","CATEGORYS":"Cattle shed attached with house","SUBCATEGORY":"Shed","QUANTITY":"31","ASSISTAMT":"93000","aadhaarno":"","janaadhaarno":"5035641427","ackno":"","memberid":"0","bhamashah":"","ssoid":"BASANTM2222","applicantname":"SURESH","afhname":"LOKA","dob":"01/01/1966","age":"60","gender":"Male","category":"","mobileno":"9785437259","email":"","dist":"Bharatpur","tehsil":"Rudawal","ruralurban":"Rural","city":"","ward":"","pansamiti":"Rupwas","grampanchayat":"Rudawal","village":"Rudawal","streetname":"???????","houseno":"0","disasterdist":"Bharatpur","disastertehsil":"Rudawal","disasterrural":"Rural","disastercity":"","disasterward":"","disasterpansamiti":"Rupwas","disastergrampanchayat":"Rudawal","disastervillage":"Rudawal","disasterstreetname":"???????","disasterflatno":"0","disasdate":"31/06/2026","disasterdetail":"????? ????? ????? ????? ????? ?????????? ,??? , ?????? ,???? ,???? ,??? ,???? ?????? ,???? ???? ,???? ???? ,???? ????????? ,???? ,??? ???? ??????","disasterarea":"??????? ,????? - ?????? ???? - ??????","disasteraddress":"??????? ,????? - ?????? ???? - ?????? ????????  pin. 321402","bankname":"PUNJAB NATIONAL BANK","branchname":"DISTT BHARATPUR","accountno":"0931000100065894","ifsc":"PUNB0093100"}}]},{"axp_recid2":[]},{"axp_recid3":[]},{"axp_recid4":[{"rowno":"001","text":"0","columns":{"attachname":"Patwari Report (Authorized construction & damage category)","description":"Patwari Report (Authorized construction & damage category)*","axp_gridattach_4":"REPURT.pdf"}},{"rowno":"001","text":"0","columns":{"attachname":"Patwari Report (Authorized construction & damage category)","description":"Patwari Report (Authorized construction & damage category)*","axp_gridattach_4":"REPURT.pdf"}},{"rowno":"001","text":"0","columns":{"attachname":"Patwari Report (Authorized construction & damage category)","description":"Patwari Report (Authorized construction & damage category)*","axp_gridattach_4":"REPURT.pdf"}},{"rowno":"001","text":"0","columns":{"attachname":"Patwari Report (Authorized construction & damage category)","description":"Patwari Report (Authorized construction & damage category)*","axp_gridattach_4":"REPURT.pdf"}}]},{"axp_recid5":[{"rowno":"001","text":"0","columns":{"attribute":"Cause of Damage","attvalue":"????? ????? ????? ????? ????? ?????????? ,??? , ?????? ,???? ,???? ,??? ,???? ?????? ,???? ???? ,???? ???? ,???? ????????? ,???? ,??? ???? ??????   "}}]},{"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 = 32
Password checking
Result : 
Verifying completed...
Page Access Category : 
User Name : mobileuser1
Select sysdate as sdt from dual
Time elapsed = 0
dt=03/06/2026 09:17:55
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=03/06/2026 09:17:55
dt=03/06/2026 09:17:55
Time elapsed = 47
User Groups: mobileuser
select userroles from axusergroups where groupname in ( 'mobileuser' )
Time elapsed = 16
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 = 16
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 = 16
   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 = 31
   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 = 31
   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 = 32
   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 = 15
   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 = 31
   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 = 16
   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 = 31
   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 = 47
   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 = 0
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 = 16
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 = 16
select lpad(' ', 250, ' ') LVAL from dual
Time elapsed = 16
   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 = 15
select * from Axusers where 1=2
Time elapsed = 0
select distinct(fldname) from AxTempUserFields
Time elapsed = 15
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 = 16
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 = 32
select * from trn_actionhistory where trn_actionhistoryid=0
Time elapsed = 15
Loading genmaps
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
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=03/06/2026 09:17:53
Param Type = c
callfinished=03/06/2026 09:17:56
Param Type = c
structname=tscaf
Param Type = n
recordid=0
Param Type = c
servicename=Saving data
Param Type = c
serviceresult='31/06/2026' is not a valid date and time
Param Type = n
timetaken=3188
Param Type = n
dbtimetaken=813
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