Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Surendrap595
Contributor
Contributor

error while loading data in Qliksense

Dear Experts,

I am new to the Qliksense and am getting the error while loading data from MYSQL DB to Qliksense app.

clipboard_image_0.png

after getting this error i have checked there is no Syntax error in Script but after clicking on Load data its throwing this error and also i have deleted the table from Qlik sense app but still its throwing the same error with same table name after deleting table aslo.

Could you please help me on this issue.

 

Thank you in advance.

Best regards 

Surendra

7 Replies
dplr-rn
Partner - Master III
Partner - Master III

can you share the part of script where this error is occuring.
I would also copy the sql and run on the mysql client to diagnose
Surendrap595
Contributor
Contributor
Author

Hi ,

The script what i am using is as follows.

LIB Connect to 'SG_DATASOURCE'

Load 'ID',
'Total_sales',
'Total_quantity'
'Units'
SQL SELECT ID,
'TOTAL_SALES',
'TOTAL_QUANTITY',
'Units'
FROM SGDB.'SALESORDERS';

while clicking on load data am getting the error:

SQLSTATE:3700,Error code: 1064,ErrorMsg:[MYSQL][ODBC5.3(A) dRIVER][mysql-5.7.19-log]

Here i am loading the table from MYSQL DB to Qliksense.

Colud please check and help me on this issue.

SergeyMak
Partner Ambassador
Partner Ambassador

Load 'ID',
'Total_sales',
'Total_quantity'
'Units';
SQL SELECT ID,
'TOTAL_SALES',
'TOTAL_QUANTITY',
'Units'
FROM SGDB.'SALESORDERS';

I can see missing semi-colon before SQL Select.
Try to add it. Or just re-select the data from that table in Edit Script .
I think, it might fix the issue
Regards,
Sergey
Surendrap595
Contributor
Contributor
Author

Hi Seregy,

its there in the script but its not working ,its throwing same error.

is there any issue with single quotes i found some posts like we need to use

SET DirectIdentifierQuoteChar='``';

LIB Connect to `SG_DATASOURCE`

Load `ID`,
`Total_sales`,
`Total_quantity`
`Units`;
SQL SELECT ID,
`TOTAL_SALES`,
`TOTAL_QUANTITY`,
`Units`
FROM SGDB.'SALESORDERS';

is the above script is correct or is there any mistakes.

Thank you.

Surendra

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Is it because of missing ';' at here?

>>>LIB Connect to `SG_DATASOURCE`

SergeyMak
Partner Ambassador
Partner Ambassador

I'd recommend you to comment that script and select data from the table again.

When you copy script from web-sites, quotes might be changed. You need to replace them with a normal ones, which you can type on your keyboard.

Although, it won't be an issue if you select data from SQL table again. It will also add all necessary semi colons.

Regards,
Sergey
Brett_Bleess
Former Employee
Former Employee

Be sure to check your SQL connector log in this case, as it will likely have more detailed information.  We are simply returning the message being provided by the SQL driver/connector you are using...  

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.