Latest Updates

DBSPI40-1: Unable to fetch data from table 'sysfiles' [NULL value detected but no indicator variable present. (1)].

solution:

from dbspierror I saw:



02/15/08 12:17:17 ERROR dbspicam(10) chwssql01\insgdev01 [metric3278:../metric3278.SQC:171]: DBSPI40-1: Unable to fetch data from table 'sysfiles' [NULL value detected but no indicator variable present. (1)].



and then with the following the first output contained a nice clue:



dbspicam –m278 –v -p

"DBSPI-Internal: Cannot create a temp directory"



thus I deleted all files under \usr\ov\dbspi\temp



Sometimes this is also caused by hanging dbspimss.exe processes so check if any process stays there for longer than 1 hour and kill it.



Sometimes this is also fixed by doing this to all databases in the instance:



use <database>

drop table ##dbspi_space_free