SMP03 SP09 Odata service using JDBC Data Source deployment Issue

[Former Member]

Hi experts I am building a Odata service in Eclipse Luna and trying to deploy my simple Odata service to fetch data from DB using  JDBC option, while i am deploying i am getting the following error , please guide me , i have searched the blogs but didn't find any luck with solution. Here is the error i am facing I am following the blog to create the service http://scn.sap.com/community/developer-center/mobility-platform/blog/2014/07/05/smp-30-integration-g... https://www.youtube.com/watch?v=aC79SJ3JrME&index=6&list=PLP4VJ70fXIeeZglLDHo7pcjIgZGd8lt1s Refered threads http://scn.sap.com/thread/3740866 http://scn.sap.com/thread/3724115 http://scn.sap.com/thread/3278105 http://scn.sap.com/thread/3621552 http://scn.sap.com/thread/3806735 Deployment cannot be completed for FLEETSERVICE Sun Jan 10 09:30:57 UTC 2016 | Build and deploy task started for task id: 2f4c351a-cc4b-4210-bd4e-fc2cdb273824 Sun Jan 10 09:30:58 UTC 2016 | Validator Logs : Sun Jan 10 09:30:58 UTC 2016 | WARNING : Invalid element exists in the integration flow, the sequence flow containing the element cannot be processed   Sun Jan 10 09:30:58 UTC 2016 | Generation started for FLEETSERVICE_SAP_1 project Sun Jan 10 09:30:58 UTC 2016 | Generation completed for FLEETSERVICE_SAP_1 project Sun Jan 10 09:30:58 UTC 2016 | Build started for FLEETSERVICE_SAP_1 project Sun Jan 10 09:30:58 UTC 2016 | Build is successful for FLEETSERVICE_SAP_1 project Sun Jan 10 09:30:58 UTC 2016 | Deployment successfully triggered for project(s) [FLEETSERVICE_SAP_1] Sun Jan 10 09:30:58 UTC 2016 | Successfully stored artifacts for task: 2f4c351a-cc4b-4210-bd4e-fc2cdb273824

[Jitendra_Kansal]

Hello Vijay,

Can you share below info:

1. SMP plugin (eclipse) version

2. How many entitysets are there in the project

3. Do you also have custom scripting for the entityset(s)?

4. Have you already tried ?

• Generating integrate content (right click on project)
• Deploy the zipped file directly in the Admin cockpit (under OData services)

Regards,

JK

[Former Member]

Hi JK 1) SMP plugin Version is 1.6.2 . 2)Only one entity set. 3) Yes i am having custom Scripting , but for mapping only , processRequestData() function is implemented. Do i need to write code to fetch data ? or simple mapping is sufficient for a basic service ? Under which circumstances do  i need to implement this function processRequestSQL() ? I have not deployed the Zipped file directly.

[Jitendra_Kansal]

In order to do mapping, you will need to implement processRequestData that you have already done.

Under which circumstances do  i need to implement this function processRequestSQL() ?

this function can be used to modify SQL statement which is a string and returns the modified SQL statement in a message body.

Check this official guide. Please dont mix two different queries in this thread, you can raise a new thread on this.

I have not deployed the Zipped file directly.

Give a try and share your findings.

Looping Carlos Roggan for more inputs.

Regards,

JK