Start Time : 08/08/2025 08:22:06
Loading Structure.
Get Struct from Cache Manager. User: soma Role: trustlineadmin
Getting Structure from Redis soma Role: trustlineadmin
Getting structure from Cache.
Recordid = 1888440000000
Loading Tstruct.
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(240325)]
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 = 3
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 Quick LoadData 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_TLBusiness1026110000000FsomatrustlineadmintrustlineadminFwdb13p5hjbqdpknjitjnv1fytrustlineadmin~100trustlineuattrustlineuat0trustlineadminhttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-in*asia/calcutta^english*8/8/2025 8:03:17 am*4894~~9867~75~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-in*asia/calcutta^english*8/8/2025 8:03:17 am*4894
axp_appschema=trustlineuat
axp_devschema=trustlineuataxdef
axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/
axp_connectionname=trustlineuat
sesid=wdb13p5hjbqdpknjitjnv1fy
ax_evalcopy=F
rolename=trustlineadmin
responsibilies=trustlineadmin
millions=F
axpimageserver=
axglo_hide=
axp_displaytext=
axglo_user=
fromuserlogin=
axglo_recordid=1026110000000
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~75~0~0~1~R~false~R
LReg Type : R
User Group trustlineadmin
User Roles trustlineadmin
Registering app/user variables for the session completed
select sessionid from connections where sessionid = :sesid
uXDS\dopen\ Check intransaction
Time elapsed = 3
Creating DbCall
select ' '::varchar(250) as lval
Time elapsed = 2
select ' '::varchar(250) as lval
Time elapsed = 1
select * from axusers where axusersid=0
Time elapsed = 6
Evaluating {axusr}
Result =
Evaluating {T}
Result =
Evaluating {ADMIN}
Result =
Evaluating {General}
Result =
Evaluating iif(getlength(pusername) < 4,{User ID should have minmum length of 4 digits},{T})
Result =
Evaluating {12345}
Result =
Evaluating iif( recordid = 0, iif(axp_md5pwd = {T},convertmd5(pwd), Encryptstr(pwd)), ppassword)
Result =
Evaluating username
Result =
Evaluating iif(usernameasemailid={T},pusername,email)
Result =
Evaluating iif(((isempty(mobile) = {F}) & getlength(mobile)#10),{ Invalid mobile number (should contain 10 digits)}, iif(((isempty(mobile) = {F}) & substr(mobile,1,1)#{7} & substr(mobile,1,1)#{8} & substr(mobile,1,1)#{9}),{ Invalid mobile number (should be starting with 7/8/9)},{T}))
Result =
Evaluating {F}
Result =
Evaluating build
Result =
Evaluating {F}
Result =
Evaluating username
Result =
Evaluating {F}
Result =
Evaluating usergroup
Result =
Evaluating {F}
Result =
Evaluating {F}
Result =
Evaluating {F}
Result =
Evaluating {F}
Result =
Evaluating {F}
Result =
Evaluating {F}
Result =
Evaluating {T}
Result =
Evaluating actflag
Result =
Evaluating getallvalues({axusergroup},{F})
Result =
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 =
Evaluating {T}
Result =
Evaluating {F}
Result =
Evaluating {F}
Result =
Evaluating iif(((getlength(ipaddr) = 0) & (isIp = {T})),{ cannot be left empty},{T})
Result =
Evaluating {T}
Result =
Evaluating {F}
Result =
Evaluating pusername
Result =
Evaluating Date()
Result =
Evaluating IIF( (isempty( axusergroup) = {F} & isempty( startdate) = {T}), {Assigned From should be specified for Additional Roles}, {T})
Result =
Evaluating IIF(isempty( enddate) = {T}, {T},iif( (ctod( startdate) > ctod( enddate)) , {End Date cannot be lesser than the start date}, {T}))
Result =
Evaluating iif(isempty(axusergroup)={F},{T},{F})
Result =
Creating Action object
Submiting & Registering data
Registering Global variables data
Registering Global variables data over
Setting values over
Record id : 1888440000000
Transid:axusr
recordid:1888440000000
primarytable:axusers
>>Loading transaction axusr record 1888440000000
Select a.axusersid, a.SourceId , a.mapname , a.cancel, a.cancelremarks , a.CreatedOn, a.CreatedBy , a.ModifiedOn , a.UserName , a.transid, a.usernameasemailid, a.usertype, a.portal_general_chk, a.pusername, a.nickname, a.ppassword, a.groupno, a.email, a.mobile, a.client_details, a.department, a.build, a.debug, a.manage, a.login_username, a.workflow, a.login_usergroup, a.send, a.importstruct, a.isfirsttime, a.pageaccess, a.reportingto, a.webskin, a.logintry, a.pwdexpdays, a.language_access, a.language, a.exportstruct, a.axpertmanager, a.accesscode, a.appparams, a.appmanager, a.tools, a.actflag, a.active, a.allusergroup, a.global_displaytext, a.dhomepage, a.homepage, a.reset_update_flag, a.isIp, a.ipaddr, a.reporting_to, a.empid, a.otpauth, a.pwdauth from AXUSERS a where a.axusersid = 1888440000000
Time elapsed = 5
Loading from 1888440000000 into frame 1, row 1
transid = ausrs
usernameasemailid =
usertype =
portal_general_chk = Portal
pusername = 11anjalidevi61@yahoo.com
nickname = Anjalidevi R
ppassword = f629f9236792c95b96b75b955a68206c
groupno = 0
email = 11anjalidevi61@yahoo.com
mobile =
client_details = 646:Anjalidevi R
department =
build = F
debug = F
manage = F
login_username = soma
workflow = F
login_usergroup = trustlineadmin
send = F
importstruct = F
isfirsttime =
pageaccess =
reportingto =
webskin =
logintry = 0
pwdexpdays = 0
language_access =
language =
exportstruct = F
axpertmanager =
accesscode =
appparams =
appmanager =
tools = F
actflag = T
active = T
allusergroup = client
global_displaytext =
dhomepage = None
homepage = 0
reset_update_flag = F
isIp =
ipaddr =
reporting_to =
empid =
otpauth = F
pwdauth = T
Select a.axuserlevelgroupsid, a.axusername, a.axusergroup, a.startdate, a.enddate,a.axuserlevelgroupsrow from AXUSERLEVELGROUPS a where a.axusersid = 1888440000000 Order by axuserlevelgroupsrow
Time elapsed = 0
Loading from 1888440000001 into frame 2, row 1
axusername = 11anjalidevi61@yahoo.com
axusergroup = client
startdate = 14/05/2025
enddate =
Loading no-save fields
Execute action from dbcall
Assigning approval bar
newmaxrow count=2
Preparing pwd-accept
Field Value - 12345
pwd = 12345
Result of encryptstr = 05000000F34AC2E6E09F3DD7DF3783698DC17A4A
pwd = 12345
Result of convertmd5 = 827ccb0eea8a706c4c34a16891f84e7b
axp_md5pwd = T
Result of iif = 827ccb0eea8a706c4c34a16891f84e7b
recordid = 1888440000000
ppassword = f629f9236792c95b96b75b955a68206c
Result of iif = f629f9236792c95b96b75b955a68206c
Preparing axuser-calculate
username = soma
Field Value - soma
build = F
username = soma
actflag = T
Result of getallvalues = client
Preparing viewfilter-calculate
Field Value - 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' )
Preparing tflag-accept
Field Value - T
Preparing axcloudtrigger-accept
select 'ALTER TRIGGER TR_AXCLOUD_USER_CREATION ENABLE' AS TR from dual
Time elapsed = 17
Query opened , Record count : 1
Field Value - ALTER TRIGGER TR_AXCLOUD_USER_CREATION ENABLE
pusername = 11anjalidevi61@yahoo.com
Preparing validrow2-calculate
axusergroup = client
Result of isempty = F
Result of iif = T
Field Value - T
Action node in structure : FalseDisable
Starting Action Execution - OnDataLoad
Executing task - field access
checkFillGrid :
Visible dcs :
Executing task field access over
Action Execution over - OnDataLoad
Action node in structure : if portal_general_chk = {Portal} AxHideControls({dhomepage}) AxHideControls({build}) AxHideControls({tools}) AxHideControls({workflow}) AxHideControls({importstruct}) AxHideControls({exportstruct}) AxHideControls({manage}) AxHideControls({debug}) AxDisableControls({pusername}) AxDisableControls({axusergroup}) AxDisableControls({startdate})end if
Starting Action Execution - script2
Executing task - scripts
Assigning expression set to parser
Expression : if portal_general_chk = {Portal}
AxHideControls({dhomepage})
AxHideControls({build})
AxHideControls({tools})
AxHideControls({workflow})
AxHideControls({importstruct})
AxHideControls({exportstruct})
AxHideControls({manage})
AxHideControls({debug})
AxDisableControls({pusername})
AxDisableControls({axusergroup})
AxDisableControls({startdate})
end if
Evaluating portal_general_chk = {Portal}
portal_general_chk = Portal
Result = 1
Evaluating AxHideControls({dhomepage})
Result =
Evaluating AxHideControls({build})
Result =
Evaluating AxHideControls({tools})
Result =
Evaluating AxHideControls({workflow})
Result =
Evaluating AxHideControls({importstruct})
Result =
Evaluating AxHideControls({exportstruct})
Result =
Evaluating AxHideControls({manage})
Result =
Evaluating AxHideControls({debug})
Result =
Evaluating AxDisableControls({pusername})
Result =
Evaluating AxDisableControls({axusergroup})
Result =
Evaluating AxDisableControls({startdate})
Result =
Executing task scripts over
Action Execution over - script2
Quick Load Data JSON
DC to JSON DC1
DC to JSON DC2
Field to JSON transid row 1
Field to JSON portal_general_chk row 1
Field to JSON pusername row 1
Field to JSON pwd row 1
Field to JSON nickname row 1
Field to JSON ppassword row 1
Field to JSON axuser row 1
Field to JSON groupno row 1
Field to JSON email row 1
Field to JSON client_details row 1
Field to JSON build row 1
Field to JSON debug row 1
Field to JSON manage row 1
Field to JSON login_username row 1
Field to JSON workflow row 1
Field to JSON login_usergroup row 1
Field to JSON send row 1
Field to JSON importstruct row 1
Field to JSON logintry row 1
Field to JSON pwdexpdays row 1
Field to JSON exportstruct row 1
Field to JSON axpertmanager row 1
Field to JSON appmanager row 1
Field to JSON tools row 1
Field to JSON actflag row 1
Field to JSON active row 1
Field to JSON allusergroup row 1
Field to JSON viewfilter row 1
Field to JSON tflag row 1
Field to JSON dhomepage row 1
Field to JSON homepage row 1
Field to JSON reset_update_flag row 1
Field to JSON isIp row 1
Field to JSON axcloudtrigger row 1
Field to JSON otpauth row 1
Field to JSON pwdauth row 1
Grid To JSON 2
Row Count 1
Existing Row Count 0
Field to JSON axusername row 1
Field to JSON axusergroup row 1
Field to JSON startdate row 1
Field to JSON validrow2 row 1
Quick Load Data JSON Completed
# 1#Executing GetAttachments
select distinct filename as fn from axusrattach where recordid = 1888440000000
uXDS\dopen\ Check intransaction
Time elapsed = 2
Result : {"data":[{"n":"DC1","v":"1","t":"dc"},{"n":"axp_recid1","v":"1888440000000","r":"0","t":"s"},{"n":"transid","v":"ausrs","r":"0","t":"s"},{"n":"portal_general_chk","v":"Portal","r":"0","idcol":"no","id":"0","oldid":"0","t":"c"},{"n":"pusername","v":"11anjalidevi61@yahoo.com","r":"0","t":"s"},{"n":"pwd","v":"12345","r":"0","t":"s"},{"n":"nickname","v":"Anjalidevi R","r":"0","t":"s"},{"n":"ppassword","v":"f629f9236792c95b96b75b955a68206c","r":"0","t":"s"},{"n":"axuser","v":"soma","r":"0","t":"s"},{"n":"groupno","v":"0","r":"0","t":"s"},{"n":"email","v":"11anjalidevi61@yahoo.com","r":"0","t":"s"},{"n":"client_details","v":"646:Anjalidevi R","r":"0","t":"m"},{"n":"build","v":"F","r":"0","t":"s"},{"n":"debug","v":"F","r":"0","t":"s"},{"n":"manage","v":"F","r":"0","t":"s"},{"n":"login_username","v":"soma","r":"0","t":"s"},{"n":"workflow","v":"F","r":"0","t":"s"},{"n":"login_usergroup","v":"trustlineadmin","r":"0","t":"s"},{"n":"send","v":"F","r":"0","t":"s"},{"n":"importstruct","v":"F","r":"0","t":"s"},{"n":"logintry","v":"0","r":"0","t":"s"},{"n":"pwdexpdays","v":"0","r":"0","t":"s"},{"n":"exportstruct","v":"F","r":"0","t":"s"},{"n":"axpertmanager","v":"","r":"0","t":"s"},{"n":"appmanager","v":"","r":"0","t":"s"},{"n":"tools","v":"F","r":"0","t":"s"},{"n":"actflag","v":"T","r":"0","t":"s"},{"n":"active","v":"T","r":"0","t":"s"},{"n":"allusergroup","v":"client","r":"0","t":"s"},{"n":"viewfilter","v":"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' )","r":"0","t":"s"},{"n":"tflag","v":"T","r":"0","t":"s"},{"n":"dhomepage","v":"None","r":"0","idcol":"no","id":"0","oldid":"0","t":"c"},{"n":"homepage","v":"0","r":"0","t":"s"},{"n":"reset_update_flag","v":"F","r":"0","t":"s"},{"n":"isIp","v":"","r":"0","t":"s"},{"n":"axcloudtrigger","v":"ALTER TRIGGER TR_AXCLOUD_USER_CREATION ENABLE","r":"0","t":"s"},{"n":"otpauth","v":"F","r":"0","t":"s"},{"n":"pwdauth","v":"T","r":"0","t":"s"},{"n":"DC2","v":"1","cr":"i1","t":"dc","hasdatarows":"yes"},{"n":"axp_recid2","v":"1888440000001","r":"1","t":"s"},{"n":"axusername","v":"11anjalidevi61@yahoo.com","r":"1","t":"s"},{"n":"axusergroup","v":"client","r":"1","idcol":"no","id":"0","oldid":"0","mr":"1","t":"c"},{"n":"startdate","v":"14/05/2025","r":"1","t":"s"},{"n":"validrow2","v":"T","r":"1","t":"s"}]}*$*{"formcontrol":[{"readonlytrans":"no"},{"fldname":"pusername000F0","fldact":"disable"},{"fldname":"pwd000F0","fldact":"disable"},{"fldname":"ppassword000F0","fldact":"disable"}]}
Quick LoadData webservice completed
Freeing DbCall Resources
Freeing Store data
Freeing DD Map
Freeing Provide Link
Freeing Validate
Freeing Parser
Freeing Poststr
Freeing Maxrows
Freeing Fnames
Freeing NewMaxRows
Freeing tlines
Freeing workquery
Freeing Struct
Freeing EventList
Freeing Tree Obj
Freeing Workflow Obj
Done - Workflow Obj
Freeing DbCall Completed
Freeing Action Obj Resources
# 1#Saving to log
insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('wdb13p5hjbqdpknjitjnv1fy','soma',to_timestamp('08/08/2025 08:22:06','dd/mm/yyyy hh24:mi:ss'),to_timestamp('08/08/2025 08:22:06','dd/mm/yyyy hh24:mi:ss'),'axusr',1888440000000,'Quick Load Data','success',397,43,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
Getting structure from Cache.
Loading tstruct.aspx completed
End Time : 08/08/2025 08:22:06