Opened 4 years ago

#6114 new defect

TAP does not allow to assign roles to a group

Reported by: zequi Owned by:
Priority: major Milestone:
Component: ThreddsAdminPanel Keywords:
Cc:

Description

The group 'Escenarios PNACC' was created but it is not possible to assign any role (in particular the pnacc role). When the form to assign the role it is filled and the Submit button pressed, the apache logs register the following lines:

SEVERE: Servlet.service() for servlet [tap] in context with path [/udg-tap] threw exception [Request processing failed; nested exception

 is org.springframework.dao.DataIntegrityViolationException: 

### Error updating database.  Cause: java.sql.SQLIntegrityConstraintViolationException: INSERT on table 'GROUPS_ROLES' caused a violatio

n of foreign key constraint 'FK_GR_GROUPNAME' for key (Escenarios).  The statement has been rolled back.

### The error may involve es.unican.meteo.tap.dao.GroupMapper.insertRole-Inline

### The error occurred while setting parameters

### SQL: INSERT INTO groups_roles (groupname,rolename) values ('Escenarios','pnacc')

### Cause: java.sql.SQLIntegrityConstraintViolationException: INSERT on table 'GROUPS_ROLES' caused a violation of foreign key constrain

t 'FK_GR_GROUPNAME' for key (Escenarios).  The statement has been rolled back.

; SQL []; INSERT on table 'GROUPS_ROLES' caused a violation of foreign key constraint 'FK_GR_GROUPNAME' for key (Escenarios).  The state

ment has been rolled back.; nested exception is java.sql.SQLIntegrityConstraintViolationException: INSERT on table 'GROUPS_ROLES' caused

 a violation of foreign key constraint 'FK_GR_GROUPNAME' for key (Escenarios).  The statement has been rolled back.] with root cause

ERROR 23503: INSERT on table 'GROUPS_ROLES' caused a violation of foreign key constraint 'FK_GR_GROUPNAME' for key (Escenarios).  The st

atement has been rolled back.

It seems there is a problem with whitespaces in group names.

Change History (0)

Note: See TracTickets for help on using tickets.