|
Home > Archive > ASE Database forum > April 2005 > Proxy tables disappear suddenly
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Proxy tables disappear suddenly
|
|
|
| I have enabled CIS option and created proxy tables, all is normal and loal
ASE has never rebooted.
Today, I found all proxy tables are not found at my local ASE. I tried to
run "Select" from these tables, it prompts:
1> select count(*) from sequence_nbr
2> go
Msg 208, Level 16, State 1:
Server 'Remote_ASE', Line 1:
sequence_nbr not found. Specify owner.objectname or use sp_help to check
whether
the object exists (sp_help may produce lots of output).
Command has been aborted.
(0 rows affected)
Why? I have tested the connection and objects definitions using following SP
and the results are normal:
sp_helpserver
sp_helpobjectdef
sp_helprotect sequence_nbr
sp_help sequence_nbr (object exists)
sp_helpexternanlogin
(ext login is shown)
sp_remotesql Remote_ASE 'select @@servername' (Show remote server name, it
means connection is active!!)
So, anyone know what happen in my server? How to overcome this problem???
Thanks.
| |
| Mark K 2005-04-27, 7:24 am |
| If your 208 error is showing the Remote_ASE, then the problem isn't the
proxy tables. The problem is that your real tables on the Remote ASE are
missing. If you run sp_help sequence_nbr in the server/database where the
proxy table is, you will see the proxy table. However, if you run that on
the Remote ASE, it will not find the table.
Mark Kusma
http://www.sybase.com/support/about...t/otherservices
"DS" <danielso@sinaman.com> wrote in message news:426ef939$1@foru
ms-1-dub...
> I have enabled CIS option and created proxy tables, all is normal and loal
> ASE has never rebooted.
>
> Today, I found all proxy tables are not found at my local ASE. I tried to
> run "Select" from these tables, it prompts:
> 1> select count(*) from sequence_nbr
> 2> go
> Msg 208, Level 16, State 1:
> Server 'Remote_ASE', Line 1:
> sequence_nbr not found. Specify owner.objectname or use sp_help to check
> whether
> the object exists (sp_help may produce lots of output).
> Command has been aborted.
> (0 rows affected)
>
> Why? I have tested the connection and objects definitions using following
SP
> and the results are normal:
> sp_helpserver
> sp_helpobjectdef
> sp_helprotect sequence_nbr
> sp_help sequence_nbr (object exists)
> sp_helpexternanlogin
(ext login is shown)
> sp_remotesql Remote_ASE 'select @@servername' (Show remote server name, it
> means connection is active!!)
>
> So, anyone know what happen in my server? How to overcome this problem???
>
> Thanks.
>
>
>
|
|
|
|
|