Connector reply error: ErrorSource

rchasser — Thu, 23 Aug 2018 09:38:27 GMT

Hi Guys,

I moved my script from QlikView to QlikSense and I have this error message when running it.

I have wrote a generic query and make a loop on several cube hosted in the same server. It is really weird because it works fine for some cube and screw for others ... In QlikView, no error at all for all the cubes ...

this is my query:

LOAD *;

SELECT

Non Empty {

[Measures].[VENTES UN (000)],

[Measures].[VENTES CA (000)],

[Measures].[ACHATS UN (000)],

[Measures].[STOCKS UN (000)],

[Measures].[AMM UN-PHIE A],

[Measures].[VMM UN-PHIE V],

[Measures].[SMM UN-PHIE S],

[Measures].[PRIX],

[Measures].[DUREE APPRO MOIS],

[Measures].[DN-A],

[Measures].[DN-V],

[Measures].[DN-S],

[Measures].[DV-A],

[Measures].[DV-V],

[Measures].[DV-S]

} On Columns,

Non Empty ( AddCalculatedMembers ( {Descendants([GEOGRAPHY].[GEO].[All GEOGRAPHY.GEO],[GEOGRAPHY].[GEO].[All GEOGRAPHY.GEO].Level,AFTER)} ) *

( AddCalculatedMembers ( {Descendants([PRODUCT].[PRO].[All PRODUCT.PRO],[PRODUCT].[PRO].[All PRODUCT.PRO].Level,AFTER)} ) *

{

[PERIOD].[MAT - Relative Half Year - Relative Quarter - Relative Month].[Relative Month].AllMembers

} ) )

Dimension Properties

[PERIOD].[MAT - Relative Half Year - Relative Quarter - Relative Month].[Relative Month].[MEMBER_VALUE],

[PRODUCT].[PRO].[MEMBER_VALUE],

[PRODUCT].[PRO].[MEMBER_UNIQUE_NAME],

[PRODUCT].[PRO].[PARENT_UNIQUE_NAME],

[GEOGRAPHY].[GEO].[MEMBER_VALUE],

[GEOGRAPHY].[GEO].[MEMBER_UNIQUE_NAME],

[GEOGRAPHY].[GEO].[PARENT_UNIQUE_NAME]

On Rows

FROM [$(vL.Cube)] CELL PROPERTIES value

;

And the full error message:

L'erreur suivante s'est produite:

Connector reply error: ErrorSource: Fournisseur Microsoft OLE DB pour SQL Server 2017 Analysis Services., ErrorMsg: Le cube PTR_FR_M_IMSINTERNE_C00999-21446 n'existe pas ou n'a pas été traité.

Emplacement de l'erreur:

?

Les données n'ont pas été chargées. Corrigez l'erreur, puis recommencez l'opération de chargement.

Let me know if you want further information.

Thanks.

topic Connector reply error: ErrorSource in Connectivity & Data Prep

Connector reply error: ErrorSource