Start Time : 12/9/2025 10:52:50 PM
Calling Signout ws
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 = 15
SELECT * FROM AXPROPS WHERE NAME = 'app'

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

Time elapsed = 15
Connection to DB Successful 
select username from connections where username = ''

Time elapsed = 0
delete from connections where sessionid = '2544lr45tuwi0l2puae4ry55'

Time elapsed = 78
delete from axtranscontrol where sessionid = '2544lr45tuwi0l2puae4ry55'

Time elapsed = 0
Saving logout
Param Type = c
logouttime=09/12/2025 22:52:50
Param Type = c
nologout=F
update axaudit set logouttime=to_date(:logouttime,'dd/mm/yyyy hh24:mi:ss'),nologout=:nologout
 where sessionid='2544lr45tuwi0l2puae4ry55'

Closing connection
# 1#Saving to log
Param Type = c
sessionid=2544lr45tuwi0l2puae4ry55
Param Type = c
calledon=09/12/2025 22:52:50
Param Type = c
callfinished=09/12/2025 22:52:50
Param Type = n
recordid=0
Param Type = c
servicename=Logout
Param Type = c
serviceresult=success
Param Type = n
timetaken=391
Param Type = n
dbtimetaken=233
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