Page 1 of 1

[Solved] Shutdown Compact error

PostPosted: Thu Apr 12, 2018 9:43 am
by Maax555
ok, so tried the shutdown compact command and received this error,
1: error in script file line: 3 File input/output errorerror java.io.IOException: S1000 invalid storage class: java.lang.NullPointerException opening file - file C:\Users\Project Tracking New\Project Tracking Test V1.15.odb.data in statement [CREATE CACHED TABLE "Customers"] in statement [SHUTDOWN COMPACT]
I tried to open the Customers table and it opens fine. Any ideas?

I have gone back to my earliest version of this DB V1.01 and get the exact same message regarding the customer table. I have opened it and cant see any issues.
Perhaps I should delete and create customer table again?

Re: Shutdown Compact error

PostPosted: Thu Apr 12, 2018 10:36 am
by Villeroy
Image
Are we discussing an embedded HSQLDB where the statusbar of the database document looks like this?
And you are running the command from menu:Tools>SQL... ?
I've never seen this error message.

Try CHECKPOINT DEFRAG

Re: Shutdown Compact error

PostPosted: Thu Apr 12, 2018 11:44 am
by Maax555
Hi Villeroy, yes embedded HSQLDB. I am running command from Tools>SQL and have also used the defrag command.
I have deleted the Customer table, run the SHUTDOWN COMPACT command and I get the exact same error but now mentioning a different table.
I have deleted all tables and left a single table and still get the same error?
I have also loaded an older DB and get exact same thing. I will now look to download a database example from internet and see if i get the same thing.
Perhaps its a java issue or i need to install LO again.

Re: Shutdown Compact error

PostPosted: Thu Apr 12, 2018 1:01 pm
by Maax555
So i have found reference to this in https://dev-builds.libreoffice.org I am now downloading an alternative version which apparently fixes this issue.
Fingers crossed.

Re: Shutdown Compact error

PostPosted: Thu Apr 12, 2018 1:27 pm
by Maax555
Downloaded V6 of LO and all is fine now. However the file size of my DB does not reduce at all, its still 400KB which means i cannot upload to some forums as restriction is 128KB. This is strange as my earlier save of this DB is half the size and has very little difference.

Re: Shutdown Compact error

PostPosted: Thu Apr 12, 2018 2:49 pm
by robleyd
[Forum] How to attach a document here Note maximum file size is 128K. If your file is larger, use a file sharing site such as Mediafire and post the link here. The link also contains information on how to anonymise your document if it contains confidential information.

Re: Shutdown Compact error

PostPosted: Thu Apr 12, 2018 3:10 pm
by Maax555
Thanks Rob, just deleting tables and forms that are not relevant to my query (which is a hassle as relationships need to be removed first) then see how big it is.