Start Time : 8/8/2025 8:22:12 AM Saving Data Cross checking field value xml length sent from client and received xml length Call to SaveData Web 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 = 0 SET SEARCH_PATH TO trustlineuat,trustlineuat,public uXDS\dexecsql\ Check intransaction Time elapsed = 0 Select nextval('connectnoseq') uXDS\dopen\ Check intransaction Time elapsed = 0 uXDS\dopen\ Check intransaction Time elapsed = 0 uXDS\dexecsql\ Check intransaction Time elapsed = 17 select props from axprops where lower(name)='app' order by blobno uXDS\dopen\ Check intransaction Time elapsed = 3 axprops xml = images\Agile-TrustLine-UATINR1FFFsmtp.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 Savedata webservice ----------------------------- Received XML : 1888440000000ausrsPortal11anjalidevi61@yahoo.com12345Anjalidevi Rf629f9236792c95b96b75b955a68206csoma011anjalidevi61@yahoo.com646:Anjalidevi RFFFsomaFtrustlineadminFF00FFTTclientand((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 and ?portal_general_chk = 'General' )TNone0FALTER TRIGGER TR_AXCLOUD_USER_CREATION ENABLEFT188844000000111anjalidevi61@yahoo.comclient14/05/2025TdbPostgredbxlocalhosttrustlineuat\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_TLBusiness1026110000000FsomatrustlineadmintrustlineadminFwdb13p5hjbqdpknjitjnv1fytrustlineadmin~100trustlineuattrustlineuat0trustlineadminhttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-in*asia/calcutta^english*8/8/2025 8:03:17 am*4894~~9867~75~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-in*asia/calcutta^english*8/8/2025 8:03:17 am*4894 axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=wdb13p5hjbqdpknjitjnv1fy ax_evalcopy=F rolename=trustlineadmin responsibilies=trustlineadmin millions=F axpimageserver= axglo_hide= axp_displaytext= axglo_user= fromuserlogin= axglo_recordid=1026110000000 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~75~0~0~1~R~false~R LReg Type : R User Group trustlineadmin User Roles trustlineadmin 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 = 2 select ' '::varchar(250) as lval Time elapsed = 1 select * from axusers where axusersid=0 Time elapsed = 8 Evaluating {axusr} Result = Evaluating {T} Result = Evaluating {ADMIN} Result = Evaluating {General} 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 username Result = Evaluating {F} 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 and ?portal_general_chk = 'General' )} 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 pusername Result = Evaluating Date() 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 = Loading genmaps Creating Action object Submitting data to dbcall Submiting & Registering data Registering Global variables data Registering Global variables data over Setting values over DB Call Validate and save >>Validating axusr >>Frame No 1 transid = ausrs usernameasemailid = usertype = portal_general_chk = Portal pusername = 11anjalidevi61@yahoo.com Evaluating - iif(getlength(pusername) < 4,{User ID should have minmum length of 4 digits},{T}) pusername = 11anjalidevi61@yahoo.com Result of getlength = 24 Result of iif = T S=11anjalidevi61@yahoo.com Select pusername from axusers where lower(pusername) = :S and axusersID <> 1888440000000 S=11anjalidevi61@yahoo.com Time elapsed = 2 pwd = 12345 nickname = Anjalidevi R ppassword = f629f9236792c95b96b75b955a68206c Evaluating - iif( recordid = 0, iif(axp_md5pwd = {T},convertmd5(pwd), Encryptstr(pwd)), ppassword) pwd = 12345 Result of encryptstr = 05000000F34AC2E6E09F3DD7DF3783698DC17A4A pwd = 12345 Result of convertmd5 = 827ccb0eea8a706c4c34a16891f84e7b axp_md5pwd = T Result of iif = 827ccb0eea8a706c4c34a16891f84e7b recordid = 1888440000000 ppassword = f629f9236792c95b96b75b955a68206c Result of iif = f629f9236792c95b96b75b955a68206c axuser = soma Evaluating - username username = soma groupno = 0 email = 11anjalidevi61@yahoo.com S=11anjalidevi61@yahoo.com Select email from axusers where lower(email) = :S and axusersID <> 1888440000000 S=11anjalidevi61@yahoo.com Time elapsed = 2 mobile = 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})) mobile = Result of substr = mobile = Result of substr = mobile = Result of substr = mobile = Result of isempty = T Result of iif = T mobile = Result of getlength = 0 mobile = Result of isempty = T Result of iif = T client_details = 646:Anjalidevi R pusername=11anjalidevi61@yahoo.com select STRING_AGG(CONCAT(a.client_code, ':' , a.client_name), ', ' ORDER BY a.createdon ASC) AS Concatenated_Client_Info from client_details a where lower(a.primary_emailid) = lower( :pusername) pusername=11anjalidevi61@yahoo.com Time elapsed = 0 Query opened , Record count : 1 department = build = F debug = F Evaluating - build build = F manage = F login_username = soma Evaluating - username username = soma workflow = F login_usergroup = trustlineadmin login_username=soma select b.axusergroup from axusers a , axuserlevelgroups b where a.axusersid = b.axusersid and a.pusername = :login_username login_username=soma Time elapsed = 0 Query opened , Record count : 1 send = F importstruct = F isfirsttime = pageaccess = reportingto = webskin = logintry = 0 pwdexpdays = 0 language_access = language = exportstruct = F axpertmanager = accesscode = appparams = appmanager = tools = F actflag = T active = T Evaluating - actflag actflag = T allusergroup = client Evaluating - getallvalues({axusergroup},{F}) Result of getallvalues = client viewfilter = and((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 and ?portal_general_chk = 'General' ) Evaluating - {and((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 and ?portal_general_chk = 'General' )} tflag = T global_displaytext = dhomepage = None SELECT caption, name, props AS homepage, 2 as slno FROM axpages where lower(pagetype) = 'web' union all select cast('None' as varchar(50)) ,'' as b , '0' as homepage, 1 as slno from dual order by slno,caption Time elapsed = 5 Query opened , Record count : 15 homepage = 0 Finding linkfield in fieldenter function Linkfield found and assigning Query from link field in fieldenter function Query assigned in fieldenter function reset_update_flag = F isIp = ipaddr = Evaluating - iif(((getlength(ipaddr) = 0) & (isIp = {T})),{ cannot be left empty},{T}) ipaddr = Result of getlength = 0 isip = Result of iif = T axcloudtrigger = ALTER TRIGGER TR_AXCLOUD_USER_CREATION ENABLE select 'ALTER TRIGGER TR_AXCLOUD_USER_CREATION ENABLE' AS TR from dual Time elapsed = 1 Query opened , Record count : 1 reporting_to = empid = otpauth = F pwdauth = T Starting Transaction Start Transaction Status : 0 End of Starting Transaction Start Transaction Status : -1 time zone difference = 0 >>Writing to tables axusr Saving to table AXUSERS select * from AXUSERS where AXUSERSid=1888440000000 Time elapsed = 5 Modifying Record 1888440000000To store data from Frame 1, Row 1 Parent Row 0 appparams = accesscode = axpertmanager = actflag = T tools = F appmanager = pwdexpdays = 0 logintry = 0 webskin = exportstruct = F language = language_access = reporting_to = ipaddr = isIp = pwdauth = T otpauth = F empid = global_displaytext = allusergroup = client active = T reset_update_flag = F homepage = 0 dhomepage = None reportingto = transid = ausrs usernameasemailid = email = 11anjalidevi61@yahoo.com client_details = 646:Anjalidevi R mobile = groupno = 0 portal_general_chk = Portal pusername = 11anjalidevi61@yahoo.com nickname = Anjalidevi R usertype = ppassword = f629f9236792c95b96b75b955a68206c send = F login_usergroup = trustlineadmin importstruct = F pageaccess = isfirsttime = workflow = F build = F department = debug = F login_username = soma manage = F Posting record update AXUSERS set username='soma',modifiedon=to_timestamp('08/08/2025 08:22:12','dd/mm/yyyy hh24:mi:ss'),app_desc='1',app_level='1',appparams='',accesscode='',axpertmanager='',actflag='T',tools='F',appmanager='',pwdexpdays=0,logintry=0,webskin='',exportstruct='F',language='',language_access='',reporting_to='',ipaddr='',isip='',pwdauth='T',otpauth='F',empid='',global_displaytext='',allusergroup='client',active='T',reset_update_flag='F',homepage='0',dhomepage='None',reportingto='',transid='ausrs',usernameasemailid='',email='11anjalidevi61@yahoo.com',client_details='646:Anjalidevi R',mobile='',groupno=0,portal_general_chk='Portal',pusername='11anjalidevi61@yahoo.com',nickname='Anjalidevi R',usertype='',ppassword='f629f9236792c95b96b75b955a68206c',send='F',login_usergroup='trustlineadmin',importstruct='F',pageaccess='',isfirsttime='',workflow='F',build='F',department='',debug='F',login_username='soma',manage='F' where AXUSERSid=1888440000000 uXDS\pupdate\ Check intransaction uXDS\pupdate\ ExecuteDirect - savepoint a Saving to table AXUSERLEVELGROUPS select * from AXUSERLEVELGROUPS where AXUSERLEVELGROUPSid=1888440000001 Time elapsed = 3 Modifying Record 1888440000001To store data from Frame 2, Row 1 Parent Row 0 enddate = startdate = 14/05/2025 axusername = 11anjalidevi61@yahoo.com axusergroup = client AXUSERLEVELGROUPSrow = 1 Posting record update AXUSERLEVELGROUPS set username='soma',enddate=null,startdate=to_timestamp('14/05/2025 00:00:00','dd/mm/yyyy hh24:mi:ss'),axusername='11anjalidevi61@yahoo.com',axusergroup='client',axuserlevelgroupsrow=1 where AXUSERLEVELGROUPSid=1888440000001 uXDS\pupdate\ Check intransaction uXDS\pupdate\ ExecuteDirect - savepoint a Time elapsed for insert/update = 3963802932847 >>Executing genmaps Time elapsed for Gen Map = 3963802932848 Time elapsed for MD Map = 3963802932849 uDBCall\SaveData\ checking InTransaction... >>Saving to history table. select max(modno) as cnt from axusrhistory where recordid=1888440000000 Time elapsed = 2 >>Saving to history table. select * from axusrhistory where recordid=0 Time elapsed = 2 select max(modno) as cnt from axusrhistory where recordid=1888440000000 Time elapsed = 0 Time elapsed for Save History = 3963802932857 Saving attachments Time elapsed for Save Attachment = 3963802932857 Time elapsed for After Save WF Exec = 3963802932857 DbCall/Executing ProcessAutoPrints... ProcessAutoPrints starts... ProcessAutoPrints SQL Query : select * from AxAutoPrints Where stransid = 'axusr' order by createdon asc select * from AxAutoPrints Where stransid = 'axusr' order by createdon asc Time elapsed = 10 cds free error : Missing DataSet property ProcessAutoPrints ends. Storedata/ProcessAutoPrints ends. DbCall/Executing ProcessDataExch... ProcessDataOut starts... ProcessDataOut SQL Query : select * from axoutqueues Where lower(active) = 't' and stransid = 'axusr' and lower(axqueuesource) = 'form' order by createdon asc select * from axoutqueues Where lower(active) = 't' and stransid = 'axusr' and lower(axqueuesource) = 'form' order by createdon asc Time elapsed = 0 cds free error : Missing DataSet property ProcessDataOut ends. Storedata/ProcessDataExch ends. DbCall/Executing ProcessFormNotifications... ProcessFormNotify starts... ProcessFormNotify SQL Query : select * from AxFormNotify Where lower(active) = 't' and stransid = 'axusr' order by createdon asc select * from AxFormNotify Where lower(active) = 't' and stransid = 'axusr' order by createdon asc Time elapsed = 15 cds free error : Missing DataSet property ProcessFormNotify ends. Storedata/ProcessFormNotifications ends. Committing Transaction Committing Transaction Status : -1 End of Committing Transaction Committing Transaction Status : 0 Transaction commited ASBTStructObj/ProcessRMQMessages starts... Processing Form notification RMQ messages... PushMessagesToRMQ starts... PushMessagesToRMQ ends. ASBTStructObj/ProcessRMQMessages ends. Creating message node Constraint Name = User Login Saved,recordid=1888440000000 select msg from axconstraints where lower(constraint_name) = 'user login saved,recordid=1888440000000' Time elapsed = 0 # 1#Executing GetAttachments select distinct filename as fn from axusrattach where recordid = 1888440000000 uXDS\dopen\ Check intransaction Time elapsed = 0 Result : {"message":[{"msg":"User Login Saved,recordid=1888440000000"}]}*$*{"result":[{"save": "success"}]} Savedata 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 ('wdb13p5hjbqdpknjitjnv1fy','soma',to_timestamp('08/08/2025 08:22:12','dd/mm/yyyy hh24:mi:ss'),to_timestamp('08/08/2025 08:22:12','dd/mm/yyyy hh24:mi:ss'),'axusr',0,'Saving data','success',522,101,0) uXDS\pinsert\ Check intransaction 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 End Time : 8/8/2025 8:22:12 AM