AnsweredAssumed Answered

OLE DB provider 'PIOLEDBENT' for linked server 'PIAF' returned data that does not match expected data length for column

Question asked by paljon on Jan 18, 2017
Latest reply on Jan 23, 2017 by pmartin

I’ve an AF attribute that contains JSON string and I want to get the value from it using the PI-OleDB Enterprise, parse the string and store value in SQL database. This has been working fine for some months but now the string has got longer and I get this error:  

 

Msg 7347, Level 16, State 1, Line 1 OLE DB provider 'PIOLEDBENT' for linked server 'PIAF' returned data that does not match expected data length for column '[PIAF].[PlantAFDB].[Data].[Snapshot].Value'. The (maximum) expected data length is 8000, while the returned data length is 8002.   

 

What options do I have to read the string using PI-OleDB when it has become this long?

Outcomes