ERROR [HY000] [Qlik][MySQL] Error writing file

[nigam_bhavya1410]

Hello All, 

I am trying to load data to my Qliksense dashboard through the data load editor. I have been loading the data for two years. While loading the data, I am getting the below error, but it works fine when I load data for one year. Can anyone please help me resolve this issue?

The following error occurred:

ERROR [HY000] [Qlik][MySQL] Error writing file 'C:\Windows\TEMP\MY4ACB.tmp' (Errcode: 28).

Qlik Data Gateway  Qlik Sense Business 

[Benoit_C · Accepted solution]

Hello @nigam_bhavya1410,

Error you have provided is very generic and does not seem Qlik related.
 

(Errcode: 28 - No space left on device) The error means that you don't have enough space to create temp files needed by MySQL.
You can use df -h to check whether \tmp is in its own partition, and how much space is allocated to it.
 

If it is in its own partition and short of space, you can either: modify /tmp so that its partition has more space (either by reallocating or moving it to the main partition - e.g. see here) changing MySql config so that it uses a different temp folder on a different partition, e.g. /var/tmp
 

You can refer this similar issue:

https://stackoverflow.com/questions/7415710/mysql-writing-file-error-errcode-28
https://support.cpanel.net/hc/en-us/articles/4402486828567-MySQL-won-t-start-Errcode-28-No-space-lef...

Regards,

Benoit

[ShubhamD_QS]

Hi @Benoit_C , 

We are also getting the same error, 

ERROR [HY000] [Qlik][Support] (50070) Cannot open file 'C:\Users\AUQLIK~1\AppData\Local\Temp\XYZ.tmp' - Error: Access is denied.

What could be the reason ?? 

Is it from QlikSense or DB ?

Shubham