Hello Evgenij, I am getting the same sql exception when running the script to create a backup file of the old (1.3) database to the new (1.4) database. The error is:
The specified database user/password combination is rejected: [23505][23505] Unique index or primary key violation: "PRIMARY KEY ON """".PAGE_INDEX"; SQL statement: ALTER TABLE PUBLIC.SITE_PERMISSION ADD CONSTRAINT PUBLIC.ACCESS_NAME_FK FOREIGN KEY(ACCESS_NAME) REFERENCES PUBLIC.ACCESS(ACCESS_NAME) NOCHECK [23505-200] There are actually NO rows in the SITE_PERMISSION table and only two rows in the ACCESS table. I am not sure why there would be a primary key violation when there are no rows to index. The DDL for SITE_PERMISSION is as follows: create table SITE_PERMISSION ( ACCESS_NAME VARCHAR(100) not null, SITE_NAME VARCHAR(5) not null, IDS_PERMISSION_ID INTEGER not null, constraint SITE_PERMISSION_PK primary key (ACCESS_NAME, SITE_NAME, IDS_PERMISSION_ID), constraint ACCESS_NAME_FK foreign key (ACCESS_NAME) references ACCESS, constraint IDS_PERMISSION_ID_FK foreign key (IDS_PERMISSION_ID) references IDS_PERMISSIONS, constraint SITE_NAME_FK foreign key (SITE_NAME) references SITE ); Any ideas on why this error is occuring? Thanks, Mike. On Friday, June 26, 2020 at 2:25:48 PM UTC-7, Michael Earl wrote: > > Hello All, > > I am attempting to upgrade our H2 jar to 1.4.200. We are currently using > 1.3.164. > > Using the 1.4.200 jar, I can't successfully open a database created by > 1.3.164. Is this expected? > > When simply opening the database I get the following: > > The specified database user/password combination is rejected: > [23505][23505] Unique index or primary key violation: "PRIMARY KEY ON > """".PAGE_INDEX"; SQL statement: ALTER TABLE PUBLIC.SITE_PERMISSION ADD > CONSTRAINT PUBLIC.ACCESS_NAME_FK FOREIGN KEY(ACCESS_NAME) REFERENCES > PUBLIC.ACCESS(ACCESS_NAME) NOCHECK [23505-200] > > The database opens successfully using the 1.3.164 jar. > > This is my connection string: jdbc:h2:file:C:/Projects/FlexIDS 4.9 - H2 > Upgrade/FlexDB/FlexDB;MV_STORE=false > > Thanks for any help > Mike. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/4f3c098e-e11b-4c61-937c-8dd0f389a4e4o%40googlegroups.com.
