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

[hkkwon89]

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

[andrey_krylov]

Have you checked the log file?

[hkkwon89]

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

[johnca]

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

[hkkwon89]

Hi John,

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

[johnca]

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

[hkkwon89]

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

[johnca]

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

[Anil_Babu_Samineni]

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

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

[andrey_krylov]

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.