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

asked 19 Mar, 11:23

Alexander%20Ilg's gravatar image

Alexander Ilg
176131321
accept rate: 0%

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.

(20 Mar, 14:19) Chris Keating

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.

permanent link

answered 19 Mar, 15:11

Chris%20Keating's gravatar image

Chris Keating
3.8k2165
accept rate: 30%

converted 27 Mar, 15:19

Volker%20Barth's gravatar image

Volker Barth
32.0k326468687

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

(23 Mar, 06:15) Alexander Ilg
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×153

question asked: 19 Mar, 11:23

question was seen: 80 times

last updated: 23 Mar, 06:15