Tuesday, January 25, 2022

Failed to validate Business Rule created by MDS API in MDS 2012

Failed to validate Business Rule created by MDS API in MDS 2012

I used MDSModelImport and created business rules for composite primary keys by MDS API.

When I first insert data from excel, I faced error "A database error has occurred".

After I tried to edit and re-save with no changes in mds web site, It worked. but It didn't work from API.

Let me know. Please.

Error Log

error number is 208: Code 208 invalid object name 'cteDuplicates669d2125e1dfca7671b321a20c997505'

Code for creating and publishing for composite primary keys:

private static void CreateAndPublishPrimaryBR(string modelName, string entityName, string[] columnNames)   {   try   {   // Set Model and Entity objects.   Identifier modelId = new Identifier { Name = modelName };   Identifier entityId = new Identifier { Name = entityName };     // Create the request object.    BusinessRulesCreateRequest ruleCreateRequest = new BusinessRulesCreateRequest();   ruleCreateRequest.ReturnCreatedIdentifiers = true;   ruleCreateRequest.BusinessRuleSet = new BusinessRules();     // Create a new business rule.   BusinessRule newRule = new BusinessRule();   ruleCreateRequest.BusinessRuleSet.BusinessRulesMember = new List<BusinessRule> { };   ruleCreateRequest.BusinessRuleSet.BusinessRulesMember.Add(newRule);     newRule.Identifier = new MemberTypeContextIdentifier   {   Name = "pk",   ModelId = modelId,   EntityId = entityId,   MemberType = MemberType.Leaf   };     newRule.Priority = 20;     BRAction ruleAction = new BRAction();   newRule.BRActions = new List<BRAction>();   newRule.BRActions.Add(ruleAction);   ruleAction.Sequence = 1;     // Set the action prefix argument for Name attribute.   BRAttributeArgument actionPrefix = new BRAttributeArgument();   ruleAction.PrefixArgument = actionPrefix;   actionPrefix.PropertyName = BRPropertyName.Anchor;   actionPrefix.AttributeId = new Identifier { Name = columnNames[0] };     // Set the action operator.   ruleAction.Operator = BRItemType.Unique;     if (columnNames.Length > 1)   {   // Set the action postfix argument for    ruleAction.PostfixArguments = new List<object>();   for( int i= 1; i < columnNames.Length; i++)   {   BRAttributeArgument postArgument = new BRAttributeArgument();   ruleAction.PostfixArguments.Add(postArgument);   postArgument.PropertyName = BRPropertyName.Anchor;   postArgument.AttributeId = new Identifier { Name = columnNames[i] };   }   }      // Create the business rule.   BusinessRulesCreateResponse ruleCreateResponse = mds.BusinessRulesCreate(ruleCreateRequest);     HandleOperationErrors(ruleCreateResponse.OperationResult);     // Create the request object.   BusinessRulesPublishRequest rulePublishRequest = new BusinessRulesPublishRequest();   rulePublishRequest.BRPublishCriteria = new BRPublishCriteria();   rulePublishRequest.BRPublishCriteria.EntityId = entityId;   rulePublishRequest.BRPublishCriteria.ModelId = modelId;   rulePublishRequest.BRPublishCriteria.MemberType = BREntityMemberType.Leaf;     // Publish the business rule.   MessageResponse rulePublishResponse = mds.BusinessRulesPublish(rulePublishRequest);     HandleOperationErrors(rulePublishResponse.OperationResult);   }   catch (Exception ex)   {   Console.WriteLine("Error: {0}", ex);   }   }





Reply:

Hi Takatoshi,

Thank you for your question. 

I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated. 

Thank you for your understanding and support.

Regards,

Charlie Liao
TechNet Community Support


------------------------------------
Reply:
Takatoshi, have you made any progress with this issue?
Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

Forcing a revalidation AND sending alert email, how to?

Hi,

I want to push some data in MDS and validate them through the business rules in place.

this is working fine.

Except that MDS did not send EMail alerts to the user on existing members.

I set the validation status to new for all existing members then I call the mdm.udpValidateMembers procedure.

all the members are correctly revalidated, but the ones in error are not sent in any email.

So how can I force this?

thanks.


Reply:
Will, have you made any progress with this issue?
Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

MRD on Mac?

Windows clients are working fine, but the Microsoft Remote Desktop app for MAC will not work unless I use the IP of the machine itself.   

Thoughts?  Solutions?  Anyone else seeing this issue?

THanks

Environment: Server 2012 R2

Clients: Mac and PC.  PC works, mac does not.  


  • Edited by Tony Tellez Monday, December 19, 2016 5:47 PM

Reply:
UPDATE: Asks me to authenticate, then I get an error that says "Unable to connect to remote PC.  Please provide the FQN or the IP address of the remote PC, and then try again."

------------------------------------

MDS 2016 - Adding domain user: no exact match error

I set up MDS on a standalone Windows Server 2012 box. Now we want to let other users access the web app via the Excel Add-in from their laptops on the company domain. We NAT'ed the web server and can access it using the local server username and password.

We then joined the server to the domain, but when I try to add domain users (ourdomain.local\jdoe) I get a "No exact match was found for ____" error.

Is this due to the fact that the MDS Services account is a local user? I can get a domain MDS User Account set up, but will it have the correct roles?

Thanks.

BTW, the .local predates me.


Reply:
WCAL, have you made any progress with this issue?

Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

Can't delete an attribute or hierarchy

Hi

I can't delete attributes from an entity in Master data services 2016. When I press the delete button the status icon changes to read with the sign !. When I hover over the icon the text is only "error".

When I'm trying to delete a hierarchy the status hangs on GenericStatus_Updating.

I have tried this on our test server which have been updated from 2014 to 2016. When I noticed the problem on our test server I made the same test on the live server which are a fresh 2016 installation. And the problem was exactly same on the live server.

There is no problem to make new or edit entities, attributes or hierarchies. It's only problem to delete objects.

Have I missed something I need to do in 2016.?

Tanks in advance

Christopher


Reply:

Here is some more information about the problem.

I changed to full loging with the switchValue Verbose in web.confog. I noticed that there was no new log entries after I had pressed delete.

I pressed F12 in IE and then pressed the delete button and got this error...

SCRIPT5007: Unable to get property 'Errors' of undefined or null reference
ViewModelAdminAttribute.js (653,41)

It looks like the problem is in the j-script.

/Christopher


------------------------------------
Reply:
Christopher, have you made any progress with this issue?

Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

Cannot associate Website to Database - [No Master Data Services instance section exists]; upon clicking [Apply]

Issue: "No Master Data Services instance section exists"
the pop-up box shown above appears no matter what i do:
- reinstalling IIS with all the required settings
- recreated MDS database
- recreated MDS website with Application Pool and Website

Machine Platform:
Computer - i5, 8GB RAM, 1 TB Drive
Operating System - Windows 10 PRO - all updates applied
SQL Server 2016 - 13.0.1601.5
Master Data Services - 13.0.12.0
Log in: Administrator

Master Data Services Configuration:
File Location: C:\Program Files\Microsoft SQL Server\130\Master Data Services\WebApplication
Database Configuration - Named "MDS" with standard defaults
Website - "MDS"
Web Application - /root (application)
Alias - blank
Log in for Application Pool - Administrator
Associate Application with Database - "MDS"
Click Apply - shows pop-up box = "No Master Data Services instance section exists"
Create Website - IP address = "All Unassigned", Port = "81", Host Header = blank, User Name is Administrator
Uses - HTTP Protocol

IIS:
Version 10.0.14393.0 (OS Build 14393.321)
Internet Configuration - Windows features - all feature for IIS are set according to Master Data Services requirements, Internet Information Services = Green Checkmark 
"MDS" Site - For MDS  - Windows Authentication Enabled
"MDS Application Pool" - .NET CLR Version v4.0.30319, Integrated

web.config = 
<configuration>
    <connectionStrings>
        <add connectionString="Server=.;Database=MDS;Integrated Security=true" name="MDS" />
    </connectionStrings>
<masterDataServices>  
<instance virtualPath="/MDS" siteName="MDS" connectionName="MDS" serviceName="MDS" />  
</masterDataServices> 
</configuration>


Reply:

Hi Mark,

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/3879b3ca-5aae-4ee0-9897-0181c142dacd/no-master-data-services-instance-section-exists?forum=sqlmds

Please click Mark As Answer if my post helped.


------------------------------------
Reply:

Hi Vishe, thank you for your response, I truly appreciate you taking the time to research and respond.

I too found this post before i created the ticket, (also it appears to be the only post out there addressing this issue), and  reviewed it over and over to see if there was anything I could glean from it to solve my challenge; however, it has not helped. :-(  Maybe if there is something in this post i am missing based on the specifications above, please let me know.

Thanks!


------------------------------------
Reply:
Mark, have you made any progress with this issue?

Thanks!

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!


------------------------------------

Can manager access the OneDrive for Business of a departed employee beyond default 30 days?

Managers usually get following notification when a departed employee's account is deleted from AD. 

"User1's account has been deleted from the Active Directory. Their OneDrive for Business will be preserved for 30 days. You're the temporary owner of all documents saved to their OneDrive for Business. If you would like to save content beyond the 30 day retention period, you can copy important documents to another location. You can also contact your administrator to reassign ownership to another OneDrive for Business owner. After 30 days, User1's OneDrive for Business will be permanently deleted." 

I would like to know if the manager can access employee's OneDrive data beyond 30 days without placing it on hold. According to this article https://jinkang.us/2016/08/11/onedrive-for-business-configurable-retention-period-for-orphaned-onedrives/, the default retention days can be set to max 3650 days. Does it mean the OneDrive data of the departed employee will be kept for 10 years instead of 30 days? Once change the default retention days to 3650 days, will the text "30 days" automatically be changed  to "3650 days" in the notification ?

"I was surprised to see that the May 2016 release of the SharePoint CSOM (v 16.1.5312.1200) introduced a new property called OrphanedPersonalSitesRetentionPeriod that allows you to Get or Set the default retention days to OneDrive for Business sites. Even better, the values can be set between 30 to 3650. That's measured in DAYS! Which means max value is 10 years!!"

Thanks In Advance !



This posting is provided AS-IS with no warranties/guarantees and confers no rights.


  • Edited by KungfuPanda2 Monday, December 12, 2016 7:50 PM
  • Changed type KungfuPanda2 Tuesday, January 10, 2017 4:54 PM waiting for answer

Reply:

Yes, we can now set the duration for which the ODFB sites will be kept. This doesn't prevent anyone from deleting files though, so if you need to meet compliance requirements Hold is still the answer.

You can use SPO PowerShell to configure ODFB sites retention:

Set-SPOTenant -OrphanedPersonalSitesRetentionPeriod 3650


------------------------------------
Reply:
Thanks Vasil for you answer. Regarding my second question in the post, will it change the text "30 days" to "3650 days" in the notification or it is something we can manually  change ?

This posting is provided AS-IS with no warranties/guarantees and confers no rights.


------------------------------------
Reply:
Havent bothered to check on that, sorry :)

------------------------------------
Reply:
I run Set-SPOTenant -OrphanedPersonalSitesRetentionPeriod 3650 and found the manager not receiving the notification anymore when OneDrive cleanup process starts for departed employees. Can anyone share experience what happens to the notification when the default retention days of OneDrive changes? Thanks in advance.

This posting is provided AS-IS with no warranties/guarantees and confers no rights.


------------------------------------

ATA Lightweight Gateway performance issues

I have been setting up ATA 1.7 in our environment,  I have installed the ATA gateway on three of our domain controllers, and two are having performance issue.  The error I am seeing is Some network traffic is not being analyzed, with a recommendation of adding additional processor and\or memory.  Prior to installing the ATA gateway we did monitor the packets\sec on the network adapter, we averaged around 3000 to 4000, with peaks around 10,000.  I have been monitoring for the last 6 hours on them, and we are averaging around 2,500.   Spec wise they are running 4 cores 24 GB of RAM, on the one that is working.  On the two that are not working one has 4 cores the other has 6 cores, both have 24 GB of RAM.  From the documentation these should be more then enough to handle the ATA lightweight gateway.

I have been monitoring resource monitor on the three servers, thinking other AD processes are consuming to much resources to allow ATA to run, the following is what I have seen over the last couple days.

DC 1, Working - (4 Cores) CPU utilization between 25 and 40%.  Memory, (24GB) currently at 88% utilized, 21.8 GB used, 1.1 GB free and 1.6 in stand by.  The biggest consumer is the lsass.exe process, consuming about 18.5 GBs, tri.gateway.exe with just over 2 GB consumed.

DC 2 Not working - (4 Cores) CPU utilization between 25 and 40%.  Memory (24GB) currently at 75% utilized, 18.3 GB used, 4.5 GB free, and 1.4 GB in stand by.  The biggest consumer is the lsass.exe process, consuming about 15.7 GBs, tri.gateway.exe with just over 1.5 GB consumed.

DC 3 Not working - (6 Cores) CPU utilization between 25 and 30%.  Memory (24GB) currently at 90% utilized, 21 GB used, 1 GB free, and 2 GB in stand by.  The biggest consumer is the lsass.exe process, consuming about 19.9 GBs, tri.gateway.exe with just over 1 GB consumed.

Initially the DCs had 4 Cores 16 GB of memory, we have slowly increased all up to 24 GBs. DC 1 started working with out issue once it had 20 GBs.  We also increased  one DC to 6 cores, again with out an success.  The were all installed in the last week, all with the latest version from our ATA center server.  The servers are in a VMware environment.  I am at a loss as to why these servers are having performance issues. I don't want to continue to deploy the ATA agent to the remaining DCs, as the allocation of resources could easily get out of hand to continue to increase core and memory. Any Ideas?



  • Edited by Evers_mark Thursday, December 15, 2016 3:12 PM had two dc 2

Reply:
During my research I found the I wasn't running the latest version of ATA, I was running 1.7.5402.  I have since updated to  1.7.5757 for both the ATA center and all three lightweight gateways.  All three Domain controllers\lightweight gateways were rebooted.  With in 15-20 minutes  the same 2 DCs reported errors concerning not anaylizing all network traffic, again recommend adding additional CPUs or Memory.  The item that is odd, is both domains have more then enough resources since the reboot.  One has 18.5 GB free memory, and 50% CPU free, the other has 15 GB free, with 50% CPU Free.  Again I am monitoring the Packets per second, since the reboot, both are averaging less then 5000 Packets\sec.  Maximum has been 7100 and 11,000 on the two respectively.

------------------------------------
Reply:

Are those VMs or physical machines?

I too saw those warnings during lightweight gateway deployments on few of my DCs hosted on VMWare ESX.

I changed these settings on my DCs network adapter as outlined in here to fix the 'Some network traffic is not being analyzed' warnings.

Network Connection icon - Properties - Configure - Advanced Tab.

1) Set 'IPv4 TSO offload' to Disabled.

2) Set 'Large Send Offload v2 (IPv4)' to Disabled.

