Post reply

MS2000 Analysis Services Cubes unavailable

  • February 12, 2009 at 12:26 am

    #218450

    Hi all,

    Has anyone got a solution on following problem:

    Every night I have several jobs assigned to load in new data from text files into MS2000 database and further into dimension tables and cubes. All jobs run at a different time during the night and they all finish with no errors. When I check the cubes in the morning, all but 1 set of cubes work properly. The 1 set of cubes (3 cubes that have the same dimensions and add up to a virtual cube) is not ready for browse and needs to be processed.

    When I do a manual process of all 3 'bad' cubes + 1 virtual they all browse fine.

    But next night/morning we have the same problem.

    In the event viewer I see this msg when job finishes:

    8128 :

    Using 'xpstar.dll' version '2000.80.2273' to execute extended stored procedure 'xp_instance_regread'.

    Does this have an impact?

    SQl Server 2000 is running 8.00.2273, SP4, Standard Edition

    Analysis Services version 8.0.2039

    Both should be latest versions.

    Best regards, Peter :w00t:

  • February 12, 2009 at 12:41 am

    #942643

    Hi,

    You have analysis services log also, what does it say?

    Regards,

    Sriram

    Sriram

  • February 12, 2009 at 1:25 am

    #942648

    Hi

    Can you be more specific? Have never used this AS log before ... where is it located?

    BRPeter

  • February 12, 2009 at 2:02 am

    #942653

    Hi,

    you can right click on the server, and in one of the tabs over there you can enable logging and you will have to specify a location where you will get a .log file, generally it gives more information than what you see in the event log.

    Sriram

    Sriram

  • February 12, 2009 at 2:54 am

    #942663

    Hi Sriram,

    Have enabled logging - will check tmw morning for new info and revert to this media.

    Thanks for your help in this matter.

    BRPeter 🙂

  • February 13, 2009 at 1:09 am

    #943381

    Sriram,

    Today I see the same problem - 3 cubes+1 virtual are not available. And nothing in the new log. It seem that logging is not performed for batch jobs. I tried yesterday to refresh 1 cube, and logging was executed fine. But for all the night jobs, there was no logging.

    Same entry in the event log.

    Have you got any idea?

    BRPeter - back to :w00t:

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply