Export to Excel/Server Log Issue

[Anonymous]

Hello Folks,

I have been struggling to find the reason for the following:

Every time a user right-clicks on a QlikView Object to export the data to excel, the following error comes up.

"Export Failed. Please check server log for more details. (It's most likely that export process took too much Server resource)"-see attached.

When we look into the log we notice that there is a Warning message that states as follows.

"<xxxxxx.qvw> failed to load because of no file access [3000]"

I know this error typically has something to do with section access restrictions but there is no section access on this application. Does anyone know what this error means? I'm particularly intrigued by the [3000]. Could this warning message be the reason why export is not available for the user?

Also, please keep in mind the user is accessing the QVW via the Access Point.

Any insight would be greatly appreciated. Thank you.

[marcus_sommer]

Maybe it's restricted within the qmc:

- Marcus

[naim216 · Accepted solution]

Environment:

• QlikView 12.20 (November 2017) and up

Edit or add the following config parameters in C:\ProgramData\QlikTech\QlikViewServer\Settings.ini and Restart Services:
QvExportTimeLimitSec=-1
QvExportMemoryLimitMB=0

Description:
QvExportTimeLimitSec (Use -1 if you don't want time limit; Default Values:-->On Server: 180 Desktop: -1)
Time limit for exporting object to Xlsx. Integer number in seconds.

QvExportMemoryLimitMB (Use 0 if you don't want memory limit;)
Memory limit for exporting object to Xlsx. Integer number in MB.


The setting needs to be applied in the settings.ini file in as a [Settings 7] property. Example: 
 

[Settings 7]
QvExportTimeLimitSec=-1
QvExportMemoryLimitMB=0
ServerLogFolder=\\QLIKSERVER2\share\logs
DocumentDirectory=\\QLIKSERVER2\share\root
NumberOfDocuments=-1

[Brett_Bleess · Accepted solution]

Just beware the above post is setting 'unlimited' on both values, so no size or time limit on exports, which you may not want to allow if you have some users that may do crazy things regarding trying to export information.  It may be better to increase the limits but leave limits in place to ensure you see the ones that are failing and can evaluate whether that is a use case you want to allow or not.

Regards,
Brett

[fabio_ribeiro]

Hi Everyone, I just want to know what is the max and min value of these parameters.

QvExportTimeLimitSec=-1
QvExportMemoryLimitMB=0

And If is possible to know where the SELOG_Export file is saved.

Thanks in advance.