Wb Connector Error

Hello -

W Recently we began getting the following error when creating Web connector Portlets. Has anyone seen this beofre or know what the cause or solution is. Any help would be much appreciated.

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Servlet execution threw an exception	com.vignette.portal.website.admin.internal.control.ConsoleAuthorizationFilter.httpDoFilter(ConsoleAuthorizationFilter.java:133)	com.vignette.portal.website.admin.internal.control.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:61)	com.vignette.portal.website.admin.internal.control.AdminContextFilter.httpDoFilter(AdminContextFilter.java:65)	com.vignette.portal.website.admin.internal.control.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:61)	com.vignette.portal.website.admin.internal.control.LegacySiteConsoleURLFilter.httpDoFilter(LegacySiteConsoleURLFilter.java:94)	com.vignette.portal.website.admin.internal.control.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:61)	com.vignette.portal.website.admin.internal.control.FailoverManagementFilter.httpDoFilter(FailoverManagementFilter.java:62)	com.vignette.portal.website.admin.internal.control.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:61)	com.vignette.portal.website.enduser.filters.AuthenticationFilter.doFilter(AuthenticationFilter.java:42)	com.vignette.portal.website.admin.internal.control.InitFrameworkFilter.httpDoFilter(InitFrameworkFilter.java:35)	com.vignette.portal.website.admin.internal.control.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:61)	com.vignette.portal.website.admin.internal.control.MultipartFilter.httpDoFilter(MultipartFilter.java:33)	com.vignette.portal.website.admin.internal.control.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:61)	com.vignette.portal.website.internal.StartupProtectionFilter.doFilterSingleInvocation(StartupProtectionFilter.java:100)	com.vignette.portal.website.internal.SingleInvocationFilter.doFilter(SingleInvocationFilter.java:52)	com.vignette.portal.website.internal.EnvironmentalWrapperFilter.doFilterSingleInvocation(EnvironmentalWrapperFilter.java:45)	com.vignette.portal.website.internal.SingleInvocationFilter.doFilter(SingleInvocationFilter.java:52)	org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

root cause

com.epicentric.jdbc.internal.ConnectionError: Connection Failure Detected  (Original message=ORA-01407: cannot update ("JOEVIG"."PORTALBEANS"."CONTENTS") to NULL; SQLState=72000; Error code=1407)

 root cause

java.sql.SQLException: ORA-01407: cannot update ("JOEVIG"."PORTALBEANS"."CONTENTS") to NULL

Find more posts tagged with

Comments

Venkata_Kambam

Looks like something from database side could be problem. Can you check any DB locks either for getting connection or updating Portal tables.

Regards,

Lokesh

From: eLink Entry: Open Text Portal Forum[mailto:vignetteportal@elinkkc.opentext.com]
Sent: Wednesday, October 27, 2010 7:59 AM
To: eLink Recipient
Subject: Wb Connector Error

Wb Connector Error

Posted by blewinsk@hq.nasa.gov (Lewinski, Brett) On 2010/10/26 22:24

Hello -

W Recently we began getting the following error when creating Web connector Portlets. Has anyone seen this beofre or know what the cause or solution is. Any help would be much appreciated.

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Servlet execution threw an exception

        com.vignette.portal.website.admin.internal.control.ConsoleAuthorizationFilter.httpDoFilter(ConsoleAuthorizationFilter.java:133)

        com.vignette.portal.website.admin.internal.control.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:61)

        com.vignette.portal.website.admin.internal.control.AdminContextFilter.httpDoFilter(AdminContextFilter.java:65)

        com.vignette.portal.website.admin.internal.control.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:61)

        com.vignette.portal.website.admin.internal.control.LegacySiteConsoleURLFilter.httpDoFilter(LegacySiteConsoleURLFilter.java:94)

        com.vignette.portal.website.admin.internal.control.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:61)

        com.vignette.portal.website.admin.internal.control.FailoverManagementFilter.httpDoFilter(FailoverManagementFilter.java:62)

        com.vignette.portal.website.admin.internal.control.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:61)

        com.vignette.portal.website.enduser.filters.AuthenticationFilter.doFilter(AuthenticationFilter.java:42)

        com.vignette.portal.website.admin.internal.control.InitFrameworkFilter.httpDoFilter(InitFrameworkFilter.java:35)

        com.vignette.portal.website.admin.internal.control.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:61)

        com.vignette.portal.website.admin.internal.control.MultipartFilter.httpDoFilter(MultipartFilter.java:33)

        com.vignette.portal.website.admin.internal.control.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:61)

        com.vignette.portal.website.internal.StartupProtectionFilter.doFilterSingleInvocation(StartupProtectionFilter.java:100)

        com.vignette.portal.website.internal.SingleInvocationFilter.doFilter(SingleInvocationFilter.java:52)

        com.vignette.portal.website.internal.EnvironmentalWrapperFilter.doFilterSingleInvocation(EnvironmentalWrapperFilter.java:45)

        com.vignette.portal.website.internal.SingleInvocationFilter.doFilter(SingleInvocationFilter.java:52)

        org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

