Start Time : 12/9/2025 6:32:04 PM
Getchioces call
ASB XE3/32/64 DLL running
[Compiled on 02/04/2020 5:23:32 PM] [File Version : 9.6.0.0]] [Product Version : 9.0][64 Bit-WebFix-dbtime-WebFix1]
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 = 16
SELECT * FROM AXPROPS WHERE NAME = 'app'

Time elapsed = 0
SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2

Time elapsed = 0
Connection to DB Successful 

Executing GetChoices webservice
-------------------------------
select a1.username||'$'||(case when a1.usertype in (10265000000000,10265000000001,13117000000000,12421000000000,12421000000001) then 1 when a1.usertype=12494000000000 then 1 else 0 end) as username,(case when A5.AXUSERGROUP='default' then 'admin' ELSE A5.AXUSERGROUP END|| ' || ' ||case when A3.DISTRICTNAME is null then 'ALL' else A3.DISTRICTNAME end|| ' || ' ||case when A4.TEHSILNAME is null then 'ALL' else A4.TEHSILNAME end|| ' || '||case when A7.PATWAR_ENG is null then 'ALL' else A7.PATWAR_ENG end ) usr from axusers a1,axuserdistrictdtl a2, cm_district a3,cm_tehsil a4, AXUSERLEVELGROUPS a5,CM_RVNU_ILR a6, CM_RVNU_PATWAR a7 where A1.AXUSERSID = A5.AXUSERSID and A1.AXUSERSID = A2.AXUSERSID(+) and A2.DISTRICT = A3.CM_DISTRICTID(+) and A2.PSAMITI = A4.CM_TEHSILID(+) and a2.ILR = a6.CM_RVNU_ILRID(+) and a2.patwar = a7.cm_rvnu_patwarid(+) and a1.active='T' and lower(a1.ssoid) = 'shimla.gurjar6' 
Time elapsed = 31
CDS Record Count : 1
CDS Record Count : 1
Result : <sqlresultset><response><row><USERNAME>15991$1</USERNAME><USR>Patwari || Bhilwara || Bijoliya || Bhoptpura</USR></row></response></sqlresultset>
GetChoices webservice completed


Closing connection - direct call
Closing connection
# 1#Saving to log
Param Type = c
sessionid=2li3vjeah2qpvs55aefygrfp
Param Type = c
calledon=09/12/2025 18:32:04
Param Type = c
callfinished=09/12/2025 18:32:04
Param Type = n
recordid=0
Param Type = c
servicename=Fetching SQL result
Param Type = c
serviceresult=success
Param Type = n
timetaken=329
Param Type = n
dbtimetaken=125
Param Type = n
dbconnectiontime=78
insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,dbconnectiontime) values (:sessionid,null,to_date(:calledon,'dd/mm/yyyy hh24:mi:ss'),to_date(:callfinished,'dd/mm/yyyy hh24:mi:ss'),null,:recordid,:servicename,:serviceresult,:timetaken,:dbtimetaken,:dbconnectiontime)

Axpert Log Error msg : ORA-00904: "DBCONNECTIONTIME": invalid identifier
Freeing AxProvider Resources
Freeing DbManager Resources
Getchioces call
ASB XE3/32/64 DLL running
[Compiled on 02/04/2020 5:23:32 PM] [File Version : 9.6.0.0]] [Product Version : 9.0][64 Bit-WebFix-dbtime-WebFix1]
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 = 0
SELECT * FROM AXPROPS WHERE NAME = 'app'

Time elapsed = 0
SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2

Time elapsed = 15
Connection to DB Successful 

Executing GetChoices webservice
-------------------------------
select a1.username||'$'||(case when a1.usertype in (10265000000000,10265000000001,13117000000000,12421000000000,12421000000001) then 1 when a1.usertype=12494000000000 then 1 else 0 end) as username,(case when A5.AXUSERGROUP='default' then 'admin' ELSE A5.AXUSERGROUP END|| ' || ' ||case when A3.DISTRICTNAME is null then 'ALL' else A3.DISTRICTNAME end|| ' || ' ||case when A4.TEHSILNAME is null then 'ALL' else A4.TEHSILNAME end|| ' || '||case when A7.PATWAR_ENG is null then 'ALL' else A7.PATWAR_ENG end ) usr from axusers a1,axuserdistrictdtl a2, cm_district a3,cm_tehsil a4, AXUSERLEVELGROUPS a5,CM_RVNU_ILR a6, CM_RVNU_PATWAR a7 where A1.AXUSERSID = A5.AXUSERSID and A1.AXUSERSID = A2.AXUSERSID(+) and A2.DISTRICT = A3.CM_DISTRICTID(+) and A2.PSAMITI = A4.CM_TEHSILID(+) and a2.ILR = a6.CM_RVNU_ILRID(+) and a2.patwar = a7.cm_rvnu_patwarid(+) and a1.active='T' and lower(a1.ssoid) = 'shimla.gurjar6' 
Time elapsed = 31
CDS Record Count : 1
CDS Record Count : 1
Result : <sqlresultset><response><row><USERNAME>15991$1</USERNAME><USR>Patwari || Bhilwara || Bijoliya || Bhoptpura</USR></row></response></sqlresultset>
GetChoices webservice completed


Closing connection - direct call
Closing connection
# 1#Saving to log
Param Type = c
sessionid=2li3vjeah2qpvs55aefygrfp
Param Type = c
calledon=09/12/2025 18:32:08
Param Type = c
callfinished=09/12/2025 18:32:09
Param Type = n
recordid=0
Param Type = c
servicename=Fetching SQL result
Param Type = c
serviceresult=success
Param Type = n
timetaken=313
Param Type = n
dbtimetaken=139
Param Type = n
dbconnectiontime=93
insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,dbconnectiontime) values (:sessionid,null,to_date(:calledon,'dd/mm/yyyy hh24:mi:ss'),to_date(:callfinished,'dd/mm/yyyy hh24:mi:ss'),null,:recordid,:servicename,:serviceresult,:timetaken,:dbtimetaken,:dbconnectiontime)

Axpert Log Error msg : ORA-00904: "DBCONNECTIONTIME": invalid identifier
Freeing AxProvider Resources
Freeing DbManager Resources