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

                      Overview: Automatically creating projects in Zoho Projects based on the changes in SDP MSP keeps everything in sync without manual updates. This means all tasks and updates on a Change are automatically reflected in Zoho Projects, making it easier to ...

                    • Automatically create MS Planner tasks in SDP Projects using MS Power Automate.

                      In many organizations, project teams use various tools to manage their tasks. For instance, a team might use Microsoft Planner (MS Planner) to organize and assign tasks due to its simplicity and integration with other Microsoft 365 applications. ...

                    • 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 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 ...

                      Related Products