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
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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

    # 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 | 6 years ago | Brenden Bain [Atlassian]
    java.sql.SQLException: ORA-12899: value too large for column "TREVOR"."JIRAISSUE"."SUMMARY" (actual: 414, maximum: 255)
  6. 0

    sporadic ORA-22275 at jdbc BLOB insert on 11g

    Oracle Community | 5 years ago | 665115
    java.sql.SQLException: ORA-22275: Ung├╝ltiger LOB-Locator angegeben

  1. mellson 2 times, last 7 months ago
9 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