SAP info cube extraction error

Anonymous — Fri, 13 Oct 2017 11:47:42 GMT

Hi Team

I am trying to connect to SAP info cube and pull the lager volume of data

I facing the following issue,Can you please guide me how to resolve.

Starting job Extract_SAP_BW at 15:50 13/10/2017.

[statistics] connecting to socket on port 3584

[statistics] connected

Exception in component tSAPInfoCubeInput_2 (Extract_SAP_BW)

java.lang.RuntimeException: Next data package could not be requested: SAPException@2f953efd [

errorCode=40

,errorGroup=0

,errorKey=null

,errorMessage=<BAPIRET2><TYPE>E</TYPE><ID>DBMAN</ID><NUMBER>257</NUMBER><MESSAGE>SQL Error: INVALID_CURSOR</MESSAGE><LOG_NO></LOG_NO><LOG_MSG_NO>000000</LOG_MSG_NO><MESSAGE_V1>INVALID_CURSOR</MESSAGE_V1><MESSAGE_V2></MESSAGE_V2><MESSAGE_V3></MESSAGE_V3><MESSAGE_V4></MESSAGE_V4><PARAMETER></PARAMETER><ROW>0</ROW><FIELD></FIELD><SYSTEM>DB2CLNT100</SYSTEM></BAPIRET2>

,bapiName=Z_TALEND_READ_INFOPROV

]

at org.talend.sap.impl.bw.readable.SAPBWLayoutBasedTableData.nextRow(SAPBWLayoutBasedTableData.java:144)

at imss.extract_sap_bw_0_1.Extract_SAP_BW.tSAPInfoCubeInput_2Process(Extract_SAP_BW.java:3776)

at imss.extract_sap_bw_0_1.Extract_SAP_BW.runJobInTOS(Extract_SAP_BW.java:4117)

at imss.extract_sap_bw_0_1.Extract_SAP_BW.main(Extract_SAP_BW.java:3936)

[FATAL]: imss.extract_sap_bw_0_1.Extract_SAP_BW - tSAPInfoCubeInput_2 Next data package could not be requested: SAPException@2f953efd [

errorCode=40

,errorGroup=0

,errorKey=null

,bapiName=Z_TALEND_READ_INFOPROV

]

java.lang.RuntimeException: Next data package could not be requested: SAPException@2f953efd [

errorCode=40

,errorGroup=0

,errorKey=null

,bapiName=Z_TALEND_READ_INFOPROV

]

at org.talend.sap.impl.bw.readable.SAPBWLayoutBasedTableData.nextRow(SAPBWLayoutBasedTableData.java:144)

at imss.extract_sap_bw_0_1.Extract_SAP_BW.tSAPInfoCubeInput_2Process(Extract_SAP_BW.java:3776)

at imss.extract_sap_bw_0_1.Extract_SAP_BW.runJobInTOS(Extract_SAP_BW.java:4117)

at imss.extract_sap_bw_0_1.Extract_SAP_BW.main(Extract_SAP_BW.java:3936)

[statistics] disconnected

Job Extract_SAP_BW ended at 15:53 13/10/2017. [exit code=1]

Re: SAP info cube extraction error

Anonymous — Mon, 16 Oct 2017 09:46:34 GMT

Hi,

You are pulling the lager volume of data? What's the size (> 1 mio. rows)?

It seems that the current implementation reaches its limits, because all the extracted data is hold in the main memory of the SAP system and client (Talend Job).

Best regards

Sabrina

Re: SAP info cube extraction error

Anonymous — Fri, 27 Oct 2017 14:03:51 GMT

Hi,

What would be the solution to process large amount of data?

If it is memory issue then would increasing the JVM parameters of the job resolve this?

Or do we have any other workaround?

Thanks

Re: SAP info cube extraction error

Bira1 — Thu, 24 Jan 2019 12:38:08 GMT

Hi @SaranyaKatakam ,

I hope all is well.

I'm having the same problem trying to load SAP data.

Did you get any solutions?

Thanks.

Re: SAP info cube extraction error

jayapal1984 — Thu, 10 Sep 2020 16:15:22 GMT

I am facing the same issue....did anyone find a solution for this ?

Re: SAP info cube extraction error

Anonymous — Mon, 14 Sep 2020 07:39:40 GMT

Hello,

On which talend build version you got this issue?

Here exists a jira issue: https://jira.talendforge.org/browse/TDI-38138

It is fixed in 6.5.1, 7.0.1

Best regards

Sabrina

Re: SAP info cube extraction error

Prakhar1 — Tue, 27 Apr 2021 08:36:55 GMT

The solution for this topic is that you have to use the FTP options in the tSAPInfocubeInput component.

You have to provide the FTP details for the system you are trying to read the Infocube.

topic Re: SAP info cube extraction error in Talend Studio

SAP info cube extraction error

Re: SAP info cube extraction error

Re: SAP info cube extraction error

Re: SAP info cube extraction error

Re: SAP info cube extraction error

Re: SAP info cube extraction error

Re: SAP info cube extraction error