Help Fix Sybase Error 936

Approved: Fortect

1. Download Fortect and install it on your computer

2. Launch the program and click "Scan"

3. Click "Repair" to fix any issues that are found

Speed up your computer's performance now with this simple download.

In this tutorial, we’re going to highlight some of the possible causes that might lead to Sybase error 936, and then I’ll suggest some potential solutions that you can try to resolve this issue. Error 936 often occurs when trying to use a template while sp_who does not indicate CREATE DATABASE. The model database is not available. It is used to create the correct new database.

Symptom

Environment

Product

SAP Adaptive Server Enterprise 15.7 Sybase Enterprise Adaptive Server 15.0

Keywords

About This Page

This is a preview of the SAP Knowledge Base article. Click more to view the full version in the SAP ONE Support Launchpad (Login)necessary).

Search Detailed Results

• When trying to create a consumption model, error 936 is reported, but sp_who does not display the current DATABASE CREATE database.

Use template
go
Message 936, 14th level only, state 1
server ‘‘, line 1
Template list not available. It is used for a new database.

• dbcc dbtable starts the following accounts:

dbt_dbid = 3 dbt_stat = 0x 0 (0x0000)
dbt_stat2 = 0xffff8000 (0x8000 (DBT2_MIXED_LOG_DATA))
dbt_stat3 = 0x20000 (0x00020000 (DBT3_SYSPART_LOG_DATA) dbt_stat3 = 0x20000 (0x00020000 (DBT3_SYSPARTITIONS_EXISTS)) < br>
ush> d40_MIXED_LOG_DATA) (DBST_LOCK)) dbt_keep = 0 dbt_hdeskeep = 0 dbt_next = 0x100049fe080 dbt_systask_keep = 0 dbt_detachxact_keep 0
43 dbt_xdetach_detach= 0 0 dbt_detachxact_keep
dbt_detach_detachxact_keep 43 0 1 0 dbt_extstat = 0x0
dbt_lastsecfobbpnext = 0xbtold_lastselogbobpne_100
0xbt_lastselogbac_bp = 0x0bt08lastselogbac_bp = 0x0bt08lastselogbac_bp = 0x08t08lastsecfobbp = 0x95 db_gdupbr> DBT. .dbi_upgd_minor = 1554
dbt_dbinfobuf.dbi_dbinfovers = 5
dbt_dbinfobuf.dbi_sarg_vers = 2 dbt_threshstat = 0x0
dbt_thresholds = 0x10004a06010 dbt_thresh_200