Installation problem with SSM 7.0

[Former Member]

Hi,

We installed SSM 7.0 but we got problems with connection between application server (PAS) and SSM. When we try in SSM administration to map a context or when we navigate on "Scorecard" Tab in SSM, we got the following error : "Error accessing the selected data source ; application server connection not available or could not be found".

We also tried to manage model connection without success. So how could we make this connection working (what guide to read) ?

We were used to use a VMware when using SSM 2007. So we could access PAS administration via localost. In SSM 7.0, how could we access PAS administration (in order to run procedure and so on) ?

Thanks in advance

[Bob_McGlynn · Accepted solution]

Jacques,

The error message that you received indicates that the model connections are not correctly set. The Server Configuration Guide for SAP Strategy Manaagement 7 SP2 Min, Section 5.2 is the section on Model Connections.

The most typical issue with failed model connections is a password error. The password for the model connection is your Windows login. Start>Administrative Tools>Computer Management>Local Users and Groups> Users. This is where you add your Windows user. It's best not to use pipadmin for this user, since it can be confusing. Suggest pasuser.

This user and password will be used for your model connections.

If you wanted to use PAS but were not on the server on which it was installed, you would first have to install PAS on your local machine and then modify the lsserver.ini file.

This is an example:

[abcde1234] <which = the name of the server where PAS is located Usually this line says localhost if you're working directly on the server>

tcp_protocol=WINSOCK

username=pipadmin

password=

PROTOCOL=tcp

SERVICE=PILOT

CURSOR=LSSCMPTR

PORT=8325

EncryptedPassword=

LOGFILE=

LOGLEVEL=

Then, when you log in to PAS, you select the server name from the drop down.

Regards,

Bob

[Former Member]

Hi,

Our problem before was that pipadmin was not a windows user in the domain. I adjusted this and now everything seems to work fine.

So problem solved.

Thanks anyway to those who helped me.

Regards

[Former Member]

Hi,

unfortunately, it doesnt work. It is not only a problem when we try to connect remotely to the PAS. When I try to make an internal connection on the server, from web to application server, it doesnu2019t work either.

I think it is due to a listener problem. If you have idea, please feel free to answer.

Regards

[Former Member]

Jacques -

You may want to try manually tracing the credentials that you are using in the SSM Admin 'Manage Model Connections' all the way back to the PAS model.

By this, I mean:

1. Login into the box where PAS is located with with the same "Web Server User Name" and "Web Server Password" used in SSM Admin 'Manage Model Connections'. Ensure that this user has administrative access to the box where PAS is located.

2. Login into PAS with the same "PAS User" and "PAS Password" being used in SSM Admin 'Manage Model Connections'.

If both of the above manual steps work, you may want to check the following:

1. Make sure that the model you are trying to access has been added to the PAS MasterDB.

2. Make sure that you have the right server, port and dimensional model in the SSM Admin 'Manage Model Connections' console.

3. Make sure that no one is using the dimensional model you are trying to access in 'Exclusive' mode

4.Make sure that both the SAP SSM Extended Listener and SAP SSM Listener services have been started. If so, maybe try restarting them both.

Hope this helps.

Jason

[Former Member]

Thanks BOb.

I'll give it a try and let you know if its working.

Best regards