Start Time : 26/06/2025 14:04:19
Loading Structure.
Get Struct from Cache Manager. User: rekhancia Role: default
Getting Structure from Redis rekhancia Role: default
Getting structure from Cache.
Recordid = 0
Opening 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 = 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 Quick DoFormLoad webservice
-------------------------------------
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*6/26/2025 2:01:08 pm*
axp_appschema=trustlineuat
axp_devschema=trustlineuataxdef
axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/
axp_connectionname=trustlineuat
sesid=cwh3jtu5jxgji5mhdrhqgxsk
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
Received XML 1dbPostgredbxlocalhosttrustlineuat\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_TLBusiness1025660000000FrekhanciadefaultdefaultFcwh3jtu5jxgji5mhdrhqgxskdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*6/26/2025 2:01:08 pm*~~9867~25~0~0~1~R~false~RccccncccccE:\Axpert113\Axpert Web\AxpertWebScripts
Received SXML ad_prAxpert PropertiestFalseTrueFalseFalseFalseNoneDefaultFalsedc1Mail Settings1axpdef_axpertpropsFalseTrueTrueTrueFalseFalsesmtphostHostCharacter2000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruesmtphostsmtpportPortNumeric40Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueTrueFalseFalseFalseTrueTruesmtpportsmtpuserUser IDCharacter2000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruesmtpusersmtppwdPasswordCharacter500Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalse*TrueTruesmtppwddc2Application Settings2axpdef_axpertpropsFalseTrueTrueTrueFalseFalseaxpsitenoSite no.( used in distributed deployments)Numeric100Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueTrueFalseFalseFalseTrueTrueaxpsitenoamtinmillionsDisplay amounts in MillionsCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTrueamtinmillionscurrseperatorCurrency seperator as Dot ( . )Character10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTruecurrseperatorlastloginShow last login usernameCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{T}TrueFalseFalseFalseFalseTrueTruelastloginautogenPost autogen processCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTrueautogencustomfromCustom Oracle Error Message Range fromCharacter200Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruecustomfromcustomtoCustom Oracle Error Message Range toCharacter200Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruecustomtodc3Password Policy Settings3axpdef_axpertpropsFalseTrueTrueTrueFalseFalseloginattemptNo. of invalid login attempts before account lockedNumeric20Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueTrueFalseFalseFalseTrueTrueloginattemptpwdexpNo. of days for Password ExpiryNumeric40Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueTrueFalseFalseFalseTrueTruepwdexppwdchangeNo. of days for Password change alertNumeric40Accept00TrueFalseFalseFalseTrueFalseFalseTrueiif(pwdchange > pwdexp,{ cannot be greater than Password expiry days},{T})TrueTrueFalseFalseFalseTrueTruepwdchangepwdmincharMinimum No. of Password charactersNumeric20Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueTrueFalseFalseFalseTrueTruepwdmincharpwdmaxcharMaximum No. of Password charactersNumeric40Accept00FalseTrueFalseFalseTrueiif(pwdmaxchar > pwdminchar,{T},{ cannot be lesser then minimum password characters})TrueTrueFalseTrueTrueTruepwdmaxcharpwdreuseNo. of previous Passwords cannot be used againNumeric20Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueTrueFalseFalseFalseTrueTruepwdreusepwdencryptApply advanced encryption standard on user passwordCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTruepwdencryptpwdalphanumPassword must contain alphanumeric charactersCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTruepwdalphanumpwdcapcharNo. of Capital charactersNumeric20Accept00FalseTrueFalseFalseTrueTrueTrueFalseTrueTrueTruepwdcapcharpwdsmallcharNo. of Small charactersNumeric20Accept00FalseTrueFalseFalseTrueTrueTrueFalseTrueTrueTruepwdsmallcharpwdnumcharNo. of NumericNumeric20Accept00FalseTrueFalseFalseTrueTrueTrueFalseTrueTrueTruepwdnumcharpwdsplcharNo. of Special charactersNumeric20Accept00FalseTrueFalseFalseTrueTrueTrueFalseTrueTrueTruepwdsplchardc4OTP Content Format4axpdef_axpertpropsFalseTrueTrueTrueTrueemailsubjectEmail subjectCharacter2500Accept00FalseTrueFalseFalseTrueTrueTrueFalseTrueTrueTrueemailsubjectemailbodyEmail bodyText80000Accept00FalseTrueFalseFalseTrueTrueTrueFalseTrueTrueemailbodysmscontentSMS contentText80000Accept00FalseTrueFalseFalseTrueTrueTrueFalseTrueTruesmscontentFalseHidef_On Form Load8pwdcapchar8pwdsmallchar8pwdnumchar8pwdsplcharfpwdalphanumcifpwdalphanumetT9pwdcapchar9pwdsmallchar9pwdnumchar9pwdsplcharcelse8pwdcapchar8pwdsmallchar8pwdnumchar8pwdsplcharf_On Data LoadcifpwdalphanumetT9pwdcapchar9pwdsmallchar9pwdnumchar9pwdsplcharcelse8pwdcapchar8pwdsmallchar8pwdnumchar8pwdsplcharpwdalphanum Equal to TFalseShowFalseHidepwdalphanum Equal to TFalseShowFalseHideSave()fact_checkmaterial-iconsdc1dc2dc3dc4
Creating DbCall
select * from axpdef_axpertprops where axpdef_axpertpropsid=0
Time elapsed = 4
Evaluating {F}
Result =
Evaluating {F}
Result =
Evaluating {T}
Result =
Evaluating {F}
Result =
Evaluating iif(pwdchange > pwdexp,{ cannot be greater than Password expiry days},{T})
Result =
Evaluating iif(pwdmaxchar > pwdminchar,{T},{ cannot be lesser then minimum password characters})
Result =
Evaluating {F}
Result =
Evaluating {F}
Result =
Submiting & Registering data
Registering Global variables data
Registering Global variables data over
Setting values over
Creating Action object
Getting recordid to load data in doformload with parameters : axpdef_axpertpropsid, with values 1~
Get Record id sql : select axpdef_axpertpropsid from axpdef_axpertprops where axpdef_axpertpropsid='1'
select axpdef_axpertpropsid from axpdef_axpertprops where axpdef_axpertpropsid='1'
Time elapsed = 2
Recordid to load : 1
Time taken to connect and submit - 209
Record ID : 1
Transid:ad_pr
recordid:1
primarytable:axpdef_axpertprops
>>Loading transaction ad_pr record 1
Select a.axpdef_axpertpropsid, a.SourceId , a.mapname , a.cancel, a.cancelremarks , a.CreatedOn, a.CreatedBy , a.ModifiedOn , a.UserName , a.smtphost, a.smtpport, a.smtpuser, a.smtppwd, a.axpsiteno, a.amtinmillions, a.currseperator, a.lastlogin, a.autogen, a.customfrom, a.customto, a.loginattempt, a.pwdexp, a.pwdchange, a.pwdminchar, a.pwdmaxchar, a.pwdreuse, a.pwdencrypt, a.pwdalphanum, a.pwdcapchar, a.pwdsmallchar, a.pwdnumchar, a.pwdsplchar, a.emailsubject, a.emailbody, a.smscontent from AXPDEF_AXPERTPROPS a where a.axpdef_axpertpropsid = 1
Time elapsed = 3
Loading from 1 into frame 1, row 1
smtphost = smtp.office365.com
smtpport = 587
smtpuser = portalneo@trustlineindia.com
smtppwd = 9IntFlo!!$$*1
axpsiteno = 0
amtinmillions = F
currseperator = F
lastlogin = T
autogen = F
customfrom =
customto =
loginattempt = 10
pwdexp = 0
pwdchange = 0
pwdminchar = 0
pwdmaxchar = 8
pwdreuse = 0
pwdencrypt = F
pwdalphanum = F
pwdcapchar = 0
pwdsmallchar = 0
pwdnumchar = 0
pwdsplchar = 0
emailsubject = TrustLine UAT App : Login OTP
emailbody = Hello,
Your One Time Password for accessing TrustLine appneo portal is
{otp}
Please do not disclose this OTP to anyone. Enter the OTP to log into your account. OTP will expire in {otpexpirytime} minute.
Thanks & Regards,
TrustLine Team
smscontent =
Loading no-save fields
Execute action from dbcall
>>Validating ad_pr
>>Frame No 1
Refreshing nonsave fields during loading
Refreshing nonsave fields during loading over
Assigning approval bar
newmaxrow count=4
Action node in structure : FalseHide
Starting Action Execution - formload
Executing task - field access
checkFillGrid :
Visible dcs :'dc1'
Executing task field access over
Action Execution over - formload
Action node in structure : pwdalphanum Equal to TFalseShowFalseHide
Starting Action Execution - dataload
Evaluating iif (pwdalphanum = {T} , {T} , {F})
pwdalphanum = F
Calling function iif
Result of iif = F
Result = F
Executing task - field access
checkFillGrid :
Visible dcs :'dc1'
Executing task field access over
Action Execution over - dataload
Quick Load Data JSON
DC to JSON DC1
DC to JSON DC2
DC to JSON DC3
DC to JSON DC4
Field to JSON smtphost row 1
Field to JSON smtpport row 1
Field to JSON smtpuser row 1
Field to JSON smtppwd row 1
Field to JSON axpsiteno row 1
Field to JSON amtinmillions row 1
Field to JSON currseperator row 1
Field to JSON lastlogin row 1
Field to JSON autogen row 1
Field to JSON loginattempt row 1
Field to JSON pwdexp row 1
Field to JSON pwdchange row 1
Field to JSON pwdminchar row 1
Field to JSON pwdmaxchar row 1
Field to JSON pwdreuse row 1
Field to JSON pwdencrypt row 1
Field to JSON pwdalphanum row 1
Field to JSON pwdcapchar row 1
Field to JSON pwdsmallchar row 1
Field to JSON pwdnumchar row 1
Field to JSON pwdsplchar row 1
Field to JSON emailsubject row 1
Field to JSON emailbody row 1
Quick Load Data JSON Completed
Result : {"data":[{"n":"DC1","v":"1","t":"dc"},{"n":"axp_recid1","v":"1","r":"0","t":"s"},{"n":"smtphost","v":"smtp.office365.com","r":"0","t":"s"},{"n":"smtpport","v":"587","r":"0","t":"s"},{"n":"smtpuser","v":"portalneo@trustlineindia.com","r":"0","t":"s"},{"n":"smtppwd","v":"9IntFlo!!$$*1","r":"0","t":"s"},{"n":"DC2","v":"1","t":"dc"},{"n":"axp_recid2","v":"1","r":"0","t":"s"},{"n":"axpsiteno","v":"0","r":"0","t":"s"},{"n":"amtinmillions","v":"F","r":"0","t":"s"},{"n":"currseperator","v":"F","r":"0","t":"s"},{"n":"lastlogin","v":"T","r":"0","t":"s"},{"n":"autogen","v":"F","r":"0","t":"s"},{"n":"DC3","v":"1","t":"dc"},{"n":"axp_recid3","v":"1","r":"0","t":"s"},{"n":"loginattempt","v":"10","r":"0","t":"s"},{"n":"pwdexp","v":"0","r":"0","t":"s"},{"n":"pwdchange","v":"0","r":"0","t":"s"},{"n":"pwdminchar","v":"0","r":"0","t":"s"},{"n":"pwdmaxchar","v":"8","r":"0","t":"s"},{"n":"pwdreuse","v":"0","r":"0","t":"s"},{"n":"pwdencrypt","v":"F","r":"0","t":"s"},{"n":"pwdalphanum","v":"F","r":"0","t":"s"},{"n":"pwdcapchar","v":"0","r":"0","t":"s"},{"n":"pwdsmallchar","v":"0","r":"0","t":"s"},{"n":"pwdnumchar","v":"0","r":"0","t":"s"},{"n":"pwdsplchar","v":"0","r":"0","t":"s"},{"n":"DC4","v":"1","t":"dc"},{"n":"axp_recid4","v":"1","r":"0","t":"s"},{"n":"emailsubject","v":"TrustLine UAT App : Login OTP","r":"0","t":"s"},{"n":"emailbody","v":"Hello,
Your One Time Password for accessing TrustLine appneo portal is
{otp}
Please do not disclose this OTP to anyone. Enter the OTP to log into your account. OTP will expire in {otpexpirytime} minute.
Thanks & Regards,
TrustLine Team","r":"0","t":"m"}]}*$*{"formcontrol":[{"readonlytrans":"no"},{"fldname":"pwdcapchar000F0","fldact":"hide"},{"fldname":"pwdsmallchar000F0","fldact":"hide"},{"fldname":"pwdnumchar000F0","fldact":"hide"},{"fldname":"pwdsplchar000F0","fldact":"hide"},{"readonlytrans":"no"},{"fldname":"pwdcapchar000F0","fldact":"hide"},{"fldname":"pwdsmallchar000F0","fldact":"hide"},{"fldname":"pwdnumchar000F0","fldact":"hide"},{"fldname":"pwdsplchar000F0","fldact":"hide"}]}
Time taken by Quick FormLoad - 73
Quick DoFormLoad 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 ('cwh3jtu5jxgji5mhdrhqgxsk','rekhancia',to_timestamp('26/06/2025 14:04:19','dd/mm/yyyy hh24:mi:ss'),to_timestamp('26/06/2025 14:04:20','dd/mm/yyyy hh24:mi:ss'),'ad_pr',0,'Quick Form Load','success',298,19,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 : 26/06/2025 14:04:20