Voltar
-
Título
Error, "Object reference not set to an instance of an object" when using the Rebuild Indexes tool -
Descrição
Using the Rebuild Indexes tool in the Object Explorer and the following error appears:
System.NullReferenceExceptionObject reference not set to an instance of an object.Stack Trace:at Quest.Toad.DB2.Utilities.Rebuild.RebuildIndexZOS.AddIndexPartition(RebuildIXObjPropZOS obj, Int32 partition)at Quest.Toad.DB2.Utilities.Rebuild.RebuildIndexZOS.LoadDataInBackground()at Quest.Toad.DB2.Utilities.Base.BaseUtilForm.dataLoader_DoWork(Object sender, DoWorkEventArgs e)at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)This does not happen for all indexes in the schema, but for the ones where the error occurs it happens 100% of the time.
-
Causa
Invalid trailing spaces in the catalogs in the creator column for objects including indexes. Toad defect on not handling the scenario without exception. -
Resolução
WORKAROUND:
Drop and recreate the involved indexes to define the creator column correctly in the catalog.
STATUS:
Fixed in version 6.1. The latest version of Toad for DB2 can be downloaded here.
-
ID do defeito
TDB-1565 -
Informações adicionais
Run the following query to identify indexes where the creator has trailing spaces (and will cause an exception in Toad), thus it's possible to run outside of Toad such as command line to get the results: SELECT CREATOR, NAME, LENGTH(CREATOR) AS LGTH_CREATOR, LENGTH(RTRIM(CREATOR)) AS RTRIM_LGTH FROM SYSIBM.SYSINDEXES WHERE LENGTH(CREATOR) <> LENGTH(RTRIM(CREATOR));