Hi All,
A report that has been running months without any problem, suddenly returns a error saying 'Invoking the web service failed with the following message: Index out of bounds'.
Googling on this message only resulted in 1 result for JetExpress. I am working with JetProfessional 2015, and this is the first time I encountered this problem.
It has to do with exceeding maximum limits in Excel, but even limiting the number of results (deleted colums, small business unit with 400-500 rows of data) results in the same error.
My IT department has no clue as to what might be causing this, so I hope this forum can help me solve this .
All suggestions are welcome!
Thanks in advance,
Willem@marin
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hello Willem@marin,
Since you are utilizing Web Services data source, it is possible that the number of records being returned in the report is causing the error to occur.
Are you utilizing an NL("Table") function in this report?
Or using an NL("Rows") function? If using a row replicator, I would suggest adding a Limit= to the replicator function. Start with 1000 records, test the report with this and see if the report runs successfully. If no issues, change the number of records incrementally and testing in-between to determine at which point the issue is encountered with the number of records being returned.
There are some changes in the report and in the NAV Server instance that you can make that can be helpful in addressing performance issues with Web Services.
Please see below:
https://jetsupport.jetreports.com/hc/en-us/articles/218954498-Jet-Professional-Performance-with-NAV-2013-2016-Web-Services
What is the version of Jet Professional that you are utilizing? If you are not on the latest release, I would recommend upgrading.
https://www.jetreports.com/downloads/?product=jet-professional
Are you able to utilize Direct SQL data source connection?
If you have direct access to the SQL Server on which your database is stored, this data source type can provide substantially faster reporting access than is traditionally possible through NAV's Web Services. And you will generally see a 50-70% increase in performance compared to using Web Services.
Also, share a copy of the report so we can take a closer look.
Cheers, -
Jet Reports Historic Posts Hi CCJetXP,
Thanks for your reply; it helped me changing my focus on what was happening in the reprort.
I reviewed the report and managed to weed out a number of unnecessary formulas, filters and even a NP(Union) function, and that last change seems to have done the trick.
The report is now running smooyhly as ever and doesn't crash with an error.
It goes to show that it is always a good idea to check up on your reports now and again, whether or not there are problems running them.
Thanks again for helping me getting my focus on the right things.
Kind regards,
Willem
Please sign in to leave a comment.