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: 
AcumenJonFoote
Partner - Contributor II
Partner - 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

1 Reply
AcumenJonFoote
Partner - Contributor II
Partner - Contributor II
Author

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.