Skip to Content.
Sympa Menu

grouper-users - V1.4.1: ModelException

Subject: Grouper Users - Open Discussion List

List archive

V1.4.1: ModelException


Chronological Thread 
  • From: "Dr. Loris Bennett" <>
  • To: Grouper Users Mailing List <>
  • Subject: V1.4.1: ModelException
  • Date: Mon, 16 Feb 2009 08:01:42 +0000
  • Organization: Freie Universität Berlin

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




Archive powered by MHonArc 2.6.16.

Top of Page