Search

MDS - Deployment error with default setup by AndrewTuerk

Active

4
0
Sign in
 to vote
Type: Bug
ID: 776307
Opened: 1/10/2013 8:36:59 PM
Access Restriction: Public
0
Workaround(s)
0
User(s) can reproduce this bug
Using a default installation of MDS, when trying to deploy a package it fails with error "value cannot be null", "parameter name: package". Check the system log. Not only is this error vague as to which system log to check (I still haven't figured that out), but it is also vague as to what needs to happen to resolve the issue. As it turns out, I added a "name" attribute to the "package" element in the xml and it resolved the issue. However, modifying the xml isn't a very good way forward.
Details (expand)

Product Language

English

Version

SQL Server 2012 - Enterprise Edition

Category

Master Data Services

Operating System

Other

Operating System Language

US English

Steps to Reproduce

1. install MDS
2. add a model, with default entity (no changes, although the first time I did some work)
3. create deploy file (success)
4. deploy file (fail)

Actual Results

the xml file that is generated has this in the first line:

<Package xmlns="http://schemas.datacontract.org/2004/07/Microsoft.MasterDataServices.Deployment" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

it succeeds in deployment if you add "name" as follows:

<Package name="test" xmlns="http://schemas.datacontract.org/2004/07/Microsoft.MasterDataServices.Deployment" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

Expected Results

if creating the deployment file succeeds, the deployment should succeed. this is especially true in such a basic test.

Platform

X64

Virtualization

 
File Attachments
File Name Submitted By Submitted On File Size  
OriginalandEditedPKG.zip (restricted) AndrewTuerk 2/8/2013 -
Sign in to post a comment.
Posted by Daniel Dittenhafer on 5/13/2013 at 5:26 AM
I waited the 15 minutes suggested by CraigD_ATL, but still received the error during MDM Package Deploy Wizard. Tried the MDSModelDeploy cmd line and received a different, more detailed error:

MDSModelDeploy operation failed. Elapsed time: 00:00:03.8091465
Error:
The web configuration file for the Master Data Services instance cannot be loaded.

An error occurred loading a configuration file: Access to the path 'c:\Program Files\Microsoft SQL Server\110\Master Data Services\WebApplication\web.config' is denied. (c:\Program Files\Microsoft SQL Server\110\Master Data Services\WebApplication\web.config)

MDS_ServiceAccounts has read access to web.config, as well as local Administrators (Full Control). I am in local Admin group, but wasn't able to open the file in Notepad for some reason (Access denied error in Notepad) so I explicitly added my account with Read access to web.config and successfully opened in Notepad. Then I went back to the MDM Model Deployment Wizard and tried again with the package deploy -> and it succeeded!

By the way, my SQL Server 2012 SP1 was a clean install (after an uninstall of SQL 2008). Default instance. Package file was created on same instance, same version.
Posted by Daniel Dittenhafer on 5/13/2013 at 4:38 AM
I have received this error also - Some details: SQL 2012 SP1 Dev Edition on Win 7 Pro. I am studying for 70-463 exam and following the steps from the Microsoft training kit book by Sarka, Lah, Jerkic, Chapter 16 Exercise 1 on pages 610-611. I received the error after step 17. This exercise is similar to CraigD_ATLs process -> export a mode, delete the model, then import the model from the package.

Currently waiting the 15 minutes that CraigD_ATL suggested and hoping it is a successful workaround.
Posted by CraigD_ATL on 4/2/2013 at 1:27 PM
I think I spoke too soon. Scratch my previous comment. It actually seems to be a timing (garbage collection?) issue. If I decide to delete a model and then deploy a package that contains a model with the same name I get this error. I have to wait approximately 15 minutes before I can deploy the package.
Posted by CraigD_ATL on 4/2/2013 at 12:24 PM
I ran into this error today. The problem went away after I closed the MDS interface and started fresh. I believe that I had another instance (explorer tab) open for adding members to a test model. I had since deleted this test model in another explorer tab (unaware that the other tab was open). When I tried to deploy the official package (with the same name and contents as the test model) I received the discussed error. Not going to lie. I was in panic mode for a few moments...
Posted by Microsoft on 3/22/2013 at 9:27 AM
Thanks to Andrew for helping us with the pkg file. Unfortunately, we are unable to reproduce the error. Adam, would you be willing to send us your pkg file as well?
Posted by Microsoft on 3/13/2013 at 11:52 AM
The info I have was that this is on SQL Server 2012. Can any of you answer:
- Was it a clean install or an upgrade from an earlier version?
- Do you have SP1 installed?
- Was the pkg file created on the same version you are trying to deploy to?
- Can you send the command line args you are using?
Thanks very much for working with us - we appreciate your time!
Posted by AdamP108 on 3/12/2013 at 12:02 PM
Actually even adding the name="test' in the first tag doesn't help me. Help very much appreciated!! Trying to get MDS to be installed by fairly large corporation, and this could be a deal breaker.
Posted by AdamP108 on 3/12/2013 at 11:57 AM
I'm having the same issue.

Value cannot be null.
Parameter name: package

For a Newly Created package from one MDS server (local default) to another.

Andrew, any way you could post the XML change you made?
Posted by AndrewTuerk on 2/8/2013 at 2:02 PM
My apologies for the delay, please find attached an original and an edited pkg file.
Posted by Microsoft on 1/22/2013 at 10:36 AM
Hi Andrew,
We are not able to repro this error. Would it be possible for you to send us your pkg file?
thanks,
Lynn
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement