[Spacewalk-list] channel data yields XML errors after upgrade

[Mikael Flood]

Sorry to bring this up again.

I am non the wiser unfortunately and the errors persists.

==> /var/log/tomcat6/catalina.out <==
2017-04-07 16:32:01,484 [TP-Processor2] WARN
org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 42703
2017-04-07 16:32:01,485 [TP-Processor2] ERROR
org.hibernate.util.JDBCExceptionReporter - ERROR: column
contentsou1_.ssl_ca_cert_id does not exist
  Position: 334
2017-04-07 16:32:01,489 [TP-Processor2] WARN
org.apache.struts.action.RequestProcessor - Unhandled Exception thrown:
class org.hibernate.exception.SQLGrammarException

Tried reverting postgres with backup database, and downgrade spacewalk to
2.5 without luck.


On 8 March 2017 at 11:00, Mikael Flood <thernx at gmail.com> wrote:

>
> Hello all!
>
> Sorry if this has been asked before.
>
> Having some problems after upgrading spacewalk from 2.5 to 2.6 by
> following instructions on the spacewalk wiki.
>
> Navigating to any channel under "manage software channels" by web
> interface results in "Internal Server Error"
>
> spacecmd softwarelist_details gives a more detailed error response:
> spacecmd {SSM:0}> softwarechannel_details test123
> ERROR: XML or text declaration not at start of entity: line 1, column 76
>
> Below follows some output from /var/log/tomcat6/catalina.out
> 2017-03-08 10:55:22,462 [TP-Processor11] WARN
> org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 42703
> 2017-03-08 10:55:22,462 [TP-Processor11] ERROR
> org.hibernate.util.JDBCExceptionReporter - ERROR: column
> contentsou1_.ssl_ca_cert_id does not exist
>   Position: 334
> 2017-03-08 10:55:22,462 [TP-Processor11] WARN
> org.apache.struts.action.RequestProcessor - Unhandled Exception thrown:
> class org.hibernate.exception.SQLGrammarException
> 2017-03-08 10:55:22,462 [TP-Processor11] ERROR
> com.redhat.rhn.frontend.servlets.SessionFilter - Error during
> transaction. Rolling back
> javax.servlet.ServletException: org.hibernate.exception.SQLGrammarException:
> could not initialize a collection: [com.redhat.rhn.domain.channel
> .Channel.sources#180]
>     at org.apache.struts.action.RequestProcessor.processException(R
> equestProcessor.java:520)
>     at org.apache.struts.action.RequestProcessor.processActionPerfo
> rm(RequestProcessor.java:427)
>     at org.apache.struts.action.RequestProcessor.process(RequestPro
> cessor.java:228)
>     at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(
> RhnRequestProcessor.java:105)
>     at org.apache.struts.action.ActionServlet.process(ActionServlet
> .java:1913)
>     at org.apache.struts.action.ActionServlet.doGet(ActionServlet.
> java:449)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
>     at org.apache.catalina.core.ApplicationFilterChain.internalDoFi
> lter(ApplicationFilterChain.java:290)
>     at org.apache.catalina.core.ApplicationFilterChain.doFilter(App
> licationFilterChain.java:206)
>
> Any help appreciated!
>
> Thanks in advance!
> --
> //Yours sincerely Mikael Flood
>



-- 
//Yours sincerely Mikael Flood
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20170407/f41ed0cb/attachment.htm>