Error on a job run in SQL

• lays.babyblush

  SSC-Addicted

  Points: 401

  More actions

  April 27, 2008 at 9:40 pm

  #181737

  Hi all,

  I get this error while i run my SQL job .

  spExtractTable Failed @ Line 1,

  The OLE DB provider "MSDASQL" for linked server

  "QOS" supplied inconsistent metadata for a column.

  The column "InteractionID" (compile-time ordinal 1)

  of object ""xxxx"."dbo"."vw_Scorecard""

  was reported to have a "DBCOLUMNFLAGS_ISNULLABLE"

  of 0 at compile time and 32 at run time.

  spExtractTable -- this extracts data from the source view and drop the destination table and recreates a replica of the view in the destination database(which is my repository).Source database is sql server 2000. and destination server is sql server 2005.

  I had no problem doing this job run for past 1 month. i had created a linked server using OLE DB.

  But now when i run the job its breaks with this error.

  Extra Inputs: I tried my linked server connection test. it says connection successful.

  InteractionId is PK on destination database.

  Could anyone please guide my thoughts to fix this?

  My work is getting affected big time because of this.

  Any kind of help will be greatly appreciated.

  Thanks in advance.

  LG

• GSquared

  SSC Guru

  Points: 260824

  More actions

  April 28, 2008 at 11:19 am

  #807957

  Have you tried recompiling the stored procedure? It looks like it needs to refresh the metadata, and that might do it.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon