Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Exception in component tDBOutputBulkExec_1_tMBE (Mysql)

Hello,

 

i charged the data with tmysqloutputBulkExec, in the end of execution the job i have this error:

Exception in component tDBOutputBulkExec_1_tMBE (DSA__Acquisition_poule_competition_penalite_forfait)
java.sql.SQLSyntaxErrorException: The used command is not allowed with this MySQL version
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:781)
	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:666)
	at local_project.dsa__acquisition_poule_competition_penalite_forfait_0_1.DSA__Acquisition_poule_competition_penalite_forfait.tDBInput_1Process(DSA__Acquisition_poule_competition_penalite_forfait.java:2443)
	at local_project.dsa__acquisition_poule_competition_penalite_forfait_0_1.DSA__Acquisition_poule_competition_penalite_forfait.runJobInTOS(DSA__Acquisition_poule_competition_penalite_forfait.java:5318)
	at local_project.dsa__acquisition_poule_competition_penalite_forfait_0_1.DSA__Acquisition_poule_competition_penalite_forfait.main(DSA__Acquisition_poule_competition_penalite_forfait.java:4919)

any Help please?

Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hello,

Are you using load data local infile command? What's MySql DB version are you using? It seems MySql 5.1 or higher one will be able to support that.

Best regards

Sabrina