3) Set 'Large Send Offload v2 (IPv6)' to Disabled.

Thanks,

Pradeep


------------------------------------

Removing CAS from hierarchy

Hi,

We have SCCM hierarchy with CAS and 3 primary Sites. Now, we are planning to restructure the hierarchy to minimize the management and maintenance overhead with single stand alone primary site server.

What is the best method to be followed to transform the hierarchy to stand alone primary site.

Also, please suggest that possibility to remove the CAS from hierarchy after converting 3 primary into 1 primary.

Thanks,

Kumaresan Lakshmanan

  • Changed type TorstenMMVP Monday, December 19, 2016 12:12 PM

Reply:

Duplicate of https://social.technet.microsoft.com/Forums/en-US/5c7a7800-0230-47e4-bac2-a523daf9e98a/remove-cas-from-primary-site?forum=configmanagergeneral

Locking thread.

Torsten Meringer | http://www.mssccmfaq.de


------------------------------------

LocalGPO support for W2012R2

We use LocalGPO to configure our servers and it is great tool. We just tried to use it on W2012R2 and got an error message that said it was only supportd on WXP, W2003, Vista, W2008, W7, W2008R2, W8, W8 Server (Which I assume is W2012 because we are using it on W2012). In any case it won't run on W2012R2. Anyone know if this is going to be supported. I am assuming that MS will update SCM since that is where all the Security guides are now but will LocalGPO also be updated? Thanks.

