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 for Me (Login required).

Search for additional results

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