Search code examples
c#sql-server-2008ssascube

System.Data.OleDb.OleDbException: Unspecified error while SSAS cube processing

I am new to this please help, I am not sure if this problem is related to SSAS cube processing or something else. Please help.

  1. The system was working fine.

  2. Some error about bad block occurred

has a bad block. that is [Drive D and Drive H]
The file system structure on the disk is corrupt and unusable. Please run the chkdsk utility on the volume STORAGE Volume.

    Drive D  is where the MySQL installation is located.

  1. Then as a corrective action we replaced a disk with new one .

  2. Cube reset was done as it was suspected data was corrupted by faulty disk.

  3. After disk replacement and cube reset the errors have changed

    Problem executing statement: SELECT statement 
    Thu, 09 Nov 2017 15:30:05 System.Data.OleDb.OleDbException: Unspecified error
     at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
     at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
     at DMTcommon.DBOps.RunNonQuerySQL(Int32 dbType, String& sql)

    Thu, 09 Nov 2017 15:30:05 Rejecting Files older than 20120201     
    Thu, 09 Nov 2017 15:30:05 Error in Bulk Insert:
    System.Data.SqlClient.SqlException: Invalid object name 'temp_table'.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResul  result, String methodName, Boolean sendToPipe)
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at DMTcommon.TransferFileObject.callParallelBulkInsert()

Further Analysis :-

After further analysis it is found that following query is failing to execute when tried directly on database

    Problem executing statement: SELECT  <some 95 columns>  INTO dbo.SUR_20171109_201711091530 FROM SUR_template 
Thu, 09 Nov 2017 15:30:05 System.Data.OleDb.OleDbException: Unspecified error

we also observed folowing :-

  1. Above query is successfully executing in other system.
  2. simple create query with few columns is successfully creating the table
  3. The query with few columns executes successfully but when we tried to execute again same query with few columns as before and with different SUR_date_time table name, it fails.

any ideas why is it happening?

Solution

  • The problem is with database. The database was corrupted somehow. Thanks for your responses. I really appreciate it. Thanks.