Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue Connecting to Qlik Data Market with Qlik Sense 3.0 -remote server returned an error: (400) Bad Request.

I get an error like below or similar whenever attempting to access Qlik Data Market Free content?

note: that I do not see a DM connection in the data connections area of the UI.

All help appreciated in diagnosing this issue.

-Robert

ERROR OUTPUT

8:06:23 TT

The remote server returned an error: (400) Bad Request.: SQL SELECT "_dim_8q8e", "_dim_8q8f", "_dim_8q8g", "Year", "MEASURE=1" FROM fact:516m WHERE '8q8e' = '4.7' AND '8q8f' = '1' AND '8q8g' = '2.4' AND MEASURE = '1' AND TIME = MOST RECENT

Code Segment
LIB CONNECT TO [DM];

[World population by country]:
LOAD

  [_dim_8q8e] AS [_dim_8q8e],

  [_dim_8q8f] AS [_dim_8q8f],

  [_dim_8q8g] AS [_dim_8q8g],

  [Year] AS [Year],

  [MEASURE=1] AS [Persons];

SQL SELECT

    "_dim_8q8e",

    "_dim_8q8f",

    "_dim_8q8g",

    "Year",

    "MEASURE=1"

FROM fact:516m

WHERE '8q8e' = '4.7'

  AND '8q8f' = '1'

  AND '8q8g' = '2.4'

  AND MEASURE = '1'

  AND TIME = MOST RECENT;

6 Replies
Not applicable
Author

I've facing the same issue with Qlik Sense Desktop, but the connection with a Qlik Sense Cloud Basic account works just fine.

I compared the scripts generated by a Desktop and a Cloud, it seems the only different is the connection line which the Cloud one has the identifier inserted.

Desktop

LIB CONNECT TO [DM];

Cloud

LIB CONNECT TO [DM (qlikcloud_qlikid_<cloud_account_username>)];

I tried to run the Cloud script on the Desktop, but the following errors return. Without the identifier, it will return the (400) Bad Request error

The following error occurred:

Could not fetch connection by name using identifier DM (qlikcloud_qlikid_xxxxx)

The error occurred here:

LIB CONNECT TO [DM (qlikcloud_qlikid_xxxxx)]

Not applicable
Author

Thank you Chad

-for Confirming the issue with Qlik Sense Desktop and Qlik Data Market connectivity.


I'm really surprised that there are no other references to this.


We have also opened a ticked with Qlik.



Not applicable
Author

The newest release 3.0 SR1 seems to resolve the issue.

Not applicable
Author

Hi Robert, thanks for the information.

Just tried with the new release 3.0.1, the data extraction from data market works fine now.

Cheers.

brucearmstrong
Partner
Partner

I just upgraded to 3.0 SR2 and it seems there's a regression.

The remote server returned an error: (400) Bad Request.: SQL SELECT "_dim_8olw", "_dim_8olx", "DateTime", "MEASURE=1" FROM fact:50e3 WHERE '8olw' = '' AND '8olx' = '' AND MEASURE = '1'

brucearmstrong
Partner
Partner

This was caused by an upgrade from 2.2 direct to 3.0 SR2.  An install repair cleaned it up.

Control Panel => Programs => Programs and Features => Qlik Sense Desktop => Change => Repair.