Hi, facing issues with QEM replicate API

[rahulkokane]

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

[sureshkumar]

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

[ShrinathAnkita]

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>

[rahulkokane]

thanks @ShrinathAnkita  for adding this.

[sureshkumar]

Hello @rahulkokane @ShrinathAnkita 

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

Regards,
Suresh

[Heinvandenheuvel]

>>> 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.