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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
anusha_t
Contributor
Contributor

Problem while connecting to TSAPinfoCubeInput

Dear talend support,

I am using Talend Studio 6.5.1 and  I am trying to  extract data from SAP using  tSAPInfoCubeInput . The job fails  with following exception .

 

Starting job JB_POC_Load_Data_From_D40_To_Azure_Blob at 10:45 30/12/2019.

[statistics] connecting to socket on port 3522
[statistics] connected
Exception in component tSAPInfoCubeInput_2 (JB_POC_Load_Data_From_D40_To_Azure_Blob)
java.lang.RuntimeException: Next data package could not be requested: SAPException@4461c7e3 [
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>D40CLNT500</SYSTEM></BAPIRET2>
,bapiName=Z_TLDBI74_READ_INFOPROV
]
at org.talend.sap.impl.bw.readable.SAPBWLayoutBasedTableData.nextRow(SAPBWLayoutBasedTableData.java:145)
at local_fig.jb_poc_load_data_from_d40_to_azure_blob_0_1.JB_POC_Load_Data_From_D40_To_Azure_Blob.tSAPInfoCubeInput_2Process(JB_POC_Load_Data_From_D40_To_Azure_Blob.java:2051)
at local_fig.jb_poc_load_data_from_d40_to_azure_blob_0_1.JB_POC_Load_Data_From_D40_To_Azure_Blob.runJobInTOS(JB_POC_Load_Data_From_D40_To_Azure_Blob.java:2382)
[FATAL]: local_fig.jb_poc_load_data_from_d40_to_azure_blob_0_1.JB_POC_Load_Data_From_D40_To_Azure_Blob - tSAPInfoCubeInput_2 Next data package could not be requested: SAPException@4461c7e3 [
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>D40CLNT500</SYSTEM></BAPIRET2>
,bapiName=Z_TLDBI74_READ_INFOPROV
]
java.lang.RuntimeException: Next data package could not be requested: SAPException@4461c7e3 [
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>D40CLNT500</SYSTEM></BAPIRET2>
at local_fig.jb_poc_load_data_from_d40_to_azure_blob_0_1.JB_POC_Load_Data_From_D40_To_Azure_Blob.main(JB_POC_Load_Data_From_D40_To_Azure_Blob.java:2208)
,bapiName=Z_TLDBI74_READ_INFOPROV
]
at org.talend.sap.impl.bw.readable.SAPBWLayoutBasedTableData.nextRow(SAPBWLayoutBasedTableData.java:145)
at local_fig.jb_poc_load_data_from_d40_to_azure_blob_0_1.JB_POC_Load_Data_From_D40_To_Azure_Blob.tSAPInfoCubeInput_2Process(JB_POC_Load_Data_From_D40_To_Azure_Blob.java:2051)
at local_fig.jb_poc_load_data_from_d40_to_azure_blob_0_1.JB_POC_Load_Data_From_D40_To_Azure_Blob.runJobInTOS(JB_POC_Load_Data_From_D40_To_Azure_Blob.java:2382)
at local_fig.jb_poc_load_data_from_d40_to_azure_blob_0_1.JB_POC_Load_Data_From_D40_To_Azure_Blob.main(JB_POC_Load_Data_From_D40_To_Azure_Blob.java:2208)
[statistics] disconnected
Job JB_POC_Load_Data_From_D40_To_Azure_Blob ended at 10:45 30/12/2019. [exit code=1]

Labels (2)
2 Replies
Anonymous
Not applicable

Hello,

Are you trying to connect to SAP info cube and pull the lager volume of data? What's the size (> 1 mio. rows)?

Best regards

Sabrina

anusha_t
Contributor
Contributor
Author

Sabrina,

we are trying to connect to SAP info cube and Number of records in source system is 1,126,530.

 

Thanks,

T.Anusha