Roger

Roger

  • Changed type Yan Li_ Monday, October 28, 2013 2:00 AM

Reply:

Hi,

It seems like that there is no localGPO for Windows 2012 yet.

Here is a similar thread:

http://social.technet.microsoft.com/Forums/en-US/70c4b668-de5b-4ef1-9ed2-0273956fd2c5/localgpo-on-win8server-2012?forum=compliancemanagement

In addition, the below forum should be the right place for this issue:

http://social.technet.microsoft.com/Forums/en-US/home?forum=compliancemanagement

Regards,

Yan Li

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
Thanks for helping make community forums a great place.


------------------------------------
Reply:

Hi,

Just checking in to see if the suggestions were helpful. Please let us know if you would like further assistance.

TechNet Subscriber Support

If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
Thanks for helping make community forums a great place.


------------------------------------
Reply:
We found a spot in the script where it checked for version and simply changed it to bypass the check. Then it worked fine. The W2012 Local GPO applied to W2012R2 just fine. I still would like to know if there will be an update to SCM 3.0 to add new templates for W2012R2. I would like to compare my current GPO to the MS recommended baseline for W2012R2 but the original question is no longer an issue.

Roger


------------------------------------
Reply:

Or you can make the OS check work by replacing (line 422):

If(Left(strOpVer,3) = "6.2") and (strProductType <> "1") then 
    strOS = "WS12"

