Unable to Connect to Web AS

[Former Member]

While setting up the Visual Composer system, we are unable to connect to our ECC 6.0 system. I have the same settings on the host system which the VC connects to the data source fine but it will not connect to any other system in our landscape. When doing a system connection test, I keep getting the error:

SAP Web AS Connection

Test Details:

The test consists of the following steps:

1. Checks the validity of system ID in the system object.

2. Checks if the system can be retrieved from the PCD.

3. Check whether a SAP system is defined in the system object

4. Validate the following parameters: WAS protocol; WAS host name

5. Checks if the host name of the server can be resolved.

6. Pings the server to see if it is alive.

7. Pings the WAS ping service; works only if the service is activated on the ABAP WAS.

8. Checks HTTP/S connectivity to the defined back-end application

Results

1. The system ID is valid

2. The system was retrieved.

3. The system object represents an SAP system

4. The following parameters are valid: Web AS Protocol (http) Web AS Host Name (saptrn01.ieua.org:8001)

5. The host name saptrn01.ieua.org was resolved successfully.

6. The server saptrn01.ieua.org could not be pinged successfully.

I have set the permission of the "Everyone" group to Full Control with the user end user checked, added the VCRole with full control, tried all the WAS settings that I've seen on the forums but nothing is working and we're unable to bring up this data source in VC. Does anyone have any other ideas to try?

[dao_ha · Accepted solution]

Hi Connie,

Check your /etc/services file for entries of the backend system. Also, as mentioned in #7-#8 of the Test Details, please make sure that you activate the service in the backend system (SICF).

Hope it helps.

Regards,

Dao

[Former Member · Accepted solution]

I checked the services file and did a side by side comparison with the server that is working and it appears to be identical. I have also activated all the services in SICF. Not sure what else could be the issue. Any help would be greatly appreciated. Thank you!

[dao_ha · Accepted solution]

Hi Connie,

The results indicated that it cannot ping the server. Can you access the link directly from your browser?

http://saptrn01.ieua.org:8001/sap/bc/ping

When you created your ECC system in the portal, what type of system connector (e.g. JDBC, Query, ODBO, XMLA or BW native) did you select? If you select the BW native then the system type must be set to SAP_BW; on the other hand, if you select JDBC as the connection type then you'd need to add the JDBC driver in Visual Admin, etc. The WAS connection test is only relevant when you select the BW native connection.

Please refer to the following doc for further details on how to troubleshoot the connection issues.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/92d80512-0a01-0010-32a3-cd3...

Hope it helps.

Regards,

Dao

[Former Member · Accepted solution]

I've tried to create a JDBC connection, XMLA and just a regular application server connection from the template but nothing is working. In visual composer the data connection keeps telling me that it has failed to connect to the backend. I'm able to bring up the page http://saptrn01.ieua.org:8001/sap/bc/ping which tells me that the server has been reached successfully.

[dao_ha · Accepted solution]

Hi Connie,

Hmm, what else can we check? Let's see if this link can help

https://wiki.sdn.sap.com/wiki/display/VC/Connectivity

Dao

[Former Member · Accepted solution]

Thanks Dao! I went through the document and unfortunately I'm still unable to get the connections to work at this time. I'm going to be working with our consultant and see if they are able to help out with this issue. I'll post the solution here as soon as I receive it. Thanks again for all of your help!

[dao_ha · Accepted solution]

Hi Connie,

Sorry that it didn't work out for you. Please do update the thread to share your solution.

Regards,

Dao

[Former Member · Accepted solution]

After working with my consultant for many hours on this all week, I've finally found the solution. I forgot the #1 rule in all networking is to always check the connections first! Turns out that the two servers were not able to communicate with each other. I figured this out when I was unable to ping the portal server from the ECC server and vice versa. Our network guy changed the settings and voila! Our Web AS and JCo connections all work now! Thank you all for all of your help. You really helped us get the parameters working for the visual composer. Thanks again!

[dao_ha · Accepted solution]

Hi Connie,

Glad to hear that you got your issues resolved and thanks for sharing the solution.

Cheers,

Dao