Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-14995

db2 throwing error creating dw_wizard_page_def_add_forms during warehouse init

    XMLWordPrintable

    Details

      Description

      09:23:29,946 ERROR DbLoader.java:525 DbLoader:525 - error creating table with this sql:
      CREATE TABLE dw_wizard_page_def_add_forms
      (
      wizard_page_def_id VARCHAR(36),
      form_def_id VARCHAR(36),
      seq_num INTEGER,
      PRIMARY KEY (wizard_page_def_id, form_def_id)
      )

      09:23:29,948 ERROR DbLoader.java:526 DbLoader:526 -
      com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -542, SQLSTATE: 42831, SQLERRMC: WIZARD_PAGE_DEF_ID
      at com.ibm.db2.jcc.b.ig.e(ig.java:1594)
      at com.ibm.db2.jcc.b.ig.b(ig.java:1158)
      at com.ibm.db2.jcc.c.gb.h(gb.java:217)
      at com.ibm.db2.jcc.c.gb.b(gb.java:46)
      at com.ibm.db2.jcc.c.w.b(w.java:40)
      at com.ibm.db2.jcc.c.vb.e(vb.java:118)
      at com.ibm.db2.jcc.b.ig.m(ig.java:1153)
      at com.ibm.db2.jcc.b.ig.a(ig.java:1868)
      at com.ibm.db2.jcc.b.ig.c(ig.java:520)
      at com.ibm.db2.jcc.b.ig.executeUpdate(ig.java:504)
      at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
      at org.sakaiproject.warehouse.util.db.DbLoader.createTable(DbLoader.java:523)
      at org.sakaiproject.warehouse.util.db.GenericTableHandler.endElement(GenericTableHandler.java:150)
      at com.sun.org.apache.xml.internal.serializer.ToXMLSAXHandler.endElement(ToXMLSAXHandler.java:262)
      at com.sun.org.apache.xml.internal.serializer.ToXMLSAXHandler.endElement(ToXMLSAXHandler.java:555)
      at GregorSamsa.template$dot$2()
      at GregorSamsa.applyTemplates2()
      at GregorSamsa.template$dot$0()
      at GregorSamsa.applyTemplates()
      at GregorSamsa.transform()
      at com.sun.org.apache.xalan.internal.xsltc.runtime.AbstractTranslet.transform(AbstractTranslet.java:594)
      at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:663)
      at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:300)
      at org.sakaiproject.warehouse.util.db.DbLoader.runLoader(DbLoader.java:223)
      at org.sakaiproject.warehouse.impl.BaseWarehouseTask.init(BaseWarehouseTask.java:98)
      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:585)
      at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1240)
      at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1205)
      at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1171)
      at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425)
      at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
      at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
      at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
      at org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:115)
      at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
      at org.sakaiproject.util.NoisierDefaultListableBeanFactory.preInstantiateSingletons(NoisierDefaultListableBeanFactory.java:74)
      at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)
      at org.sakaiproject.component.impl.SpringCompMgr.init(SpringCompMgr.java:146)
      at org.sakaiproject.component.cover.ComponentManager.getInstance(ComponentManager.java:68)
      at org.sakaiproject.component.cover.ComponentManager.get(ComponentManager.java:80)
      at org.sakaiproject.dav.DavServlet.init(DavServlet.java:488)
      at javax.servlet.GenericServlet.init(GenericServlet.java:211)
      at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
      at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932)
      at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3951)
      at org.apache.catalina.core.StandardContext.start(StandardContext.java:4225)
      at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
      at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
      at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
      at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:608)
      at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535)
      at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)
      at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
      at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
      at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
      at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
      at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
      at org.apache.catalina.core.StandardService.start(StandardService.java:450)
      at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
      at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
      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:585)
      at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
      at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
      09:23:31,058 INFO BaseWarehouseTask.java:89 WizardPageWarehouse

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                jbush John Bush
                Reporter:
                jbush John Bush
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code