With 

 If(Left(strOpVer,3) = "6.2" or (Left(strOpVer,3) = "6.3")) and (strProductType <> "1") then 
    strOS = "WS12"


------------------------------------
Reply:

More simply, you can comment out the call to "ChkOSVersion"

' Call ChkOSVersion

Just add ' to the top of line 278 and good to go.


------------------------------------
Reply:

I am working on a windows 2012 r2 system and changed the Call ChkOSVersion in the script.

It works but does NOT apply all settings like the Security Options.

Now i know why its not supported because it doesnt work a 100%


------------------------------------

Create login for group of windows

On each windows, system defaults Users group. I want to create a login for Users group. I tried but SQL denied and show error

"

TITLE: Microsoft SQL Server Management Studio

------------------------------

 

Create failed for Login '[SeverName]\Users'.  (Microsoft.SqlServer.Smo)

 

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.6020.0+((SQL11_PCU_Main).151020-1526+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Login&LinkId=20476

 

------------------------------

ADDITIONAL INFORMATION:

 

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

 

------------------------------

 

Windows NT user or group '[SeverName]\Users' not found. Check the name again. (Microsoft SQL Server, Error: 15401)

 

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.6248&EvtSrc=MSSQLServer&EvtID=15401&LinkId=20476

 

------------------------------

BUTTONS:

 

OK

------------------------------

"

Please help me to resolve.

Thanks


Reply:

Windows NT user or group '[SeverName]\Users' not found. Check the name again


And you are sure you entered (or selected?) the right Windows domain group; but the error message it seems not?

Olaf Helper

[ Blog] [ Xing] [ MVP]


------------------------------------
Reply:

I just created a group. the TSQL command should be

USE [master]
GO
CREATE LOGIN [PUBLISHER\Users] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO

Where publisher is the name of my server.

Did you try SeverName\Users? When you browse for the users windows group you need to select the object type groups, then type users and click the check name button to validate it.


------------------------------------
Reply:
Yes. I am sure. Because I choose from browser 

------------------------------------
Reply:

Yes, I did. But I can not do like you.

I just tried but don't work


------------------------------------
Reply:

List all account in Users group:

- Ai Le

- NT Authority\Authenticated Users (S-1-5-11)

- NT Authority\Interactive (S-1-5-4)

- Philix

The detailed message

===================================

Create failed for Login 'PHILIX09\Users'.  (Microsoft.SqlServer.Smo)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.6020.0+((SQL11_PCU_Main).151020-1526+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Login&LinkId=20476

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()
   at Microsoft.SqlServer.Management.SqlManagerUI.CreateLoginData.LoginPrototype.ApplyGeneralChanges(Server server)
   at Microsoft.SqlServer.Management.SqlManagerUI.CreateLogin.DoPreProcessExecution(RunType runType, ExecutionMode& executionResult)
   at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.DoPreProcessExecutionAndRunViews(RunType runType)
   at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.ExecuteForSql(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult)
   at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.Microsoft.SqlServer.Management.SqlMgmt.IExecutionAwareSqlControlCollection.PreProcessExecution(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult)
   at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.RunNow(RunType runType, Object sender)

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
   at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext)
   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImplFinish(StringCollection createQuery, ScriptingPreferences sp)
   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()

===================================

Windows NT user or group 'PHILIX09\Users' not found. Check the name again. (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.6248&EvtSrc=MSSQLServer&EvtID=15401&LinkId=20476

------------------------------
Server Name: PHILIX09
Error Number: 15401
Severity: 16
State: 1
Line Number: 1


------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)



------------------------------------
Reply:

I suspect you are running Windows 10.  What edition are you running? Home?


------------------------------------
Reply:
That is Windows server 2012 r2

------------------------------------

Site feed/microfeed email workflow

I need to make workflow to microfeed/Site feed which send me email when somebody write something in feed. How i can do that? Email notification action send too much information, i cant edit email alert columns (template) in sharepoint online?
  • Edited by KeijoKeijo Monday, December 19, 2016 7:25 AM bugs

Dona Sarkar said " .......We will release ISO for the Slow ring build next week.”

Source

Excerpt:

The news comes via Windows Insider chief Dona Sarkar on Twitter, where she put it bluntly: "No more builds this week. We don't love the current options & don't want to leave you in a bad state during the holidays. And this also means no more builds for 2016. We will release ISO for the Slow ring build next week."

I log into my computer, says I can`t

I log into my computer and it says I wasn't able to be logged in to sign out or dismiss the message. It says usually when you sign out it works again so I sign out sign back in and it still doesn't let me so I put dismiss. Then it tells me I`m logged in a temporary account but if I save any information it will be lost. I could use the internet and everything perfectly but I want to use my regular desktop and save things.

Unlock bitlocker

hey Guyz please help to unlock my bitlocker in D drive

i recently formet my c drive and then i m unable to acess my D Drive

i have Correct password and recovery key still its saying recovery key and password is wrong

help in this i have all data on d drive


Reply:

If you have another PC then sign into your Microsoft Account online and view your saved BitLocker recovery keys. http://windows.microsoft.com/recoverykey

Expand the Computer name > select the one you want to unlock, and look for the BitLocker recovery key that is for the same first part of the Recovery key ID number. Enter the Recovery key.  

If the above doesn't help then try The BitLocker Repair Tool

                                                

S.Sengupta, Windows Insider MVP


------------------------------------

DSF Error

hi,

I am getting below error on DSF 

  • Edited by mujeebuddin Sunday, January 3, 2016 8:22 AM

Reply:

hi.

The picture isn't clear!


------------------------------------

KB3206632 breaks 2016 Hyper-V V-TPM

Just ran across an issue with KB3206632 on two lab servers running 2016 Hyper-V. These are E5 V2 servers with a TPM 1.2 module installed and enabled. Issue seems to be identical to the one Win-10 Hyper-V users are having over here.

Upon starting a guest with V-TPM enabled, Hyper-V Manager gives the following message.

An error occurred while attempting to start the selected virtual machine(s).

XXX failed to start

XXX could not initialize

The virtual machine XXX can't start becasuse the host's Isolated User Mode is off.

Unchecking Enable Trusted Platform Module in settings allows the guest to boot but requires inputting the backup key if Bitlocker is enabled.

Uninstalling KB3206632 from the host works on both hosts and all guests so far.

There's also a bunch of events in event log

TPM-WMI

The Trusted Platform Module (TPM) hardware on this computer cannot be provisioned for use automatically.  To set up the TPM interactively use the TPM management console (Start->tpm.msc) and use the action to make the TPM ready.

Error: The TPM provisioning action is not allowed by the specified flags.  For provisioning to be successful, one of several actions may be required.  The TPM management console (tpm.msc) action to make the TPM Ready may help.  For further information, see the documentation for the Win32_Tpm WMI method 'Provision'.  (The actions that may be required include importing the TPM Owner Authorization value into the system, calling the Win32_Tpm WMI method for provisioning the TPM and specifying TRUE for either 'ForceClear_Allowed' or 'PhysicalPresencePrompts_Allowed' (as indicated by the value returned in the Additional Information), or enabling the TPM in the system BIOS.)
Additional Information: 0x80011c





Reply:

Same problem here i have blocked this update via this tool:

https://support.microsoft.com/en-us/kb/3073930

So i wait until microsoft confirm this problem and has a fix for it.

Mike Couwenbergh IT Infrastructuur Architect


------------------------------------
Reply:

I run on my Windows 10 Machine in the same problme. My TPM 1.2 is Present and working for me. On the Hostmachine I use Bitlocker on System Partition.

O.k. The TPM is not Windows 2012 compliance

TpmPresent          : True
TpmReady            : False
ManufacturerId      : 1229346816
ManufacturerVersion : 3.19
ManagedAuthLevel    : Delegated

After deinstall the Update, V-TPM is working again and now I don't know what next steps I can try to do.

Joerg


------------------------------------

Advertisement

i woona doona job in microsoft advertisement .

what i will have to do.

R2 Server Essentials - Office 365 tab causes Dashboard to crash

I have an R2 Essentials server up and running with Office 365 AD integration which all seems to be working OK. If I enable the Office 365 tab in the dashboard it seems to work initially and displays all the correct information but after about 30 seconds the dashboard crashes (then asks you if you want to disable the offending add-in when you restart).

I get the following 2 event errors:

Source: Application Error
-------------------------------

Faulting application name: Dashboard.exe, version: 6.3.9600.16384, time stamp: 0x5215cf5a
Faulting module name: KERNELBASE.dll, version: 6.3.9600.16408, time stamp: 0x523d557d
Exception code: 0xe0434352
Fault offset: 0x000000000000ab78
Faulting process id: 0x4a4
Faulting application start time: 0x01ced8cdc76d80c2
Faulting application path: C:\Windows\system32\Essentials\Dashboard.exe
Faulting module path: C:\Windows\system32\KERNELBASE.dll
Report Id: 22023c37-44c1-11e3-80be-001018303c36
Faulting package full name:
Faulting package-relative application ID:

Source: .NET runtime
---------------------------

Application: Dashboard.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.Reflection.TargetInvocationException
Stack:
   at System.RuntimeMethodHandle.InvokeMethod(System.Object, System.Object[], System.Signature, Boolean)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(System.Object, System.Object[], System.Object[])
   at System.Delegate.DynamicInvokeImpl(System.Object[])
   at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(System.Object)
   at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
   at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
   at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
   at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry)
   at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
   at System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef)
   at Microsoft.WindowsServerSolutions.Dashboard.Forms.Controls.AdminListView.WndProc(System.Windows.Forms.Message ByRef)
   at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr, Int32, IntPtr, IntPtr)
   at System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr, IntPtr, Int32, IntPtr, IntPtr)
   at System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr, IntPtr, Int32, IntPtr, IntPtr)
   at System.Windows.Forms.NativeWindow.DefWndProc(System.Windows.Forms.Message ByRef)
   at System.Windows.Forms.Form.DefWndProc(System.Windows.Forms.Message ByRef)
   at System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef)
   at System.Windows.Forms.Form.WmSysCommand(System.Windows.Forms.Message ByRef)
   at System.Windows.Forms.Form.WndProc(System.Windows.Forms.Message ByRef)
   at Microsoft.WindowsServerSolutions.Dashboard.Forms.MainForm.WndProc(System.Windows.Forms.Message ByRef)
   at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr, Int32, IntPtr, IntPtr)
   at System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr, IntPtr, Int32, IntPtr, IntPtr)
   at System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr, IntPtr, Int32, IntPtr, IntPtr)
   at System.Windows.Forms.NativeWindow.DefWndProc(System.Windows.Forms.Message ByRef)
   at System.Windows.Forms.Form.DefWndProc(System.Windows.Forms.Message ByRef)
   at System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef)
   at System.Windows.Forms.Form.WmNcButtonDown(System.Windows.Forms.Message ByRef)
   at System.Windows.Forms.Form.WndProc(System.Windows.Forms.Message ByRef)
   at Microsoft.WindowsServerSolutions.Dashboard.Forms.MainForm.WndProc(System.Windows.Forms.Message ByRef)
   at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr, Int32, IntPtr, IntPtr)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG ByRef)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG ByRef)
   at System.Windows.Forms.Application+ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr, Int32, Int32)
   at System.Windows.Forms.Application+ThreadContext.RunMessageLoopInner(Int32, System.Windows.Forms.ApplicationContext)
   at System.Windows.Forms.Application+ThreadContext.RunMessageLoop(Int32, System.Windows.Forms.ApplicationContext)
   at Microsoft.WindowsServerSolutions.Dashboard.Program.Main(System.String[])

