Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
hkkwon89
New Contributor

Auto-reload failed in Qlikview Management Console after adding Load dual inline tab

Hello,

I have a dashboard that had no issue being auto reloaded in the management console.

Recently, I made changes to the report in order to create a custom adhoc report and now the qvw is failing to auto reload in the management console. The qvw reloads fine manually within itself, however.

Dimensions:

LOAD DUAL(Dim,Sort) as Dim INLINE

[Dim, Sort

Commercial, 1

Blue Shield Commercial ACO, 2

Covered California Exchange, 3

Senior with DSNP SNPI SNPC MM SE, 4

Senior Medi-Medi, 5

Medi-Cal, 6

Medi-Cal EXPANSION, 7

Medi-Cal Medi-Medi, 8

Medi-Cal SPD, 9

Medi-Cal TANF, 10

Medi-Cal Low Income, 11

SF Risk SF Region Medi-Cal, 12

SF Risk SF Region Senior, 13

SF Risk DO Region Senior, 14

Combined SF Risk Senior, 15

];

Above is the new tab in the script that is causing the issue and I have no idea how to fix it.

I appreciate any help.

Thank you

11 Replies
Highlighted
andrey_krylov
Valued Contributor

Re: Auto-reload failed in Qlikview Management Console after adding Load dual inline tab

Have you checked the log file?

Highlighted
hkkwon89
New Contributor

Re: Auto-reload failed in Qlikview Management Console after adding Load dual inline tab

Hi Andrey

Error log says ---> QDSMain.Exceptions.SourceDocumentNotFoundException: Could not find SourceDocument (distribution)

However, I have the same exact copy of the dashboard with above tab of the script commented out, and that dashboard reloads fine. So it must be the code above that is causing the error; however I am unsure why it is saying a sourcedocument could not be found as it isn't a file that is loading the above table.

Thank you

Highlighted
johncaqc
Valued Contributor

Re: Auto-reload failed in Qlikview Management Console after adding Load dual inline tab

Hi Caleb,

Have you tried "NoConcatenate" for this table (and maybe others that follow)?  It's possible a subsequent load is getting confused on what table it is assigned to. I always define either NoConcatenate, Join or Concatenate to remove doubt on every table I load.

Dimensions:

NoConcatenate

LOAD DUAL(Dim,Sort) as Dim INLINE

[Dim, Sort

Commercial, 1

Blue Shield Commercial ACO, 2

...etc.

V/r,

John

Highlighted
hkkwon89
New Contributor

Re: Auto-reload failed in Qlikview Management Console after adding Load dual inline tab

Hi John,

I tried adding noconcatenate to the load script but it didn't do the trick unfortunately..

Highlighted
johncaqc
Valued Contributor

Re: Auto-reload failed in Qlikview Management Console after adding Load dual inline tab

Okay, fair enough. What exactly are you looking for? You have 3 tables you are loading, one is a crosstable. With the 3 tables provided please share the resulting table. Use Excel if you have to manually create it. Just show what you expect to see in the end table (sorry, I am not understanding the question as is).

Highlighted
hkkwon89
New Contributor

Re: Auto-reload failed in Qlikview Management Console after adding Load dual inline tab

I have about 10 tables currently in my dashboard which has been reloading without a problem in Qlikview Management Console until I added the script in the original thread above in order to meet another department's request and build a custom table for them within the dashboard.

I can reload the dashboard fine manually. However the script above must be causing some kind of issue with QMC which keeps making it fail to reload in console..

Highlighted
johncaqc
Valued Contributor

Re: Auto-reload failed in Qlikview Management Console after adding Load dual inline tab

The best way to troubleshoot this then is to look at the document log file. Not the log in the QMC that you refer to above but the one the document generates in the same folder as the document itself. It will be named the same as the document plus a .txt at the end, so MyDocumentLoad.qvw should have a log file named MyDocumentLoad.qvw.txt in the same folder. If you cannot see it then it needs to be enabled in the Document Properties under Settings. It will be on the General tab near the top. Once you run the document again it should be generated, and you can then open it and look for the failure statement, typically at the bottom of the file.

V/r,

John

Highlighted

Re: Auto-reload failed in Qlikview Management Console after adding Load dual inline tab

1) Is there any Error in Log file of QVW?

2) To ignore, Use Error Handling using SET ErrorMode = 0

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
andrey_krylov
Valued Contributor

Re: Auto-reload failed in Qlikview Management Console after adding Load dual inline tab

Hi Caleb, I think this script can't actually cause a loading error. Check the file name again, considering the fact that QMS swears at it's absence.