You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Shah Amit <am...@hotmail.com> on 2005/11/10 15:49:31 UTC
J2 - Any DB Changes since M3 ?
Hi all,
Just wondering if there were any DB changes since M3 in the latest jetspeed
in svn head ... I am trying to run new jetspeed against the M3 db, but
getting some a0.column_value not found exception ...
Any suggestions ? I can't just drop my DB and flush it with new one because
I have tons of other stuff created on that DB :-(
Thanks,
Amit
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
RE: J2 - Any DB Changes since M3 ?
Posted by Shah Amit <am...@hotmail.com>.
Hi all ...
Sorry to ask again :-( But any suggestions ...
----Original Message Follows----
From: "Shah Amit" <am...@hotmail.com>
Reply-To: "Jetspeed Users List" <je...@portals.apache.org>
To: jetspeed-user@portals.apache.org
Subject: RE: J2 - Any DB Changes since M3 ?
Date: Thu, 10 Nov 2005 12:01:41 -0500
Thanks a lot people for your help ! The Jira list is thorough and I have
passed that error. However, now I have two issues.
1. I constantly get the following exception on my console --
Batch entry 0 INSERT INTO PAGE_STATISTICS VALUES( was aborted. Call
getNextException() to see the cause.
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:107)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
at
org.apache.jetspeed.statistics.impl.BatchedStatistics.flush(BatchedStatistics.java:168)
at
org.apache.jetspeed.statistics.impl.BatchedStatistics.checkAndDoFlush(BatchedStatistics.java:81)
at
org.apache.jetspeed.statistics.impl.BatchedStatistics.run(BatchedStatistics.java:127)
at java.lang.Thread.run(Thread.java:534)
It just keeps scrolling constantly.
2. I cannot login. When I try to login, I get following error on the browser
--
javax.servlet.ServletException: Fatal error encountered while processing
portal request: org.apache.jetspeed.pipeline.PipelineException:
org.apache.jetspeed.pipeline.PipelineException:
org.apache.jetspeed.pipeline.PipelineException:
org.apache.jetspeed.profiler.ProfilerException: Couldn't find any profiling
rules including default rule for principal admin
org.apache.jetspeed.engine.JetspeedServlet.doGet(JetspeedServlet.java:235)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
org.apache.jetspeed.pipeline.PipelineException:
org.apache.jetspeed.pipeline.PipelineException:
org.apache.jetspeed.pipeline.PipelineException:
org.apache.jetspeed.profiler.ProfilerException: Couldn't find any profiling
rules including default rule for principal admin
org.apache.jetspeed.security.impl.PasswordCredentialValveImpl.invoke(PasswordCredentialValveImpl.java:153)
org.apache.jetspeed.pipeline.JetspeedPipeline.invokeNext(JetspeedPipeline.java:203)
org.apache.jetspeed.localization.impl.LocalizationValveImpl.invoke(LocalizationValveImpl.java:168)
org.apache.jetspeed.pipeline.JetspeedPipeline.invokeNext(JetspeedPipeline.java:203)
org.apache.jetspeed.security.impl.AbstractSecurityValve$1.run(AbstractSecurityValve.java:117)
java.security.AccessController.doPrivileged(Native Method)
javax.security.auth.Subject.doAsPrivileged(Subject.java:437)
org.apache.jetspeed.security.impl.AbstractSecurityValve.invoke(AbstractSecurityValve.java:111)
org.apache.jetspeed.pipeline.JetspeedPipeline.invokeNext(JetspeedPipeline.java:203)
org.apache.jetspeed.container.url.impl.PortalURLValveImpl.invoke(PortalURLValveImpl.java:55)
org.apache.jetspeed.pipeline.JetspeedPipeline.invokeNext(JetspeedPipeline.java:203)
org.apache.jetspeed.capabilities.impl.CapabilityValveImpl.invoke(CapabilityValveImpl.java:128)
org.apache.jetspeed.pipeline.JetspeedPipeline.invokeNext(JetspeedPipeline.java:203)
org.apache.jetspeed.pipeline.JetspeedPipeline.invoke(JetspeedPipeline.java:185)
org.apache.jetspeed.engine.JetspeedEngine.service(JetspeedEngine.java:230)
org.apache.jetspeed.engine.JetspeedServlet.doGet(JetspeedServlet.java:226)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
Thanks,
Amit
----Original Message Follows----
From: David Le Strat <dl...@yahoo.com>
Reply-To: "Jetspeed Users List" <je...@portals.apache.org>
To: Jetspeed Users List <je...@portals.apache.org>
Subject: RE: J2 - Any DB Changes since M3 ?
Date: Thu, 10 Nov 2005 07:16:09 -0800 (PST)
Amit,
The following issue in Jira has the detail of the
changes that were performed:
http://issues.apache.org/jira/browse/JS2-318
Regards,
David Le Strat
--- Shah Amit <am...@hotmail.com> wrote:
> Hi Randy,
>
> Thanks for the reply ! Tried those changes, but
> still getting the same
> problem ... I noticed a few other tables with column
> name "value". Is it
> that _all_ of those were changed to column_value ?
> :-(
>
>
>
> ----Original Message Follows----
> From: "Scott T Weaver"
> <sc...@binary-designs.net>
> Reply-To: "Jetspeed Users List"
> <je...@portals.apache.org>
> To: "'Jetspeed Users List'"
> <je...@portals.apache.org>
> Subject: RE: J2 - Any DB Changes since M3 ?
> Date: Thu, 10 Nov 2005 09:58:14 -0500
>
> Hi Amit,
>
> I was just fixing those myself as I am upgrading our
> deployment servers to
> M4. Here are the tables that need to change from
> "VALUE" to "COLUMN_VALUE"
>
> Affected Tables:
> PA_METADATA_FIELDS
> RULE_CRITERION
> SECURITY_CREDENTIAL
>
> HTH,
> -Scott
>
> > -----Original Message-----
> > From: Shah Amit [mailto:amit_shah25@hotmail.com]
> > Sent: Thursday, November 10, 2005 9:50 AM
> > To: jetspeed-user@jakarta.apache.org
> > Subject: J2 - Any DB Changes since M3 ?
> >
> > Hi all,
> >
> > Just wondering if there were any DB changes since
> M3 in the latest
> > jetspeed
> > in svn head ... I am trying to run new jetspeed
> against the M3 db, but
> > getting some a0.column_value not found exception
> ...
> >
> > Any suggestions ? I can't just drop my DB and
> flush it with new one
> > because
> > I have tons of other stuff created on that DB :-(
> >
> > Thanks,
> > Amit
> >
> >
> >
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> jetspeed-user-unsubscribe@portals.apache.org
> > For additional commands, e-mail:
> jetspeed-user-help@portals.apache.org
>
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail:
> jetspeed-user-help@portals.apache.org
>
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail:
> jetspeed-user-help@portals.apache.org
>
>
________________________
David Le Strat
Blogging @ http://dlsthoughts.blogspot.com
__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
RE: J2 - Any DB Changes since M3 ?
Posted by Shah Amit <am...@hotmail.com>.
Thanks a lot people for your help ! The Jira list is thorough and I have
passed that error. However, now I have two issues.
1. I constantly get the following exception on my console --
Batch entry 0 INSERT INTO PAGE_STATISTICS VALUES( was aborted. Call
getNextException() to see the cause.
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:107)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
at
org.apache.jetspeed.statistics.impl.BatchedStatistics.flush(BatchedStatistics.java:168)
at
org.apache.jetspeed.statistics.impl.BatchedStatistics.checkAndDoFlush(BatchedStatistics.java:81)
at
org.apache.jetspeed.statistics.impl.BatchedStatistics.run(BatchedStatistics.java:127)
at java.lang.Thread.run(Thread.java:534)
It just keeps scrolling constantly.
2. I cannot login. When I try to login, I get following error on the browser
--
javax.servlet.ServletException: Fatal error encountered while processing
portal request: org.apache.jetspeed.pipeline.PipelineException:
org.apache.jetspeed.pipeline.PipelineException:
org.apache.jetspeed.pipeline.PipelineException:
org.apache.jetspeed.profiler.ProfilerException: Couldn't find any profiling
rules including default rule for principal admin
org.apache.jetspeed.engine.JetspeedServlet.doGet(JetspeedServlet.java:235)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
org.apache.jetspeed.pipeline.PipelineException:
org.apache.jetspeed.pipeline.PipelineException:
org.apache.jetspeed.pipeline.PipelineException:
org.apache.jetspeed.profiler.ProfilerException: Couldn't find any profiling
rules including default rule for principal admin
org.apache.jetspeed.security.impl.PasswordCredentialValveImpl.invoke(PasswordCredentialValveImpl.java:153)
org.apache.jetspeed.pipeline.JetspeedPipeline.invokeNext(JetspeedPipeline.java:203)
org.apache.jetspeed.localization.impl.LocalizationValveImpl.invoke(LocalizationValveImpl.java:168)
org.apache.jetspeed.pipeline.JetspeedPipeline.invokeNext(JetspeedPipeline.java:203)
org.apache.jetspeed.security.impl.AbstractSecurityValve$1.run(AbstractSecurityValve.java:117)
java.security.AccessController.doPrivileged(Native Method)
javax.security.auth.Subject.doAsPrivileged(Subject.java:437)
org.apache.jetspeed.security.impl.AbstractSecurityValve.invoke(AbstractSecurityValve.java:111)
org.apache.jetspeed.pipeline.JetspeedPipeline.invokeNext(JetspeedPipeline.java:203)
org.apache.jetspeed.container.url.impl.PortalURLValveImpl.invoke(PortalURLValveImpl.java:55)
org.apache.jetspeed.pipeline.JetspeedPipeline.invokeNext(JetspeedPipeline.java:203)
org.apache.jetspeed.capabilities.impl.CapabilityValveImpl.invoke(CapabilityValveImpl.java:128)
org.apache.jetspeed.pipeline.JetspeedPipeline.invokeNext(JetspeedPipeline.java:203)
org.apache.jetspeed.pipeline.JetspeedPipeline.invoke(JetspeedPipeline.java:185)
org.apache.jetspeed.engine.JetspeedEngine.service(JetspeedEngine.java:230)
org.apache.jetspeed.engine.JetspeedServlet.doGet(JetspeedServlet.java:226)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
Thanks,
Amit
----Original Message Follows----
From: David Le Strat <dl...@yahoo.com>
Reply-To: "Jetspeed Users List" <je...@portals.apache.org>
To: Jetspeed Users List <je...@portals.apache.org>
Subject: RE: J2 - Any DB Changes since M3 ?
Date: Thu, 10 Nov 2005 07:16:09 -0800 (PST)
Amit,
The following issue in Jira has the detail of the
changes that were performed:
http://issues.apache.org/jira/browse/JS2-318
Regards,
David Le Strat
--- Shah Amit <am...@hotmail.com> wrote:
> Hi Randy,
>
> Thanks for the reply ! Tried those changes, but
> still getting the same
> problem ... I noticed a few other tables with column
> name "value". Is it
> that _all_ of those were changed to column_value ?
> :-(
>
>
>
> ----Original Message Follows----
> From: "Scott T Weaver"
> <sc...@binary-designs.net>
> Reply-To: "Jetspeed Users List"
> <je...@portals.apache.org>
> To: "'Jetspeed Users List'"
> <je...@portals.apache.org>
> Subject: RE: J2 - Any DB Changes since M3 ?
> Date: Thu, 10 Nov 2005 09:58:14 -0500
>
> Hi Amit,
>
> I was just fixing those myself as I am upgrading our
> deployment servers to
> M4. Here are the tables that need to change from
> "VALUE" to "COLUMN_VALUE"
>
> Affected Tables:
> PA_METADATA_FIELDS
> RULE_CRITERION
> SECURITY_CREDENTIAL
>
> HTH,
> -Scott
>
> > -----Original Message-----
> > From: Shah Amit [mailto:amit_shah25@hotmail.com]
> > Sent: Thursday, November 10, 2005 9:50 AM
> > To: jetspeed-user@jakarta.apache.org
> > Subject: J2 - Any DB Changes since M3 ?
> >
> > Hi all,
> >
> > Just wondering if there were any DB changes since
> M3 in the latest
> > jetspeed
> > in svn head ... I am trying to run new jetspeed
> against the M3 db, but
> > getting some a0.column_value not found exception
> ...
> >
> > Any suggestions ? I can't just drop my DB and
> flush it with new one
> > because
> > I have tons of other stuff created on that DB :-(
> >
> > Thanks,
> > Amit
> >
> >
> >
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> jetspeed-user-unsubscribe@portals.apache.org
> > For additional commands, e-mail:
> jetspeed-user-help@portals.apache.org
>
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail:
> jetspeed-user-help@portals.apache.org
>
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail:
> jetspeed-user-help@portals.apache.org
>
>
________________________
David Le Strat
Blogging @ http://dlsthoughts.blogspot.com
__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
RE: J2 - Any DB Changes since M3 ?
Posted by David Le Strat <dl...@yahoo.com>.
Amit,
The following issue in Jira has the detail of the
changes that were performed:
http://issues.apache.org/jira/browse/JS2-318
Regards,
David Le Strat
--- Shah Amit <am...@hotmail.com> wrote:
> Hi Randy,
>
> Thanks for the reply ! Tried those changes, but
> still getting the same
> problem ... I noticed a few other tables with column
> name "value". Is it
> that _all_ of those were changed to column_value ?
> :-(
>
>
>
> ----Original Message Follows----
> From: "Scott T Weaver"
> <sc...@binary-designs.net>
> Reply-To: "Jetspeed Users List"
> <je...@portals.apache.org>
> To: "'Jetspeed Users List'"
> <je...@portals.apache.org>
> Subject: RE: J2 - Any DB Changes since M3 ?
> Date: Thu, 10 Nov 2005 09:58:14 -0500
>
> Hi Amit,
>
> I was just fixing those myself as I am upgrading our
> deployment servers to
> M4. Here are the tables that need to change from
> "VALUE" to "COLUMN_VALUE"
>
> Affected Tables:
> PA_METADATA_FIELDS
> RULE_CRITERION
> SECURITY_CREDENTIAL
>
> HTH,
> -Scott
>
> > -----Original Message-----
> > From: Shah Amit [mailto:amit_shah25@hotmail.com]
> > Sent: Thursday, November 10, 2005 9:50 AM
> > To: jetspeed-user@jakarta.apache.org
> > Subject: J2 - Any DB Changes since M3 ?
> >
> > Hi all,
> >
> > Just wondering if there were any DB changes since
> M3 in the latest
> > jetspeed
> > in svn head ... I am trying to run new jetspeed
> against the M3 db, but
> > getting some a0.column_value not found exception
> ...
> >
> > Any suggestions ? I can't just drop my DB and
> flush it with new one
> > because
> > I have tons of other stuff created on that DB :-(
> >
> > Thanks,
> > Amit
> >
> >
> >
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> jetspeed-user-unsubscribe@portals.apache.org
> > For additional commands, e-mail:
> jetspeed-user-help@portals.apache.org
>
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail:
> jetspeed-user-help@portals.apache.org
>
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail:
> jetspeed-user-help@portals.apache.org
>
>
________________________
David Le Strat
Blogging @ http://dlsthoughts.blogspot.com
__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
RE: J2 - Any DB Changes since M3 ?
Posted by Shah Amit <am...@hotmail.com>.
Hi Randy,
Thanks for the reply ! Tried those changes, but still getting the same
problem ... I noticed a few other tables with column name "value". Is it
that _all_ of those were changed to column_value ? :-(
----Original Message Follows----
From: "Scott T Weaver" <sc...@binary-designs.net>
Reply-To: "Jetspeed Users List" <je...@portals.apache.org>
To: "'Jetspeed Users List'" <je...@portals.apache.org>
Subject: RE: J2 - Any DB Changes since M3 ?
Date: Thu, 10 Nov 2005 09:58:14 -0500
Hi Amit,
I was just fixing those myself as I am upgrading our deployment servers to
M4. Here are the tables that need to change from "VALUE" to "COLUMN_VALUE"
Affected Tables:
PA_METADATA_FIELDS
RULE_CRITERION
SECURITY_CREDENTIAL
HTH,
-Scott
> -----Original Message-----
> From: Shah Amit [mailto:amit_shah25@hotmail.com]
> Sent: Thursday, November 10, 2005 9:50 AM
> To: jetspeed-user@jakarta.apache.org
> Subject: J2 - Any DB Changes since M3 ?
>
> Hi all,
>
> Just wondering if there were any DB changes since M3 in the latest
> jetspeed
> in svn head ... I am trying to run new jetspeed against the M3 db, but
> getting some a0.column_value not found exception ...
>
> Any suggestions ? I can't just drop my DB and flush it with new one
> because
> I have tons of other stuff created on that DB :-(
>
> Thanks,
> Amit
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
RE: J2 - Any DB Changes since M3 ?
Posted by Scott T Weaver <sc...@binary-designs.net>.
Hi Amit,
I was just fixing those myself as I am upgrading our deployment servers to
M4. Here are the tables that need to change from "VALUE" to "COLUMN_VALUE"
Affected Tables:
PA_METADATA_FIELDS
RULE_CRITERION
SECURITY_CREDENTIAL
HTH,
-Scott
> -----Original Message-----
> From: Shah Amit [mailto:amit_shah25@hotmail.com]
> Sent: Thursday, November 10, 2005 9:50 AM
> To: jetspeed-user@jakarta.apache.org
> Subject: J2 - Any DB Changes since M3 ?
>
> Hi all,
>
> Just wondering if there were any DB changes since M3 in the latest
> jetspeed
> in svn head ... I am trying to run new jetspeed against the M3 db, but
> getting some a0.column_value not found exception ...
>
> Any suggestions ? I can't just drop my DB and flush it with new one
> because
> I have tons of other stuff created on that DB :-(
>
> Thanks,
> Amit
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org