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 Originally the GP databases were on the D drive. For the steps below, assume the final query you want to use looks something like the code below. Blog Tridea Partners Blog Microsoft Dynamics Become a Member · Contact the Publishers · Login · © 2016 ERP Software Blog · Privacy Notice · Copyright · Member Terms and
Enable these options and then reissue your query. Yes Fabricam is loaded and is working fine. It only happens to her UserID. 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 read review
Join Us! *Tek-Tips's functionality depends on members receiving e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! 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. In fact, a number of Dynamics MVP's alluded to this in a support thread at http://www.ms-news.net/f1610/smartlist-builder-odbc-error-8692687.html.
Kevin D 2009-04-28 18:33:01 UTC PermalinkRaw Message I had her delete 2 Custom Reminders that SY1404 had listed for her that Idon't think she had used in a while. Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free. 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. It is actually equal to the company ID (2).
If you have the Fabricam compnay loaded, does it have a similar problem? I use the SQL Native Client 10.0 driver. I refreshed the View using the linked server and was able to select on it and get data back. https://community.dynamics.com/gp/f/32/t/107350 It works very well!
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 However, in this case, it was coupled with a SQL Error 923 which references restricted access in one of the databases. In this case it was the TEST database. We did Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. But if it happens again, I will run the DEXSQL.log to see what is going on.
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. Bonuses there are several scripts that need to be run in order to make your Test company work properly... I am logged in as ‘sa' in both SQL and GP, so would not expect security to be an issue…Any suggestions? Yes, both Dynamics and Company database successfully restored.
Ltd. I have restored these DBs (Dynamics and Company DB) and TEST Machine start giving same errors. Reply admin says: 07/06/2011 at 11:13 PM Thanks Andy - let me know how it goes for you guys. This linked server happens to be connecting to DB2 so I also explicitly converted the data to sql server data types in the view thinking it was a type conversion issue.
Remove all reminder and task from the user having such error. repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (DYNAMICS).". Enable these options and then reissue your query. 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
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 When I changed the SQL view to use the linked Server, I get no results in my SmartList.
Red Flag This Post Please let us know here why this post is inappropriate. and then it displays the smartlist results. Which DBCC command are you running? 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.
Maybe that has something to do with it. Close this window and log in. I start getting errors when exploring Smartlist. Reply Aaron Berquist says: 07/12/2011 at 2:52 PM Hmm indeed.
Thanks Reply Aaron Berquist says: 07/12/2011 at 11:23 AM Hi Jerry, When you created your view, did you GRANT SELECT ON DYNGRP to the view? 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. INTERID value is correct. 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
Aaron Reply Using SmartList Builder With A Linked Server - It Can Be Done! | Aaron Berquist - High Dynamic Range - DynamicAccounting.net - GP Technical Blogs - Microsoft Dynamics Community 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. Any further suggestions? The strange thing isthat any of these reports from Anyview work for everyone else and have beenworking for years.
However, since the INTERID in the SY01500 table was incorrect for the test company, the INTERID script did not work properly. 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 Get listed Microsoft Have you created a Dexsql.log? I didn't try to drop the smartlist neither try to recreate it yet.