search

sap-tutorials / Tutorials

Tutorials on sap.com
https://developers.sap.com/tutorial-navigator.html
Creative Commons Attribution 4.0 International
733 stars 778 forks source link

Expose Integration Flow Endpoint as API and Test the Flow #23753

Closed lgaaloul closed 1 month ago

lgaaloul commented 1 month ago

Tutorials: https://developers.sap.com/tutorials/cp-starter-isuite-api-management.html

Error When execute API : Cannot connect to host zeus.hana.prod.eu-central-1

Hello

I created a ticket #23749 but it was closed without being resolved.

Step_5 step_receiver

In step 4 "Execute API" of the tutorial "Expose Integration Flow Endpoint as API and Test the Flow" I have the following error message

Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sap://zeus.hana.prod.eu-central-1.whitney.dbaas.ondemand.com:22716 [Cannot connect to host zeus.hana.prod.eu-central-1.whitney.dbaas.ondemand.com/18.196.126.43:22716 [java.net.ConnectException: error 111 - Connection refused], -813.]. Error Code: -813 Call: SELECT PRODUCT_ID, CATEGORY, CATEGORY_NAME, CURRENCY_CODE, DIMENSION_DEPTH, DIMENSION_HEIGHT, DIMENSION_UNIT, DIMENSION_WIDTH, LONG_DESCRIPTION, NAME, PICTURE_URL, PRICE, QUANTITY_UNIT, SHORT_DESCRIPTION, SUPPLIER_ID, WEIGHT, WEIGHT_UNIT, SUPPLIER_SUPPLIER_ID FROM ESPM_PRODUCT WHERE PRODUCT_ID LIKE ? ESCAPE '' bind => [1 parameter bound] Query: ReadAllQuery(referenceClass=Product sql="SELECT PRODUCT_ID, CATEGORY, CATEGORY_NAME, CURRENCY_CODE, DIMENSION_DEPTH, DIMENSION_HEIGHT, DIMENSION_UNIT, DIMENSION_WIDTH, LONG_DESCRIPTION, NAME, PICTURE_URL, PRICE, QUANTITY_UNIT, SHORT_DESCRIPTION, SUPPLIER_ID, WEIGHT, WEIGHT_UNIT, SUPPLIER_SUPPLIER_ID FROM ESPM_PRODUCT WHERE PRODUCT_ID LIKE ? ESCAPE ''")

jmmargo commented 1 month ago

@Karunaharan please respond to this user's feedback. Thank you.

Karunaharan commented 1 month ago

Hi @lgaaloul - what is the receiver system that you are connecting to? Please confirm.

lgaaloul commented 1 month ago

Hi @Karunaharan

Below is my receiver configuration as shown in step 6 of the tutorial

step_receiver_1 step_receiver_2 step_receiver_def

Thanks

Karunaharan commented 1 month ago

I'm not sure what you refer to by "Cannot connect to host zeus.hana.prod.eu-central-1.whitney.dbaas.ondemand.com"

It might be the case that the webshop application is intermittently down. Please try after some time. I'll check from my side as well.

Karunaharan commented 1 month ago

Hi @lgaaloul The webshop app didn't work with the mentioned URL. It is changed to https://refapps-espm-ui.cfapps.eu10.hana.ondemand.com. The same is updated in the tutorial too. Please try now.

Karuna

lgaaloul commented 1 month ago

Hi @Karunaharan

Thanks, it works.