Symptom
- Customer is using MS SQL Server endpoint with the views/tables exposed as entities using a JDBC driver via Integration Gateway.
The tables use identity columns(auto-incremented server generated keys) as the primary key.
The primary key is getting used for both read and write operations. When a write operation is attempted it is causing the error shown below in the SMP server log:
2.0#2017-05-25 02:13:36 PM#DEBUG#RequestResponse#500##Client Request Trace#1495736015712177#d054d3d2-4132-11e7-8000-8bebe2d42877#com.cintas.rentalcopilot#com.sap.mobile.platform.server.online.filter.application.AbstractClientFilter:doFilter#testcopilot#######304#####<< Status Code: 500#
2.0#2017-05-25 02:13:36 PM#ERROR#RequestResponse#200##Integration Gateway#1495736015712160#d054d3d2-4132-11e7-8000-8bebe2d42877#com.cintas.rentalcopilot#com.sap.it.commons.logging.slf4j.internal.LoggerSlf4j:log#testcopilot#######304#####[Gateway][BUSINESS][CreateEntityFailed]:Data Provider - createEntity: service = ROUTEBOOK_SERVICES_COPILOT , entity set = tblCustomerSiteDetailAttributesInfo , request content type = application/json;charset=utf-8 , message = com.sap.gateway.core.api.exception.IGWException: while trying to invoke the methodjava.lang.Object.toString() of a null object returned from java.util.Map$Entry.getValue() : Transaction ID: 16991413-580a-4273-87f8-cb197533bc85#
#2.0#2017-05-25 02:13:36 PM#ERROR#RequestResponse#200##Integration Gateway#1495736015712159#d054d3d2-4132-11e7-8000-8bebe2d42877#com.cintas.rentalcopilot#com.sap.gateway.core.ip.provider.data.CamelDataProvider:processCamelRoute#testcopilot#######304#####
Stacktrace
Read more...
Environment
- SMP 3.0 server SP10
- Intergration Gateway (IGW)
- MS SQL Server
Product
SAP Mobile Platform 3.0
Keywords
IGW JDBC OData integration gateway auto generated key , KBA , MOB-ONP-OOD , SAP Mobile On Premise Offline OData Server , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.