Cannot start JSMP tool - Can start SDM

[Former Member]

Dear all,

We do have the following environment :

1. PL7 is our productive BW-ABAP system

PL8 is our productive BW-JAVA system

PL7 acts as PL8 UME.

2. QL7 is our quality BW-ABAP system

QL8 is our qulatiy BW-JAVA system

QL7 acts as QL8 UME.

We have copied PL7 to QL7 and PL8 to QL8 (system refresh for ABAP, export/ import of schema for BW-JAVA).

Now, we cannot restart the JSPM tool from QL8.

We do have the following issue :

1. When starting QL8, we do have the following error in std_server0.out file :

May 16, 2011 3:04:53 PM com.sap.ip.bi.webapplications [SAPEngine_Application_Thread[impl:3]_28] Fatal: Error in DoInit method

May 16, 2011 3:04:53 PM com.sap.ip.bi.webapplications [SAPEngine_Application_Thread[impl:3]_28] Fatal:

May 16, 2011 3:04:53 PM com.sap.ip.bi.webapplications [SAPEngine_Application_Thread[impl:3]_28] Fatal: java.lang.reflect.UndeclaredThrowableException

Caused by: java.lang.reflect.InvocationTargetException

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.sapportals.portal.security.usermanagement.WrappedUserInvocationHandler.callOtherMethod(ServiceUserFactoryImpl.java:172)

at com.sapportals.portal.security.usermanagement.WrappedUserInvocationHandler.invoke(ServiceUserFactoryImpl.java:147)

... 30 more

Caused by: com.sap.security.api.PrincipalNotAccessibleException: ORA-00942: table or view does not exist

at com.sap.security.core.imp.AbstractPrincipal.getPrincipalDatabagValues(AbstractPrincipal.java:1797)

at com.sap.security.core.imp.AbstractPrincipal.getAttributeValueString(AbstractPrincipal.java:1843)

at com.sap.security.core.imp.AbstractUserAccount.getDisplayName(AbstractUserAccount.java:2316)

at com.sap.security.core.imp.UserAccountWrapper.getDisplayName(UserAccountWrapper.java:509)

at com.sapportals.portal.security.usermanagement.User50_Impl.getDisplayId(User50_Impl.java:222)

... 36 more

May 16, 2011 3:05:05 PM com.sap.lcr.cimsrv.CIMOMServlet [SAPEngine_Application_Thread[impl:3]_15] Fatal: SLD initialization failure, can not set up cluster-wide event notification. Please check your JMS provider for errors.

1. Excluding compile: com.sap.engine.services.webservices.jaxrpc.encoding.GeneratedComplexType::_loadInto

2. Excluding compile: com.sap.engine.services.webservices.jaxrpc.encoding.InstanceBuilder::readElement

2. When starting JSPM, we do have the following error :

"Can not detect usages. Cannot detect installed ppms instances. Could not load usage type data from source jdbc/pool/QL8.

"com.sap.sl.ut.infoprovider.exceptions.UTInforException: Wrong SQL Statement!

"com.sap.sl.ut.infoprovider.exceptions.UTInforException: Wrong SQL Statement! java.sql.SQLException: ORA-00942: table or view does not exist."

Important :

we can use SDM, Visual Administrator and Configtool without any problem.

Any help is very welcome.

Best regards

SAPNetWeaverAdmin

[Former Member · Accepted solution]

1. ORA-00942: Class PrincipalNotAccessibleException this is a UME Exception, Have you performed the Post Installation Steps after J2EE System Copy --> UME Configuration using Config TOOL & Under core.ume.service?

2. SLD initialization failure, Visual Admin --> SLD Data Supplier, Check the user and the port of the Central/ Local SLD and hit a the Menu Arrow which has 'Refresh the data from SLD'.

3. Cannot load JSPM, this is also related to Post Installation Steps of J2EE.

Thanks

SM

[Former Member · Accepted solution]

Dear SM,

Interesting ...

ORA-00942: Class PrincipalNotAccessibleException this is a UME Exception, Have you performed the Post Installation Steps after J2EE System Copy --> UME Configuration using Config TOOL & Under core.ume.service?

Do you have a standard link which refer to the J2EE post installation system copy ?

Best regards

SAP NetWeaverAdmin

[Former Member · Accepted solution]

According to the below note

https://service.sap.com/sap/support/notes/400241

ORA-00942: table or view does not exist

Log entries: Logon as OPS$ user to get <sapowner>'s password

Connecting as /@<sid> on connection 0 ...

Now I'm connected to ORACLE

• ERROR => ORA-942 when accessing table SAPUSER

The system issues message ORA-00942 if the table SAPUSER does not exist. Therefore, proceed as follows:

Use the following command to create the table SAPUSER as <sid>adm:

CREATE TABLE "OPS$<sid>ADM".SAPUSER

(USERID VARCHAR2(256), PASSWD VARCHAR2(256));

INSERT INTO "OPS$<sid>ADM".SAPUSER VALUES ('<sapowner>', '<password>');

If the error still occurs, see the "General checks" section once again.

So have you check whether J2EE is able to access SAPSR3DB schema using OPS$ Mechanism?

To check the UME Service functioning , use COnfig tool --> Global Service --> scroll to core.ume.service and check the back end configration.

Refer:

http://help.sap.com/saphelp_47x200/helpdata/en/f0/06093f7c392e5ae10000000a114084/content.htm

http://help.sap.com/saphelp_47x200/helpdata/en/8c/1024d16f350041917d01bfdaeb2fae/content.htm

Thanks

SM

[Former Member · Accepted solution]

Thanks SM, very helpfull.

I have a last question :

how do you test it ?

"So have you check whether J2EE is able to access SAPSR3DB schema using OPS$ Mechanism?"

Best regards

SAPNetWeaverAdmin

[Former Member · Accepted solution]

Login as ORASID, use the below command to change the password of SAPSR3DB and store it in SAPUSER table of OPS$SAPSID.

brconnect -f chpass -o SAPSR3DB -p NEWPASS

This will save the newpassword and login as SAPSR3DB as below to see if you can select few tables from his schema

> sqlplus

> username: SAPSR3DB

> Password: XXXXXXXXXXX

> select count(*) from user_tables; This value might be around 642.

Thanks

SM

[former_member239334 · Accepted solution]

Did you solve your issue. We are encountering the same problem and would like to know how to solve it.

Thanks in advance.

Best Regards,

Olivier

[Former Member]

Hi,

Check whether you have installed the correct java version and JCE policy files or not.

Thanks,

Deepthi

[Former Member]

Hello

Kindly check the JSPM log under /JSPM/log and see what other information can be seen.

Kindly cross check all the post activities.

I hope SLD supplier data has some issue along with UME configuration.

Kindly fix the UME part so that ABAP and Java are in sync for user management part.

Then fix the SLD connectivity and try.

Regards

Vivek