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">FLOOD</calamity><SCHEME rowno="001">Housing</SCHEME><CATEGORYS rowno="001">Partially Damaged Houses</CATEGORYS><SUBCATEGORY rowno="001">Pucca(other than huts) Damage at least 15%</SUBCATEGORY><QUANTITY rowno="001">2</QUANTITY><ASSISTAMT rowno="001">13000</ASSISTAMT><aadhaarno rowno="001"></aadhaarno><janaadhaarno rowno="001">4777852706</janaadhaarno><ackno rowno="001">1329-2KHR-26630</ackno><memberid rowno="001">65118382154</memberid><bhamashah rowno="001"></bhamashah><ssoid rowno="001">GHISAKALANADA1973</ssoid><applicantname rowno="001">Kishani</applicantname><afhname rowno="001">nathu</afhname><dob rowno="001">01/01/1961</dob><age rowno="001">64</age><gender rowno="001">Female</gender><category rowno="001"></category><mobileno rowno="001">8107283389</mobileno><email rowno="001"></email><dist rowno="001">Ajmer</dist><tehsil rowno="001">Arain</tehsil><ruralurban rowno="001">Rural</ruralurban><city rowno="001"></city><ward rowno="001"></ward><pansamiti rowno="001">Arain</pansamiti><grampanchayat rowno="001">Kalanada</grampanchayat><village rowno="001">Dholpuriya</village><streetname rowno="001">????????</streetname><houseno rowno="001">0</houseno><disasterdist rowno="001">Ajmer</disasterdist><disastertehsil rowno="001">Arain</disastertehsil><disasterrural rowno="001">Rural</disasterrural><disastercity rowno="001"></disastercity><disasterward rowno="001"></disasterward><disasterpansamiti rowno="001">Arain</disasterpansamiti><disastergrampanchayat rowno="001">Kalanada</disastergrampanchayat><disastervillage rowno="001">Dholpuriya</disastervillage><disasterstreetname rowno="001">????????</disasterstreetname><disasterflatno rowno="001">0</disasterflatno><disasdate rowno="001">05/09/2025</disasdate><disasterdetail rowno="001">?????? ????? ??????</disasterdetail><disasterarea rowno="001">????? ???????? ? ????</disasterarea><disasteraddress rowno="001">????? ???????? ? ????</disasteraddress><bankname rowno="001">BANK OF BARODA</bankname><branchname rowno="001">KATSOORA, AJMER, RAJASTHAN - 305801</branchname><accountno rowno="001">17888100000404</accountno><ifsc rowno="001">BARB0KATSOO</ifsc><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":"FLOOD","SCHEME":"Housing","CATEGORYS":"Partially Damaged Houses","SUBCATEGORY":"Pucca(other than huts) Damage at least 15%","QUANTITY":"2","ASSISTAMT":"13000","aadhaarno":"","janaadhaarno":"4777852706","ackno":"1329-2KHR-26630","memberid":"65118382154","bhamashah":"","ssoid":"GHISAKALANADA1973","applicantname":"Kishani","afhname":"nathu","dob":"01/01/1961","age":"64","gender":"Female","category":"","mobileno":"8107283389","email":"","dist":"Ajmer","tehsil":"Arain","ruralurban":"Rural","city":"","ward":"","pansamiti":"Arain","grampanchayat":"Kalanada","village":"Dholpuriya","streetname":"????????","houseno":"0","disasterdist":"Ajmer","disastertehsil":"Arain","disasterrural":"Rural","disastercity":"","disasterward":"","disasterpansamiti":"Arain","disastergrampanchayat":"Kalanada","disastervillage":"Dholpuriya","disasterstreetname":"????????","disasterflatno":"0","disasdate":"05/09/2025","disasterdetail":"?????? ????? ??????","disasterarea":"????? ???????? ? ????","disasteraddress":"????? ???????? ? ????","bankname":"BANK OF BARODA","branchname":"KATSOORA, AJMER, RAJASTHAN - 305801","accountno":"17888100000404","ifsc":"BARB0KATSOO"}}]},{"axp_recid2":[]},{"axp_recid3":[]},{"axp_recid4":[]},{"axp_recid5":[]},{"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 = 0
dt=05/09/2025 14:10:43
Select sysdate as sdt from dual
Time elapsed = 16
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=05/09/2025 14:10:43
dt=05/09/2025 14:10:43
Time elapsed = 32
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 = 16
Step4
axprops\stm size:4334
Step4-123456
<root updatedon="13/05/2025 16:11:49" name="app" caption="app" appverno="9.6.0.0" updusername="" updatedby="admin"><props LocalNum="91"><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 = 47
   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 = 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 = 47
   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 = 16
   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 = 16
   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 = 15
   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 = 0
   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 = 15
   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 = 16
   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 = 0
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
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=05/09/2025 14:10:37
Param Type = c
callfinished=05/09/2025 14:10:39
Param Type = c
structname=tscaf
Param Type = n
recordid=0
Param Type = c
servicename=Saving data
Param Type = c
serviceresult=Out of memory
Param Type = n
timetaken=1906
Param Type = n
dbtimetaken=579
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