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

[JBBS]

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)

[xdshi]

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

[JBBS]

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.

[xdshi]

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

[JBBS]

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.

[xdshi]

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

[JBBS]

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

[xdshi]

Hello,

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

Best regards

Sabrina

[JBBS]

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

THanks for follow-up!

[xdshi]

Hello,

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

Best regards

Sabrina

[xdshi]

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