Help get this topic noticed by sharing it on Twitter, Facebook, or email.

sf_refresh failing with unexpected catastrophic error

Hi,

Read quite a few of the previous posts on this type of error, but none seem to match my issue exactly.

I am running a stored procedure in a scheduled job and the sf_refresh command fails intermittently with a catastropic error.

I am logging the job step output to a table so here is the full error transcript.

Job 'T24 Import and Sync' : Step 1, 'Import T24 client to PBB' : Began Executing 2017-04-15 23:15:55Msg 7399, Sev 16, State 1, Line 1 : The OLE DB provider "DBAmp.DBAmp" for linked server "pbbprod" reported an error. The provider reported an unexpected catastrophic failure. [SQLSTATE 42000]
Msg 7341, Sev 16, State 1, Line 1 : Cannot get the current row value of column "[pbbprod]...[Account].Sector_Strategy__c" from OLE DB provider "DBAmp.DBAmp" for linked server "pbbprod". [SQLSTATE 42000]
Msg 0, Sev 16, State 1, Line 47 : --- Starting SF_Refresh for Account V3.4.4 [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 99 : 23:17:10: Using Schema Error Action of subset [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 269 : 23:17:14: Using last run time of 2017-04-15 18:37:00 [SQLSTATE 01000]

Any assistance would be appreciated.

Thanks
Derek
1 person has
this problem
+1
Reply
  • Sector_Strategy__c: Is this a new column for the Account object or was the definition recently modified ?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited sad, anxious, confused, frustrated

  • Hi Bill,

    Sector_Strategy__c is not a new field and was last modified on 10 March.

    What is strange is that the next time the refresh was run it worked fine with no errors.

    Job 'T24 Import and Sync' : Step 1, 'Import T24 client to PBB' : Began Executing 2017-04-19 01:00:05
    --- Starting SF_Refresh for Account V3.4.4 [SQLSTATE 01000]
    01:01:12: Using Schema Error Action of subset [SQLSTATE 01000]
    01:01:17: Using last run time of 2017-04-17 02:48:00 [SQLSTATE 01000]
    02:36:56: Identified 344921 updated/inserted rows. [SQLSTATE 01000]
    02:37:43: Identified 9 deleted rows. [SQLSTATE 01000]
    02:37:43: Removing deleted rows from Account [SQLSTATE 01000]
    02:37:43: Adding updated/inserted rows into Account [SQLSTATE 01000]
    --- Ending SF_Refresh. Operation successful. [SQLSTATE 01000]

    And now today I got the following errors on the same refresh operation

    Job 'T24 Import and Sync' : Step 1, 'Import T24 client to PBB' : Began Executing 2017-04-20 01:00:00
    Msg 7399, Sev 16, State 1, Line 1 : The OLE DB provider "DBAmp.DBAmp" for linked server "pbbprod" reported an error. The provider reported an unexpected catastrophic failure. [SQLSTATE 42000]
    Msg 7330, Sev 16, State 1, Line 1 : Cannot fetch a row from OLE DB provider "DBAmp.DBAmp" for linked server "pbbprod". [SQLSTATE 42000]
    Msg 0, Sev 16, State 1, Line 47 : --- Starting SF_Refresh for Account V3.4.4 [SQLSTATE 01000]
    Msg 0, Sev 16, State 1, Line 99 : 01:01:18: Using Schema Error Action of subset [SQLSTATE 01000]
    Msg 0, Sev 16, State 1, Line 269 : 01:01:22: Using last run time of 2017-04-19 02:33:00 [SQLSTATE 01000]

    So overall its a bit unpredictable at the moment... works some days and fails on others with difference errors.

    Regards
    Derek
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited