Deployment issues with 4.1.0-rc-03

[Juergen Starek]

Hello again,

upon deployment of the ear file, I get the following error message:

$ asadmin --port 40432 deploy icat.ear-4.1.0-rc-03.ear

Application deployed with name icat.ear-4.1.0-rc-03.

PER01003: Deployment encountered SQL Exceptions:

PER01000: Got SQLException executing statement "CREATE TABLE USER_TABLE_ANSTO (USER_ID VARCHAR2(255) NOT NULL, PASSWORD VARCHAR2(255) NOT NULL, PRIMARY KEY (USER_ID))": java.sql.SQLException: ORA-00955: Es gibt bereits ein Objekt mit diesem Namen

PER01000: Got SQLException executing statement "CREATE TABLE USER_SESSION_ANSTO (USER_SESSION_ID VARCHAR2(255) NOT NULL, EXPIRE_DATE_TIME TIMESTAMP NOT NULL, RUN_AS VARCHAR2(255) NOT NULL, PRIMARY KEY (USER_SESSION_ID))": java.sql.SQLException: ORA-00955: Es gibt bereits ein Objekt mit diesem Namen

PER01000: Got SQLException executing statement "CREATE TABLE USER_TABLE (USER_ID VARCHAR2(255) NOT NULL, PASSWORD VARCHAR2(255) NOT NULL, PRIMARY KEY (USER_ID))": java.sql.SQLException: ORA-00955: Es gibt bereits ein Objekt mit diesem Namen

PER01000: Got SQLException executing statement "CREATE TABLE USER_SESSION (USER_SESSION_ID VARCHAR2(255) NOT NULL, EXPIRE_DATE_TIME TIMESTAMP NOT NULL, RUN_AS VARCHAR2(255) NOT NULL, PRIMARY KEY (USER_SESSION_ID))": java.sql.SQLException: ORA-00955: Es gibt bereits ein Objekt mit diesem Namen

Cannot create tables for application icat.ear-4.1.0-rc-03. The expected DDL file icat.ear-4.1.0-rc-03_icat.exposed-4.1.0-rc-03_icat_createDDL.jdbc is not available.

However, the command finishes with

Command deploy executed successfully.

I would assume that the SQL exceptions are not fatal, but what about the DDL file part of the message? Where can I get that file?

[Steve Fisher]

This is just the workings of Eclipselink - it is normal

> --
> You received this message because you are subscribed to the Google Groups
> "icatproject-support" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/icatproject-support/-/ffNg75-O0LEJ.
> To post to this group, send email to icatproje...@googlegroups.com.
> To unsubscribe from this group, send email to
> icatproject-sup...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/icatproject-support?hl=en.

[Juergen Starek]

Am Mittwoch, 6. Juni 2012 21:22:33 UTC+2 schrieb Steve Fisher:

This is just the workings of Eclipselink - it is normal  

I'm afraid the file is necessary after all, since there are no tables generated in the icat database -- the icatuser database, for which I don't see such an error message, gets populated.