Start Time : 12/10/2025 11:28:40 AM
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 = 47
SELECT * FROM AXPROPS WHERE NAME = 'app'

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

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

Time elapsed = 16
delete from connections where sessionid = '10sb1b55flrdnrud2sqfsp55'

Time elapsed = 187
delete from axtranscontrol where sessionid = '10sb1b55flrdnrud2sqfsp55'

Time elapsed = 15
Saving logout
Param Type = c
logouttime=10/12/2025 11:28:42
Param Type = c
nologout=F
update axaudit set logouttime=to_date(:logouttime,'dd/mm/yyyy hh24:mi:ss'),nologout=:nologout
 where sessionid='10sb1b55flrdnrud2sqfsp55'

Closing connection
# 1#Saving to log
Param Type = c
sessionid=10sb1b55flrdnrud2sqfsp55
Param Type = c
calledon=10/12/2025 11:28:40
Param Type = c
callfinished=10/12/2025 11:28:41
Param Type = n
recordid=0
Param Type = c
servicename=Logout
Param Type = c
serviceresult=success
Param Type = n
timetaken=719
Param Type = n
dbtimetaken=500
Param Type = n
dbconnectiontime=172
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