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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-10-29 07:07 AM

Error: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax

Starting job xyz at 15:57 29/10/2018. [statistics] connecting to socket on port 4064 [statistics] connected Exception in component tDBOutput_2 (Xyz) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$User.Role_Name__c ,`data1` VARCHAR(1300) ,`data2` VA' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.Util.getInstance(Util.java:384) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2832) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2781) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:908) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:788) at project_1.xyz.xyz.tSalesforceInput_2Process(xyz.java:9866) at project_1.xyz.xyz.tSalesforceInput_1Process(xyz.java:5060) at project_1.xyz.xyz.runJobInTOS(xyz.java:14591) at project_1.xyz.xyz.main(xyz.java:14440) [statistics] disconnected Job xyzended at 15:58 29/10/2018. [exit code=0] i am getting above error message while loading data from sales force source to mysql target. Appreciate any help.

Labels (5)
Labels
370 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2018-10-29 03:05 PM
Author

to be less than helpful: The error likely says what it means. You've got a syntax problem in your salesforce query. Without more details, it is difficult to provide any more assistance.



To get some help from the forum you should add the following details to your future posts:
1) a quick high-level summary of what you are trying to do
2) screenshots or descriptions of your job, and any relevant component configurations
3) stack traces of the errors you're seeing ( which you did include-- thanks! )
370 Views
0 Likes