Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vishalgoud
Creator III
Creator III

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

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
Creator III
Creator III
Author

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,