Correction – agency_id needs to be populated when populating the USER and GROUP tables –

INSERT INTO TEST.USER VALUES (1, ‘TEST USER 1’, 1);
INSERT INTO TEST.USER VALUES (2, ‘TEST USER 2’, 1);
INSERT INTO TEST.USER VALUES (3, ‘TEST USER 3’, 1);
INSERT INTO TEST.USER VALUES (4, ‘TEST USER 4’, 1);
INSERT INTO TEST.USER VALUES (5, ‘TEST USER 5’, 1);
INSERT INTO TEST.USER VALUES (6, ‘TEST USER 6’1, 1);
INSERT INTO TEST.USER VALUES (7, ‘TEST USER 7’, 1);
INSERT INTO TEST.USER VALUES (8, ‘TEST USER 8’, 1);

INSERT INTO TEST.GROUP VALUES(1, ‘TEST GROUP 1’, 1);