Error while running SSM UI

[Former Member]

Hello all ,

While running the SSM User Interface or administration UI , we are getting a error. The error is :

500 Internal Server Error

SAP NetWeaver Application Server 7.10 / AS Java 7.10

"Application error occurred during the request procession."

Error occured in invoking event "contextInitialized()" on listener class com.sap.cpm.sm.common.listeners.SMServletContextListener.

Details: "The WebApplicationException log ID is [005056984B1200160000000000000D54014061C707863504]."

We have removed the SSM application from the system and tried accessing the UI. Still the same error persists. If we remove the SSM application , then the URL should not be found. But , the same error is coming. Any idea as to where the error is and what is causing it ?

Thanks

Vijay

[Former Member · Accepted solution]

Hi,

I am stepping in for Vijay to update the message.

We tried to fix the error and finally undeployed and deployed CMP_STR_MGM_APC with SP04.

The prvious error has gone but it lead to another issue. We are not able to import the sapmple data from import.zip or

bootstrap.zip in http://hostname:port/strategy/tools ->transporter.

The error message from default trace is copied here.

#1.5 #005056984B1200170000003100000278014061C70786202F#1274200708262#com.sap.cpm.sm.newdbimpl.NewDataTransportServlet#sap.com/xapps_cpmsm~strategymanagement#com.sap.cpm.sm.newdbimpl.NewDataTransportServlet#pipadmin#917####b4b70370629b11dfc6b2005056984b12#HTTP Worker [3]##0#0#Error#1#/System/Server#Java#handleError()##Encounters error while creating or executing prepared statement [SELECT tstring, cpms_dbname_id FROM cpms_strings WHERE code = ? AND lang = ? AND (cpms_dbname_id = ? OR cpms_dbname_id = -1) ORDER BY cpms_dbname_id]

Values:

TRANSPORTER_52, , -1

[EXCEPTION]

#1#com.sap.sql.log.OpenSQLException: Cannot assign an empty string to host variable 2.

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:95)

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:188)

Waiting for inputs from the experts.

Thanks & Regards,

RK

Edited by: Raman Kulkarni on May 18, 2010 6:41 PM

Edited by: Raman Kulkarni on May 18, 2010 6:47 PM

[Bob_McGlynn · Accepted solution]

Raman,

When you are in Transporter, do you have a picklist or is a browse button available? If you upgraded to another SP, the import or bootstrap zip has to be associated with the current version running.

Remember that if you are using SQL Server for your db, you have to move the SQL procs files up a level when during install./config as referred to in the installation guide.

Regards,

Bob

[Former Member · Accepted solution]

Hi Bob ,

Thanks for your reply.

We are not getting a browse button available. We are having a picklist. We ensured we have all the components at the same SP level. Can you tell me a note or point to the correct import.zip file for SSM 7.5 SP04.

Also , I think the trace file points to a database error (SELECT tstring, cpms_dbname_id FROM cpms_strings WHERE code = ? AND lang = ? AND (cpms_dbname_id = ? OR cpms_dbname_id = -1) ORDER BY cpms_dbname_id]) .

My feeling is that this SQL is not getting executed . Is it a issue with the Dbase Admin or something ?? We are using Oracle as a backend.

Thanks ,

Vijay

[Bob_McGlynn · Accepted solution]

Vijay,

Are you using SQL Server for your SSM db? During the installation (or when upgrading with Service Packs) one of the steps is to move some PROCS files up one level. This has to be done if you are using SQL Server or Oracle as the SSM db. You should check to make sure is correct.

To check the steps in the configuration guide, they can be found at -- 2. Setting Up Client Access to the SAP Netweaver CE System Database

Regards,

Bob

[Former Member · Accepted solution]

Hi Bob,

Thanks for your reply. Our CE database is Oracle. We have copied the files from install-dir>\SAP BusinessObjects\Strategy

Management\InternetPub\procs\oracle_procs to procs directory but the issue is not resolved.

We have also upgraded to CE 7.1 SP09 .

Regards,

Raman

[Bob_McGlynn · Accepted solution]

Raman,

If you are using Oracle as your system database, the 32-bit client software for Oracle is installed on the Windows server where PAS is installed.

If you are connecting to Oracle from the Access LSLink subsystem of PAS, you must have the Oracle client software installed on your machine.

Also, please review the Server Configuration guide and check your Oracle settings.

Regards,

Bob

[Bob_McGlynn]

Vijay,

Are you going through a new installation or is this a problem that has popped up recently? Is the whole of your Netweaver instance running? jstart.exe should be green.

Regards,

Bob

[Former Member]

Dear Vijiay,

I guess you only removed SSM application server not AS Java webservice ( deployed on AS Java) , link will exits if you didn't undeploye CPMSTRMGMAPCXXXX.SCA.

I think if you reinstall SSM application and redeploy correct SP of SCA on AS Java ( after undeploy previous SCA) , try again.

Make sure the SP level for all components of SSM are in sync.

I faced same issue , and it was actually resolved by restarting SSM Listener and recreating HFPBM ( or whatever your database name) Model connection.

Regards