Start Time : 5/20/2025 12:33:31 PM 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 = 1 SET SEARCH_PATH TO trustlineuat,trustlineuat,public uXDS\dexecsql\ Check intransaction Time elapsed = 2 Select nextval('connectnoseq') uXDS\dopen\ Check intransaction Time elapsed = 4 uXDS\dopen\ Check intransaction Time elapsed = 4 uXDS\dexecsql\ Check intransaction Time elapsed = 2 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 : 1884660000000axusr11akhilvis@gmail.com12345Akhil Vishwanathamc5f8de689c119f863ee4a22f2ef86f91rekhancia01c_11akhilvis@gmail.com7904362037FFFFrekhanciadefaultFFF00FFTTclientand((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 )TNone0FALTER TRIGGER TR_AXCLOUD_USER_CREATION ENABLETFGeneral188466000000111akhilvis@gmail.comclient06/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_TLBusiness1025660000000FrekhanciadefaultdefaultFgmyjcxxozanv2o1zo21ssfafdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*5/20/2025 12:14:18 pm*~~9867~25~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-us*asia/calcutta^english*5/20/2025 12:14:18 pm* axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=gmyjcxxozanv2o1zo21ssfaf 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 Creating DbCall select ' '::varchar(250) as lval Time elapsed = 2 select * from axusers where axusersid=0 Time elapsed = 7 Evaluating {T} Result = Evaluating {axusr} Result = Evaluating {ADMIN} 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 {F} Result = Evaluating username 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 )} 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 {General} Result = Evaluating pusername 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 usernameasemailid = transid = axusr usertype = pusername = 11akhilvis@gmail.com Evaluating - iif(getlength(pusername) < 4,{User ID should have minmum length of 4 digits},{T}) pusername = 11akhilvis@gmail.com Result of getlength = 20 Result of iif = T S=11akhilvis@gmail.com Select pusername from axusers where lower(pusername) = :S and axusersID <> 1884660000000 S=11akhilvis@gmail.com Time elapsed = 3 pwd = 12345 nickname = Akhil Vishwanatham ppassword = c5f8de689c119f863ee4a22f2ef86f91 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 = 1884660000000 ppassword = c5f8de689c119f863ee4a22f2ef86f91 Result of iif = c5f8de689c119f863ee4a22f2ef86f91 axuser = rekhancia Evaluating - username username = rekhancia groupno = 0 email = 1c_11akhilvis@gmail.com S=1c_11akhilvis@gmail.com Select email from axusers where lower(email) = :S and axusersID <> 1884660000000 S=1c_11akhilvis@gmail.com Time elapsed = 2 mobile = 7904362037 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 = 7904362037 Result of substr = 7 mobile = 7904362037 Result of substr = 7 mobile = 7904362037 Result of substr = 7 mobile = 7904362037 Result of isempty = F Result of iif = T mobile = 7904362037 Result of getlength = 10 mobile = 7904362037 Result of isempty = F Result of iif = T department = build = F debug = F Evaluating - build build = F manage = F workflow = F login_username = rekhancia Evaluating - username username = rekhancia login_usergroup = default login_username=rekhancia select b.axusergroup from axusers a , axuserlevelgroups b where a.axusersid = b.axusersid and a.pusername = :login_username login_username=rekhancia Time elapsed = 4 Query opened , Record count : 1 send = F importstruct = F isfirsttime = F 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 ) Evaluating - {and((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 )} 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 = 6 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 = T pwdauth = F portal_general_chk = General Evaluating - {General} 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=1884660000000 Time elapsed = 0 Modifying Record 1884660000000To store data from Frame 1, Row 1 Parent Row 0 appmanager = appparams = accesscode = active = T actflag = T tools = F language_access = pwdexpdays = 0 logintry = 0 axpertmanager = exportstruct = F language = empid = reporting_to = ipaddr = portal_general_chk = General pwdauth = F otpauth = T dhomepage = None global_displaytext = allusergroup = client isIp = reset_update_flag = F homepage = 0 email = 1c_11akhilvis@gmail.com groupno = 0 mobile = 7904362037 build = F department = ppassword = c5f8de689c119f863ee4a22f2ef86f91 transid = axusr usernameasemailid = usertype = nickname = Akhil Vishwanatham pusername = 11akhilvis@gmail.com pageaccess = login_usergroup = default send = F isfirsttime = F importstruct = F login_username = rekhancia manage = F debug = F webskin = workflow = F reportingto = Posting record update AXUSERS set username='rekhancia',modifiedon=to_timestamp('20/05/2025 12:33:31','dd/mm/yyyy hh24:mi:ss'),app_desc='1',app_level='1',appmanager='',appparams='',accesscode='',active='T',actflag='T',tools='F',language_access='',pwdexpdays=0,logintry=0,axpertmanager='',exportstruct='F',language='',empid='',reporting_to='',ipaddr='',portal_general_chk='General',pwdauth='F',otpauth='T',dhomepage='None',global_displaytext='',allusergroup='client',isip='',reset_update_flag='F',homepage='0',email='1c_11akhilvis@gmail.com',groupno=0,mobile='7904362037',build='F',department='',ppassword='c5f8de689c119f863ee4a22f2ef86f91',transid='axusr',usernameasemailid='',usertype='',nickname='Akhil Vishwanatham',pusername='11akhilvis@gmail.com',pageaccess='',login_usergroup='default',send='F',isfirsttime='F',importstruct='F',login_username='rekhancia',manage='F',debug='F',webskin='',workflow='F',reportingto='' where AXUSERSid=1884660000000 uXDS\pupdate\ Check intransaction uXDS\pupdate\ ExecuteDirect - savepoint a Saving to table AXUSERLEVELGROUPS select * from AXUSERLEVELGROUPS where AXUSERLEVELGROUPSid=1884660000001 Time elapsed = 0 Modifying Record 1884660000001To store data from Frame 2, Row 1 Parent Row 0 enddate = startdate = 06/05/2025 axusername = 11akhilvis@gmail.com axusergroup = client AXUSERLEVELGROUPSrow = 1 Posting record update AXUSERLEVELGROUPS set username='rekhancia',enddate=null,startdate=to_timestamp('06/05/2025 00:00:00','dd/mm/yyyy hh24:mi:ss'),axusername='11akhilvis@gmail.com',axusergroup='client',axuserlevelgroupsrow=1 where AXUSERLEVELGROUPSid=1884660000001 uXDS\pupdate\ Check intransaction uXDS\pupdate\ ExecuteDirect - savepoint a Time elapsed for insert/update = 3956906011951 >>Executing genmaps Time elapsed for Gen Map = 3956906011951 Time elapsed for MD Map = 3956906011951 uDBCall\SaveData\ checking InTransaction... >>Saving to history table. select max(modno) as cnt from axusrhistory where recordid=1884660000000 Time elapsed = 16 >>Saving to history table. select * from axusrhistory where recordid=0 Time elapsed = 0 select max(modno) as cnt from axusrhistory where recordid=1884660000000 Time elapsed = 0 Time elapsed for Save History = 3956906011967 Saving attachments Time elapsed for Save Attachment = 3956906011967 Time elapsed for After Save WF Exec = 3956906011967 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 = 0 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 = 16 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=1884660000000 select msg from axconstraints where lower(constraint_name) = 'user login saved,recordid=1884660000000' Time elapsed = 0 # 1#Executing GetAttachments select distinct filename as fn from axusrattach where recordid = 1884660000000 uXDS\dopen\ Check intransaction Time elapsed = 2 Result : {"message":[{"msg":"User Login Saved,recordid=1884660000000"}]}*$*{"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 ('gmyjcxxozanv2o1zo21ssfaf','rekhancia',to_timestamp('20/05/2025 12:33:31','dd/mm/yyyy hh24:mi:ss'),to_timestamp('20/05/2025 12:33:32','dd/mm/yyyy hh24:mi:ss'),'axusr',0,'Saving data','success',493,96,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 : 5/20/2025 12:33:32 PM