Start Time : 07/08/2024 10:48:25 Get IviewObj from Cache, User: rekhancia Role: Getting IviewObj from cache rekhancia Role: Loading iview.aspx before post back (get and set parameters) Get Iview Parameters Loading and setting parameters components Call to GetIView Web Service for page no 1 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 = 2 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 GetIViewNew webservice --------------------------------- Received 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_TLBusiness1025660000000FrekhanciadefaultdefaultF1u3sb0qwg2a5gzugv4mwae1ndefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*8/7/2024 10:45:22 am*-2592009820~~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/7/2024 10:45:22 am*-2592009820 axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=1u3sb0qwg2a5gzugv4mwae1n 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 = 3 >>Reading defintion - response Initializing Report Preparing SQL statements Assigning values to IView parameters Creating Columns SELECT rname,substring(string_agg(case when stype='t' then t.caption when stype ='i' then i.caption end,','),1,150)||'...' sname FROM axuseraccess a left join tstructs t on a.sname = t.name left join iviews i on a.sname = i.name group by rname order by rname LIMIT 25 Time elapsed = 12 Time elapsed = 13 Copying result to grid Row 1 Evaluating column values rname = dummy rname = dummy sname = sname = Creating Row Row No1 Created Displaying columns Column Name : rname Column Value : dummy Column Name : sname Column Value : Row 2 Evaluating column values rname = sample rname = sample sname = Trustline Bank Details,Country,Country,Currency,Distributor and RM Details,Financial Years,Fund and Scheme,List of Values,Primary Bank Name,Family Rel... sname = Trustline Bank Details,Country,Country,Currency,Distributor and RM Details,Financial Years,Fund and Scheme,List of Values,Primary Bank Name,Family Rel... Creating Row Row No2 Created Displaying columns Column Name : rname Column Value : sample Column Name : sname Column Value : Trustline Bank Details,Country,Country,Currency,Distributor and RM Details,Financial Years,Fund and Scheme,List of Values,Primary Bank Name,Family Rel... Row 3 Evaluating column values rname = test rname = test sname = Client Documents ,PEG Task History,ToDo List,Client Master,Client Portal... sname = Client Documents ,PEG Task History,ToDo List,Client Master,Client Portal... Creating Row Row No3 Created Displaying columns Column Name : rname Column Value : test Column Name : sname Column Value : Client Documents ,PEG Task History,ToDo List,Client Master,Client Portal... Row 4 Evaluating column values rname = tlclientmaster rname = tlclientmaster sname = Client Master (Concise),Client Master... sname = Client Master (Concise),Client Master... Creating Row Row No4 Created Displaying columns Column Name : rname Column Value : tlclientmaster Column Name : sname Column Value : Client Master (Concise),Client Master... Row 5 Evaluating column values rname = tlmaster rname = tlmaster sname = Import data log,Data import templates,Trustline Bank Details,Country,Currency,Distributor and RM Details,Mail Merge Email Templates,Financial Years,Fu... sname = Import data log,Data import templates,Trustline Bank Details,Country,Currency,Distributor and RM Details,Mail Merge Email Templates,Financial Years,Fu... Creating Row Row No5 Created Displaying columns Column Name : rname Column Value : tlmaster Column Name : sname Column Value : Import data log,Data import templates,Trustline Bank Details,Country,Currency,Distributor and RM Details,Mail Merge Email Templates,Financial Years,Fu... Row 6 Evaluating column values rname = tlsuperadmin rname = tlsuperadmin sname = Data import templates,User Roles,User Login,Trustline Bank Details,Client Documents ,Client Master (Concise),Report Reconciliation,Country,Currency,D... sname = Data import templates,User Roles,User Login,Trustline Bank Details,Client Documents ,Client Master (Concise),Report Reconciliation,Country,Currency,D... Creating Row Row No6 Created Displaying columns Column Name : rname Column Value : tlsuperadmin Column Name : sname Column Value : Data import templates,User Roles,User Login,Trustline Bank Details,Client Documents ,Client Master (Concise),Report Reconciliation,Country,Currency,D... Row 7 Evaluating column values rname = trustlineadmin rname = trustlineadmin sname = Data import templates,Portal Login,Years,User Roles,User Login,Trustline Bank Details,Client Account Detail,Client Bank Details,Joint Holder Details,C... sname = Data import templates,Portal Login,Years,User Roles,User Login,Trustline Bank Details,Client Account Detail,Client Bank Details,Joint Holder Details,C... Creating Row Row No7 Created Displaying columns Column Name : rname Column Value : trustlineadmin Column Name : sname Column Value : Data import templates,Portal Login,Years,User Roles,User Login,Trustline Bank Details,Client Account Detail,Client Bank Details,Joint Holder Details,C... Row 8 Evaluating column values rname = trustlineapprover rname = trustlineapprover sname = Client Master (Concise),ToDo List,Client Master... sname = Client Master (Concise),ToDo List,Client Master... Creating Row Row No8 Created Displaying columns Column Name : rname Column Value : trustlineapprover Column Name : sname Column Value : Client Master (Concise),ToDo List,Client Master... Row 9 Evaluating column values rname = trustlineclient rname = trustlineclient sname = Client Documents ,Client Documents,Client Portal... sname = Client Documents ,Client Documents,Client Portal... Creating Row Row No9 Created Displaying columns Column Name : rname Column Value : trustlineclient Column Name : sname Column Value : Client Documents ,Client Documents,Client Portal... Storing subtotals Storing subtotals at : E:\Axpert113\Axpert Web\AxpertWebScripts\Axpert\1u3sb0qwg2a5gzugv4mwae1n\response.lst Time elapsed = 77 Total Time elapsed = 95 Iview result :{"data":{"row":[{"rowno":"1","rname":"dummy","sname":""},{"rowno":"2","rname":"sample","sname":"Trustline Bank Details,Country,Country,Currency,Distributor and RM Details,Financial Years,Fund and Scheme,List of Values,Primary Bank Name,Family Rel..."},{"rowno":"3","rname":"test","sname":"Client Documents ,PEG Task History,ToDo List,Client Master,Client Portal..."},{"rowno":"4","rname":"tlclientmaster","sname":"Client Master (Concise),Client Master..."},{"rowno":"5","rname":"tlmaster","sname":"Import data log,Data import templates,Trustline Bank Details,Country,Currency,Distributor and RM Details,Mail Merge Email Templates,Financial Years,Fu..."},{"rowno":"6","rname":"tlsuperadmin","sname":"Data import templates,User Roles,User Login,Trustline Bank Details,Client Documents ,Client Master (Concise),Report Reconciliation,Country,Currency,D..."},{"rowno":"7","rname":"trustlineadmin","sname":"Data import templates,Portal Login,Years,User Roles,User Login,Trustline Bank Details,Client Account Detail,Client Bank Details,Joint Holder Details,C..."},{"rowno":"8","rname":"trustlineapprover","sname":"Client Master (Concise),ToDo List,Client Master..."},{"rowno":"9","rname":"trustlineclient","sname":"Client Documents ,Client Documents,Client Portal..."}]},"reccount":{"reccount":"9"},"actualrows":{"actualrows":"9"}} GetIView webservice completed Time Used : 45.7774502997801 secs # 1#Saving to log insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('1u3sb0qwg2a5gzugv4mwae1n','rekhancia',to_timestamp('07/08/2024 10:48:25','dd/mm/yyyy hh24:mi:ss'),to_timestamp('07/08/2024 10:48:26','dd/mm/yyyy hh24:mi:ss'),'response',0,'Get IView New','success',282,23,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 Loading and setting parameters components completed End Time : 07/08/2024 10:48:26 Get IviewObj from Cache, User: rekhancia Role: Getting IviewObj from cache rekhancia Role: Loading iview.aspx before post back (get and set parameters) Get Iview Parameters Loading and setting parameters components Call to GetIView Web Service for page no 1 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 = 2 select props from axprops where lower(name)='app' order by blobno uXDS\dopen\ Check intransaction Time elapsed = 2 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 = 0 Db Manager Connection ends Connection to DB Successful Executing GetIViewNew webservice --------------------------------- Received 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_TLBusiness1025660000000FrekhanciadefaultdefaultF1u3sb0qwg2a5gzugv4mwae1ndefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*8/7/2024 10:45:22 am*-2592009820~~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/7/2024 10:45:22 am*-2592009820 axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=1u3sb0qwg2a5gzugv4mwae1n 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 = 3 >>Reading defintion - response Initializing Report Preparing SQL statements Assigning values to IView parameters Creating Columns SELECT rname,substring(string_agg(case when stype='t' then t.caption when stype ='i' then i.caption end,','),1,150)||'...' sname FROM axuseraccess a left join tstructs t on a.sname = t.name left join iviews i on a.sname = i.name group by rname order by rname LIMIT 25 Time elapsed = 13 Time elapsed = 14 Copying result to grid Row 1 Evaluating column values rname = dummy rname = dummy sname = sname = Creating Row Row No1 Created Displaying columns Column Name : rname Column Value : dummy Column Name : sname Column Value : Row 2 Evaluating column values rname = sample rname = sample sname = Trustline Bank Details,Country,Country,Currency,Distributor and RM Details,Financial Years,Fund and Scheme,List of Values,Primary Bank Name,Family Rel... sname = Trustline Bank Details,Country,Country,Currency,Distributor and RM Details,Financial Years,Fund and Scheme,List of Values,Primary Bank Name,Family Rel... Creating Row Row No2 Created Displaying columns Column Name : rname Column Value : sample Column Name : sname Column Value : Trustline Bank Details,Country,Country,Currency,Distributor and RM Details,Financial Years,Fund and Scheme,List of Values,Primary Bank Name,Family Rel... Row 3 Evaluating column values rname = test rname = test sname = Client Documents ,PEG Task History,ToDo List,Client Master,Client Portal... sname = Client Documents ,PEG Task History,ToDo List,Client Master,Client Portal... Creating Row Row No3 Created Displaying columns Column Name : rname Column Value : test Column Name : sname Column Value : Client Documents ,PEG Task History,ToDo List,Client Master,Client Portal... Row 4 Evaluating column values rname = tlclientmaster rname = tlclientmaster sname = Client Master (Concise),Client Master... sname = Client Master (Concise),Client Master... Creating Row Row No4 Created Displaying columns Column Name : rname Column Value : tlclientmaster Column Name : sname Column Value : Client Master (Concise),Client Master... Row 5 Evaluating column values rname = tlmaster rname = tlmaster sname = Import data log,Data import templates,Trustline Bank Details,Country,Currency,Distributor and RM Details,Mail Merge Email Templates,Financial Years,Fu... sname = Import data log,Data import templates,Trustline Bank Details,Country,Currency,Distributor and RM Details,Mail Merge Email Templates,Financial Years,Fu... Creating Row Row No5 Created Displaying columns Column Name : rname Column Value : tlmaster Column Name : sname Column Value : Import data log,Data import templates,Trustline Bank Details,Country,Currency,Distributor and RM Details,Mail Merge Email Templates,Financial Years,Fu... Row 6 Evaluating column values rname = tlsuperadmin rname = tlsuperadmin sname = Data import templates,User Roles,User Login,Trustline Bank Details,Client Documents ,Client Master (Concise),Report Reconciliation,Country,Currency,D... sname = Data import templates,User Roles,User Login,Trustline Bank Details,Client Documents ,Client Master (Concise),Report Reconciliation,Country,Currency,D... Creating Row Row No6 Created Displaying columns Column Name : rname Column Value : tlsuperadmin Column Name : sname Column Value : Data import templates,User Roles,User Login,Trustline Bank Details,Client Documents ,Client Master (Concise),Report Reconciliation,Country,Currency,D... Row 7 Evaluating column values rname = trustlineadmin rname = trustlineadmin sname = Data import templates,Portal Login,Years,User Roles,User Login,Trustline Bank Details,Client Account Detail,Client Bank Details,Joint Holder Details,C... sname = Data import templates,Portal Login,Years,User Roles,User Login,Trustline Bank Details,Client Account Detail,Client Bank Details,Joint Holder Details,C... Creating Row Row No7 Created Displaying columns Column Name : rname Column Value : trustlineadmin Column Name : sname Column Value : Data import templates,Portal Login,Years,User Roles,User Login,Trustline Bank Details,Client Account Detail,Client Bank Details,Joint Holder Details,C... Row 8 Evaluating column values rname = trustlineapprover rname = trustlineapprover sname = Client Master (Concise),ToDo List,Client Master... sname = Client Master (Concise),ToDo List,Client Master... Creating Row Row No8 Created Displaying columns Column Name : rname Column Value : trustlineapprover Column Name : sname Column Value : Client Master (Concise),ToDo List,Client Master... Row 9 Evaluating column values rname = trustlineclient rname = trustlineclient sname = Client Documents ,Client Documents,Client Portal... sname = Client Documents ,Client Documents,Client Portal... Creating Row Row No9 Created Displaying columns Column Name : rname Column Value : trustlineclient Column Name : sname Column Value : Client Documents ,Client Documents,Client Portal... Storing subtotals Storing subtotals at : E:\Axpert113\Axpert Web\AxpertWebScripts\Axpert\1u3sb0qwg2a5gzugv4mwae1n\response.lst Time elapsed = 89 Total Time elapsed = 109 Iview result :{"data":{"row":[{"rowno":"1","rname":"dummy","sname":""},{"rowno":"2","rname":"sample","sname":"Trustline Bank Details,Country,Country,Currency,Distributor and RM Details,Financial Years,Fund and Scheme,List of Values,Primary Bank Name,Family Rel..."},{"rowno":"3","rname":"test","sname":"Client Documents ,PEG Task History,ToDo List,Client Master,Client Portal..."},{"rowno":"4","rname":"tlclientmaster","sname":"Client Master (Concise),Client Master..."},{"rowno":"5","rname":"tlmaster","sname":"Import data log,Data import templates,Trustline Bank Details,Country,Currency,Distributor and RM Details,Mail Merge Email Templates,Financial Years,Fu..."},{"rowno":"6","rname":"tlsuperadmin","sname":"Data import templates,User Roles,User Login,Trustline Bank Details,Client Documents ,Client Master (Concise),Report Reconciliation,Country,Currency,D..."},{"rowno":"7","rname":"trustlineadmin","sname":"Data import templates,Portal Login,Years,User Roles,User Login,Trustline Bank Details,Client Account Detail,Client Bank Details,Joint Holder Details,C..."},{"rowno":"8","rname":"trustlineapprover","sname":"Client Master (Concise),ToDo List,Client Master..."},{"rowno":"9","rname":"trustlineclient","sname":"Client Documents ,Client Documents,Client Portal..."}]},"reccount":{"reccount":"9"},"actualrows":{"actualrows":"9"}} GetIView webservice completed Time Used : 45.7904504146875 secs # 1#Saving to log insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('1u3sb0qwg2a5gzugv4mwae1n','rekhancia',to_timestamp('07/08/2024 10:48:35','dd/mm/yyyy hh24:mi:ss'),to_timestamp('07/08/2024 10:48:36','dd/mm/yyyy hh24:mi:ss'),'response',0,'Get IView New','success',281,20,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 Loading and setting parameters components completed End Time : 07/08/2024 10:48:36