Error while calling odata service in SMP SP5

[Former Member]

I am getting an error while calling odata service in smp sp5. The error is "Internal server error occurred ::: Check server logs for more details", unable to show the results.

Please help me to fix this issue.

Regards

B Praveen

[Jitendra_Kansal · Accepted solution]

Hi Praveen,

Can you share steps what all you have done before encountered with this error?

Share the screenshots. Did you get a chance to look at SMP server logs for more clues?

Regards,

JK

[Former Member · Accepted solution]

Created an odata service with the integration gateway for sp4 and deployed in smp sp4 and it worked fine, where as the same service is not working in sp5.

i) we upgraded keepler to sp5. Some projects are deploying where some projects are not deploying in smp(sp5) gateway cockpit. after 80% the process is not progressing.

Please tell us,How to migrate from sp4 to sp5

Regards

B Praveen

[Jitendra_Kansal · Accepted solution]

Please confirm below points:

1. As you said, you have upgraded Kelper to SP05, can you verify "API Toolkit version"? Should be 1.1.3 (check this guide )

2. As you have upgraded runtime to SP05, you have to upgrade target runtime for existing project. Right click on project> Change Target Runtime > Select SP05

3. Redeploy (Generate and deploy integrate content). You may rename service and update its version while doing so.

Which data source this odata service has been assigned to? SOAP WS/JDBC/JPA/ODC?

Regards,

JK

[Former Member · Accepted solution]

API Toolkit Version is 1.1.4, I upgraded runtime to sp05. Its SOAP WS.

I create a new project with only one entity set and deployed. It was deployed into gateway cockpit, But when accessing I am getting error as in attached image

[Jitendra_Kansal · Accepted solution]

Praveen,

1. Can you share screenshots of OData model, request mapping response mapping?
2. Are you doing it Query operation?
3. Have you done any custom scripting?
4. As already asked did you check server logs? You must get some hints from there? Run the service again and check logs for that duration.. Admin cockpit> system>logs>smpserverhostname.log

Regards,

JK

[Former Member · Accepted solution]

The services when deployed in smp sp4 they are working fine.

All are with custom scripting only, do we need any changes in scripting?

I will send error log later

[Jitendra_Kansal · Accepted solution]

Please provide complete information to help you better.

Have you implemented Query operation in your project as you are trying to access EntitySet information? Can you share the custom code?

please check logs to troubleshoot your issue.

Regards,

JK

[Former Member · Accepted solution]

We found the solution.

In SP04 we used a function processRequestXML to send a query request in java script custom code.

where as for SP05 we send a query request using processRequestData function.

Now it is working.

Thank u jitendra for your support

regards

praveen

[Jitendra_Kansal · Accepted solution]

Glad it worked for you. Thanks for sharing the solution.

Regards,

JK