Category Archives: Microsoft

Microsoft Products

Error while trying to Access “Details” of a SharePoint App

November 6, 2015 1:22 PM / Leave a Comment /

Recently we added Access Services to our SharePoint 2013 environment. After the initial setup we started testing the new implementation and stumbled over an error while accessing the details page of an app. This has nothing to do with access itself, more with apps in general.

2015-11-06_13-03-54

After clicking on details you get an error message with the correlation id. So nothing easier to get the log regarding that error.

SqlError: ‘The EXECUTE permission was denied on the object ‘prc_CountAppInstanceData’, database ‘SharePoint_Logging’, schema ‘dbo’.’    Source: ‘.Net SqlClient Data Provider’ Number: 229 State: 5 Class: 14 Procedure: ‘prc_CountAppInstanceData’ LineNumber: 1 Server: ‘Database.fqdn.com’ f2ec3e9d-ac28-80f1-8d80-1d89f5d672a9
11/06/2015 12:50:34.93  w3wp.exe (Servername.fqdn.com:0x5DE4)            0x5D34 SharePoint Foundation          Database                       5214 Critical Insufficient SQL database permissions for user ‘Name: NT AUTHORITY\IUSR SID: S-1-5-17 ImpersonationLevel: Impersonation’ in database ‘SharePoint_Logging’ on SQL Server instance ‘Database.fqdn.com’. Additional error information from SQL Server is included below.  The EXECUTE permission was denied on the object ‘prc_CountAppInstanceData’, database ‘SharePoint_Logging’, schema ‘dbo’. f2ec3e9d-ac28-80f1-8d80-1d89f5d672a9

This leads us to a permission issue. We tried granting the App Management Service Account “SPDataAccess” permission on our logging database, which did not help.

As you can see in the log there is an user specified IUSR SID: S-1-5-17. This leads to a permission issue from IIS WebServer. Makes sense as all SharePoint Applications are running within the IIS and their Application Pools. As our App Management Service Account wasn’t the issue we granted our Application Pool Account under which the Web Applications are running, the “SPDataAccess” permission on our logging database.

2015-11-06_13-04-42

Et voila, this fixed the issue.

Problem: App Details do not work.

Solution: Grant SPDataAccess Permisson to your Web Application Pool Account on your SharePoint Logging Database.

Posted in: Microsoft, SharePoint / Tagged: , ,

Reinstall WSUS and keep downloaded content

June 3, 2015 8:37 PM / 1 Comment /

Our scenario was that we wanted to upgrade our WSUS running on Windows Server 2012 to Windows Server 2012 R2 and changing the database to WID. The database wasn’t that important for us, as all computers placed in one group where all patches are approved. But we wanted to keep the content of 800 Gigabyte without redownloading all that stuff.

A huge advantage is if you have the data on a seperate drive or partition. Before you start, shutdown the WSUS Service and rename the WsusContent folder or move it to a different location.

Then you’re good to go. Reinstall or setup a new machine and install WSUS. During the initial configuration wizard its important that you choose “synchronize manually” and do not trigger a sync before or at the end of the wizard. Then copy the previous saved WsusContent folder to the location you’ve choosen in the wizard and replace everything. After that you can manually start your synchronization and WSUS is reindexing the whole content without downloading a huge amount of data. It should take around 3-4 hours, depending on your hardware and disk. You can see the status on synchronization tab.

 

Good luck!

Posted in: Microsoft, Windows Server / Tagged: , , , , ,

Error during install of Microsoft Workflow Manager 1.0 Refresh

June 30, 2014 1:34 PM / Leave a Comment /

Installing the Workflow Manger 1.0 Refresh can be tricky.

During Installation process with the web platform installer 5.0 (only way to install it) the setup of Microsoft Windows Fabric V1 CU1 fails. When you open the log it says 1603.

So lets see what 1603 means. Open cmd prompt and type net helpmsg 1603.

C:\>net helpmsg 1603

Fatal error during Installation.

Not very expressive. But there is a simple solution, install Visual C++ Redistributable for Visual Studio 2012 Update 4.

 

Source: Social MSDN

Posted in: Microsoft, SharePoint / Tagged: , ,

Change network profile of Windows Server 2012 R2

