SAP Knowledge Base Article - Preview

2483491 - Offline OData store using IGW: Connecting MS SQL server-generate keys fails

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.