ulunload does nothing on Windows

[former_SQLA_member1694889]

Hello everybody,

I am trying to unload a ratter large UltraLite database (about 7 GB) on a Windows server (running SQL Anywhere 17.0.4.2053).

The command I use is the following:

ulunload.exe -c "DBF=C:\\Users\\Administrator\\Downloads\\test.udb" -t CODEGROUP,CODEGROUPML -s C:\\Users\\Administrator\\Downloads\\dump.sql

The problem I face is that ulunload is running (I can see it in the task manager), but it looks like it is doing nothing - the udb is not opened, the CPU of the machine is at 1%. I waited for more than 30 min, but the status stays the same.

Any idea what could go wrong?

Thanks for your help! Alex

[chris_keating]

If you continue to have problems, you may want to consider opening a support case so we can investigate. If you do not have support, we would still like to investigate. Would you be able to provide the database? If so, can you send me an email at first.last@sap.com with a location to access the file or I can arrange a location to upload.

[chris_keating · Accepted solution]

1) If there is no existing uleng17 instance, can you add -v to see if the unload does any work.This would be evidenced with lines starting with "unloading" or "saving". It may be that the unload is working but it is taking some time to unload.

2) Is there an existing uleng17 running on the machine? If so, it might be that the running uleng17 instance is in a bad state and ulunload is stuck trying to access it. Ultralite utilities use this process as well as applications that use the engine runtime.

[former_SQLA_member1694889 · Accepted solution]

Hello Chris,

the problem was as you expected - the uleng17 process was running, but not reacting anymore. After killing it, the ulunload worked fine. Thank you for the hint!

Best regards, Alex