WebSphere Portal Server - WPCP 5 publishing problem

This is Interesting: Free IT Magazines  
Home > Archive > WebSphere Portal Server > July 2004 > WPCP 5 publishing problem





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author WPCP 5 publishing problem
qibm

2004-01-19, 3:01 pm

I have installed WPS5.0 and migrated database to Oracle 9i. The process was smooth and did not give any errors. The Portal site including WPCP works fine except for one issue. When I am using WPCP and trying to publish , I get the following error.

Part of error log :
--------------------------------------------
Previous exception:
Message: RemoteException occurred in server thread; nested exception is:
com.ibm.websphere.cpi.CPIException: ; nested exception is:
com.ibm.ejs.cm.portability.TableDoesNotExistException: ORA-00942: table or view does not exist

Stack trace:
java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
com.ibm.websphere.cpi.CPIException: ; nested exception is:
com.ibm.ejs.cm.portability.TableDoesNotExistException: ORA-00942: table or view does not exist


End of exception traces.
Current exception:
Message:
null
Stack trace:
com.ibm.websphere.brb.BusinessRuleBeansException

at com.ibm.websphere.brb.mgmt.RuleMgmtHelper.getRootFolder

(RuleMgmtHelper.java:228)

at com.ibm.ws.brb.LocalRuleManager.<init>(LocalRuleManager.java:103)
at com.ibm.websphere.brb.TriggerPoint.<init>(TriggerPoint.java:251)
at com.ibm.websphere.brb.TriggerPoint.<init>(TriggerPoint.java:188)
at com.ibm.websphere.personalization.RuleExecutorRuntime.<init>(RuleExecutorRuntime.java:45)
at com.ibm.websphere.personalization.RuleMitigator.getInstance(RuleMitigator.java:22)
at com.ibm.websphere.personalization.RuleTrigger.trigger(RuleTrigger.java:1172)
at com.ibm.websphere.personalization.RuleTrigger.getRuleResults(RuleTrigger.java:542)
at sample10.contentspots.GetOffersByType.getRuleContent(GetOffersByType.java:28)
at org.apache.jsp._doView._jspService(_doView.java:183)
at com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.jsp.servlet.JspServlet$JspServletWrapper.service(JspServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.serviceJspFile(JspServlet.java(Compiled Code))

---------------------------------------

Please if someone can help out in pointing the problem.

Thanks



James Yannotta

2004-01-19, 3:01 pm

V5.0 Infocenter is missing this:

SQL> grant ALTER on EJB.BRBeans_Rule to PZNADMIN;
SQL> grant DELETE on EJB.BRBeans_Rule to PZNADMIN;
SQL> grant INSERT on EJB.BRBeans_Rule to PZNADMIN;
SQL> grant SELECT on EJB.BRBeans_Rule to PZNADMIN;
SQL> grant UPDATE on EJB.BRBeans_Rule to PZNADMIN;

SQL> grant ALTER on EJB.BRBeans_RuleFolder to PZNADMIN;
SQL> grant DELETE on EJB.BRBeans_RuleFolder to PZNADMIN;
SQL> grant INSERT on EJB.BRBeans_RuleFolder to PZNADMIN;
SQL> grant SELECT on EJB.BRBeans_RuleFolder to PZNADMIN;
SQL> grant UPDATE on EJB.BRBeans_RuleFolder to PZNADMIN;

-James

"qibm" <hi_techserv@yahoo.com> wrote in message
news:942668213.1071754059907.JavaMail.wasadmin@swg3ws006...
quote:

> I have installed WPS5.0 and migrated database to Oracle 9i. The process

was smooth and did not give any errors. The Portal site including WPCP works
fine except for one issue. When I am using WPCP and trying to publish , I
get the following error.
quote:

>
> Part of error log :
> --------------------------------------------
> Previous exception:
> Message: RemoteException occurred in server thread; nested exception is:
> com.ibm.websphere.cpi.CPIException: ; nested exception is:
> com.ibm.ejs.cm.portability.TableDoesNotExistException: ORA-00942: table or

view does not exist
quote:

>
> Stack trace:
> java.rmi.ServerException: RemoteException occurred in server thread;

nested exception is:
quote:

> com.ibm.websphere.cpi.CPIException: ; nested exception is:
> com.ibm.ejs.cm.portability.TableDoesNotExistException: ORA-00942: table or

view does not exist
quote:

>
>
> End of exception traces.
> Current exception:
> Message:
> null
> Stack trace:
> com.ibm.websphere.brb.BusinessRuleBeansException
>
> at com.ibm.websphere.brb.mgmt.RuleMgmtHelper.getRootFolder
>
> (RuleMgmtHelper.java:228)
>
> at com.ibm.ws.brb.LocalRuleManager.<init>(LocalRuleManager.java:103)
> at com.ibm.websphere.brb.TriggerPoint.<init>(TriggerPoint.java:251)
> at com.ibm.websphere.brb.TriggerPoint.<init>(TriggerPoint.java:188)
> at

com.ibm.websphere.personalization.RuleExecutorRuntime.<init>(RuleExecutorRun
time.java:45)
quote:

> at

com.ibm.websphere.personalization.RuleMitigator.getInstance(RuleMitigator.ja
va:22)
quote:

> at

com.ibm.websphere.personalization.RuleTrigger.trigger(RuleTrigger.java:1172)
quote:

> at

com.ibm.websphere.personalization.RuleTrigger.getRuleResults(RuleTrigger.jav
a:542)
quote:

> at

sample10.contentspots.GetOffersByType.getRuleContent(GetOffersByType.java:28
)
quote:

> at org.apache.jsp._doView._jspService(_doView.java:183)
> at

com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java(Com
piled Code))
quote:

