> Gps Error
> Gps Error 58 Odbc Error 37000
Gps Error 58 Odbc Error 37000
Once you do that, and build your SmartList, you can change what the view is actually doing after the fact. The strange thing isthat any of these reports from Anyview work for everyone else and have beenworking for years. 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 I have drilled down more, and at least come to this conclusion that problem is with DBs only, if you kindly check my last paragraph in my first post, when our navigate here
Has anyone seen this before? Thanks! and then it displays the smartlist results. When a user logs out of one company into another, she gets 3 errors.
Once they clicked OK they received a second error message: Microsoft Dynamics GP - GPS Error: 58 Clicking OK again presented a third error message: Microsoft Dynamics GP - SQL Error: Once we corrected the INTERID in the table to the DB Name and reran the script, the issue was resolved. Thanks, Jeremie Reply Stefano Polo says: 09/21/2012 at 4:43 PM I really had high hopes for this but it really doesn't work. It only happens to her UserID.
I assume your currenct view calls the linked server this way: SELECT * FROM LINKEDSERVER.LINKEDDB.DBO.LINKEDTABLE Try changing your view to call the linked server this way: SELECT * FROM OPENQUERY(LINKEDSERVER, ‘SELECT We went to Main MenuGP-->Reminder-->change reminder preferences-->remove. I want to say that I "think" I have narrowed it down to Smartlist,based on researching the error messages and Customersource. Minimum of 10 users and I started receiving this error message each time I select a user and revoke access.
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? 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 It works very well! read this article Which DBCC command are you running?
I didn't try to drop the smartlist neither try to recreate it yet. I then concluded that the SQL Stored Procedure what I am looking at, is also of *Audit Trails* module. How would that happen? I've used your suggestions to create a linked server query for Excel Report Builder and I get data.
We also frequently have requests to produce reports which consolidate data from all of these entities onto one SmartList so that, in one report, users can quickly see data from every http://www.aaronberquist.com/2011/07/using-smartlist-builder-with-a-linked-server-it-can-be-done/ 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. Thank you, I believe it is the shortest way to overcome these issues. :) Reply adeel ahmad Works For Ravi Automobile Pvt. Bookmark the permalink.
Overall GP is running fine and everything else seems ok. http://redhatisnotlinux.org/gps-error/gps-error-18.html hmmmm. I had her delete them and she said she hasn't seen the error again. Ian.
Mariano Gomez 2009-04-28 17:23:03 UTC PermalinkRaw Message If you've narrowed down this to a SmartList error, then the next questionwould be, is this a standard SmartList or is it a SmartList Few smartlist (after these 3 errors), show results, and few smartlist dont' show any results. And are you using SmartList or SmartView to access it? http://redhatisnotlinux.org/gps-error/gps-error-58-odbc.html Let me explain what I did to get rid of this. 1.
It says it did not find the stored procedure *mxCallRevokeUserAudit*. 2.
I refreshed the View using the linked server and was able to select on it and get data back. I checked whether this stored procedure is available on any other company that I had on my GP environment. Close Box Join Tek-Tips Today! But the same query in SmartList Builder produces no results when the linked server columns are included.
Interesting thing we found. Reply Richard Wheeler Works For Revered Business Solutions, Inc. Reply All Responses (5) Ian Stewart Works For Intelligent Partnerships in Europe Blog My Badges Ian Stewart responded on 28 Apr 2009 2:58 PM What version of GP are you using? http://redhatisnotlinux.org/gps-error/gps-error-10-odbc-error-08004.html Reply NOLA My Badges NOLA responded on 5 Jun 2013 10:00 AM Interid was run and did not help.
It's then I decided to check this out and clear it once for all. What would be your troubleshooting steps to figure out whare this is coming from, short of running every single Smartlist favorite? Replaced the View with the linked server select and the SmartList in GP shows no data. When I upgraded to Microsoft Dynamics GP2010 R2, I had selected this module also for installation.
Reply NOLA My Badges NOLA responded on 5 Jun 2013 1:38 PM Unfortunately they have restarted a few times since the error started a couple of months ago. SQL Error: 1934 3. If you have the Fabricam compnay loaded, does it have a similar problem? 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