on 05-15-2010 9:03 AM
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
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/xappscpmsm~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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.