Start Time : 12/08/2024 15:02:26 Getting Menu ASB XE3/32/64 DLL running [Compiled on 31/07/2024 1:02:00 PM] [File Version : 11.3.0.0]] [Product Version : 11.3][64Bit(260724)] 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 = 1 select props from axprops where lower(name)='app' order by blobno uXDS\dopen\ Check intransaction Time elapsed = 3 axprops xml = images\Agile-TrustLine-UATINR1FFFsmtp.office365.com587portalneo@trustlineindia.com01trust@123*100000FF SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2 uXDS\dopen\ Check intransaction Time elapsed = 2 Db Manager Connection ends Connection to DB Successful Executing GetMultiMenu webservice --------------------------------- Recevied XML : dbPostgredbxlocalhosttrustlineuat\trustlineuattrustlineuataxdefdd/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_TLBusiness1026110000000FsomatrustlineadmintrustlineadminFpoldytivpp1u221enww3n0xytrustlineadmin~100trustlineuattrustlineuat0trustlineadminhttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*8/12/2024 3:02:23 pm*10195216168~~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=en-us*asia/calcutta^english*8/12/2024 3:02:23 pm*10195216168 axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=poldytivpp1u221enww3n0xy ax_evalcopy=F rolename=trustlineadmin responsibilies=trustlineadmin millions=F axpimageserver= axglo_hide= axp_displaytext= axglo_user= fromuserlogin= axglo_recordid=1026110000000 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 trustlineadmin User Roles trustlineadmin Registering app/user variables for the session completed select sessionid from connections where sessionid = :sesid uXDS\dopen\ Check intransaction Time elapsed = 3 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 ('trustlineadmin') and stype = 'p' ) order by ordno ,levelno uXDS\dopen\ Check intransaction Time elapsed = 6 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 ( 'Head19','','Head16','PageIvaxfinyrs','PageIvtodolist','Head22','PageIvaxroles','PageTsausrs','PageIvportlogi','PageTsmwork','PageTsrespa','Head509298','PageTsfinys','PageTscontm','PageTststat','PageTstcity','PageTscurre','PageTsliovs','PageTspbank','PageTsbnkde','PageTstlcon','PageTsrelat','PageTsdisrm','PageTsfndsh','PageTscntry','Head800859','PageTsad_it','Head573158','PageIvclmascon','PageIvclntlist','Head711672','PageIvdocuploa','PageIvdocupche','PageTsdocup','PageTsdocsg','PageTsporco','PageIvprtlcong','HP1698765453552','PageIvuplexcep','Head246327','PageIvcldocume','PageIvrmfunsch','PageIvvwcliedt','PageIvdocsegre','PageIvcllogtim','PageIvcldocvie','PageIvclupchkl','HP1698238098286','Head104239','PageTsuiclm','HP1704042003246','Head685389','PageTscnrid','PageTscband','PageTscaccd','PageTscnome','PageTscjhdl','PageTscubod' ) ) a , axpages b where a.name = b.name order by b.ordno, b.levelno ) c uXDS\dopen\ Check intransaction Time elapsed = 5 Name : Head19 Name : Head16 Name : PageIvaxfinyrs Name : PageIvtodolist Name : Head22 Name : PageIvaxroles Name : PageTsausrs Name : PageIvportlogi Name : PageTsmwork Name : PageTsrespa Name : Head509298 Name : PageTsfinys Name : PageTscontm Name : PageTststat Name : PageTstcity Name : PageTscurre Name : PageTsliovs Name : PageTspbank Name : PageTsbnkde Name : PageTstlcon Name : PageTsrelat Name : PageTsdisrm Name : PageTsfndsh Name : PageTscntry Name : Head800859 Name : PageTsad_it Name : Head573158 Name : PageIvclmascon Name : PageIvclntlist Name : Head711672 Name : PageIvdocuploa Name : PageIvdocupche Name : PageTsdocup Name : PageTsdocsg Name : PageTsporco Name : PageIvprtlcong Name : HP1698765453552 Name : PageIvuplexcep Name : Head246327 Name : PageIvcldocume Name : PageIvrmfunsch Name : PageIvvwcliedt Name : PageIvdocsegre Name : PageIvcllogtim Name : PageIvcldocvie Name : PageIvclupchkl Name : HP1698238098286 Name : Head104239 Name : PageTsuiclm Name : HP1704042003246 Name : Head685389 Name : PageTscnrid Name : PageTscband Name : PageTscaccd Name : PageTscnome Name : PageTscjhdl Name : PageTscubod select count(*) as cnt from axhomeconfig uXDS\dopen\ Check intransaction Time elapsed = 3 Getting Role-Wise Card names... Executing GetRoleWiseCardNames select axp_cardsid,accessstring from axp_cards where inhomepage = 'T' order by orderno Time elapsed = 3 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 '%,trustlineadmin,%' ) order by orderno Time elapsed = 7 sql params count : 0 select 'Schemes' as "Schemes", b.scheme_code as "Scheme Code", count(1) as "Nos" from client_details a, client_accountdetails b where a.cancel ='F' and a.active = 'T' AND a.client_detailsid = b.client_detailsid group by b.scheme_code order by 1 uXDS\dopen\ Check intransaction Time elapsed = 5 sql params count : 0 select id,activecnt from (select 'Inactive Clients' as id, count(a.client_code )as activecnt from client_details a where a.active = 'F' union select 'Active Clients' as id, count(a.client_code) as activecnt from client_details a where a.active = 'T')b order by 2 uXDS\dopen\ Check intransaction Time elapsed = 3 sql params count : 0 select a.resident_status, count(1) as cnt from client_details a where a.cancel ='F' and a.active = 'T' group by a.resident_status order by 1 uXDS\dopen\ Check intransaction Time elapsed = 2 Executing GetFullCardDetails completed.. Getting Card details completed... Result :admin_panel_settingsmaterial-iconsperm_data_settingmaterial-iconsview_listmaterial-iconssupervised_user_circlematerial-iconsbackup_tablematerial-iconsattach_emailmaterial-iconsnature_peoplematerial-iconsdeveloper_boardmaterial-iconsredeemmaterial-iconsimportant_devicesmaterial-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 My Funds\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":"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 List of Accounts\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 Latest BizNotes/Covering Note\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 Latest Videos\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 Latest Articles\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":"1375660000000","cardname":"Schemes Option Card","cardtype":"list","charttype":"","chartjson":"{\"attributes\":{\"cck\":\"\",\"shwLgnd\":,\"xAxisL\":\"\",\"yAxisL\":\"\",\"gradClrChart\":,\"shwChartVal\":,\"threeD\":\"remove\",\"enableSlick\":,\"numbSym\":}}","cardicon":"","pagename":"","pagedesc":"","cardbgclr":"","width":"col-md-4","height":"300px","cachedata":"true","autorefresh":"30","cardsql":{"fields":[{"name":"Schemes","datatype":"text"},{"name":"Scheme Code","datatype":"string"},{"name":"Nos","datatype":"numeric"}],"row":[{"Schemes":"Schemes","Scheme Code":"Floater","Nos":"14"},{"Schemes":"Schemes","Scheme Code":"Intrinsic","Nos":"58"}]},"orderno":"7","accessstring":",trustlineadmin,default,","htransid":"","htype":"","hcaption":"","axpfile_imgcard":"","html_editor_card":"","calendarstransid":"","exp_editor_buttons":""},{"axp_cardsid":"1938220000000","cardname":"Clients","cardtype":"chart","charttype":"pie","chartjson":"{\"attributes\":{\"cck\":\"darkGreen\",\"shwLgnd\":true,\"xAxisL\":\"Clients\",\"yAxisL\":\"\",\"gradClrChart\":false,\"shwChartVal\":true,\"threeD\":\"remove\",\"enableSlick\":false,\"numbSym\":false}}","cardicon":"person_outline","pagename":"","pagedesc":"","cardbgclr":"","width":"col-md-3","height":"0px","cachedata":"true","autorefresh":"30","cardsql":{"fields":[{"name":"id","datatype":"text"},{"name":"activecnt","datatype":"numeric"}],"row":[{"id":"Inactive Clients","activecnt":"0"},{"id":"Active Clients","activecnt":"64"}]},"orderno":"9","accessstring":",default,trustlineadmin,","htransid":"","htype":"","hcaption":"","axpfile_imgcard":"","html_editor_card":"","calendarstransid":"","exp_editor_buttons":""},{"axp_cardsid":"1372010000000","cardname":"Resident Status ","cardtype":"chart","charttype":"pie","chartjson":"{\"attributes\":{\"cck\":\"avacado\",\"shwLgnd\":true,\"xAxisL\":\"Resident\",\"yAxisL\":\"Nos.\",\"gradClrChart\":false,\"shwChartVal\":true,\"threeD\":\"create\",\"enableSlick\":false,\"numbSym\":}}","cardicon":"pie_chart_outline","pagename":"","pagedesc":"","cardbgclr":"","width":"col-md-1","height":"100px","cachedata":"true","autorefresh":"30","cardsql":{"fields":[{"name":"resident_status","datatype":"string"},{"name":"cnt","datatype":"numeric"}],"row":[{"resident_status":"Dummy","cnt":"1"},{"resident_status":"Foreign National","cnt":"1"},{"resident_status":"Non-Resident Indian","cnt":"2"},{"resident_status":"Resident Indian","cnt":"60"}]},"orderno":"11","accessstring":",default,trustlineadmin,trustlineapprover,","htransid":"","htype":"","hcaption":"","axpfile_imgcard":"","html_editor_card":"","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 ('poldytivpp1u221enww3n0xy','soma',to_timestamp('12/08/2024 15:02:26','dd/mm/yyyy hh24:mi:ss'),to_timestamp('12/08/2024 15:02:26','dd/mm/yyyy hh24:mi:ss'),null,0,'Get menu - Multi levels','success',300,43,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