Start Time : 5/26/2025 4:15:45 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 = 2 SET SEARCH_PATH TO trustlineuat,trustlineuat,public uXDS\dexecsql\ Check intransaction Time elapsed = 2 Select nextval('connectnoseq') uXDS\dopen\ Check intransaction Time elapsed = 3 uXDS\dopen\ Check intransaction Time elapsed = 4 uXDS\dexecsql\ Check intransaction Time elapsed = 3 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.com9IntFlo!!$$*1100000FF SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2 uXDS\dopen\ Check intransaction Time elapsed = 3 Db Manager Connection ends Connection to DB Successful Executing Savedata webservice ----------------------------- Received XML : 0axusrTADMINPortal11nitesh.damani@sugaldamani.com20140530S N Damani Realty Investors LLP9c778cbeb863fdd4f1ba38142e0455e1rekhancia11nitesh.damani@sugaldamani.com800:S N Damani Realty Investors LLPFFFFrekhanciadefaultFFFFFFTTclientand((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' )TFFALTER TRIGGER TR_AXCLOUD_USER_CREATION ENABLEFT011nitesh.damani@sugaldamani.comclient26/05/2025T*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_TLBusiness1025660000000FrekhanciadefaultdefaultFetdzm0ronr0phiio123xdwtwdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*5/26/2025 3:57:12 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/26/2025 3:57:12 pm* axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=etdzm0ronr0phiio123xdwtw 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 ' '::varchar(250) as lval Time elapsed = 1 select * from axusers where axusersid=0 Time elapsed = 7 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 {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 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 Creating changed web rows list Changed Web DC : dc2 Changed Web DC Rows: '*', DB Call Validate and save >>Validating axusr >>Frame No 1 transid = axusr usernameasemailid = T usertype = ADMIN portal_general_chk = Portal pusername = 11nitesh.damani@sugaldamani.com Evaluating - iif(getlength(pusername) < 4,{User ID should have minmum length of 4 digits},{T}) pusername = 11nitesh.damani@sugaldamani.com Result of getlength = 31 Result of iif = T S=11nitesh.damani@sugaldamani.com Select pusername from axusers where lower(pusername) = :S S=11nitesh.damani@sugaldamani.com Time elapsed = 3 Email ID/Login ID* : value exceeds defined width Validate error msg : Email ID/Login ID* : value exceeds defined width Validate error msg1 : Email ID/Login ID* : value exceeds defined width Validate error msg2 : Email ID/Login ID* : value exceeds defined width DB Call error msg : Email ID/Login ID* : value exceeds defined width Error : Email ID/Login ID* : value exceeds defined width" , "errfld" : "pusername,1 insert into axerrorlog values('rekhancia',to_timestamp('26/05/2025 16:15:45','dd/mm/yyyy hh24:mi:ss'),'axusr','SaveData','Email ID/Login ID* : value exceeds defined width" , "errfld" : "pusername,1') Time elapsed = 8 Constraint Name = Email ID/Login ID* : value exceeds defined width select msg from axconstraints where lower(constraint_name) = 'email id/login id* : value exceeds defined width' Time elapsed = 1 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 ('etdzm0ronr0phiio123xdwtw','rekhancia',to_timestamp('26/05/2025 16:15:45','dd/mm/yyyy hh24:mi:ss'),to_timestamp('26/05/2025 16:15:45','dd/mm/yyyy hh24:mi:ss'),'axusr',0,'Saving data','Email ID/Login ID* : value exceeds defined width',290,46,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/26/2025 4:15:45 PM