Start a Conversation

Solved!

Go to Solution

1630

June 18th, 2020 06:00

RunReport no longer working after upgrade from 3.31 to 3.4

Using a POST call to

/api/ReportService/Actions/ReportService.RunReport

with a body of

{
    "FilterGroupId":  0,
    "ReportDefId":  57514
}

returns this error

{
    "error": {
        "code": "Base.1.0.GeneralError",
        "message": "A general error has occurred. See ExtendedInfo for more information.",
        "@Message.ExtendedInfo": [
            {
                "MessageId": "CGEN1004",
                "MessageId": "CGEN1004",
                "RelatedProperties": [],
                "Message": "Unable to complete the request because  null  does not exist or is not applicable for the resource URI.",
                "MessageArgs": [
                    null
                ],
                "Severity": "Critical",
                "Resolution": "Check the request resource URI. Refer to the OpenManage Enterprise-Modular User's Guide for more information about resource URI and its properties."
            }
        ]
    }
}

 

Looked at "/api/ReportService" which came back with

{
    "@odata.context": "/api/$metadata#ReportService.ReportService",
    "@odata.type": "#ReportService.ReportService",
    "@odata.id": "/api/ReportService",
    "Actions": null,
    "ReportDefs@odata.navigationLink": "/api/ReportService/ReportDefs",
    "ReportResults@odata.navigationLink": "/api/ReportService/ReportResults",
    "ResultRows@odata.navigationLink": "/api/ReportService/ResultRows"
}

 

Are actions no longer supported for reports? Any help would be appreciated.

June 18th, 2020 23:00

@JoeyKleinsorge 

Please run the API to fetch the Report Definitions

URL : https:// Address>/api/ReportService/ReportDefs

Method : Get

Once all the report definitions are displayed, please use the respective report definition to run a report

URL : https:// /api/ReportService/Actions/ReportService.RunReport

Method : Post

Payload :

{
"ReportDefId": ,
"FilterGroupId": 0
}

 

 

Thanks,

Anil Kumar V K R

#Iwork4Dell

2.9K Posts

June 18th, 2020 13:00

Hi Joey,

 

I ran this on my test appliance and it worked there. What if happens when you run a GET query against the following:

 

/api/ReportService/ReportDefs(57514)

June 19th, 2020 05:00

Thanks for the help @anilkumarvkr and @Dell-DylanJ 

It seems that all of the built in reports I have been using changed IDs after the upgrade. The "Warranties Expiring in Next 30 Days" report is now 110362.

Do either of you know if this is going to happen with every upgrade? We currently use scripts that run and then get the results of a few reports, and they all have the report IDs hard-coded. Do I need to run a ReportDef and search for the report name to get the correct ID every time? 

June 19th, 2020 21:00

@JoeyKleinsorge 

The Report definitions do change when the appliance is upgraded

Thanks,
Anil Kumar V K R
#Iwork4Dell
No Events found!

Top