topic Re: Talend Studio - error retrieving SAP BW metadata in Talend Studio

Talend Studio - error retrieving SAP BW metadata

RMotta2408 — Mon, 08 Jul 2024 14:43:15 GMT

Hello everyone,

I'm trying to retrieve a table using SAP BW Table Wizard.
After choosing InfoObject and choosing the tables I want, I get the following error:

What must I do to overcome this problem?

Thank you,

Rui

Re: Talend Studio - error retrieving SAP BW metadata

Xiaodi_Shi — Tue, 09 Jul 2024 08:42:40 GMT

Hello,

Please make sure that the SAP BW source system is not empty and SAP service account basic permission setting is OK with you.

Here is SAP ERP authorizations for Talend

https://help.talend.com/en-US/components/8.0/sap/sap-erp-authorizations-for-talend

Best regards

Sabrina

Re: Talend Studio - error retrieving SAP BW metadata

RMotta2408 — Tue, 09 Jul 2024 12:49:28 GMT

Hi Sabrina,

Thanks for replying.
It's only certain tables I'm unable to access.
I have accessed many of the others I needed. But these are giving me that message.
Could these tables be corrupted or inaccessible due to a lack of permission on my side?

I found this site: https://help.talend.com/en-US/studio-user-guide/8.0-R2024-05/retrieving-sap-bw-objects-metadata

And in it, I found this:
For the InfoObject type objects, only the Attribute, Hierarchy and Text information can be extracted, and the number of the columns for each type of information is displayed in the Column Number field with the format A[X] H[Y] T[Z], where X, Y and Z represent the number of the columns for the Attribute, Hierarchy and Text information respectively.

In my image, I see the values of X, Y and Z are 0 (zero). Could that mean problems with the table?

Rui

Re: Talend Studio - error retrieving SAP BW metadata

Xiaodi_Shi — Wed, 10 Jul 2024 01:18:22 GMT

Hello,

Does this issue reproduce on certain tables only? Have you tried to import all the various lists of several objects (InfoCube, ADSO, DSO, ..) with the '*' wildcard?

Best regards

Sabrina

Re: Talend Studio - error retrieving SAP BW metadata

RMotta2408 — Wed, 10 Jul 2024 09:31:42 GMT

Hi Sabrina,

Yes, the issue reproduces for certain tables only.

I have listed all the tables in DataSource, DataStoreObjects, InfoCube and InfoObjects.
But the issue arises when I want to import certain tables.

Thank you,

Rui