Internal error when loading an app and I cannot duplicate this app either (this app is set as a task)

[Nemo1]

Hello, 

I have this two tasks that contibute to the building of my app.

The tasks are not loading on the QMC, and I do not get why. I only get "task status: failed" but I cannot download any script log. 

I tried going through the data editor of this tasks, which as I said, are first buidt as apps... but when I load it I get an error "internal error". 

Then I tried duplicating this tasks, and I cannot do that either!. (for the record,I COULD duplicate this app before, I duplicate it one week before)

I wiuld appreaciate any help.

thanks

[Nemo1]

Thanks again, and I am so sorry for keep on asking and asking but I do not know how to do that. 

So to copy the app from its disk location, I guess I should go to C:\ProgramData\Qlik\Sense\Apps ??? or where should i go? I try to find it but I could not... where should I look for it? I am quite new in this world.

[Nemo1]

I do not have a path such as C:\ProgramData\Qlik\Sense\Apps in my computer

[henrikalmen]

You can find the physical location for the apps as an admin in the QMC under "Service Cluster".

[Anil_Babu_Samineni]

@Nemo1 there are three questions what i see

1) To identify script failures without logfile

A) Change in Engine with scheduler service from Log to Debug

And once again run the task and go to : C:\ProgramData\Qlik\Sense\Log\Engine\Trace\YourServerHostName(Which is scheduler node that the job failed)_System_Engine.txt

If you find this error,

Domain/YourAccount ExtendedException: Type '1013' thrown in file 'C:\Jws\engine-common-ws\src\AppObject\src\AppSerializer.cpp' in function '`anonymous-namespace'::AddScriptObject' on line '256'. Message: 'Unknown error' and additional debug info: 'Reload failed! AppScript is not yet available'

First part, Go to PGADMIN and run this from QSR

select * From public."AppObjects"

where "App_ID"='xys' and"ObjectType" in ('app_appscript', 'LoadModel')

If ObjectType not finding for "app_appscript" it means, There is somehow an object missed with this object type during publishing and replace

Please just run these two queries

1) SELECT * FROM "Apps" WHERE "ID" NOT IN

(SELECT DISTINCT "App_ID" FROM "AppObjects" WHERE "ObjectType" = 'app_appscript');

2) SELECT x."App_ID", x."EngineObjectId", x."Owner_ID", '{"qOperation": 2, "qItemID": "' || x."ID"::"varchar" || '"}'

FROM "AppObjects" x , (SELECT ao."App_ID", "EngineObjectId", Max(ao."CreatedDate") maxDate FROM "Apps" app,"AppObjects" ao WHERE 1 = 1 AND ao."App_ID" = app."ID" GROUP BY ao."App_ID", "EngineObjectId" HAVING count(*) > 1) as tmp WHERE x."App_ID" = tmp."App_ID" AND x."EngineObjectId" = tmp."EngineObjectId" AND x."EngineObjectId" != 'LoadModel' AND x."EngineObjectId" != 'qvapp_appscript' AND x."EngineObjectId" != 'app_appscript' ORDER BY x."App_ID", x."EngineObjectId" ;

As a workaround, We can implement this

CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; INSERT INTO "AppObjects" ("ID", "EngineObjectType", "Attributes", "ObjectType", "PublishTime", "Published", "Approved", "SourceObject", "Name", "EngineObjectId", "ContentHash", "Size", "CreatedDate", "ModifiedDate", "ModifiedByUserName", "App_ID", "File_ID", "Owner_ID", "DraftObject", "Description", "AppObjectBlobId") VALUES (uuid_generate_v4(), '', '', 'app_appscript', timezone('utc', now()), true, true, '', '', 'qvapp_appscript', '', -1, timezone('utc', now()), timezone('utc', now()), ' Domain/YourAccount ', 'xys', null, 'abc', '', '', '')

// Here, First ID is app (xyz) and second ID is user ID (abc)

2. Internal error

this always show when you open parallel with same application in the same browser. I would suggest to clear cache and try (If application is yours and there is no blocking in security rules)

3. Duplicate App

I saw someone already shared knowledge, please explore there in your another post instead of clubbing with duplicate information questions.

Good luck!

[Nemo1]

Hello, thanks for answering. It is me again 😞

So I found the physical location for the app, and I identify it through its Target App ID. 

I go to the disc location, with this Target App ID number, I search for it and I get different files but non in QVF file. I get the as ".lock" and then I get another folder with many files, around 20, but none of them is a QVF file... what is going on? any help is appreciated it

[henrikalmen · Accepted solution]

Yes sorry, the files are without extensions. Copy the file with the correct ID to somewhere else, and rename it to soemthing and give it the extension .qvf. Then try to import it. (Ignore lock files).

If it still doesn't work, try to investigate the answer by @Anil_Babu_Samineni. I'm not sure what the create extension statement actually does, could you explain that part Anil?

[Nemo1]

hello, thank you again. I have done that, but still, when I try to import it , it gives me an error. I will see the answer from Anil now 

[Anil_Babu_Samineni]

@henrikalmen The Extension table force to clean the nullify and insert with existing database. This is somehow my thoughts (Since I have experienced in the past). Once we clean the null records and insert  with some string (Like, . and , etc.), It will release the ContentHASH if anywhere blocked. 

[Nemo1]

I have found the solution, thanks for the help. i realy appreciaite it!!! u rock!

[Nemo1]

Thanks, I have found the solution. I love this community