topic Re: Hi, facing issues with QEM replicate API in Qlik Replicate

Hi, facing issues with QEM replicate API

rahulkokane — Fri, 22 Dec 2023 04:54:40 GMT

Hi, we are not able to create QLIK tasks through QEM APIs.

Error we are seeing in server logs:

00017626: 2023-12-21T06:32:03:709625 [DATA_STRUCTURE ]E: SQLite general error. Code <5>, Message <database is locked>. [1000505] (at_sqlite.c:525) 

00017626: 2023-12-21T06:32:03:709660 [DATA_STRUCTURE ]E: SQLite general error. Code <5>, Message <database is locked>. [1000506] (at_sqlite.c:475) 

00017626: 2023-12-21T06:32:03:709672 [INFRASTRUCTURE ]W: Failed to update task status (error=1000505) (repository.c:5895)

Our PROD env is down, please provide solution for the same. Also sharing server logs file.

Thanks

Re: Hi, facing issues with QEM replicate API

sureshkumar — Thu, 21 Dec 2023 07:45:39 GMT

Hello @rahulkokane

We don't have any APIs to create task using REST API, .NET API and Python API in QEM.
Kindly let us know which command you're trying to run at QEM server.

Below is the supported API commands

Qlik Enterprise Manager API guide | Qlik Enterprise Manager Help

Regards,

Suresh

Re: Hi, facing issues with QEM replicate API

ShrinathAnkita — Thu, 21 Dec 2023 07:57:28 GMT

No we are not using the REST API. Rahul is talking about the action=import which we use to import a task on a server there we are getting

Failed to create cloud task :testattunity. Request Error</p> <p>The server encountered an error processing the request. See server logs for more details.</p>

Re: Hi, facing issues with QEM replicate API

rahulkokane — Thu, 21 Dec 2023 08:09:54 GMT

thanks @ShrinathAnkita for adding this.

Re: Hi, facing issues with QEM replicate API

sureshkumar — Thu, 21 Dec 2023 08:21:39 GMT

Hello @rahulkokane @ShrinathAnkita

As you already opened a support ticket, lets continue to troubleshoot the issue in the opened support ticket.

Regards,
Suresh

Re: Hi, facing issues with QEM replicate API

Heinvandenheuvel — Fri, 22 Dec 2023 02:55:26 GMT

>>> Hi, we are not able to create QLIK tasks through QEM APIs.

FWIW: The QEM has it's own forum, but admittedly it only reaches a small audience of experts and also admittedly is heavily polluted by misguided Qlik Sense adventurers. https://community.qlik.com/t5/Qlik-Enterprise-Manager/bd-p/qlik-enterprise-manager-discussions

Anyway, please clarify. Does that mean you are trying to IMPORT tasks through the Enterprise manager with a script?

- Did it ever work? Does it work in a lower (DEV) environment?

- Does it work with through the QEM - UI directly?

- Does it work on the Replicate Servers directly - with UI and/or using REPCTL importrepositry?

>>> Our PROD env is hamered,

?!?! English please! Use your words. Full sentences please. We are not mindreaders.

From the log:

...Database /attunity/data/tasks/RepoGlobal.repo is locked. Retry count is

... Free repository /attunity/data/tasks/xxx/xxx.repo

That feels like poor error handling Assuming a root cause.

Now those logs were set to verbose, which may well be required for analysis. At the same time it may be reporting way to many event which look bad but are in fact good - like when creating a fresh object, one may try to delete it first but if it is not there, that's ok.

Perhaps the root cause is a protection violation ?

Hein.