Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
patbuchanan
Contributor III
Contributor III

An error occurred - Unsupported file format

I'm using Qlik Sense 3.2 SR4 and have had several apps that are published that have stopped working with my daily reload tasks and not open when I try to open them in the published stream.  I just get an message saying 'An error occurred - Unsupported file format'

QSerror.PNG

I keep a copy of the apps in my work folder and I go to that app and it works fine and it lets me reload but when I try to republish this app it gives me the same error 'An error occurred - Unsupported file format'.  The only solution I've found is to delete the Published app and re-copy/publish the app from my work folder but that gives me a new appid and breaks the links/shortcuts that the users have already made which they are giving me push back on...


I looked in Chrome and see this too:

QSerrorDetails.PNG


My app also uses Section Access:

Section Access;

Load * Inline [

  ACCESS, USERID , GROUP , REDUCTION_ACCTNUM , OMIT

  ADMIN , INTERNAL\SA_ENGINE , * , * ,

  ADMIN , INTERNAL\SA_HUB , * , * ,

  ADMIN , INTERNAL\SA_PRINTING , * , * ,

  ADMIN , INTERNAL\SA_PROXY , * , * ,

  ADMIN , INTERNAL\SA_QLIKVIEW , * , * ,

  ADMIN , INTERNAL\SA_REPORTING , * , * ,

  ADMIN , INTERNAL\SA_REPOSITORY , * , * ,

  ADMIN , INTERNAL\SA_SCHEDULER , * , * ,

  ADMIN , CORP\User1, * , * ,

  ADMIN ,   CORP\User2, * , * ,

  ADMIN ,   CORP\User3, * , * ,

  ADMIN ,   CORP\User4, * , * ,

  ADMIN ,   CORP\User5, * , * ,

  USER ,   CORP\User6, * , 'TERRITORY 2' ,

  USER ,   CORP\User6, * , 'TERRITORY 2 MANAGER' ,

  USER ,   CORP\User7, * , 'TERRITORY 3' ,

  USER ,   CORP\User7, * , 'TERRITORY 3 MANAGER' ,

  USER ,   CORP\User8, * , 'TERRITORY 1' ,

  USER ,   CORP\User8 , * , 'TERRITORY 1 MANAGER' ,

  USER ,   CORP\User9, * , 'TERRITORY 4' ,

  USER ,   CORP\User9, * , 'ACCOUNT MANAGEMENT' ,

  USER ,   CORP\User9, * , 'TERRITORY 4 MANAGER' ,

  USER ,   CORP\User10, * , 'K12 ACCOUNTS LARGE > 40K' ,

  USER ,   CORP\User10, * , 'K12 ACCOUNTS LARGE > 40K MANAGER' ,

  USER ,   CORP\User11, * , 'EDU TECH' ,

  USER ,   CORP\User11, * , 'EDU TECH MANAGER' ,

  USER ,   CORP\User12, * , 'ONBOARDING' ,

  USER ,   CORP\User12, * , 'ONBOARDING MANAGER' ,

  USER , CORP\User13, * , 'ONBOARDING' ,

  USER , CORP\User13 , * , 'ONBOARDING MANAGER' ,

];

Section Application;

18 Replies
tbrancazio
Luminary Alumni
Luminary Alumni

Hi Emmanuelle,

I haven't seen this error since back when I first encountered it and posted to this thread.  In our case, it appeared to have been spaces used within the section access.  We also just recently upgraded to November 2017 a month ago. 

Have you tried making a duplicate copy of the app to see if that will open?  Perhaps look through the load statement for any random spaces that are not needed?

Sorry I can't be of more help.  I know your app doesn't use section access, but as soon as we removed the unneeded spaces; the app opened without the error.  

Emmanuelle__Bustos
Partner - Specialist
Partner - Specialist

Okay Tom, Thank you.

gianpaolo_31
Contributor III
Contributor III

Hello Everyone,

Any resolution on this error?

We've experienced the same when Section Access is used.

Qlik Sense Server April 2018 release.

Thanks.

tbrancazio
Luminary Alumni
Luminary Alumni

Hi Gian,

I had not seen this error in the longest time until a couple of weeks ago on a new app build with section access.  I am not sure if this was the root cause, but we had a synthetic key that seemed to be causing the problem.  We opened the app without data, removed the synthetic key, and reloaded.  After doing so, we republished to the stream and the application opened with no issue.

gianpaolo_31
Contributor III
Contributor III

Hello Thomas,

Good day!

We've found a 'workaround' regarding this issue. Please see below steps.

-duplicate app (Section Access on original file is disabled)

-enable section access

-DON'T RELOAD

-save

-publish

-check if accessible

-create task

Thanks.

dwforest
Specialist II
Specialist II

Out of disk space on the Server where the log files and/or app files are stored?

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

It doesn't seem to be the case for the original poster, but when I did Section Access in QlikView I would tend to prefix the security field with a % and use a HidePrefix.

This seems to break Sense at the moment (Sep 2018). When I had a hidden field it broke, changed it to a non prefixed one and it worked. Not sure if it was the fact it was hidden or the fact I used a % symbol. A different symbol might have worked fine.

Hope that helps someone...

Steve

bbergstrom
Partner - Creator II
Partner - Creator II

One solution that just worked for us is to make a duplicate of the app and open it without data.  This allowed me to open the app, go to the Data Load Editor and then reload the data.  So far so good.

This was in the April 2018 version of Qlik Sense.

Hope this helps someone.

KingsleyJH
Partner - Contributor III
Partner - Contributor III

I have found the same issue and was battling to find a solution online.

I did the following steps and it seemed to have worked for me:

    1. Duplicate the app to your workspace.

    2. Delete the Section Access (copy it to notepad first so you don't lose it)

    3. Place an exit script before any tables are loaded (I did this immediately after the variable declaration in the main section)

    4. Go to QMC and export app to your local PC.

    5. Delete app from your workspace.

    6. Import app with a new name (I just added a "1" on the end).

    7. Open the app and reload it.

    8. Paste the Section access back in.

    9. Reload again.

    10. Publish to a stream

 

As mentioned, this worked for me. I hope it also works for you!

 

God Bless

Kingsley