on 05-16-2011 2:45 PM
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.
Excluding compile: com.sap.engine.services.webservices.jaxrpc.encoding.GeneratedComplexType::_loadInto
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
Hi,
Check whether you have installed the correct java version and JCE policy files or not.
Thanks,
Deepthi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.