Error in updating Projects (17977 ID - Fixed) - 14503

Error in updating Projects (17977 ID - Fixed) - 14503

Unable to edit the project details and throws unexpected error


Issue ID =  17977 


Trace:

com.adventnet.customview.CustomViewException: Invalid Table alias WorkOrderAccountMapping specified |
    at com.adventnet.customview.table.SDTableModelCoreServiceProvider.execute(SDTableModelCoreServiceProvider.java:716)|
    at com.adventnet.customview.table.SDTableModelCoreServiceProvider.getTotalCount(SDTableModelCoreServiceProvider.java:596)|
    at com.adventnet.customview.table.SDTableModelCoreServiceProvider.checkRangeBasedOnTotal(SDTableModelCoreServiceProvider.java:294)|
    at com.adventnet.customview.table.SDTableModelCoreServiceProvider.getModelData(SDTableModelCoreServiceProvider.java:768)|
    at com.adventnet.customview.table.SDTableModelCoreServiceProvider.process(SDTableModelCoreServiceProvider.java:187)|
    at com.adventnet.customview.service.authorization.TableModelScopingProvider.process(TableModelScopingProvider.java:87)|
    at com.adventnet.customview.service.SQTemplateValuesServiceProvider.process(SQTemplateValuesServiceProvider.java:100)|
    at com.adventnet.customview.CustomViewManagerImpl.getData(CustomViewManagerImpl.java:277)|
    at sun.reflect.GeneratedMethodAccessor99.invoke(Unknown Source)|
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)|
    at java.lang.reflect.Method.invoke(Method.java:498)|
    at com.adventnet.mfw.bean.BeanProxy.invoke(BeanProxy.java:53)|
    at com.sun.proxy.$Proxy4.getData(Unknown Source)|
    at com.adventnet.servicedesk.query.util.HdSelectQueryUtil.getTableModel(HdSelectQueryUtil.java:298)|
    at com.manageengine.servicedesk.project.util.ProjectRequestAssociationUtil.getProjectRequestsCount(ProjectRequestAssociationUtil.java:302)|
    at com.manageengine.servicedesk.project.form.ProjectForm.getAssociatedRequestCount(ProjectForm.java:1230)|
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)|



 
        New to M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                  See all integrations
                  New to ADManager Plus?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial
                    Start your free trial

                      • Related Articles

                      • Integrating Zoho Projects with SDP MSP change management

                        PURPOSE: When a change is created or edited as required, a project is created in Zoho Projects respectively. Here is an example of creating a project in Zoho Projects when a change is created under a specific site in SDP MSP. TESTED IN MSP BUILDS: ...

                      • Query to pull Account ID and Site ID (MSSQL & PGSQL)

                        Tested in Build PGSQL (14300) or MSSQL (14306) Go to Reports Tab >> New Query Report and run the below query. For Postgres & MS SQL select adef.org_id "Account ID", adef.org_name "account",sdef.siteid "Siteid", sdo.name "Site" from sitedefinition ...

                      • Updating Account ID and Site ID using orca editor

                        Steps to edit account id & siteid in registry using "orca editor" 1.Download and install the orca editor from this link - 2.Open the ManageEngineAssetExplorerAgent.msi using orca editor 3.Select the Registry table in the left nav and edit Account id ...

                      • Update request additional field with Custom Request ID

                        Requirement: Each Organization's request ID format may differ. In the current model, replacing the existing request id with these is not possible; however, the same can be replaced in an additional field. Custom Format : Example: 202305221125001 ...

                      • Query to show requests and its associations with Problems, Changes and Projects (MSSQL)

                        Working on Builds: 14500 and above Database: MSSQL SELECT wo.WORKORDERID AS "Request ID", pim.problemid "Associated Problem ID", icm.changeid "Associated Change ID", wtp.projectid "Associated Project ID", CASE WHEN (wo.is_catalog_template) = 'false' ...

                        Related Products