I can see results from the view in my SQL Query window, so I know that the Linked Server view returns values, but can't get SmartList to display them. We went to Main MenuGP-->Reminder-->change reminder preferences-->remove. Maybe that has something to do with it. Overall GP is running fine and everything else seems ok.
Thanks Srini Tags: SQL Error:7405 ODBC Error: 37000 Add SQL Table SmartList creation ANSI_NULLS ANSI_WARNINGS GPS Error: 58 Reply All Responses (7) Only Answers Béat Bucher Works For Forensic Technology in Reply Richard Wheeler Works For Revered Business Solutions, Inc. Column1 is varchar(5) and Column2 is TINYINT: select Column1, Column2 from LINKEDSERVER.SAMPLEDB.dbo.SAMPLETABLE Here are the steps you need to follow: Create a SQL view with the columns and field lengths that VN:F [1.9.10_1130]Please wait while your rating is cast…Rating: 0.0/10 (0 votes cast)VN:F […] Reply Andy Nifong says: 07/06/2011 at 10:04 AM Nice, Aaron - we've run into this several times and
ODBC Error: 37000 It is very inconsistent and will work and then next time will not. 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 Related Recommended DUG Home Contact DUG Dynamics AX Users Forums Blogs Events Documentation, videos and downloads AX Partners Group Dynamics NAV Users Forums Blogs Wikipedia Events Books NAV partners group NAV Daoud View my complete profile Follow by e-mail: Links Company Website Dyamics GP Excel Paste Free Exchange Rates Feed Dynamics GP Reporting Series الواجهة العربية About Me Posts to Mail: Enter
Almas Reply Industries Education Government Health Discrete Manufacturing Hospitality and travel Retail and consumer goods For customers Small and midsize businesses Enterprise Envision Microsoft Ignite Microsoft AppSource For partners Microsoft partner Any help would be greatly appreciated. In order to make this work, I had to come up with a workaround to the very ANSI_NULLs issue other people have reported as stopping them in their tracks. Yes Fabricam is loaded and is working fine.
Reply Vaidhyanathan Mohan Works For Scope Systems in Perth, WA @vaidymohan LinkedIn Blog Website My Badges Vaidhyanathan Mohan responded on 2 Apr 2012 1:02 PM Angie, try disabling this product and are you sure the generic and linked server result sets are the same in terms of field definitions? Reply All Responses (8) Only Answers Jonathan Fear My Badges Jonathan Fear responded on 5 Jun 2013 9:16 AM Did you run the script to update the Interid? https://community.dynamics.com/gp/f/32/t/102744 Resizing SmartList TreeView and ListView panes usi...
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 It happens on 3 different live and 3 different test companies and only when I remove a user from the company. I can see the results in SmartList when the SQL view is generic (that is looking at a local table), so its only when I change the view to make use 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
When I changed the SQL view to use the linked Server, I get no results in my SmartList. https://community.dynamics.com/gp/f/32/t/46685 in Ballston Lake, New York My Badges Richard Wheeler responded on 8 Jun 2013 6:22 AM Please explain the image restore. 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. Thanks, Chris Reply Victoria Yudin Works For Flexible Solutions in USA @victoriayudin LinkedIn Blog Website My Badges Victoria Yudin responded on 5 Jan 2011 2:08 PM Chris, Do you have any
Select is Granted to DYNGRP. 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 and then it displays the smartlist results. 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.
Also which report he is printing with which options. 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? The created view is visible for selection within Smartlist "Add SQL Table" window used for selecting the tables. Hope that helps.
I have restored the DBs one day before the crash, and all start working fine. Thus the above error. If you look in your DYNAMICS..SY01500 table, is the INTERID value correct for this company?
Website My Badges adeel ahmad responded on 10 Jun 2013 1:09 AM I really appreciate your support Richard. Enable these options and then reissue your query.ODBC Error: 37000 Tags: While creating smart list using SQLView Error in Smart list Builder Reply Almas Mahfooz Works For Evincible Solutions in She said the errors have not come backyet so hopefully it is fixed. Logout from GP and Login back Thanks and Regards Amit Amit Tags: Dynamics GP 10 Reply Andy Sather Works For Microsoft in Fargo, ND My Badges Andy Sather responded on
If you don't do this, SmartView will spin forever on the "Loading…" screen when you try to run a SmartList. 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 So some trick needs here, and I have found one for you. hmmmm.
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 Anybody can give any idea? Required fields are marked *Comment Name * Email * Website Leave this field empty CAPTCHA Code* Subscribe to this Feed via RSS Questions? It only happens to her UserID.
It only happens to her UserID. I want to say that I "think" I have narrowed it down to Smartlist,based on researching the error messages and Customersource. Reply Aaron Berquist says: 07/12/2011 at 2:52 PM Hmm indeed. Thanks!
Reply adeel ahmad Works For Ravi Automobile Pvt. Note: I have updated the sample code above to include the "GRANT SELECT" permissions to "DYNGRP" on the view. Anybody got any ideas? The problem is that we have over 100 users and 100 companies and everyone seems to make Smartlist favorites and set them available to "System." So there are tons of Smartlists
I got the initial error message, changed the view to be generic, created the SmartList and proved that it worked with the generic view.
© 2017 imagextension.com