SAP Knowledge Base Article - Preview

2458104 - After load a database dump to new database, some tables cannot be selected correctly, Msg 208 is reported

Symptom

After loading a database dump to new database, some tables cannot be selected correctly, even the table name can be found in the table sysobjects.

Error message below can be found:

select * from sample_table
go 
Msg 208, Level 16, State 1: 
Server 'test_server', Line 1: 
sample_table not found. Specify owner.objectname or use sp_help to check whether the 
object exists (sp_help may produce lots of output).

Mismatch can be found from sp_helpuser, in this case, the login_name should be the 'test' but not 'Non_test'

1> sp_helpuser
2> go
Users_name     ID_in_db        Group_name    Login_name
--------------- --------------- ---------------- ---------------------
test                   3                     public              Non_test
usedb_user       4                     public              NULL

(1 row affected)
(return status = 0)


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

Msg 208, sp_helpuser , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.