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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.