Grouper Users - Open Discussion List

["Dr. Loris Bennett" <>]

Hi,

Due to various experiments with versions 1.4.0, 1.4.1 and a snapshot of
1.4.1, I seem to have got my database (postgres 8.3) into a bit of a
strange state. I can no longer log into the UI.

When I run

        bin/gsh.sh -registry -check

I get the error message

        org.apache.ddlutils.model.ModelException: There are multiple
        column with the name id in the table grouper_attributes

(see attached log). In fact, there are not multiple columns called 'id'
in the table.

Any ideas?

In the meantime, I shall try to restore an old DB dump and upgrade it to
V1.4.1.

Regards

Loris
 
-- 
Dr. Loris Bennett (Mr.)
Freie Universität Berlin
ZEDAT - Zentraleinrichtung für Datenverarbeitung / Computer Center
Compute & Media Service
Fabeckstr. 32, Room 221
D-14195 Berlin
Tel ++49 30 838 51024
Fax ++49 30 838 56721
Email 

Web www.zedat.fu-berlin.de
Grouper starting up: version: 1.4.1, build date: 2009/02/13 11:17:17, env: 
<no label configured>
grouper.properties read from: 
/home/testwww/src/grouper/grouper-api-1.4.1/conf/grouper.properties
Grouper current directory is: /home/testwww/src/grouper/grouper-api-1.4.1
log4j.properties read from:   
/home/testwww/src/grouper/grouper-api-1.4.1/conf/log4j.properties
Grouper is logging to file:   /home/testwww/grouper/log/grouper_error.log, at 
min level TRACE for package: edu.internet2.middleware.grouper, based on 
log4j.properties
grouper.hibernate.properties: 
/home/testwww/src/grouper/grouper-api-1.4.1/conf/grouper.hibernate.properties
grouper.hibernate.properties: 
grouper@jdbc:postgresql://identity-store.zedat.fu-berlin.de:5713/testfurzdb
sources.xml read from:        
/home/testwww/src/grouper/grouper-api-1.4.1/conf/sources.xml
sources.xml groupersource id: g:gsa
sources.xml jdbc source id:   fub: 
grouper@jdbc:postgresql://identity-store.zedat.fu-berlin.de:5713/testfurzdb
(note, might need to type in your response multiple times (Java stdin is 
flaky))
(note, you can whitelist or blacklist db urls and users in the 
grouper.properties)
Are you sure you want to schemaexport all tables 
(dropThenCreate=F,writeAndRunScript=F) in db user 'grouper', db url 
'jdbc:postgresql://identity-store.zedat.fu-berlin.de:5713/testfurzdb'? (y|n): 
y
Continuing...
Grouper ddl object type 'Grouper' has dbVersion: 0 and java version: 13
org.apache.ddlutils.model.ModelException: There are multiple column with the 
name id in the table grouper_attributes
        at org.apache.ddlutils.model.Database.initialize(Database.java:295)
        at 
org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelReader.java:484)
        at 
org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1920)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper(GrouperDdlUtils.java:488)
        at 
edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:155)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:167)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:108)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at com.dawidweiss.invoker.Invoker.loader(Invoker.java:167)
        at com.dawidweiss.invoker.Invoker.main(Invoker.java:303)
[com.dawidweiss.invoker.Invoker] 
edu.internet2.middleware.grouper.app.gsh.GrouperShell has thrown an exception.
java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:172)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:108)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at com.dawidweiss.invoker.Invoker.loader(Invoker.java:167)
        at com.dawidweiss.invoker.Invoker.main(Invoker.java:303)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:167)
        ... 7 more
Caused by: java.lang.RuntimeException: 
org.apache.ddlutils.model.ModelException: There are multiple column with the 
name id in the table grouper_attributes
        at 
edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:176)
        ... 12 more
Caused by: org.apache.ddlutils.model.ModelException: There are multiple 
column with the name id in the table grouper_attributes
        at org.apache.ddlutils.model.Database.initialize(Database.java:295)
        at 
org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelReader.java:484)
        at 
org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1920)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper(GrouperDdlUtils.java:488)
        at 
edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:155)
        ... 12 more