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

Unsuccessful schema statement- creating tables in Oracle

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.5.0
    • Fix Version/s: 2.5.0
    • Component/s: Sitestats
    • Labels:
      None
    • Environment:
      Oracle 9, 10g
    • Previous Issue Keys:
      STAT-4

      Description

      When starting tomcat I receive the following errors:

      INFO: Updating database schema for Hibernate SessionFactory (2006-07-18 15:31:41
      ,631 main_org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBe
      an)
      WARN: Unsuccessful schema statement: create table SST_SITEACTIVITY (ID number(19
      ,0) not null, SITE_ID varchar2(99) not null, DATE date not null, EVENT_ID varcha
      r2(32) not null, COUNT number(19,0) not null, primary key (ID)) (2006-07-18 15:3
      1:44,509 main_org.sakaiproject.springframework.orm.hibernate.AddableSessionFacto
      ryBean)
      java.sql.SQLException: ORA-00904: : invalid identifier

      These affect the following tables: (Column fields in parenthes)

      SST_SITEACTIVITY (DATE, COUNT)
      SST_EVENTS (DATE, COUNT)
      SST_SITEVISITS (DATE)
      SST_RESOURCES (DATE, COUNT)
      SST_SITEACTIVITY (DATE, COUNT)

      How can I help with Oracle?

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                nfernandes Nuno Fernandes (Inactive)
                Reporter:
                jpeterso2413 Jeremy Peterson (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code