Actually, it does not appear to be a SQL exception:
Caused by: java.lang.RuntimeException: The specified member was not
found: Active Directory (H1)
at
org.jasig.portal.io.GetMemberServicePhrase.evaluate(GetMemberServicePhra
se.java:84)
at
org.danann.cernunnos.runtime.ConcatenatingPhrase.evaluate(ConcatenatingP
hrase.java:77)
at
org.danann.cernunnos.sql.PhraseParameterPreparedStatementSetter.setValue
s(PhraseParameterPreparedStatementSetter.java:40)
at
org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcT
emplate.java:771)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:566
)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:767)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:825)
at org.danann.cernunnos.sql.UpsertTask.doUpdate(UpsertTask.java:167)
at org.danann.cernunnos.sql.UpsertTask.perform(UpsertTask.java:147)
at
org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDec
orator.java:58)
at
org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractConta
inerTask.java:123)
at
org.danann.cernunnos.sql.TransactionTask.access$300(TransactionTask.java
:40)
at
org.danann.cernunnos.sql.TransactionTask$PerformSubtasksTransactionCallb
ack.doInTransactionWithoutResult(TransactionTask.java:141)
at
org.springframework.transaction.support.TransactionCallbackWithoutResult
.doInTransaction(TransactionCallbackWithoutResult.java:33)
at
org.springframework.transaction.support.TransactionTemplate.execute(Tran
sactionTemplate.java:128)
at
org.danann.cernunnos.sql.TransactionTask.perform(TransactionTask.java:11
5)
at
org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDec
orator.java:58)
at
org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRu
nner.java:310)
at
org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:264)
at
org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:87)
... 27 more
I'm still thinking that handling the delimiting on the export side
should do the trick. Or perhaps during the comparison in
GetMemberServicePhrase.evaluate(). I'll take a look at the scripts you
committed to trunk as I proceed forth as well.
Thanks,
--Chris
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Eric
Dalquist
Sent: Tuesday, October 07, 2008 11:26 AM
To: [email protected]
Subject: Re: [uportal-dev] Small Import/Export Concern
How did it fail? Was it a SQL exception?
If so Cernunnos 1.0 should be able to deal with the string since it uses
prepared statements for the SQL. Also, all of the updated import scripts
are in the trunk right now if you want to take a look.
-Eric
Christopher Doyle wrote:
I ran into a little issue when attempting to import a membership entity
into uPortal where the relevant group name contains parentheses. In our
case, we are using the following values to define the ROOT_KEY value of
our SmartLdapGroupStore (per environment):
Local / Development: "Active Directory (H1)"
Staging / Production: "Active Directory (WIN)"
We added this SmartLdapGroupStore ROOT group to the "Everyone" group
using the Groups Manager. The subsequent exported membership entity (as
generated by crn-export) is defined as:
<membership
script="classpath://org/jasig/portal/io/import-membership_v2-6.crn">
<parent>Everyone</parent>
<child>
<group>Active Directory (H1)</group>
</child>
</membership>
My initial attempt to import this entity into a new environment failed.
As it turns out, the parentheses in the ROOT_KEY were the culprit. I
manually delimited the parentheses in the entity and was able to re-run
the import successfully:
<group>Active Directory \(H1\)</group>
My proposal is obviously to modify the export .crn scripts to
accommodate proper delimiting. I'm prepping a release at the moment and
don't have an immediate solution to contribute back, but wanted to at
least make folks aware of the concern in case it comes up elsewhere.
Eric D. - I know that you have prepared some updated import/export
scripts for 3.1.0, do they address this? I don't want to duplicate any
work that you may have already completed.
Thanks,
--Chris
--
[ c h r i s d o y l e ]
Johns Hopkins University
Sr. System Software Engineer, [EMAIL PROTECTED]
410.735.4127
[EMAIL PROTECTED]
"Eleven. Exactly. One louder."
--
You are currently subscribed to [email protected] as:
[EMAIL PROTECTED]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/uportal-dev
--
You are currently subscribed to [email protected] as: [EMAIL
PROTECTED]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/uportal-dev
