Hi All,
On one of sandbox, we have setup BYOD export. suddenly it has started failing with this error.
The export job is scheduled to run for every hour and it normally runs for 2-3 minutes. but since yesterday it has started taking 4 hours and then fails with below error. It is incremental push on data entity.
During this 4 hours, we checked the SQL and there are no Locking and also query shows 'Running'. but after few hours it fails somehow. There is nothing from our side we changed.
Can someone please help understand what could have gone wrong? We are thinking to raise MS Support case but thought to ask experts here if we can fix it in case it is easier solution.
This data entity is credit card transactions which is biggest table in our database and we are not in position to republish entity as it will take days to migrate all the data again in entity store.
<?xml version="1.0"?><Errors><Error><ErrorCode>-1071636471</ErrorCode><SubComponent>Oledb Source [179]</SubComponent><Description>SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Unspecified error".</Description></Error><Error><ErrorCode>-1073450982</ErrorCode><SubComponent>SSIS.Pipeline</SubComponent><Description>Oledb Source failed the pre-execute phase and returned error code 0x80004005.</Description></Error></Errors>
Regards,
Vikky
