I am using teiid odata and ws libraries to for making a SAP Odata connector. I am able to create a connection and get all the properties for a SAP entity. But while trying to fetch the records I get the following exception

Do you know if SAP service is OData V2 or V4? if SAP service is V2 there is separate translator in Teiid for that. It is by name "sap-gateway". The translator you are using is OData V4, I can't say that I have tested this SAP, as at the time this was developed there was no SAP V4 service.

I am using the same dependencies as said above. Also I am using translator-odata in connectors. And the specific translator in that which I am using is SAPNWODataExecutionFactory, even I tried SAPODataExecutionFactory too (there is no diff as previous extends this one).

I checked on SAP demo systems for the Odata services, even they are on the V2.

it is a different code base, it MUST be a different exception stack and can not be same. If you still seeing exactly same then you have not configured correctly. If you did please post the new exception.

Is above SAP service a public service, that I can hit to reproduce the issue? it seems to be asking for user/password. Is there a place I can register to access this service? Or if there is way you can attach the $metadata file, then also I can debug to see what is the issue?

You are consuming from SAP OData V2 service, and querying over OData V2 or V4 on Teiid. The issue above, what I can tell you is, you are trying to execute the OData query you formed for direct SAP OData interface on Teiid. That will not work always. Like in this case the the Address in the original SAP service is a complex property of the BusinessParterSet, when that metadata is brought into Teiid (which is like relational database engine) it does not handle complex objects, so it has to either inline the properties of the "address" complex object or it has to define as a separate table with defined relationships. So, that is what Teiid does, in this case it inlines "address" specific columns into BusinessParterSet. Another reason we do this is, on Teiid we have to be able to also able to

select * from BusinessPartnerSet

results in tabular format, Address as a complex object (blob/clob) does not convey the right decipher of the information fully. so try like

Let's please keep the topic focused on one topic. You need to show me the error on the SAP service you provided for me to recreate to provide any suggestions. My previous comment was based on the your query you submitted.