SAP Knowledge Base Article - Preview

2113264 - Stacktrace with Error 692 on CREATE DATABASE - SAP ASE

Symptom

  • The "create database" command fails with Error 692 in the ASE error log.
  • The "dbcc page(dbid, pagenumber, 0, 1, 1, -1)" command does not complete in over 5 minutes.
  • Database devices are created on iscsi storage
  • Stacktrace looks like this:

kernel Direct i/o enabled for ufs file
kernel Initializing virtual device 3 with dsync 'off'
kernel Virtual device 3 started using asynchronous (with DIRECTIO) i/o.
Initializing device with zeros. kernel Finished initialization.

server Error: 692, Severity: 20, State: 1 Uninitialized logical page 'pagenumber' was read while accessing database , object, index, partition .
server  Error: 1251, Severity: 26, State: 1
server An in-use preallocated semaphore cursor was encountered.
kernel SQL causing error : insert into #t1 (dbid) select dbid from master.dbo.sysdatabases where name like @dbname /* ** Now for each dbid in #spdbdesc, build t
kernel Current statement number: 41 Current line number: 211
kernel ************************************
server SQL Text: insert into #t1 (dbid) select dbid from master.dbo.sysdatabases where name like @dbname
Now for each dbid in #t1, build the database status ** description. */
server SQL Text: create table #t1 ( dbid smallint null, dbdesc varchar(777) null )
Initialize #t1 from sysdatabases
pcstkwalk+0x18()
ucstkgentrace+0x23c()


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

hardware, fault, 605 , 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.