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 ONE Support launchpad (Login required).

Search for additional results

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