topic Re: Table keeps reverting to suspended in Data Movement & Streaming

Table keeps reverting to suspended

Andrew_ENT — Wed, 19 Mar 2025 21:46:28 GMT

Can someone provide a checklist for how to identify what is causing a table to suspend and how to deal with it please?

I'm loading in the table VBFA from SAP (Sales Document Flow). It shows here what we should expect the Keys to be VBFA SAP Table (Sales Document Flow).

I started encountering errors with this table and I suspected it was to do with one of the key fields being blank. So I put an expression in for each of them;

They basically all say $IFNULL(${VBELV} , 'NA')

But still I get errors.

Does anyone have a neat checklist of what things to check first to get this working?

Thanks in advance.

Re: Table keeps reverting to suspended

TimGarrod — Mon, 06 Jan 2025 16:10:21 GMT

Andrew - 2 items that may help.
1 - the log for the task should provide details on the table issue.
If that is difficult to traverse, you can add a Control Table to the task so that suspended tables are written to it with the reason.

See - https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Replicating/suspended_tables.htm

In your task settings for Replication or Landing tasks goto Metadata > Control tables and enable 'Suspended tables'.
Stop the task, Prepare the task (to send the configuration to the gateway) and then Resume

To capture the info for the suspended table you may need to reload it.

Re: Table keeps reverting to suspended

Andrew_ENT — Tue, 07 Jan 2025 10:32:51 GMT

Thanks Tim.

I checked logs and they didn't seem to go back far enough to when this first occurred. So, I've hit reload tables and it loaded successfully. I'll continue to monitor the situation.

Is there any way to program an "on error" rule in QCDI? Assuming that it finds a null in a field that should be non nullable, and would therefore cause an error, I'd like it to still load all other lines.