Issue 107096 - In a macro, SQL order "Shutdown compact" fails
Summary: In a macro, SQL order "Shutdown compact" fails
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO320m5
Hardware: All All
: P5 (lowest) Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-11-21 08:46 UTC by dle
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Message from SQL order "Shutdown compact" (21.41 KB, text/plain)
2009-11-21 08:50 UTC, dle
no flags Details
Sample of "Shutdown Compact" by clicking the button. (12.30 KB, text/plain)
2009-11-21 08:55 UTC, dle
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description dle 2009-11-21 08:46:05 UTC

Since OOo 320, the SQL Order "SHUTDOWN COMPACT" inside a macro fails with a
message (see the attachment). 
If it is replaced by "Shutdown" or by "Shutdown Script", this is ok.
In case with "Shutdown Script" no problem on the next run.
The difference between "Script" and "Compact" is that in case of "Compact" the
tables are rebuilt immediatly. Maybe the problem is here?

Thanks in advance.
Comment 1 dle 2009-11-21 08:50:30 UTC
Created attachment 66218 [details]
Message from SQL order "Shutdown compact"
Comment 2 dle 2009-11-21 08:55:14 UTC
Created attachment 66219 [details]
Sample of "Shutdown Compact" by clicking the button.
Comment 3 py_samyn 2009-11-21 11:38:58 UTC

My environment : XP SP3 - 300m65(Build:9457)

I confirm...

But no problem if it is replaced by CHECKPOINT DEFRAG

Best regards
Comment 4 marc.neumann 2009-11-23 07:03:48 UTC
confirm and send to the right developer
Comment 5 ocke.janssen 2009-11-23 07:54:06 UTC
As work around you should use execute("SHUTDOWN COMPACT") in your macro and not
Comment 6 dle 2009-11-23 14:03:49 UTC
Thank you for the bypass.
Comment 7 Frank Schönheit 2010-11-24 10:51:38 UTC
Given the easy workaround, I don't think we'd (realistically) fix this in the
3.x time frame => retargeting
Comment 8 ocke.janssen 2011-02-03 09:48:45 UTC
Change prio.