cancel
Showing results for 
Search instead for 
Did you mean: 

SAP NCO 2.0 RFC_READ_TABLE returns empty RfcAbapException

dmko
Explorer
0 Kudos

Hi all,

I have a very weird situation here, on the customer side one of the tables just stopped return data when we do read it by RFC_READ_TABLE. The table is V_IBIN_SYVAL, what we are doing is just retrieve ATINN values from the table by IN_RECNO ids. So where statement is super simple like IN_RECNO IN ( 051MWa057jQxnYf9m1oEBm, 051MWa057jQxnYhfQYAEBm, 051MWa057jQxnYilPcUEBm, 051MWa057jQxnYymFixEG0, 051MWa057jQxnY{HReCEG0 )
We also do split by separate options to meet 512 max symbols requirement.

The most interesting is I tried to execute a query without specific options and no_data=X to get fields collection only and eliminate other possible issues and it also failed with an empty RfcAbapException.
It's just start happen suddenly, the code has not been changed from 2011.


Also we are still using the old .Net SapConnector 2.0.0.26 for this legacy project.


Other tables like MARA, for example, returning data properly using same code. Can you please advice what can be the issue?

RFC_DB_FLDTable fields = new RFC_DB_FLDTable();
RFC_DB_OPTTable options = new RFC_DB_OPTTable();
TAB512Table datatable = new TAB512Table();
proxy.Rfc_Read_Table("|", "X", "V_IBIN_SYVAL", 0, 0, ref datatable, ref fields, ref options);
Sandra_Rossi
Active Contributor
0 Kudos
Possibly one line is returned which contains invalid data in one column (of database)?
Sandra_Rossi
Active Contributor
Look directly into the database e.g. one DATS contains space, one NUMC contains non-numeric, etc.
View Entire Topic
dmko
Explorer
0 Kudos

Hi Sandra,

Thanks for the reply! 

How I can figure out that data is invalid, is there any check mechanizm etc. how I can get this invalid value?

Sorry, I'm quite new in SAP, just wondering what is invalid data here? 🙂 

Ulrich_Schmidt
Product and Topic Expert
Product and Topic Expert
0 Kudos
Hello dmko, you probably wanted to add a comment to the discussion above, and not an answer to your own question?
dmko
Explorer
0 Kudos
yes, sorry 😄