Has anyone seen this? Any ideas?

Thanks
  • Changed type Andy Qi Tuesday, November 26, 2013 11:59 AM

Reply:

Have a look in the Logs folder, there should be some Office 365 integration log files.

They should have more detail.

Robert Pearman SBS MVP
itauthority.co.uk | Title(Required)
Facebook | Twitter | Linked in | Google+


------------------------------------
Reply:
Thanks Robert but I can't find anything in the C:\windows\logs folder relating to Office 365?

------------------------------------
Reply:
It's not c:\windows it's in http://www.channelprosmb.com/article/key_windows_2012_essentials_log_files

Unfortunately TechNet isn't coming back, sorry folks :-(


------------------------------------
Reply:

Speaking with Susan for the same problem since Win2012 R2 Essentials lunch day.

Under investigation.....You are not alone....on this.......


------------------------------------
Reply:

You have?  Did I miss an email?  email me again with susan-at-msmvps.com (change the -at- to @) I'm setting up a case for fsofos@, is that you?

Unfortunately TechNet isn't coming back, sorry folks :-(


------------------------------------
Reply:
Yeap...

------------------------------------
Reply:

Oh got it.  I'm having difficulties getting the case set up (my mvp cases get renewed at 10/31 so I have to wait for them to kick in again) my apologizes and as soon as I can I'll get a case set up.

