| Groups | Blog | Home |
sql server programming : Error on query of linked server
the linked server. Occasionally when a query is executed using one of the views, it results in this error: "The OLE DB provider "SQLNCLI" for linked server "SERVERNAME" reported a change in schema version between compile time ("81311853655859119") and run time ("81311853655859135") for table ""DATABASENAME"."USERNAME"."TABLENAME"". (where SERVERNAME is the linked server's name, DATABASENAME is the database on the linked server, USERNAME is the owner of the table, and (obviously) TABLENAME is the name of the table on the linked server.) On the surface, this message might seem to mean what it says - the schema of the view or linked table chagned while the query was executing - but I am almost 100% positive that this is NOT the case. The schema of the view or table never changes. Is there something else that might cause this? Perhaps a locked table or something?
1. The SQL server where the view exists on the linked server is SQL Server
2005 with SP1 and post-SP1 cumulative hotfix (no SP2 yet). The SQL server that it is linking to is SQL Server 2000 with SP3. 2. It occurs intermittently, on various tables. There are a group of about 10 or 15 tables we access on the linked server. Looking back though my log of error messages (which is not 100% complete), I've seen the error occur on 2 or 3 different tables. 3. Changing to use OPENQUERY would require some relatively major changes to our production system, which I don't think I am prepared to make at this time. We have several views on these linked tables and I can't predict which one will get an error so I would have to change all of them. 4. No, they are not updated. I will install SP2 soon on the SQL 2005 system. I cannot install anything later than SQL 2000/SP3 on the linked server due to application reasons (that server is the database server for JD Edwards/Peoplesoft Enterprise One and the version we are using only supports SP3 - we would need to upgrade the application itself to a later service pack to support later SQL service packs, and it is a LOB system and covered by Sarbox blah blah blah, it can't be quickly done.) [quoted text, click to view] "Charles Wang[MSFT]" <changliw@online.microsoft.com> wrote in message news:m$21maXWHHA.1540@TK2MSFTNGHUB02.phx.gbl... > Hi, > I understand that you encountered the error (7359): > ""The OLE DB provider "SQLNCLI" for linked server "SERVERNAME" reported a > change in schema version between compile time ("81311853655859119") and > run > time ("81311853655859135") for table > ""DATABASENAME"."USERNAME"."TABLENAME""." > when you executed a distributed query. > If I have misunderstood, please let me know. > > For further research, I would like to know: > 1. What is your SQL Server version and your linked server version? > 2. Does this issue occur on some linked tables/views or all linked > tables/views? Intermittently or constantly? > 3. What is it going on if you use OPENQUERY to perform the linked query? > 4. Has the latest service pack been installed on your local SQL Server and > linked server? > > Look forward to your response. > > Best regards, > Charles Wang > Microsoft Online Community Support > ===================================================== > Get notification to my posts through email? Please refer to: > http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif > ications > > If you are using Outlook Express, please make sure you clear the check box > "Tools/Options/Read: Get 300 headers at a time" to see your reply > promptly. > > > Note: The MSDN Managed Newsgroup support offering is for non-urgent issues > where an initial response from the community or a Microsoft Support > Engineer within 1 business day is acceptable. Please note that each follow > up response may take approximately 2 business days as the support > professional working with you may need further investigation to reach the > most efficient resolution. The offering is not appropriate for situations > that require urgent, real-time or phone-based interactions or complex > project analysis and dump analysis issues. Issues of this nature are best > handled working with a dedicated Microsoft Support Engineer by contacting > Microsoft Customer Support Services (CSS) at > http://msdn.microsoft.com/subscriptions/support/default.aspx. > ====================================================== > When responding to posts, please "Reply to Group" via > your newsreader so that others may learn and benefit > from this issue. > ====================================================== > This posting is provided "AS IS" with no warranties, and confers no > rights. > ====================================================== > > > > >
Hi,
I understand that you encountered the error (7359): ""The OLE DB provider "SQLNCLI" for linked server "SERVERNAME" reported a change in schema version between compile time ("81311853655859119") and run time ("81311853655859135") for table ""DATABASENAME"."USERNAME"."TABLENAME""." when you executed a distributed query. If I have misunderstood, please let me know. For further research, I would like to know: 1. What is your SQL Server version and your linked server version? 2. Does this issue occur on some linked tables/views or all linked tables/views? Intermittently or constantly? 3. What is it going on if you use OPENQUERY to perform the linked query? 4. Has the latest service pack been installed on your local SQL Server and linked server? Look forward to your response. Best regards, Charles Wang Microsoft Online Community Support ===================================================== Get notification to my posts through email? Please refer to: http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications If you are using Outlook Express, please make sure you clear the check box "Tools/Options/Read: Get 300 headers at a time" to see your reply promptly. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscriptions/support/default.aspx. ====================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from this issue. ====================================================== This posting is provided "AS IS" with no warranties, and confers no rights. ======================================================
Hi,
Thanks for your response. Please first install SQL Server 2005 SP2 on your server; then check if there is some anti-virus software installed on your server, please temporarily disable it. Since this issue occurs intermittently in your production environment, MPS report and dump analysis are most likely required; The work should be done by CSS. If this issue persists, it is recommended that you contact Microsoft Customer Support Services (CSS) via telephone so that a dedicated Support Professional can assist you recover the server in a more efficient manner. Please be advised that contacting phone support will be a charged call. To obtain the phone numbers for specific technology request please take a look at the web site listed below. http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS If you are outside the US please see http://support.microsoft.com for regional support phone numbers. If you have any other questions or concerns, please feel free to let me know. It is my pleasure to be of assistance. Best regards, Charles Wang Microsoft Online Community Support ===================================================== Get notification to my posts through email? Please refer to: http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications If you are using Outlook Express, please make sure you clear the check box "Tools/Options/Read: Get 300 headers at a time" to see your reply promptly. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscriptions/support/default.aspx. ====================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from this issue. ====================================================== This posting is provided "AS IS" with no warranties, and confers no rights. ======================================================
Don't see what you're looking for? Try a search.
|
January 2003
March 2003
April 2003
May 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
April 2008
August 2008
| home · blog · groups | Questions? Comments? Contact the dn |