Microsoft KB Archive/117516

FIX: NT SQL Admin May Be Erratic when Reading Tape Directory

PSS ID Number: Q117516 Article last modified on 10-31-1994

4.20

WINDOWS

BUG# NT: 9768 (4.2)

= SYMPTOMS =

When using the Windows NT version of SQL Administrator to scan the directory of a tape and one or more query timeouts occur, SQL Administrator may GP fault, return unreadable information, or fail to return at all.

When reading the tape directory using the Load Database selection under Manage Databases, the following situations may occur if SQL Administrator is configured to ignore timeouts:


 * If no timeouts occur, operations work normally.
 * If a timeout occurs, the data returned to the screen is garbled. For example, the “Volume Number” may be blank, and the “Volume Label” may be “Q0001”. No information is returned in the list of dumps. If the command is run again without exiting the screen, SQL Admin may end with an error message that the instruction at “0x00XXXXXX” referenced memory at “0x00XXXXXX”. The memory could not be “read”.
 * If the Tape Directory command is chosen, then the list box is simply filled with meaningless information.

= CAUSE =

The problem is caused by timeouts occurring while waiting for the results from SQL Monitor.

= WORKAROUND =

Upgrade to version 4.21. Or, increase the “System Functions” timeout to a value greater than the time it takes to scan the tape.

= STATUS =

Microsoft has confirmed this to be a problem in SQL Server version 4.2. This problem was corrected in SQL Server version 4.21. For more information, please contact your primary support provider.

Additional reference words: 4.20 SQL Admin tape hang trap Windows NT KBCategory: kbtool kberrmsg KBSubCategory: SSrvWinNT SSrvBkup SSrvSQL_Admin

=
================================================================

Copyright Microsoft Corporation 1994.