Linked server using view broken by field length change.

• cdavis0403

  SSC Veteran

  Points: 246

  More actions

  February 3, 2004 at 12:14 pm

  #107816

  The length was changed on a column used in a view referenced by a linked server. After the change a select using the view no longer worked. MSG 4274 was returned with this message OLE DB provider 'SQLOLEDB' returned an unexpected data length for the fixed-length column '[forecast].[forecast].[dbo].[vw_itemsizerange].ProductId'. The expected data length is 5, while the returned data length is 7. Query using view did not work in Query Analyzer. Adding a new linked server did work. I'm assuming that the old view was cashed but don't know how to get the view to refresh to reflect the column length change.

  
  Carl Davis

• February 6, 2004 at 8:00 am

  This was removed by the editor as SPAM

• rswaldia

  Grasshopper

  Points: 21

  More actions

  March 11, 2016 at 4:02 am

  #1864521

  Hi -

  I faced the similar issue. My data source is SQL View. Using SQL version 2012 SP1. I just ran "exec sp_refreshview <yourViewName>" on source database. It got resolved.