I have just installed Express Jet reports with NAV 2013 R2 and have created my first very simple report. When I refresh the report I get the following error:
"Invoking the web service failed with the following message: The metadata object table 14125600 was not found"
Notes:
Jet reports is connecting to NAV and allows me to access tables and create report
I have windows authentication and have NAV SUPER permissions
The objects have been loaded into NAV
Has any one else seen this problem?
Date
Votes
6 comments
-
Jet Reports Historic Posts Since it seems like all of the permssions are correct, perhaps try to import the .fob file again. Something might have gotten corrupted in NAV.
To install the .fob file open the Microsoft Dynamics NAV Development Environment and then
connect to the database.
- Open the Object Designer (on the Tools menu, choose Object Designer)
- Import the .fob file (on the File menu, choose Import)
- Locate the import file (Jet Reports Objects.fob), and then choose Open.
- The .fob file includes modified objects. When prompted choose Yes to import all objects.
- Verify that no objects are to be skipped. Objects are skipped if the version of the object in the database is later than the one in the .fob file.
- Choose the OK button to import the .fob file.
The .fob file installs a set of business objects in codeunits 14125500-14125504 and Table 14125600. -
Jet Reports Historic Posts Hi,
i have the same problem.
Jet reports is connecting to NAV and allows me to access the tables and create a report.
But when the report is about to show i get the error
"Invoking the web service failed with the following message: The metadata object table 14125600 was not found"
I have NAV User Password Authentication and have NAV SUPER permissions for the user.
Jet is connected via web services.
The objects have been loaded into NAV and everything goes fine till upon that point.
In NAV Development environment it states that i don't have read permissions to read the Jet cancellation Table.
I tried to reinstall the objects but that didnt help.
Any ideas?
Regards
Johannes -
Jet Reports Historic Posts Hello JohannesDB,
If you are connecting to Dynamics NAV 2013 via Web Services then Jet Express users must have Read, Insert, Modify, Delete (RIMD-) permissions to Table and Table Data for 14125600 “Jet Cancellation”.
Best regards,
MWilson -
Jet Reports Historic Posts Hello JohannesDB,
As a follow up, this can also happen in both standard and multi-tenant environments if the table is not compiled.
I have seen this occur when table was added after the tenants had been mounted and the table was not compiled.
Once the table was compiled the reports began to work as expected.
Best regards,
MWilson -
Jet Reports Historic Posts Thank you so much MWilson!
After compiling the table it works.
Regards
Johannes -
Please sign in to leave a comment.