topic Re: Compose DWH - TPIL error in Qlik Compose

Compose DWH - TPIL error

garyclark — Fri, 14 Mar 2025 20:49:07 GMT

Hi Team,

Some times after deploying new project we are getting below error, can you please let us know why we get this issue and how can we resolve.

Currently we are dropping and recreating the tales in DWH and DM as a work around. Please let me know if you need additional details from our end

Thanks

Re: Compose DWH - TPIL error

Nanda_Ravindra — Fri, 04 Feb 2022 22:20:55 GMT

Hello @garyclark

What version of Qlik compose are you running?

Is the deployment package that you are trying to deploy is from an older version of compose? If so, please indicate that version as well.

Regards,

Nanda

Re: Compose DWH - TPIL error

garyclark — Mon, 07 Feb 2022 15:31:36 GMT

Hi @Nanda_Ravindra Thanks for responding. compose version we are using is "2021.8.0.262" .
We have created a deployment project from this version and then deployed JSON file on to a new project on the same server and same version. Also this issue does not happen everytime so I am interested to know why and when this is happening.
I hope I answered your questions.
Thanks.

Re: Compose DWH - TPIL error

Nanda_Ravindra — Mon, 14 Feb 2022 22:02:36 GMT

Hello @garyclark

The error message you are seeing could be a result of a project which was originally migrated from an older version and you might have missed an upgrade step.

If the above is not true, please open a case with support and send the ETL log in verbose.

Thanks,

Nanda

Re: Compose DWH - TPIL error

Aldy — Fri, 15 Apr 2022 21:59:34 GMT

Hello All,

This issue "java.sql.BatchUpdateException: Invalid object name 'dbo.TPIL_RUNS" never got fixed since the days of version 6.0 and still persists even with the latest version 2021.8

I have been waiting for more than an year for a solution on this.

Re: Compose DWH - TPIL error

Dana_Baldwin — Fri, 15 Apr 2022 22:34:12 GMT

Hi @Aldy

I researched this and found your support case. I apologize for the delay. I do see recent activity that the issue is being actively worked. Please continue to monitor your support case for the current status.

Thanks,

Dana

Re: Compose DWH - TPIL error

Aldy — Fri, 15 Apr 2022 23:24:18 GMT

Hi @Dana_Baldwin

Thank you for your response.

Re: Compose DWH - TPIL error

Nanda_Ravindra — Wed, 18 May 2022 18:40:33 GMT

@garyclark Is this issue still persist in your environment?

Since this issue is not consistent, we will have to look into the logs in verbose when this happens. That being said, we have a similar intermittent issue associated with the "Invalid object name dbo.TPIL_RUNS" error which we have addressed in our 2021.8 - sp14 patch ( FYI, you are on sp04). Our suggestion here is to have you upgrade to the latest patch(2021.08-sp14) and open a case with support if the issue still persists.

Hope this helps!

Thanks,

Nanda