We are using GP 2010 with the January 2013 hotfix (version 11.00.2164) on SQL 2008r2 (version 10.50.1617). Seconds DOC 1 WARNING: Distributions are unbalanced.2: 3 Insert Warning 0. Any idea what might cause it and is there a fix for it?(add new tag) Adult Image? I am logged in as ‘sa' in both SQL and GP, so would not expect security to be an issue…Any suggestions?
I have tried some of the resolutions suggested in few forums and it DOES NOT help either. The view is accessible without any issues within the management studio. This causes other users who are in GP to lockup as well. Thanks, Palma0 0 03/05/13--20:50: Originating Post Date is Zero Contact us about this article The transaction entries that we posted in GP are showing with Originating Post date value https://community.dynamics.com/gp/f/32/t/102744
Thanks in advance Dipal Patel(add new tag) Adult Image? microsoft.public.greatplains Discussion: Smartlist Builder ODBC error (too old to reply) Susan 2009-06-29 18:38:01 UTC PermalinkRaw Message We are receiving the following error message in Smartlist Builder regardlessof whether or not we Patrick [MSFT] 2009-07-02 03:14:32 UTC PermalinkRaw Message While you are entirely correct that Dexterity doesn't understand nulls, thereason this fails under Smartlist builder is that it is using passthroughSQL. 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.
The strange thing isthat any of these reports from Anyview work for everyone else and have beenworking for years. It was done with a SQL trigger of the PK010033 table. Showing recent items. I want to say that I "think" I have narrowed it down to Smartlist,based on researching the error messages and Customersource.
Reply Almas Mahfooz Works For Evincible Solutions in Karachi,Pakistan LinkedIn Blog Website My Badges Suggested Answer Almas Mahfooz responded on 17 Dec 2015 11:48 AM Oboro3, did you try the method Even if you have ANSINULLS and ANSI WARNINGS set for your query, these are disregarded bySmartList Builder, so the answer is it cannot be done -- yes, even if youhave the All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. Go Here The view is accessible without any issues within the management studio.
Select is Granted to DYNGRP. It just doesn't work. does he use the PDK tool ? Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc.
The created view is visible for selection within Smartlist "Add SQL Table" window used for selecting the tables. When I add the View and try to add a key field, the http://microsoft.public.greatplains.narkive.com/uHpY1OrI/smartlist-builder-odbc-error Is that the one you're using? They have a date of creation quite recent (when the last YE Tax update was applied)... 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?
This issue first occurred last Thursday. It only happens to her UserID. The strange thing isthat any of these reports from Anyview work for everyone else and have beenworking for years. Thanks Srini0 0 03/06/13--13:08: Posting in GP 2010 is causing locks on the master database.
Reply JerryB says: 07/12/2011 at 12:54 PM I originally set up the Linked Server using Microsoft OLE DB Provider for SQL server. If you don't do this, SmartView will spin forever on the "Loading…" screen when you try to run a SmartList. 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 I've tried both avenues (file import or direct input) and none of them work....
Seconds DOC 1 ERROR: Object '90111512' already exists -- cannot Insert.2: 90111512 Insert Failed 0. I've used your suggestions to create a linked server query for Excel Report Builder and I get data. By joining you are opting in to receive e-mail.
ODBC error 37000Same messge whether those options are marked or unmarked. I know that it works with AnyView, and have done a test with SmartList builder and it works there as well. Reply Leave a Reply Cancel reply Your email address will not be published. ODBC error 37000Same messge whether those options are marked or unmarked.
are you sure the generic and linked server result sets are the same in terms of field definitions? It only happens to her UserID. Click Here to join Tek-Tips and talk with other members! The inventory transactions are available in inquiry and smartlist views.
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? 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 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 Mariano Gomez 2009-06-29 19:10:01 UTC PermalinkRaw Message You are receiving this error because you are trying to query a database thatis on a remote server via a Linked Server connection.
Due to this we are unable to close the period. They could then compare - actual MO final pick list consumption to the BOM at time of MO Entry. Cancel Contact Us: 888-319-3663 Access Activation Keys & Renewals Software SmartConnect Extender SmartView Node Builder Flexicoder SmartPost SmartList Builder Zendesk CRM Integration Services Training Dedicated Support Professional Services Support They do look like coming from GP, but I couldn't say for sure.
The view is accessible without any issues within the management studio. 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
© 2017 imagextension.com