Is that the one you're using? We are on version 10. Select is Granted to DYNGRP. The reason I ask, is because an incorrect syntax near ',' istypically a syntax error in a query.If this is a SLB smartlist then and if it is based on some
Below is the exact sequence of error messages that I received:Since I had not doing this frequently (it's maximum 3 users in 6 months) and also the purpose of revoking This removed that now (in)famous error message. GPS Error: 58 (clicks ok) SQL Error: 102 ..... The only option that was left; to remove this product from my environment (by removing DYNAMICS.SET file contents alone and not the dictionary itself). https://community.dynamics.com/gp/f/32/t/107475
What would be your troubleshooting steps to figure out wharethis is coming from, short of running every single Smartlist favorite?Has anyone seen this before? Have you created a Dexsql.log? Reply NOLA My Badges Verified Answer NOLA responded on 6 Jun 2013 8:03 AM The INTERID script did not change it. I have a test machine, if you can suggest any scenario to check, I can do that.
Have NO idea how the Interid was wrong but sometimes you've just gotta roll with it! :-) Thanks! But I could beway off.It is most likely not Smartlist builder, they have some legacy 3rd partycalled "Anyview" that they still have reports from. I then concluded that the SQL Stored Procedure what I am looking at, is also of *Audit Trails* module. Reply Amit Thakkar My Badges Amit Thakkar responded on 16 Jun 2009 6:48 AM Hi Day, Yesterday i was facing the same problem for one of the user.
Reply NOLA My Badges NOLA responded on 6 Jun 2013 8:28 AM Beat, We did follow the procedures and run the scripts. You had GP on image and that image had a C and D drive. While creating smart list getting error Above method Reply Greg Wahl says: 12/17/2015 at 11:04 AM Any update on solution to this problem? https://community.dynamics.com/gp/f/32/t/107350 Replaced the View with the linked server select and the SmartList in GP shows no data.
Has anyone seen this before? Reply Béat Bucher Works For Forensic Technology in Montreal, QC @gp_beat LinkedIn Google+ Blog Website My Badges Suggested Answer Béat Bucher responded on 6 Jun 2013 8:23 AM Hi NOLA, Have Yes, both Dynamics and Company database successfully restored. ODBC Error: 37000 It is very inconsistent and will work and then next time will not.
I deleted that Linked Server and created a new one using the SQL Native Client 10.0 driver. http://www.aaronberquist.com/2011/07/using-smartlist-builder-with-a-linked-server-it-can-be-done/ there are several scripts that need to be run in order to make your Test company work properly... Check the second error message. I want to say that I "think" I have narrowed it down to Smartlist,based on researching the error messages and Customersource.
What I think was happening was on login, it tries to load the Reminders, My Reports, and Quicklinks to the home page and she ended up having some reminders that I Then we have to reboot the system and hope it works, which sometimes takes 2-3 reboots. And are you using SmartList or SmartView to access it? Minimum of 10 users and I started receiving this error message each time I select a user and revoke access.
If I query the view directly I get data returned. Enable these options and then reissue your query. The problem is that wehave over 100 users and 100 companies and everyone seems to make Smartlistfavorites and set them available to "System." So there are tons ofSmartlists that may or incorect Syntax Near ',' (clicks ok)ODBC Error: 37000 (clicks ok)Then is able to proceed to work with no problemsI think it has something to do with a Smartlist Reminder or Shortcut
The problem is that wehave over 100 users and 100 companies and everyone seems to make Smartlistfavorites and set them available to "System." So there are tons ofSmartlists that may or Furthermore, recently our GP Server got crashed and I have restored it through an image, but while restoring via image, the .mdf and .ldf files are on C drive (before it I didn't try to drop the smartlist neither try to recreate it yet.
I could get only one link with exact error message, which I found on our Community Forum. Collection of Microsoft Dynamics GP (Great Plains) SQL scripts, … The Global Positioning System … GPS Error: 58 - Microsoft Dynamics GP Community Forum – GPS Error: 58. I'll really appreciate if you can kindly give me your comments on one thing that when I restore Dynamics and Company Database of 5.25.2013 everything works great, and as soon as So while the views they are created with might not beperfect, nobody else gets this message.Everyone is on the same versions (GP 10 btw) and builds.
That also resolved a cannot create next note index error that they were getting in Integration Manager as it has to look up the note index on the SY01500 table also. Ltd. Jul 4th, 2011 by Aaron Berquist. Reply adeel ahmad Works For Ravi Automobile Pvt.
By product Downloads … Microsoft Hardware drivers; Dynamics GP - An error occurred executing SQL statements Other associated errors : GPS Error:54 SQL Error: 2601 (Microsoft)(ODBC SQL Server Driver) … Bank If you look in your DYNAMICS..SY01500 table, is the INTERID value correct for this company? Reply JerryB says: 07/12/2011 at 12:54 PM I originally set up the Linked Server using Microsoft OLE DB Provider for SQL server. GPS Error: 58 2.
LikeLike Reply Pingback: Error When Granting User Access to a New Company | Dynamics GP Insights Pingback: Error When Granting User Access to a New Company | Interesting Findings & Knowledge It is actually equal to the company ID (2). Thanks Reply Aaron Berquist says: 07/12/2011 at 12:09 PM When you set up the linked server, what Driver did you use? It only happens to her UserID.
I'll pass this on to our other consultants and be sure to give this a try the next time it comes up. Required fields are marked *Comment Name * Email * Website Leave this field empty CAPTCHA Code* Subscribe to this Feed via RSS Questions? Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are ODBC and SQL Errors Good Day, My customer, runs a report in Great Plains for a certain Period, if the customer chooses to run the same report for another period straight
incorect Syntax Near ',' (clicks ok)ODBC Error: 37000 (clicks ok)Then is able to proceed to work with no problemsI think it has something to do with a Smartlist Reminder or Shortcut Have you tried restarting the SQL instance?