When trying to convert a Requisition to a PO. Query Error. Microsoft.BusinessFramework.Data.GeneralDatabaseException Incorrect syntax near ‘TO’
Tried the KB article asking you to reset IIS, but no luck.
*This post is locked for comments
Yes, I have the same problem. I've run a SQL trace and I saw that is a missing comma in the order by (please see "_____")
With the "iisreset" option doesn't work this time for me but restarting the BP site worked fine!
Under the "Internet Information Services (IIS) Manager", select the "Business Portal" site, and on the rigth you'll find "Manage Web Site". Just press "restart" and have a nice day!
Regards
E.
Hi John,
Have you tried to open business portal on IE 8 or 9 and tried the above.
If you want to troubleshoot yourself, you could look in the event viewer or do a sql trace. They may offer some clues. Otherwise, support is always happy to help.
Thanks
Rob
I am unfortunately not able to take a screenshot at this time. However, our issue is identical to the original posting. Our users attempt to convert requisitions into purchase orders in Business Portal and receive the exact error message:
Query Error. Microsoft.BusinessFramework.Data.GeneralDatabaseException Incorrect syntax near ‘TO’
This began on the first day of our new fiscal year. We performed an upgrade from GP 2010 to 2013 during the last fiscal year which included a SQL upgrade as well. We did not have this issue in the last fiscal year after the upgrade.
John, since the original post was some time ago, could you post a screen shot of what your error message looks like. It is often easier to see an error than to 'type an error'
Thanks.
We are experiencing this issue as well. Were you able to find a resolution?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156