Home > Gps Error > Gps Error 58 Dynamics

Gps Error 58 Dynamics

Register now while it's still free! I have created a database link using Management studio to SQL Database residing in another server. Required fields are marked * MVP Award Associations View Credentials Social Media & Other Sites Buy My Books GP 2016 Cookbook Workflow 2.0 Implementing the Web Client GP 2013 Cookbook Financial 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

Reply Jeremie Grund says: 09/04/2012 at 2:53 PM I too am having the same issue as JerryB, created the SmartList using a "dummy" view with the same datatypes. Please leave this field empty. Since the message said something about *Audit*, I thought I would first check with *Audit Trails* module. Thanks again for your help.KevinPost by Mariano GomezEnabling a DEXSQL.LOG will allow you to pinpoint the specific issue, table,or query that is causing this message.Best regards,--MG.-Mariano Gomez, MIS, MCP, PMPMaximum Global her latest blog

When a user logsout of one company into another, she gets 3 errors.GPS Error: 58 (clicks ok)SQL Error: 102 ..... A little background - we have 150+ Dynamics GP companies, all on one database server. So some trick needs here, and I have found one for you. This is very userspecific.I'll post when I figure it out.ThanksKevinPost by Mariano GomezIf you've narrowed down this to a SmartList error, then the next questionwould be, is this a standard SmartList

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? 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 So some trick needs here, and I have found one for you. I didn't try to drop the smartlist neither try to recreate it yet.

I have done a lot of searchng online but have not found anything concrete to assist. Once you do that, and build your SmartList, you can change what the view is actually doing after the fact. incorect Syntax Near ',' (clicks ok) ODBC Error: 37000 (clicks ok) Then is able to proceed to work with no problems I think it has something to do with a Smartlist https://community.dynamics.com/gp/f/32/t/102744 We went to Main MenuGP-->Reminder-->change reminder preferences-->remove.

Still it is continuing to give this error. The following is the SQL statement being run: SELECT LIVE.dbo.GL00100.ACTINDX AS '1' FROM LIVE.dbo.GL00100 (nolock) WHERE ((LIVE.dbo.GL00100.ACCATNUM IN (1, I could get only one link with exact error message, which I found on our Community Forum. It works very well!

Reply JerryB says: 07/12/2011 at 11:58 AM Hi Aaron, I have tried granting access to DYNGRP and still have the same issue. check my blog Reply admin says: 07/06/2011 at 11:13 PM Thanks Andy - let me know how it goes for you guys. in Ballston Lake, New York My Badges Richard Wheeler responded on 7 Jun 2013 5:38 AM Did the SQL server name change? Has anyone figured this out or has everyone just moved on?

When a user logsout of one company into another, she gets 3 errors.GPS Error: 58 (clicks ok)SQL Error: 102 ..... There was an issue in V 8,where you got the above error sequence when you were running a smartlist...not on exit from one company. If you have the Fabricam compnay loaded, does it have a similar problem? Join Us! *Tek-Tips's functionality depends on members receiving e-mail.

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 Mariano Gomez 2009-04-28 18:26:03 UTC PermalinkRaw Message Enabling a DEXSQL.LOG will allow you to pinpoint the specific issue, table,or query that is causing this message.Best regards,--MG.-Mariano Gomez, MIS, MCP, PMPMaximum Global 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 Your Name (required) - Your Email (required) - What is 3+3?

Please let me know if any further questions. If it comes back again, I'll definitely do theDEXSQL.LOG. When clicking on most of the smarlist, it displays (first) GPS Error: 58, OK, then it displays SQL ERROR: 601 [Microsoft][SQL Server Native Client 10][SQL Server] Could not continue scan with

Website My Badges Question Status Unanswered adeel ahmad asked a question on 6 Jun 2013 11:26 PM Hi, I am using Dynamics GP 2010 with SQL 2008 R2.

It may take a while depending on how big the database is. Jul 4th, 2011 by Aaron Berquist. are you sure the generic and linked server result sets are the same in terms of field definitions? Red Flag This Post Please let us know here why this post is inappropriate.

This is very userspecific.I'll post when I figure it out.ThanksKevinPost by Mariano GomezIf you've narrowed down this to a SmartList error, then the next questionwould be, is this a standard SmartList Any help is greatly appreciated Regards Warren Goetzsche Warren Cancel Reply almas 0 2014-10-30 1:18 PM Warren, Could you provide screen shots of errors. Note: I have updated the sample code above to include the "GRANT SELECT" permissions to "DYNGRP" on the view. To my surprise (and joy, of course), Physical Name of all tables started with *MX*. 6.

I love to hear that someone is actually making use of some of these tips!