I am working with Decision Tree mining model with the Model specs as below.
The source for training data is a table from sql server 2008 with 210 Million rows. Structure is as below.
Upon training the Model, at some point through the training process, It errors with the below message
File system error: A FileStore error from WriteFile occurred. Physical file:
\\?\M:\OLAP\Data\KWProject.0.db\MiningStructureHooks ~MC-Phrases Key.7.dim\11.Phrases Key.asstore. Logical file: . .
Observing the file grow in the File location M:\OLAP\Data\KWProject.0.db\MiningStructureHooks ~MC-Phrases Key.7.dim\11.Phrases Key.asstore,
it seems to error out when reaching around 4GB.
I have seen other sites/forums with same errors and the resolution being either using ROLAP or ByAttribute/ByTable or setting the <PropertyBufferRecordLimitEnabled>1</PropertyBufferRecordLimitEnabled>
to 1 in the msmdsrv.ini file.
Since this is not a cube, ROLAP and ByAttribute setting didnt apply here.
I have tried with the PropertyBufferRecordLimitEnabled setting to a 1 but with no luck.
Model and source table structure is as below-
Key bigint (Key)
Pages int (Predict)
Views int (Predict)
Rows in the table: 210 Million
I have tr
View Complete Post