Problem while connecting to TSAPinfoCubeInput

anusha_t — Mon, 30 Dec 2019 05:18:25 GMT

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]

Re: Problem while connecting to TSAPinfoCubeInput

Anonymous — Mon, 06 Jan 2020 06:51:09 GMT

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

Re: Problem while connecting to TSAPinfoCubeInput

anusha_t — Mon, 06 Jan 2020 08:09:22 GMT

Sabrina,

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

Thanks,

T.Anusha

topic Re: Problem while connecting to TSAPinfoCubeInput in Talend Studio

Problem while connecting to TSAPinfoCubeInput

Re: Problem while connecting to TSAPinfoCubeInput

Re: Problem while connecting to TSAPinfoCubeInput