search

CGI-NRM / SeqDB-documentation

MIT License
0 stars 1 forks source link

seqdb , version 3.32 - users and genotypes error #33

Open Inkimar opened 5 years ago

Inkimar commented 5 years ago

check @RodriNRM account.

Inkimar commented 5 years ago

See Readme file for 3.32 in - postgres version 9.6 is used

1. see the doc: 'verify 'Add new user'-functionality' Error is )

javax.persistence.PersistenceException: [org.hibernate.exception.ConstraintViolationException: could not execute statement, could not execute statement, ERROR: duplicate key value violates unique constraint "pk_people"
  Detail: Key (peopleid)=(1) already exists.]

Question : there are already 6users in the system so the peopleid 1 to 6 are already taken, the id of the next key should be 7 ?

2. see the doc: verify 'Genotype'-functionality Error is ) 

javax.persistence.PersistenceException: [could not extract ResultSet, ERROR: syntax error at or near ")"
  Position: 2264]
Inkimar commented 5 years ago

Solution for 1. keep on adding until the peopleid is equal to number of users.

Inkimar commented 5 years ago

Should be resolved in Version 3.35 , see that issue