[Data Factory] SAP Table Connector cannot find FM in SAP ECC 6

Question

[Data Factory] SAP Table Connector cannot find FM in SAP ECC 6

Nestor 46

Our version of SAP (ECC6 EHP 0) does not have the FM ZRFC_READ_TABLE2. We created a copy and called it ZFM_INTERNAL_ZRFC_READ_TABLE2; however, when trying to use it from ADF with the SAP connector (version 3.0.23 64bit) we get an error.
Type: SAP.Middleware.Connector.RfcInvalidParameterException
Message: Element QUERY_TABLE of container metadata XXXXX/ZFM_INTERNAL_ZRFC_READ_TABLE2 unknown.

I posted this question in the GitHub feedback page (link) and was told this is a better forum to answer this type of questions.

The FM has the QUERY_TABLE parameter and it has been tested to be working (using Python scripts).
Screenshots of the configuration and tests performed.

Any ideas as to where the problem lies?

HarithaMaddi-MSFT 10,146 Reputation points

2020-09-16T09:38:51.007+00:00

Hi @Nestor ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

Can you also share the pipeline run id and region of data factory that failed with this issue to investigate further. I will work with product team and will get back to you with more insights once we receive pipeline run id.

Thanks for your patience.
Carlos-Enrique de las Marinas Rodríguez 1 Reputation point

2020-09-17T09:37:29.59+00:00
Hi @HarithaMaddi-MSFT ,

The pipeline run ID is: 8c291402-bd7a-4614-84df-e4ab72662322

The data factory information is:

Location: West Europe

Resource group: EUW-RG-GDP-EMEA-DEV

Please, let me know if any other information is necessary.
Thanks.
HarithaMaddi-MSFT 10,146 Reputation points

2020-09-17T13:19:16.14+00:00

Thanks @Carlos-Enrique de las Marinas Rodríguez for sharing the details. I will work with Internal teams and will get back to you for further insights.

Thanks for your patience!
Carlos-Enrique de las Marinas Rodríguez 1 Reputation point

2020-09-21T09:35:45.367+00:00

Hi @HarithaMaddi-MSFT ,

Could you please share information about the status of this topic?

Thanks in advance for your feedback!
HarithaMaddi-MSFT 10,146 Reputation points

2020-09-21T09:44:30.177+00:00

Thanks @Carlos-Enrique de las Marinas Rodríguez for the query. I am working with product team to identify the root cause and awaiting their response. I will keep you updated once I receive insights from them.

Thanks for your patience again!
HarithaMaddi-MSFT 10,146 Reputation points

2020-09-21T13:47:45.053+00:00

Hi @Carlos-Enrique de las Marinas Rodríguez , Product team suggested to get the FIELDS table first to get the schema, then try to parse the data using the schema. Could you please return schemas in the Fields table and let us know if issue persists.

Thanks for your support!
Carlos-Enrique de las Marinas Rodríguez 1 Reputation point

2020-09-21T17:02:26.627+00:00

Hi @HarithaMaddi-MSFT ,

There is a specific parameter in the function module to ask only for the FIELDS information. The way to do it in SAP (using SE37) is:

If we set the NO_DATA parameter to any character, we are requesting only the schema (FIELDS) and no data is retrieved.

I do not see any parameter in the pipeline definition equivalent to the NO_DATA parameter in SAP. What I have done is to instantiate the Row count parameter to 0, but the component reports the same error.

Accepted answer

1 additional answer

Your answer

HarithaMaddi-MSFT 10,146 Reputation points

2020-09-16T09:38:51.007+00:00

Hi @Nestor ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

Can you also share the pipeline run id and region of data factory that failed with this issue to investigate further. I will work with product team and will get back to you with more insights once we receive pipeline run id.

Thanks for your patience.
Carlos-Enrique de las Marinas Rodríguez 1 Reputation point

2020-09-17T09:37:29.59+00:00

Hi @HarithaMaddi-MSFT ,

The pipeline run ID is: 8c291402-bd7a-4614-84df-e4ab72662322

The data factory information is:

Location: West Europe

Resource group: EUW-RG-GDP-EMEA-DEV

