I am having an automatic job which will run for every 30 mins. Sometimes, the dataload is getting failed
because of time-out error. Please find the error details below.
Source: Process IMPT DWH Dimensions Analysis Services Execute DDL Task
Description: OLE DB error: OLE DB or ODBC error:
Time-out occurred while waiting for buffer latch type 4 for page (3:346697), database ID 2.; 42000. End Error Error: 2010-09-21 10:48:15.86 Code:
0xC11F000C Source: Process IMPT DWH Dimensions Analysis Services Execute DDL Task Description: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'IPMT User Dimension',
Name of 'IPMT User Dimension' was being processed. End Error E. The step failed.
Please help me on this.
View Complete Post