Table not found

[suvbin]

Hi Team,

Got below error , but the task is running fine.  Table is existing in the logstream task and in the child task. 

Target is : Bigquery.

Failed to truncate net changes table
Execute truncate net changes table failed. 'TRUNCATE TABLE `Qlikrep_us`.`attrep_changes8CE8FA68F7008BFB`'
RetCode: SQL_ERROR  SqlState: 42S02 NativeError: 31770 Message: [Simba][BigQuery] (31770) Table is not found. Not found: Table pa-qk-prd-clinet:QlikRep_us:attrep_changes8CE8FA68F7008BFB was not found in location QlikRep_us

Does this mean that the table is not existing in the target?  But changes are getting captured. Then why this error is comming. 

Request to brief on this.

[Heinvandenheuvel]

>> Table is existing in the logstream task and in the child task

With that you surely mean the base/target table.

The error is reported for the 'net changes' temporary table. You've been working with Replicate long enough to know about the comings and goings of those helper tables don't you? They are created on first activation, filled to create a 'batch', truncated just before a next batch to be build, and an attempt is made to drop them on task end. Apparently the timing of these steps was 'off', likely due to an earlier, correctable, issue.

What was the error level in the log?

]I: or even ]W: - Informational / Warning? Don't worry be happy!

Did it ever work without error? Is the error reproducible? What circumstance appear to trigger this?

If you are serious about understanding the why/when/how about this, then you must run the task with LOGGING LEVEL for TARGET_APPLY set to debug and GREP (FINDSTR ... or whatever tool you like), for attrep_changes[8CE8FA68F7008BFB]

hth, Hein.