Unloading a database leads to an error in SQL Central after upgrade

[huber1]

Hi

Having installed the update to SQL Anywhere 17.0.4.2129, I notice a difference in unloading a database. Up to version 17.0.4.2066, I was able to execute the dbunload statement in the Summary page of the Unload Database Wizard directly by pressing the Finish Button. After the update, I get the attached error.

The dbunload statement looks like: dbunload -v -c "UID= testdatabase;PWD=***;Server=skyserver;DBN= Testdatabase;ASTART=No;host=10.0.1.2:2638" -an "/Users/admin/Desktop/Testdatabase.db" -ap 4096 -ea None -kdi 0 -ii -up

If I execute the very same statement in the terminal AND put at PWD= the password in clear instead of the ***, it works. As I think we have not changed the server environment (may be except an update of Java), I am wondering if there is a change in SQL Central?

• OS X 10.11 El Capitan
• Java 1.8.0_101

Best regards, Robert

[johnsmirnios]

The generation of the unprocessed.sql file hasn't changed AFAIK. unprocessed.sql will go into the 'current directory'. Perhaps the current directory for your invocation of SQL Central is a location where you do not have write permission?

[huber1]

Hi John I write the database as before the update to the admin's Desktop folder. As I am logged in as admin, I have write access to this folder. I am a little helpless what it could be.

[johnsmirnios]

Try changing the current directory of the SQL Central process. To do so, edit the icon that you use to invoke it. Right-click on the icon, choose 'Properties' then put a directory into the "Start in:" field.

[huber1]

Do you mean the icon of SQL Central?

[johnsmirnios]

Yes. And you must restart SQL Central after editing the icon.

[huber1]

I am on OS X and with Get Info I don't have a field like Start in:. I also checked Package Contents but can't find something like you mention. Could you give a hint where to find this field in El Capitan, please?