NetBase SQL Shadowing Handbook

NetBase SQL Troubleshooting
____________________________________________________________
ver A0195 QUEST Software, Inc. 4-9
More than one slot found for the
same partition
(DBERR 2813)
Open_Log_Scan has received an array of SCR slots
where some partition has multiple COMMIT records.
To correct, retrieve a set of slots from the node
performing a soft resync, by issuing a Get_SCR call
with the LATEST option. Then retry the
Open_Log_Scan call.
Multiple database environments
updated in the same transaction.
(DBERR 15002)
This can happen if a single transaction has a mixture
of Apply_Log records and direct updates, or a mixture
of Apply_Log records from multiple masters.
MUST BE CONFIGURED BEFORE
IT CAN BE STARTED
You must modify "SQL - Enable Standby Logging"
within the CONFIG subsystem of NBCTRL, setting it
to "Y" prior to issuing the START SQL command.
New partition instance found, and
the current SCR does not have any
more slots.
(DBERR 15001)
This typically happens on a system with a large
number of partition IDs. Also, if this system has
switched master-shadow states with a number of
other systems, it will have a large number of non-
empty partition instances. The transaction will be
aborted by the ALLBASE product, but the user
application will need to terminate at this point. Do a
START DBE NEWLOG with a larger SCR size, and
re-establish soft resync connection with the master.
No apply WSL records transaction
currently active.
(DBERR 10049)
Apply_Log encountered a WSL record that was not a
BEGIN WORK record, and the BEGIN WORK WSL
record has not been processed for the transaction.
This could occur if the Apply_Log transaction was
aborted and the user tried to continue applying log
records without starting at the beginning of the
transaction. Also, transmission errors could cause the
beginning of the transaction to be lost.
Check the application to verify transactions are
correctly re-applied (especially in cases of
transactions which span multiple log buffers). If it is
correct, try to re-transmit the transaction and apply it.
If the problem persists, closing and re-opening the log
scan may be in order (in case the problem was due to
transmission from HP SQL to the Transmit_Log
process).
NO CURRENT SQL ACCESS You must start SQL within NBCTRL before you may
issue the SHOW SQL command. Enter START SQL,
and re-issue the SHOW SQL command.
ERROR MESSAGE SUGGESTION