Start Time : 20/05/2025 12:33:18 Loading Structure. Get Struct from Cache Manager. User: rekhancia Role: default Calling webservice to get Structure from DB ASB XE3/32/64 DLL running [Compiled on 23/10/2024 5:01:00 AM] [File Version : 11.3.0.0]] [Product Version : 11.3][64Bit(260724)] 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 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 = 2 Db Manager Connection ends Connection to DB Successful Web App Name : Executing GetStructure webservice --------------------------------- Received XML : tstructsaxusrdbPostgredbxlocalhosttrustlineuat\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 Reading Structure from DB Sql : select props from tstructs where lower(name)= :name order by blobno Paramval : axusr ParamTYpe : c Param List : name select props from tstructs where lower(name)= :name order by blobno uXDS\dopen\ Check intransaction Time elapsed = 3 Step5 select ' '::varchar(250) as lval Time elapsed = 2 Evaluating {T} Result = T Evaluating {axusr} Result = axusr Evaluating {ADMIN} Result = ADMIN Evaluating {12345} Result = 12345 Evaluating iif( recordid = 0, iif(axp_md5pwd = {T},convertmd5(pwd), Encryptstr(pwd)), ppassword) recordid = 0 axp_md5pwd = T pwd = 1 pwd = 1 ppassword = 1 Calling function encryptstr Result of encryptstr = 010000007B914803A259697AD9780FDF9C72E2F9 Calling function convertmd5 Result of convertmd5 = c4ca4238a0b923820dcc509a6f75849b Calling function iif Result of iif = c4ca4238a0b923820dcc509a6f75849b Calling function iif Result of iif = c4ca4238a0b923820dcc509a6f75849b Result = c4ca4238a0b923820dcc509a6f75849b Evaluating {12345} Result = 12345 Evaluating username username = rekhancia Result = rekhancia Evaluating iif(usernameasemailid={T},pusername,email) usernameasemailid = 1 pusername = 1 email = 1 Calling function iif Result of iif = 1 Result = 1 Evaluating {T} Result = T Evaluating {F} Result = F Evaluating build build = 1 Result = 1 Evaluating {F} Result = F Evaluating {F} Result = F Evaluating {F} Result = F Evaluating username username = rekhancia Result = rekhancia Evaluating usergroup usergroup = default Result = default Evaluating {F} Result = F Evaluating {F} Result = F Evaluating {F} Result = F Evaluating {F} Result = F Evaluating {F} Result = F Evaluating {F} Result = F Evaluating {T} Result = T Evaluating actflag actflag = 1 Result = 1 Evaluating {T} Result = T Evaluating getallvalues({axusergroup},{F}) Calling function getallvalues Result of getallvalues = 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 = and((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 ) Evaluating {T} Result = T Evaluating {F} Result = F Evaluating {F} Result = F Evaluating {T} Result = T Evaluating {F} Result = F Evaluating {General} Result = General Evaluating pusername pusername = 1 Result = 1 Evaluating iif(isempty(axusergroup)={F},{T},{F}) axusergroup = 1 Calling function isempty Result of isempty = F Calling function iif Result of iif = T Result = T Check print forms Check Attachments Check track changes Executing SetViewControl procedure Executing SetDcAccess Executing AddBtnList Executing SetBtnAccess End of SetViewControl procedure Executing AddSQLResult Field Name : axusr Field Name : dc1 Field Name : usernameasemailid Field Name : transid Field Name : usertype Field Name : pusername Field Name : pwd Field Name : nickname Field Name : ppassword Field Name : axuser Field Name : groupno Field Name : email Field Name : mobile Field Name : department Field Name : build Field Name : debug Field Name : manage Field Name : workflow Field Name : login_username Field Name : login_usergroup Field Name : send Field Name : importstruct Field Name : isfirsttime Field Name : pageaccess Field Name : reportingto Field Name : webskin Field Name : logintry Field Name : pwdexpdays Field Name : language_access Field Name : language Field Name : exportstruct Field Name : axpertmanager Field Name : accesscode Field Name : appparams Field Name : appmanager Field Name : tools Field Name : actflag Field Name : active Field Name : allusergroup Field Name : viewfilter Field Name : tflag Field Name : global_displaytext Field Name : dhomepage Field Name : homepage Field Name : reset_update_flag Field Name : isIp Field Name : ipaddr Field Name : axcloudtrigger Field Name : reporting_to Field Name : empid Field Name : otpauth Field Name : pwdauth Field Name : portal_general_chk Field Name : dc2 Field Name : axusername Field Name : axusergroup Field Name : startdate Field Name : enddate Field Name : validrow2 Field Name : axpconfigs_axusr Field Name : comps Field Name : iframes Field Name : actions Executing AddSQLResult Completed Select configname,cvalue from axpconfigs_axusr CDS Open Error Msg : csd query : Select configname,cvalue from axpconfigs_axusr $ Error msg : relation "axpconfigs_axusr" does not exist uXDS\open\ Exceptio relation "axpconfigs_axusr" does not exist SELECT A.STYPE,A.STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'SINGLE' as APPLYON FROM axpstructconfig a, axuserlevelgroups b WHERE A.USERROLES IN ('default') AND B.AXUSERNAME = :uname AND lower(a.stype) = :structure_type AND A.STRUCTNAME not in('ALL Reports','ALL Forms') UNION SELECT A.STYPE,A.STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'SINGLE' as APPLYON FROM axpstructconfig a WHERE coalesce(USERROLES, 'ALL') = 'ALL' AND lower(a.stype) = :structure_type AND structname = :sname AND A.STRUCTNAME not in('ALL Reports','ALL Forms') UNION SELECT A.STYPE, :sname STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'ALL' as APPLYON FROM axpstructconfig a, axuserlevelgroups b WHERE A.USERROLES IN ('default') AND B.AXUSERNAME = :uname AND lower(a.stype) = :structure_type AND A.STRUCTNAME in('ALL Reports','ALL Forms') UNION SELECT A.STYPE, :sname STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'ALL' as APPLYON FROM axpstructconfig a WHERE coalesce(USERROLES, 'ALL') = 'ALL' AND lower(a.stype) = :structure_type AND A.STRUCTNAME in('ALL Reports','ALL Forms') order by STYPE,STRUCTNAME,PROPS,APPLYON DESC uname=rekhancia structure_type=tstruct structure_type=tstruct sname=axusr sname=axusr uname=rekhancia structure_type=tstruct sname=axusr structure_type=tstruct Time elapsed = 17 Select names from templates where lower(iviewid) = 'axusr' Time elapsed = 2 sname=axusr select content from AX_LAYOUTDESIGN where lower(transid)= :sname and module= 'TSTRUCT' order by created_on desc sname=axusr Time elapsed = 4 Select * from axrulesdef where lower(transid) = 'axusr' order by rulegroup,rulename Time elapsed = 3 Select * from axrulesdef_conmsg where lower(btnstransid) = 'axusr' order by btnname Time elapsed = 10 select errcode,errmsg from axpdef_errcodes where lower(errlang) = 'english'and ((lower(applicabletransid) = 'axusr') or (lower(applicabletransid) like '%,axusr,%') or (lower(applicabletransid) like 'axusr,%') or (lower(applicabletransid) like '%,axusr')) order by errlang , applicabletransid Time elapsed = 3 CheckAxProcessDef starts... CheckAxProcessDef starts... select * from AxProcessDef where lower(transid)='axusr' and lower(active)='t' and lower(tasktype)='make' Time elapsed = 1 SELECT ppm.powner as processowner , ppm.pownerflg as processownerflg, ppm.amendment, pdv.* FROM AxprocessDefV2 pdv JOIN axpdef_peg_processmaster ppm ON pdv.processname = ppm.caption WHERE lower(transid)='axusr' and lower(active)='t' and lower(tasktype)='make' and (ppm.amendment is null or ppm.amendment = '' or lower(ppm.amendment)<> 't') Time elapsed = 16 CheckAxProcessDef ends. IsAmendmentEnabled starts... SELECT ppm.powner as processowner , ppm.pownerflg as processownerflg, ppm.amendment, pdv.* FROM AxprocessDefV2 pdv JOIN axpdef_peg_processmaster ppm ON pdv.processname = ppm.caption WHERE lower(transid)='axusr' and lower(active)='t' and lower(ppm.amendment) = 't' order by indexno Time elapsed = 0 IsAmendmentEnabled ends. CheckAxProcessDef ends. Structure XML : axusrUser LogintTrueTrueFalseFalseFalseNoneDefaultFalsedc1User Login1axusersFalseTrueTrueTrueTrueFalseusernameasemailidusernameasemailidCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{T}TrueTrueFalseFalseTrueTrueeemailTrueusernameasemailid~email,pusernametransidtransidCharacter50Accept00TrueFalseFalseTrueTrueFalseFalseTrue{axusr}TrueFalseFalseFalseFalseTrueTruetransidusertypeUser TypeCharacter200Select00FalseFalseADMINTrueTrueFalseFalseTrue{ADMIN}TrueTrueFalseFalseTrueTrueTrueusertypepusernameEmail ID/Login IDCharacter300Accept00FalseFalseFalseFalseFalseFalseFalseTrueiif(getlength(pusername) < 4,{User ID should have minmum length of 4 digits},{T})FalseTrueFalseFalseTrueTrueeemail,eaxusernameFor login purposeTruepusername~email,usernameasemailid,axusernamepwdPasswordCharacter150Accept00FalseFalseFalseTrueTrueFalseFalseFalse{12345}TrueTrueFalseFalseTrue*TrueeppasswordTruepwd~ppasswordnicknameFirst NameCharacter2000Accept00FalseFalseFalseFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTrueTruenicknameppasswordpasswordCharacter500calculate00TrueTrueFalseFalseTrueiif( recordid = 0, iif(axp_md5pwd = {T},convertmd5(pwd), Encryptstr(pwd)), ppassword)TrueTrueFalseFalseTrueTrueTrueppassword,pwdaxuseraxuserCharacter250calculate00TrueTrueFalseFalseFalseusernameTrueTrueFalseFalseTrueTrueTrueaxusergroupnousergroupnumberNumeric70Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruegroupnoemailE-mailCharacter2540Accept00FalseFalseFalseFalseTrueFalseFalseTrueiif(usernameasemailid={T},pusername,email)FalseTrueFalseFalseTrueTrue*@*.*Trueemail,usernameasemailid,pusernamemobileMobileCharacter100Accept00FalseFalseFalseFalseTrueFalseFalseTrueiif(((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}))TrueTrueFalseFalseTrueTrueTruemobiledepartmentDepartmentCharacter1000Accept00TrueFalseFalseTrueTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruedepartmentbuildEnable TraceCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueedebugTruebuild~debugdebugDebugCharacter10calculate00FalseTrueFalseFalseTruebuildTrueTrueFalseFalseTrueTrueTruedebug,buildmanageUsersCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTruemanageworkflowEnable WorkflowCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTrueworkflowlogin_usernamelogin_usernameCharacter500calculate00TrueTrueFalseFalseTrueusernameTrueFalseFalseFalseFalseTrueelogin_usergroup,slogin_usergroupTruelogin_username~login_usergrouplogin_usergrouplogin_usergroupCharacter500Acceptselect b.axusergroup from axusers a , axuserlevelgroups b where a.axusersid = b.axusersid and a.pusername = :login_username 00TrueFalseFalseTrueTrueFalseFalseTrueusergroupTrueFalseFalseFalseFalseTrueTruelogin_usergroup,login_usernamesendSend/ReceiveCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTruesendimportstructImport StructuresCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTrueimportstructisfirsttimeisfirsttimeCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTrueisfirsttimepageaccesspageaccessCharacter2500Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruepageaccessreportingtoreportingtoCharacter300Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruereportingtowebskinwebskinCharacter250Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruewebskinlogintrylogintryNumeric20Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruelogintrypwdexpdayspwdexpdaysNumeric30Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruepwdexpdayslanguage_accesslanguage_accessCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruelanguage_accesslanguagelanguageCharacter250Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruelanguageexportstructExport StructureCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTrueexportstructaxpertmanagerAxpertmanagerCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTrueaxpertmanageraccesscodeaccesscodeCharacter250Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueaccesscodeappparamsappparamsCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueappparamsappmanagerApp ManagerCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueappmanagertoolsToolsCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTruetoolsactflagActiveCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{T}TrueTrueFalseFalseTrueTrueeactiveTrueactflag~activeactiveActiveCharacter10calculate00TrueTrueFalseFalseTrueactflagTrueTrueFalseFalseTrueTrueTrueactive,actflagallusergroupallusergroupCharacter20000calculate00TrueTrueFalseFalseTruegetallvalues({axusergroup},{F})TrueTrueFalseFalseTrueTrueTrueallusergroup,axusergroupviewfilterviewfilterCharacter20000calculate00TrueTrueTrueFalseFalse{and((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 )} TrueFalseFalseFalseFalseTrueTrueviewfiltertflagtflagCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseFalse{T}TrueTrueFalseFalseTrueTrueTruetflagglobal_displaytextGlobal DisplaytextCharacter3000Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueglobal_displaytextdhomepageHome PageCharacter2000SelectSELECT 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,caption00TrueTrueFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTruefhomepageTruedhomepage~homepagehomepageCharacter2000Fill00dhomepageHOMEPAGEFalseTrueTrueTrueFalseTrueTrueTrueFalseFalseTrueFalseFalsehomepage,dhomepagereset_update_flagReset/UpdateCharacter10Accept00TrueFalseFalseTrueTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTruereset_update_flagisIpIs IP authentication required?Character10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTrueisIpipaddrIP AddressCharacter10000Accept00FalseFalseFalseTrueTrueFalseFalseTrueiif(((getlength(ipaddr) = 0) & (isIp = {T})),{ cannot be left empty},{T})TrueTrueFalseFalseTrueTrueTrueipaddraxcloudtriggeraxcloudtriggerCharacter1000Acceptselect 'ALTER TRIGGER TR_AXCLOUD_USER_CREATION ENABLE' AS TR from dual00TrueTrueFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTrueaxcloudtriggerreporting_toReporting toCharacter500Accept00TrueFalseFalseTrueTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruereporting_toempidEmployee IdCharacter1000Accept00TrueFalseFalseTrueTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueempidotpauthOTP AuthenticationCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{T}TrueFalseFalseFalseFalseTrueTrueotpauthpwdauthPassword AuthenticationCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTruepwdauthportal_general_chkPortal/GeneralCharacter2000calculate00TrueTrueTrueFalseTrue{General}TrueFalseFalseFalseFalseTrueTrueportal_general_chkdc2Roles2axuserlevelgroupsTrueTrueFalseTrueTrueFalseaxusernameaxusernameCharacter1000calculate00TrueTrueFalseFalseTruepusernameTrueTrueFalseFalseTrueTrueTrueaxusername,pusernameaxusergroupRoleCharacter300Selectselect Role, GROUPNO from (SELECT GROUPNAME as Role, GROUPNO FROM AXUSERGROUPS a1 where a1.groupname <> 'admin' and :usergroup in ('default','admin') UNION select GROUPNAME as Role, GROUPNO from axusergroups a1 where :usergroup not in ('default','admin') and a1.groupname not in ('default','admin') and a1.active = 'T' )a ORDER BY Role00TrueTrueFalseFalseFalseFalseTrueFalseTrueFalseFalseTrueTrueevalidrow2,eallusergroupTrueaxusergroup~validrow2,allusergroupstartdateStart DateDate/Time100Accept00FalseFalseFalseFalseFalseFalseFalseTrueIIF( (isempty( axusergroup) = {F} & isempty( startdate) = {T}), {Assigned From should be specified for Additional Roles}, {T})TrueTrueFalseFalseTrueTrueTruestartdateenddateEnd DateDate/Time100Accept00FalseFalseFalseFalseTrueFalseFalseTrueIIF(isempty( enddate) = {T}, {T},iif( (ctod( startdate) > ctod( enddate)) , {End Date cannot be lesser than the start date}, {T}))TrueTrueFalseFalseTrueTrueTrueenddatevalidrow2validrow2Character100calculate00TrueTrueFalseFalseFalseiif(isempty(axusergroup)={F},{T},{F})TrueTrueFalseFalseTrueTrueTruevalidrow2,axusergroupsearchcolsactflag,axusergroup,build,debug,dhomepage,email,enddate,exportstruct,importstruct,manage,mobile,nickname,otpauth,pusername,pwdauth,startdate,tools,workflowremovematerial-iconslistmaterial-iconslistmaterial-iconsfact_checkmaterial-iconsdc1dc2activeF1enddate:currentdate0pusernamepusername,FalseFalseUser ImportusimpFalsetypecalc Equal to TFalseEnablevvipaccess''1FalseDisablefusertypeciftypecalcetT1vvipaccesscelse3vvipaccess3''2vvipaccessFalseHideFalseDisableTstructaxusrcamera optiontrueALLTstructaxusrCustom CSStrueALLTstructaxusrFile Upload Limit200ALLTstructaxusrGeneraltrueALLTstructaxusrGeneralfalseALLTstructaxusrGridEditinlineALLTstructaxusrprofilepicSaveImagetrueSINGLE[{"transid":"axusr","compressedMode":true,"newDesign":true,"staticRunMode":false,"wizardDC":false,"selectedLayout":"single","selectedFontSize":"14","selectedControlHeight":"24","tstUpdatedOn":"24/04/2025 13:32:35","dcLayout":"default","formWidth":"100","formAlignment":"default","fieldCaptionWidth":"30","formLabel":[],"buttonFieldFont":[],"dcs":[{"dc_id":"1","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"pusername","x":0,"y":0,"width":8,"height":1,"visibility":true},{"fld_id":"nickname","x":8,"y":0,"width":8,"height":1,"visibility":true},{"fld_id":"actflag","x":17,"y":0,"width":3,"height":1,"visibility":true},{"fld_id":"email","x":0,"y":1,"width":12,"height":1,"visibility":true},{"fld_id":"mobile","x":12,"y":1,"width":9,"height":1,"visibility":true},{"fld_id":"dhomepage","x":21,"y":1,"width":7,"height":1,"visibility":true},{"fld_id":"build","x":0,"y":2,"width":3,"height":1,"visibility":true},{"fld_id":"tools","x":3,"y":2,"width":2,"height":1,"visibility":true},{"fld_id":"workflow","x":5,"y":2,"width":4,"height":1,"visibility":true},{"fld_id":"importstruct","x":9,"y":2,"width":4,"height":1,"visibility":true},{"fld_id":"exportstruct","x":13,"y":2,"width":4,"height":1,"visibility":true},{"fld_id":"manage","x":17,"y":2,"width":3,"height":1,"visibility":true},{"fld_id":"debug","x":20,"y":2,"width":3,"height":1,"visibility":true},{"fld_id":"otpauth","x":24,"y":2,"width":4,"height":1,"visibility":true},{"fld_id":"pwdauth","x":28,"y":2,"width":5,"height":1,"visibility":true}],"tableDesign":null},{"dc_id":"2","isGrid":"T","gridStretch":false,"fieldsDesign":[{"fld_id":"axusergroup","x":0,"y":0,"width":12,"height":1,"visibility":true},{"fld_id":"startdate","x":12,"y":0,"width":9,"height":1,"visibility":true},{"fld_id":"enddate","x":21,"y":0,"width":9,"height":1,"visibility":true}],"tableDesign":[{"fld_id":"uniqueEditDeleteAct2","width":39,"visibility":true},{"fld_id":"uniqueThHead2","width":43,"visibility":true},{"fld_id":"axp_recid2","width":0,"visibility":false},{"fld_id":"axusername","width":0,"visibility":false},{"fld_id":"axusergroup","width":346,"visibility":true},{"fld_id":"startdate","width":214,"visibility":true},{"fld_id":"enddate","width":214,"visibility":true},{"fld_id":"validrow2","width":0,"visibility":false}]},{"dc_id":"3","isGrid":"T","gridStretch":false,"fieldsDesign":[{"fld_id":"charts","x":0,"y":0,"width":24,"height":1,"visibility":true},{"fld_id":"graphtype","x":24,"y":0,"width":12,"height":1,"visibility":true}],"tableDesign":[{"fld_id":"uniqueEditDeleteAct3","width":20,"visibility":true},{"fld_id":"uniqueThHead3","width":40,"visibility":true},{"fld_id":"axp_recid3","width":0,"visibility":false},{"fld_id":"charts","width":331,"visibility":true},{"fld_id":"chartgroup","width":0,"visibility":false},{"fld_id":"graphtypeflag","width":0,"visibility":false},{"fld_id":"tmp_graphtype","width":0,"visibility":false},{"fld_id":"graphtype","width":322,"visibility":true},{"fld_id":"piecolor","width":0,"visibility":false},{"fld_id":"titlelinkname","width":0,"visibility":false},{"fld_id":"filterlinkname","width":0,"visibility":false},{"fld_id":"sqltext","width":0,"visibility":false},{"fld_id":"hyptext","width":0,"visibility":false}]}],"newdcs":null}]username GetStructure webservice completed # 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:18','dd/mm/yyyy hh24:mi:ss'),to_timestamp('20/05/2025 12:33:19','dd/mm/yyyy hh24:mi:ss'),null,0,'Get Structure','success',431,71,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 Returning the structure. Getting Structure from DB rekhancia Role: default Recordid = 1884660000000 Loading Tstruct. 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 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 Quick LoadData webservice ----------------------------------- Received XML : 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_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 = 0 select * from axusers where axusersid=0 Time elapsed = 0 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 = Creating Action object Submiting & Registering data Registering Global variables data Registering Global variables data over Setting values over Record id : 1884660000000 Transid:axusr recordid:1884660000000 primarytable:axusers >>Loading transaction axusr record 1884660000000 Select a.axusersid, a.SourceId , a.mapname , a.cancel, a.cancelremarks , a.CreatedOn, a.CreatedBy , a.ModifiedOn , a.UserName , a.usernameasemailid, a.transid, a.usertype, a.pusername, a.nickname, a.ppassword, a.groupno, a.email, a.mobile, a.department, a.build, a.debug, a.manage, a.workflow, a.login_username, a.login_usergroup, a.send, a.importstruct, a.isfirsttime, a.pageaccess, a.reportingto, a.webskin, a.logintry, a.pwdexpdays, a.language_access, a.language, a.exportstruct, a.axpertmanager, a.accesscode, a.appparams, a.appmanager, a.tools, a.actflag, a.active, a.allusergroup, a.global_displaytext, a.dhomepage, a.homepage, a.reset_update_flag, a.isIp, a.ipaddr, a.reporting_to, a.empid, a.otpauth, a.pwdauth, a.portal_general_chk from AXUSERS a where a.axusersid = 1884660000000 Time elapsed = 6 Loading from 1884660000000 into frame 1, row 1 usernameasemailid = transid = axusr usertype = pusername = 11akhilvis@gmail.com nickname = Akhil Vishwanatham ppassword = c5f8de689c119f863ee4a22f2ef86f91 groupno = 0 email = 1c_11akhilvis@gmail.com mobile = 7904362037 department = build = F debug = manage = F workflow = F login_username = rekhancia login_usergroup = default 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 allusergroup = client global_displaytext = dhomepage = None homepage = 0 reset_update_flag = F isIp = ipaddr = reporting_to = empid = otpauth = T pwdauth = F portal_general_chk = Portal Select a.axuserlevelgroupsid, a.axusername, a.axusergroup, a.startdate, a.enddate,a.axuserlevelgroupsrow from AXUSERLEVELGROUPS a where a.axusersid = 1884660000000 Order by axuserlevelgroupsrow Time elapsed = 3 Loading from 1884660000001 into frame 2, row 1 axusername = 11akhilvis@gmail.com axusergroup = client startdate = 06/05/2025 enddate = Loading no-save fields Execute action from dbcall Assigning approval bar newmaxrow count=2 Preparing pwd-accept Field Value - 12345 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 Preparing axuser-calculate username = rekhancia Field Value - rekhancia build = F username = rekhancia actflag = T Result of getallvalues = client Preparing viewfilter-calculate Field Value - and((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 ) Preparing tflag-accept Field Value - T Preparing axcloudtrigger-accept select 'ALTER TRIGGER TR_AXCLOUD_USER_CREATION ENABLE' AS TR from dual Time elapsed = 0 Query opened , Record count : 1 Field Value - ALTER TRIGGER TR_AXCLOUD_USER_CREATION ENABLE pusername = 11akhilvis@gmail.com Preparing validrow2-calculate axusergroup = client Result of isempty = F Result of iif = T Field Value - T Action node in structure : FalseDisable Starting Action Execution - OnDataLoad Executing task - field access checkFillGrid : Visible dcs : Executing task field access over Action Execution over - OnDataLoad Quick Load Data JSON DC to JSON DC1 DC to JSON DC2 Field to JSON transid row 1 Field to JSON pusername row 1 Field to JSON pwd row 1 Field to JSON nickname row 1 Field to JSON ppassword row 1 Field to JSON axuser row 1 Field to JSON groupno row 1 Field to JSON email row 1 Field to JSON mobile row 1 Field to JSON build row 1 Field to JSON debug row 1 Field to JSON manage row 1 Field to JSON workflow row 1 Field to JSON login_username row 1 Field to JSON login_usergroup row 1 Field to JSON send row 1 Field to JSON importstruct row 1 Field to JSON isfirsttime row 1 Field to JSON logintry row 1 Field to JSON pwdexpdays row 1 Field to JSON exportstruct row 1 Field to JSON axpertmanager row 1 Field to JSON appmanager row 1 Field to JSON tools row 1 Field to JSON actflag row 1 Field to JSON active row 1 Field to JSON allusergroup row 1 Field to JSON viewfilter row 1 Field to JSON tflag row 1 Field to JSON dhomepage row 1 Field to JSON homepage row 1 Field to JSON reset_update_flag row 1 Field to JSON isIp row 1 Field to JSON axcloudtrigger row 1 Field to JSON otpauth row 1 Field to JSON pwdauth row 1 Field to JSON portal_general_chk row 1 Grid To JSON 2 Row Count 1 Existing Row Count 0 Field to JSON axusername row 1 Field to JSON axusergroup row 1 Field to JSON startdate row 1 Field to JSON validrow2 row 1 Quick Load Data JSON Completed # 1#Executing GetAttachments select distinct filename as fn from axusrattach where recordid = 1884660000000 uXDS\dopen\ Check intransaction Time elapsed = 3 Result : {"data":[{"n":"DC1","v":"1","t":"dc"},{"n":"axp_recid1","v":"1884660000000","r":"0","t":"s"},{"n":"transid","v":"axusr","r":"0","t":"s"},{"n":"pusername","v":"11akhilvis@gmail.com","r":"0","t":"s"},{"n":"pwd","v":"12345","r":"0","t":"s"},{"n":"nickname","v":"Akhil Vishwanatham","r":"0","t":"s"},{"n":"ppassword","v":"c5f8de689c119f863ee4a22f2ef86f91","r":"0","t":"s"},{"n":"axuser","v":"rekhancia","r":"0","t":"s"},{"n":"groupno","v":"0","r":"0","t":"s"},{"n":"email","v":"1c_11akhilvis@gmail.com","r":"0","t":"s"},{"n":"mobile","v":"7904362037","r":"0","t":"s"},{"n":"build","v":"F","r":"0","t":"s"},{"n":"debug","v":"F","r":"0","t":"s"},{"n":"manage","v":"F","r":"0","t":"s"},{"n":"workflow","v":"F","r":"0","t":"s"},{"n":"login_username","v":"rekhancia","r":"0","t":"s"},{"n":"login_usergroup","v":"default","r":"0","t":"s"},{"n":"send","v":"F","r":"0","t":"s"},{"n":"importstruct","v":"F","r":"0","t":"s"},{"n":"isfirsttime","v":"F","r":"0","t":"s"},{"n":"logintry","v":"0","r":"0","t":"s"},{"n":"pwdexpdays","v":"0","r":"0","t":"s"},{"n":"exportstruct","v":"F","r":"0","t":"s"},{"n":"axpertmanager","v":"","r":"0","t":"s"},{"n":"appmanager","v":"","r":"0","t":"s"},{"n":"tools","v":"F","r":"0","t":"s"},{"n":"actflag","v":"T","r":"0","t":"s"},{"n":"active","v":"T","r":"0","t":"s"},{"n":"allusergroup","v":"client","r":"0","t":"s"},{"n":"viewfilter","v":"and((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 )","r":"0","t":"s"},{"n":"tflag","v":"T","r":"0","t":"s"},{"n":"dhomepage","v":"None","r":"0","idcol":"no","id":"0","oldid":"0","t":"c"},{"n":"homepage","v":"0","r":"0","t":"s"},{"n":"reset_update_flag","v":"F","r":"0","t":"s"},{"n":"isIp","v":"","r":"0","t":"s"},{"n":"axcloudtrigger","v":"ALTER TRIGGER TR_AXCLOUD_USER_CREATION ENABLE","r":"0","t":"s"},{"n":"otpauth","v":"T","r":"0","t":"s"},{"n":"pwdauth","v":"F","r":"0","t":"s"},{"n":"portal_general_chk","v":"General","r":"0","t":"s"},{"n":"DC2","v":"1","cr":"i1","t":"dc","hasdatarows":"yes"},{"n":"axp_recid2","v":"1884660000001","r":"1","t":"s"},{"n":"axusername","v":"11akhilvis@gmail.com","r":"1","t":"s"},{"n":"axusergroup","v":"client","r":"1","idcol":"no","id":"0","oldid":"0","mr":"1","t":"c"},{"n":"startdate","v":"06/05/2025","r":"1","t":"s"},{"n":"validrow2","v":"T","r":"1","t":"s"}]}*$*{"formcontrol":[{"readonlytrans":"no"},{"fldname":"pusername000F0","fldact":"disable"},{"fldname":"pwd000F0","fldact":"disable"},{"fldname":"ppassword000F0","fldact":"disable"}]} Quick LoadData 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:19','dd/mm/yyyy hh24:mi:ss'),to_timestamp('20/05/2025 12:33:19','dd/mm/yyyy hh24:mi:ss'),'axusr',1884660000000,'Quick Load Data','success',358,21,0) uXDS\pinsert\ Check intransaction Closing connection Freeing AxProvider Resources 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 Getting structure from Cache. Loading tstruct.aspx completed End Time : 20/05/2025 12:33:19 Getting structure from Cache.