Start Time : 26/05/2025 16:11:26
Get IviewObj from Cache, User: rekhancia Role:
Loading iview.aspx before post back (get and set parameters)
Get ListView 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-UAT![]()
INR1FFFsmtp.office365.com587portalneo@trustlineindia.com9IntFlo!!$$*1100000FF
SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2
uXDS\dopen\ Check intransaction
Time elapsed = 2
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_TLBusiness1025660000000FrekhanciadefaultdefaultFetdzm0ronr0phiio123xdwtwdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*5/26/2025 3:57:12 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/26/2025 3:57:12 pm*
axp_appschema=trustlineuat
axp_devschema=trustlineuataxdef
axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/
axp_connectionname=trustlineuat
sesid=etdzm0ronr0phiio123xdwtw
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
Sql : select props from lviews where lower(name)= :name order by blobno
Paramval : axusr
ParamTYpe : c
Param List : name
select props from lviews where lower(name)= :name order by blobno
uXDS\dopen\ Check intransaction
Time elapsed = 0
Step5
select username , config_data from axp_smartviews_config where ivname = 'axusr'
Time elapsed = 0
GetSmartViewSettings Result : {"all":{"views":{"main":{"design":[{"name":"pusername","width":239.23611900390625},{"name":"nickname","width":222.2395980078125},{"name":"email","width":251.87500450195313},{"name":"mobile","width":105.98959037841797},{"name":"build","width":62.77778312744141},{"name":"debug","width":73.68056175292969},{"name":"manage","width":62.70834037841797},{"name":"workflow","width":57.30903312744141},{"name":"tools","width":50.81597587646485},{"name":"actflag","width":54.84375450195313},{"name":"dhomepage","width":58.78472587646485},{"name":"ipaddr","width":100.52084037841797},{"name":"createdby","width":81.66667625488282},{"name":"createdon","width":163.92361900390625},{"name":"username","width":148.09029075683594},{"name":"modifiedon","width":120.5208480078125}],"applyTo":"ALL","groupName":"main","caption":"main"}}}}
Select cvalue from axpconfigsiv_axusr where configname= 'groupbtns'
CDS Open Error Msg : csd query : Select cvalue from axpconfigsiv_axusr where configname= 'groupbtns' $ Error msg : relation "axpconfigsiv_axusr" does not exist
uXDS\open\ Exceptio relation "axpconfigsiv_axusr" 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=axusr
sname=axusr
uname=rekhancia
structure_type=iview
sname=axusr
structure_type=iview
Time elapsed = 0
GetParamsNew webservice completed
# 1#Saving to log
insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('etdzm0ronr0phiio123xdwtw','rekhancia',to_timestamp('26/05/2025 16:11:26','dd/mm/yyyy hh24:mi:ss'),to_timestamp('26/05/2025 16:11:26','dd/mm/yyyy hh24:mi:ss'),null,0,'Getting IView Params New','success',176,8,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 = 1
select props from axprops where lower(name)='app' order by blobno
uXDS\dopen\ Check intransaction
Time elapsed = 4
axprops xml = images\Agile-TrustLine-UAT![]()
INR1FFFsmtp.office365.com587portalneo@trustlineindia.com9IntFlo!!$$*1100000FF
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\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_TLBusiness1025660000000FrekhanciadefaultdefaultFetdzm0ronr0phiio123xdwtwdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*5/26/2025 3:57:12 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/26/2025 3:57:12 pm*
axp_appschema=trustlineuat
axp_devschema=trustlineuataxdef
axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/
axp_connectionname=trustlineuat
sesid=etdzm0ronr0phiio123xdwtw
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 - axusr
Going to change sql
Original SQL : select a1.axusersid recordid,a1.wkid,a1.app_desc,a1.cancel ,a1.cancelremarks ,a1.createdby ,a1.createdon ,a1.username ,a1.modifiedon , a1.transid, a1.usernameasemailid, a1.usertype, a1.portal_general_chk, a1.pusername, a1.nickname, a1.ppassword, a1.groupno, a1.email, a1.mobile, a1.client_details, a1.department, a1.build, a1.debug, a1.manage, a1.workflow, a1.login_username, a1.login_usergroup, a1.send, a1.importstruct, a1.isfirsttime, a1.pageaccess, a1.reportingto, a1.webskin, a1.logintry, a1.pwdexpdays, a1.language_access, a1.language, a1.exportstruct, a1.axpertmanager, a1.accesscode, a1.appparams, a1.appmanager, a1.tools, a1.actflag, a1.allusergroup, a1.global_displaytext, a1.dhomepage, a1.homepage, a1.isIp, a1.reset_update_flag, a1.ipaddr, a1.reporting_to, a1.empid, a1.otpauth, a1.pwdauth from axusers a1 where a1.transid='axusr' {viewfilter} order by a1.modifiedon desc
Going to AddListViewCont
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : axusr
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
uXDS\dopen\ Check intransaction
Time elapsed = 4
Step5
select ' '::varchar(250) as lval
Time elapsed = 2
select ' '::varchar(250) as lval
Time elapsed = 1
Evaluating {and((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 and ?portal_general_chk = 'General' )}
Result = and((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 and ?portal_general_chk = 'General' )
AddListViewCont Completed
Result SQL : select a1.axusersid recordid,a1.wkid,a1.app_desc,a1.cancel ,a1.cancelremarks ,a1.createdby ,a1.createdon ,a1.username ,a1.modifiedon , a1.transid, a1.usernameasemailid, a1.usertype, a1.portal_general_chk, a1.pusername, a1.nickname, a1.ppassword, a1.groupno, a1.email, a1.mobile, a1.client_details, a1.department, a1.build, a1.debug, a1.manage, a1.workflow, a1.login_username, a1.login_usergroup, a1.send, a1.importstruct, a1.isfirsttime, a1.pageaccess, a1.reportingto, a1.webskin, a1.logintry, a1.pwdexpdays, a1.language_access, a1.language, a1.exportstruct, a1.axpertmanager, a1.accesscode, a1.appparams, a1.appmanager, a1.tools, a1.actflag, a1.allusergroup, a1.global_displaytext, a1.dhomepage, a1.homepage, a1.isIp, a1.reset_update_flag, a1.ipaddr, a1.reporting_to, a1.empid, a1.otpauth, a1.pwdauth from axusers a1 where a1.transid='axusr' {viewfilter} order by a1.modifiedon desc
Changed sql after filter and sort condition inserted : select a1.axusersid recordid,a1.wkid,a1.app_desc,a1.cancel ,a1.cancelremarks ,a1.createdby ,a1.createdon ,a1.username ,a1.modifiedon , a1.transid, a1.usernameasemailid, a1.usertype, a1.portal_general_chk, a1.pusername, a1.nickname, a1.ppassword, a1.groupno, a1.email, a1.mobile, a1.client_details, a1.department, a1.build, a1.debug, a1.manage, a1.workflow, a1.login_username, a1.login_usergroup, a1.send, a1.importstruct, a1.isfirsttime, a1.pageaccess, a1.reportingto, a1.webskin, a1.logintry, a1.pwdexpdays, a1.language_access, a1.language, a1.exportstruct, a1.axpertmanager, a1.accesscode, a1.appparams, a1.appmanager, a1.tools, a1.actflag, a1.allusergroup, a1.global_displaytext, a1.dhomepage, a1.homepage, a1.isIp, a1.reset_update_flag, a1.ipaddr, a1.reporting_to, a1.empid, a1.otpauth, a1.pwdauth from axusers a1 where a1.transid='axusr' {viewfilter} order by a1.modifiedon desc
Change sql completed
Initializing Report
Preparing SQL statements
Assigning values to IView parameters
Filling dynamic params
select a1.axusersid recordid,a1.wkid,a1.app_desc,a1.cancel ,a1.cancelremarks ,a1.createdby ,a1.createdon ,a1.username ,a1.modifiedon , a1.transid, a1.usernameasemailid, a1.usertype, a1.portal_general_chk, a1.pusername, a1.nickname, a1.ppassword, a1.groupno, a1.email, a1.mobile, a1.client_details, a1.department, a1.build, a1.debug, a1.manage, a1.workflow, a1.login_username, a1.login_usergroup, a1.send, a1.importstruct, a1.isfirsttime, a1.pageaccess, a1.reportingto, a1.webskin, a1.logintry, a1.pwdexpdays, a1.language_access, a1.language, a1.exportstruct, a1.axpertmanager, a1.accesscode, a1.appparams, a1.appmanager, a1.tools, a1.actflag, a1.allusergroup, a1.global_displaytext, a1.dhomepage, a1.homepage, a1.isIp, a1.reset_update_flag, a1.ipaddr, a1.reporting_to, a1.empid, a1.otpauth, a1.pwdauth from axusers a1 where a1.transid='axusr' {viewfilter} order by a1.modifiedon desc
usergroup(c)=default
usergroup=default
usergroup(c)=default
Creating Columns
Creating Columns for first time
Creating transid
sourcepusername
Creating usernameasemailid
sourcepusername
Creating usertype
sourcepusername
Creating portal_general_chk
sourcepusername
Creating pusername
sourcepusername
Creating nickname
sourcepusername
Creating ppassword
sourcepusername
Creating groupno
sourcepusername
Creating email
sourcepusername
Creating mobile
sourcepusername
Creating client_details
sourcepusername
Creating department
sourcepusername
Creating build
sourcepusername
Creating debug
sourcepusername
Creating manage
sourcepusername
Creating workflow
sourcepusername
Creating login_username
sourcepusername
Creating login_usergroup
sourcepusername
Creating send
sourcepusername
Creating importstruct
sourcepusername
Creating isfirsttime
sourcepusername
Creating pageaccess
sourcepusername
Creating reportingto
sourcepusername
Creating webskin
sourcepusername
Creating logintry
sourcepusername
Creating pwdexpdays
sourcepusername
Creating language_access
sourcepusername
Creating language
sourcepusername
Creating exportstruct
sourcepusername
Creating axpertmanager
sourcepusername
Creating accesscode
sourcepusername
Creating appparams
sourcepusername
Creating appmanager
sourcepusername
Creating tools
sourcepusername
Creating actflag
sourcepusername
Creating allusergroup
sourcepusername
Creating global_displaytext
sourcepusername
Creating dhomepage
sourcepusername
Creating homepage
sourcepusername
Creating isIp
sourcepusername
Creating reset_update_flag
sourcepusername
Creating ipaddr
sourcepusername
Creating reporting_to
sourcepusername
Creating empid
sourcepusername
Creating otpauth
sourcepusername
Creating pwdauth
sourcepusername
Creating recordid
sourcepusername
Creating app_desc
sourcepusername
Creating createdby
sourcepusername
Creating createdon
sourcepusername
Creating username
sourcepusername
Creating modifiedon
sourcepusername
Creating cancel
sourcepusername
Creating cancelremarks
sourcepusername
Creating Columns for first time completed
select a1.axusersid recordid,a1.wkid,a1.app_desc,a1.cancel ,a1.cancelremarks ,a1.createdby ,a1.createdon ,a1.username ,a1.modifiedon , a1.transid, a1.usernameasemailid, a1.usertype, a1.portal_general_chk, a1.pusername, a1.nickname, a1.ppassword, a1.groupno, a1.email, a1.mobile, a1.client_details, a1.department, a1.build, a1.debug, a1.manage, a1.workflow, a1.login_username, a1.login_usergroup, a1.send, a1.importstruct, a1.isfirsttime, a1.pageaccess, a1.reportingto, a1.webskin, a1.logintry, a1.pwdexpdays, a1.language_access, a1.language, a1.exportstruct, a1.axpertmanager, a1.accesscode, a1.appparams, a1.appmanager, a1.tools, a1.actflag, a1.allusergroup, a1.global_displaytext, a1.dhomepage, a1.homepage, a1.isIp, a1.reset_update_flag, a1.ipaddr, a1.reporting_to, a1.empid, a1.otpauth, a1.pwdauth from axusers a1 where a1.transid='axusr' and((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 and ?portal_general_chk = 'General' ) order by a1.modifiedon desc LIMIT 25
usergroup=default
usergroup=default
CDS Open Error Msg : csd query : select a1.axusersid recordid,a1.wkid,a1.app_desc,a1.cancel ,a1.cancelremarks ,a1.createdby ,a1.createdon ,a1.username ,a1.modifiedon , a1.transid, a1.usernameasemailid, a1.usertype, a1.portal_general_chk, a1.pusername, a1.nickname, a1.ppassword, a1.groupno, a1.email, a1.mobile, a1.client_details, a1.department, a1.build, a1.debug, a1.manage, a1.workflow, a1.login_username, a1.login_usergroup, a1.send, a1.importstruct, a1.isfirsttime, a1.pageaccess, a1.reportingto, a1.webskin, a1.logintry, a1.pwdexpdays, a1.language_access, a1.language, a1.exportstruct, a1.axpertmanager, a1.accesscode, a1.appparams, a1.appmanager, a1.tools, a1.actflag, a1.allusergroup, a1.global_displaytext, a1.dhomepage, a1.homepage, a1.isIp, a1.reset_update_flag, a1.ipaddr, a1.reporting_to, a1.empid, a1.otpauth, a1.pwdauth from axusers a1 where a1.transid='axusr' and((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 and ?portal_general_chk = 'General' ) order by a1.modifiedon desc LIMIT 25 $ Error msg : column "?portal_general_chk" does not exist
uXDS\open\ Exceptio column "?portal_general_chk" does not exist
Exception on Show Iview :column "?portal_general_chk" does not exist
Error message - column "?portal_general_chk" does not exist
GetIView webservice completed
Time Used : 46.1626746094213 secs
# 1#Saving to log
insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('etdzm0ronr0phiio123xdwtw','rekhancia',to_timestamp('26/05/2025 16:11:26','dd/mm/yyyy hh24:mi:ss'),to_timestamp('26/05/2025 16:11:26','dd/mm/yyyy hh24:mi:ss'),'axusr',0,'Get IView New','column "?portal_general_chk" does not exist',360,17,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
End Time : 26/05/2025 16:11:26
Get IviewObj from Cache, User: rekhancia Role:
Loading iview.aspx before post back (get and set parameters)
Get ListView 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 = 1
select props from axprops where lower(name)='app' order by blobno
uXDS\dopen\ Check intransaction
Time elapsed = 4
axprops xml = images\Agile-TrustLine-UAT![]()
INR1FFFsmtp.office365.com587portalneo@trustlineindia.com9IntFlo!!$$*1100000FF
SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2
uXDS\dopen\ Check intransaction
Time elapsed = 2
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_TLBusiness1025660000000FrekhanciadefaultdefaultFetdzm0ronr0phiio123xdwtwdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*5/26/2025 3:57:12 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/26/2025 3:57:12 pm*
axp_appschema=trustlineuat
axp_devschema=trustlineuataxdef
axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/
axp_connectionname=trustlineuat
sesid=etdzm0ronr0phiio123xdwtw
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
Sql : select props from lviews where lower(name)= :name order by blobno
Paramval : axusr
ParamTYpe : c
Param List : name
select props from lviews where lower(name)= :name order by blobno
uXDS\dopen\ Check intransaction
Time elapsed = 0
Step5
select username , config_data from axp_smartviews_config where ivname = 'axusr'
Time elapsed = 0
GetSmartViewSettings Result : {"all":{"views":{"main":{"design":[{"name":"pusername","width":239.23611900390625},{"name":"nickname","width":222.2395980078125},{"name":"email","width":251.87500450195313},{"name":"mobile","width":105.98959037841797},{"name":"build","width":62.77778312744141},{"name":"debug","width":73.68056175292969},{"name":"manage","width":62.70834037841797},{"name":"workflow","width":57.30903312744141},{"name":"tools","width":50.81597587646485},{"name":"actflag","width":54.84375450195313},{"name":"dhomepage","width":58.78472587646485},{"name":"ipaddr","width":100.52084037841797},{"name":"createdby","width":81.66667625488282},{"name":"createdon","width":163.92361900390625},{"name":"username","width":148.09029075683594},{"name":"modifiedon","width":120.5208480078125}],"applyTo":"ALL","groupName":"main","caption":"main"}}}}
Select cvalue from axpconfigsiv_axusr where configname= 'groupbtns'
CDS Open Error Msg : csd query : Select cvalue from axpconfigsiv_axusr where configname= 'groupbtns' $ Error msg : relation "axpconfigsiv_axusr" does not exist
uXDS\open\ Exceptio relation "axpconfigsiv_axusr" 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=axusr
sname=axusr
uname=rekhancia
structure_type=iview
sname=axusr
structure_type=iview
Time elapsed = 16
GetParamsNew webservice completed
# 1#Saving to log
insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('etdzm0ronr0phiio123xdwtw','rekhancia',to_timestamp('26/05/2025 16:11:36','dd/mm/yyyy hh24:mi:ss'),to_timestamp('26/05/2025 16:11:36','dd/mm/yyyy hh24:mi:ss'),null,0,'Getting IView Params New','success',164,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
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 = 2
select props from axprops where lower(name)='app' order by blobno
uXDS\dopen\ Check intransaction
Time elapsed = 4
axprops xml = images\Agile-TrustLine-UAT![]()
INR1FFFsmtp.office365.com587portalneo@trustlineindia.com9IntFlo!!$$*1100000FF
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\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_TLBusiness1025660000000FrekhanciadefaultdefaultFetdzm0ronr0phiio123xdwtwdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*5/26/2025 3:57:12 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/26/2025 3:57:12 pm*
axp_appschema=trustlineuat
axp_devschema=trustlineuataxdef
axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/
axp_connectionname=trustlineuat
sesid=etdzm0ronr0phiio123xdwtw
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 - axusr
Going to change sql
Original SQL : select a1.axusersid recordid,a1.wkid,a1.app_desc,a1.cancel ,a1.cancelremarks ,a1.createdby ,a1.createdon ,a1.username ,a1.modifiedon , a1.transid, a1.usernameasemailid, a1.usertype, a1.portal_general_chk, a1.pusername, a1.nickname, a1.ppassword, a1.groupno, a1.email, a1.mobile, a1.client_details, a1.department, a1.build, a1.debug, a1.manage, a1.workflow, a1.login_username, a1.login_usergroup, a1.send, a1.importstruct, a1.isfirsttime, a1.pageaccess, a1.reportingto, a1.webskin, a1.logintry, a1.pwdexpdays, a1.language_access, a1.language, a1.exportstruct, a1.axpertmanager, a1.accesscode, a1.appparams, a1.appmanager, a1.tools, a1.actflag, a1.allusergroup, a1.global_displaytext, a1.dhomepage, a1.homepage, a1.isIp, a1.reset_update_flag, a1.ipaddr, a1.reporting_to, a1.empid, a1.otpauth, a1.pwdauth from axusers a1 where a1.transid='axusr' {viewfilter} order by a1.modifiedon desc
Going to AddListViewCont
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : axusr
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
uXDS\dopen\ Check intransaction
Time elapsed = 3
Step5
select ' '::varchar(250) as lval
Time elapsed = 2
select ' '::varchar(250) as lval
Time elapsed = 1
Evaluating {and((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 and ?portal_general_chk = 'General' )}
Result = and((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 and ?portal_general_chk = 'General' )
AddListViewCont Completed
Result SQL : select a1.axusersid recordid,a1.wkid,a1.app_desc,a1.cancel ,a1.cancelremarks ,a1.createdby ,a1.createdon ,a1.username ,a1.modifiedon , a1.transid, a1.usernameasemailid, a1.usertype, a1.portal_general_chk, a1.pusername, a1.nickname, a1.ppassword, a1.groupno, a1.email, a1.mobile, a1.client_details, a1.department, a1.build, a1.debug, a1.manage, a1.workflow, a1.login_username, a1.login_usergroup, a1.send, a1.importstruct, a1.isfirsttime, a1.pageaccess, a1.reportingto, a1.webskin, a1.logintry, a1.pwdexpdays, a1.language_access, a1.language, a1.exportstruct, a1.axpertmanager, a1.accesscode, a1.appparams, a1.appmanager, a1.tools, a1.actflag, a1.allusergroup, a1.global_displaytext, a1.dhomepage, a1.homepage, a1.isIp, a1.reset_update_flag, a1.ipaddr, a1.reporting_to, a1.empid, a1.otpauth, a1.pwdauth from axusers a1 where a1.transid='axusr' {viewfilter} order by a1.modifiedon desc
Changed sql after filter and sort condition inserted : select a1.axusersid recordid,a1.wkid,a1.app_desc,a1.cancel ,a1.cancelremarks ,a1.createdby ,a1.createdon ,a1.username ,a1.modifiedon , a1.transid, a1.usernameasemailid, a1.usertype, a1.portal_general_chk, a1.pusername, a1.nickname, a1.ppassword, a1.groupno, a1.email, a1.mobile, a1.client_details, a1.department, a1.build, a1.debug, a1.manage, a1.workflow, a1.login_username, a1.login_usergroup, a1.send, a1.importstruct, a1.isfirsttime, a1.pageaccess, a1.reportingto, a1.webskin, a1.logintry, a1.pwdexpdays, a1.language_access, a1.language, a1.exportstruct, a1.axpertmanager, a1.accesscode, a1.appparams, a1.appmanager, a1.tools, a1.actflag, a1.allusergroup, a1.global_displaytext, a1.dhomepage, a1.homepage, a1.isIp, a1.reset_update_flag, a1.ipaddr, a1.reporting_to, a1.empid, a1.otpauth, a1.pwdauth from axusers a1 where a1.transid='axusr' {viewfilter} order by a1.modifiedon desc
Change sql completed
Initializing Report
Preparing SQL statements
Assigning values to IView parameters
Filling dynamic params
select a1.axusersid recordid,a1.wkid,a1.app_desc,a1.cancel ,a1.cancelremarks ,a1.createdby ,a1.createdon ,a1.username ,a1.modifiedon , a1.transid, a1.usernameasemailid, a1.usertype, a1.portal_general_chk, a1.pusername, a1.nickname, a1.ppassword, a1.groupno, a1.email, a1.mobile, a1.client_details, a1.department, a1.build, a1.debug, a1.manage, a1.workflow, a1.login_username, a1.login_usergroup, a1.send, a1.importstruct, a1.isfirsttime, a1.pageaccess, a1.reportingto, a1.webskin, a1.logintry, a1.pwdexpdays, a1.language_access, a1.language, a1.exportstruct, a1.axpertmanager, a1.accesscode, a1.appparams, a1.appmanager, a1.tools, a1.actflag, a1.allusergroup, a1.global_displaytext, a1.dhomepage, a1.homepage, a1.isIp, a1.reset_update_flag, a1.ipaddr, a1.reporting_to, a1.empid, a1.otpauth, a1.pwdauth from axusers a1 where a1.transid='axusr' {viewfilter} order by a1.modifiedon desc
usergroup(c)=default
usergroup=default
usergroup(c)=default
Creating Columns
Creating Columns for first time
Creating transid
sourcepusername
Creating usernameasemailid
sourcepusername
Creating usertype
sourcepusername
Creating portal_general_chk
sourcepusername
Creating pusername
sourcepusername
Creating nickname
sourcepusername
Creating ppassword
sourcepusername
Creating groupno
sourcepusername
Creating email
sourcepusername
Creating mobile
sourcepusername
Creating client_details
sourcepusername
Creating department
sourcepusername
Creating build
sourcepusername
Creating debug
sourcepusername
Creating manage
sourcepusername
Creating workflow
sourcepusername
Creating login_username
sourcepusername
Creating login_usergroup
sourcepusername
Creating send
sourcepusername
Creating importstruct
sourcepusername
Creating isfirsttime
sourcepusername
Creating pageaccess
sourcepusername
Creating reportingto
sourcepusername
Creating webskin
sourcepusername
Creating logintry
sourcepusername
Creating pwdexpdays
sourcepusername
Creating language_access
sourcepusername
Creating language
sourcepusername
Creating exportstruct
sourcepusername
Creating axpertmanager
sourcepusername
Creating accesscode
sourcepusername
Creating appparams
sourcepusername
Creating appmanager
sourcepusername
Creating tools
sourcepusername
Creating actflag
sourcepusername
Creating allusergroup
sourcepusername
Creating global_displaytext
sourcepusername
Creating dhomepage
sourcepusername
Creating homepage
sourcepusername
Creating isIp
sourcepusername
Creating reset_update_flag
sourcepusername
Creating ipaddr
sourcepusername
Creating reporting_to
sourcepusername
Creating empid
sourcepusername
Creating otpauth
sourcepusername
Creating pwdauth
sourcepusername
Creating recordid
sourcepusername
Creating app_desc
sourcepusername
Creating createdby
sourcepusername
Creating createdon
sourcepusername
Creating username
sourcepusername
Creating modifiedon
sourcepusername
Creating cancel
sourcepusername
Creating cancelremarks
sourcepusername
Creating Columns for first time completed
select a1.axusersid recordid,a1.wkid,a1.app_desc,a1.cancel ,a1.cancelremarks ,a1.createdby ,a1.createdon ,a1.username ,a1.modifiedon , a1.transid, a1.usernameasemailid, a1.usertype, a1.portal_general_chk, a1.pusername, a1.nickname, a1.ppassword, a1.groupno, a1.email, a1.mobile, a1.client_details, a1.department, a1.build, a1.debug, a1.manage, a1.workflow, a1.login_username, a1.login_usergroup, a1.send, a1.importstruct, a1.isfirsttime, a1.pageaccess, a1.reportingto, a1.webskin, a1.logintry, a1.pwdexpdays, a1.language_access, a1.language, a1.exportstruct, a1.axpertmanager, a1.accesscode, a1.appparams, a1.appmanager, a1.tools, a1.actflag, a1.allusergroup, a1.global_displaytext, a1.dhomepage, a1.homepage, a1.isIp, a1.reset_update_flag, a1.ipaddr, a1.reporting_to, a1.empid, a1.otpauth, a1.pwdauth from axusers a1 where a1.transid='axusr' and((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 and ?portal_general_chk = 'General' ) order by a1.modifiedon desc LIMIT 25
usergroup=default
usergroup=default
CDS Open Error Msg : csd query : select a1.axusersid recordid,a1.wkid,a1.app_desc,a1.cancel ,a1.cancelremarks ,a1.createdby ,a1.createdon ,a1.username ,a1.modifiedon , a1.transid, a1.usernameasemailid, a1.usertype, a1.portal_general_chk, a1.pusername, a1.nickname, a1.ppassword, a1.groupno, a1.email, a1.mobile, a1.client_details, a1.department, a1.build, a1.debug, a1.manage, a1.workflow, a1.login_username, a1.login_usergroup, a1.send, a1.importstruct, a1.isfirsttime, a1.pageaccess, a1.reportingto, a1.webskin, a1.logintry, a1.pwdexpdays, a1.language_access, a1.language, a1.exportstruct, a1.axpertmanager, a1.accesscode, a1.appparams, a1.appmanager, a1.tools, a1.actflag, a1.allusergroup, a1.global_displaytext, a1.dhomepage, a1.homepage, a1.isIp, a1.reset_update_flag, a1.ipaddr, a1.reporting_to, a1.empid, a1.otpauth, a1.pwdauth from axusers a1 where a1.transid='axusr' and((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 and ?portal_general_chk = 'General' ) order by a1.modifiedon desc LIMIT 25 $ Error msg : column "?portal_general_chk" does not exist
uXDS\open\ Exceptio column "?portal_general_chk" does not exist
Exception on Show Iview :column "?portal_general_chk" does not exist
Error message - column "?portal_general_chk" does not exist
GetIView webservice completed
Time Used : 46.1576747256597 secs
# 1#Saving to log
insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('etdzm0ronr0phiio123xdwtw','rekhancia',to_timestamp('26/05/2025 16:11:36','dd/mm/yyyy hh24:mi:ss'),to_timestamp('26/05/2025 16:11:36','dd/mm/yyyy hh24:mi:ss'),'axusr',0,'Get IView New','column "?portal_general_chk" does not exist',355,17,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
End Time : 26/05/2025 16:11:36