Question Status

Suggested Answer
SomuAx2012 asked a question on 7 Oct 2013 1:30 PM

SSRS error log syas: 

Query execution failed for dataset 'TaxTransDS' ---> System.InvalidOperationException: An exception occurred in the query metadata execution. The exception is No data to create a bookmark.

I am running the standard report with no customizations. Any body came across this? Please help.

Reply
David Hand responded on 13 Nov 2013 12:21 PM

Have you had any luck finding a cause or solution for this? I've just been notified of the same issue occurring in one of my clients AX 2012 R1 CU2 system.

Reply
Nathan Erbstoesser responded on 19 Nov 2013 2:35 PM

Hello

There have been a few different cases submitted in regards to this issue. In each of them the issue seemed to be related to what was entered in the date field. If nothing was entered in one case, it resulted in this error. In another case they entered a date range greater than 7 days and it resulted in the error. They recommended installing the latest kernel version at that time and it resolved the issue. The link to a Bemis article follows, as well as the KB number, and a link to our life cycle services site where you should be able to access the fix/KB.

bemis.partners.extranet.microsoft.com/.../DisplayArticlePage.aspx

KB 2889544

https://lcs.dynamics.com/

Please let me know if this helps as I would be happy to assist you with any questions.

Have a great day

Reply
Suggested Answer
Nathan Erbstoesser responded on 19 Nov 2013 2:37 PM

Hello

There have been a few different cases submitted in regards to this issue. In each of them the issue seemed to be related to what was entered in the date field. If nothing was entered in one case, it resulted in this error. In another case they entered a date range greater than 7 days and it resulted in the error. They recommended installing the latest kernel version at that time and it resolved the issue. The link to a Bemis article follows, as well as the KB number, and a link to our life cycle services site where you should be able to access the fix/KB.

bemis.partners.extranet.microsoft.com/.../DisplayArticlePage.aspx

KB 2889544

https://lcs.dynamics.com/

Please let me know if this helps as I would be happy to assist you with any questions.

Have a great day

Reply
HBay responded on 7 Nov 2014 3:53 AM

Is this problem solved, have someone a solution ?

Reply
Suggested Answer
Nathan Erbstoesser responded on 19 Nov 2013 2:37 PM

Hello

There have been a few different cases submitted in regards to this issue. In each of them the issue seemed to be related to what was entered in the date field. If nothing was entered in one case, it resulted in this error. In another case they entered a date range greater than 7 days and it resulted in the error. They recommended installing the latest kernel version at that time and it resolved the issue. The link to a Bemis article follows, as well as the KB number, and a link to our life cycle services site where you should be able to access the fix/KB.

bemis.partners.extranet.microsoft.com/.../DisplayArticlePage.aspx

KB 2889544

https://lcs.dynamics.com/

Please let me know if this helps as I would be happy to assist you with any questions.

Have a great day

Reply