Start Time : 02/08/2024 17:48:28 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 = 1 select props from axprops where lower(name)='app' order by blobno uXDS\dopen\ Check intransaction Time elapsed = 4 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_TLBusiness1025660000000FrekhanciadefaultdefaultF21ujkxfi3sanzmaknrarljnjdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*8/2/2024 5:48:27 pm*-15206396604~~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/2/2024 5:48:27 pm*-15206396604 axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=21ujkxfi3sanzmaknrarljnj ax_evalcopy=F rolename=default responsibilies=default millions=F axpimageserver= axglo_hide= axp_displaytext= axglo_user= fromuserlogin= axglo_recordid=1025660000000 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 default User Roles default Registering app/user variables for the session completed select sessionid from connections where sessionid = :sesid uXDS\dopen\ Check intransaction Time elapsed = 2 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 '%,default,%' ) order by orderno Time elapsed = 4 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 = 2 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 = 1 Executing GetFullCardDetails completed.. Getting Card details completed... Result : 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 ('21ujkxfi3sanzmaknrarljnj','rekhancia',to_timestamp('02/08/2024 17:48:28','dd/mm/yyyy hh24:mi:ss'),to_timestamp('02/08/2024 17:48:28','dd/mm/yyyy hh24:mi:ss'),null,0,'Get menu - Multi levels','success',224,27,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