Start Time : 7/5/2024 6:12:10 PM 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 = 16 SET SEARCH_PATH TO trustlineuat,trustlineuat,public Time elapsed = 0 Select nextval('connectnoseq') Time elapsed = 0 Time elapsed = 0 Time elapsed = 0 select props from axprops where lower(name)='app' order by blobno Time elapsed = 0 axprops xml = images\Agile-TrustLine-UATINR1FFF0somatcs1@gmail.comsoma@12330000FF 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\lp0t3y1t5mlfgthiiuvqq2ym 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/5/2024 6:09:05 pm*-5097732671 axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=lp0t3y1t5mlfgthiiuvqq2ym 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 = 0 Received XML 0513729218765522somatcs1@gmail.com00eaddcb7a6dd50824f25d243cec0e7bT*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_TLBusiness1025660000000FrekhanciadefaultdefaultFlp0t3y1t5mlfgthiiuvqq2ymdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*7/5/2024 6:09:05 pm*-5097732671~~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 = 513729218765522 S=513729218765522 Select rpassword from reset_password where lower(rpassword) = :S S=513729218765522 Time elapsed = 16 primary_emailid = somatcs1@gmail.com ppassword = 00eaddcb7a6dd50824f25d243cec0e7b Evaluating - iif( recordid = 0, iif(axp_md5pwd = {T},convertmd5(rpassword), Encryptstr(rpassword)), ppassword) rpassword = 513729218765522 Result of encryptstr = 0F0000006F1D352170F34F06748C39D9698A2D7A rpassword = 513729218765522 Result of convertmd5 = 00eaddcb7a6dd50824f25d243cec0e7b axp_md5pwd = T Result of iif = 00eaddcb7a6dd50824f25d243cec0e7b recordid = 0 ppassword = 00eaddcb7a6dd50824f25d243cec0e7b Result of iif = 00eaddcb7a6dd50824f25d243cec0e7b isfirsttime = T reason_passwordreset = delete from Axp_TransCheck where sessionid = 'lp0t3y1t5mlfgthiiuvqq2ym' 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 = 15 select pusername from axusers where axusersid=0 Time elapsed = 0 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 = 16 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 = 16 RecordId = 1783110000000 MapName SourceId 0 GetNoOfTrans Check Reg Type : R rpassword = 513729218765522 primary_emailid = somatcs1@gmail.com ppassword = 00eaddcb7a6dd50824f25d243cec0e7b isfirsttime = T reason_passwordreset = 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 (1783110000000,null,0,'F','rekhancia',to_timestamp('05/07/2024 18:12:10','dd/mm/yyyy hh24:mi:ss'),'rekhancia',to_timestamp('05/07/2024 18:12:10','dd/mm/yyyy hh24:mi:ss'),'1','1','513729218765522','somatcs1@gmail.com','00eaddcb7a6dd50824f25d243cec0e7b','T',null) Time elapsed for insert/update = 3929364730473 >>Executing genmaps Time elapsed for Gen Map = 3929364730473 >>Posting MD Maps : Select * from axusers where axusers where pusername='somatcs1@gmail.com' @pusername=somatcs1@gmail.com *ppassword=00eaddcb7a6dd50824f25d243cec0e7b *pwd=513729218765522 *isfirsttime=T *reset_update_flag=T SELECT * FROM axusers where pusername='somatcs1@gmail.com' for update Time elapsed = 0 SELECT * FROM axusers where pusername='somatcs1@gmail.com' Time elapsed = 0 update axusers set ppassword='00eaddcb7a6dd50824f25d243cec0e7b',pwd='513729218765522',isfirsttime='T',reset_update_flag='T' where pusername='somatcs1@gmail.com' Time elapsed for MD Map = 3929364730504 insert into respahistory (modifieddate,recordid,username,tablerecid,newtrans,canceltrans,cancelremarks) values (to_timestamp('05/07/2024 18:12:10','dd/mm/yyyy hh24:mi:ss'),1783110000000,'rekhancia',1783110000000,'t','f',null) Time elapsed for Save History = 3929364730504 Time elapsed for Save Attachment = 3929364730504 Time elapsed for After Save WF Exec = 3929364730504 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 1783110000000 Record ID 1783110000000 Creating message node Constraint Name = Reset Password Saved,recordid=1783110000000 select msg from axconstraints where lower(constraint_name) = 'reset password saved,recordid=1783110000000' Time elapsed = 0 Result of save = Result = Evaluating SendEMail({resetpasswordemail}, recordid) recordid = 1783110000000 Calling function sendemail Executing SendEMail... insert into EMailDetails (id,sessionid,username,calledon,context,structtype,structname,act_script_name,recordid,params,emaildefname) values ('2024070518121000017831001','lp0t3y1t5mlfgthiiuvqq2ym','rekhancia',to_timestamp('05/07/2024 18:12:10','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 = 15 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 1783110000000 >>Loading transaction respa record 1783110000000 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 = 1783110000000 Time elapsed = 0 Loading from 1783110000000 into frame 1, row 1 rpassword = 513729218765522 primary_emailid = somatcs1@gmail.com ppassword = 00eaddcb7a6dd50824f25d243cec0e7b isfirsttime = T reason_passwordreset = Loading no-save fields >>Validating respa >>Frame No 1 rpassword = 513729218765522 S=513729218765522 Select rpassword from reset_password where lower(rpassword) = :S and reset_passwordID <> 1783110000000 S=513729218765522 Time elapsed = 0 primary_emailid = somatcs1@gmail.com ppassword = 00eaddcb7a6dd50824f25d243cec0e7b Evaluating - iif( recordid = 0, iif(axp_md5pwd = {T},convertmd5(rpassword), Encryptstr(rpassword)), ppassword) rpassword = 513729218765522 Result of encryptstr = 0F0000006F1D352170F34F06748C39D9698A2D7A rpassword = 513729218765522 Result of convertmd5 = 00eaddcb7a6dd50824f25d243cec0e7b axp_md5pwd = T Result of iif = 00eaddcb7a6dd50824f25d243cec0e7b recordid = 1783110000000 ppassword = 00eaddcb7a6dd50824f25d243cec0e7b Result of iif = 00eaddcb7a6dd50824f25d243cec0e7b isfirsttime = T reason_passwordreset = 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-UATINR1FFF0somatcs1@gmail.comsoma@12330000FF Reading mail parameters select email from axusers where username = :u Time elapsed = 0 Mail from rekhancia@agile-labs.com Error while sending mail :Authentication details for sending mail are not found Error in SendMail.Authentication details for sending mail are not found insert into EMailExceptionDetails (id,transid,recordid,lineno,errormsg) values ('2024070518121000017831001',null,0,1,'Authentication details for sending mail are not found') Error in SendMailFormData-Authentication details for sending mail are not found Error in GetMailDetails-Authentication details for sending mail are not found update EmailDetails set totallines=1,succlines=0,status='Authentication details for sending mail are not found' where id='2024070518121000017831001' Error in SendEMail-Authentication details for sending mail are not found Error in sending mail. Error in SendEMail-Authentication details for sending mail are not found Erron in sending mail. Error in SendEMail-Authentication details for sending mail are not found Error while evaluating - Erron in sending mail. Error in SendEMail-Authentication details for sending mail are not found Error in EvalExprSet - Erron in sending mail. Error in SendEMail-Authentication details for sending mail are not found Exception in RemoteAction uASBActionObj\RemoteDoAction\Exception Erron in sending mail. Error in SendEMail-Authentication details for sending mail are not found uASBActionObj\RemoteDoAction\ RollBack RollBack Transaction RollBack Transaction Status : -1 End of RollBack Transaction RollBack Transaction Status : 0 insert into axerrorlog values('rekhancia',to_timestamp('05/07/2024 18:12:10','dd/mm/yyyy hh24:mi:ss'),'Action Call','','') Time elapsed = 16 delete from Axp_TransCheck where sessionid = 'lp0t3y1t5mlfgthiiuvqq2ym' Time elapsed = 0 Result : {"result":[{"action": "retry"}]}*$*{"error":[{"msg":"Erron in sending mail. Error in SendEMail-Authentication details for sending mail are not found"}]} [Compiled on 29/05/2024 10:32:00 AM] [File Version : 11.3.0.0]] [Product Version : 11.3][64Bit(140524)] Time Used : 45.8847584516551 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 ('lp0t3y1t5mlfgthiiuvqq2ym','rekhancia',to_timestamp('05/07/2024 18:12:10','dd/mm/yyyy hh24:mi:ss'),to_timestamp('05/07/2024 18:12:10','dd/mm/yyyy hh24:mi:ss'),'respa',1783110000000,'Executing Script','Erron in sending mail. Error in SendEMail-Authentication details for sending mail are not found',422,126,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