Salesforce

Errors 263 or 276 when trying to run PROSTRCT STATISTICS online

Information

 
TitleErrors 263 or 276 when trying to run PROSTRCT STATISTICS online
URL NameP116434
Article Number000162485
EnvironmentProduct: Progress
Version: 9.x
Product: OpenEdge
Version: 10.0A, 10.0
OS: All supported platforms
Question/Problem Description
PROSTRCT STATISTICS reports that the database is in use and returns errors 263 or 276
PROSTRCT STATISTICS runs properly if the database is offline
Steps to Reproduce
Clarifying Information
Using a version of Progress lower than 9.1E04
Using a version of OpenEdge 10 lower than 10.0B05
Error Message** The database <file-name> is in use in single-user mode. (263)
** The database <file-name> is in use in multi-user mode. (276)
Defect Number
Enhancement Number
Cause
In versions of Progress/OpenEdge lower than 9.1E04 and 10.0B05, this is expected behaviour. PROSTRCT STATISTICS cannot be run when the database is in use. The database must be offline with all users logged out.
Resolution
Option #1:  Upgrade
  • Upgrade to Progress 9.1E04
  • Upgrade to OpenEdge 10.0B05
  • Upgrade to OpenEdge 10.1A and later

Option #2:  DBANALYS

If an upgrade is not possible, run DBANALYS instead:
    
$   PROUTIL <dbname> -C DBANALYS > dbanalys.out
   
The DBANALYS report will supply information about index, record and free chain blocks while the database is in use.
Workaround
Notes
Keyword Phrase
Last Modified Date1/17/2017 1:01 PM

Powered by