Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

vishalgoud
Contributor

extractor app and final app(UI) are not going to exit script tab..??

We have a separate extractors for fact and dim tables scheduled the the final app reload based on the success of 2 extractors.

Dim extractor fine but coming to fact extractor even after generating all the qvds its still shwoing in running state only in QMC.

we observed that and killed it manually and we reloaded the final app manually now its going on..

now the same happening with the Final application with UI, its reloaded till before the exit script, but not moving further its been 2 hours

from the latest log we see that information, it is not exiting the script

we are bit surprised to see, i wrote exit scirt at the end for both.

I can not do a full reload in dev env but debug used to work perfectly for extractor and full reload worked perfectly for final app(UI).

the prod server version is Qv 11.20.13407.0 SR15 (x64).

dev qv version is Qv 11.20.13607.0 SR17 (x64).

Please suggest seom solutions to fix this as this is very important now.

2 Replies
Or
Valued Contributor II

Re: extractor app still reloading in QMC even after generating all qvds...??

Are you dropping tables in your script after the QVD is built?

If you load a bunch of tables, and don't drop any, it's likely the time is being spent trying to generate a bunch of synthetic keys. You can get around this by dropping tables after they're written to QVD, as a quick alternative to actually modifying the data model. Alternatively, you can use the Loosen Tables command to prevent QlikView from trying to create keys between the tables.

vishalgoud
Contributor

Re: extractor app still reloading in QMC even after generating all qvds...??

Hi Thanks for the reply ,

yes am droppping all the tables once they created to qvd. was not sure where we are going wrong.

A for loop was used at the end but that is before exit script only,

Community Browser