General Error Select from Cube

AcumenJonFoote — Wed, 25 Jan 2017 01:16:09 GMT

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

Re: General Error Select from Cube

AcumenJonFoote — Thu, 26 Jan 2017 01:59:24 GMT

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.

topic General Error Select from Cube in App Development

General Error Select from Cube

Re: General Error Select from Cube