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

Database error when importing osp matrix



    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 2.4.x, 2.5.x, 2.6.x
    • Fix Version/s: None
    • Component/s: OSP: Wizards - Matrix
    • Labels:
    • Environment:
      Oracle 10.2 database environment


      We downloaded the SOE Proficiency Matrix (created in OSP 2.4) from the OSP Community Library, but when we went to import the matrix into our 2.4 instance, we received the following error:

      org.sakaiproject.portal.api.PortalHandlerException: org.sakaiproject.tool.api.ToolException: Request processing failed; nested exception is org.sakaiproject.metaobj.shared.model.OspException: java.lang.RuntimeException: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute JDBC batch update; uncategorized SQLException for SQL [insert into metaobj_form_def (description, documentRoot, owner, created, modified, systemOnly, externalType, siteId, siteState, globalState, schemaData, instruction, schema_hash, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [99999]; error code [22295]; ORA-22295: cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement
      ; nested exception is java.sql.BatchUpdateException: ORA-22295: cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement

      According to Sean Keesler, who created the SOE prof. matrix, he used MySQL 4.1.20 as his database, but we are using Oracle 10.2. I was able to take the same matrix zip file and upload it successfully to a nightly test instance (it uses HSQL as its database). Our DBA took a look at the error and the table structure and it looks like the schemaData field may have been the cause of the issue.

      I am attaching a copy of the SOE Profiency Matrix zip file.

        Gliffy Diagrams





                • Assignee:
                  osp-jira OSP Jira Team (Inactive)
                  eckertd Dawn Eckert (Inactive)
                • Votes:
                  0 Vote for this issue
                  1 Start watching this issue


                  • Created:

                    Git Integration