Bottom line know that you aren't alone (not that that helps)

Unfortunately TechNet isn't coming back, sorry folks :-(


------------------------------------
Reply:

No worries Susan. One think I've learn so far with computers....patience is a virtue....:)

Thanks again for your time and effort to solve this....


------------------------------------
Reply:
Please share the logs here though as well if possible.

Robert Pearman SBS MVP
itauthority.co.uk | Title(Required)
Facebook | Twitter | Linked in | Google+


------------------------------------
Reply:

MIcrosoft is collecting info from my server to work on my case at at the moment.... :)

Robert what logs are you interesting in particular?


------------------------------------
Reply:

I have posted what appear to be relevant log files on Dropbox:

https://www.dropbox.com/s/96zb2vz2fa70zib/Dashboard.2.log

https://www.dropbox.com/s/wm0jbwf7x7s63w1/SharedServiceHost-EmailProviderServiceConfig.log


------------------------------------
Reply:

MIcrosoft is collecting info from my server to work on my case at at the moment.... :)

Robert what logs are you interesting in particular?


Any progress Wiseman?

------------------------------------
Reply:

I am asking the same at Microsoft....

No news Good News??? We will see. I will keep this thread updated.....


------------------------------------
Reply:

I don't see any activity in the case since last week.

Klockwork?  Can you put the log file in skydrive and post the link up here?

