Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
acumenjonfoote
New Contributor II

General Error Select from Cube

I have a client that has been running a connection to a Dynamics AX Cube. It has been working fine up until now, suddenly over night it has stopped working.

It seems to be connecting to the cube ok through an OLEBDB connection, but it fails with a 'General Error' once it gets to the Select statement.

We have simplified the script to look like this.

LIB CONNECT TO 'Dynamics Ax - Cubes';

LOAD

  "[Measures].[Ending amount]" as [Ending amount];

SELECT

  [Measures].[Ending amount]

   

FROM [Inventory value cube]

;

Does anyone have any idea why it has suddenly stopped working.

P.S we are using the MDX generator to create the script and it is connecting and load the data fine.

Thanks in advance for any help.

Cheers

Jon

Tags (2)
1 Reply
acumenjonfoote
New Contributor II

Re: General Error Select from Cube

I found this error by using the SQL Profile, which occurs when Qlik queries the cubes:

  XML for Analysis parser: The CurrentCatalog XML/A property was not specified.