SAP MDK Offline OData sync failure after a new entity created

[p619793]

Hi,

In my offline mdk app, when I create an entity for Reservation Entity in offline mode and press sync for uploading the same, upload action comepletes successfully and record gets created at backend. Then DownloadOffline action starts which fails. The downloadoffline action tries to download the entityset from backend.

Error is reported in banner message on sync failure :

Below is log from client trace.

An error is logged in the trace : 'Parameter 20 value is out of range for conversion.' Not sure which parameter it is referring to.

Best regards,

Sumit

[d_weinberg]

Hi Sumit,

What was the cause of the issue. I am right now facing the exact same issue and cannot fiure out the cause (I quite new to the MDK).

Best regards,

Daniel

[bill_froelich]

weinberg01 Please open a new question so you can include the specifics of your scenario

[p619793]

Hi weinberg01 , for me there was a text field (Edm.string) and the value for this field returned from backend OData service was more than the max. length specified in the OData metadata. So we corrected the code in backend odata service. We also reported this to SAP to report a better error message, if possible.

Regards,

Sumit

[bing_fang]

Hi sumit.kundu2,

I check our code, there is validation code for the string length, but there may be an issue which cause it not work and let the database layer to throw the error message. we create a internal ticket to find the reason and will enhance it.

thanks.

[briantim]

It is hard to see the error unless it is from the length of the msgtext is splitting into other fields

[briantim]

Need more information. What does the vendor record look like? Can you show what is being passed in to the record?

[p619793]

Hi briantim ,

The creation of a new reservation is happening using ChangeSet action hence a batch call to odata. Here is the payload:

--batch_709b8b9352ac4342a0efb1e012d_1
content-type: multipart/mixed; boundary=changeset_709b8b9352ac4342a0efb1e012d_2

--changeset_709b8b9352ac4342a0efb1e012d_2
content-type: application/http
content-transfer-encoding: binary
content-id: 1

POST HeaderStrSet HTTP/1.1
Content-Type: application/json
Accept: application/json;q=1, application/atom+xml;q=0.5
RepeatabilityCreation: Tue, 18 Apr 2023 14:45:17 +0000
RequestID: d62591d9de5311ed8000b2534fa04d9d
OfflineOData.TransactionID: 31a4733a-e7a6-42e5-86de-6efd731e0164

{"Ekgrp":"002","AppDate":"\/Date(1681829076000)\/","MoveType":"201","Werks":"9000","Kostl":"3030003","DropPoint":"001"}
--changeset_709b8b9352ac4342a0efb1e012d_2
content-type: application/http
content-transfer-encoding: binary
content-id: 2

POST ItemStrSet HTTP/1.1
Content-Type: application/json
Accept: application/json;q=1, application/atom+xml;q=0.5
RepeatabilityCreation: Tue, 18 Apr 2023 14:45:17 +0000
RequestID: d62591dbde5311ed8000b2534fa04d9d
OfflineOData.TransactionID: 31a4733a-e7a6-42e5-86de-6efd731e0164

{"Ablad":"","Plant":"1000","Matnr":"10000040","Meins":"EA","MatQuan":"1"}
--changeset_709b8b9352ac4342a0efb1e012d_2--

--batch_709b8b9352ac4342a0efb1e012d_1--<br>

Here is the response from backend odata:

