Internal error

• BEIJCKM

  Mr or Mrs. 500

  Points: 583

  More actions

  September 4, 2003 at 11:35 pm

  #106031

  Processing cube failed due to internal error.

  Details:

  Analysis Server Error: Processing error [Internal error] 'Finance_rapport^Order'SOrder Id4508509565' ; Time:9/4/2003 4:04:06 PM

  I use a view. Nothing has changed on the base table (one column is added) but order is not the column that is added.

  Anybody any ideas.

  Thanks in advance.

  Regards,

  Bart

• September 8, 2003 at 8:00 am

  This was removed by the editor as SPAM

• Nico Verbaenen

  SSChasing Mays

  Points: 649

  More actions

  October 7, 2003 at 1:16 am

  #477304

  I have the same problem. The only difference is that I get this error when trying to process a new dimension.

  The source of the problem is a bit deeper in my case. The first error I got making this cube was when I wanted to count de member count of a level in my dimension. There I got the error Methode '~' of object '~' failed.

  I filled in the member count value manually with the correct value to work around this problem. But I didn't got far.

  There several other dimensions and cubes running fine for the last year and a half.

  Greetz,

  Nico

• BEIJCKM

  Mr or Mrs. 500

  Points: 583

  More actions

  October 7, 2003 at 3:00 am

  #477314

  Hi Nico,

  Thanks for the reply.

  I thought that I was the only person having

  this problem. For now the problem is still not fixed.

  What's the data type for the new dimension ?

  Regards,

  Bart

• Nico Verbaenen

  SSChasing Mays

  Points: 649

  More actions

  October 7, 2003 at 3:12 am

  #477315

  Bart,

  You're not alone...

  All the levels in my dimension are varchar.

  Other detail:

  The data I want to get is in 7 different tables (For each level 1 table)

  All joined togheter nicely.

  I've been looking on MSDN, BOL, ... nothing there.

  Greetz,

  Nico

• BEIJCKM

  Mr or Mrs. 500

  Points: 583

  More actions

  October 7, 2003 at 3:18 am

  #477316

  Nico,

  Varchar should not be a problem.

  Which DB are you using (Oracle, SQL server...) ?

  How many records are there in each table ?

  Has their been any changes in the driver settings on the server machine.

• Nico Verbaenen

  SSChasing Mays

  Points: 649

  More actions

  October 7, 2003 at 3:33 am

  #477318

  Bart,

  DB : SQL Server

  Nr of rec's Top table 7. Bottom table +/- 600.000

  No changes done to the server.

  Not at the SQL Server and not at the analysis server.

• Nico Verbaenen

  SSChasing Mays

  Points: 649

  More actions

  October 7, 2003 at 7:46 am

  #477368

  Bart,

  I've found a problem.

  On the lowest level I have moer then 65.000 records attached to one parent level.

  So more then 65.000 product under one catalog entry.

  Trying to solve the problem now. Maybe you should check this?

  Greetz,

  Nico

• BEIJCKM

  Mr or Mrs. 500

  Points: 583

  More actions

  October 7, 2003 at 7:49 am

  #477371

  Hi Nico,

  I think I've seen something simmilar...

  I'll see... I'll let you know the result.

  Regards,

  Bart