Start Time : 26/05/2025 16:20:43 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 = 0 select props from axprops where lower(name)='app' order by blobno uXDS\dopen\ Check intransaction Time elapsed = 0 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 = 0 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_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 = 0 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 = 16 Step5 select ' '::varchar(250) as lval Time elapsed = 0 select ' '::varchar(250) as lval Time elapsed = 0 Evaluating {T} Result = T Evaluating {axusr} Result = axusr Evaluating {ADMIN} Result = ADMIN Evaluating {General} Result = General 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 username username = rekhancia Result = rekhancia Evaluating {F} Result = F 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 and ?portal_general_chk = 'General' )} Result = 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 {T} Result = T Evaluating {F} Result = F Evaluating {F} Result = F Evaluating {T} Result = T Evaluating {F} Result = F Evaluating pusername pusername = 1 Result = 1 Evaluating Date() Calling function date Result of date = 26/05/2025 Result = 26/05/2025 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 : portal_general_chk 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 : client_details Field Name : department Field Name : build Field Name : debug Field Name : manage Field Name : login_username Field Name : workflow 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 : dc2 Field Name : axusername Field Name : axusergroup Field Name : startdate Field Name : enddate Field Name : validrow2 Field Name : scripts 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 = 10 Select names from templates where lower(iviewid) = 'axusr' Time elapsed = 1 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 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 = 2 CheckAxProcessDef starts... CheckAxProcessDef starts... select * from AxProcessDef where lower(transid)='axusr' and lower(active)='t' and lower(tasktype)='make' Time elapsed = 5 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 = 10 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 = 9 IsAmendmentEnabled ends. CheckAxProcessDef ends. Structure XML : axusrUser LogintTrueTrueFalseFalseFalseNoneDefaultFalsedc1User Login1axusersFalseTrueTrueTrueTrueFalseusernameasemailidusernameasemailidCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{T}TrueTrueFalseFalseTrueTrueeemailTrueusernameasemailid~email,pusernametransidtransidCharacter50Accept00TrueFalseFalseTrueTrueFalseFalseTrue{axusr}TrueFalseFalseFalseFalseTrueTruetransidusertypeUser TypeCharacter200Select00FalseFalseADMINTrueTrueFalseFalseTrue{ADMIN}TrueTrueFalseFalseTrueTrueTrueusertypeportal_general_chkPortal/GeneralCharacter1000Select00FalseFalsePortalGeneralFalseTrueTrueFalseTrue{General}TrueTrueFalseFalseTrueTrueeallusergroup,saxusergroup,evalidrow2Trueportal_general_chk~allusergroup,axusergroup,validrow2pusernameEmail ID/Login IDCharacter5000Accept00FalseFalseFalseFalseFalseFalseFalseTrueiif(getlength(pusername) < 4,{User ID should have minmum length of 4 digits},{T})FalseTrueFalseFalseTrueTrueeemail,sclient_details,eaxusernameFor login purposeTruepusername~email,usernameasemailid,client_details,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}))TrueTrueFalseFalseTrueTrueTruemobileclient_detailsClient DetailsText40000Acceptselect STRING_AGG(CONCAT(a.client_code, ':' , a.client_name), ', ') AS Concatenated_Client_Info from client_details a where lower(a.primary_emailid) = lower( :pusername)00TrueFalseFalseFalseTrueTrueFalseTrueTrueFalseFalseFalseFalseTrueTrueclient_details,pusernamedepartmentDepartmentCharacter1000Accept00TrueFalseFalseTrueTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruedepartmentbuildEnable TraceCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueedebugTruebuild~debugdebugDebugCharacter10calculate00FalseTrueFalseFalseTruebuildTrueTrueFalseFalseTrueTrueTruedebug,buildmanageUsersCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTruemanagelogin_usernamelogin_usernameCharacter500calculate00TrueTrueFalseFalseTrueusernameTrueFalseFalseFalseFalseTrueelogin_usergroup,slogin_usergroupTruelogin_username~login_usergroupworkflowEnable WorkflowCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTrueworkflowlogin_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 and ?portal_general_chk = 'General' )} 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}TrueFalseFalseFalseFalseTrueTruepwdauthdc2Roles2axuserlevelgroupsTrueTrueFalseTrueTrueFalseaxusernameaxusernameCharacter1000calculate00TrueTrueFalseFalseTruepusernameTrueTrueFalseFalseTrueTrueTrueaxusername,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' union select GROUPNAME as Role, GROUPNO from axusergroups a1 where a1.groupname in ('client') and :portal_general_chk = 'Portal' )a ORDER BY Role00TrueTrueFalseFalseFalseFalseTrueFalseTrueFalseFalseTrueTrueevalidrow2,eallusergroupTrueaxusergroup,portal_general_chk~validrow2,allusergroupstartdateStart DateDate/Time100Accept00FalseTrueFalseFalseFalseFalseFalseTrueDate()IIF( (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,axusergroup,portal_general_chkif portal_general_chk = {Portal} AxHideControls({dhomepage}) AxHideControls({build}) AxHideControls({tools}) AxHideControls({workflow}) AxHideControls({importstruct}) AxHideControls({exportstruct}) AxHideControls({manage}) AxHideControls({debug}) AxDisableControls({pusername}) AxDisableControls({axusergroup}) RefreshFrame({dc2})end if if portal_general_chk = {Portal} AxHideControls({dhomepage}) AxHideControls({build}) AxHideControls({tools}) AxHideControls({workflow}) AxHideControls({importstruct}) AxHideControls({exportstruct}) AxHideControls({manage}) AxHideControls({debug}) AxDisableControls({pusername}) AxDisableControls({axusergroup}) AxDisableControls({startdate})end if searchcolsactflag,axusergroup,build,debug,dhomepage,email,enddate,exportstruct,importstruct,manage,mobile,nickname,otpauth,portal_general_chk,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":"26/05/2025 16:16:31","dcLayout":"default","formWidth":"100","formAlignment":"default","fieldCaptionWidth":"30","formLabel":[],"buttonFieldFont":[],"dcs":[{"dc_id":"1","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"portal_general_chk","x":0,"y":0,"width":8,"height":1,"visibility":true},{"fld_id":"pusername","x":8,"y":0,"width":9,"height":1,"visibility":true},{"fld_id":"nickname","x":17,"y":0,"width":8,"height":1,"visibility":true},{"fld_id":"dhomepage","x":25,"y":0,"width":6,"height":1,"visibility":true},{"fld_id":"email","x":0,"y":1,"width":11,"height":1,"visibility":true},{"fld_id":"mobile","x":11,"y":1,"width":6,"height":1,"visibility":true},{"fld_id":"actflag","x":17,"y":1,"width":3,"height":1,"visibility":true},{"fld_id":"otpauth","x":20,"y":1,"width":5,"height":1,"visibility":true},{"fld_id":"pwdauth","x":25,"y":1,"width":6,"height":1,"visibility":true},{"fld_id":"build","x":0,"y":2,"width":4,"height":1,"visibility":true},{"fld_id":"debug","x":4,"y":2,"width":4,"height":1,"visibility":true},{"fld_id":"manage","x":8,"y":2,"width":3,"height":1,"visibility":true},{"fld_id":"workflow","x":11,"y":2,"width":4,"height":1,"visibility":true},{"fld_id":"importstruct","x":15,"y":2,"width":5,"height":1,"visibility":true},{"fld_id":"exportstruct","x":20,"y":2,"width":5,"height":1,"visibility":true},{"fld_id":"tools","x":25,"y":2,"width":6,"height":1,"visibility":true},{"fld_id":"client_details","x":0,"y":3,"width":17,"height":2,"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":339,"visibility":true},{"fld_id":"startdate","width":207,"visibility":true},{"fld_id":"enddate","width":207,"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 ('etdzm0ronr0phiio123xdwtw','rekhancia',to_timestamp('26/05/2025 16:20:43','dd/mm/yyyy hh24:mi:ss'),to_timestamp('26/05/2025 16:20:44','dd/mm/yyyy hh24:mi:ss'),null,0,'Get Structure','success',456,57,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 = 0 Opening 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 = 0 select props from axprops where lower(name)='app' order by blobno uXDS\dopen\ Check intransaction Time elapsed = 16 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 = 0 Db Manager Connection ends Connection to DB Successful Executing Quick DoFormLoad webservice ------------------------------------- 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 = 0 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_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 Received SXML axusrUser LogintTrueTrueFalseFalseFalseNoneDefaultFalsedc1User Login1axusersFalseTrueTrueTrueTrueFalseusernameasemailidusernameasemailidCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{T}TrueTrueFalseFalseTrueTrueeemailTrueusernameasemailid~email,pusernametransidtransidCharacter50Accept00TrueFalseFalseTrueTrueFalseFalseTrue{axusr}TrueFalseFalseFalseFalseTrueTruetransidusertypeUser TypeCharacter200Select00FalseFalseADMINTrueTrueFalseFalseTrue{ADMIN}TrueTrueFalseFalseTrueTrueTrueusertypeportal_general_chkPortal/GeneralCharacter1000Select00FalseFalsePortalGeneralFalseTrueTrueFalseTrue{General}TrueTrueFalseFalseTrueTrueeallusergroup,saxusergroup,evalidrow2Trueportal_general_chk~allusergroup,axusergroup,validrow2pusernameEmail ID/Login IDCharacter5000Accept00FalseFalseFalseFalseFalseFalseFalseTrueiif(getlength(pusername) < 4,{User ID should have minmum length of 4 digits},{T})FalseTrueFalseFalseTrueTrueeemail,sclient_details,eaxusernameFor login purposeTruepusername~email,usernameasemailid,client_details,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}))TrueTrueFalseFalseTrueTrueTruemobileclient_detailsClient DetailsText40000Acceptselect STRING_AGG(CONCAT(a.client_code, ':' , a.client_name), ', ') AS Concatenated_Client_Info from client_details a where lower(a.primary_emailid) = lower( :pusername)00TrueFalseFalseFalseTrueTrueFalseTrueTrueFalseFalseFalseFalseTrueTrueclient_details,pusernamedepartmentDepartmentCharacter1000Accept00TrueFalseFalseTrueTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruedepartmentbuildEnable TraceCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueedebugTruebuild~debugdebugDebugCharacter10calculate00FalseTrueFalseFalseTruebuildTrueTrueFalseFalseTrueTrueTruedebug,buildmanageUsersCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTruemanagelogin_usernamelogin_usernameCharacter500calculate00TrueTrueFalseFalseTrueusernameTrueFalseFalseFalseFalseTrueelogin_usergroup,slogin_usergroupTruelogin_username~login_usergroupworkflowEnable WorkflowCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTrueworkflowlogin_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 and ?portal_general_chk = 'General' )} 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}TrueFalseFalseFalseFalseTrueTruepwdauthdc2Roles2axuserlevelgroupsTrueTrueFalseTrueTrueFalseaxusernameaxusernameCharacter1000calculate00TrueTrueFalseFalseTruepusernameTrueTrueFalseFalseTrueTrueTrueaxusername,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' union select GROUPNAME as Role, GROUPNO from axusergroups a1 where a1.groupname in ('client') and :portal_general_chk = 'Portal' )a ORDER BY Role00TrueTrueFalseFalseFalseFalseTrueFalseTrueFalseFalseTrueTrueevalidrow2,eallusergroupTrueaxusergroup,portal_general_chk~validrow2,allusergroupstartdateStart DateDate/Time100Accept00FalseTrueFalseFalseFalseFalseFalseTrueDate()IIF( (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,axusergroup,portal_general_chkif portal_general_chk = {Portal} AxHideControls({dhomepage}) AxHideControls({build}) AxHideControls({tools}) AxHideControls({workflow}) AxHideControls({importstruct}) AxHideControls({exportstruct}) AxHideControls({manage}) AxHideControls({debug}) AxDisableControls({pusername}) AxDisableControls({axusergroup}) RefreshFrame({dc2})end if if portal_general_chk = {Portal} AxHideControls({dhomepage}) AxHideControls({build}) AxHideControls({tools}) AxHideControls({workflow}) AxHideControls({importstruct}) AxHideControls({exportstruct}) AxHideControls({manage}) AxHideControls({debug}) AxDisableControls({pusername}) AxDisableControls({axusergroup}) AxDisableControls({startdate})end if removematerial-iconslistmaterial-iconslistmaterial-iconsfact_checkmaterial-iconsdc1dc2activeF1enddate:currentdate0pusernamepusername,FalseFalseUser ImportusimpFalsetypecalc Equal to TFalseEnablevvipaccess''1FalseDisablefusertypeciftypecalcetT1vvipaccesscelse3vvipaccess3''2vvipaccessFalseHideFalseDisable Creating DbCall Evaluating {T} Result = Evaluating pusername Result = Evaluating {axusr} Result = Evaluating {ADMIN} Result = Evaluating {General} 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 {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 {T} Result = Evaluating {F} 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(axusergroup)={F},{T},{F}) Result = Evaluating iif(getlength(pusername) < 4,{User ID should have minmum length of 4 digits},{T}) Result = Submiting & Registering data Registering Global variables data Registering Global variables data over Setting values over Creating Action object Time taken to connect and submit - 214 Action node in structure : FalseHide Starting Action Execution - OnFormLoad Executing task - field access checkFillGrid : Visible dcs :'dc1','dc2' Executing task field access over Action Execution over - OnFormLoad Action node in structure : if portal_general_chk = {Portal} AxHideControls({dhomepage}) AxHideControls({build}) AxHideControls({tools}) AxHideControls({workflow}) AxHideControls({importstruct}) AxHideControls({exportstruct}) AxHideControls({manage}) AxHideControls({debug}) AxDisableControls({pusername}) AxDisableControls({axusergroup}) RefreshFrame({dc2})end if Starting Action Execution - script1 Executing task - scripts Assigning expression set to parser Expression : if portal_general_chk = {Portal} AxHideControls({dhomepage}) AxHideControls({build}) AxHideControls({tools}) AxHideControls({workflow}) AxHideControls({importstruct}) AxHideControls({exportstruct}) AxHideControls({manage}) AxHideControls({debug}) AxDisableControls({pusername}) AxDisableControls({axusergroup}) RefreshFrame({dc2}) end if Evaluating portal_general_chk = {Portal} portal_general_chk = Result = 0 Executing task scripts over Action Execution over - script1 Quick Form Load JSON Executing fill Grid 1 Preparing usernameasemailid-accept Field Value - T DC to JSON DC1 Field to JSON usernameasemailid row 1 Preparing transid-accept Field Value - axusr Field to JSON transid row 1 Preparing usertype-select Field Value - ADMIN Field to JSON usertype row 1 Preparing portal_general_chk-select Field Value - General Field to JSON portal_general_chk row 1 Preparing pusername-accept Field Value - Preparing pwd-accept Field Value - 12345 Field to JSON pwd row 1 Preparing ppassword-calculate pwd = 12345 Result of encryptstr = 05000000F34AC2E6E09F3DD7DF3783698DC17A4A pwd = 12345 Result of convertmd5 = 827ccb0eea8a706c4c34a16891f84e7b axp_md5pwd = T Result of iif = 827ccb0eea8a706c4c34a16891f84e7b recordid = 0 ppassword = Result of iif = 827ccb0eea8a706c4c34a16891f84e7b Field Value - 827ccb0eea8a706c4c34a16891f84e7b Field to JSON ppassword row 1 Preparing axuser-calculate username = rekhancia Field Value - rekhancia Field to JSON axuser row 1 Preparing email-accept usernameasemailid = T pusername = email = Result of iif = Field Value - Preparing client_details-accept pusername= select STRING_AGG(CONCAT(a.client_code, ':' , a.client_name), ', ') AS Concatenated_Client_Info from client_details a where lower(a.primary_emailid) = lower( :pusername) pusername= Time elapsed = 0 Query opened , Record count : 1 Field Value - Preparing build-accept Field Value - F Field to JSON build row 1 Preparing debug-calculate build = F Field Value - F Field to JSON debug row 1 Preparing manage-accept Field Value - F Field to JSON manage row 1 Preparing login_username-calculate username = rekhancia Field Value - rekhancia Field to JSON login_username row 1 Preparing workflow-accept Field Value - F Field to JSON workflow row 1 Preparing login_usergroup-accept 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 = 0 Query opened , Record count : 1 Field Value - default Field to JSON login_usergroup row 1 Preparing send-accept Field Value - F Field to JSON send row 1 Preparing importstruct-accept Field Value - F Field to JSON importstruct row 1 Preparing isfirsttime-accept Field Value - F Field to JSON isfirsttime row 1 Preparing exportstruct-accept Field Value - F Field to JSON exportstruct row 1 Preparing axpertmanager-accept Field Value - F Field to JSON axpertmanager row 1 Preparing tools-accept Field Value - F Field to JSON tools row 1 Preparing actflag-accept Field Value - T Field to JSON actflag row 1 Preparing active-calculate actflag = T Field Value - T Field to JSON active row 1 Preparing allusergroup-calculate Result of getallvalues = Field Value - 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 and ?portal_general_chk = 'General' ) Field to JSON viewfilter row 1 Preparing tflag-accept Field Value - T Field to JSON tflag row 1 Preparing dhomepage-select 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 = 0 Query opened , Record count : 15 Field Value - Preparing homepage-fill Field Value - Preparing reset_update_flag-accept Field Value - F Field to JSON reset_update_flag row 1 Preparing isIp-accept Field Value - F Field to JSON isIp row 1 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 Field to JSON axcloudtrigger row 1 Preparing otpauth-accept Field Value - T Field to JSON otpauth row 1 Preparing pwdauth-accept Field Value - F Field to JSON pwdauth row 1 Executing fill Grid 2 DC to JSON Quick Form load JSON completed 57 Result : {"data":[{"n":"DC1","v":"1","t":"dc"},{"n":"axp_recid1","v":"0","r":"0","t":"s"},{"n":"usernameasemailid","v":"T","r":"0","t":"s"},{"n":"transid","v":"axusr","r":"0","t":"s"},{"n":"usertype","v":"ADMIN","r":"0","t":"c"},{"n":"portal_general_chk","v":"General","r":"0","t":"c"},{"n":"pwd","v":"12345","r":"0","t":"s"},{"n":"ppassword","v":"827ccb0eea8a706c4c34a16891f84e7b","r":"0","t":"s"},{"n":"axuser","v":"rekhancia","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":"login_username","v":"rekhancia","r":"0","t":"s"},{"n":"workflow","v":"F","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":"exportstruct","v":"F","r":"0","t":"s"},{"n":"axpertmanager","v":"F","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":"viewfilter","v":"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' )","r":"0","t":"s"},{"n":"tflag","v":"T","r":"0","t":"s"},{"n":"reset_update_flag","v":"F","r":"0","t":"s"},{"n":"isIp","v":"F","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"}]}*$*{"formcontrol":[{"readonlytrans":"no"},{"dc":"dc5","dcact":"hide"},{"fldname":"pwd000F0","fldact":"enable"}]}*$*{"globalVars":[{"n":"username","v":"rekhancia"}]} Time taken by Quick FormLoad - 73 Quick DoFormLoad 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:20:44','dd/mm/yyyy hh24:mi:ss'),to_timestamp('26/05/2025 16:20:44','dd/mm/yyyy hh24:mi:ss'),'axusr',0,'Quick Form Load','success',312,16,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 : 26/05/2025 16:20:44