root cause

com.epicentric.jdbc.internal.ConnectionError: Connection Failure Detected  (Original message=ORA-01407: cannot update ("JOEVIG"."PORTALBEANS"."CONTENTS") to NULL

; SQLState=72000; Error code=1407)

 root cause

java.sql.SQLException: ORA-01407: cannot update ("JOEVIG"."PORTALBEANS"."CONTENTS") to NULL

[To post a comment, use the normal reply function]
Forum:	Open Text Portal Forum
Livelink Server:	knowledge-wlweb01

Brett_T_Lewinski

Thanks Lokesh for the quick reply.

We checked the DB and there are no locks on any of the tables. I bounced the Vignette Jboss Server and when I try to create a Web Connector I get the following 2 errors:

Version:1.0 StartHTML:0000000149 EndHTML:0000000523 StartFragment:0000000199 EndFragment:0000000489 StartSelection:0000000199 EndSelection:0000000489 com.epicentric.jdbc.internal.ConnectionError: Connection Failure Detected (Original message=ORA-01460: unimplemented or unreasonable conversion requested
; SQLState=72000; Error code=1460)

and

Version:1.0 StartHTML:0000000149 EndHTML:0000000419 StartFragment:0000000199 EndFragment:0000000385 StartSelection:0000000199 EndSelection:0000000385 java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested

These 2 are different than the first errors 2 I saw (listed above). This is very strange as this was all working a few days ago. Any other ideas or insight woudl be much appreciated.

Thanks

Venkata_Kambam

To identify the issue portal logs are required. Pleaseraise a VOLSS ticket and attach portal logs to ticket in DEBUG mode.

Thanks & Regards,

Lokesh

From: eLink Entry: Open Text Portal Forum[mailto:vignetteportal@elinkkc.opentext.com]
Sent: Wednesday, October 27, 2010 6:16 PM
To: eLink Recipient
Subject: RE Web Connector Error

RE Web Connector Error

Posted by blewinsk@hq.nasa.gov (Lewinski, Brett) On 2010/10/27 08:41

Thanks Lokesh for the quick reply.

We checked the DB and there are no locks on any of the tables. I bounced the Vignette Jboss Server and when I try to create a Web Connector I get the following 2 errors:

Version:1.0 StartHTML:0000000149 EndHTML:0000000523 StartFragment:0000000199 EndFragment:0000000489 StartSelection:0000000199 EndSelection:0000000489 com.epicentric.jdbc.internal.ConnectionError: Connection Failure Detected (Original message=ORA-01460: unimplemented or unreasonable conversion requested
; SQLState=72000; Error code=1460)

and

Version:1.0 StartHTML:0000000149 EndHTML:0000000419 StartFragment:0000000199 EndFragment:0000000385 StartSelection:0000000199 EndSelection:0000000385 java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested

These 2 are different than the first errors 2 I saw (listed above). This is very strange as this was all working a few days ago. Any other ideas or insight woudl be much appreciated.

Thanks

[To post a comment, use the normal reply function]
Topic:	Wb Connector Error
Forum:	Open Text Portal Forum
Livelink Server:	knowledge-wlweb01