Dear All,
We have a Dataverse created via an Azure Synapse Link. The data is synching with D365 Finance & Operations every 15 mins and is using the Parquet file format. We have created a separate DB (that basically is just a bunch of Views over the Tables in the Dataverse - call it VIEW_DB) which we expose to other users rather than going directly to the Dataverse DB.
Once we have this data in the Dataverse, we then need to copy some data to a different target for reporting and use traditional SSIS to do this. As such, also every 15 mins we run this process to extract data from the VIEW_DB that is being synch'd. This mostly works OK (99% success). However, every so often and at irregular times, we receive the following error message ...
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.
Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14
Description: "Statement(s) could not be prepared.".
Description: "Could not use view or function 'db_datareader.TM1_vwJournal' because of binding errors.".
Description: "Invalid object name 'dataverse_xxxx_unqxxxxxxxxx.dbo.LedgerJournalTable'.".
Description: "OLE DB Source" failed validation and returned validation status "VS_ISBROKEN".
Description: One or more component failed validation.
Has anyone experienced anything like this?
Why would this run OK for most of the time but fail once or twice every couple of days or so?
Would it have anything to do with the Sync process disrupting our OLEDB connection?
Any help much appreciated.
Basil
