Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
james_hanify
Creator
Creator

'Script failed' but doesn't seem to be

I have tried going through the debug and it seems to successfully do its thing.

It just always seems to fail on the store of the qvd

I have tried different things but to no avail.

Path for save path

// sets path for saving

SET vPathQvd = '..\Data\TestQVDs';

Directory [$(vPathQvd)];

This is my script ending


// Begin process to end the script

DisConnect; //disconnect gracefully from ODBC? No further ODBC connections can be deployed after this line

// To store data into QVDs to be used by the user interface later and be more efficient

for i = 0 to NoOfTables() - 1

  LET d = TableName(i);

  //store $(d) into $(vPathQvd)\$(d).QVD;

  store $(d) into $(d).QVD;

next

// To find out the how long the script took

LET vScriptDuration = interval(now() - $(vScriptStartTime),'mm:ss');

// Allow a graceful exit

exit Script;

When I comment out the whole store part, it doesn't say script failed but then it obviously hasn't stored it, which makes me think it is a permissions problem?

Any help / advice would be appreciated

3 Replies
girirajsinh
Creator III
Creator III

Hi

Could you share .qvw or part of it ?

One thing to check is $(d) is not Null. .. Check  what TableName(i) carries . You may use TRACE command to know it values.

girirajsinh
Creator III
Creator III

HI James,

Following is working for me. It saves each table into separate qvd

SET vPathQvd = 'D:\Girirajsinh'; 
Directory [$(vPathQvd)]

DisConnect;


for i = 0 to NoOfTables() - 1 
LET d = TableName(i); 
store $(d) into $(d).QVD; 
next 

//LET vScriptDuration = interval(now() - $(vScriptStartTime),'mm:ss'); 
exit Script

Chip_Matejowsky
Support
Support

Hi James,

In my past experience, I have run across some similar issues as yours regarding tasks failing if a STORE to QVD is invoked in the load script., especially if the STORE command and is called near the end of the load script. Something you may want to try would be to create a temporary auto-generated table immediately after the STORE command as the OS needs time to process file operations associated with the STORE command before moving on with the load script. An additional troubleshooting step you may implement would be to auto-generate a temporary table after the STORE command. This should allow enough time for the file operations to compete.

You could have the QVW developer include something similar to the below after the STORE command:

Load RecNo( ) as A, rand( ) as B autogenerate(100000);(Note: The parenthesis after autogenerate is allowed but not required.)


Hope this helps

-Chip

Principal Technical Support Engineer with Qlik Support
Help users find answers! Don't forget to mark a solution that worked for you!