topic Re: TSaptableinput component filter with subquery in Talend Studio

TSaptableinput component filter with subquery

Anonymous — Sat, 16 Nov 2024 04:28:09 GMT

Hi,

I am using Talend Enterprise edition.

I would like to retrieve records from SAP table VBRP. With the business requirement I need to apply a filter like a sub query as per the attached image.

I get the below error.

Can you please help?

Cheers!

Gatha

Re: TSaptableinput component filter with subquery

Anonymous — Fri, 04 Oct 2019 19:31:18 GMT

Hi Gatha,

Is it working fine when you are running the query with filter conditions as values? Are you getting the error only when sub query is added?

I do not have a personal SAP environment for a quick verification. So I would recommend to raise a Support case in parallel as SAP environments may not be readily available for all community members to cross check the issue.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: TSaptableinput component filter with subquery

Anonymous — Mon, 07 Oct 2019 15:21:15 GMT

Hi Nikil,

The individual values are working fine

Only the sub query is giving this error message below.

SAPException@6d367020 [
errorCode=12
,errorGroup=104
,errorKey=JCO_ERROR_SYSTEM_FAILURE
,errorMessage=A condition specified at runtime has an unexpected format.
,errorMessageClass=00
,errorMessageNumber=341
,errorMessageText=SAPSQL_WHERE_ILLEGAL_VALUE
,errorMessageType=X
,bapiName=Z_TALEND_READ_TABLE
,tableName=VBRP
]

Cheers!

Gatha

Re: TSaptableinput component filter with subquery

Anonymous — Tue, 08 Oct 2019 12:16:20 GMT

Hi Nikil,

We raised it to Talend yesterday.

I have found ELT components are available for SAP components, I try to use it, so that I can join the 2 tables at source and get only the valid records out of SAP.

in the tELTSAPMap component, its asking for some FTP details, if I leave them null and execute the job, its failing with the below error.

I checked the documentation, It is not clear why FTP is required for SAP ELT

Execution failed : org.talend.commons.exception.PersistenceException: java.lang.NullPointerException
[java.lang.NullPointerException]

Can you please help me with that?

Cheers!

Gatha

SAP_ELT_MAP.png

Re: TSaptableinput component filter with subquery

SRoux — Tue, 01 Sep 2020 08:28:19 GMT

Hi,

On ELT call a file result will be created locally to SAP ERP filesystem. And in the same time your Talend job will download the file via FTP. Indeed the request is executed locally to SAP server (where clause, join and so on) for performance consideration.

On my side I don't have any ftp server on my SAP ERP machine and I wonder if it is possible to act without ftp server, just generate the file on SAP Server. Presently I get connection error. If anyone gets a workaround please tell me what.

Cheers

Stephane