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?