Ask Your Question
0

Base error code issue [closed]

asked 2013-05-23 18:30:42 +0200

AlexWJ gravatar image

updated 2014-01-06 23:34:02 +0200

oweng gravatar image

Can anyone help interpret the error code I am getting. It is for a very simple single table database which works fine for a few entries; all saved records, close and reopens fine then after a another entry will then show the following when opening the data base file:

SQL Status: S1000 Error code: 40

S1000 General error java.lang.NullPointerException in statement [SELECT * FROM "ProductStock"]

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-01 21:47:24.449758

2 Answers

Sort by » oldest newest most voted
1

answered 2013-05-24 23:23:33 +0200

JohnD gravatar image

A quick Google search for that error message seems to show a variety of possible reasons - most which are over my head :) However, it seems that some kind of database corruption may be a cause. Base has known to be somewhat unstable at times and having regular backups is recommended. Here are a couple of things you might want to try:

Got to Tools / SQL... and execute these commands --- Shutdown Compact then close and reopen your database. Might also try Checkpoint Defrag.

Another possibility is noted in the post -- http://www.mail-archive.com/users@openoffice.org/msg85626.html Basically it says to ensure that there are no null values in the first row.

Good luck!

edit flag offensive delete link more

Comments

thank you for "Got to Tools / SQL... and execute these commands --- Shutdown Compact then close and reopen your database" it worked for me. yours` sehrguey

sehrguey gravatar imagesehrguey ( 2015-03-11 17:02:20 +0200 )edit
0

answered 2013-05-25 04:59:02 +0200

oweng gravatar image

You don't mention which version of LO you are using or even how your database is configured. Presumably you are simply using the standard HSQLDB v1.8 in an embedded manner, which is the default method. Finding error codes for HyperSQL requires looking at the source code as there do not appear to be any listings on the website.

Error codes for HSQLDB v1.8 can be found in /src/org/hsqldb/Trace.java but unfortunately error code 40 (line 160) is a general error, which is why the causes are variable as @JohnD indicates. This same contextual error (NullPointerException) has been around a long time as this Red Hat bug comment shows. That bug also indicates it is not always easy to reproduce.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-05-23 18:30:42 +0200

Seen: 4,250 times

Last updated: May 25 '13