question

Bob Z. avatar image
Bob Z. asked ·

Was there a change to what is saved in the "daily reports" database. (aka reporting DB)

I have recently upgraded to v19 of NAM. I have a report that filters on selected Tasks and Operations and this report works fine for a previous day or days as long as my resolution is set to something less than a day. As soon I run the report with the resolution set to a day, I do not receive any results. I know that "daily" data is pulled from a different database from where the "5 min / hourly" data is pulled and is populated when the nightly jobs run. I have confirmed that the nightly jobs have been running fine. Is Task/Operation details no longer being stored in the reporting DB?

reportsnam 2019
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

1 Answer

Jacek J. avatar image
Jacek J. answered ·

Hi Bob,


This is correct, with daily time resolution, NAM server uses different tables in database than in case of resolution of 5 minutes or similar.

Still, it doesn't explain the effect you have described. It looks like something we need to take a closer look. What I can suggest now is to create support ticket, include export config, include screenshots and definitions of your reports (if we're talking about customized reports).

We will go back to you with answer as soon as we analyze the issue, but data I mentioned above is crucial here.


Best Regards,


Jacek

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.