Tuesday, March 5, 2013

[SQL 2012] Failing to deploy MDS package with MDSModelDeploy.exe

[SQL 2012] Failing to deploy MDS package with MDSModelDeploy.exe

Failing to deploy MDS package with MDSModelDeploy.exe

Posted: 25 Nov 2012 08:54 PM PST

Heya guys, i am deploying a .pkg for MDS using MDSModelDeploy.exeI am doing exactly what MS says. But get an error.this is my CMD code[code]c:\Program Files\Microsoft SQL Server\110\Master Data Services\Configuration>mdsmodeldeploy.exe listservicesMDS services (Service, Website, Virtual Path):MDS1, Default Web Site, MDSMDS2, Default Web Site, MDS1MDS3, ISPMasterDataService,MDSModelDeploy operation completed successfully. Elapsed time: 00:00:00.3989524c:\Program Files\Microsoft SQL Server\110\Master Data Services\Configuration> MDSModelDeploy.exe deploynew -package "C:\Programles\Microsoft SQL Server\110\Master Data Services\Configuration\Finance_data.pkg" -model Finance -service ISPMasterDataServiceMDSModelDeploy operation failed. Elapsed time: 00:00:00.0634293Error:The DeployNew command failed because either there is a missing - option or the name is not in quotes. All names that contain spas must be enclosed in quotation marks.c:\Program Files\Microsoft SQL Server\110\Master Data Services\Configuration>[/code]any idea why?thanks

Migrating from 2008R2 to 2012... any considerations?

Posted: 04 Mar 2013 07:04 PM PST

Hi,This week we will start migrating from SQL2008-R2 to SQL2012. Are they are known issues to consider? Or is it just a matter of restoring the databses from a backup and continue?Thanks,

Can't find options to retain partitions in SSAS Tabular Deployment?

Posted: 04 Mar 2013 11:05 AM PST

So I have created a new Tabular cube on 2012, deployed it for a while. And created a few new partitions via SSMS in the server to cover all the data. Now I have made some changes in the project, planning to deploy it to the server, but can NOT find an option to ignore existing partitions (that are not defined in the project itself) I have tried it on a test db, and no matter what i do... the project seems to deploy its definition, and overwrite what's on the server. meaning all the partitions that i created after deploy are WIPED! I have billions of rows of data, so reprocessing all the missing partitions are really not preferable... and managing the partitions in project but not in ssms is also not preferable as we typicall use scripts to add / manage partitions after it goes livewe have found some blog posts about changing .deploymentoptions file... but we don't know what value we should change to (not in BOL).. we changed it to "RetainPartitions" as a test.. but that doesn't workanyone has been through this? thanks

Error for Reinitialize Subscription in Snapshot Replication

Posted: 04 Mar 2013 06:37 AM PST

Hi all, I have Snapshot replication setup. I added a new article to my publication. I then went to the Replication monitor and right clicked on Reinitialize all Subscriptions. I get the error below. But when I manually run the SQL job which creates the snapshot and then run the job for the subscriber, everything runs fine. I don't understand the Reinitialize all subscriptions error message. I first thought this was a permissions issue, but have played around with the permissions in the distribution database and nothing has resolved the error. [i]Replication Monitor could not reinitialize one or more subscriptions that support automatic initilization. Additional Information: An exception occurred while executing a transact sql statement or batch. (Microsoft.SQLServer.ConnectionInfo)The subscripttion status of the object could not be changed. Could not update the distribution database subscription table. The subscription status could not be changed. Changed database context to "TestDatabase". (Microsoft SQL Server: Error 14068) [/i]
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog