When I upgraded to Microsoft Dynamics GP2010 R2, I had selected this module also for installation. Ltd. I checked whether this stored procedure is available on any other company that I had on my GP environment. If I query the view directly I get data returned.
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 However I have drill down the issue and come to this conclusion that the day the system has been crashed, the DB files got corrupted, fortunately I have backup of all I could not find one on any company. 3. More Bonuses
Now today when I try to check Integrity of DB (dynamics or company), it failed as well. Email Me! 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.
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. Sure it will work. This ensures consistent query semantics. 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?
I got the initial error message, changed the view to be generic, created the SmartList and proved that it worked with the generic view. It only happens to her UserID. Ian. Reply Richard Wheeler Works For Revered Business Solutions, Inc.
Personal tools Namespaces Article Search Main Page Applications AOL Internet Explorer MS Outlook Outlook Express Windows Live DLL Errors Exe Errors Ocx Errors Operating Systems Windows 7 Windows Others Windows http://www.erpsoftwareblog.com/2015/05/dynamics-gp-database-corrupted/ It works very well! What would be your troubleshooting steps to figure out whare this is coming from, short of running every single Smartlist favorite? Enable these options and then reissue your query.ODBC Error: 37000 Thanks Adrian Email * Name * 1 Answer Vote Up 0 Vote Down Public Jared Dux ⋅ Staff ⋅ August 11,
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 There can be many events which may have resulted in the system files errors. in Lahore, Pakistan. Any further suggestions?
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. 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 I want to say that I "think" I have narrowed it down to Smartlist,based on researching the error messages and Customersource. 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
Related This entry was posted in Audit Trails, Debugging, GP Administration, SQL, SQL Error Messages, Troubleshooting and tagged SQL. Of course, using a linked server is not, in the end, an ideal solution, but for cases when you have to, the method above will allow you to use SmartLists with I want to say that I "think" I have narrowed it down to Smartlist,based on researching the error messages and Customersource.
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 in Ballston Lake, New York My Badges Richard Wheeler responded on 8 Jun 2013 6:22 AM Please explain the image restore. When a user logsout of one company into another, she gets 3 errors.GPS Error: 58 (clicks ok)SQL Error: 102 ..... 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.
The strange thing isthat any of these reports from Anyview work for everyone else and have beenworking for years. 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 Ltd. Once you have successfully built the object, ALTER the view to call the code from the linked server: ALTER VIEW SampleView AS --SELECT convert(varchar(5),'') as Column1, convert(tinyint,0) as Column2