Reload task giving Error: Zip Error when trying to access a file on particular node

[sravanthiG]

When reload is triggering to particalur scheduler node its failing with Error: Zip Error , but same task is being run on all other scheduler nodes , what could be the issue with the Node ?

[Chip_Matejowsky]

Hi @sravanthiG,

Is this issue for QlikView or Qlik Sense? Can you provide a screen capture or task log snippet that has the full error?  Thanks!

Best Regards

[sravanthiG]

This issue is in Qliksense May 2021 patch4 ,and this task has the data connection of sharepoint from wherre it should able to fetch and used for processing 

[Chip_Matejowsky]

@sravanthiG,

Can you provide the full, exact wording of the error or log that contains the error? Thanks!

Best Regards

[sravanthiG]

Hi, I am attaching the error snippet from the log as i could not provide you the full log, So as per below error  "SP - SVB Expedite SFDC" this is the sharepoint connection and when the task goes to particular node its giving the error and for rest of the nodes task is successful 

20230322T043441.939-0400 0086 FROM [lib://SP - SVB Expedite SFDC]
20230322T043441.939-0400 0087 (ooxml, embedded labels, table is ***)
20230322T043503.003-0400 Error: Bad Zip File
20230322T043503.004-0400 Execution Failed
20230322T043503.006-0400 Execution finished.

[Chip_Matejowsky]

Hi @sravanthiG,

Can you provide more information on what the source data is? [lib://SP - SVB Expedite SFDC] is this SalesForce data connector?
 

From my experience the Error: Bad Zip File occurs when attempting to load data from a password protected Excel file. Is this the case here? If yes, test by removing the password protection to see if the reload is successful.

Best Regards

[sravanthiG]

This is of excel file  which will be accessed from sharepoint and it does not have any password enabled

[Chip_Matejowsky]

Hi @sravanthiG,

Have a look at Qlik Knowledgebase article Fetching data from files on SharePoint with Qlik Sense for multiple ways to load data from SharePoint into Qlik Sense.

Best Regards 

[sravanthiG]

This task is running on every node and going to success , but with particular node9 particular web file is giving an Zip file error , and SharePoint link is accessible from that particular node 9 and can download the file. Do we have to check anything from the server configurations perspective ??