java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_686 in statement [INSERT INTO UP_SS_USER_ATTS(USER_ID, PROFILE_ID, SS_ID , SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES(?, ?, ?, 1, ?, ?, ?, ?)]

Apereo Issues | fatlily | 7 years ago
  1. 0

    The export was runing well without any problem.Then i use the crm-import to update the uportal version 3.1and other is fine except the *.fragment-layout.It encountes the following problem : [java] Import DLM Fragment Layout: fragment-layout\ent-lo.fragment-layout [java] ERROR Failed to import DLM Fragment Layout from: fragment-layout\ent-lo.fragment-layout due to exception: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/F:/uPortal-3.1.1-quick-start/uPortal-3.1.1/uportal-impl/target/uportal-impl-3.1.1.jar!/org/jasig/portal/io/import-layout_v2-6.crn [java] Source: /crn [java] Entity Name: <crn> [java] ERROR Exception thrown while performing subtask in its own thread. The parent ExecutorService has been shutdown since fail-fast was set to true [java] org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/F:/uPortal-3.1.1-quick-start/uPortal-3.1.1/uportal-impl/target/uportal-impl-3.1.1.jar!/org/jasig/portal/io/import-layout_v2-6.crn [java] Source: /crn [java] Entity Name: <crn> [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:100) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:97) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.core.ErrorHandlingTask.perform(ErrorHandlingTask.java:112) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.concurrent.ConcurrentTask.access$000(ConcurrentTask.java:24) [java] at org.danann.cernunnos.concurrent.ConcurrentTask$1.run(ConcurrentTask.java:72) [java] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) [java] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) [java] at java.util.concurrent.FutureTask.run(FutureTask.java:123) [java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) [java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) [java] at java.lang.Thread.run(Thread.java:595) [java] Caused by: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/F:/uPortal-3.1.1-quick-start/uPortal-3.1.1/uportal-impl/target/uportal-impl-3.1.1.jar!/org/jasig/portal/io/import-layout_v3-0.crn [java] Source: /sql-query/subtasks/with/subtasks/with/subtasks/sql-transaction/with-attribute[2]/if/sequence/with-attribute/@value [java] Entity Name: ${crn} [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:100) [java] at org.danann.cernunnos.flow.CernunnosPhrase.evaluate(CernunnosPhrase.java:66) [java] at org.danann.cernunnos.runtime.RuntimePhraseDecorator.evaluate(RuntimePhraseDecorator.java:75) [java] at org.danann.cernunnos.runtime.ConcatenatingPhrase.evaluate(ConcatenatingPhrase.java:77) [java] at org.danann.cernunnos.runtime.RuntimeReagentDecorator.evaluate(RuntimeReagentDecorator.java:71) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:64) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SequenceTask.perform(SequenceTask.java:78) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.IfTask.perform(IfTask.java:60) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.sql.TransactionTask.access$300(TransactionTask.java:40) [java] at org.danann.cernunnos.sql.TransactionTask$PerformSubtasksTransactionCallback.doInTransactionWithoutResult(TransactionTask.java:141) [java] at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) [java] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) [java] at org.danann.cernunnos.sql.TransactionTask.perform(TransactionTask.java:115) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.sql.QueryTask.access$100(QueryTask.java:58) [java] at org.danann.cernunnos.sql.QueryTask$ResponseMappingRowCallbackHandler.processRow(QueryTask.java:193) [java] at org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java:1368) [java] at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:653) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591) [java] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641) [java] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670) [java] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:686) [java] at org.danann.cernunnos.sql.QueryTask.perform(QueryTask.java:130) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:97) [java] ... 21 more [java] Caused by: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/F:/uPortal-3.1.1-quick-start/uPortal-3.1.1/uportal-impl/target/uportal-impl-3.1.1.jar!/org/jasig/portal/io/import-layout-node.crn [java] Source: /with/subtasks/with-attribute/choose[2]/when[1]/with-attribute/if/with-attribute/@value [java] Entity Name: ${crn} [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:100) [java] at org.danann.cernunnos.flow.CernunnosPhrase.evaluate(CernunnosPhrase.java:66) [java] at org.danann.cernunnos.runtime.RuntimePhraseDecorator.evaluate(RuntimePhraseDecorator.java:75) [java] at org.danann.cernunnos.runtime.ConcatenatingPhrase.evaluate(ConcatenatingPhrase.java:77) [java] at org.danann.cernunnos.runtime.RuntimeReagentDecorator.evaluate(RuntimeReagentDecorator.java:71) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:64) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.IfTask.perform(IfTask.java:60) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.ChooseTask.perform(ChooseTask.java:112) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:97) [java] ... 71 more [java] Caused by: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/F:/uPortal-3.1.1-quick-start/uPortal-3.1.1/uportal-impl/target/uportal-impl-3.1.1.jar!/org/jasig/portal/io/import-layout-node.crn [java] Source: /with/subtasks/with-attribute/choose[1]/when[2]/with-attribute/if/with-attribute/@value [java] Entity Name: ${crn} [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:100) [java] at org.danann.cernunnos.flow.CernunnosPhrase.evaluate(CernunnosPhrase.java:66) [java] at org.danann.cernunnos.runtime.RuntimePhraseDecorator.evaluate(RuntimePhraseDecorator.java:75) [java] at org.danann.cernunnos.runtime.ConcatenatingPhrase.evaluate(ConcatenatingPhrase.java:77) [java] at org.danann.cernunnos.runtime.RuntimeReagentDecorator.evaluate(RuntimeReagentDecorator.java:71) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:64) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.IfTask.perform(IfTask.java:60) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.ChooseTask.perform(ChooseTask.java:112) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:97) [java] ... 102 more [java] Caused by: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/F:/uPortal-3.1.1-quick-start/uPortal-3.1.1/uportal-impl/target/uportal-impl-3.1.1.jar!/org/jasig/portal/io/import-layout-node.crn [java] Source: /with/subtasks/with-attribute/choose[1]/when[2]/with-attribute/if/with-attribute/@value [java] Entity Name: ${crn} [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:100) [java] at org.danann.cernunnos.flow.CernunnosPhrase.evaluate(CernunnosPhrase.java:66) [java] at org.danann.cernunnos.runtime.RuntimePhraseDecorator.evaluate(RuntimePhraseDecorator.java:75) [java] at org.danann.cernunnos.runtime.ConcatenatingPhrase.evaluate(ConcatenatingPhrase.java:77) [java] at org.danann.cernunnos.runtime.RuntimeReagentDecorator.evaluate(RuntimeReagentDecorator.java:71) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:64) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.IfTask.perform(IfTask.java:60) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.ChooseTask.perform(ChooseTask.java:112) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:97) [java] ... 133 more [java] Caused by: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/F:/uPortal-3.1.1-quick-start/uPortal-3.1.1/uportal-impl/target/uportal-impl-3.1.1.jar!/org/jasig/portal/io/import-layout-node.crn [java] Source: /with/subtasks/with-attribute/choose[2]/when[1]/with-attribute/if/with-attribute/@value [java] Entity Name: ${crn} [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:100) [java] at org.danann.cernunnos.flow.CernunnosPhrase.evaluate(CernunnosPhrase.java:66) [java] at org.danann.cernunnos.runtime.RuntimePhraseDecorator.evaluate(RuntimePhraseDecorator.java:75) [java] at org.danann.cernunnos.runtime.ConcatenatingPhrase.evaluate(ConcatenatingPhrase.java:77) [java] at org.danann.cernunnos.runtime.RuntimeReagentDecorator.evaluate(RuntimeReagentDecorator.java:71) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:64) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.IfTask.perform(IfTask.java:60) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.ChooseTask.perform(ChooseTask.java:112) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:97) [java] ... 164 more [java] Caused by: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/F:/uPortal-3.1.1-quick-start/uPortal-3.1.1/uportal-impl/target/uportal-impl-3.1.1.jar!/org/jasig/portal/io/import-layout-node.crn [java] Source: /with/subtasks/with-attribute/choose[1]/when[2]/with-attribute/if/with-attribute/@value [java] Entity Name: ${crn} [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:100) [java] at org.danann.cernunnos.flow.CernunnosPhrase.evaluate(CernunnosPhrase.java:66) [java] at org.danann.cernunnos.runtime.RuntimePhraseDecorator.evaluate(RuntimePhraseDecorator.java:75) [java] at org.danann.cernunnos.runtime.ConcatenatingPhrase.evaluate(ConcatenatingPhrase.java:77) [java] at org.danann.cernunnos.runtime.RuntimeReagentDecorator.evaluate(RuntimeReagentDecorator.java:71) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:64) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.IfTask.perform(IfTask.java:60) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.ChooseTask.perform(ChooseTask.java:112) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:97) [java] ... 195 more [java] Caused by: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/F:/uPortal-3.1.1-quick-start/uPortal-3.1.1/uportal-impl/target/uportal-impl-3.1.1.jar!/org/jasig/portal/io/import-layout-node.crn [java] Source: /with/subtasks/with-attribute/choose[2]/when[1]/crn [java] Entity Name: <crn> [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:100) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.ChooseTask.perform(ChooseTask.java:112) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:97) [java] ... 226 more [java] Caused by: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/F:/uPortal-3.1.1-quick-start/uPortal-3.1.1/uportal-impl/target/uportal-impl-3.1.1.jar!/org/jasig/portal/io/import-layout-params.crn [java] Source: /with-attribute/node-iterator[2]/with-attribute/with-attribute/sql-statement [java] Entity Name: <sql-statement> [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:93) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.xml.NodeIteratorTask.perform(NodeIteratorTask.java:95) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:97) [java] ... 243 more [java] Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT INTO UP_SS_USER_ATTS(USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES(?, ?, ?, 1, ?, ?, ?, ?)]; Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_686 in statement [INSERT INTO UP_SS_USER_ATTS(USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES(?, ?, ?, 1, ?, ?, ?, ?)]; nested exception is java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_686 in statement [INSERT INTO UP_SS_USER_ATTS(USER_ID, PROFILE_ID, SS_ID , SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES(?, ?, ?, 1, ?, ?, ?, ?)] [java] at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100) [java] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [java] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:619) [java] at org.danann.cernunnos.sql.StatementTask.perform(StatementTask.java:106) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] ... 262 more [java] Caused by: java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_686 in statement [INSERT INTO UP_SS_USER_ATTS(USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES(?, ?, ?, 1, ?, ?, ?, ?)] [java] at org.hsqldb.jdbc.Util.throwError(Unknown Source) [java] at org.hsqldb.jdbc.jdbcPreparedStatement.execute(Unknown Source) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169) [java] at org.danann.cernunnos.sql.StatementTask$PhraseParameterPreparedStatementCallback.doInPreparedStatement(StatementTask.java:125) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591) [java] ... 265 more In the end i found that the *.fragment-out file seems someting wrong .The stucture part appeared twice : <layout username="ent-lo" script="classpath://org/jasig/portal/io/import-layout_v3-0.crn"> <root name="Root folder" hidden="N" immutable="N" unremovable="Y"> <header name="Header folder" hidden="N" immutable="Y" unremovable="Y"/> <footer name="Footer folder" hidden="N" immutable="N" unremovable="N"/> <tab name="Real Entertainment" hidden="N" immutable="N" unremovable="N"> <param> <name>cp:editAllowed</name> <value>false</value> </param> <column name="Column" hidden="N" immutable="N" unremovable="N"> <structure-attribute type="folder"> <name>width</name> <value>40%</value> </structure-attribute> <structure-attribute type="folder"> <name>width</name> <value>40%</value> </structure-attribute> </column> <column name="Column" hidden="N" immutable="N" unremovable="N"> <structure-attribute type="folder"> <name>width</name> <value>60%</value> </structure-attribute> <structure-attribute type="folder"> <name>width</name> <value>60%</value> </structure-attribute> </column> </tab> </root> <profile name="HTML browser profile"> <description>A system profile for common web browsers</description> <structure name="DLM Tabs and columns"/> <theme name="DLM XHTML"/> </profile> </layout> Still i don't kown how to fix it and sincerely ask for help.Thanks!

    Apereo Issues | 7 years ago | fatlily
    java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_686 in statement [INSERT INTO UP_SS_USER_ATTS(USER_ID, PROFILE_ID, SS_ID , SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES(?, ?, ?, 1, ?, ?, ?, ?)]
  2. 0

    The export was runing well without any problem.Then i use the crm-import to update the uportal version 3.1and other is fine except the *.fragment-layout.It encountes the following problem : [java] Import DLM Fragment Layout: fragment-layout\ent-lo.fragment-layout [java] ERROR Failed to import DLM Fragment Layout from: fragment-layout\ent-lo.fragment-layout due to exception: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/F:/uPortal-3.1.1-quick-start/uPortal-3.1.1/uportal-impl/target/uportal-impl-3.1.1.jar!/org/jasig/portal/io/import-layout_v2-6.crn [java] Source: /crn [java] Entity Name: <crn> [java] ERROR Exception thrown while performing subtask in its own thread. The parent ExecutorService has been shutdown since fail-fast was set to true [java] org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/F:/uPortal-3.1.1-quick-start/uPortal-3.1.1/uportal-impl/target/uportal-impl-3.1.1.jar!/org/jasig/portal/io/import-layout_v2-6.crn [java] Source: /crn [java] Entity Name: <crn> [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:100) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:97) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.core.ErrorHandlingTask.perform(ErrorHandlingTask.java:112) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.concurrent.ConcurrentTask.access$000(ConcurrentTask.java:24) [java] at org.danann.cernunnos.concurrent.ConcurrentTask$1.run(ConcurrentTask.java:72) [java] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) [java] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) [java] at java.util.concurrent.FutureTask.run(FutureTask.java:123) [java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) [java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) [java] at java.lang.Thread.run(Thread.java:595) [java] Caused by: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/F:/uPortal-3.1.1-quick-start/uPortal-3.1.1/uportal-impl/target/uportal-impl-3.1.1.jar!/org/jasig/portal/io/import-layout_v3-0.crn [java] Source: /sql-query/subtasks/with/subtasks/with/subtasks/sql-transaction/with-attribute[2]/if/sequence/with-attribute/@value [java] Entity Name: ${crn} [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:100) [java] at org.danann.cernunnos.flow.CernunnosPhrase.evaluate(CernunnosPhrase.java:66) [java] at org.danann.cernunnos.runtime.RuntimePhraseDecorator.evaluate(RuntimePhraseDecorator.java:75) [java] at org.danann.cernunnos.runtime.ConcatenatingPhrase.evaluate(ConcatenatingPhrase.java:77) [java] at org.danann.cernunnos.runtime.RuntimeReagentDecorator.evaluate(RuntimeReagentDecorator.java:71) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:64) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SequenceTask.perform(SequenceTask.java:78) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.IfTask.perform(IfTask.java:60) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.sql.TransactionTask.access$300(TransactionTask.java:40) [java] at org.danann.cernunnos.sql.TransactionTask$PerformSubtasksTransactionCallback.doInTransactionWithoutResult(TransactionTask.java:141) [java] at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) [java] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) [java] at org.danann.cernunnos.sql.TransactionTask.perform(TransactionTask.java:115) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.sql.QueryTask.access$100(QueryTask.java:58) [java] at org.danann.cernunnos.sql.QueryTask$ResponseMappingRowCallbackHandler.processRow(QueryTask.java:193) [java] at org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java:1368) [java] at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:653) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591) [java] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641) [java] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670) [java] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:686) [java] at org.danann.cernunnos.sql.QueryTask.perform(QueryTask.java:130) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:97) [java] ... 21 more [java] Caused by: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/F:/uPortal-3.1.1-quick-start/uPortal-3.1.1/uportal-impl/target/uportal-impl-3.1.1.jar!/org/jasig/portal/io/import-layout-node.crn [java] Source: /with/subtasks/with-attribute/choose[2]/when[1]/with-attribute/if/with-attribute/@value [java] Entity Name: ${crn} [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:100) [java] at org.danann.cernunnos.flow.CernunnosPhrase.evaluate(CernunnosPhrase.java:66) [java] at org.danann.cernunnos.runtime.RuntimePhraseDecorator.evaluate(RuntimePhraseDecorator.java:75) [java] at org.danann.cernunnos.runtime.ConcatenatingPhrase.evaluate(ConcatenatingPhrase.java:77) [java] at org.danann.cernunnos.runtime.RuntimeReagentDecorator.evaluate(RuntimeReagentDecorator.java:71) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:64) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.IfTask.perform(IfTask.java:60) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.ChooseTask.perform(ChooseTask.java:112) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:97) [java] ... 71 more [java] Caused by: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/F:/uPortal-3.1.1-quick-start/uPortal-3.1.1/uportal-impl/target/uportal-impl-3.1.1.jar!/org/jasig/portal/io/import-layout-node.crn [java] Source: /with/subtasks/with-attribute/choose[1]/when[2]/with-attribute/if/with-attribute/@value [java] Entity Name: ${crn} [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:100) [java] at org.danann.cernunnos.flow.CernunnosPhrase.evaluate(CernunnosPhrase.java:66) [java] at org.danann.cernunnos.runtime.RuntimePhraseDecorator.evaluate(RuntimePhraseDecorator.java:75) [java] at org.danann.cernunnos.runtime.ConcatenatingPhrase.evaluate(ConcatenatingPhrase.java:77) [java] at org.danann.cernunnos.runtime.RuntimeReagentDecorator.evaluate(RuntimeReagentDecorator.java:71) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:64) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.IfTask.perform(IfTask.java:60) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.ChooseTask.perform(ChooseTask.java:112) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:97) [java] ... 102 more [java] Caused by: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/F:/uPortal-3.1.1-quick-start/uPortal-3.1.1/uportal-impl/target/uportal-impl-3.1.1.jar!/org/jasig/portal/io/import-layout-node.crn [java] Source: /with/subtasks/with-attribute/choose[1]/when[2]/with-attribute/if/with-attribute/@value [java] Entity Name: ${crn} [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:100) [java] at org.danann.cernunnos.flow.CernunnosPhrase.evaluate(CernunnosPhrase.java:66) [java] at org.danann.cernunnos.runtime.RuntimePhraseDecorator.evaluate(RuntimePhraseDecorator.java:75) [java] at org.danann.cernunnos.runtime.ConcatenatingPhrase.evaluate(ConcatenatingPhrase.java:77) [java] at org.danann.cernunnos.runtime.RuntimeReagentDecorator.evaluate(RuntimeReagentDecorator.java:71) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:64) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.IfTask.perform(IfTask.java:60) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.ChooseTask.perform(ChooseTask.java:112) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:97) [java] ... 133 more [java] Caused by: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/F:/uPortal-3.1.1-quick-start/uPortal-3.1.1/uportal-impl/target/uportal-impl-3.1.1.jar!/org/jasig/portal/io/import-layout-node.crn [java] Source: /with/subtasks/with-attribute/choose[2]/when[1]/with-attribute/if/with-attribute/@value [java] Entity Name: ${crn} [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:100) [java] at org.danann.cernunnos.flow.CernunnosPhrase.evaluate(CernunnosPhrase.java:66) [java] at org.danann.cernunnos.runtime.RuntimePhraseDecorator.evaluate(RuntimePhraseDecorator.java:75) [java] at org.danann.cernunnos.runtime.ConcatenatingPhrase.evaluate(ConcatenatingPhrase.java:77) [java] at org.danann.cernunnos.runtime.RuntimeReagentDecorator.evaluate(RuntimeReagentDecorator.java:71) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:64) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.IfTask.perform(IfTask.java:60) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.ChooseTask.perform(ChooseTask.java:112) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:97) [java] ... 164 more [java] Caused by: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/F:/uPortal-3.1.1-quick-start/uPortal-3.1.1/uportal-impl/target/uportal-impl-3.1.1.jar!/org/jasig/portal/io/import-layout-node.crn [java] Source: /with/subtasks/with-attribute/choose[1]/when[2]/with-attribute/if/with-attribute/@value [java] Entity Name: ${crn} [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:100) [java] at org.danann.cernunnos.flow.CernunnosPhrase.evaluate(CernunnosPhrase.java:66) [java] at org.danann.cernunnos.runtime.RuntimePhraseDecorator.evaluate(RuntimePhraseDecorator.java:75) [java] at org.danann.cernunnos.runtime.ConcatenatingPhrase.evaluate(ConcatenatingPhrase.java:77) [java] at org.danann.cernunnos.runtime.RuntimeReagentDecorator.evaluate(RuntimeReagentDecorator.java:71) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:64) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.IfTask.perform(IfTask.java:60) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.ChooseTask.perform(ChooseTask.java:112) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:97) [java] ... 195 more [java] Caused by: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/F:/uPortal-3.1.1-quick-start/uPortal-3.1.1/uportal-impl/target/uportal-impl-3.1.1.jar!/org/jasig/portal/io/import-layout-node.crn [java] Source: /with/subtasks/with-attribute/choose[2]/when[1]/crn [java] Entity Name: <crn> [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:100) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.flow.IfTask.performSubtasks(IfTask.java:70) [java] at org.danann.cernunnos.flow.ChooseTask.perform(ChooseTask.java:112) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:97) [java] ... 226 more [java] Caused by: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/F:/uPortal-3.1.1-quick-start/uPortal-3.1.1/uportal-impl/target/uportal-impl-3.1.1.jar!/org/jasig/portal/io/import-layout-params.crn [java] Source: /with-attribute/node-iterator[2]/with-attribute/with-attribute/sql-statement [java] Entity Name: <sql-statement> [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:93) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.xml.NodeIteratorTask.perform(NodeIteratorTask.java:95) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:97) [java] ... 243 more [java] Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT INTO UP_SS_USER_ATTS(USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES(?, ?, ?, 1, ?, ?, ?, ?)]; Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_686 in statement [INSERT INTO UP_SS_USER_ATTS(USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES(?, ?, ?, 1, ?, ?, ?, ?)]; nested exception is java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_686 in statement [INSERT INTO UP_SS_USER_ATTS(USER_ID, PROFILE_ID, SS_ID , SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES(?, ?, ?, 1, ?, ?, ?, ?)] [java] at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100) [java] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [java] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:619) [java] at org.danann.cernunnos.sql.StatementTask.perform(StatementTask.java:106) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] ... 262 more [java] Caused by: java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_686 in statement [INSERT INTO UP_SS_USER_ATTS(USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES(?, ?, ?, 1, ?, ?, ?, ?)] [java] at org.hsqldb.jdbc.Util.throwError(Unknown Source) [java] at org.hsqldb.jdbc.jdbcPreparedStatement.execute(Unknown Source) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169) [java] at org.danann.cernunnos.sql.StatementTask$PhraseParameterPreparedStatementCallback.doInPreparedStatement(StatementTask.java:125) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591) [java] ... 265 more In the end i found that the *.fragment-out file seems someting wrong .The stucture part appeared twice : <layout username="ent-lo" script="classpath://org/jasig/portal/io/import-layout_v3-0.crn"> <root name="Root folder" hidden="N" immutable="N" unremovable="Y"> <header name="Header folder" hidden="N" immutable="Y" unremovable="Y"/> <footer name="Footer folder" hidden="N" immutable="N" unremovable="N"/> <tab name="Real Entertainment" hidden="N" immutable="N" unremovable="N"> <param> <name>cp:editAllowed</name> <value>false</value> </param> <column name="Column" hidden="N" immutable="N" unremovable="N"> <structure-attribute type="folder"> <name>width</name> <value>40%</value> </structure-attribute> <structure-attribute type="folder"> <name>width</name> <value>40%</value> </structure-attribute> </column> <column name="Column" hidden="N" immutable="N" unremovable="N"> <structure-attribute type="folder"> <name>width</name> <value>60%</value> </structure-attribute> <structure-attribute type="folder"> <name>width</name> <value>60%</value> </structure-attribute> </column> </tab> </root> <profile name="HTML browser profile"> <description>A system profile for common web browsers</description> <structure name="DLM Tabs and columns"/> <theme name="DLM XHTML"/> </profile> </layout> Still i don't kown how to fix it and sincerely ask for help.Thanks!

    Apereo Issues | 7 years ago | fatlily
    java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_686 in statement [INSERT INTO UP_SS_USER_ATTS(USER_ID, PROFILE_ID, SS_ID , SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES(?, ?, ?, 1, ?, ?, ?, ?)]
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Adding the same role to the group results in exception in the server log

    YouTrack | 8 years ago
    java.sql.SQLException: Violation of unique constraint SYS_CT_255: duplicate value(s) for column(s) GROUP_ID,ROLE_ID,PROJECT_ID in statement [IN SERT INTO usergroup_roles (GROUP_ID, ROLE_ID, PROJECT_ID) VALUES (?,?,?)]
  5. 0

    Out of memory in SQL counting inspection errors

    YouTrack | 8 years ago
    org.springframework.jdbc.UncategorizedSQLException: Error executing query with params:[1013, 1010, 1010, 5]; uncategorized SQLException for SQL [SELECT COUNT(*) FROM ( SELECT count(r.HASH) AS COUNTER from inspection_results r, inspection_data a WHERE r.BUILD_ID IN (?,?) AND a.HASH=r.HASH GROUP BY r.HASH HAVING count(r.HASH)=1 AND MAX(r.BUILD_ID)=? and MAX(a.SEVERITY)<=?) t]; SQL state [S1000]; error code [72]; out of memory; nested exception is java.sql.SQLException: out of memory

    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

      Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_686 in statement [INSERT INTO UP_SS_USER_ATTS(USER_ID, PROFILE_ID, SS_ID, SS_TYPE, STRUCT_ID, PARAM_NAME, PARAM_TYPE, PARAM_VAL) VALUES(?, ?, ?, 1, ?, ?, ?, ?)]

      at org.hsqldb.jdbc.Util.throwError()
    2. HSQLDB
      jdbcPreparedStatement.execute
      1. org.hsqldb.jdbc.Util.throwError(Unknown Source)
      2. org.hsqldb.jdbc.jdbcPreparedStatement.execute(Unknown Source)
      2 frames
    3. Commons DBCP
      DelegatingPreparedStatement.execute
      1. org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
      2. org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
      2 frames
    4. org.danann.cernunnos
      StatementTask$PhraseParameterPreparedStatementCallback.doInPreparedStatement
      1. org.danann.cernunnos.sql.StatementTask$PhraseParameterPreparedStatementCallback.doInPreparedStatement(StatementTask.java:125)
      1 frame
    5. Spring Framework
      JdbcTemplate.execute
      1. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
      2. org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100)
      3. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
      4. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
      5. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
      6. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:619)
      6 frames
    6. org.danann.cernunnos
      RuntimeTaskDecorator.perform
      1. org.danann.cernunnos.sql.StatementTask.perform(StatementTask.java:106)
      2. org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77)
      2 frames