June 6, 2014 11:51 PM / Leave a Comment /

After installing Windows Server 2012 R2 or Windows 8.1 you will be asked if this is a home/work network or not. Based on that windows will choose your network profile.

Network ProfileI was some kind distracted and accidently clicked in the middle of the desktop and the sidebar disappeared. Windows decided that this is a “No” and you will be on a public network. I’ve no idea why but you can not change it through the network and sharing center, all settings you’re trying to set will be set back to default of public networks. Like network discovery. So how to change it? Quite easy, just open the registry and navigate to the following path:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\NetworkList\Profiles

There will be at least one key in that list. Simply delete the one you want to reset and reboot your machine. After that you will be asked again. However I would only recommend that method if that happened to you right after the setup as I don’t know if some firewall rules will be reset or deleted.

Posted in: Microsoft / Tagged: , , , ,

Windows 2012 R2 Data Deduplication and ISOs

June 1, 2014 4:11 PM / Leave a Comment /

I’ve tried to install some machines on my Hyper-V. All ISOs were placed on the second drive where data deduplication is enabled. With deduplication enabled I ran into the problem that no serial/license number was accepted neither the AVMA Key nor the generic KMS Key or my own key. After hours of searching for solutions on the web and no solution in sight. I copied the iso to drive D again. Suprise it was working! One day later I tried to install a new machine and it wasn’t working again. No key accepted. After moving it to drive C where no deduplication happens its working again.

Conclusion: Never ever put windows installation media on a drive with data deduplication enabled.

Posted in: Microsoft / Tagged: , , , ,

<20 Watt Home Server for Hyper-V and ESXi

June 1, 2014 3:58 PM / Leave a Comment /

I’ve rented a lot of linux vps around the world for testing and hosting teamspeak and other stuff. Not every application runs on linux so I decided to build a small home server with a low power consumption.

I stumbled over the list of components in the hardwareluxx forums and build my system based on that components. ( Link )

Here is my list:

  • Intel Pentium G3420
  • ASRock Z87E-ITX
  • Crucial Ballistix Sport Kit 8GB ( DDR3-1600, CL9-9-9-24 )
  • EKL Alpenföhn Silvretta
  • be quiet! Pure Power L8 300W ATX 2.4
  • SanDisk SSD 128GB
  • Kingston SSDNow mS200 SSD 30 GB
  • Cooler Master Elite 130

First of all I removed the Mini PCIe Wifi card from the mainboard as its not needed and plugged in the mSATA at the bottom of it. The small SSD can be used for the OS (Server 2012 R2) or as Host Cache for ESXi.
After putting all components together I enabled all bios settings allowing power savings and switched of the soundcard etc. I also tried to undervolt the CPU with the VCore Offset and got it down to -0,235mV.

Here are the results (power measurement):

ESXi 5.5 U1 Windows Server 2012 R2
Idle 18.2 Watts 11.1 Watts
Load 39.6 Watts 35.8 Watts

Make sure all drivers are installed and no usb devices are plugged in. The usb devices may prevent reaching a package c-state of more than 80.

The network drivers are a little tricky. For ESXi 5.5 follow this guide  ESXi 6.0 includes drivers for Intel I217V and for Server 2012 follow this guide.

Good luck and post your results.

Posted in: ESXi, Hyper-V, Microsoft, VMWare / Tagged: , , , , , , ,

SharePoint 2013 – Zero Byte ULS Logs

February 26, 2014 1:42 PM / Leave a Comment /

Recently I stumbled over out ULS Logs on the Web Frontends. Suprisingly they were empty, 0 bytes. I checked the permissions for the account the tracing service is running with (Web Application Pool Account). Everything was fine, same permissions as on the other servers where it was working.

So I checked the local groups and found out the tracing account must be a member of the “Performance Log Users”. Add the account, restart the “SharePoint Tracing” Service and you will see the uls logs growing.

Posted in: Microsoft, SharePoint / Tagged: , , , ,

Operations Manager 2012 R2 – Data Warehouse can’t process performance data

February 4, 2014 4:26 PM / Leave a Comment /

We had the problem that our data warehouse can’t process all performance data being collected. To get rid of this problem you need to disable some performance collection rules in your opsmgr 2012r2 (preferable the ones you don’t need).

