Error building the database with j2:create.production

[aordin <ao...@disid.com>]

Hi!
I create one copy of my jetspeed2 portal database with "pg_dump -a -d" 
and obtain one ' dataBase.sql ' file only with the data and using 
INSERT(no COPY).
My objective is create one new database and charge on it my ' 
database.sql ' with all my data, and I want to make it with one maven 
goal. To make it, I put my ' dataBase.sql ' file into 
"${basedir}/src/sql" and execute: *maven j2:create.production*, at first 
time all works fine, but after execute the schemes, when it try to 
execute my ' dataBase.sql '  it show me this error: (excuse me but some 
sentences is translated by me, to english)

        [echo] Running user-defined SQL scripts...
    j2:_process.all.scripts.in.path:
        [echo] Checking for SQL scripts at path /MY_PROJECT_HOME/src/sql...
        [echo] Running SQL scripts in directory /MY_PROJECT_HOME/src/sql...
    j2:_db.execute:
        [sql] Executing file: /MY_PROJECT_HOME/src/sql/dataBase.sql
        [sql] [ERROR] Failed to execute:           INSERT INTO
    pa_metadata_fields VALUES (4, 2, 'Jetspeed-2 Administration
    Portlets', 'title', 'en,,')

    BUILD FAILED

    Errors stack :
     >> Unable to obtain goal [j2:db.create.production]
     >> File......
    file:/home/USER/.maven/cache/maven-jetspeed2-plugin-2.0/plugin.jelly
     >> Element... sql
     >> Line...... 839
     >> Column.... 44
     >> org.postgresql.util.PSQLException: ERROR: insert or update in
    the table «pa_metadata_fields» violate the foreign key
    «pa_metadata_fields_fk_1»
      Detail: The key (object_id)=(2) is not present in the table
    «portlet_application».
     >> ERROR: insert or update in the table «pa_metadata_fields»
    violate the foreign key «pa_metadata_fields_fk_1»
        Detail: The key (object_id)=(2) is not present in the table
    «portlet_application».

Somebody can help me?
If you know another better way, please tell me how.

thank you very much!

-- 

Adolfo

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org