12-26-2009, 01:22 PM
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
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