500 Internal Server Error while executing Gateway Service

[Former Member]

I have created a project in SEGW for RFC.  When i execute this service it gives status as "500 Internal Server Error" .

Exception occurs when the following method is executed : /IWFND/IF_SODATA_MAPPER~GET_ENTITY_PROV_BY_FEED_DATA.

Also I noticed that if the queried table has some output data only then this Internal Server error occurs whereas the status is "200 OK" when there is no output data.

Please help me to solve this issue.

[kammaje_cis · Accepted solution]

HI Deepika,

May be you can look at the error log and let us know the error mentioned there?

Also with the 500 error it should be throwing some kind of error message right?

Thanks

Krishna

[Former Member · Accepted solution]

ERROR_INFO

Invalid format (return table): Row Number 1,  Property Name 'DateChOn',  Property Value '00000000'

This is the error i am getting. Format for this field in entity properties is Date Time.

[former_member184867 · Accepted solution]

Hi Deepika,
Please check in your metadata , if attribute nullable is true for property 'DateChOn'.

Regards,

Atanu

[Former Member · Accepted solution]

Hi Atanu,

I gave the property as Null-able for all the fields in my table.

But still m getting same error.

[former_member184867 · Accepted solution]

Hi Deepika,

You need to mark 'nullable'  = 'true' at the attribute for property 'DateChOn' in the metadata document.

Can you please share the metadata ?

Regards,

Atanu

[kammaje_cis · Accepted solution]

After changing it as nullable, clear your metadata cache. Both in BEP as well as FND system.

[Surekha · Accepted solution]

Hi Krishna ,

I am also getting internal Server error 500 while processing batch for create operation.

After executing batch in post operation  i got this message

Please see below screenshot which i got in error log

Let me know the solution for the same.

Thanks

Surekha

[Former Member · Accepted solution]

Hi Surekha,

Please check maybe request body of batch is having any issues..

Thanks

[Surekha · Accepted solution]

Hi Rajesh,

There was some problem with request body.I have resolved it and it's working fine ..

Thanks for reply.....

Thanks

Surekha