November 17, 2011 at 10:39 am
Hi,
I've come across this issue just today, where in a table is loaded through an Integration Services package from a data source [Flat file]. This package contains a workflow of tasks sequenced once after another going about executing certain stored procedures and queries which ultimately refreshes an cube stored in SQL Analysis Services 2005.
I'm not sure how this issue had arose, but the package / task had just stopped immediately after it started executing [Probably, the flat file had started bulk inserting data into the destination table into the local SQL database]. This happened due to some system issue (in the client machine where this package runs) had rebooted. I'm unable to load the package for running again after the machine had restarted. I'd tried to drill in and find out the root cause, however, it seems one of the base tables used in the package had become unusable. We are unable to view, load or recover any data from this table.
Is it possible to recover data (if not the structure atleast) of this table?? Had tried using the database option DBCC CHECKDB but in vain. Can anyone help?
Regards
Sarang
November 17, 2011 at 10:40 am
What did checkdb returns?
What db did you run the package on?
The only obvious answer to this problem is reload the package from QA env. Which I guess you thought about.
Do you have a backup of msdb?
November 17, 2011 at 10:51 am
Hi,
This package runs and updates / refreshes the cube stored in the Server. Initially, certain data files which are required are stored and loaded into the local database and processed, and this processed data is transferred to Server for cube refresh.
Do you have a backup of msdb? >> No, its a local DB, not MSDB database but an user-defined one. The local DB name is TESTING. The Server DB where the processed data is transferred for cube refresh is called DATAMART.
What did checkdb returns? >> Anyway, will post the results of DBCC CHECKDB 2mrw.
Regards
Sarang
November 17, 2011 at 10:53 am
Ok, do you have backups of those dbs?
please run checkdb with those switches => ALL_ERRORMSGS, NO_INFOMSGS
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply