Start Time : 07/08/2024 10:30:55 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 31/07/2024 1:02:00 PM] [File Version : 11.3.0.0]] [Product Version : 11.3][64Bit(260724)] 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.com01trust@123*100000FF 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*8/7/2024 10:29:20 am*-2592002218 axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=fevgag5szj4b24cs5phvx0ut 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\trustlineuattrustlineuataxdefdd/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_TLBusiness1025660000000FrekhanciadefaultdefaultFfevgag5szj4b24cs5phvx0utdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*8/7/2024 10:29:20 am*-2592002218~~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 toCharacter200Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruecustomtodc3User Access & Password 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 charactersNumeric20Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueTrueFalseFalseFalseTrueTruepwdmincharpwdreuseNo. of previous Passwords cannot be used againNumeric20Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueTrueFalseFalseFalseTrueTruepwdreusepwdalphanumPassword must contain alphanumeric charactersCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTruepwdalphanumpwdencryptApply advanced encryption standard on user passwordCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTruepwdencryptSave()fact_checkmaterial-iconsdc1dc2dc3 Creating DbCall Evaluating {F} Result = Evaluating {F} Result = Evaluating {T} Result = Evaluating {F} 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 = 3 Recordid to load : 1 Time taken to connect and submit - 213 Record ID : 1 Transid:ad_pr recordid:1 primarytable:axpdef_axpertprops >>Loading transaction ad_pr record 1 Select a.* 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 = 01trust@123* axpsiteno = 0 amtinmillions = F currseperator = F lastlogin = T autogen = F customfrom = customto = loginattempt = 10 pwdexp = 0 Evaluating iif(pwdchange > pwdexp,{ cannot be greater than Password expiry days},{T}) Result = pwdchange = 0 pwdminchar = 0 pwdreuse = 0 pwdalphanum = F pwdencrypt = F 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=3 Quick Load Data JSON DC to JSON DC1 DC to JSON DC2 DC to JSON DC3 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 pwdreuse row 1 Field to JSON pwdalphanum row 1 Field to JSON pwdencrypt 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":"01trust@123*","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":"pwdreuse","v":"0","r":"0","t":"s"},{"n":"pwdalphanum","v":"F","r":"0","t":"s"},{"n":"pwdencrypt","v":"F","r":"0","t":"s"}]} Time taken by Quick FormLoad - 53 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 ('fevgag5szj4b24cs5phvx0ut','rekhancia',to_timestamp('07/08/2024 10:30:55','dd/mm/yyyy hh24:mi:ss'),to_timestamp('07/08/2024 10:30:55','dd/mm/yyyy hh24:mi:ss'),'ad_pr',0,'Quick Form Load','success',284,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 Getting structure from Cache. Loading tstruct.aspx completed End Time : 07/08/2024 10:30:55