Start Time : 27/06/2024 19:13:59
Getting Menu
ASB XE3/32/64 DLL running
[Compiled on 29/05/2024 10:32:00 AM] [File Version : 11.3.0.0]] [Product Version : 11.3][64Bit(010324)]
DB Manager created
Current ASB DLL folder : E:\Axpert113\Axpert Web\AxpertWebScripts
Connecting to project : trustlineuat
Connecting to project found : -1
Session key validation
Session key validation completed
Db Manager Connection starts
Db Manager Connection XML receied : dbPostgredbxlocalhosttrustlineuat\trustlineuat
creating connection starts...
creating connection end...
creating date xds...
creating date xds end...
PostGreConnect starts...
PostGreConnect ends...
db user : trustlineuat
Select now() as sdt
Time elapsed = 0
select props from axprops where lower(name)='app' order by blobno
uXDS\dopen\ Check intransaction
Time elapsed = 16
axprops xml = images\Agile-TrustLine-UAT
INR1FFF030000FF
SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2
uXDS\dopen\ Check intransaction
Time elapsed = 0
Db Manager Connection ends
Connection to DB Successful
Executing GetMultiMenu webservice
---------------------------------
Recevied XML : dbPostgredbxlocalhosttrustlineuat\trustlineuattrustlineuatdd/mm/yyyy hh24:mi:ssadminlocalBlackENGLISHtruet\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir\\10.16.248.2\UAT_Attachment\UAT_TLReports\\10.16.248.2\UAT_Attachment\UAT_TLBusinessFsomatcs1@gmail.comtrustlineclientclientFgt2oa5zbh0fwj2di3iagg2bsclient~100trustlineuattrustlineuat0trustlineclienthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuat*~~9867~25~0~0~1~R~false~RccccncccccE:\Axpert113\Axpert Web\AxpertWebScripts
Registering app/user variables for the session
Registering DBMem variables
Registering DBMem variables completed
Registering ConfigParam variables
Registering ConfigParam variables completed
auth_path=E:\Axpert113\Axpert Web\AxpertWebScripts
axp_clientlocale=*
axp_appschema=trustlineuat
axp_devschema=trustlineuataxdef
axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/
axp_connectionname=trustlineuat
sesid=gt2oa5zbh0fwj2di3iagg2bs
ax_evalcopy=F
rolename=client
responsibilies=trustlineclient
millions=F
axpimageserver=
axglo_hide=
axp_displaytext=
axglo_user=
fromuserlogin=
axglo_recordid=
axpimagepath=
AxpServerPath=\\10.16.248.2\UAT_Attachment\UAT_TLBusiness
AxpAttachmentPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports
AxpDbDirPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir
LStr : ~~9867~25~0~0~1~R~false~R
LReg Type : R
User Group client
User Roles trustlineclient
Registering app/user variables for the session completed
select sessionid from connections where sessionid = :sesid
uXDS\dopen\ Check intransaction
Time elapsed = 0
select name,caption,type,visible,img,parent,levelno,props,pagetype,intview,icon from axpages where blobno=1 and lower(coalesce(webenable,'t')) ='t' and lower(coalesce(pagetype,'s')) <> 'stem' and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('trustlineclient') and stype = 'p' ) order by ordno ,levelno
uXDS\dopen\ Check intransaction
Time elapsed = 16
select * from (select b.name,b.caption,b.type,b.visible,b.img,b.parent,b.ordno,b.levelno,b.props,b.pagetype,b.intview,b.icon from ( select name,caption,type,visible,img,parent,ordno,levelno,pagetype,intview,icon from axpages where blobno=1 and lower(coalesce(webenable,'t')) ='t' and lower(coalesce(pagetype,'s')) <> 'stem' and name in ( 'Head246327','','PageIvcldocume','HP1704042003246' ) ) a , axpages b where a.name = b.name order by b.ordno, b.levelno ) c
uXDS\dopen\ Check intransaction
Time elapsed = 0
Name : Head246327
Name : PageIvcldocume
Name : HP1704042003246
select count(*) as cnt from axhomeconfig
uXDS\dopen\ Check intransaction
Time elapsed = 0
Getting Role-Wise Card names...
Executing GetRoleWiseCardNames
select axp_cardsid,accessstring from axp_cards where inhomepage = 'T' order by orderno
Time elapsed = 0
Executing GetRoleWiseCardNames completed..
Getting Role-Wise Card names completed...
Getting Card details...
Executing GetFullCardDetails
select axp_cardsid,cardname,cardtype,charttype,chartjson,cardicon,pagename,pagedesc,cardbgclr,width,height,cachedata,autorefresh,sql_editor_cardsql as cardsql,orderno,accessstring,htransid,htype,hcaption,axpfile_imgcard,html_editor_card,calendarstransid,exp_editor_buttons from axp_cards where inhomepage = 'T' and ( lower(accessstring) like '%,client,%' ) order by orderno
Time elapsed = 16
Executing GetFullCardDetails completed..
Getting Card details completed...
Result :redeemmaterial-icons
Cards Result :{"result":[{"axp_cardsid":"1638770000000","cardname":"Announcement ","cardtype":"html","charttype":"","chartjson":"{\"attributes\":{\"cck\":\"\",\"shwLgnd\":,\"xAxisL\":\"\",\"yAxisL\":\"\",\"gradClrChart\":,\"shwChartVal\":,\"threeD\":\"remove\",\"enableSlick\":,\"numbSym\":}}","cardicon":"","pagename":"","pagedesc":"","cardbgclr":"","width":"col-md-12","height":"160px","cachedata":"true","autorefresh":"30","cardsql":"","orderno":"1","accessstring":",client,default,trustlineadmin,trustlineapprover,","htransid":"","htype":"","hcaption":"","axpfile_imgcard":"","html_editor_card":"
\r\n \r\n
\r\n\r\n
\r\n\r\n\r\n ","calendarstransid":"","exp_editor_buttons":""},{"axp_cardsid":"1638220000000","cardname":"My Funds","cardtype":"html","charttype":"","chartjson":"{\"attributes\":{\"cck\":\"\",\"shwLgnd\":,\"xAxisL\":\"\",\"yAxisL\":\"\",\"gradClrChart\":,\"shwChartVal\":,\"threeD\":\"remove\",\"enableSlick\":,\"numbSym\":}}","cardicon":"","pagename":"","pagedesc":"","cardbgclr":"","width":"col-md-3","height":"400px","cachedata":"true","autorefresh":"30","cardsql":"","orderno":"2","accessstring":",client,default,trustlineadmin,trustlineapprover,","htransid":"","htype":"","hcaption":"","axpfile_imgcard":"","html_editor_card":"
\r\n \r\n
\r\n
\r\n \r\n \r\n \r\n\r\n \r\n
\r\n \r\n
\r\n \r\n
\r\n
\r\n\r\n","calendarstransid":"","exp_editor_buttons":""},{"axp_cardsid":"1637880000000","cardname":"List of Accounts","cardtype":"html","charttype":"","chartjson":"{\"attributes\":{\"cck\":\"\",\"shwLgnd\":,\"xAxisL\":\"\",\"yAxisL\":\"\",\"gradClrChart\":,\"shwChartVal\":,\"threeD\":\"remove\",\"enableSlick\":,\"numbSym\":}}","cardicon":"","pagename":"","pagedesc":"","cardbgclr":"","width":"col-md-3","height":"400px","cachedata":"true","autorefresh":"30","cardsql":"","orderno":"3","accessstring":",client,default,trustlineadmin,trustlineapprover,","htransid":"","htype":"","hcaption":"","axpfile_imgcard":"","html_editor_card":"
\r\n \r\n\r\n
\r\n\r\n
\r\n \r\n \r\n \r\n\r\n \r\n
\r\n\r\n\r\n\r\n
\r\n \r\n
\r\n \r\n
\r\n
\r\n\r\n","calendarstransid":"","exp_editor_buttons":""},{"axp_cardsid":"1757010000000","cardname":"Biz Notes","cardtype":"html","charttype":"","chartjson":"{\"attributes\":{\"cck\":\"\",\"shwLgnd\":,\"xAxisL\":\"\",\"yAxisL\":\"\",\"gradClrChart\":,\"shwChartVal\":,\"threeD\":\"remove\",\"enableSlick\":,\"numbSym\":}}","cardicon":"","pagename":"","pagedesc":"","cardbgclr":"","width":"col-md-3","height":"400px","cachedata":"true","autorefresh":"30","cardsql":"","orderno":"4","accessstring":",admin,client,default,trustlineadmin,trustlineapprover,","htransid":"","htype":"","hcaption":"","axpfile_imgcard":"","html_editor_card":"
\r\n \r\n
\r\n
\r\n \r\n \r\n \r\n\r\n \r\n
\r\n\r\n
\r\n \r\n
\r\n \r\n
\r\n
\r\n\r\n","calendarstransid":"","exp_editor_buttons":""},{"axp_cardsid":"1638440000000","cardname":"Latest Videos","cardtype":"html","charttype":"","chartjson":"{\"attributes\":{\"cck\":\"\",\"shwLgnd\":,\"xAxisL\":\"\",\"yAxisL\":\"\",\"gradClrChart\":,\"shwChartVal\":,\"threeD\":\"remove\",\"enableSlick\":,\"numbSym\":}}","cardicon":"","pagename":"","pagedesc":"","cardbgclr":"","width":"col-md-3","height":"400px","cachedata":"true","autorefresh":"30","cardsql":"","orderno":"5","accessstring":",client,default,trustlineadmin,trustlineapprover,","htransid":"","htype":"","hcaption":"","axpfile_imgcard":"","html_editor_card":"
\r\n \r\n
\r\n\r\n
\r\n \r\n \r\n \r\n\r\n \r\n\r\n\r\n
\r\n\r\n\r\n
\r\n \r\n \r\n\r\n \r\n\r\n \r\n
\r\n \r\n
\r\n
\r\n\r\n","calendarstransid":"","exp_editor_buttons":""},{"axp_cardsid":"1635330000000","cardname":"Latest Articles","cardtype":"html","charttype":"","chartjson":"{\"attributes\":{\"cck\":\"\",\"shwLgnd\":,\"xAxisL\":\"\",\"yAxisL\":\"\",\"gradClrChart\":,\"shwChartVal\":,\"threeD\":\"remove\",\"enableSlick\":,\"numbSym\":}}","cardicon":"","pagename":"","pagedesc":"","cardbgclr":"","width":"col-md-3","height":"400px","cachedata":"true","autorefresh":"30","cardsql":"","orderno":"6","accessstring":",client,default,trustlineadmin,trustlineapprover,","htransid":"","htype":"","hcaption":"","axpfile_imgcard":"","html_editor_card":"
\r\n \r\n
\r\n
\r\n \r\n \r\n \r\n\r\n \r\n
\r\n\r\n
\r\n \r\n
\r\n \r\n
\r\n
\r\n\r\n","calendarstransid":"","exp_editor_buttons":""}]}
GetMultiMenu webservice completed
# 1#Saving to log
insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('gt2oa5zbh0fwj2di3iagg2bs','somatcs1@gmail.com',to_timestamp('27/06/2024 19:13:59','dd/mm/yyyy hh24:mi:ss'),to_timestamp('27/06/2024 19:14:00','dd/mm/yyyy hh24:mi:ss'),null,0,'Get menu - Multi levels','success',266,48,0)
uXDS\pinsert\ Check intransaction
Closing connection
Freeing AxProvider Resources
Freeing DbManager Resources
Destroying Default xds in db manager
Destroying connect object
Disconnecting from db trustlineuat
Keep Connection setting false
Disconnecting...
Disconnected...
Dbx name =
ConnectionName =
DriverName =
GetDriverFunc =
LibraryName =
VendorLib =
Successfully disconnected from db trustlineuat
Destroyed connect object
Destroying GF