At one of our sites we are now receiving the error listed below when trying to run an extraction. I am certain that we have a publsiher defined as the following sql command returns a single row: select * from sysuserperm where publishauth = 'Y'

Here is my extract command: dbxtract -b -n -u -v -c "dsn=Central Database;dbn=Central03;eng=Central03;commlinks=tcpip{Host=192.168.30.4};uid=dbextract;pwd=xxx;" J:\bersys\unload\011039 011039 -y

Resulting error: SQL Anywhere Extraction Utility Version 12.0.1.3436 Connecting and initializing There is no publisher defined for the specified database

Any help or guidance is appreciated.

Thanks, Brian

asked 15 May '17, 09:38

bgreiman's gravatar image

bgreiman
400181927
accept rate: 20%

What does "select current publisher" return?

(15 May '17, 10:10) Volker Barth

select * from sysuserperm where publishauth = 'Y' returns a row with user_name 030000 which is the correct publisher

(15 May '17, 10:22) bgreiman
Replies hidden

Yes, but what does the mentioned select return?

(15 May '17, 10:27) Volker Barth

Here is CSV formatted export of the row that is returned: 522,3638,'030000',0x013c752dde9fbb9ff4ff7df95d21d739325e0f523e3fc5db2dfeb260fbfdfd91522aef2489,'Y','Y','N','Y','Y','N','Duluth DB Server-new'

(15 May '17, 10:32) bgreiman

Please can you still make sure that "SELECT CURRENT PUBLISHER" does also return the expected value?

(16 May '17, 14:52) Volker Barth

FYI - I uninstalled and re-install SQL Anywhere and that solved my issue. Must have been a corrupted or missing file somewhere in the installation.

Thanks, Brian

permanent link

answered 01 Jun '17, 09:51

bgreiman's gravatar image

bgreiman
400181927
accept rate: 20%

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:

×5

question asked: 15 May '17, 09:38

question was seen: 1,134 times

last updated: 01 Jun '17, 09:51