Qlik sense desktop - cannot write data into MySQL db

[zplskova]

Hello

I have a connection to MySQL and need to perform a simple exercise :

1. load data from table 1 from db to qlik sense

2.  write data to table 2 from qlik sense to db

I can load data from db into qlik however when I try to write data back or just clear the table (error below) in db I get the error (screenshot attached).

The following error occurred:

QVX_UNEXPECTED_END_OF_DATA: ERROR [42000] [Qlik][MySQL] DELETE command denied to user 'xxx_xxxx'@'xx.xx.xxx.xx' for table 'NPI_STATUS_TRACK_2'

The error occurred here:

SQL DELETE FROM `npi_status`.`NPI_STATUS_TRACK_2`

When I try to write data back to MSSQL it works, but qlik sense desktop doesnt allow me to write data back to MySQL.

So basically I can load from db whatever I want but 'other direction' (from qlik to db) doesnt work.

Anyone who could help me pleeeaaaase?

[arielrichtman]

This sounds like a permissions issue at database level. Consult your DBA.

[zplskova]

Thank you. I hoped this is not that case... 😞

[Rocky6]

Can i have a sample data for this i am also trying the same and i could not find the answer. Can someone help me out to solve this solutions.