Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to fetch data in an Agentry project from an Oracle DB and SMP 3.0?

Hi

I am trying to get information from an Oracle database on a project in Agentry, but I am confused as to perform this test.

For one, check that you can define the backend in the SMP with the Oracle client installed for the tnsnames.

On the other side, and I think the best option is to use OData.

However, in the case of OData, I use the SMP Gateway Management 3.0 to connect to the database, which was successful.

Now I have the details of how to define the service that allows me to operate Agentry data using the Eclipse Connector Studio DSE and that allows me to generate the Steps required for transactions in Agentry.

When generating a service that uses the connection Gateway Management, the log sends an error in the method org.apache.olingo.odata2.api.edm.provider.EdmProvider.getSchemas ().

The log information is next:

An exception of type 'NullPointerException' occurred. |

2015 01 06 12:46:46#0-600#ERROR#com.sap.gateway.core.api.provider.model.CacheModelProvider##anonymous#http-bio-8083-exec-9###while trying to invoke the method org.apache.olingo.odata2.api.edm.provider.EdmProvider.getSchemas() of a null object loaded from field com.sap.gateway.core.ip.provider.model.CamelModelProvider.edmProvider of an object loaded from local variable 'this' java.lang.NullPointerException: while trying to invoke the method org.apache.olingo.odata2.api.edm.provider.EdmProvider.getSchemas() of a null object loaded from field com.sap.gateway.core.ip.provider.model.CamelModelProvider.edmProvider of an object loaded from local variable 'this'

I hope you can help me.

regards

Former Member
replied

Yes, no matter what type of server (Windows or Linux) you will need an Oracle client on the server to connect to the backend.

I would start with the Oracle Instant Client for Linux and follow the Oracle installation instructions.

--Bill

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question