How can we check/fix the bad data causing "invalid segment number"? We need the SQL Export data for our daily reporting.
==>SQL EXPRESS select qry (linked to cloud-hosted SAGE100c 2022v3 Standard) has been working up until error today (12/6/2023)
SELECT * INTO SQLMas90..IM_ItemTransactionHistory FROM Openquery(Sage, 'SELECT * FROM IM_ItemTransactionHistory')
WHERE TransactionDate >= DATEADD(DAY, -730, GETDATE());
Error today:
OLE DB provider "MSDASQL" for linked server "Sage" returned message "[ProvideX][ODBC Driver][PVKIO]Invalid segment number".
Msg 7330, Level 16, State 2, Procedure dbo.MQ_AdhocDataCreateLoad, Line 95 [Batch Start Line 2]
Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "Sage".
Thanks very much for your help.