August 20, 2012 at 8:18 am
Hi,
I'm trying to change the source of one of the dimensions in a small cube.
This particular dimension will henceforth be managed by MDS so I'm trying to update the named query to point at MDS views.
The problem is once I manke the change the dimension will no longer process.
The first error is a failure to log on. Which is odd since I can explore the data
2 further errors reference specific attributes.
I'm afraid I'm offsite at the moment so I don't have access to the exact messages.
One thing I want to check in the morning is that the attribute data types are correct, but I would have expected the error to mention truncation. And it wouldn't necessarily explain the logon failure message.
Anyone got suggestions on specific things I can check?
TIA
August 20, 2012 at 6:06 pm
The actual errors are:
"The following system error occurred: Logon failure: unknown username or bad password."
"Errors in the high-level relational engine. A connection could not be made with the DateSourceID of 'new source' Name of 'new source'"
"Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Project', Name of 'Project' was being processed."
"Errors in the OLAP storage engine: An error occurred while the 'Top Level' attribute of the 'Project' dimension from the 'ssas database' database was being processed."
"Internal error: The operation terminated unsuccessfully."
"Server: The operation has been cancelled."
This is what I get after I've forced the new data types to match the old ones. I've done this as casting in the named query after writing rules in MDS.
Any thoughts?
August 20, 2012 at 6:31 pm
Ok,
After deleting the old NQ and saving, then adding back the NQ and saving.
The view was missing from the dimension. I had to add it again and redo the mappings of key columns and name columns (remapping may not have been needed).
Then I went back to the Data Source for the new source and saw the password was blank (it wasn't previously! it seems to ask me each time I open up this project.) After addint the password back in again and hitting 'Test' I got an error.
This is new and might be the source of my problem. It says:
"The ImpersonationInfo for datasource 'new source' contains an ImpersonationMode that can only be used by a server administrator."
Judging by this article (http://blogs.msdn.com/b/john_daskalakis/archive/2009/12/16/9937631.aspx)
my permissions might have changed 🙁
August 20, 2012 at 7:05 pm
Turns out i'm still a local admin so therefore I'm still a SSAS server admin.
I believe the issue is that I didn't pay proper attention and set the impersonation option incorrectly when creating the new data source.
Should have been service account.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply