Start Time : 12/11/2025 3:20:26 PM
GetChoice
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 = 16
Connection to DB Successful 

Executing GetChoices webservice
-------------------------------
Validating Session
select * from connections where sessionid = :sesid

Time elapsed = 0
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 parentPageName,iconName  from Axiconmenu 
Time elapsed = 15
CDS Record Count : 21
Result : <sqlresultset axpapp="dmis" sessionid="31nj5zu0rizi4eepbieitg55" trace="E:\website\dmis\dmisscripts\Log\31nj5zu0rizi4eepbieitg55\GetChoice.txt"><response><row><PARENTPAGENAME>masters</PARENTPAGENAME><ICONNAME>mas</ICONNAME></row><row><PARENTPAGENAME>dmrd masters</PARENTPAGENAME><ICONNAME>dms</ICONNAME></row><row><PARENTPAGENAME>mobile services</PARENTPAGENAME><ICONNAME>pws</ICONNAME></row><row><PARENTPAGENAME>mass communication</PARENTPAGENAME><ICONNAME>mc</ICONNAME></row><row><PARENTPAGENAME>event</PARENTPAGENAME><ICONNAME>inc</ICONNAME></row><row><PARENTPAGENAME>banker cheque</PARENTPAGENAME><ICONNAME>icon-edit</ICONNAME></row><row><PARENTPAGENAME>other relief assistance</PARENTPAGENAME><ICONNAME>ora</ICONNAME></row><row><PARENTPAGENAME>manual bill</PARENTPAGENAME><ICONNAME>mb</ICONNAME></row><row><PARENTPAGENAME>reports</PARENTPAGENAME><ICONNAME>rpt</ICONNAME></row><row><PARENTPAGENAME>task</PARENTPAGENAME><ICONNAME>icon-exclamation-sign</ICONNAME></row><row><PARENTPAGENAME>cattle camp relief</PARENTPAGENAME><ICONNAME>ccr</ICONNAME></row><row><PARENTPAGENAME>fodder scheme</PARENTPAGENAME><ICONNAME>fd</ICONNAME></row><row><PARENTPAGENAME>dbt</PARENTPAGENAME><ICONNAME>dbt</ICONNAME></row><row><PARENTPAGENAME>agriculture relief</PARENTPAGENAME><ICONNAME>ar</ICONNAME></row><row><PARENTPAGENAME>inventory managment</PARENTPAGENAME><ICONNAME>inv</ICONNAME></row><row><PARENTPAGENAME>contact directory</PARENTPAGENAME><ICONNAME>cd</ICONNAME></row><row><PARENTPAGENAME>district disaster profile</PARENTPAGENAME><ICONNAME>ddp</ICONNAME></row><row><PARENTPAGENAME>user manuals</PARENTPAGENAME><ICONNAME>um</ICONNAME></row><row><PARENTPAGENAME>dmrd-request</PARENTPAGENAME><ICONNAME>dmr</ICONNAME></row><row><PARENTPAGENAME>ert- registration</PARENTPAGENAME><ICONNAME>ert</ICONNAME></row><row><PARENTPAGENAME>demand</PARENTPAGENAME><ICONNAME>dmg</ICONNAME></row></response></sqlresultset>
GetChoices 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:26
Param Type = c
callfinished=11/12/2025 15:20:26
Param Type = n
recordid=0
Param Type = c
servicename=Fetching SQL result
Param Type = c
serviceresult=success
Param Type = n
timetaken=437
Param Type = n
dbtimetaken=171
Param Type = n
dbconnectiontime=109
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