Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]
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
Sabrina,
we are trying to connect to SAP info cube and Number of records in source system is 1,126,530.
Thanks,
T.Anusha