"errors in the metadata manager the database with the name <yourDBName> already exists

Click to expand...

, chances are that you renamed the name of the database recently.

This is what happened in my case, and I ran into the error when trying to build the cube (and having changed the project settings to point at the changed database). As it turns out behind the scenes SSAS will keep track of databases with a database ID. The one I was attempting to build...

SSAS: errors in the metadata manager the database with the name <db> already exists]]>SSAS - Error THE ‘ROLE’ WITH ‘ID’ = {ID} DOESN’T EXIST IN THE COLLECTION.Tue, 14 Nov 2017 13:00:11 +0000http://www.mssqlforum.com/threads/ssas-error-the-%E2%80%98role%E2%80%99-with-%E2%80%98id%E2%80%99-id-doesn%E2%80%99t-exist-in-the-collection.26072/
http://www.mssqlforum.com/threads/ssas-error-the-%E2%80%98role%E2%80%99-with-%E2%80%98id%E2%80%99-id-doesn%E2%80%99t-exist-in-the-collection.26072/Peter SchmitzPeter Schmitz
Rather than re-doing all the work involved in defining dimensions, I imported the existing ones by right-clicking on the...

SSAS - Error THE ‘ROLE’ WITH ‘ID’ = {ID} DOESN’T EXIST IN THE COLLECTION.]]>SSIS - Milliseconds truncated from datetime variablesMon, 25 Sep 2017 08:23:28 +0000http://www.mssqlforum.com/threads/ssis-milliseconds-truncated-from-datetime-variables.26066/
http://www.mssqlforum.com/threads/ssis-milliseconds-truncated-from-datetime-variables.26066/Peter SchmitzPeter SchmitzSSIS - Milliseconds truncated from datetime variables]]>SSRS Error - An item with the same key has already been addedThu, 03 Aug 2017 13:27:04 +0000http://www.mssqlforum.com/threads/ssrs-error-an-item-with-the-same-key-has-already-been-added.26041/
http://www.mssqlforum.com/threads/ssrs-error-an-item-with-the-same-key-has-already-been-added.26041/Peter SchmitzPeter Schmitz
Not with this report. The error in the title popped up for me. It's a pretty non-descriptive title, though, so I popped open the Query Builder, hoping to find some kind of a hint there. Luckily, it did. In the "Alias" column, look for "Expr1".

The root cause of the error in my case was that I was doing a self-join in my table, and pulling out the same field...

SSRS Error - An item with the same key has already been added]]>SSIS - Search in filesTue, 04 Jul 2017 10:09:44 +0000http://www.mssqlforum.com/threads/ssis-search-in-files.26036/
http://www.mssqlforum.com/threads/ssis-search-in-files.26036/Peter SchmitzPeter Schmitz
Today, a colleague showed me this is actually possible inside Visual Studio. To do so, simply use CTRL + SHIFT + F. Alternatively, you can find it in the menu, by checking Edit -> Find and Replace -> Find in Files.]]>SSAS - Missing admin userFri, 30 Jun 2017 12:06:47 +0000http://www.mssqlforum.com/threads/ssas-missing-admin-user.26035/
http://www.mssqlforum.com/threads/ssas-missing-admin-user.26035/Peter SchmitzPeter Schmitz
In SSAS this manifested itself by my userid being replaced with a GUID, and seeing the message "user does not have permission to create a new object in '<PC-name>', or the object does not exist".

At the time he was copying some objects from one SSIS package to another, as he had been doing most of the day. However, all of a sudden this error popped up to ruin his day. He didn't actually try to save or do anything, but even just clicking back to the original package would pop up this error.

There was no immediate indication of what happened, but a bit of digging...

SSIS - Error: "an item with the same key already been added"]]>SSAS - Drill-through row count is capped at 1,000 rowsMon, 12 Jun 2017 12:24:51 +0000http://www.mssqlforum.com/threads/ssas-drill-through-row-count-is-capped-at-1-000-rows.26025/
http://www.mssqlforum.com/threads/ssas-drill-through-row-count-is-capped-at-1-000-rows.26025/Peter SchmitzPeter Schmitz
Seeing I wasn't the developer who originally set the drill-through up, I got a bit worried, as apparently this cap prevents her from doing the reconciliation we need for the project. Some quick poking around in SSAS also didn't reveal any limits or caps were implemented.

The data source view does not contain a definition for <column> in the <table> table or view"

Click to expand...

It usually means you need to refresh your data source view. However, you will need to ensure that any references to the particular column are also covered. Today, I ran into a situation where a dimension we originally referenced once now was split up into a role-playing dimension.

I.e....

