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
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
