SAP Knowledge Base Article - Preview

2835023 - Behavior when dropping a table type from a database that was loaded

Symptom

A dump database was loaded into a target server where dbid is not the same as source server. This database has a table type.

1) When trying to drop type in target database then hit in error 3705:

1> use db02
2> go
1> drop type tbl_type_01
2> go
Msg 3705, Level 16, State 7:
Server 'asewin16', Line 1:
Cannot use DROP TYPE with 'tb01' because 'tb01' is a table. Use DROP TABLE.

2) The other behavior observed: if we have in the same server two copies of a database. Both have different dbid. We execute the command to drop the type in the second database but the type is dropped in the first database:

1> use db01
2> go
1> select id, name, uid, type from sysobjects where name = "tbl_type_01"
2> go
id
name
uid type
-----------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------- ----
2022919891
tbl_type_01
1 TT

(1 row affected)
1> use db02
2> go
1> select id, name, uid, type from sysobjects where name = "tbl_type_01"
2> go
id
name
uid type
-----------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------- ----
2022919891
tbl_type_01
1 TT

(1 row affected)
1> drop type tbl_type_01
2> go
1> select id, name, uid, type from sysobjects where name = "tbl_type_01"
2> go
id
name
uid type
-----------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------- ----
2022919891
tbl_type_01
1 TT

(1 row affected)
1> use db01
2> go
1> select id, name, uid, type from sysobjects where name = "tbl_type_01"
2> go
id
name
uid type
-----------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------- ----

(0 rows affected)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 and later 

Product

SAP Adaptive Server Enterprise 16.0

Keywords

 load database drop type table error 3705 systypes xdbid 819970 , 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.