For some databases SQL-dumps created via SCRIPT cannot be imported into an empty database. The schema of all the databases is the same and most of them work just fine.
But databases showing this error always fail with the same exception when importing the Dumps via RUNSCRIPT: Index "PRIMARY_KEY_E" besteht bereits Index "PRIMARY_KEY_E" already exists; SQL statement: CREATE PRIMARY KEY PUBLIC.PRIMARY_KEY_E ON PUBLIC.NULL_IMAGE_ACTION (OBJECT_ID) [42111-123] This also happens in the H2 console. Running SCRIPT in the H" console shows no errors for the original database but RUNSCRIPT on a empty db fails with the above error. The databases were created and maintained with older versions of H2. The databases can be opened without problems with the newest version. (Last week we upgraded to the current version to get rid of a problem under Windows Vista und Windows 7 with access rights where H2 produced a FileNotFoundException due to denied access to the file system_temp_lob.db - the current version solves this nicely) Since the databases contain customer data, I cannot post them here. I can sent them via private e-mail for further analysis. Any help is very much appreciated. Many thanks in advance. Cheers -sascha -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
