Can you please post the entire stacktrace?
On 2013-01-09 15:03, kais haddadin wrote:
Hello,
I try to open the H2 database version (1.3.168) and am getting this error:
"Sequenz "SYSTEM_SEQUENCE_A5042270_9313_42F1_B53B_FC2AD0D3510F" nicht
gefunden
Sequence "SYSTEM_SEQUENCE_A5042270_9313_42F1_B53B_FC2AD0D3510F" not
found; SQL statement:
CREATE CACHED TABLE FCM.LAGERBESTÄNDE(
"#id" INTEGER DEFAULT (NEXT VALUE FOR
FCM.SYSTEM_SEQUENCE_A5042270_9313_42F1_B53B_FC2AD0D3510F) NOT NULL
NULL_TO_DEFAULT SEQUENCE
FCM.SYSTEM_SEQUENCE_A5042270_9313_42F1_B53B_FC2AD0D3510F SELECTIVITY 100,
SCENARIO VARCHAR(32672) SELECTIVITY 1,
JAHR VARCHAR(32672) SELECTIVITY 1,
MONAT VARCHAR(32672) SELECTIVITY 1,
ARTIKEL VARCHAR(32672) SELECTIVITY 97,
LAGERORT VARCHAR(32672) SELECTIVITY 1,
EINHEIT VARCHAR(32672) SELECTIVITY 1,
"#VALUE" DOUBLE SELECTIVITY 6
)
<http://192.168.2.52:8082/login.do?jsessionid=e60f6ed39eaa5eb82e5e62554c7147e1#>"
but I did not create this, I created a table with Autoincrement
column, the query should look like this :
CREATE TABLE FCM.LAGERBESTÄNDE
<http://192.168.2.52:8082/login.do?jsessionid=e60f6ed39eaa5eb82e5e62554c7147e1#>
("#id" INTEGER PRIMARY KEY AUTO_INCREMENT,...
Is this a known bug? I can not reproduce the problem, but It seems to
happen sometimes.
I can attach the database but it is 30MB after compression.
Regards,
Kais
--
You received this message because you are subscribed to the Google
Groups "H2 Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/iDm121_u8oUJ.
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.
--
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.