none
File system error: A FileStore error from WriteFile occurred. Physical file: Logical file: . .

    Question

  • Errors when process dimension table as below:

    File system error: A FileStore error from WriteFile occurred. Physical file: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\lilo2.0.db\Tbl Fact Client Product Info View From Hive.0.dim\6.Id.ksstore. Logical file: . .

    I had googled some solutions, like processFull instead of processUpdate, "ByAttribute" instead of "ByTable", but still no luck.

    So, any other solution for this issue, except upgrading from SQLServer2008R2 to SQLServer2012?

    Backgrounds:

    1: SQLServer 2008 R2

    2. About 30 million rows for dimension table, and each row has 6 nvarchar columns, each row < 160 char

    Saturday, September 14, 2013 2:10 PM

Answers

All replies