Start Time : 20/05/2025 12:33:03 Get IviewObj from Cache, User: rekhancia Role: Loading iview.aspx before post back (get and set parameters) Get Iview Parameters Call to GetParams Web Service ASB XE3/32/64 DLL running [Compiled on 24/03/2025 11:58:10 PM] [File Version : 11.3.0.0]] [Product Version : 11.3][64Bit(181224)] 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.com9IntFlo!!$$*1100000FF SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2 uXDS\dopen\ Check intransaction Time elapsed = 3 Db Manager Connection ends Connection to DB Successful Executing GetParamsNew webservice ---------------------------------- Received 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_TLBusiness1025660000000FrekhanciadefaultdefaultFgmyjcxxozanv2o1zo21ssfafdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*5/20/2025 12:14:18 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*5/20/2025 12:14:18 pm* axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=gmyjcxxozanv2o1zo21ssfaf 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 Sql : select props from iviews where lower(name)= :name order by blobno Paramval : axusers ParamTYpe : c Param List : name select props from iviews where lower(name)= :name order by blobno uXDS\dopen\ Check intransaction Time elapsed = 4 Step5 select username , config_data from axp_smartviews_config where ivname = 'axusers' Time elapsed = 3 GetSmartViewSettings Result : Select cvalue from axpconfigsiv_axusers where configname= 'groupbtns' CDS Open Error Msg : csd query : Select cvalue from axpconfigsiv_axusers where configname= 'groupbtns' $ Error msg : relation "axpconfigsiv_axusers" does not exist uXDS\open\ Exceptio relation "axpconfigsiv_axusers" does not exist Creating runtime menu Created runtime menu Global vars in Params :{"globalVars":[]} Result : SELECT A.STYPE,A.STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'SINGLE' as APPLYON FROM axpstructconfig a, axuserlevelgroups b WHERE A.USERROLES IN ('default') AND B.AXUSERNAME = :uname AND lower(a.stype) = :structure_type AND A.STRUCTNAME not in('ALL Reports','ALL Forms') UNION SELECT A.STYPE,A.STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'SINGLE' as APPLYON FROM axpstructconfig a WHERE coalesce(USERROLES, 'ALL') = 'ALL' AND lower(a.stype) = :structure_type AND structname = :sname AND A.STRUCTNAME not in('ALL Reports','ALL Forms') UNION SELECT A.STYPE, :sname STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'ALL' as APPLYON FROM axpstructconfig a, axuserlevelgroups b WHERE A.USERROLES IN ('default') AND B.AXUSERNAME = :uname AND lower(a.stype) = :structure_type AND A.STRUCTNAME in('ALL Reports','ALL Forms') UNION SELECT A.STYPE, :sname STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'ALL' as APPLYON FROM axpstructconfig a WHERE coalesce(USERROLES, 'ALL') = 'ALL' AND lower(a.stype) = :structure_type AND A.STRUCTNAME in('ALL Reports','ALL Forms') order by STYPE,STRUCTNAME,PROPS,APPLYON DESC uname=rekhancia structure_type=iview structure_type=iview sname=axusers sname=axusers uname=rekhancia structure_type=iview sname=axusers structure_type=iview Time elapsed = 13 GetParamsNew webservice completed # 1#Saving to log insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('gmyjcxxozanv2o1zo21ssfaf','rekhancia',to_timestamp('20/05/2025 12:33:03','dd/mm/yyyy hh24:mi:ss'),to_timestamp('20/05/2025 12:33:03','dd/mm/yyyy hh24:mi:ss'),null,0,'Getting IView Params New','success',180,31,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 Call to GetIView Web Service for page no 1 ASB XE3/32/64 DLL running [Compiled on 24/03/2025 11:58:10 PM] [File Version : 11.3.0.0]] [Product Version : 11.3][64Bit(181224)] 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.com9IntFlo!!$$*1100000FF SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2 uXDS\dopen\ Check intransaction Time elapsed = 15 Db Manager Connection ends Connection to DB Successful Executing GetIViewNew webservice --------------------------------- Received 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_TLBusiness1025660000000FrekhanciadefaultdefaultFgmyjcxxozanv2o1zo21ssfafdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*5/20/2025 12:14:18 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*5/20/2025 12:14:18 pm* axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=gmyjcxxozanv2o1zo21ssfaf 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 >>Reading defintion - axusers Evaluating dbrow Result = Evaluating dbrow Result = Initializing Report Preparing SQL statements Assigning values to IView parameters Creating Columns Creating Columns for first time Creating axusersid sourceusername Creating column1 sourceusername Creating username sourceusername Creating nickname sourceusername Creating email sourceusername Creating mobile sourceusername Creating allusergroup sourceusername Creating Columns for first time completed select axusersid,username, nickname, email, allusergroup, mobile from axusers where COALESCE(active,'T')='T' and username <> 'admin' LIMIT 25 Time elapsed = 0 Time elapsed = 0 Copying result to grid Row 1 Evaluating column values axusersid = 1890010000000 axusersid = 1890010000000 column1 - evaluating expression dbrow = 1 column1 = 1 column1 = 1 username = 11cr_pradeep@wabag.in username = 11cr_pradeep@wabag.in nickname = Pradeep C R nickname = Pradeep C R email = 11cr_pradeep@wabag.in email = 11cr_pradeep@wabag.in mobile = 7032746004 mobile = 7032746004 allusergroup = client allusergroup = client Creating Row Row No1 Created Displaying columns Column Name : axusersid Column Value : 1890010000000 Column Name : column1 Column Value : 1 Column Name : username Column Value : 11cr_pradeep@wabag.in Column Name : nickname Column Value : Pradeep C R Column Name : email Column Value : 11cr_pradeep@wabag.in Column Name : mobile Column Value : 7032746004 Column Name : allusergroup Column Value : client Row 2 Evaluating column values axusersid = 1882010000000 axusersid = 1882010000000 column1 - evaluating expression dbrow = 2 column1 = 2 column1 = 2 username = 1tkgovind@yahoo.com username = 1tkgovind@yahoo.com nickname = T K Govinda Rajan nickname = T K Govinda Rajan email = itsme.trustline@hotmail.com email = itsme.trustline@hotmail.com mobile = mobile = allusergroup = client allusergroup = client Creating Row Row No2 Created Displaying columns Column Name : axusersid Column Value : 1882010000000 Column Name : column1 Column Value : 2 Column Name : username Column Value : 1tkgovind@yahoo.com Column Name : nickname Column Value : T K Govinda Rajan Column Name : email Column Value : itsme.trustline@hotmail.com Column Name : mobile Column Value : Column Name : allusergroup Column Value : client Row 3 Evaluating column values axusersid = 1889660000000 axusersid = 1889660000000 column1 - evaluating expression dbrow = 3 column1 = 3 column1 = 3 username = 11test@gmail.com username = 11test@gmail.com nickname = Testing nickname = Testing email = 11test@gmail.com email = 11test@gmail.com mobile = 9111111111 mobile = 9111111111 allusergroup = client allusergroup = client Creating Row Row No3 Created Displaying columns Column Name : axusersid Column Value : 1889660000000 Column Name : column1 Column Value : 3 Column Name : username Column Value : 11test@gmail.com Column Name : nickname Column Value : Testing Column Name : email Column Value : 11test@gmail.com Column Name : mobile Column Value : 9111111111 Column Name : allusergroup Column Value : client Row 4 Evaluating column values axusersid = 1890330000000 axusersid = 1890330000000 column1 - evaluating expression dbrow = 4 column1 = 4 column1 = 4 username = 11dalal.naozer@yahoo.com username = 11dalal.naozer@yahoo.com nickname = Naozer Cusrow Dalal 1 nickname = Naozer Cusrow Dalal 1 email = vlaksi.d@agile-labs.com email = vlaksi.d@agile-labs.com mobile = 9820302953 mobile = 9820302953 allusergroup = client allusergroup = client Creating Row Row No4 Created Displaying columns Column Name : axusersid Column Value : 1890330000000 Column Name : column1 Column Value : 4 Column Name : username Column Value : 11dalal.naozer@yahoo.com Column Name : nickname Column Value : Naozer Cusrow Dalal 1 Column Name : email Column Value : vlaksi.d@agile-labs.com Column Name : mobile Column Value : 9820302953 Column Name : allusergroup Column Value : client Row 5 Evaluating column values axusersid = 1882440000000 axusersid = 1882440000000 column1 - evaluating expression dbrow = 5 column1 = 5 column1 = 5 username = 1gomathi.u@gmail.com username = 1gomathi.u@gmail.com nickname = Gomathi Ulaganathan nickname = Gomathi Ulaganathan email = 1gomathi.u@gmail.com email = 1gomathi.u@gmail.com mobile = mobile = allusergroup = client allusergroup = client Creating Row Row No5 Created Displaying columns Column Name : axusersid Column Value : 1882440000000 Column Name : column1 Column Value : 5 Column Name : username Column Value : 1gomathi.u@gmail.com Column Name : nickname Column Value : Gomathi Ulaganathan Column Name : email Column Value : 1gomathi.u@gmail.com Column Name : mobile Column Value : Column Name : allusergroup Column Value : client Row 6 Evaluating column values axusersid = 1887220000000 axusersid = 1887220000000 column1 - evaluating expression dbrow = 6 column1 = 6 column1 = 6 username = 12test@gmail.com username = 12test@gmail.com nickname = Testing 2 nickname = Testing 2 email = reckhancia@gmail.com email = reckhancia@gmail.com mobile = mobile = allusergroup = client allusergroup = client Creating Row Row No6 Created Displaying columns Column Name : axusersid Column Value : 1887220000000 Column Name : column1 Column Value : 6 Column Name : username Column Value : 12test@gmail.com Column Name : nickname Column Value : Testing 2 Column Name : email Column Value : reckhancia@gmail.com Column Name : mobile Column Value : Column Name : allusergroup Column Value : client Row 7 Evaluating column values axusersid = 1025660000000 axusersid = 1025660000000 column1 - evaluating expression dbrow = 7 column1 = 7 column1 = 7 username = rekhancia username = rekhancia nickname = rekhancia nickname = rekhancia email = rekhancia@agile-labs.com email = rekhancia@agile-labs.com mobile = 7904362037 mobile = 7904362037 allusergroup = default allusergroup = default Creating Row Row No7 Created Displaying columns Column Name : axusersid Column Value : 1025660000000 Column Name : column1 Column Value : 7 Column Name : username Column Value : rekhancia Column Name : nickname Column Value : rekhancia Column Name : email Column Value : rekhancia@agile-labs.com Column Name : mobile Column Value : 7904362037 Column Name : allusergroup Column Value : default Row 8 Evaluating column values axusersid = 1890550000000 axusersid = 1890550000000 column1 - evaluating expression dbrow = 8 column1 = 8 column1 = 8 username = 11deepakdesai@hotmail.com username = 11deepakdesai@hotmail.com nickname = Deepa Deepak Desai nickname = Deepa Deepak Desai email = vlakshmi.d@agile-labs.com email = vlakshmi.d@agile-labs.com mobile = 9823276852 mobile = 9823276852 allusergroup = client allusergroup = client Creating Row Row No8 Created Displaying columns Column Name : axusersid Column Value : 1890550000000 Column Name : column1 Column Value : 8 Column Name : username Column Value : 11deepakdesai@hotmail.com Column Name : nickname Column Value : Deepa Deepak Desai Column Name : email Column Value : vlakshmi.d@agile-labs.com Column Name : mobile Column Value : 9823276852 Column Name : allusergroup Column Value : client Row 9 Evaluating column values axusersid = 1359110000000 axusersid = 1359110000000 column1 - evaluating expression dbrow = 9 column1 = 9 column1 = 9 username = merwinmanoharan username = merwinmanoharan nickname = Merwin Manoharan nickname = Merwin Manoharan email = merwin@trustlineindia.com email = merwin@trustlineindia.com mobile = mobile = allusergroup = trustlineapprover allusergroup = trustlineapprover Creating Row Row No9 Created Displaying columns Column Name : axusersid Column Value : 1359110000000 Column Name : column1 Column Value : 9 Column Name : username Column Value : merwinmanoharan Column Name : nickname Column Value : Merwin Manoharan Column Name : email Column Value : merwin@trustlineindia.com Column Name : mobile Column Value : Column Name : allusergroup Column Value : trustlineapprover Row 10 Evaluating column values axusersid = 1386010000000 axusersid = 1386010000000 column1 - evaluating expression dbrow = 10 column1 = 10 column1 = 10 username = tamil username = tamil nickname = Tamil nickname = Tamil email = tamil@gmail.com email = tamil@gmail.com mobile = mobile = allusergroup = trustlineadmin allusergroup = trustlineadmin Creating Row Row No10 Created Displaying columns Column Name : axusersid Column Value : 1386010000000 Column Name : column1 Column Value : 10 Column Name : username Column Value : tamil Column Name : nickname Column Value : Tamil Column Name : email Column Value : tamil@gmail.com Column Name : mobile Column Value : Column Name : allusergroup Column Value : trustlineadmin Row 11 Evaluating column values axusersid = 1888440000000 axusersid = 1888440000000 column1 - evaluating expression dbrow = 11 column1 = 11 column1 = 11 username = 11anjalidevi61@yahoo.com username = 11anjalidevi61@yahoo.com nickname = Anjalidevi R nickname = Anjalidevi R email = 11anjalidevi61@yahoo.com email = 11anjalidevi61@yahoo.com mobile = 7904362037 mobile = 7904362037 allusergroup = client allusergroup = client Creating Row Row No11 Created Displaying columns Column Name : axusersid Column Value : 1888440000000 Column Name : column1 Column Value : 11 Column Name : username Column Value : 11anjalidevi61@yahoo.com Column Name : nickname Column Value : Anjalidevi R Column Name : email Column Value : 11anjalidevi61@yahoo.com Column Name : mobile Column Value : 7904362037 Column Name : allusergroup Column Value : client Row 12 Evaluating column values axusersid = 1891220000000 axusersid = 1891220000000 column1 - evaluating expression dbrow = 12 column1 = 12 column1 = 12 username = 11iraj1966@yahoo.com username = 11iraj1966@yahoo.com nickname = Usha Ratnakumari Rajakumar nickname = Usha Ratnakumari Rajakumar email = 11iraj1966@yahoo.com email = 11iraj1966@yahoo.com mobile = 7904362037 mobile = 7904362037 allusergroup = client allusergroup = client Creating Row Row No12 Created Displaying columns Column Name : axusersid Column Value : 1891220000000 Column Name : column1 Column Value : 12 Column Name : username Column Value : 11iraj1966@yahoo.com Column Name : nickname Column Value : Usha Ratnakumari Rajakumar Column Name : email Column Value : 11iraj1966@yahoo.com Column Name : mobile Column Value : 7904362037 Column Name : allusergroup Column Value : client Row 13 Evaluating column values axusersid = 1736990000000 axusersid = 1736990000000 column1 - evaluating expression dbrow = 13 column1 = 13 column1 = 13 username = ramk username = ramk nickname = Ramakrishnan nickname = Ramakrishnan email = ramk@gmail.com email = ramk@gmail.com mobile = mobile = allusergroup = tlclientmaster allusergroup = tlclientmaster Creating Row Row No13 Created Displaying columns Column Name : axusersid Column Value : 1736990000000 Column Name : column1 Column Value : 13 Column Name : username Column Value : ramk Column Name : nickname Column Value : Ramakrishnan Column Name : email Column Value : ramk@gmail.com Column Name : mobile Column Value : Column Name : allusergroup Column Value : tlclientmaster Row 14 Evaluating column values axusersid = 1025880000000 axusersid = 1025880000000 column1 - evaluating expression dbrow = 14 column1 = 14 column1 = 14 username = devipriya username = devipriya nickname = devi nickname = devi email = devipriya@agile-labs.com email = devipriya@agile-labs.com mobile = 9524122299 mobile = 9524122299 allusergroup = default allusergroup = default Creating Row Row No14 Created Displaying columns Column Name : axusersid Column Value : 1025880000000 Column Name : column1 Column Value : 14 Column Name : username Column Value : devipriya Column Name : nickname Column Value : devi Column Name : email Column Value : devipriya@agile-labs.com Column Name : mobile Column Value : 9524122299 Column Name : allusergroup Column Value : default Row 15 Evaluating column values axusersid = 1882990000000 axusersid = 1882990000000 column1 - evaluating expression dbrow = 15 column1 = 15 column1 = 15 username = 1cvkamath@gmail.com username = 1cvkamath@gmail.com nickname = C V Kamath nickname = C V Kamath email = soma_sundari@yahoo.com email = soma_sundari@yahoo.com mobile = mobile = allusergroup = client allusergroup = client Creating Row Row No15 Created Displaying columns Column Name : axusersid Column Value : 1882990000000 Column Name : column1 Column Value : 15 Column Name : username Column Value : 1cvkamath@gmail.com Column Name : nickname Column Value : C V Kamath Column Name : email Column Value : soma_sundari@yahoo.com Column Name : mobile Column Value : Column Name : allusergroup Column Value : client Row 16 Evaluating column values axusersid = 1884660000000 axusersid = 1884660000000 column1 - evaluating expression dbrow = 16 column1 = 16 column1 = 16 username = 11akhilvis@gmail.com username = 11akhilvis@gmail.com nickname = Akhil Vishwanatham nickname = Akhil Vishwanatham email = 1c_11akhilvis@gmail.com email = 1c_11akhilvis@gmail.com mobile = 7904362037 mobile = 7904362037 allusergroup = client allusergroup = client Creating Row Row No16 Created Displaying columns Column Name : axusersid Column Value : 1884660000000 Column Name : column1 Column Value : 16 Column Name : username Column Value : 11akhilvis@gmail.com Column Name : nickname Column Value : Akhil Vishwanatham Column Name : email Column Value : 1c_11akhilvis@gmail.com Column Name : mobile Column Value : 7904362037 Column Name : allusergroup Column Value : client Row 17 Evaluating column values axusersid = 1888880000000 axusersid = 1888880000000 column1 - evaluating expression dbrow = 17 column1 = 17 column1 = 17 username = 11arvind@compactups.com username = 11arvind@compactups.com nickname = Aravindan R nickname = Aravindan R email = 11arvind@compactups.com email = 11arvind@compactups.com mobile = mobile = allusergroup = client allusergroup = client Creating Row Row No17 Created Displaying columns Column Name : axusersid Column Value : 1888880000000 Column Name : column1 Column Value : 17 Column Name : username Column Value : 11arvind@compactups.com Column Name : nickname Column Value : Aravindan R Column Name : email Column Value : 11arvind@compactups.com Column Name : mobile Column Value : Column Name : allusergroup Column Value : client Row 18 Evaluating column values axusersid = 1025330000000 axusersid = 1025330000000 column1 - evaluating expression dbrow = 18 column1 = 18 column1 = 18 username = vaidheesh username = vaidheesh nickname = vaidheesh nickname = vaidheesh email = vaidheesh@agile-labs.com email = vaidheesh@agile-labs.com mobile = mobile = allusergroup = default allusergroup = default Creating Row Row No18 Created Displaying columns Column Name : axusersid Column Value : 1025330000000 Column Name : column1 Column Value : 18 Column Name : username Column Value : vaidheesh Column Name : nickname Column Value : vaidheesh Column Name : email Column Value : vaidheesh@agile-labs.com Column Name : mobile Column Value : Column Name : allusergroup Column Value : default Row 19 Evaluating column values axusersid = 1361880000000 axusersid = 1361880000000 column1 - evaluating expression dbrow = 19 column1 = 19 column1 = 19 username = soma username = soma nickname = Soma nickname = Soma email = soma@trustlineindia.com email = soma@trustlineindia.com mobile = mobile = allusergroup = trustlineadmin allusergroup = trustlineadmin Creating Row Row No19 Created Displaying columns Column Name : axusersid Column Value : 1361880000000 Column Name : column1 Column Value : 19 Column Name : username Column Value : soma Column Name : nickname Column Value : Soma Column Name : email Column Value : soma@trustlineindia.com Column Name : mobile Column Value : Column Name : allusergroup Column Value : trustlineadmin Rehiding column axusersid Rehiding column column1 Rehiding column username Rehiding column nickname Rehiding column email Rehiding column mobile Rehiding column allusergroup Storing subtotals Storing subtotals at : E:\Axpert113\Axpert Web\AxpertWebScripts\Axpert\gmyjcxxozanv2o1zo21ssfaf\axusers.lst Time elapsed = 406 Total Time elapsed = 422 Creating Report Header/Footer Creating Report Header/Footer over select cvalue, elements from templates where type='Iview' and iviewid = 'axusers' Time elapsed = 3 Iview result :{"data":{"reporthf":{},"headrow":{"rowno":{"@hide":"false"},"axrowtype":{"@hide":"true","@width":"80","@dec":"0","@type":"c","#text":"axrowtype"},"axp__font":{"@hide":"true","@width":"80","@dec":"0","@type":"c","#text":"axp__fontdetails"},"axusersid":{"#text":"axusersid","@width":"80","@dec":"0","@align":"Right","@type":"n","@freezecol":"F","@hide":"true"},"column1":{"#text":"axp_slno","@width":"80","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"},"username":{"#text":"Login Username","@width":"150","@dec":"0","@align":"Left","@type":"c","@hlink":"taxusr","@pop":"False","@hltype":"load","@parentrefresh":"false","@readonly":"false","@map":"axusersID=:axusersid","@freezecol":"F","@hide":"false"},"nickname":{"#text":"Nick Name","@width":"180","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"},"email":{"#text":"Email","@width":"150","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"},"mobile":{"#text":"Mobile No.","@width":"100","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"},"allusergroup":{"#text":"Roles","@width":"180","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"}},"row":[{"rowno":"1","axusersid":"1890010000000","column1":"1","username":"11cr_pradeep@wabag.in","nickname":"Pradeep C R","email":"11cr_pradeep@wabag.in","mobile":"7032746004","allusergroup":"client"},{"rowno":"2","axusersid":"1882010000000","column1":"2","username":"1tkgovind@yahoo.com","nickname":"T K Govinda Rajan","email":"itsme.trustline@hotmail.com","mobile":"","allusergroup":"client"},{"rowno":"3","axusersid":"1889660000000","column1":"3","username":"11test@gmail.com","nickname":"Testing","email":"11test@gmail.com","mobile":"9111111111","allusergroup":"client"},{"rowno":"4","axusersid":"1890330000000","column1":"4","username":"11dalal.naozer@yahoo.com","nickname":"Naozer Cusrow Dalal 1","email":"vlaksi.d@agile-labs.com","mobile":"9820302953","allusergroup":"client"},{"rowno":"5","axusersid":"1882440000000","column1":"5","username":"1gomathi.u@gmail.com","nickname":"Gomathi Ulaganathan","email":"1gomathi.u@gmail.com","mobile":"","allusergroup":"client"},{"rowno":"6","axusersid":"1887220000000","column1":"6","username":"12test@gmail.com","nickname":"Testing 2","email":"reckhancia@gmail.com","mobile":"","allusergroup":"client"},{"rowno":"7","axusersid":"1025660000000","column1":"7","username":"rekhancia","nickname":"rekhancia","email":"rekhancia@agile-labs.com","mobile":"7904362037","allusergroup":"default"},{"rowno":"8","axusersid":"1890550000000","column1":"8","username":"11deepakdesai@hotmail.com","nickname":"Deepa Deepak Desai","email":"vlakshmi.d@agile-labs.com","mobile":"9823276852","allusergroup":"client"},{"rowno":"9","axusersid":"1359110000000","column1":"9","username":"merwinmanoharan","nickname":"Merwin Manoharan","email":"merwin@trustlineindia.com","mobile":"","allusergroup":"trustlineapprover"},{"rowno":"10","axusersid":"1386010000000","column1":"10","username":"tamil","nickname":"Tamil","email":"tamil@gmail.com","mobile":"","allusergroup":"trustlineadmin"},{"rowno":"11","axusersid":"1888440000000","column1":"11","username":"11anjalidevi61@yahoo.com","nickname":"Anjalidevi R","email":"11anjalidevi61@yahoo.com","mobile":"7904362037","allusergroup":"client"},{"rowno":"12","axusersid":"1891220000000","column1":"12","username":"11iraj1966@yahoo.com","nickname":"Usha Ratnakumari Rajakumar","email":"11iraj1966@yahoo.com","mobile":"7904362037","allusergroup":"client"},{"rowno":"13","axusersid":"1736990000000","column1":"13","username":"ramk","nickname":"Ramakrishnan","email":"ramk@gmail.com","mobile":"","allusergroup":"tlclientmaster"},{"rowno":"14","axusersid":"1025880000000","column1":"14","username":"devipriya","nickname":"devi","email":"devipriya@agile-labs.com","mobile":"9524122299","allusergroup":"default"},{"rowno":"15","axusersid":"1882990000000","column1":"15","username":"1cvkamath@gmail.com","nickname":"C V Kamath","email":"soma_sundari@yahoo.com","mobile":"","allusergroup":"client"},{"rowno":"16","axusersid":"1884660000000","column1":"16","username":"11akhilvis@gmail.com","nickname":"Akhil Vishwanatham","email":"1c_11akhilvis@gmail.com","mobile":"7904362037","allusergroup":"client"},{"rowno":"17","axusersid":"1888880000000","column1":"17","username":"11arvind@compactups.com","nickname":"Aravindan R","email":"11arvind@compactups.com","mobile":"","allusergroup":"client"},{"rowno":"18","axusersid":"1025330000000","column1":"18","username":"vaidheesh","nickname":"vaidheesh","email":"vaidheesh@agile-labs.com","mobile":"","allusergroup":"default"},{"rowno":"19","axusersid":"1361880000000","column1":"19","username":"soma","nickname":"Soma","email":"soma@trustlineindia.com","mobile":"","allusergroup":"trustlineadmin"}]},"reccount":{"reccount":"19"},"actualrows":{"actualrows":"19"}}#$?# GetIView webservice completed Time Used : 46.3715229568056 secs # 1#Saving to log insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('gmyjcxxozanv2o1zo21ssfaf','rekhancia',to_timestamp('20/05/2025 12:33:03','dd/mm/yyyy hh24:mi:ss'),to_timestamp('20/05/2025 12:33:04','dd/mm/yyyy hh24:mi:ss'),'axusers',0,'Get IView New','success',575,18,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 : 20/05/2025 12:33:04