Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Analysis Server and Reporting Services (2008)  AMO Attribute exception : Errors in the OLAP stora

Author  Topic  snsn Starting Member 1 Post Posted - 2010-07-24 : 13:51:53 Hello I make proccess olap cube using by AMO in vb.net project, after adding new record it gets following error: AMO Attribute exception : Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'dbo_zakup_proplata', Column: 'zakup_id', Value: '5'. The attribute is 'Zakup Id'. Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. Errors in the OLAP storage engine: An error occurred while processing the 'Zakup Proplata' partition of the 'Zakup Proplata' measure group for the 'Main Db' cube from the Olap_db database. Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. Internal error: The operation terminated unsuccessfully. Server: The operation has been cancelled. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Errors in the OLAP storage engine: An error occurred while processing the 'Per Ostatki' partition of the 'Per Ostatki' measure group for the 'Main Db' cube from the Olap_db database. I am trying to proccess olap cube in vb.net using this code: Dim AMOServer As Server, AMODB As Database, AMOCube As Cube Try AMOServer = New Server() AMODB = New Database() AMOCube = New Cube() AMOServer.Connect("Data Source=localhost;Provider=msolap3.0;") AMODB = AMOServer.Databases.GetByName("Olap_db") AMOCube = AMODB.Cubes.GetByName("Main Db") ' MsgBox("Hello") AMOCube.Process(ProcessType.ProcessFull) ' MsgBox("Finished") AMODB.Dispose() AMOServer.Disconnect(True) AMOServer.Dispose() Catch ex As Exception Throw New Exception("AMO Attribute exception : " & ex.Message) Finally End Try is any solution for this problem?