Post reply

AS 2005 - Roles get reset when cube is rolled

  • October 26, 2006 at 5:14 pm

    #114896

    I'm running ProjectServer 2003 on SQL Server 2005, AS 2005.  The cube kicks off fine, and completes successfully.  Not seeing any errors...etc.  The cube is scheduled to be processed every night via ProjectServer, and when it is run this way, the user roles to access the cube must be re-created manually.  When this was running on AS 2000, these roles persisted automatically.  Any idea what is happening here?

  • November 8, 2006 at 12:39 pm

    #670689

    Yes, I certainly will.  We're actually starting to think this is a bug...

  • November 9, 2006 at 8:45 pm

    #670980

    Hey James,

    No solution on offer but what you *could* try is have a trace start up before your cube processing run (by the proj server).  The trace log in AS2K5 is quite good, it should show you exactly what's happening.  I would expect to either see a drop of the roles or possibly a complete recreation of the DB without the roles included.

    Cheers,

     

    Steve.

Viewing 3 posts - 1 through 3 (of 3 total)

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