topic Re: tsapinfocubinput error: Next data package could not be requested (related to Z_TLDBI74_READ_INFOPROV) in Talend Studio

tsapinfocubinput error: Next data package could not be requested (related to Z_TLDBI74_READ_INFOPROV)

Anonymous — Sat, 16 Nov 2024 07:54:27 GMT

Dear talend support,

I am using Talend Studio 6.5.1 and have a very simple job based to extract data from SAP using tSAPInfoCubeInput . The job fails and produces the stacktrace below. Is it possible there is still a bug in this component?

STACKTRACE=

Exception in component tSAPInfoCubeInput_1 (infoobject)
[FATAL]: bridgestonedev.infoobject_0_1.infoobject - tSAPInfoCubeInput_1 Next data package could not be requested: SAPException@426b6a74 [
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>BIDCLNT001</SYSTEM></BAPIRET2>
,bapiName=Z_TLDBI74_READ_INFOPROV
]
java.lang.RuntimeException: Next data package could not be requested: SAPException@426b6a74 [
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>BIDCLNT001</SYSTEM></BAPIRET2>
java.lang.RuntimeException: Next data package could not be requested: SAPException@426b6a74 [
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>BIDCLNT001</SYSTEM></BAPIRET2>
,bapiName=Z_TLDBI74_READ_INFOPROV
]
at org.talend.sap.impl.bw.readable.SAPBWLayoutBasedTableData.nextRow(SAPBWLayoutBasedTableData.java:145)

Re: tsapinfocubinput error: Next data package could not be requested (related to Z_TLDBI74_READ_INFOPROV)

Anonymous — Thu, 26 Jul 2018 08:38:15 GMT

Hello,

Are you trying to extract large data set with InfoCube component?

Here exists a jira issue:https://jira.talendforge.org/browse/TDI-38138 and it has been fixed on 6.5.1, 7.0.1

Best regards

Sabrina

Re: tsapinfocubinput error: Next data package could not be requested (related to Z_TLDBI74_READ_INFOPROV)

Anonymous — Thu, 26 Jul 2018 08:53:36 GMT

Hi,

thanks for reply.

Indeed this looks a lot like my error. But I am using Studio 6.5.1-maybe it is not fixed? Also the BAPI used for me is Z_TLDBI74_READ_INFOPROV while in the JIRA ticket it is Z_TALEND_READ_INFOPROV.

The dataset is about 300k rows with 22 fields in them-this is not that large I would say.

Re: tsapinfocubinput error: Next data package could not be requested (related to Z_TLDBI74_READ_INFOPROV)

Anonymous — Thu, 26 Jul 2018 09:19:09 GMT

Hello,

Are you on InfoObject?

Have you tried to use tSAPInfoObjectInput to extract data from SAP. This component can retrieve InfoObject data from an SAP BW system.

Would you mind creating a case on talend support portal so that we can give you a remote assistance through support cycle with priority?

Best regards

Sabrina

Re: tsapinfocubinput error: Next data package could not be requested (related to Z_TLDBI74_READ_INFOPROV)

Anonymous — Thu, 26 Jul 2018 10:59:05 GMT

Hi,

thanks for reply!

this is an infocube-not an infoobject. TsapinfoobjectInput fails saying he can not find the infoobject (which is logical as it is an infocube).

I try to log on to https://www.talend.com/services/technical-support/ to log this case there but get the following error :

'Single Sign-On Error - We can't log you in. Check for an invalid assertion in the SAML Assertion Validator (available in Single Sign-On Settings) or check the login history for failed logins.'

Best.

Re: tsapinfocubinput error: Next data package could not be requested (related to Z_TLDBI74_READ_INFOPROV)

Anonymous — Fri, 27 Jul 2018 04:04:25 GMT

Hello,

The best place to start is this website - https://login.talend.com/support-login.php.

and please try to use other browser to see if it is OK with you. Feel free to let us know if you have login issue when you log a ticket to our Customer care organization.

Bestregards

Sabrina

Re: tsapinfocubinput error: Next data package could not be requested (related to Z_TLDBI74_READ_INFOPROV)

Anonymous — Fri, 27 Jul 2018 08:40:59 GMT

Thanks for feedback.

I have this issue both in chrome as in internet explorer. I have sent a mail with my credentials to 'customercare@talend.com' . I am not able to log a professional support ticket like this. Please advice on what to do. Screenshot attached of the error

errorloginsupport.png

Re: tsapinfocubinput error: Next data package could not be requested (related to Z_TLDBI74_READ_INFOPROV)

Anonymous — Fri, 27 Jul 2018 09:57:59 GMT

Hello,

Feel free to let us know if there is no response from customercare@talend.com.

Best regards

Sabrina

Re: tsapinfocubinput error: Next data package could not be requested (related to Z_TLDBI74_READ_INFOPROV)

Anonymous — Fri, 27 Jul 2018 10:00:52 GMT

Indeed , there is no response so far (was sent last businessday).

THanks for follow-up!

Re: tsapinfocubinput error: Next data package could not be requested (related to Z_TLDBI74_READ_INFOPROV)

Anonymous — Fri, 27 Jul 2018 10:54:10 GMT

Hello,

Would you mind sending me a private message with your credentials? We will reach out to support portal.

Best regards

Sabrina

Re: tsapinfocubinput error: Next data package could not be requested (related to Z_TLDBI74_READ_INFOPROV)

Anonymous — Tue, 31 Jul 2018 16:08:03 GMT

Hello,

We have sent an email to CustomerCare@talend.com with your issue and credentials.

Is there any response? Don't hesitate to post your issue here.

Best regards

Sabrina

Re: tsapinfocubinput error: Next data package could not be requested (related to Z_TLDBI74_READ_INFOPROV)

Anonymous — Tue, 24 Nov 2020 15:08:25 GMT

Increasing the memory for the table space on the sap side resolves this issue.

Re: tsapinfocubinput error: Next data package could not be requested (related to Z_TLDBI74_READ_INFOPROV)

SebastienA — Thu, 17 Oct 2024 09:54:53 GMT

Hi,

I have exactly the same error retrieving data from a TSAPInfocubeInput.
Can you tell me which SAP parameter has been increased on the SAP side, please ?

We already tried to increase these 4 SAP parameters to 6Go (large enough !) :

abap/heap_area_dia
abap/heap_area_nondia
ztta/roll_extension_dia
ztta/roll_extension_nondia

But it is still failing with the same error : Next data package could not be requested

Help would be much appreciated !
Thanks you

Re: tsapinfocubinput error: Next data package could not be requested (related to Z_TLDBI74_READ_INFOPROV)

ABAT — Tue, 06 May 2025 10:27:03 GMT

Can anyone help me with the parameters which needs to be amended in SAP?

Re: tsapinfocubinput error: Next data package could not be requested (related to Z_TLDBI74_READ_INFOPROV)

jackjoxon — Mon, 23 Jun 2025 06:49:26 GMT

You're hitting an INVALID_CURSOR error with tSAPInfoCubeInput, likely due to a backend issue in the custom BAPI (Z_TLDBI74_READ_INFOPROV). Try reducing the data package size, check BAPI stability, and test with a standard extractor. Also, updating Talend might help.

Sometimes SAP errors are trickier than decoding pure desi foods—but a few tweaks should fix it!