We have been using Jet Express for approx. 1 year without issue. In December our non administrator uses were receiving errors when running their reports:
]The pivot table 'PivotTable2' could not be refreshed. The following error was reported: 'Reference is not valid'.
Upon testing the connection the error received:
The url 'http://xx.xx.x.xx:7047/DynamicsNAV70/WS/MMCC/Services' is not valid. The following error was reported: The remote server returned an error:(500) Internal Server Error.
After 3 days users were again able to run reports without issue. We assumed it must have been a windows update.
Since Jan 5th users are again unable to run reports and get same errors. All users in IT dept can run reports and if you log into any PC under network admin you can run reports however if you give user admin privileges reports still will not run.
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello metricit,
The error "The pivot table 'PivotTable2' could not be refreshed. The following error was reported: 'Reference is not valid'. " is a product of the report not running correctly due to a connection not being established with the NAV Web Service.
Generally I have seen the error "The remote server returned an error:(500) Internal Server Error." produced with conflicting Codeunits and Pages that are published within the instance.
There are a few options to test.
1) Create a separate NAV instance with only the Jet Codeunit published.
2) Unpublish all Codeunits and Pages. Republish the Jet Codeunit. Test the connection. If successful, republish the other Codeunits and Pages one at a time, testing the connection after publishing each one. If you run into a Codeunit or Page that is creating a conflict then you will need to investigate why this is occurring.
Regards,
MWilson -
Jet Reports Historic Posts Thank you - we sent your reply to our programmer. There is a conflict with web services that they are now troubleshooting.
Please sign in to leave a comment.