[prev in list] [next in list] [prev in thread] [next in thread]
List: wsf-javascript-dev
Subject: [Dev] WSO2 API Manager 1.6.0 Sample Data errors
From: Isuru Perera <isurup () wso2 ! com>
Date: 2014-02-28 6:46:49
Message-ID: CADQ5vQQZ0bVRo_+-hpc7M5oj=8LA0E6ASoJ5oH31VLQQ7fhhQQ () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Hi,
I was following [1] on WSO2 API Manager 1.6.0 and got following errors when
trying ant on samples/Data
isuru@isurup-ThinkPad-T530:~/wso2am-1.6.0/samples/Data$ ant
Buildfile: /home/isuru/wso2am-1.6.0/samples/Data/build.xml
init:
populate-user-database:
[sql] Executing resource:
/home/isuru/temp/support/TELECOMITDEV-8/wso2am-1.6.0/samples/Data/UserPopulator.sql
[sql] Failed to execute: INSERT INTO UM_USER_ROLE (UM_ROLE_ID,
UM_USER_ID ,UM_TENANT_ID ) VALUES (1, @USER_ID,-1234)
[sql] org.h2.jdbc.JdbcSQLException: Referential integrity constraint
violation: "CONSTRAINT_BA1: PUBLIC.UM_USER_ROLE FOREIGN KEY(UM_ROLE_ID,
UM_TENANT_ID) REFERENCES PUBLIC.UM_ROLE(UM_ID, UM_TENANT_ID)"; SQL
statement:
[sql] INSERT INTO UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID ,UM_TENANT_ID
) VALUES (1, @USER_ID,-1234) [23002-140]
[sql] Failed to execute: INSERT INTO UM_USER_ROLE (UM_ROLE_ID,
UM_USER_ID ,UM_TENANT_ID ) VALUES (2,@USER_ID,-1234)
[sql] org.h2.jdbc.JdbcSQLException: Referential integrity constraint
violation: "CONSTRAINT_BA1: PUBLIC.UM_USER_ROLE FOREIGN KEY(UM_ROLE_ID,
UM_TENANT_ID) REFERENCES PUBLIC.UM_ROLE(UM_ID, UM_TENANT_ID)"; SQL
statement:
[sql] INSERT INTO UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID ,UM_TENANT_ID
) VALUES (2,@USER_ID,-1234) [23002-140]
[sql] Failed to execute: INSERT INTO UM_USER_ROLE (UM_ROLE_ID,
UM_USER_ID ,UM_TENANT_ID ) VALUES (1, @USER_ID,-1234)
[sql] org.h2.jdbc.JdbcSQLException: Referential integrity constraint
violation: "CONSTRAINT_BA1: PUBLIC.UM_USER_ROLE FOREIGN KEY(UM_ROLE_ID,
UM_TENANT_ID) REFERENCES PUBLIC.UM_ROLE(UM_ID, UM_TENANT_ID)"; SQL
statement:
[sql] INSERT INTO UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID ,UM_TENANT_ID
) VALUES (1, @USER_ID,-1234) [23002-140]
[sql] Failed to execute: INSERT INTO UM_USER_ROLE (UM_ROLE_ID,
UM_USER_ID ,UM_TENANT_ID ) VALUES (2,@USER_ID,-1234)
[sql] org.h2.jdbc.JdbcSQLException: Referential integrity constraint
violation: "CONSTRAINT_BA1: PUBLIC.UM_USER_ROLE FOREIGN KEY(UM_ROLE_ID,
UM_TENANT_ID) REFERENCES PUBLIC.UM_ROLE(UM_ID, UM_TENANT_ID)"; SQL
statement:
[sql] INSERT INTO UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID ,UM_TENANT_ID
) VALUES (2,@USER_ID,-1234) [23002-140]
[sql] 10 of 14 SQL statements executed successfully
BUILD SUCCESSFUL
Total time: 1 second
What is the reason for this?
Best Regards,
[1] https://docs.wso2.org/display/AM160/Setting+up+the+Samples
--
Isuru Perera
Senior Software Engineer | WSO2, Inc. | http://wso2.com/
Lean . Enterprise . Middleware
about.me/chrishantha
[Attachment #5 (text/html)]
<div dir="ltr"><div><div><div>Hi,<br><br></div>I was following [1] on WSO2 API \
Manager 1.6.0 and got following errors when trying ant on samples/Data<br><span \
style="font-family:courier \
new,monospace"><br>isuru@isurup-ThinkPad-T530:~/wso2am-1.6.0/samples/Data$ ant<br>
Buildfile: /home/isuru/wso2am-1.6.0/samples/Data/build.xml<br><br>init:<br><br>populate-user-database:<br> \
[sql] Executing resource: \
/home/isuru/temp/support/TELECOMITDEV-8/wso2am-1.6.0/samples/Data/UserPopulator.sql<br>
[sql] Failed to execute: INSERT INTO UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID \
,UM_TENANT_ID ) VALUES (1, @USER_ID,-1234)<br> [sql] \
org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: \
"CONSTRAINT_BA1: PUBLIC.UM_USER_ROLE FOREIGN KEY(UM_ROLE_ID, UM_TENANT_ID) \
REFERENCES PUBLIC.UM_ROLE(UM_ID, UM_TENANT_ID)"; SQL statement:<br>
[sql] INSERT INTO UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID ,UM_TENANT_ID ) VALUES \
(1, @USER_ID,-1234) [23002-140]<br> [sql] Failed to execute: INSERT INTO \
UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID ,UM_TENANT_ID ) VALUES (2,@USER_ID,-1234)<br>
[sql] org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: \
"CONSTRAINT_BA1: PUBLIC.UM_USER_ROLE FOREIGN KEY(UM_ROLE_ID, UM_TENANT_ID) \
REFERENCES PUBLIC.UM_ROLE(UM_ID, UM_TENANT_ID)"; SQL statement:<br>
[sql] INSERT INTO UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID ,UM_TENANT_ID ) VALUES \
(2,@USER_ID,-1234) [23002-140]<br> [sql] Failed to execute: INSERT INTO \
UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID ,UM_TENANT_ID ) VALUES (1, @USER_ID,-1234)<br>
[sql] org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: \
"CONSTRAINT_BA1: PUBLIC.UM_USER_ROLE FOREIGN KEY(UM_ROLE_ID, UM_TENANT_ID) \
REFERENCES PUBLIC.UM_ROLE(UM_ID, UM_TENANT_ID)"; SQL statement:<br>
[sql] INSERT INTO UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID ,UM_TENANT_ID ) VALUES \
(1, @USER_ID,-1234) [23002-140]<br> [sql] Failed to execute: INSERT INTO \
UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID ,UM_TENANT_ID ) VALUES (2,@USER_ID,-1234)<br>
[sql] org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: \
"CONSTRAINT_BA1: PUBLIC.UM_USER_ROLE FOREIGN KEY(UM_ROLE_ID, UM_TENANT_ID) \
REFERENCES PUBLIC.UM_ROLE(UM_ID, UM_TENANT_ID)"; SQL statement:<br>
[sql] INSERT INTO UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID ,UM_TENANT_ID ) VALUES \
(2,@USER_ID,-1234) [23002-140]<br> [sql] 10 of 14 SQL statements executed \
successfully<br><br>BUILD SUCCESSFUL<br>Total time: 1 second</span><br>
<br></div>What is the reason for this?<br><br></div>Best \
Regards,<br><div><div><br>[1] <a \
href="https://docs.wso2.org/display/AM160/Setting+up+the+Samples">https://docs.wso2.org/display/AM160/Setting+up+the+Samples</a><br \
clear="all">
<div><div><br>-- <br><div dir="ltr"><span style="color:rgb(102,102,102)"><font><span \
style="font-family:arial,helvetica,sans-serif">Isuru Perera<br>Senior Software \
Engineer | WSO<font>2,</font> Inc. | <a href="http://wso2.com/" \
target="_blank">http://wso2.com/</a><br>
Lean . Enterprise . Middleware<br></span></font></span><br><a \
href="http://about.me/chrishantha" target="_blank">about.me/chrishantha</a></div> \
</div></div></div></div></div>
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic