Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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)

Labels (4)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

14 Replies
Anonymous
Not applicable
Author

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

 

Anonymous
Not applicable
Author

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.

 

 

Anonymous
Not applicable
Author

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

 

Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

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

 

Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

Hello,

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

Best regards

Sabrina

Anonymous
Not applicable
Author

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

THanks for follow-up!

Anonymous
Not applicable
Author

Hello,

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

Best regards

Sabrina