Skip to Content.
Sympa Menu

grouper-users - RE: [grouper-users] colons in display names causing issues

Subject: Grouper Users - Open Discussion List

List archive

RE: [grouper-users] colons in display names causing issues


Chronological Thread 
  • From: "Redman, Chad" <>
  • To: Liam Hoekenga <>, "" <>
  • Subject: RE: [grouper-users] colons in display names causing issues
  • Date: Fri, 5 Jan 2018 14:42:00 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:93WjpBPe2q6QN6kYRMcl6mtUPXoX/o7sNwtQ0KIMzox0I/jzrarrMEGX3/hxlliBBdydt6odzbKO+4nbGkU4qa6bt34DdJEeHzQksu4x2zIaPcieFEfgJ+TrZSFpVO5LVVti4m3peRMNQJW2aFLduGC94iAPERvjKwV1Ov71GonPhMiryuy+4ZLebxlViDanfb9+MAi9oBnMuMURnYZsMLs6xAHTontPdeRWxGdoKkyWkh3h+Mq+/4Nt/jpJtf45+MFOTav1f6IjTbxFFzsmKHw65NfqtRbYUwSC4GYXX3gMnRpJBwjF6wz6Xov0vyDnuOdxxDWWMMvrRr0vRz+s87lkRwPpiCcfNj427mfXitBrjKlGpB6tvgFzz5LIbI2QMvd1Y6HTcs4ARWdZXshfSTFPAp+yYYUMAeoOP+dYoJXyqFYVtxSyGRWgCfnzxjNUhHL727Ax3eQ7EQHB2QwtB9wCvmjKo9roMacdS+a1wLHVxjjdb/NZwyry5IbVeR0mvf6MXah/ftfJxkk1CQzKk1CQppbjPz6Oy+QNtXSU4/B+Wu2ylm4qsgd8qSWsyMc0koTFmJgaxkzZ+Sh83Yo5OMC0RUt1YdOrDJdcqySXN4VoTc4tWW5lvSM3x7wYtZGnZCQG1ZQqywDFZ/CZaYSE/w7vWPiLLTtli39oe7SyjAuo/0e60O3zTMy03U5KriVbltnMsWgA2QTP58aAVvdw8F6t1CuN2AzN8+1EJls7mrTBJ54m374wioEcsUPeHi/whUr6lreWdl8j+ui09evofqnmpp6bN49ykA3+NbkumtC7AeQ/NQgOXHKX9vi71L3m5UH5QbNKgeMqkqTBrpzVP9gXqrO8DgNIz4ov9hOyDzmp3dgEgXUKKVxFdwyIgofzPlzDJfH1AemjjFi0lTdk3fHGPrnvApXXKXjDla/scqp960FG1QU81cpf6IxJBbEEOv3zXFT8tMHeDhAlKQC73fvoCMhl2oMERW2PGrOZML/VsVKQ6eIvOe6MZJINuDnjMfgp/uPujWQnll8HZqmkxp8XaHGjHvR6OEWVf2DggtYHEWcWoAU+Vurqh0OeUTJNfXq9Qb8z5ixoQL6hWKPCT4XloLuM3yq9EZQeMmRHA1WWOWrtdo6EHfoAdXTWaoVuiDsZTbW7DpI62Au1nA7817d9KOfIoGsVuY+pnIx6/erOjRwosCFvAt6G+2CLU2xumG4UHXk70L0p8mJnzVLWm5J1j/lRE5gbzPNAXk1yYZXcxuBNEd3+XwvHVsqPQxCrTsjwUmJ5dc4439JbOxU1IN6llB2WmnPyW7I=
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

If this is SQL you can do an inline replacement in the query:

 

select c.name as group_name, replace(c.descr, ':', '_') as group_display_name from ...

 

 

-Chad

 

 

From: [mailto:] On Behalf Of Liam Hoekenga
Sent: Friday, January 05, 2018 9:32 AM
To:
Subject: [grouper-users] colons in display names causing issues

 

It looks like the column I'm using to provide a display name for one of my loader jobs occasionally includes colons, e.g. "Dept Finance: Thing".  This is making the loader sad:

 

2018-01-04 05:37:05,718: [pool-1-thread-3470] ERROR GrouperLoaderType.syncGroupLogicForOneGroup(1880) -  - Error in job for group: ref:sql:PRVST_EXC_VP_ACA_AFF:COLLEGE_OF_STUFF:12345:Staff

java.lang.RuntimeException: Problem with group: ref:sql:PRVST_EXC_VP_ACA_AFF:COLLEGE_OF_STUFF:12345:Staff

...

Caused by: java.lang.RuntimeException: The length of stems in stem name: 5, ref:sql:PRVST_EXC_VP_ACA_AFF:COLLEGE_OF_STUFF:12345, should be the same as the display stems: 6, ref:sql:PRVST_EXC_VP_ACA_AFF:COLLEGE_OF_STUFF:Dept Finance: Thing,

 

 

How would I fix this?

Liam


Archive powered by MHonArc 2.6.19.

Top of Page