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

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

hkkwon89 — Wed, 25 Nov 2020 16:16:04 GMT

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

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

andrey_krylov — Sat, 06 Oct 2018 06:42:38 GMT

Have you checked the log file?

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

hkkwon89 — Tue, 09 Oct 2018 16:50:40 GMT

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

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

johnca — Tue, 09 Oct 2018 17:13:01 GMT

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

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

hkkwon89 — Tue, 09 Oct 2018 20:14:43 GMT

Hi John,

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

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

johnca — Tue, 09 Oct 2018 20:31:25 GMT

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

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

hkkwon89 — Tue, 09 Oct 2018 20:35:56 GMT

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

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

johnca — Tue, 09 Oct 2018 21:23:12 GMT

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

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

Anil_Babu_Samineni — Wed, 10 Oct 2018 03:41:25 GMT

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

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

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

andrey_krylov — Wed, 10 Oct 2018 04:09:48 GMT

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.

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

hkkwon89 — Wed, 10 Oct 2018 16:36:45 GMT

This is what I'm seeing in the log file

2018-10-09 11:09:12 Error: Bad call to OpenFileOrURL: "\INL100D.tmp" and DefaultDir was empty !

2018-10-09 11:09:12 General Script Error

2018-10-09 11:09:12 Execution Failed

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

johnca — Wed, 10 Oct 2018 17:03:57 GMT

Here's some info on your specific failure mode;

Inline table error "Bad Call to OpenFileOrURL" new Desktop SR

HTH,

John