Start Time : 12/10/2025 11:28:34 AM Loading iview.aspx before post back (get and set parameters) Get Iview Parameters Call to GetParams Web Service ASB XE3/32/64 DLL running [Compiled on 19/06/2015 12:09:20 AM] [File Version : 9.5.0.0]] [Product Version : 9.0][64 Bit - WebFix2] DB Manager created Current ASB DLL folder : E:\website\dmis\dmisscripts Connecting to project Dbx name = dmis ConnectionName = oracle DriverName = oracle GetDriverFunc = getSQLDriverORACLE LibraryName = E:\website\dmis\dmisscripts\dbxora.dll VendorLib = E:\website\dmis\dmisscripts\OCI.dll Database = dmis User_Name = dmis Select sysdate as sdt from dual Time elapsed = 15 SELECT * FROM AXPROPS WHERE NAME = 'app' Time elapsed = 16 SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2 Time elapsed = 0 Connection to DB Successful Executing GetParams webservice ------------------------------ Received XML + dbOracledbxdmisdmisdc1d71bbb5c4d2a5e936db79ef10c19fdmisdd/mm/yyyy hh24:mi:ssadminlocaldmisactivedmis\100000falseselect ausername ||'-'|| ( usertype ) auname from axusers where username in (:username)tBlackfalse Validating Session select * from connections where sessionid = :sesid Time elapsed = 16 Application Variables and Values ax_evalcopy=T rolename=Patwari responsibilies=Patwari usrpatid=4525 urole=Patwari usrofcnm=ALL usrdeptnm=ALL usrofc=0 usrdept=0 usrdistid=14 usrpatnm=Barnel usrilrnm=Khatoo Kalan usrtehnm=Jayal usrdistnm=Nagaur usrpatwar=Barnel usrrole=Patwari User Group Patwari User Roles Patwari Validate Session completed Sql : select props from iviews where lower(name)= :name order by blobno Paramval : ifilvd ParamTYpe : c Param List : name select props from iviews where lower(name)= :name order by blobno Time elapsed = 32 Step5 CDS Param Name : username CDS Param Type : c CDS Param Value : 28661 username=28661 SELECT sessionid FROM trn_girdawarivillage x1, vw_geodtl x2, vw_usrdtl x3, vw_seasonclose x4 WHERE X1.VILLID = X2.VILLID AND X2.PATWARID = X3.PATID AND X3.USERROLE = 'Patwari' AND x3.usrnm = :username AND (X4.DMDIST = x3.DISTNM OR X4.DMDIST = 'ALL' OR X3.DISTNM = 'ALL') AND (X4.DMGTEH = x3.TEHNM OR X4.DMGTEH = 'ALL' OR X3.TEHNM = 'ALL') AND nvl(x4.uploading,'No') = 'No' AND X4.ISSEASONCLOSE='F' AND X1.sessionid = X4.SEASONCODE GROUP BY sessionid ORDER BY sessionid username=28661 Time elapsed = 47 CDS Record Count : 2 CDS Param Name : season CDS Param Type : c CDS Param Value : season= select DMGTYPE from trn_reqdmgareahdr where UPPER(sessionid) = :season season= Time elapsed = 0 Evaluating selectcalamity Error while evaluating - selectcalamity is not defined Param Name : dmgtype Param Type : C Param Value : CDS Param Name : season CDS Param Type : c CDS Param Value : season= select DMGTYPE from trn_reqdmgareahdr where UPPER(sessionid) = :season season= Time elapsed = 15 CDS Param Name : username CDS Param Type : c CDS Param Value : 28661 username=28661 Select DISTNM||'>>'||Tehnm||'>>'||PATNM location from vw_usrdtl where usrnm = :username username=28661 Time elapsed = 31 Param Name : loc Param Value : Nagaur>>Jayal>>Barnel CDS Param Name : season CDS Param Type : c CDS Param Value : season= select ' Season Code - '||UPPER(SESSIONID)||' ( '||to_char(startdate,'dd-MM-rrrr')||' To '||to_char(enddate,'dd-MM-rrrr')||' ) - '||DMGTYPE filterstr from trn_reqdmgareahdr a where UPPER(SESSIONID) = :season season= Time elapsed = 15 CDS Param Name : username CDS Param Type : c CDS Param Value : 28661 username=28661 Select patid from VW_USRDTL where usrnm = :username username=28661 Time elapsed = 31 Param Name : ppatid Param Value : 4525 Result :Task1seasonSeasonCharacterFalsefalse0TrueFalseSelect~~selectcalamity,dmgtype,filtertext~~2079-RABI2082-KHARIFselectcalamityselectcalamityCharacterFalsetrue0TrueFalseAcceptdmgtypeCalamityCharacterFalseselectcalamityfalse0TrueFalseSelectloclocationCharacterFalsetrue0TrueFalseAcceptfiltertextfiltertextCharacterFalsetrue0TrueFalseAcceptTask1ppatidppatidNumericFalsetrue0FalseFalseAccept GetParams webservice completed Closing connection # 1#Saving to log Param Type = c sessionid=10sb1b55flrdnrud2sqfsp55 Param Type = c username=28661 Param Type = c calledon=10/12/2025 11:28:34 Param Type = c callfinished=10/12/2025 11:28:39 Param Type = n recordid=0 Param Type = c servicename=Getting IView Params Param Type = c serviceresult=success Param Type = n timetaken=4782 Param Type = n dbtimetaken=1062 insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken) values (:sessionid,:username,to_date(:calledon,'dd/mm/yyyy hh24:mi:ss'),to_date(:callfinished,'dd/mm/yyyy hh24:mi:ss'),null,:recordid,:servicename,:serviceresult,:timetaken,:dbtimetaken) Freeing AxProvider Resources Freeing DbManager Resources Loading and setting parameters components Loading and setting parameters components completed End Time : 12/10/2025 11:28:39 AM