http://www.channelprosmb.com/article/key_windows_2012_essentials_log_files

Dashboard.log and Dashboard.2.log

and OIMGettingStartedWizard.log

Unfortunately TechNet isn't coming back, sorry folks :-(


------------------------------------
Reply:

Susan this the last communication i had with Microsoft today...:

Hello,

I have done good research on the issue and broken it down to long extent. I have few things which might look like need to check on.

I have to try them on my lab machine 1st before we proceed with same on the live server.

I'll get in touch with you tomorrow to continue on this.

Thanks.



  • Edited by Wiseman Tuesday, November 12, 2013 8:06 PM

------------------------------------
Reply:
What the heck does that mean?

Unfortunately TechNet isn't coming back, sorry folks :-(


------------------------------------
Reply:

Thanks Susan,

Here's a link to a SkyDrive folder with the log files:

Skydrive folder

------------------------------------
Reply:

Susan today's support comes as follows....

"Thank you the email.

I was testing few things however found that we need to take a look at the stack and might be this is common issue or bug.

I'm discussing the case along with my TL with product team and might need some time to research more on it.

Looking at the current situation we can continue with the workaround for now by renaming 'SharePointLibraryTabPage.addin' file

Will get back to you sometime around mid of next week with final details on it.

Apologies for the time taken, I hope you understand that the issue is slightly complicated."

So the coolpit seems to be the Sharepoint Online Library Integration with the Dashboard.

Susan i believe the problem in my case is that i am an "OLD" Office 365 Tenant. Sharepoint Online Libraries migrated from v1.0 Office 365  to Current version (Wave 2 Products) probably causing the Dashboard control to crash...somewhere in the way....

 



------------------------------------
Reply:
Hey Klockwork, does that describe your situation as well?  If it doesn't I think we need to open a case for you too.  Email me at susan-at-msmvps.com (change the -at- to @) and we can get you investigated.

Unfortunately TechNet isn't coming back, sorry folks :-(


------------------------------------
Reply:

Hi Susan, that is similar to my situation, my account was upgraded to Wave 2. Do you have any idea what 'the workaround for now by renaming 'SharePointLibraryTabPage.addin' file' means?

I appear to have more problems now, since installing updates this morning the 'Windows Server Essentials Management Service' service (WseMgmtSvc) refuses to start(see related thread). The only upside to that is that the dashboard no longer crashes with the O365 tab enabled! Joy.

My email is jamie-at-klockwork.co.uk


------------------------------------
Reply:

FYI

I have renamed the SharePointLibraryTabPage.addin as mentioned above and the dashboard is no longer crashing. hoorah!


------------------------------------
Reply:

Yes i know i did the same as Microsoft Support suggested. But this is the workaround. Now for the final solution we both have to wait a bit longer....