Please, let me know if any other information is necessary.
Thanks.
HarithaMaddi-MSFT 10,146 Reputation points

2020-09-17T13:19:16.14+00:00

Thanks @Carlos-Enrique de las Marinas Rodríguez for sharing the details. I will work with Internal teams and will get back to you for further insights.

Thanks for your patience!
Carlos-Enrique de las Marinas Rodríguez 1 Reputation point

2020-09-21T09:35:45.367+00:00

Hi @HarithaMaddi-MSFT ,

Could you please share information about the status of this topic?

Thanks in advance for your feedback!
HarithaMaddi-MSFT 10,146 Reputation points

2020-09-21T09:44:30.177+00:00

Thanks @Carlos-Enrique de las Marinas Rodríguez for the query. I am working with product team to identify the root cause and awaiting their response. I will keep you updated once I receive insights from them.

Thanks for your patience again!
HarithaMaddi-MSFT 10,146 Reputation points

2020-09-21T13:47:45.053+00:00

Hi @Carlos-Enrique de las Marinas Rodríguez , Product team suggested to get the FIELDS table first to get the schema, then try to parse the data using the schema. Could you please return schemas in the Fields table and let us know if issue persists.

Thanks for your support!
Carlos-Enrique de las Marinas Rodríguez 1 Reputation point

2020-09-21T17:02:26.627+00:00

Hi @HarithaMaddi-MSFT ,

There is a specific parameter in the function module to ask only for the FIELDS information. The way to do it in SAP (using SE37) is:

If we set the NO_DATA parameter to any character, we are requesting only the schema (FIELDS) and no data is retrieved.

I do not see any parameter in the pipeline definition equivalent to the NO_DATA parameter in SAP. What I have done is to instantiate the Row count parameter to 0, but the component reports the same error.

Answer 1

HarithaMaddi-MSFT 10,146

Thanks @Nestor and @Carlos-Enrique de las Marinas Rodríguez for sharing the details. I discussed with the Product team and they suggested that currently there is no parameter in Azure Data Factory(ADF) equivalent to "NO_DATA" parameter in SAP. And, as per our discussion, the above issue is resolved if we are specifying function module alone without the function group.

I would recommend you to submit an idea in feedback forum which is closely monitored by the Data Factory product team and will be implemented in future releases.

Carlos-Enrique de las Marinas Rodríguez 1 Reputation point

2020-09-22T10:11:49.573+00:00

Thanks @HarithaMaddi-MSFT for the answer.
I am mentioning also @Nestor to keep him informed.

The function module can work perfectly with the NO_DATA parameter marked as "X" or empty. My comment was to illustrate how to retrieve only the schema using the SE37 transaction and how I proceeded in ADF. In fact, you can see at the beginning of this question the provided example works with NO_DATA empty.
The function module is a copy of the RFC_READ_TABLE2 with another name, thus is compliant with the requirements for using the SAP Table connector component.

I am at your disposal for any additional information you or your team could need to diagnose and solve the issue.
HarithaMaddi-MSFT 10,146 Reputation points

2020-09-22T10:28:36.457+00:00

Thanks @Carlos-Enrique de las Marinas Rodríguez for clarifying this. Please send out a mail to AzCommunity[at]microsoft[dot]com with subject "Attn: Haritha - SAP Table Connector cannot find FM in SAP ECC 6" and we will work with you to investigate the issue along with the product team.
HarithaMaddi-MSFT 10,146 Reputation points

2020-09-29T09:17:33.717+00:00

Thanks @Carlos-Enrique de las Marinas Rodríguez and @Nestor for the time in investigating the issue and for sharing valuable feedback on the product. As the original issue is resolved, please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
HarithaMaddi-MSFT 10,146 Reputation points

2020-10-06T08:55:49.797+00:00

Thanks @Carlos-Enrique de las Marinas Rodríguez and @Nestor for the time in investigating the issue and for sharing valuable feedback on the product. As the original issue is resolved, following up to check if you can click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

Answer 2

Abhilash E 0

@Nestor Did you get any other methods to accomplish it?

Share via

[Data Factory] SAP Table Connector cannot find FM in SAP ECC 6

1 additional answer

Your answer