Start Time : 5/20/2025 12:33:39 PM
Load Data 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(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 = 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 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_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
Creating DbCall
select ' '::varchar(250) as lval
Time elapsed = 0
select * from axusers where axusersid=0
Time elapsed = 0
Evaluating {T}
Result =
Evaluating {axusr}
Result =
Evaluating {ADMIN}
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 {F}
Result =
Evaluating username
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 )}
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 {General}
Result =
Evaluating pusername
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 : 1884660000000
Transid:axusr
recordid:1884660000000
primarytable:axusers
>>Loading transaction axusr record 1884660000000
Select a.axusersid, a.SourceId , a.mapname , a.cancel, a.cancelremarks , a.CreatedOn, a.CreatedBy , a.ModifiedOn , a.UserName , a.usernameasemailid, a.transid, a.usertype, a.pusername, a.nickname, a.ppassword, a.groupno, a.email, a.mobile, a.department, a.build, a.debug, a.manage, a.workflow, a.login_username, 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, a.portal_general_chk from AXUSERS a where a.axusersid = 1884660000000
Time elapsed = 5
Loading from 1884660000000 into frame 1, row 1
usernameasemailid =
transid = axusr
usertype =
pusername = 11akhilvis@gmail.com
nickname = Akhil Vishwanatham
ppassword = c5f8de689c119f863ee4a22f2ef86f91
groupno = 0
email = 1c_11akhilvis@gmail.com
mobile = 7904362037
department =
build = F
debug = F
manage = F
workflow = F
login_username = rekhancia
login_usergroup = default
send = F
importstruct = F
isfirsttime = F
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 = T
pwdauth = F
portal_general_chk = General
Select a.axuserlevelgroupsid, a.axusername, a.axusergroup, a.startdate, a.enddate,a.axuserlevelgroupsrow from AXUSERLEVELGROUPS a where a.axusersid = 1884660000000 Order by axuserlevelgroupsrow
Time elapsed = 3
Loading from 1884660000001 into frame 2, row 1
axusername = 11akhilvis@gmail.com
axusergroup = client
startdate = 06/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 = 1884660000000
ppassword = c5f8de689c119f863ee4a22f2ef86f91
Result of iif = c5f8de689c119f863ee4a22f2ef86f91
Preparing axuser-calculate
username = rekhancia
Field Value - rekhancia
build = F
username = rekhancia
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 )
Preparing tflag-accept
Field Value - T
Preparing axcloudtrigger-accept
select 'ALTER TRIGGER TR_AXCLOUD_USER_CREATION ENABLE' AS TR from dual
Time elapsed = 0
Query opened , Record count : 1
Field Value - ALTER TRIGGER TR_AXCLOUD_USER_CREATION ENABLE
pusername = 11akhilvis@gmail.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
Quick Load Data JSON
DC to JSON DC1
DC to JSON DC2
Field to JSON transid 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 mobile row 1
Field to JSON build row 1
Field to JSON debug row 1
Field to JSON manage row 1
Field to JSON workflow row 1
Field to JSON login_username row 1
Field to JSON login_usergroup row 1
Field to JSON send row 1
Field to JSON importstruct row 1
Field to JSON isfirsttime 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
Field to JSON portal_general_chk 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 = 1884660000000
uXDS\dopen\ Check intransaction
Time elapsed = 3
Result : {"data":[{"n":"DC1","v":"1","t":"dc"},{"n":"axp_recid1","v":"1884660000000","r":"0","t":"s"},{"n":"transid","v":"axusr","r":"0","t":"s"},{"n":"pusername","v":"11akhilvis@gmail.com","r":"0","t":"s"},{"n":"pwd","v":"12345","r":"0","t":"s"},{"n":"nickname","v":"Akhil Vishwanatham","r":"0","t":"s"},{"n":"ppassword","v":"c5f8de689c119f863ee4a22f2ef86f91","r":"0","t":"s"},{"n":"axuser","v":"rekhancia","r":"0","t":"s"},{"n":"groupno","v":"0","r":"0","t":"s"},{"n":"email","v":"1c_11akhilvis@gmail.com","r":"0","t":"s"},{"n":"mobile","v":"7904362037","r":"0","t":"s"},{"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":"workflow","v":"F","r":"0","t":"s"},{"n":"login_username","v":"rekhancia","r":"0","t":"s"},{"n":"login_usergroup","v":"default","r":"0","t":"s"},{"n":"send","v":"F","r":"0","t":"s"},{"n":"importstruct","v":"F","r":"0","t":"s"},{"n":"isfirsttime","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 )","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":"T","r":"0","t":"s"},{"n":"pwdauth","v":"F","r":"0","t":"s"},{"n":"portal_general_chk","v":"General","r":"0","t":"s"},{"n":"DC2","v":"1","cr":"i1","t":"dc","hasdatarows":"yes"},{"n":"axp_recid2","v":"1884660000001","r":"1","t":"s"},{"n":"axusername","v":"11akhilvis@gmail.com","r":"1","t":"s"},{"n":"axusergroup","v":"client","r":"1","idcol":"no","id":"0","oldid":"0","mr":"1","t":"c"},{"n":"startdate","v":"06/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 ('gmyjcxxozanv2o1zo21ssfaf','rekhancia',to_timestamp('20/05/2025 12:33:39','dd/mm/yyyy hh24:mi:ss'),to_timestamp('20/05/2025 12:33:39','dd/mm/yyyy hh24:mi:ss'),'axusr',1884660000000,'Quick Load Data','success',370,22,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
Load Data service completed.