You may find out which one collect most data you can run the following queries against your dwh.

Performance insertions per day

SELECT CASE WHEN(GROUPING(CONVERT(VARCHAR(20), TimeSampled, 102)) = 1)
THEN ‘All Days’ ELSE CONVERT(VARCHAR(20), TimeSampled, 102)
END AS DaySampled, COUNT(*) AS PerfInsertPerDay
FROM PerformanceDataAllView with (NOLOCK)
GROUP BY CONVERT(VARCHAR(20), TimeSampled, 102) WITH ROLLUP
ORDER BY DaySampled DESC

To find the rules collecting the most Performance Signature data in the database

select managementpack.MPName, ruleview.DisplayName,
count(*) AS TotalPerfSig
from performancesignaturedata with (nolock)
inner join performancesignaturehistory with (nolock)
on performancesignaturedata.performancesignaturehistoryid = performancesignaturehistory.performancesignaturehistoryid
inner join performancesignature with (nolock)
on performancesignaturehistory.performancesignatureid = performancesignature.performancesignatureid
inner join ruleview with (nolock)
on ruleview.id = performancesignature.learningruleid
inner join managementpack with(nolock)
on ruleview.managementpackid = managementpack.managementpackid
group by managementpack.mpname, ruleview.Displayname
order by TotalPerfSig DESC, managementpack.mpname, ruleview.DisplayName

Good luck

Posted in: Microsoft, Operations Manager / Tagged: , , , , ,

SharePoint 2013 – Unknown SQL Exception 64

January 7, 2014 12:46 PM / Leave a Comment /

After a major network outage one of our server doesn’t want to connect to the database server anymore. The event log was spammed with the following message:

Error    07.01.2014 10:09:09    Microsoft-SharePoint Products-SharePoint Foundation    5586    Database    “Unknown SQL Exception 64 occurred. Additional error information from SQL Server is included below.

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 – The specified network name is no longer available.)”

This message only appeared on one out of five servers. No reboot, no iisreset resolved the problem.

We resolved the issue by moving the database to another sql node (FailOver / Always On). When you move the database all connections will be forcibly closed. Seems that the sql server doesn’t allow the server to connect to the database as some connection was still established. If you can’t move the database to another node, simply restart the instance or put the affected database in single user mode to close the connections.

Posted in: Microsoft, SharePoint / Tagged: , , ,

Office Web Apps 2013 Management Pack for Operations Manager 2012 (R2)

November 8, 2013 12:20 PM / 13 Comments /

Update 17.08.2015:

Official answer from Microsoft USA. It’s been finally decided that the Management Pack is discontinued. Disappointing.

However, feel free to use my fixed Management Pack.

 

Update 16.10.2014:

I’ve unsealed the Managemant Pack and added the missing strings. You cannot upgrade the existing one as I don’t have the signing keys. Good luck!

16-10-_2014_16-58-11Download: Microsoft.OfficeWebAppsServer_Custom

 

Update 12.02.2014:

Apologies for the delay.

It’s been finally decided that Office Web Apps Server MP will be released by the Web Apps Server team.

My team is working on getting this out the door as soon as possible, but there will be official release.

Update 18.12.2013: Our support engineer told us the development of this management pack has been discontinued for now. 🙁

In most case Microsoft offers a management pack for operations manager shortly after release within a few weeks or month.

This is not the case for Office Web Apps 2013 for Exchange/Lync/SharePoint. The Guide was released more than a year ago. As stated in the Document, Management Pack “Microsoft.OfficeWebAppsServer.mp” + “MicrosoftOfficeWebAppsServer.Config” is needed to monitor Office Web Apps Server 2013. So where to find it?

There is a link on technet forums and this is exactly the same that we received from the support engineer. You can download the management pack from the link at the end of the thread.

This is a buggy version of the management pack but it works. I will update the post when I get a release date.

Missing displaynames

HealthExp

 

 

Guide – http://www.microsoft.com/en-us/download/details.aspx?id=34594

Management Pack – http://download.microsoft.com/download/4/9/E/49EA21D0-CDF9-469F-805D-AC31527A55F2/microsoft.officewebappsserver.mp

 

Posted in: OfficeWebApps / Tagged: , , , , ,