Start Time : 12/11/2025 3:20:25 PM
Getting Menu
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 = 0
Connection to DB Successful
Executing GetMultiMenu webservice
---------------------------------
Recevied 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=default
responsibilies=default
usrpatid=0
urole=default
usrofcnm=ALL
usrdeptnm=ALL
usrofc=0
usrdept=0
usrdistid=0
usrpatnm=ALL
usrilrnm=ALL
usrtehnm=ALL
usrdistnm=ALL
usrpatwar=
usrrole=default
User Group default
User Roles default
Validate Session completed
select name,caption,type,visible,img,parent,levelno,props,pagetype,intview from axpages where blobno=1 and lower(nvl(webenable,'t')) ='t' and lower(nvl(pagetype,'s')) <> 'stem' order by ordno ,levelno
Time elapsed = 0
Result :
GetMultiMenu webservice completed
Closing connection
# 1#Saving to log
Param Type = c
sessionid=31nj5zu0rizi4eepbieitg55
Param Type = c
username=admin
Param Type = c
calledon=11/12/2025 15:20:25
Param Type = c
callfinished=11/12/2025 15:20:25
Param Type = n
recordid=0
Param Type = c
servicename=Get menu - Multi levels
Param Type = c
serviceresult=success
Param Type = n
timetaken=719
Param Type = n
dbtimetaken=157
Param Type = n
dbconnectiontime=110
insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,dbconnectiontime) 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,:dbconnectiontime)
Axpert Log Error msg : ORA-00904: "DBCONNECTIONTIME": invalid identifier
Freeing AxProvider Resources
Freeing DbManager Resources