Can i ask something? Does your office 365 subscription been active before the v2013 products came to market?

I mean are you an Office 365 active user before 2013?

I am asking this because i have a feeling that "Old" Office 365 subscribers deal only with this specific problem.As you can imagine our problem lies with Sharepoint Online integration with Server 2012 R2 Essentials 

My opinion is that  our some of our Sharepoint Online Libraries where created with the old version of Sharepoint Online which might pose a different "Syncing" parameter that Windows Server 2012 R2 Essentials does not "Fully" understands....


------------------------------------
Reply:
Yes, my O365 subscription started prior to 2013(by a long time). The MS support engineer who worked on the management service problem is now looking into the dashboard crash, hopefully we'll get some answers next week.

------------------------------------
Reply:
Heard from the MS bods this morning, they're still working on it! Apparently it might be something to do with language settings on Sharepoint sites that were upgraded. Will update if I hear any more.

------------------------------------
Reply:

Your hearing is perfect.......!!!

I got the same support direction. My Sharepoint Online Top level site is in Greek (by default as i am located in Greece) and its using some special characters (according to MS Support) to display its content. These special characters are causing all this mess.....

You can request to change its Display Language by opening a Support ticket. This the only way it can be done....and it takes days..... i am still waiting to complete.....


------------------------------------
Reply:

Finally resolved!! The crash was actually being caused by a function within the Sharepoint Libraries addin in the dashboard passing an empty parameter. The parameter was the Team Site Title (Site Settings>Title, Description and Logo) which was left blank in Site Settings. Just adding a title allowed me to re-enable the addin and the dashboard no longer crashed at startup. Apparently this only effects Office 365 accounts that have been upgraded (WaveX to WaveY) and language settings may also play a part(My Team Site was set to US English and Public Site to English English). It has been logged as a bug and the product team are working on it. Many thanks to Swapnil(MS product support) for his perseverance and Susan for logging the support ticket.

I asked Swapnil if it was possible to extend the evaluation period due to the length of time(4 months) it's taken to resolve but no go. Looks like I'll have to re-subscribe to Action Pack, I've passed the new assessment!!


------------------------------------
Reply:

Hi, 

Recentely I installed the Essentials Experience on my 2012 R2 Datacenter and, intially, the office365 integration was working but suddently the wsemailsvc stopped initializing and the OI stopped working. I got the message to verify if the computer have internet access. I'm trying to do what you did and add a title on the Team Site settings but I dont know how to get there.

One more information, my dashboard never crashed. 

Thanks


------------------------------------
Reply:

To add a team Site Title:

  • Log into your Office 365 admin center
  • Click 'Sites' (in the top ribbon)
  • Click 'Team Site'
  • Click on Settings icon (Gear icon top right hand corner), select 'Site settings'
  • Click on 'Title, Description and Logo'
  • Add a title and click 'OK'

Your problem sounds a little different to mine but worth giving this a try.

Good luck.


------------------------------------
Reply:

Thanks for the fast reply, Klockwork

There were a title and a description.
 
I thought that I didnt know how to get there but I did know. My sharepoint is on the old version yet, I think that's the problem. It will be updated tomorrow, so I guess that the problem should be fixed easily tomorrow. 


Thank you. 


------------------------------------
Reply:

I'm having similar issues with my WSE12R2 server.  Is it possible to download the original .addin files (from a working WSE12R2 box) and folder set that should exist here C:\Program Files\Windows Server\Bin\Addins?

 And perhaps the .dll's that should exist here C:\Windows\system32\Essentials\?


------------------------------------

Cost Rates

Hi,

I have a resource created in Project 2013, the resource has 3 different cost rates created. I have assigned the resource to a 1 day (8 hours work) task and I am wondering is it possible to assign different cost rates for the resource to the task e.g. first 4 hours at 20 euro (rate A) and next 4 hours at 40 Euro (rate B). I have been struggling to see if this can be done in MS Project ?

JV

  


Reply:

Johnvel,

You can, but you will have to break the resource into two separate parts, each with a different rate, so you can assign both to the same task (see screen shot). You cannot assign the same resource twice to a given task.

However, you could set an effective date, including a time, on the resource's cost rate table that would effectively switch from one rate to another (and even yet another) in a given day. The disadvantage is that once the rate is changed it will stay at that new rate until changed again, but you could start out at 20 euros at the beginning of the day, switch to 40 euros at noon, and then switch back to 20 euros for the next day.

Probably not what you wanted to hear but hope this answers your question.

John



  • Edited by John - Project Sunday, December 18, 2016 1:20 AM another thought

------------------------------------
Reply:

JV --

In addition to John's excellent reply, I would recommend you break the task into two different tasks.  Assign the same resource to each task and then use the Cost Rate Table column to specify the Cost Rate Table applied to the resource assignment on each task respectively.  Hope this helps.

Dale A. Howard [MVP]


------------------------------------
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Setup is Split Across Multiple CDs

Setup is Split Across Multiple CDs Lately I've seen a bunch of people hitting installation errors that have to do with the fact th...