Consultor Eletrônico



Kbase P31098: Using new dbtool found in 9.1D06 produces numerous errors ch
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   08/08/2003
Status: Unverified

FACT(s) (Environment):

Solaris SPARC 8

FACT(s) (Environment):

Progress 9.1D

SYMPTOM(s):

Using new dbtool found in 9.1D06

Running dbtool against database procedures many errors

DBTOOL options:

1. SQL Width & Date Scan w/Report Option
2. SQL Width Scan w/Fix Option
3. Record Validation
4. Record Version Validation
5. Read database block(s)
9. Enable/Disable File Logging

Q. Quit

Choice: 1

<connect>: (0=single-user 1=self-service >1=#threads)? 0

<recid>: (recid or all)? all

<table>: (Table number or all)? all

<area>: (Area number or all)? all

<display>: (verbose level 0-3)? 0

aborts analyzing the SQL widths with the following error message:

Record 529138849 in area 6 has table number 0 which doesn't exist.

CHANGE:

Installed 9.1D06 which includes dbtool utility

CAUSE:

Metascheam corruption as evidenced by the errors relating to sql width and date scan.

FIX:

Dump and load to resolve errors when checking/fixing sql widths (options 1 & 2)