java.lang.RuntimeException: data-import for ../uPortal-3-2-patches/build/export-2011-10-12/layout/jschraegle.layout failed

Apereo Issues | Bill Brown | 5 years ago
  1. 0

    Greetings: per an IRC thread, here is a trace of an import issue we are getting with our layout files. I think this trace is happening for many files: (this pastebin has the before and after of taking out "<dlm:position hidden="false" immutable="false" name="uocHome-lo:null" type="dlm:position" unremovable="false"/>" from the users layout file. http://pastebin.com/pQ5EV7Yi) [java] INFO [java] INFO [java] INFO Importing Data from: ../uPortal-3-2-patches/build/export-2011-10-12/layout/jschraegle.layout [java] INFO Initializing ExecutorService 'importExportThreadPool' [java] INFO Adding destruction callback singleton for bean 'scopedTarget.sessionAttributesOverridesMap' [java] INFO Looking up bean 'referenceEntitySearcher' in ApplicationContext due to context not yet being initialized [java] INFO Looking up bean 'cacheFactory' in ApplicationContext due to context not yet being initialized [java] WARN No layout node found for pathref: uocHome-lo:/layout/folder/folder[3] [java] WARN No layout node found for pathref: uocHome-lo:/layout/folder/folder[3]/folder[1] [java] WARN Invalid DLM PathRef, no delimiter: [java] WARN No layout node found for pathref: uocHome-lo:/layout/folder/folder[3]/folder[1]/channel[1] [java] Exception in thread "main" java.lang.RuntimeException: data-import for ../uPortal-3-2-patches/build/export-2011-10-12/layout/jschraegle.layout failed [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) [java] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) [java] at java.lang.reflect.Constructor.newInstance(Constructor.java:513) [java] at org.codehaus.groovy.reflection.CachedConstructor.invoke(CachedConstructor.java:77) [java] at org.codehaus.groovy.runtime.callsite.ConstructorSite$ConstructorSiteNoUnwrapNoCoerce.callConstructor(ConstructorSite.java:102) [java] at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstructor(CallSiteArray.java:54) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:182) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:194) [java] at upshell_1700142953.run(upshell_1700142953.groovy:13) [java] at groovy.lang.GroovyShell.runScriptOrMainOrTestOrRunnable(GroovyShell.java:266) [java] at groovy.lang.GroovyShell.run(GroovyShell.java:229) [java] at org.jasig.portal.shell.PortalShell.main(PortalShell.java:84) [java] Caused by: java.lang.RuntimeException: Unable to persist layout for user: jschraegle [java] at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.importLayout(RDBMDistributedLayoutStore.java:794) [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [java] at java.lang.reflect.Method.invoke(Method.java:597) [java] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) [java] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [java] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [java] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) [java] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [java] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [java] at $Proxy96.importLayout(Unknown Source) [java] at org.jasig.portal.io.xml.layout.LayoutImporter.importDataElement(LayoutImporter.java:44) [java] at org.jasig.portal.io.xml.crn.AbstractDom4jImporter.importData(AbstractDom4jImporter.java:86) [java] at org.jasig.portal.io.xml.crn.AbstractDom4jImporter.importData(AbstractDom4jImporter.java:53) [java] at org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importOrUpgradeData(JaxbPortalDataHandlerService.java:518) [java] at org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:481) [java] at org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:448) [java] at org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:426) [java] at org.jasig.portal.io.xml.IPortalDataHandlerService$importData.call(Unknown Source) [java] at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:42) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116) [java] at upshell_1700142953.run(upshell_1700142953.groovy:10) [java] ... 3 more [java] Caused by: org.springframework.dao.DataIntegrityViolationException: ConnectionCallback; SQL []; ORA-01400: cannot insert NULL into ("UNICON"."UP_LAYOUT_PARAM"."STRUCT_PARM_VAL") [java] ; nested exception is java.sql.SQLException: ORA-01400: cannot insert NULL into ("UNICON"."UP_LAYOUT_PARAM"."STRUCT_PARM_VAL") [java] [java] at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245) [java] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:348) [java] at org.jasig.portal.layout.simple.RDBMUserLayoutStore$11.doInTransaction(RDBMUserLayoutStore.java:1205) [java] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) [java] at org.jasig.portal.layout.simple.RDBMUserLayoutStore.setUserLayout(RDBMUserLayoutStore.java:1202) [java] at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.setUserLayout(RDBMDistributedLayoutStore.java:1432) [java] at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.importLayout(RDBMDistributedLayoutStore.java:790) [java] ... 26 more [java] Caused by: java.sql.SQLException: ORA-01400: cannot insert NULL into ("UNICON"."UP_LAYOUT_PARAM"."STRUCT_PARM_VAL") [java] [java] at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74) [java] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131) [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468) [java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) [java] at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.saveStructure(RDBMDistributedLayoutStore.java:1777) [java] at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.saveStructure(RDBMDistributedLayoutStore.java:1725) [java] at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.saveStructure(RDBMDistributedLayoutStore.java:1725) [java] at org.jasig.portal.layout.simple.RDBMUserLayoutStore$11$1.doInConnection(RDBMUserLayoutStore.java:1258) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:341) [java] ... 31 more [java] INFO Shutting down ExecutorService 'importExportThreadPool' [java] INFO Shutting down ExecutorService 'uPortalTaskExecutor' [copy] Copying 1 file to /home/billbrown/uportal-4.0.2/target BUILD FAILED /home/billbrown/uportal-4.0.2/build.xml:596: The following error occurred while executing this line: /home/billbrown/uportal-4.0.2/build.xml:424: The following error occurred while executing this line: /home/billbrown/uportal-4.0.2/build.xml:1356: The following error occurred while executing this line: /home/billbrown/uportal-4.0.2/build.xml:1329: The following error occurred while executing this line: /home/billbrown/uportal-4.0.2/build.xml:1332: The following error occurred while executing this line: /home/billbrown/uportal-4.0.2/build.xml:1359: The following error occurred while executing this line: /home/billbrown/uportal-4.0.2/build.xml:430: /home/billbrown/uportal-4.0.2/build.xml:433: Java returned: 1 Total time: 39 seconds billbrown@piglet:~/uportal-4.0.2$ more ../uPortal-3-2-patches/build/export-2011-10-12/layout/jschraegle.layout <layout xmlns:dlm="http://www.uportal.org/layout/dlm" script="classpath://org/ja sig/portal/io/import-layout_v3-2.crn" username="jschraegle"> <folder hidden="false" immutable="false" name="Root folder" type="root" unremovable="true"> <folder dlm:origin="uocHome-lo:/layout/folder/folder[3]" hidden="false" immutable="false" name="Home" type="regular" unremovable="false"> <folder dlm:origin="uocHome-lo:/layout/folder/folder[3]/folder[1]" hidden= "false" immutable="false" name="Column" type="regular" unremovable="false"> <dlm:positionSet hidden="false" immutable="false" name="" type="dlm:positionSet" unremovable="false"> <dlm:position hidden="false" immutable="false" name="uocHome-lo:/layout/folder/folder[3]/folder[1]/channel[1]" type="dlm:position" unremovable="false" fname="Announcements"/> <dlm:position hidden="false" immutable="false" name="uocHome-lo:null" type="dlm:position" unremovable="false"/> </dlm:positionSet> </folder> </folder> </folder> </layout> let me know if you need more information. Thanks for your help.

    Apereo Issues | 5 years ago | Bill Brown
    java.lang.RuntimeException: data-import for ../uPortal-3-2-patches/build/export-2011-10-12/layout/jschraegle.layout failed
  2. 0

    Greetings: per an IRC thread, here is a trace of an import issue we are getting with our layout files. I think this trace is happening for many files: (this pastebin has the before and after of taking out "<dlm:position hidden="false" immutable="false" name="uocHome-lo:null" type="dlm:position" unremovable="false"/>" from the users layout file. http://pastebin.com/pQ5EV7Yi) [java] INFO [java] INFO [java] INFO Importing Data from: ../uPortal-3-2-patches/build/export-2011-10-12/layout/jschraegle.layout [java] INFO Initializing ExecutorService 'importExportThreadPool' [java] INFO Adding destruction callback singleton for bean 'scopedTarget.sessionAttributesOverridesMap' [java] INFO Looking up bean 'referenceEntitySearcher' in ApplicationContext due to context not yet being initialized [java] INFO Looking up bean 'cacheFactory' in ApplicationContext due to context not yet being initialized [java] WARN No layout node found for pathref: uocHome-lo:/layout/folder/folder[3] [java] WARN No layout node found for pathref: uocHome-lo:/layout/folder/folder[3]/folder[1] [java] WARN Invalid DLM PathRef, no delimiter: [java] WARN No layout node found for pathref: uocHome-lo:/layout/folder/folder[3]/folder[1]/channel[1] [java] Exception in thread "main" java.lang.RuntimeException: data-import for ../uPortal-3-2-patches/build/export-2011-10-12/layout/jschraegle.layout failed [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) [java] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) [java] at java.lang.reflect.Constructor.newInstance(Constructor.java:513) [java] at org.codehaus.groovy.reflection.CachedConstructor.invoke(CachedConstructor.java:77) [java] at org.codehaus.groovy.runtime.callsite.ConstructorSite$ConstructorSiteNoUnwrapNoCoerce.callConstructor(ConstructorSite.java:102) [java] at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstructor(CallSiteArray.java:54) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:182) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:194) [java] at upshell_1700142953.run(upshell_1700142953.groovy:13) [java] at groovy.lang.GroovyShell.runScriptOrMainOrTestOrRunnable(GroovyShell.java:266) [java] at groovy.lang.GroovyShell.run(GroovyShell.java:229) [java] at org.jasig.portal.shell.PortalShell.main(PortalShell.java:84) [java] Caused by: java.lang.RuntimeException: Unable to persist layout for user: jschraegle [java] at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.importLayout(RDBMDistributedLayoutStore.java:794) [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [java] at java.lang.reflect.Method.invoke(Method.java:597) [java] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) [java] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [java] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [java] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) [java] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [java] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [java] at $Proxy96.importLayout(Unknown Source) [java] at org.jasig.portal.io.xml.layout.LayoutImporter.importDataElement(LayoutImporter.java:44) [java] at org.jasig.portal.io.xml.crn.AbstractDom4jImporter.importData(AbstractDom4jImporter.java:86) [java] at org.jasig.portal.io.xml.crn.AbstractDom4jImporter.importData(AbstractDom4jImporter.java:53) [java] at org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importOrUpgradeData(JaxbPortalDataHandlerService.java:518) [java] at org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:481) [java] at org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:448) [java] at org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:426) [java] at org.jasig.portal.io.xml.IPortalDataHandlerService$importData.call(Unknown Source) [java] at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:42) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116) [java] at upshell_1700142953.run(upshell_1700142953.groovy:10) [java] ... 3 more [java] Caused by: org.springframework.dao.DataIntegrityViolationException: ConnectionCallback; SQL []; ORA-01400: cannot insert NULL into ("UNICON"."UP_LAYOUT_PARAM"."STRUCT_PARM_VAL") [java] ; nested exception is java.sql.SQLException: ORA-01400: cannot insert NULL into ("UNICON"."UP_LAYOUT_PARAM"."STRUCT_PARM_VAL") [java] [java] at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245) [java] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:348) [java] at org.jasig.portal.layout.simple.RDBMUserLayoutStore$11.doInTransaction(RDBMUserLayoutStore.java:1205) [java] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) [java] at org.jasig.portal.layout.simple.RDBMUserLayoutStore.setUserLayout(RDBMUserLayoutStore.java:1202) [java] at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.setUserLayout(RDBMDistributedLayoutStore.java:1432) [java] at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.importLayout(RDBMDistributedLayoutStore.java:790) [java] ... 26 more [java] Caused by: java.sql.SQLException: ORA-01400: cannot insert NULL into ("UNICON"."UP_LAYOUT_PARAM"."STRUCT_PARM_VAL") [java] [java] at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74) [java] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131) [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468) [java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) [java] at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.saveStructure(RDBMDistributedLayoutStore.java:1777) [java] at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.saveStructure(RDBMDistributedLayoutStore.java:1725) [java] at org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.saveStructure(RDBMDistributedLayoutStore.java:1725) [java] at org.jasig.portal.layout.simple.RDBMUserLayoutStore$11$1.doInConnection(RDBMUserLayoutStore.java:1258) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:341) [java] ... 31 more [java] INFO Shutting down ExecutorService 'importExportThreadPool' [java] INFO Shutting down ExecutorService 'uPortalTaskExecutor' [copy] Copying 1 file to /home/billbrown/uportal-4.0.2/target BUILD FAILED /home/billbrown/uportal-4.0.2/build.xml:596: The following error occurred while executing this line: /home/billbrown/uportal-4.0.2/build.xml:424: The following error occurred while executing this line: /home/billbrown/uportal-4.0.2/build.xml:1356: The following error occurred while executing this line: /home/billbrown/uportal-4.0.2/build.xml:1329: The following error occurred while executing this line: /home/billbrown/uportal-4.0.2/build.xml:1332: The following error occurred while executing this line: /home/billbrown/uportal-4.0.2/build.xml:1359: The following error occurred while executing this line: /home/billbrown/uportal-4.0.2/build.xml:430: /home/billbrown/uportal-4.0.2/build.xml:433: Java returned: 1 Total time: 39 seconds billbrown@piglet:~/uportal-4.0.2$ more ../uPortal-3-2-patches/build/export-2011-10-12/layout/jschraegle.layout <layout xmlns:dlm="http://www.uportal.org/layout/dlm" script="classpath://org/ja sig/portal/io/import-layout_v3-2.crn" username="jschraegle"> <folder hidden="false" immutable="false" name="Root folder" type="root" unremovable="true"> <folder dlm:origin="uocHome-lo:/layout/folder/folder[3]" hidden="false" immutable="false" name="Home" type="regular" unremovable="false"> <folder dlm:origin="uocHome-lo:/layout/folder/folder[3]/folder[1]" hidden= "false" immutable="false" name="Column" type="regular" unremovable="false"> <dlm:positionSet hidden="false" immutable="false" name="" type="dlm:positionSet" unremovable="false"> <dlm:position hidden="false" immutable="false" name="uocHome-lo:/layout/folder/folder[3]/folder[1]/channel[1]" type="dlm:position" unremovable="false" fname="Announcements"/> <dlm:position hidden="false" immutable="false" name="uocHome-lo:null" type="dlm:position" unremovable="false"/> </dlm:positionSet> </folder> </folder> </folder> </layout> let me know if you need more information. Thanks for your help.

    Apereo Issues | 5 years ago | Bill Brown
    java.sql.SQLException: ORA-01400: cannot insert NULL into ("UNICON"."UP_LAYOUT_PARAM"."STRUCT_PARM_VAL")
  3. 0

    "Wrong number or types of arguments" in nativeQuery with temporal parameter set to null

    Stack Overflow | 4 years ago | Mithfindel
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Trouble running Open Anzo snapshot

    Google Groups | 8 years ago | Rolf Bardeli
    org.openanzo.jdbc.utils.RdbException: ErrorCode[256:262181] [RDB_ERROR] Failed to execute an sql operation:[setInitializing] SQL: [UPDATE SERVER SET INITIALIZED=0 WHERE INITIALIZED IS NULL] Params:[] Templates:[] Root Cause: java.sql.SQLException ORA-00942: Tabelle oder View nicht vorhanden
  6. 0

    # Connect to an empty oracle database. # On the JIRA setup wizard choose restore some data. # I restored my local data. it had an issue with a summary > 255 characters and I got this error: {noformat} java.sql.SQLException: ORA-12899: value too large for column "TREVOR"."JIRAISSUE"."SUMMARY" (actual: 414, maximum: 255) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1008) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3530) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:233) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:632) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:125) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:98) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:64) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:489) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:469) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:80) at com.atlassian.jira.action.admin.OfbizImportHandler.createWithDeadlockRetry(OfbizImportHandler.java:515) {noformat} # I then go back to the initial wizard and click "Next" to setup JIRA rather than do an import. # (DEFECT) The next button takes me to a screen that says JIRA has been setup. However, this leaves JIRA in a bad state as some of the data from the initial import is hanging around in the database. After this point JIRA is non-usable. I would assume that if I restart the "clean install" setup wizard, that it cleans up the database so it actually did a clean install.

    Atlassian JIRA | 5 years ago | Brenden Bain [Atlassian]
    java.sql.SQLException: ORA-12899: value too large for column "TREVOR"."JIRAISSUE"."SUMMARY" (actual: 414, maximum: 255)

  1. mellson 2 times, last 3 months ago
8 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    ORA-01400: cannot insert NULL into ("UNICON"."UP_LAYOUT_PARAM"."STRUCT_PARM_VAL")

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeUpdate
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    5. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    6. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062)
    12 frames
  3. Commons DBCP
    DelegatingPreparedStatement.executeUpdate
    1. org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    2. org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    2 frames
  4. org.jasig.portal
    RDBMUserLayoutStore$11$1.doInConnection
    1. org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.saveStructure(RDBMDistributedLayoutStore.java:1777)
    2. org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.saveStructure(RDBMDistributedLayoutStore.java:1725)
    3. org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.saveStructure(RDBMDistributedLayoutStore.java:1725)
    4. org.jasig.portal.layout.simple.RDBMUserLayoutStore$11$1.doInConnection(RDBMUserLayoutStore.java:1258)
    4 frames
  5. Spring Framework
    JdbcTemplate.execute
    1. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:341)
    1 frame
  6. org.jasig.portal
    RDBMUserLayoutStore$11.doInTransaction
    1. org.jasig.portal.layout.simple.RDBMUserLayoutStore$11.doInTransaction(RDBMUserLayoutStore.java:1205)
    1 frame
  7. Spring Tx
    TransactionTemplate.execute
    1. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
    1 frame
  8. org.jasig.portal
    RDBMDistributedLayoutStore.importLayout
    1. org.jasig.portal.layout.simple.RDBMUserLayoutStore.setUserLayout(RDBMUserLayoutStore.java:1202)
    2. org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.setUserLayout(RDBMDistributedLayoutStore.java:1432)
    3. org.jasig.portal.layout.dlm.RDBMDistributedLayoutStore.importLayout(RDBMDistributedLayoutStore.java:790)
    3 frames
  9. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  10. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    3 frames
  11. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    1 frame
  12. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    2 frames
  13. Unknown
    $Proxy96.importLayout
    1. $Proxy96.importLayout(Unknown Source)
    1 frame
  14. org.jasig.portal
    IPortalDataHandlerService$importData.call
    1. org.jasig.portal.io.xml.layout.LayoutImporter.importDataElement(LayoutImporter.java:44)
    2. org.jasig.portal.io.xml.crn.AbstractDom4jImporter.importData(AbstractDom4jImporter.java:86)
    3. org.jasig.portal.io.xml.crn.AbstractDom4jImporter.importData(AbstractDom4jImporter.java:53)
    4. org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importOrUpgradeData(JaxbPortalDataHandlerService.java:518)
    5. org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:481)
    6. org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:448)
    7. org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:426)
    8. org.jasig.portal.io.xml.IPortalDataHandlerService$importData.call(Unknown Source)
    8 frames
  15. Groovy
    AbstractCallSite.call
    1. org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:42)
    2. org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108)
    3. org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
    3 frames
  16. Unknown
    upshell_1700142953.run
    1. upshell_1700142953.run(upshell_1700142953.groovy:10)
    1 frame
  17. Groovy
    GroovyShell.run
    1. groovy.lang.GroovyShell.runScriptOrMainOrTestOrRunnable(GroovyShell.java:266)
    2. groovy.lang.GroovyShell.run(GroovyShell.java:229)
    2 frames
  18. org.jasig.portal
    PortalShell.main
    1. org.jasig.portal.shell.PortalShell.main(PortalShell.java:84)
    1 frame