Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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

alt text

asked 21 Oct '16, 08:08

robert's gravatar image

robert
853475468
accept rate: 0%

edited 21 Oct '16, 08:10


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?

permanent link

answered 21 Oct '16, 10:12

John%20Smirnios's gravatar image

John Smirnios
12.0k396166
accept rate: 37%

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.

(23 Oct '16, 06:31) robert
Replies hidden

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.

(23 Oct '16, 07:57) John Smirnios

Do you mean the icon of SQL Central?

(25 Oct '16, 11:56) robert
Replies hidden

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

(25 Oct '16, 12:28) John Smirnios

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?

(26 Oct '16, 02:20) robert
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:

×52

question asked: 21 Oct '16, 08:08

question was seen: 1,959 times

last updated: 26 Oct '16, 02:20