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 dmismobileuser1f86bd3b581d1c9b322bb9349df5e753dtscaf000FLOODHousingPartially Damaged HousesPucca(other than huts) Damage at least 15%159750046807436831088-1VO5-2227060074022910ASHOK.VAISHNAV12345Rampyari Khatikdevi01/01/197253Female8104455011TonkMalpuraRuralMalpuraLamba Hari SinghLamba Hari Singhkekri road,Lambaharisingh0TonkMalpuraRuralMalpuraLamba Hari SinghLamba Hari Singhkekri road,Lambaharisingh005/09/2025??????????Lambaharisinghkekri road,LambaharisinghBANK OF BARODALHAMBA HARI SINGH, DIST. TONK, RAJASTHAN - 304 503.13770100013108BARB0LAMHAR0Patwari 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":"15","ASSISTAMT":"97500","aadhaarno":"","janaadhaarno":"4680743683","ackno":"1088-1VO5-22270","memberid":"60074022910","bhamashah":"","ssoid":"ASHOK.VAISHNAV12345","applicantname":"Rampyari Khatik","afhname":"devi","dob":"01/01/1972","age":"53","gender":"Female","category":"","mobileno":"8104455011","email":"","dist":"Tonk","tehsil":"Malpura","ruralurban":"Rural","city":"","ward":"","pansamiti":"Malpura","grampanchayat":"Lamba Hari Singh","village":"Lamba Hari Singh","streetname":"kekri road,Lambaharisingh","houseno":"0","disasterdist":"Tonk","disastertehsil":"Malpura","disasterrural":"Rural","disastercity":"","disasterward":"","disasterpansamiti":"Malpura","disastergrampanchayat":"Lamba Hari Singh","disastervillage":"Lamba Hari Singh","disasterstreetname":"kekri road,Lambaharisingh","disasterflatno":"0","disasdate":"05/09/2025","disasterdetail":"??????????","disasterarea":"Lambaharisingh","disasteraddress":"kekri road,Lambaharisingh","bankname":"BANK OF BARODA","branchname":"LHAMBA HARI SINGH, DIST. TONK, RAJASTHAN - 304 503.","accountno":"13770100013108","ifsc":"BARB0LAMHAR"}}]},{"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 = 33 Password checking Result : Verifying completed... Page Access Category : User Name : mobileuser1 Select sysdate as sdt from dual Time elapsed = 12 dt=03/10/2025 10:34:20 Select sysdate as sdt from dual Time elapsed = 14 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/10/2025 10:34:20 dt=03/10/2025 10:34:20 Time elapsed = 36 User Groups: mobileuser select userroles from axusergroups where groupname in ( 'mobileuser' ) Time elapsed = 12 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 = 10 Step4 axprops\stm size:4334 Step4-123456 images\Disaster Management & Relief DepartmentINRFF,00000F 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 = 40 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 = 22 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 = 30 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 = 30 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 = 33 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 = 32 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 = 23 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 = 22 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 = 22 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 = 17 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 = 25 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 = 26 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 = 30 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 = 11 select Props from axuseraccess where lower(rname)='mobileuser' and lower(sname)='tscaf' and stype = 't' Time elapsed = 12 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 = 9 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 = 9 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 = 14 select lpad(' ', 250, ' ') LVAL from dual Time elapsed = 13 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 = 19 select * from cm_activityform where cm_activityformid=0 Time elapsed = 12 select * from Axusers where 1=2 Time elapsed = 11 select distinct(fldname) from AxTempUserFields Time elapsed = 10 select * from AxAttachWorkflow where lower(transid) = 'tscaf' Time elapsed = 12 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 = 9 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 = 23 select * from trn_actionhistory where trn_actionhistoryid=0 Time elapsed = 10 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 = 15 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 = Tonk select a1.cm_districtid, a1.districtname from cm_district a1 order by a1.districtname Time elapsed = 219 regprefix = dist=Tonk select 'AR'||'/'||(SUBSTR(upper( :dist ), 1, 4))||'/'||extract(year from sysdate )||'/' as pref from dual dist=Tonk Time elapsed = 18 regprefix after validation = AR/TONK/2025/ regno = 0 regdate = recid=0 select TRUNC(CREATEDON) from CM_ACTIVITYFORM where CM_ACTIVITYFORMID = :recid recid=0 Time elapsed = 15 regdate after validation = 30/12/1899 todaydt = Evaluating - date() Result of date = 03/10/2025 todaydt after validation = 03/10/2025 calamity = FLOOD select CM_DISASTERTYPEID,upper(DISASTERNAME) DISASTERNAME,DISASTERNAMEHN from cm_disastertype where isactive = 'T' and IS4OTHERRELIEF = 'T' order by DISASTERNAME Time elapsed = 14 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 = 12558000000000 scheme = Housing 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 = 14 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 = 17032000000141 categorys = Partially Damaged Houses schemeid=17032000000141 Select A2.CM_SCHEMECATEGORYID, A2.SCHCATEGORYENG from cm_schemecategory a2,mst_subcategory a1 where A1.CATEGORY = A2.CM_SCHEMECATEGORYID and A1.SCHEME = :schemeid schemeid=17032000000141 Time elapsed = 17 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 = 17045000000010 quantity = 15 subcategory = Pucca(other than huts) Damage at least 15% schemeid=17032000000141 categoryid=17045000000010 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=17032000000141 categoryid=17045000000010 Time elapsed = 20 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 = 17075000000018 assistamt = 97500 applicantname = Rampyari Khatik afhname = devi dob = 01/01/1972 age = 53 dob=01-Jan-1972 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-1972 dob=01-Jan-1972 Time elapsed = 18 Evaluating - iif(age > 17,{T},{ should be greater then or equal 18}) age = 53 Result of iif = T gender = Female select C.VALUECODE from VW_LOV c where C.LISTCODE = 'gender' and upper(C.ACTIVE) = upper('Yes') Time elapsed = 218 category = select C.VALUECODE from VW_LOV c where C.LISTCODE = 'CastCategory' and upper(C.ACTIVE) = upper('Yes') Time elapsed = 13 mobileno = 8104455011 Evaluating - iif(getlength(mobileno) < 10 , {Mobile Number should be of 10 Digit},{T}) mobileno = 8104455011 Result of getlength = 10 Result of iif = T email = tdist = Finding linkfield in fieldenter function Linkfield found and assigning Query from link field in fieldenter function Query assigned in fieldenter function tdist after validation = 22 tehsil = Malpura dist = ('Tonk') Query component recreating again select a.cm_tehsilid,a.tehsilname from cm_tehsil a ,cm_district b where A.DISTRICTCODE =B.CM_DISTRICTID and upper(B.DISTRICTNAME)= upper('Tonk') Time elapsed = 12 ttehsil = Finding linkfield in fieldenter function Linkfield found and assigning Query from link field in fieldenter function Query assigned in fieldenter function dist = ('Tonk') ttehsil after validation = 205 ruralurban = Rural select C.VALUECODE from VW_LOV c where C.LISTCODE = 'ruralurban' and upper(C.ACTIVE) = upper('Yes') Time elapsed = 220 city = dist=Tonk select C.CM_CITYID, C.CITYENG from cm_city c, cm_district d where C.DISTRICTID = D.CM_DISTRICTID and d.DISTRICTNAME = :dist dist=Tonk Time elapsed = 20 Evaluating - iif(ruralurban = {Urban},iif(isempty(city)={T},{ is mandatory},{T}), {T}) city = Result of isempty = T Result of iif = is mandatory ruralurban = Rural Result of iif = T ward = city= select W.CM_WARDID,W.WARDENG from cm_ward w, cm_city c where W.CITYID = C.CITYID and C.CITYENG = :city order by W.CM_WARDID city= Time elapsed = 16 pansamiti = Malpura dist=Tonk select B.CM_BLOCKID,B.BLOCKNAME from cm_block b,cm_district d where B.DISTRICTCODE = D.CM_DISTRICTID and D.DISTRICTNAME = :dist order by B.BLOCKNAME dist=Tonk Time elapsed = 19 Evaluating - iif(ruralurban = {Rural},iif( isempty(pansamiti) ={T}, { is mandatory},{T}),{T}) pansamiti = Malpura Result of isempty = F Result of iif = T ruralurban = Rural Result of iif = T grampanchayat = Lamba Hari Singh pansamiti=Malpura select gp.cm_gpanchayatId,GP.GPANCHAYATNAME from cm_gpanchayat gp,cm_block b where GP.PANSAMITI = B.CM_BLOCKID and B.BLOCKNAME = :pansamiti order by GP.GPANCHAYATNAME pansamiti=Malpura Time elapsed = 26 Evaluating - iif(ruralurban = {Rural}, iif(isempty(grampanchayat) = {T},{ is mandatory},{T}),{T}) grampanchayat = Lamba Hari Singh Result of isempty = F Result of iif = T ruralurban = Rural Result of iif = T village = Lamba Hari Singh grampanchayat=Lamba Hari Singh dist=Tonk pansamiti=Malpura select V.CM_VILLAGEID,V.VILLAGENAME from cm_village v, cm_gpanchayat gp, cm_district cd, cm_block cb where V.GPANCHAYATID = GP.CM_GPANCHAYATID and CD.CM_DISTRICTID = CB.DISTRICTCODE and CB.CM_BLOCKID = GP.PANSAMITI and GP.GPANCHAYATNAME = :grampanchayat and CD.DISTRICTNAME = :dist and CB.BLOCKNAME = :pansamiti order by V.VILLAGENAME grampanchayat=Lamba Hari Singh dist=Tonk pansamiti=Malpura Time elapsed = 54 Evaluating - iif(ruralurban={Rural},iif(isempty(Village) = {T}, {is mandatory},{T}),{T}) village = Lamba Hari Singh Result of isempty = F Result of iif = T ruralurban = Rural Result of iif = T tvill = Finding linkfield in fieldenter function Linkfield found and assigning Query from link field in fieldenter function Query assigned in fieldenter function tvill after validation = 28289 streetname = kekri road,Lambaharisingh houseno = 0 disasterdist = Tonk select a1.cm_districtid, a1.districtname from cm_district a1 order by a1.districtname Time elapsed = 14 disastertehsil = Malpura disasterdist = ('Tonk') Query component recreating again select a.cm_tehsilid,a.tehsilname from cm_tehsil a ,cm_district b where A.DISTRICTCODE =B.CM_DISTRICTID and upper(B.DISTRICTNAME)= upper('Tonk') Time elapsed = 13 disasterrural = Rural select C.VALUECODE from VW_LOV c where C.LISTCODE = 'ruralurban' and upper(C.ACTIVE) = upper('Yes') Time elapsed = 14 disastercity = disasterdist=Tonk select C.CM_CITYID, C.CITYENG from cm_city c, cm_district d where C.DISTRICTID = D.CM_DISTRICTID and d.DISTRICTNAME = :disasterdist disasterdist=Tonk Time elapsed = 18 Evaluating - iif(ruralurban = {Urban},iif(isempty(disastercity)={T},{ is mandatory},{T}), {T}) disastercity = Result of isempty = T Result of iif = is mandatory ruralurban = Rural Result of iif = T disasterward = disastercity= select W.CM_WARDID,W.WARDENG from cm_ward w, cm_city c where W.CITYID = C.CITYID and C.CITYENG = :disastercity order by W.CM_WARDID disastercity= Time elapsed = 14 disasterpansamiti = Malpura disasterdist=Tonk select B.CM_BLOCKID,B.BLOCKNAME from cm_block b,cm_district d where B.DISTRICTCODE = D.CM_DISTRICTID and D.DISTRICTNAME = :disasterdist order by B.BLOCKNAME disasterdist=Tonk Time elapsed = 19 Evaluating - iif(disasterrural = {Rural},iif( isempty(disasterpansamiti) ={T}, { is mandatory},{T}),{T}) disasterpansamiti = Malpura Result of isempty = F Result of iif = T disasterrural = Rural Result of iif = T disastergrampanchayat = Lamba Hari Singh disasterpansamiti=Malpura select gp.cm_gpanchayatId,GP.GPANCHAYATNAME from cm_gpanchayat gp,cm_block b where GP.PANSAMITI = B.CM_BLOCKID and B.BLOCKNAME = :disasterpansamiti order by GP.GPANCHAYATNAME disasterpansamiti=Malpura Time elapsed = 24 Evaluating - iif(disasterrural = {Rural}, iif(isempty(disastergrampanchayat) = {T},{ is mandatory},{T}),{T}) disastergrampanchayat = Lamba Hari Singh Result of isempty = F Result of iif = T disasterrural = Rural Result of iif = T disastervillage = Lamba Hari Singh disastergrampanchayat=Lamba Hari Singh disasterdist=Tonk disasterpansamiti=Malpura select V.CM_VILLAGEID,V.VILLAGENAME from cm_village v, cm_gpanchayat gp, cm_district cd, cm_block cb where V.GPANCHAYATID = GP.CM_GPANCHAYATID and CD.CM_DISTRICTID = CB.DISTRICTCODE and CB.CM_BLOCKID = GP.PANSAMITI and GP.GPANCHAYATNAME = :disastergrampanchayat and CD.DISTRICTNAME = :disasterdist and CB.BLOCKNAME = :disasterpansamiti order by V.VILLAGENAME disastergrampanchayat=Lamba Hari Singh disasterdist=Tonk disasterpansamiti=Malpura Time elapsed = 53 patwar = disasterdist=Tonk disastertehsil=Malpura disastervillage=Lamba Hari Singh recordid=0 SELECT V.PATWARNM FROM vw_tehsilvill v WHERE V.DISTNM = :disasterdist AND V.TEHSILNM = :disastertehsil AND V.VILLNM = :disastervillage AND :recordid = 0 UNION SELECT PATWAR FROM CM_ACTIVITYFORM WHERE CM_ACTIVITYFORMID = :recordid disasterdist=Tonk disastertehsil=Malpura disastervillage=Lamba Hari Singh recordid=0 recordid=0 Time elapsed = 51 patwar after validation = Lamba Hari Singh disasterstreetname = kekri road,Lambaharisingh disasterflatno = 0 disasdate = 05/09/2025 Evaluating - iif(isempty(disasdate) = {T},{ empty not allowed},iif( disasdate >todaydt,{Future Date Not Allowed},{T} )) disasdate = 05/09/2025 todaydt = 03/10/2025 Result of iif = T disasdate = 05/09/2025 Result of isempty = F Result of iif = T disasterdetail = ?????????? disasterarea = Lambaharisingh aadhaarno = janaadhaarno = 4680743683 ackno = 1088-1VO5-22270 memberid = 60074022910 ssoid = ASHOK.VAISHNAV12345 ifsc = BARB0LAMHAR bhamashah = bankname = BANK OF BARODA branchname = LHAMBA HARI SINGH, DIST. TONK, RAJASTHAN - 304 503. accountno = 13770100013108 chkdupsso = Evaluating - scheme+ssoid scheme = Housing ssoid = ASHOK.VAISHNAV12345 chkdupsso after validation = HousingASHOK.VAISHNAV12345 sanctionflag = Evaluating - {0} sanctionflag after validation = 0 sanctionno = disasteraddress = kekri road,Lambaharisingh samvat = select samvat from cm_otherrelief_config order by Samvat desc Time elapsed = 12 Evaluating - iif(recordid > 0 & isempty(samvat)={T},{ is Mandatory! },{T}) samvat = Result of isempty = T recordid = 0 Result of iif = T farcat = action = farcat= scheme=Housing usrole=mobileuser SELECT DISTINCT CASE WHEN :farcat = 'OSMF' AND :scheme = 'Animal husbandry assistance' THEN 'Reject' ELSE ACTION END AS Action, CASE WHEN :farcat = 'OSMF' AND :scheme = 'Animal husbandry assistance' THEN 5 else VIEWCODE END AS VIEWCODE from cm_wfactionhdr x1, cm_wfactiondtl x2 where x1.cm_wfactionhdrid = x2.cm_wfactionhdrid and upper(x1.TCAPTIONNAME) = UPPER('Relief Assistance Form') and UPPER(ROLE) = UPPER( :usrole ) order by VIEWCODE farcat= scheme=Housing farcat= scheme=Housing usrole=mobileuser Time elapsed = 46 Evaluating - {Create} action after validation = Create markto = Patwari usrole=mobileuser action=Create SELECT DISTINCT a.nextusergroup FROM cm_wfactiondtl a, cm_wfactionhdr b WHERE A.cm_wfactionhdrid = b.cm_wfactionhdrid AND B.Role = :usrole AND a.action = :action AND B.TRNNAME IN (SELECT a2.cm_moduledtlid FROM cm_modulehdr a1, cm_moduledtl a2 WHERE a1.cm_modulehdrid = a2.cm_modulehdrid AND a1.modname = 'Other Relief' AND a2.tname = 'tscaf') usrole=mobileuser action=Create Time elapsed = 27 Evaluating - iif(action = {Recommend and Forward} & isempty(markto)={T},{ is mandatory},{T}) markto = Patwari Result of isempty = F action = Create Result of iif = T marktouser = tdist=22 markto=Patwari ttehsil=205 tvill=28289 SELECT e.USERNAME FROM AXUSERlevelgroups e, axuserdistrictdtl g, AXUSERGROUPS d WHERE E.AXUSERSID = G.AXUSERSID AND E.USERGROUP = d.groupname AND G.DISTRICT = :tdist AND d.USERROLES = :markto AND ( ( :markto = 'Tehsildar' AND G.PSAMITI = :ttehsil ) OR ( :markto IN ('ReliefOIC', 'Collector')) OR ( :markto = 'Patwari' AND (SELECT V.PATWARID FROM vw_tehsilvill v WHERE V.DISTID = :tdist AND V.TEHSILID = :ttehsil AND V.VILLID = :tvill ) = G.PATWAR)) tdist=22 markto=Patwari markto=Patwari ttehsil=205 markto=Patwari markto=Patwari tdist=22 ttehsil=205 tvill=28289 Time elapsed = 80 marktouser after validation = 30315 viewcode = 0 Finding linkfield in fieldenter function Linkfield found and assigning Query from link field in fieldenter function Query assigned in fieldenter function rejreason = remark = flag = Finding linkfield in fieldenter function Linkfield found and assigning Query from link field in fieldenter function Query assigned in fieldenter function flag after validation = 0 appamt = bhamashahstatus = bhamashahremark = a = time zone difference = 0 >>Writing to tables tscaf Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tscaf' Time elapsed = 11 Saving to table CM_ACTIVITYFORM select * from CM_ACTIVITYFORM where CM_ACTIVITYFORMid=0 Time elapsed = 13 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 9 RecordId = 19346000000200 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 12 Select sysdate as sdt from dual Time elapsed = 11 ifsc = BARB0LAMHAR bhamashah = memberid = 60074022910 ssoid = ASHOK.VAISHNAV12345 accountno = 13770100013108 disasteraddress = kekri road,Lambaharisingh bankname = BANK OF BARODA branchname = LHAMBA HARI SINGH, DIST. TONK, RAJASTHAN - 304 503. disasdate = 05/09/2025 disasterdetail = ?????????? disasterstreetname = kekri road,Lambaharisingh disasterflatno = 0 janaadhaarno = 4680743683 ackno = 1088-1VO5-22270 disasterarea = Lambaharisingh aadhaarno = action = Create rejreason = samvat = farcat = bhamashahstatus = 0 bhamashahremark = flag = 0 appamt = 0 viewcode = 0 remark = markto = Patwari marktouser = 30315 sanctionflag = 0 sanctionno = patwar = Lamba Hari Singh chkdupsso = HousingASHOK.VAISHNAV12345 disastervillage = 28289 Select * FROM Sequence WHERE lower(TRANSTYPE)='tscaf' and lower(FIELDNAME)='regno'and lower(prefixfield)='regprefix' Time elapsed = 15 update Sequence set lastno = 125890 where lower(TRANSTYPE)='tscaf' and lower(FIELDNAME)='regno'and lower(prefixfield)='regprefix' Time elapsed = 8 regno = AR/TONK/2025/125889 dist = 22 scheme = 17032000000141 calamity = 12558000000000 mobileno = 8104455011 email = gender = Female category = afhname = devi applicantname = Rampyari Khatik age = 53 dob = 01/01/1972 quantity = 15 categorys = 17045000000010 assistamt = 97500 subcategory = 17075000000018 disastertehsil = 205 disasterrural = Rural houseno = 0 disasterdist = 22 disasterpansamiti = 193 disastergrampanchayat = 6686 disastercity = 0 disasterward = 0 streetname = kekri road,Lambaharisingh city = 0 ward = 0 tehsil = 205 ruralurban = Rural grampanchayat = 6686 village = 28289 pansamiti = 193 Posting record t=19346000000200 select regno from CM_ACTIVITYFORM where regno = 'AR/TONK/2025/125889' and CM_ACTIVITYFORMid <> :t t=19346000000200 Time elapsed = 129 Param Type = n cm_activityformid=19346000000200 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser1 Param Type = c createdon=03/10/2025 10:34:26 Param Type = c username=mobileuser1 Param Type = c modifiedon=03/10/2025 10:34:26 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c ifsc=BARB0LAMHAR Param Type = c memberid=60074022910 Param Type = c ssoid=ASHOK.VAISHNAV12345 Param Type = c accountno=13770100013108 Param Type = c disasteraddress=kekri road,Lambaharisingh Param Type = c bankname=BANK OF BARODA Param Type = c branchname=LHAMBA HARI SINGH, DIST. TONK, RAJASTHAN - 304 503. Param Type = c disasdate=05/09/2025 00:00:00 Param Type = c disasterdetail=?????????? Param Type = c disasterstreetname=kekri road,Lambaharisingh Param Type = c disasterflatno=0 Param Type = c janaadhaarno=4680743683 Param Type = c ackno=1088-1VO5-22270 Param Type = c disasterarea=Lambaharisingh Param Type = c action=Create Param Type = n bhamashahstatus=0 Param Type = n flag=0 Param Type = n appamt=0 Param Type = n viewcode=0 Param Type = c markto=Patwari Param Type = c marktouser=30315 Param Type = n sanctionflag=0 Param Type = c patwar=Lamba Hari Singh Param Type = c chkdupsso=HousingASHOK.VAISHNAV12345 Param Type = n disastervillage=28289 Param Type = c regno=AR/TONK/2025/125889 Param Type = n dist=22 Param Type = n scheme=17032000000141 Param Type = n calamity=12558000000000 Param Type = n mobileno=8104455011 Param Type = c gender=Female Param Type = c afhname=devi Param Type = c applicantname=Rampyari Khatik Param Type = n age=53 Param Type = c dob=01/01/1972 00:00:00 Param Type = n quantity=15 Param Type = n categorys=17045000000010 Param Type = n assistamt=97500 Param Type = n subcategory=17075000000018 Param Type = n disastertehsil=205 Param Type = c disasterrural=Rural Param Type = c houseno=0 Param Type = n disasterdist=22 Param Type = n disasterpansamiti=193 Param Type = n disastergrampanchayat=6686 Param Type = n disastercity=0 Param Type = n disasterward=0 Param Type = c streetname=kekri road,Lambaharisingh Param Type = n city=0 Param Type = n ward=0 Param Type = n tehsil=205 Param Type = c ruralurban=Rural Param Type = n grampanchayat=6686 Param Type = n village=28289 Param Type = n pansamiti=193 insert into CM_ACTIVITYFORM (cm_activityformid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,ifsc,bhamashah,memberid,ssoid,accountno,disasteraddress,bankname,branchname,disasdate,disasterdetail,disasterstreetname,disasterflatno,janaadhaarno,ackno,disasterarea,aadhaarno,action,rejreason,samvat,farcat,bhamashahstatus,bhamashahremark,flag,appamt,viewcode,remark,markto,marktouser,sanctionflag,sanctionno,patwar,chkdupsso,disastervillage,regno,dist,scheme,calamity,mobileno,email,gender,category,afhname,applicantname,age,dob,quantity,categorys,assistamt,subcategory,disastertehsil,disasterrural,houseno,disasterdist,disasterpansamiti,disastergrampanchayat,disastercity,disasterward,streetname,city,ward,tehsil,ruralurban,grampanchayat,village,pansamiti) values (:cm_activityformid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:ifsc,null,:memberid,:ssoid,:accountno,:disasteraddress,:bankname,:branchname,to_date(:disasdate,'dd/mm/yyyy hh24:mi:ss'),:disasterdetail,:disasterstreetname,:disasterflatno,:janaadhaarno,:ackno,:disasterarea,null,:action,null,null,null,:bhamashahstatus,null,:flag,:appamt,:viewcode,null,:markto,:marktouser,:sanctionflag,null,:patwar,:chkdupsso,:disastervillage,:regno,:dist,:scheme,:calamity,:mobileno,null,:gender,null,:afhname,:applicantname,:age,to_date(:dob,'dd/mm/yyyy hh24:mi:ss'),:quantity,:categorys,:assistamt,:subcategory,:disastertehsil,:disasterrural,:houseno,:disasterdist,:disasterpansamiti,:disastergrampanchayat,:disastercity,:disasterward,:streetname,:city,:ward,:tehsil,:ruralurban,:grampanchayat,:village,:pansamiti) Time elapsed for insert/update = 3968649252241 >>Executing genmaps >>Posting from tscaf to tacwk >>Mapping Mapped moduletype Row = 1 value = Housing idvalue 0 Mapped entrytype Row = 1 value = Relief Assistance Form idvalue 0 Mapped tablename Row = 1 value = cm_activityform idvalue 0 Mapped recid Row = 1 value = 19346000000200 idvalue 0 Mapped viewcode Row = 1 value = 0 idvalue 0 Mapped actionbyrole Row = 1 value = mobileuser idvalue 0 Mapped actionbyuser Row = 1 value = mobileuser1 idvalue 0 Mapped action Row = 1 value = Create idvalue 0 Mapped nextrole Row = 1 value = Patwari idvalue 0 Mapped nextuser Row = 1 value = 30315 idvalue 0 Mapped remark Row = 1 value = idvalue 0 Mapped systemremark Row = 1 value = idvalue 0 Mapped appamt Row = 1 value = 0 idvalue 0 >>Validating tacwk >>Frame No 1 moduletype = Housing entrytype = Relief Assistance Form tablename = cm_activityform recid = 19346000000200 viewcode = 0 actionbyrole = mobileuser actionbyuser = mobileuser1 action = Create nextrole = Patwari nextuser = 30315 remark = systemremark = appamt = 0 appamt after validation = 0.00 >>Writing to tables tacwk Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tacwk' Time elapsed = 8 Saving to table TRN_ACTIONHISTORY select * from TRN_ACTIONHISTORY where TRN_ACTIONHISTORYid=0 Time elapsed = 11 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 9 RecordId = 19346000000201 MapName tscaf1 SourceId 19346000000200 Select sysdate as sdt from dual Time elapsed = 10 Select sysdate as sdt from dual Time elapsed = 10 nextuser = 30315 nextrole = Patwari action = Create appamt = 0.00 systemremark = remark = actionbyuser = mobileuser1 tablename = cm_activityform entrytype = Relief Assistance Form moduletype = Housing actionbyrole = mobileuser viewcode = 0 recid = 19346000000200 Posting record Param Type = n trn_actionhistoryid=19346000000201 Param Type = c mapname=tscaf1 Param Type = n sourceid=19346000000200 Param Type = c cancel=F Param Type = c createdby=mobileuser1 Param Type = c createdon=03/10/2025 10:34:28 Param Type = c username=mobileuser1 Param Type = c modifiedon=03/10/2025 10:34:28 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c nextuser=30315 Param Type = c nextrole=Patwari Param Type = c action=Create Param Type = n appamt=0 Param Type = c actionbyuser=mobileuser1 Param Type = c tablename=cm_activityform Param Type = c entrytype=Relief Assistance Form Param Type = c moduletype=Housing Param Type = c actionbyrole=mobileuser Param Type = c viewcode=0 Param Type = c recid=19346000000200 insert into TRN_ACTIONHISTORY (trn_actionhistoryid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,nextuser,nextrole,action,appamt,systemremark,remark,actionbyuser,tablename,entrytype,moduletype,actionbyrole,viewcode,recid) values (:trn_actionhistoryid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:nextuser,:nextrole,:action,:appamt,null,null,:actionbyuser,:tablename,:entrytype,:moduletype,:actionbyrole,:viewcode,:recid) Time elapsed for Gen Map = 3968649252942 Time elapsed for MD Map = 3968649252948 Time elapsed for Save History = 3968649252955 Time elapsed for Save Attachment = 3968649252962 Time elapsed for After Save WF Exec = 3968649252970 Transaction commited Result : {"message":[{"msg":"Relief Assistance Form Saved","Registration No.":"AR/TONK/2025/125889","recordid":"19346000000200"}]} 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/10/2025 10:34:04 Param Type = c callfinished=03/10/2025 10:34:13 Param Type = c structname=tscaf Param Type = n recordid=0 Param Type = c servicename=Saving data Param Type = c serviceresult=success Param Type = n timetaken=8627 Param Type = n dbtimetaken=3467 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