HTTP/1.1 201 Created
Content-Type: application/json
Content-Length: 517
dataserviceversion: 2.0
location: https://s4devmobile:444/sap/opu/odata/sap/Zxxxx_APP_SRV/HeaderStrSet(guid'31a4733a-e7a6-42e5-86de-6efd731e0164')<br>
{"d":{"__metadata":{"id":"https://s4devmobile:444/sap/opu/odata/sap/Zxxxx_APP_SRV/HeaderStrSet(guid'31a4733a-e7a6-42e5-86de-6efd731e0164')","uri":"https://s4devmobile:444/sap/opu/odata/sap/Zxxxx_APP_SRV/HeaderStrSet(guid'31a4733a-e7a6-42e5-86de-6efd731e0164')","type":"Zxxxx_APP_SRV.HeaderStr"},"Ekgrp":"002","AppDate":"\/Date(1681776000000)\/","Guid":"31a4733a-e7a6-42e5-86de-6efd731e0164","MoveType":"201","Werks":"9000","Kostl":"3030003","DropPoint":"001"}}<br>HTTP/1.1 201 Created
Content-Type: application/json
Content-Length: 671
dataserviceversion: 2.0
location: https://s4devmobile:444/sap/opu/odata/sap/Zxxxx_APP_SRV/ItemStrSet(Guid=guid'31a4733a-e7a6-42e5-86de-6efd731e0164',ReqNum='0000001247',ReqItem='00010')<br>
{"d":{"__metadata":{"id":"https://s4devmobile:444/sap/opu/odata/sap/Zxxxx_APP_SRV/ItemStrSet(Guid=guid'31a4733a-e7a6-42e5-86de-6efd731e0164',ReqNum='0000001247',ReqItem='00010')","uri":"https://s4devmobile:444/sap/opu/odata/sap/Zxxxx_APP_SRV/ItemStrSet(Guid=guid'31a4733a-e7a6-42e5-86de-6efd731e0164',ReqNum='0000001247',ReqItem='00010')","type":"Zxxxx_APP_SRV.ItemStr"},"Ablad":"","Guid":"31a4733a-e7a6-42e5-86de-6efd731e0164","Plant":"1000","Mandt":"","MsgText":"","Matnr":"10000040","ReqType":"","CreatedBy":"","ReqNum":"0000001247","CreatedOn":null,"Meins":"EA","ReqItem":"00010","Maktx":"","MatQuan":"1.000"}}<br>

The DownloadOffline action result from OData (,i.e., GET ItemStrSet):

{
  "d" : {
    "results" : [
      {
        "__metadata" : {
          "id" : "https://s4devmobile:444/sap/opu/odata/sap/Zxxxx_APP_SRV/ItemStrSet(Guid=guid'd2402db3-e2c1-4073-b68d-1018eef26c67',ReqNum='0000001265',ReqItem='00010')",
          "uri" : "https://s4devmobile:444/sap/opu/odata/sap/Zxxxx_APP_SRV/ItemStrSet(Guid=guid'd2402db3-e2c1-4073-b68d-1018eef26c67',ReqNum='0000001265',ReqItem='00010')",
          "type" : "Zxxxx_APP_SRV.ItemStr"<br>        },
        "Ablad" : "test sk6",
        "Guid" : "d2402db3-e2c1-4073-b68d-1018eef26c67",
        "Plant" : "1000",
        "Mandt" : "300",
        "MsgText" : "For Material no: 10000040 already exist Reservation nos: 0000001254,0000001247,0000001242,0000001241,0000001223,0000001201,0000001198,0000001197,0000001196,0000001195,0000001193,0000001154,0000001153,0000001150,0000001137,0000001134,0000001130,0000001129,0000001128,0000001026,0000001008,0000001007,0000001006,0000001004,0000001003,0000001001,0000000997,0000000996,0000000995,0000000993,0000000992,0000000990,0000000971,0000000970,0000000969,0000000967,0000000966,0000000964,0000000931,0000000923,0000000917,0000000914,0000000912,0000000911,0000000910,0000000908,0000000907,0000000905,0000000904,0000000903,0000000902,0000000901,0000000900,0000000899,0000000898,0000000897,0000000896,0000000895,0000000894,0000000893,0000000892,0000000891,0000000890,0000000889,0000000888,0000000887,0000000886,0000000885,0000000884,0000000883,0000000882,0000000881,0000000880,0000000879,0000000878,0000000877,0000000875,0000000874,0000000873,0000000871,0000000870,0000000868,0000000866,0000000865,0000000864,0000000863,0000000862,0000000861,0000000860,0000000859,0000000858,0000000857,0000000856,0000000855,0000000854,0000000853,0000000851,0000000850,0000000849,0000000847,0000000846,0000000843,0000000841,0000000840,0000000839,0000000838,0000000837,0000000836,0000000835,0000000833,0000000831,0000000830,0000000829,",
        "Matnr" : "10000040",
        "ReqType" : "RV",
        "CreatedBy" : "SKUNDU",
        "ReqNum" : "0000001265",
        "CreatedOn" : "\/Date(1681862400000)\/",
        "Meins" : "EA",
        "ReqItem" : "00010",
        "Maktx" : "",
        "MatQuan" : "1.000"
      }
    ]
  }
}<br>