Error when executing Integration Gateway service
I created a service on IGW to expose an oracle db as odata but i'm getting the following error when i call it from the browser:
<error><code/><message xml:lang="en-US">An exception occurred.</message></error>
The service itself is working. Its destination is reachable from the IGW's management cockpit test, and its url returns the service description when executed from the browser. The error happens when i try to access an entity within the service, as in:
I checked SMP's logs and found two possibly related error entries. The first is from execution of my custom script. I had to create a script to map the entity set names to actual table names in the database (their full name: schema + table name).
2015 04 07 15:41:29#0-300#ERROR#com.sap.gateway.ip.core.customdev.processor.IGWScriptProcessor##anonymous#http-bio-8083-exec-5###[Gateway][TECHNICAL][TechnicalError]:This is first log
2015 04 07 15:41:29#0-300#ERROR#com.sap.gateway.core.odata4sap.ODataErrorCallbackImpl##anonymous#http-bio-8083-exec-5###handleError(): failed to serve request for URI https://smp3url:8083/gateway/odata/SIST/ODATATEST;v=1/Solicitacao, message = An exception occurred.
Joao Franco replied
I found out what was the issue.
The type of the properties in my entity were not compatible with the type of the database columns. For one we use oracle's number for our keys, but i was using Edm.int32 in the odata model. The compatible type is acutally Edm.decimal as number is a floating point.
Before i close this discussion, do we have any document showing the compatibility between edm types with the different datasources (oracledb perhaps hehe)?