> at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
> at

com.ibm.ws.webcontainer.jsp.servlet.JspServlet$JspServletWrapper.service(Jsp
Servlet.java(Compiled Code))
quote:

> at

com.ibm.ws.webcontainer.jsp.servlet.JspServlet.serviceJspFile(JspServlet.jav
a(Compiled Code))
quote:

>
> ---------------------------------------
>
> Please if someone can help out in pointing the problem.
>
> Thanks
>
>
>



qibm

2004-01-29, 10:33 pm

It surely does solve the problem.

But later I enabled security and we are using Active Directory (LDAP). After doing this I am getting a errors while Publishing - the files are published OK, only thr Rules publish gives error.

Below is the error :

[7/27/04 14:56:44:151 GMT+05:30] 36bc6573 SecurityColla A SECJ0053E: Authorization failed for /UNAUTHENTICATED while invoking (Bean)brbeans/PznEJB/RuleFolder createRule(int,java.lang.String):1 securityName: /UNAUTHENTICATED;accessID: UNAUTHENTICATED is no
t granted any of the required roles: PznRuntimeAdministrationRole PznPublisherRole DenyAllRole

[7/27/04 14:56:44:161 GMT+05:30] 36bc6573 ExceptionUtil E CNTR0019E: Non-application exception occurred while processing method "createRule". Exception data: com.ibm.websphere.csi.CSIException: SECJ0053E: Authorization failed for /UNAUTHENTICATED while in
voking (Bean)brbeans/PznEJB/RuleFolder createRule(int,java.lang.String):1 securityName: /UNAUTHENTICATED;accessID: UNAUTHENTICATED is not granted any of the required roles:
PznRuntimeAdministrationRole PznPublisherRole DenyAllRole
at com.ibm.ws.security.core.SecurityCollaborator. performAuthorization(SecurityCollaborato
r.java(Compiled Code))
at com.ibm.ws.security.core.EJSSecurityCollaborator.preInvoke(EJSSecurityCollaborator.java(Compiled Code))

--------------------------------

Do we need to add roles like PznRuntimeAdministrationRole , PznPublisherRole in some place after enabling Security.

Thanks
CC

2004-04-03, 8:33 am

What application are you publishing to? PersAdmin, Sample10 etc...?


"qibm" <hi_techserv@yahoo.com> wrote in message
news:1171378924.1075461915834.JavaMail.wasadmin@swg3ws006...
> It surely does solve the problem.
>
> But later I enabled security and we are using Active Directory (LDAP).
After doing this I am getting a errors while Publishing - the files are
published OK, only thr Rules publish gives error.
>
> Below is the error :
>
> [7/27/04 14:56:44:151 GMT+05:30] 36bc6573 SecurityColla A SECJ0053E:
Authorization failed for /UNAUTHENTICATED while invoking
(Bean)brbeans/PznEJB/RuleFolder createRule(int,java.lang.String):1
securityName: /UNAUTHENTICATED;accessID: UNAUTHENTICATED is not granted any
of the required roles: PznRuntimeAdministrationRole PznPublisherRole
DenyAllRole
>
> [7/27/04 14:56:44:161 GMT+05:30] 36bc6573 ExceptionUtil E CNTR0019E:
Non-application exception occurred while processing method "createRule".
Exception data: com.ibm.websphere.csi.CSIException: SECJ0053E: Authorization
failed for /UNAUTHENTICATED while invoking (Bean)brbeans/PznEJB/RuleFolder
createRule(int,java.lang.String):1 securityName: /UNAUTHENTICATED;accessID:
UNAUTHENTICATED is not granted any of the required roles:
> PznRuntimeAdministrationRole PznPublisherRole DenyAllRole
> at
com.ibm.ws.security.core.SecurityCollaborator.performAuthorization(SecurityC
ollaborator.java(Compiled Code))
> at
com.ibm.ws.security.core.EJSSecurityCollaborator.preInvoke(EJSSecurityCollab
orator.java(Compiled Code))
>
> --------------------------------
>
> Do we need to add roles like PznRuntimeAdministrationRole ,
PznPublisherRole in some place after enabling Security.
>
> Thanks


Koala

2004-07-30, 2:22 am

I have the same error, and i'll be very thankful if you describe, how you solved this problem.
Thanks.
Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com