Start Time : 7/8/2024 11:05:47 AM Executing Action ASB XE3/32/64 DLL running [Compiled on 29/05/2024 10:32:00 AM] [File Version : 11.3.0.0]] [Product Version : 11.3][64Bit(140524)] 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 = 0 SET SEARCH_PATH TO trustlineuat,trustlineuat,public Time elapsed = 0 Select nextval('connectnoseq') Time elapsed = 0 Time elapsed = 0 Time elapsed = 16 select props from axprops where lower(name)='app' order by blobno Time elapsed = 0 axprops xml = images\Agile-TrustLine-UATINR1FFFsmtp.office365.com587rekhancia@agile-labs.comDivitessi12990@30000FF SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2 Time elapsed = 0 Db Manager Connection ends Connection to DB Successful Executing DoScript WebService ----------------------------- Registering app/user variables for the session Script path set in WEB : E:\Axpert113\Axpert Web\AxpertWebScripts\Axpert\axrlupfqu3sglsxvqp5y0ldp 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*7/8/2024 11:03:05 am*2592018645 axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=axrlupfqu3sglsxvqp5y0ldp 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 Time elapsed = 16 Received XML 0675442719039931somatcs1@gmail.comd48cefff45b008f0bff5d2b9419ff7f4TTesting Mail *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_TLBusiness1025660000000FrekhanciadefaultdefaultFaxrlupfqu3sglsxvqp5y0ldpdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*7/8/2024 11:03:05 am*2592018645~~9867~25~0~0~1~R~false~RccccncccccE:\Axpert113\Axpert Web\AxpertWebScripts Received SXML respaReset PasswordtFalseTrueFalseFalseFalseNoneDefaultFalsedc1Reset Password1reset_passwordFalseTrueTrueTrueFalseFalserpasswordRandom PasswordCharacter500Acceptselect passwordrandom_number()00TrueFalseTrueFalseFalseTrueFalseTrueFalseFalseFalseFalseFalseTrueeppasswordTruerpassword~ppasswordprimary_emailidPrimary Email IDCharacter5000Accept00TrueFalseFalseFalseTrueTrueFalseTrueTrueFalseFalseFalseFalseTrueTrueprimary_emailidppasswordppasswordCharacter500calculate00TrueTrueFalseFalseTrueiif( recordid = 0, iif(axp_md5pwd = {T},convertmd5(rpassword), Encryptstr(rpassword)), ppassword)TrueTrueFalseFalseFalseTrueTrueppassword,rpasswordisfirsttimeisfirsttimeCharacter10Accept00TrueFalseFalseTrueTrueFalseFalseTrue{T}TrueFalseFalseFalseFalseTrueTrueisfirsttimereason_passwordresetReason for Password ResetCharacter10000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruereason_passwordresetmdmap1Update password to Portal LoginFalseausrsppasswordppasswordpusernameprimary_emailidaxusersReplaceFalseTrue0FalseFalsemdmap2Update random passwordFalseausrspwdrpasswordpusernameprimary_emailidaxusersReplaceFalseTrue0FalseFalsemdmap3Update isfirsttimeFalseausrsisfirsttimeisfirsttimepusernameprimary_emailidaxusersReplaceFalseTrue0FalseFalsemdmap4Update Reset UpdateFalseausrsreset_update_flagisfirsttimepusernameprimary_emailidaxusersReplaceFalseTrue0FalseFalseSave()SendEMail({resetpasswordemail}, recordid)first_pagematerial-iconsskip_previousmaterial-iconsskip_nextmaterial-iconslast_pagematerial-iconssavematerial-iconssearchmaterial-iconsremovematerial-iconsprintmaterial-iconsremove_red_eyematerial-iconspicture_as_pdfmaterial-iconslistmaterial-iconslistmaterial-iconslistmaterial-iconstask_altmaterial-iconsdc1 Creating Action object Creating DbCall Creating DbCall CheckForNoLDS starts select * from reset_password where reset_passwordid=0 Time elapsed = 0 Evaluating iif( recordid = 0, iif(axp_md5pwd = {T},convertmd5(rpassword), Encryptstr(rpassword)), ppassword) Result = Evaluating {T} Result = Submiting & Registering data Registering Global variables data Registering Global variables data over Setting values over Creating changed web rows list Changed Web DC : #text Changed Web DC Rows: '*', Calling action in docoreaction Finding and executing action node :script1 Starting Action Execution - script1 Executing task - scripts Assigning expression set to parser Expression : Save() SendEMail({resetpasswordemail}, recordid) Evaluating Save() Calling function save Executing save from action DBCalll assigned for save action Starting database transaction for validating & saving DB Call Validate and save >>Validating respa >>Frame No 1 rpassword = 675442719039931 S=675442719039931 Select rpassword from reset_password where lower(rpassword) = :S S=675442719039931 Time elapsed = 0 primary_emailid = somatcs1@gmail.com ppassword = d48cefff45b008f0bff5d2b9419ff7f4 Evaluating - iif( recordid = 0, iif(axp_md5pwd = {T},convertmd5(rpassword), Encryptstr(rpassword)), ppassword) rpassword = 675442719039931 Result of encryptstr = 0F0000004BF415EB2EF43D97CFDCBDFCDEC5F840 rpassword = 675442719039931 Result of convertmd5 = d48cefff45b008f0bff5d2b9419ff7f4 axp_md5pwd = T Result of iif = d48cefff45b008f0bff5d2b9419ff7f4 recordid = 0 ppassword = d48cefff45b008f0bff5d2b9419ff7f4 Result of iif = d48cefff45b008f0bff5d2b9419ff7f4 isfirsttime = T reason_passwordreset = Testing Mail delete from Axp_TransCheck where sessionid = 'axrlupfqu3sglsxvqp5y0ldp' Time elapsed = 0 Starting Transaction Start Transaction Status : 0 End of Starting Transaction Start Transaction Status : -1 select distinct(schemaname) from axschema where lower(transid)='ausrs' Time elapsed = 0 select pusername from axusers where axusersid=0 Time elapsed = 16 select ppassword from axusers where axusersid=0 Time elapsed = 0 select distinct(schemaname) from axschema where lower(transid)='ausrs' Time elapsed = 0 select pwd from axusers where axusersid=0 Time elapsed = 0 select distinct(schemaname) from axschema where lower(transid)='ausrs' Time elapsed = 0 select isfirsttime from axusers where axusersid=0 Time elapsed = 0 select distinct(schemaname) from axschema where lower(transid)='ausrs' Time elapsed = 0 select reset_update_flag from axusers where axusersid=0 Time elapsed = 0 Loading genmaps time zone difference = 0 >>Writing to tables respa Saving to table RESET_PASSWORD select * from RESET_PASSWORD where RESET_PASSWORDid=0 Time elapsed = 0 Adding new record to store data from Frame 1, Row 1 Parent Row 0 Time elapsed = 0 RecordId = 1783880000000 MapName SourceId 0 GetNoOfTrans Check Reg Type : R rpassword = 675442719039931 primary_emailid = somatcs1@gmail.com ppassword = d48cefff45b008f0bff5d2b9419ff7f4 isfirsttime = T reason_passwordreset = Testing Mail Posting record insert into RESET_PASSWORD (reset_passwordid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,rpassword,primary_emailid,ppassword,isfirsttime,reason_passwordreset) values (1783880000000,null,0,'F','rekhancia',to_timestamp('08/07/2024 11:05:48','dd/mm/yyyy hh24:mi:ss'),'rekhancia',to_timestamp('08/07/2024 11:05:48','dd/mm/yyyy hh24:mi:ss'),'1','1','675442719039931','somatcs1@gmail.com','d48cefff45b008f0bff5d2b9419ff7f4','T','Testing Mail ') Time elapsed for insert/update = 3929598348319 >>Executing genmaps Time elapsed for Gen Map = 3929598348319 >>Posting MD Maps : Select * from axusers where axusers where pusername='somatcs1@gmail.com' @pusername=somatcs1@gmail.com *ppassword=d48cefff45b008f0bff5d2b9419ff7f4 *pwd=675442719039931 *isfirsttime=T *reset_update_flag=T SELECT * FROM axusers where pusername='somatcs1@gmail.com' for update Time elapsed = 16 SELECT * FROM axusers where pusername='somatcs1@gmail.com' Time elapsed = 0 update axusers set ppassword='d48cefff45b008f0bff5d2b9419ff7f4',pwd='675442719039931',isfirsttime='T',reset_update_flag='T' where pusername='somatcs1@gmail.com' Time elapsed for MD Map = 3929598348351 insert into respahistory (modifieddate,recordid,username,tablerecid,newtrans,canceltrans,cancelremarks) values (to_timestamp('08/07/2024 11:05:48','dd/mm/yyyy hh24:mi:ss'),1783880000000,'rekhancia',1783880000000,'t','f',null) Time elapsed for Save History = 3929598348351 Time elapsed for Save Attachment = 3929598348351 Time elapsed for After Save WF Exec = 3929598348351 DbCall/Executing ProcessAutoPrints... ProcessAutoPrints starts... ProcessAutoPrints SQL Query : select * from AxAutoPrints Where stransid = 'respa' order by createdon asc select * from AxAutoPrints Where stransid = 'respa' order by createdon asc Time elapsed = 0 ProcessAutoPrints ends. Storedata/ProcessAutoPrints ends. DbCall/Executing ProcessDataExch... ProcessDataOut starts... ProcessDataOut SQL Query : select * from axoutqueues Where lower(active) = 't' and stransid = 'respa' and lower(axqueuesource) = 'form' order by createdon asc select * from axoutqueues Where lower(active) = 't' and stransid = 'respa' and lower(axqueuesource) = 'form' order by createdon asc Time elapsed = 0 ProcessDataOut ends. Storedata/ProcessDataExch ends. DbCall/Executing ProcessFormNotifications... ProcessFormNotify starts... ProcessFormNotify SQL Query : select * from AxFormNotify Where lower(active) = 't' and stransid = 'respa' order by createdon asc select * from AxFormNotify Where lower(active) = 't' and stransid = 'respa' order by createdon asc Time elapsed = 0 ProcessFormNotify ends. Storedata/ProcessFormNotifications ends. FNAme reset_passwordid Value 1783880000000 Record ID 1783880000000 Creating message node Constraint Name = Reset Password Saved,recordid=1783880000000 select msg from axconstraints where lower(constraint_name) = 'reset password saved,recordid=1783880000000' Time elapsed = 0 Result of save = Result = Evaluating SendEMail({resetpasswordemail}, recordid) recordid = 1783880000000 Calling function sendemail Executing SendEMail... insert into EMailDetails (id,sessionid,username,calledon,context,structtype,structname,act_script_name,recordid,params,emaildefname) values ('2024070811054800017838001','axrlupfqu3sglsxvqp5y0ldp','rekhancia',to_timestamp('08/07/2024 11:05:48','dd/mm/yyyy hh24:mi:ss'),'Web',null,null,'r1',0,null,'resetpasswordemail') Registering email data from variables. Fetching email data from table... select Axp_EMailSource,Axp_EMailTransid,Axp_EMailIView,Axp_EMailTo,Axp_EMailCC,Axp_EMailBCC,Axp_EMailSubject,Axp_EMailAttachment,Axp_EMailBody,Axp_EMailAttachRenameList from EmailDef where lower(EMailDefName)='resetpasswordemail' Time elapsed = 0 OpenMailDataCDS ends. Getting mail details. Getting value for Axp_EMailSource Axp_EMailSource=tstruct Getting value for Axp_EMailTransid Axp_EMailTransid=respa Getting DbObj Sql : select props from tstructs where lower(name)= :name order by blobno Paramval : respa ParamTYpe : c Param List : name select props from tstructs where lower(name)= :name order by blobno Time elapsed = 16 Step5 CheckForNoLDS starts Preparing expressions Evaluating iif( recordid = 0, iif(axp_md5pwd = {T},convertmd5(rpassword), Encryptstr(rpassword)), ppassword) Result = Evaluating {T} Result = Loading and validating data for tstruct = respa, recordid 1783880000000 >>Loading transaction respa record 1783880000000 Select a.reset_passwordid, a.SourceId , a.rpassword, a.primary_emailid, a.ppassword, a.isfirsttime, a.reason_passwordreset from RESET_PASSWORD a where a.reset_passwordid = 1783880000000 Time elapsed = 16 Loading from 1783880000000 into frame 1, row 1 rpassword = 675442719039931 primary_emailid = somatcs1@gmail.com ppassword = d48cefff45b008f0bff5d2b9419ff7f4 isfirsttime = T reason_passwordreset = Testing Mail Loading no-save fields >>Validating respa >>Frame No 1 rpassword = 675442719039931 S=675442719039931 Select rpassword from reset_password where lower(rpassword) = :S and reset_passwordID <> 1783880000000 S=675442719039931 Time elapsed = 0 primary_emailid = somatcs1@gmail.com ppassword = d48cefff45b008f0bff5d2b9419ff7f4 Evaluating - iif( recordid = 0, iif(axp_md5pwd = {T},convertmd5(rpassword), Encryptstr(rpassword)), ppassword) rpassword = 675442719039931 Result of encryptstr = 0F0000004BF415EB2EF43D97CFDCBDFCDEC5F840 rpassword = 675442719039931 Result of convertmd5 = d48cefff45b008f0bff5d2b9419ff7f4 axp_md5pwd = T Result of iif = d48cefff45b008f0bff5d2b9419ff7f4 recordid = 1783880000000 ppassword = d48cefff45b008f0bff5d2b9419ff7f4 Result of iif = d48cefff45b008f0bff5d2b9419ff7f4 isfirsttime = T reason_passwordreset = Testing Mail Preapring xml. Sending mail. Sending mail Params : :primary_emailidPassword reset SuccessfulHi, Your password reset is successful. Password is :rpassword Please verify and revert us in case of any issues. Thanks, TrustLine Holdings Pvt Ltd Sql : select props from axprops where lower(name)= :name order by blobno Paramval : app ParamTYpe : c Param List : name select props from axprops where lower(name)= :name order by blobno Time elapsed = 0 Step5 xml : images\Agile-TrustLine-UATINR1FFFsmtp.office365.com587rekhancia@agile-labs.comDivitessi12990@30000FF Reading mail parameters select email from axusers where username = :u Time elapsed = 16 Mail from rekhancia@agile-labs.com Sending mail through SMTP AxpertMailClent function strats GetMessageData function starts Submitting attachments AssignData function strats ConnectSMTP function strats transparent_mailauth: Executing DoAttachments... Connecting to SMTP Host=smtp.office365.com port=587 user= Error while sending mail :Authentication unsuccessful, the user credentials were incorrect. [PN2PR01CA0111.INDPRD01.PROD.OUTLOOK.COM 2024-07-08T05:35:55.292Z 08DC9E513452B05C] Error in SendMail.Authentication unsuccessful, the user credentials were incorrect. [PN2PR01CA0111.INDPRD01.PROD.OUTLOOK.COM 2024-07-08T05:35:55.292Z 08DC9E513452B05C] insert into EMailExceptionDetails (id,transid,recordid,lineno,errormsg) values ('2024070811054800017838001',null,0,1,'Authentication unsuccessful, the user credentials were incorrect. [PN2PR01CA0111.INDPRD01.PROD.OUTLOOK.COM 2024-07-08T05:35:55.292Z 08DC9E513452B05C] ') Error in SendMailFormData-Authentication unsuccessful, the user credentials were incorrect. [PN2PR01CA0111.INDPRD01.PROD.OUTLOOK.COM 2024-07-08T05:35:55.292Z 08DC9E513452B05C] Error in GetMailDetails-Authentication unsuccessful, the user credentials were incorrect. [PN2PR01CA0111.INDPRD01.PROD.OUTLOOK.COM 2024-07-08T05:35:55.292Z 08DC9E513452B05C] update EmailDetails set totallines=1,succlines=0,status='Authentication unsuccessful, the user credentials were incorrect. [PN2PR01CA0111.INDPRD01.PROD.OUTLOOK.COM 2024-07-08T05:35:55.292Z 08DC9E513452B05C] ' where id='2024070811054800017838001' Error in SendEMail-Authentication unsuccessful, the user credentials were incorrect. [PN2PR01CA0111.INDPRD01.PROD.OUTLOOK.COM 2024-07-08T05:35:55.292Z 08DC9E513452B05C] Error in sending mail. Error in SendEMail-Authentication unsuccessful, the user credentials were incorrect. [PN2PR01CA0111.INDPRD01.PROD.OUTLOOK.COM 2024-07-08T05:35:55.292Z 08DC9E513452B05C] Erron in sending mail. Error in SendEMail-Authentication unsuccessful, the user credentials were incorrect. [PN2PR01CA0111.INDPRD01.PROD.OUTLOOK.COM 2024-07-08T05:35:55.292Z 08DC9E513452B05C] Error while evaluating - Erron in sending mail. Error in SendEMail-Authentication unsuccessful, the user credentials were incorrect. [PN2PR01CA0111.INDPRD01.PROD.OUTLOOK.COM 2024-07-08T05:35:55.292Z 08DC9E513452B05C] Error in EvalExprSet - Erron in sending mail. Error in SendEMail-Authentication unsuccessful, the user credentials were incorrect. [PN2PR01CA0111.INDPRD01.PROD.OUTLOOK.COM 2024-07-08T05:35:55.292Z 08DC9E513452B05C] Exception in RemoteAction uASBActionObj\RemoteDoAction\Exception Erron in sending mail. Error in SendEMail-Authentication unsuccessful, the user credentials were incorrect. [PN2PR01CA0111.INDPRD01.PROD.OUTLOOK.COM 2024-07-08T05:35:55.292Z 08DC9E513452B05C] uASBActionObj\RemoteDoAction\ RollBack RollBack Transaction RollBack Transaction Status : -1 End of RollBack Transaction RollBack Transaction Status : 0 insert into axerrorlog values('rekhancia',to_timestamp('08/07/2024 11:05:48','dd/mm/yyyy hh24:mi:ss'),'Action Call','','') Time elapsed = 0 delete from Axp_TransCheck where sessionid = 'axrlupfqu3sglsxvqp5y0ldp' Time elapsed = 0 Result : {"result":[{"action": "retry"}]}*$*{"error":[{"msg":"Erron in sending mail. Error in SendEMail-Authentication unsuccessful, the user credentials were incorrect. [PN2PR01CA0111.INDPRD01.PROD.OUTLOOK.COM 2024-07-08T05:35:55.292Z 08DC9E513452B05C] "}]} [Compiled on 29/05/2024 10:32:00 AM] [File Version : 11.3.0.0]] [Product Version : 11.3][64Bit(140524)] Time Used : 52.7464623617361 secs 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 ('axrlupfqu3sglsxvqp5y0ldp','rekhancia',to_timestamp('08/07/2024 11:05:48','dd/mm/yyyy hh24:mi:ss'),to_timestamp('08/07/2024 11:05:55','dd/mm/yyyy hh24:mi:ss'),'respa',1783880000000,'Executing Script','Erron in sending mail. Error in SendEMail-Authentication unsuccessful, the user credentials were incorrect. [PN2PR01CA0111.INDPRD01.PROD.OUTLOOK.COM 2024-07-08T05:35:55.292Z 08DC9E513452B05C] ',7281,143,0) Closing connection Freeing AxProvider Resources Destroying License Manager Destroying License Manager XDS Destroying License Manager Completed 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