Start Time : 26/09/2024 12:41:55 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 = 0 select props from axprops where lower(name)='app' order by blobno uXDS\dopen\ Check intransaction Time elapsed = 0 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 = 16 Db Manager Connection ends Connection to DB Successful Executing GetMultiMenu webservice --------------------------------- Recevied XML : dbPostgredbxlocalhosttrustlineuat\trustlineuattrustlineuatdd/mm/yyyy hh24:mi:ss13iraj1966@yahoo.comlocalBlackENGLISHtruet\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir\\10.16.248.2\UAT_Attachment\UAT_TLReports\\10.16.248.2\UAT_Attachment\UAT_TLBusiness1025660000000FrekhanciadefaultdefaultFm1wpr11izwubiasurof0j0mpdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*9/26/2024 12:41:54 pm*~~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*9/26/2024 12:41:54 pm* axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=m1wpr11izwubiasurof0j0mp 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 = 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' order by ordno ,levelno uXDS\dopen\ Check intransaction Time elapsed = 16 Name : Head19 Name : Head14 Name : PageIvidsco Name : PageIvaxchtdtl Name : PageIvaxnxtlst Name : PageIvcerrm Name : PageIvesmsco Name : PageTsappsr Name : PageTsagspr Name : PageTstconf Name : PageTstemps Name : PageTsiconf Name : PageIviaxpscon Name : PageTsastcp Name : Head17 Name : PageIvdmlscrpt Name : PageTsthelp Name : PageIvadxconfv Name : PageIvikywd Name : PageTsaxglo Name : PageIvthint Name : PageTsaxctx Name : Head18 Name : PageIvivhelpto Name : PageIvaxemllog Name : PageIvsmslog Name : PageIvadxoutlo Name : PageIvadxinlog Name : PageIvaxusracc Name : PageIvapplogsm Name : PageIvitimtk Name : PageIviaxex Name : PageIvauditlog Name : Head16 Name : PageIvaxfinyrs Name : PageIvloview1 Name : Head20 Name : Head21 Name : PageTsaxstc Name : PageIvForms Name : PageTsad__t Name : PageIvmainrepo Name : PageTsad__d Name : PageTsmntst Name : PageTsad_fg Name : PageTsad_md Name : PageTsad_ge Name : Head23 Name : PageIvimobc Name : Page245 Name : PageTsofcon Name : PageIvtodolist Name : HP100 Name : HP1700829859872 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 : PageIvad_implg Name : PageTsfemai Name : HP1700647482345 Name : HP1700628989551 Name : HP1701235633390 Name : Head573158 Name : PageTstrcln Name : PageIvclmascon Name : PageIvclntlist Name : Head711672 Name : PageIvdocuploa Name : PageIvdocupche Name : PageTsdocup Name : PageTsdocsg Name : PageTsporco Name : PageIvprtlcong Name : HP1698765453552 Name : PageTsfupse Name : PageTsfupva Name : PageIvuplexcep Name : Head246327 Name : PageIvfundleve Name : PageIvcldocume Name : PageIvschemele Name : PageIvrmfunsch Name : PageIvvwcliedt Name : PageIvloginrep Name : PageIvdocsegre Name : PageIvcityrepo Name : PageIvcllogtim Name : PageIvcldocvie Name : PageIvclupchkl Name : PageIvrepuploa Name : HP1698238098286 Name : PageTsclhom Name : Head690558 Name : PageIvtrialdoc Name : PageIvemailrep Name : PageTsad_li Name : PageIvaxlangs Name : PageTsad_lg Name : PageIvad_lngst Name : PageTsaxcad Name : Head104239 Name : PageTsuiclm Name : HP1700853895354 Name : HP1700829649608 Name : HP1700829751172 Name : HP1700830195097 Name : PageTstestf Name : PageIvclnotupl Name : PageIvpegtaskh Name : PageTsad_am Name : PageTsad_at Name : PageTsad_cp Name : PageTsad_pm Name : PageTsad_pn Name : PageTsad_td Name : PageTspgv2a Name : PageTspgv2c Name : PageTspgv2m Name : PageTsa__sm Name : PageIvad__act Name : PageIvad__alog Name : PageIvad__pgal Name : PageIvad__pgnt Name : PageIvad__prcd Name : PageIvad_pgv2 Name : HP1702563201947 Name : HP1704042003246 Name : PageTscnomi Name : PageIvsacltdoc Name : Head685389 Name : PageTscnrid Name : PageTscband Name : PageTscaccd Name : PageTscnome Name : PageTscjhdl Name : PageTscubod Name : PageTsgenem Name : HP1714048270317 Name : __not_found__ select count(*) as cnt from axhomeconfig uXDS\dopen\ Check intransaction Time elapsed = 15 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 '%,default,%' ) order by orderno Time elapsed = 16 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 = 0 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 = 0 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 = 0 Executing GetFullCardDetails completed.. Getting Card details completed... Result :admin_panel_settingsmaterial-iconsconstructionmaterial-iconssupportmaterial-iconshome_repair_servicematerial-iconsperm_data_settingmaterial-iconssettingsmaterial-iconssend_to_mobilematerial-iconsview_listmaterial-iconssupervised_user_circlematerial-iconsbackup_tablematerial-iconsattach_emailmaterial-iconsnature_peoplematerial-iconsdeveloper_boardmaterial-iconsredeemmaterial-iconsimportant_devicesmaterial-iconsdocument_scannermaterial-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":"57"}]},"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":"1"},{"id":"Active Clients","activecnt":"63"}]},"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":"59"}]},"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 ('m1wpr11izwubiasurof0j0mp','rekhancia',to_timestamp('26/09/2024 12:41:55','dd/mm/yyyy hh24:mi:ss'),to_timestamp('26/09/2024 12:41:55','dd/mm/yyyy hh24:mi:ss'),null,0,'Get menu - Multi levels','success',406,63,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