Hybrid Application [SMP3.0.7.0] - oData Service Deployment Issues

[Former Member]

Dear Experts, Good Day,

I have created the oData Service(Data Source as JDBC), while deploying the service on SMP, getting the ‘Deployment cannot be completed for <<SERVICENAME>>’(Error Screen Shot 1), upon clicking on the OK button the service got created successfully in the Integration Gateway cockpit, upon enabling the service in the Integration Gateway, the appropriate service is accessible & consuming the same service in hybrid application.

The problem is, if the SMP Server got restarted, none of the earlier deployed services are accessible, even if you redeploy the service again from eclipse editor, it is getting the below error message, for more details attaching  the server logs.

[Work Around] – Temporarily identified a work around for this issue, deleting the target content from the oadat service, renaming the  odata service & deploy the service with the different name.

FYI… Attaching Error Screen Shot 1(Screen Shot 1)

FYI…. Attaching Eclipse Details Error Message for the above error(Screen 2)

By somehow, if the SMP server got restart then these service are not accessible, getting the following error:

FYI… Error Message while invoking the service through browser.

<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">

<code>SERVICE_UNAVAILABLE</code>

<message xml:lang="en-US">Service Unavailable</message>

</error>

Also Attaching the SMP Server Logs for more details(SMP-SERVER-LOGS)

Sharing the environment details:

Server : SMP 3 SP 07

SDK : SDK07

Editor :

API Toolkit for SAP 1.4.1

Eclipse IDE for JAVA EE 2.0.2.201

OData Modeler 1.4.1

Kindly Suggest.

Regards,

Tirupati

smp-server-logs.txt.zip

[Jitendra_Kansal]

I had experienced same error with SOAP WS but not JDBC. This is very strange behavior.

Is this the first time you faced this error? and that too with JDBC data source?

You are working on Eclipse kepler. Right?

If possible, can you reinstalling "SAP Mobile Platform Tools" and then try? Please follow steps mentioned

Make sure you are able to connect to SMP server as per step #4

Regards,

JK

[Former Member]

Thanks Jitendra for you response!

Yes, correct I am using the Eclipse Kepler with oData Modeler 1.4.1

This is the first time I am facing with SMP-SP07(That too with JDBC, not tried with SOAP yet).

As I mentioned in my post, the server is connecting from eclipse, even I am able to deploy the oData services which we are consuming for my hybrid Application. The issue is with the SMP restart.

The moment we restart the SMP server all the deployed service become not accessible.

Also verified the deployment_content at the server, all the deployed services ex. [service name_version.jar] files are existing @ server even after the restart.

Also tried with the reinstall option but no luck.

Any known issue with SP07(Since I am using Both SMP server & sdk are SP07)?

Regards,

Tirupati

[Jitendra_Kansal]

I tried to reproduce the same at my end but for me all deployed OData services are working after restart.

You should raise a ticket in SAP support portal.

Regards,

JK

[PavelPenaz]

Hi Tirupati,

Can you attach the Eclipse project here, as a zip?

Will try to import to my Eclipse, check deploying to my SMP server and let you know back. Just to check of this is an issue with the project or with the SMP server instance.

Thanks,

Pavel

[PavelPenaz]

Hi Tirupati,

Thanks for providing the Eclipse project by email.

I imported the project to my Eclipse, Kepler, version of the SMP and ODATA plugins 1.4.1

And for me, the same project works, I tried redeploying to my SMP 3.0 SP07 PL02 multiple times and also restarted SMP. The service is still there. Obviously, the only thing I could not try was to test against your own database. But the service is active even after reboot and I do not get any errors.

Question: Do you have SMP 3.0 SP07 patch level 2?

Suggestion: I would suggest to check the following:

1. delete the project in Eclipse

2. delete the service on Integration gateway

3. restart SMP

4. import the project again to Eclipse

5. Redeploy to SMP

Would this work?

Thanks.

Pavel Penaz

[Former Member]

Dear Pavel,

Thanks for your response, the issue got solved by upgrading SMP Server from SP07 base version to PL02.

Thanks a lot for your continuous support.

Regards,

Tirupati