topic Re: Connectivity Error while reloading Qliksense Application in Connectivity & Data Prep

Connectivity Error while reloading Qliksense Application

GOKULAKANNAN — Mon, 06 Nov 2023 12:09:28 GMT

Hi Team,

Am facing an issue while reloading the application from the QMC Task, Its saying error like below,

"Connector connect error: SQL##f - SqlState: S1000, ErrorCode: 50090, ErrorMsg: [Simba] [Support] (50090) Conversion from string to number failed with value ‘ ‘ "

Have anyone faced this issue before, Kindly respond.

Re: Connectivity Error while reloading Qliksense Application

jochem_zw — Mon, 13 Nov 2023 19:42:12 GMT

Which database is the Simba Driver trying to connect? Is it Google Big Query?

Re: Connectivity Error while reloading Qliksense Application

GOKULAKANNAN — Tue, 14 Nov 2023 13:59:06 GMT

Hi @jochem_zw ,

Yeah it is google big query

Re: Connectivity Error while reloading Qliksense Application

jochem_zw — Tue, 14 Nov 2023 14:13:57 GMT

did you try this?

https://stackoverflow.com/questions/62903325/why-do-i-get-a-conversion-from-string-to-number-failed-with-value-error-whe

Re: Connectivity Error while reloading Qliksense Application

GOKULAKANNAN — Tue, 14 Nov 2023 14:27:05 GMT

Hi @jochem_zw ,

I have checked this, still am facing the below error,

Error: Connector connect Error:SQL##f-SqlState: S1000, ErrorCode: 8701, ErrorMsg: [Simba] [DriverOAuthSupport] (8701) Error interacting with REST API: Failure when receiving data from the peer

Re: Connectivity Error while reloading Qliksense Application

jochem_zw — Tue, 14 Nov 2023 15:37:27 GMT

Look like you have an Authentication problem, did you create a service account etc.?? Think you have to connect by Service Account. Maybe best to create a support case ith Qlik, because i'm running out of options....Sorry!