SSAS - "The data source view does not contain a definition for <column>"]]>SSAS - "Deserialization failed: Error when trying to open cube designer in Visual Studio (SSAS)"Mon, 12 Jun 2017 10:15:57 +0000http://www.mssqlforum.com/threads/ssas-deserialization-failed-error-when-trying-to-open-cube-designer-in-visual-studio-ssas.26023/
http://www.mssqlforum.com/threads/ssas-deserialization-failed-error-when-trying-to-open-cube-designer-in-visual-studio-ssas.26023/Peter SchmitzPeter Schmitz
When that was done, I was greeted with the error:

Deserialization failed: Error when trying to open cube designer in Visual Studio (SSAS)

Click to expand...

As it turns out, the new name I provided for my measures was already used in a different measuregroup, and the graphical design window couldn't load because of that.

The solution was to...

SSAS - "Deserialization failed: Error when trying to open cube designer in Visual Studio (SSAS)"]]>RabbitMQ SSIS Component error: Could not load file or assembly ‘RabbitMQ.Client'Thu, 01 Jun 2017 11:43:40 +0000http://www.mssqlforum.com/threads/rabbitmq-ssis-component-error-could-not-load-file-or-assembly-%E2%80%98rabbitmq-client.26011/
http://www.mssqlforum.com/threads/rabbitmq-ssis-component-error-could-not-load-file-or-assembly-%E2%80%98rabbitmq-client.26011/Peter SchmitzPeter Schmitzinstalling the RabbitMQ source components for SSIS, I created a test package to see if I could actually get any data returned. However, when running the package, I was greeted with the following error:

System.IO.FileNotFoundException: Could not load file or assembly ‘RabbitMQ.Client, Version=3.1.1.0, Culture=neutral, PublicKeyToken=89e7d7c5feba84ce’ or one of its...

SSIS - Dark color scheme, white rowcount in Data Flow]]>SSIS - Getting the RabbitMQ components to work for SQL Server 2014Mon, 22 May 2017 11:21:25 +0000http://www.mssqlforum.com/threads/ssis-getting-the-rabbitmq-components-to-work-for-sql-server-2014.26009/
http://www.mssqlforum.com/threads/ssis-getting-the-rabbitmq-components-to-work-for-sql-server-2014.26009/Peter SchmitzPeter SchmitzGitHub. While attempting to do so, we ran into a few issues, so I figured I'd write a quick guide on what we did to get this to work.

First, we downloaded the zip file, and unpacked it on my development server. Once it was unzipped, we opened the solutioni n Visual Studio. Our target server is SQL Server 2014, and the version of Visual Studio the package was opened in is Visual Studio 2013...

SSIS - Getting the RabbitMQ components to work for SQL Server 2014]]>Find out which SSIS package(s) are executed more than onceMon, 22 May 2017 08:52:06 +0000http://www.mssqlforum.com/threads/find-out-which-ssis-package-s-are-executed-more-than-once.26008/
http://www.mssqlforum.com/threads/find-out-which-ssis-package-s-are-executed-more-than-once.26008/Peter SchmitzPeter Schmitz
In order to try and extract that information from SSISDB, rather than manually going...

Find out which SSIS package(s) are executed more than once]]>SSIS - Automate an Execute Process Task with variable argumentsMon, 06 Feb 2017 15:55:13 +0000http://www.mssqlforum.com/threads/ssis-automate-an-execute-process-task-with-variable-arguments.26000/
http://www.mssqlforum.com/threads/ssis-automate-an-execute-process-task-with-variable-arguments.26000/Peter SchmitzPeter Schmitz
Normally this is exactly how you would use variables, but with the Execute Process you cannot enter variables into the Arguments field, as they would be passed directly to the command window as is, and thus not supply the actual values...

SSIS - Automate an Execute Process Task with variable arguments]]>SSIS - Flat File Connection Manager using VariablesMon, 06 Feb 2017 13:23:08 +0000http://www.mssqlforum.com/threads/ssis-flat-file-connection-manager-using-variables.25999/
http://www.mssqlforum.com/threads/ssis-flat-file-connection-manager-using-variables.25999/Peter SchmitzPeter Schmitz
When executing the loop, though, the sourcing seemed to fail once the loop finished once. After some frustrating time spent figuring out why things were not working, I pinpointed the issue to the file-name variable used as output within the For...

However, as it turns out, a number of the rows contained fields where end users added commas in the field (for example an address). In these cases, the data for that column was surrounded with double quotes (").

Cannot obtain the required interface ("IID_IBSchemaRowset")]]>Adding additional maps to SSRSMon, 01 Oct 2012 21:00:00 +0000http://www.mssqlforum.com/threads/adding-additional-maps-to-ssrs.58/
http://www.mssqlforum.com/threads/adding-additional-maps-to-ssrs.58/Peter SchmitzPeter Schmitz
Luckily, this is pretty easy to do. The biggest thing will probably be locating maps that contain spatial data that can then be linked to the actual data tables (which also will have to contain spatial data), but luckily there is a CodePlex initiative collecting several of these maps. The project has been dubbed...