Local Data Processing Error: F_JD21B4: DBMS Error Invalid Object Name…

Edit on GitHub

Matt Taylor Fivetranner

Issue

Integrate Job returns the following error after importing a channel:

F_JD21B4: DBMS error [Invalid object name 'return'. Statement(s) could not be prepared]. Last query [select top(1) * \
from [return]].

Local Data Processing

This usually happens if a channel is imported from a different hub and the router directory for this channel contains older files.

Remove the old router files from directory $HVR_CONFIG/router/<hubname>/<channel name>/loc_<src>/loc_<tgt>