getting error Property 'RoomNumber' is invalid in gateway system.

[Former Member]

Hi All,

While creating customer from customise oData service, I am getting error "Property 'RoomNumber' is invalid".(T100 Error ID: /IWFND/CM_MGW033)

I have a customer entity type which is having RoomNumber field with property creatable & updatable.

Can you please help me to solve this out or way to solve such kind of errors as it is very critical?

Below is the error detail from error log ...

ERROR_CONTEXT ..ERROR_INFOProperty 'RoomNumber' is invalid ..ERROR_RESOLUTION ...SAP_NOTESee SAP Note 1797736 for error analysis ...LINK_TO_SAP_NOTEhttps://service.sap.com/sap/support/notes/1797736 ../IWFND/CX_MGW_TECH_EXCEPTION ...RFC_FAILURE_MESSAGE_V2 ...RFC_FAILURE_MESSAGE ...TRANSFORMATION ...ENTITY_NAME ...REMOTE_MESSAGE ...REMOTE_SYSTEM ...REMOTE_MESSAGE_TYPE ...SERVICE_IDENTIFIER ...METHOD ...FIELD_NAME ...FIELD_VALUE ...NAVIGATION_PROPERTY ...SYSTEM_ALIAS_LIST ...FILTER ../IWCOR/CX_DS_BAD_REQUEST ..CX_SXML_PARSE_ERROR ...ERROR_TEXT ...RAWSTRING ...XML_OFFSET1893 ...RC0 ../IWCOR/CX_DS_EP_PROPERTY_ERROR ...PROPERTYRoomNumber ...VALUE ...TYPE ...OFFSET0 ..SERVICE_INFO ...NAMESPACE/SAP/ ...SERVICE_NAMEEUSD_CUSTOMER ...VERSION5001 ...SYSTEM_ALIASECC_FMS ...DESTINATIONECC_FMS ..SYSTEM_INFO ...REQUEST_URI/sap/opu/odata/sap/EUSD_CUSTOMER;v=5001/CustomerSet ...REMOTE_ADDRESS(xx.xx.xxx.xx) ...APPLICATION_SERVERthegwq00_GWQ_00 ...HUB_VERSION_INFOSystem GWQ/100, NW Release 7.40, SAP_GWFND SP10, Internal GWFND Version 011

Regards,

Subhanshu

[Former Member]

Hi Shubhanshu,

1. Go to the tcode segw and open the project and the entity.

2. Check if you have defined the field named RoomNumber in your entity type. This is case sensitive.

capture.png

[former_member467951]

Execute the Metadata request and see if the property "RoomNumber" and verify if it exists, make sure the case(upper/low) matches.

[Former Member]

Hi Ram,

yes, it is available in metadata.

<Property Name="RoomNumber" Type="Edm.String" Nullable="false" MaxLength="10" sap:label="Room number" sap:sortable="false" sap:filterable="false" />

Regards,

Subhanshu

[former_member467951]

Strange, then the fastest way is to resolve this is to debug your request. You can start all the way by putting an external breakpoint in ODATA handler class /IWFND/CL_SODATA_HTTP_HANDLER, method IF_HTTP_EXTENSION~HANDLE_REQUEST.

If possible screenshot your complete payload and EDM properties screen in SEGW.

[Former Member]

Hi Ram,

It got solved.

Actually, internally service was calling the another system(Old system) to get the dummy customer and creating a customer in the new system. I compared the entity set of the service in both system and found the conflict(Room no. was missing) in the structure in one of the entity set. made both structures in sync and it started working.

Thanks a lot for your Time Ram,

Regards,

Subhanshu

[former_member467951]

Your welcome. Please mark the appropriate answer as solved.