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 |
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 answered 01 Jun '17, 09:51 bgreiman |
What does "select current publisher" return?
select * from sysuserperm where publishauth = 'Y' returns a row with user_name 030000 which is the correct publisher
Yes, but what does the mentioned select return?
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'
Please can you still make sure that "SELECT CURRENT PUBLISHER" does also return the expected value?