Interversal Blog – IIS, Sharepoint, dot Net, Plesk, MySQL, SQL Server, PHP and all the web technologies in one site

Somewhere for me to keep thoughts and text. Use either at your own risk.

28 Jan

SharePoint – How do I tell if my the FQDN of my server is different from the NetBios Name?

Posted in Uncategorized on 28.01.14

And why do I need to know?

 

You need to know to set up the User Profile Service Application correctly. If they are different, there is a setting that will make things magically work. If you don’t fix the setting, then get ready for days or even weeks of dealing with: “Syncronisation starting’, and various other unhelpful messages from a stuffed User Profile Sync.

 

There are plenty of ways of checking the NetBios Names and FQDNs but these are my favourites. They don’t require Active Directory modules and should work on any server.

FQDN of computer:
[System.Net.Dns]::GetHostByName(($env:computerName))

EG:
 HostName Aliases AddressList
 -------- ------- -----------
 SEVSPAPP01.mycompany.com.au {} {10.1.10.43}

NetBios Domain of Computer:
(gwmi Win32_NTDomain).DomainName MYCompany

In this case mycompany.com.au != MYCompany so I would have to use NetBiosDomainNamesEnabled = “1″

Comments Off

28 Jan

Error: .Net SqlClient Data Provider: System.Data.SqlClient.SqlException: HostId is not registered

Posted in Sharepoint on 28.01.14

Being recently cursed by the error:
.Net SqlClient Data Provider: System.Data.SqlClient.SqlException: HostId is not registered
   at Microsoft.ResourceManagement.Utilities.ExceptionManager.ThrowException(Exception exception)
   at Microsoft.ResourceManagement.Data.Exception.DataAccessExceptionManager.ThrowException(SqlException innerException)
   at Microsoft.ResourceManagement.Data.DataAccess.RetrieveWorkflowDataForHostActivator(Int16 hostId, Int16 pingIntervalSecs, Int32 activeHostedWorkflowDefinitionsSequenceNumber, Int16 workflowControlMessagesMaxPerMinute, Int16 requestRecoveryMaxPerMinute, Int16 requestCleanupMaxPerMinute, Boolean runRequestRecoveryScan, Boolean& doPolicyApplicationDispatch, ReadOnlyCollection`1& activeHostedWorkflowDefinitions, ReadOnlyCollection`1& workflowControlMessages, List`1& requestsToRedispatch)
   at Microsoft.ResourceManagement.Workflow.Hosting.HostActivator.RetrieveWorkflowDataForHostActivator()
   at Microsoft.ResourceManagement.Workflow.Hosting.HostActivator.ActivateHosts(Object source, ElapsedEventArgs e)
  
  
  And subsequent:
  ILM Certificate could not be created: Cert step 2 could not be created: C:\Program Files\Microsoft Office Servers\15.0\Tools\MakeCert.exe -pe -sr LocalMachine -ss My -a sha1 -n CN=”ForefrontIdentityManager” -sky exchange -pe -in “ForefrontIdentityManager” -ir localmachine -is root
 
 
 I realised I was in the land of the repeated ForeFront Certificate problem. This occurs when ForeFront Certificates already exist.
 CleverWorkarounds has a good writeup about it.
 
 Basically, you need to get rid of the FIM Certs before you start the sync service. It’s a bit of a pain to go through all the objects. I kept missing some and would have to start over again.
 Here is a script to remove the ForeFrontIdentityManager Certificates off your server for you:
 
 net stop sptimerv4
net stop spadminv4

 sl cert:
 Get-ChildItem -Recurse | Where { $_.Issuer -eq “CN=ForefrontIdentityManager” }
Get-ChildItem -Recurse | Where { $_.Issuer -eq “CN=ForefrontIdentityManager” } | Remove-Item
Get-ChildItem -Recurse | Where { $_.Issuer -eq “CN=ForefrontIdentityManager” }
 net start sptimerv4
 net start spadminv4
Even after getting rid of all the FIM Certs, it still wouldn’t run. I had moar errors:
ILM Certificate could not be created: netsh http error:netsh http add urlacl url=http://+:5726/ user=domain\svc_spfarm sddl=D:(A;;GA;;;S-1-5-21-4215000165-3197143036-532513930-5390)
ILM Certificate could not be created: netsh http error:netsh http add urlacl url=http://+:5725/ user=domain\svc_spfarm sddl=D:(A;;GA;;;S-1-5-21-4215000165-3197143036-532513930-5390)

And I deleted both of the Discresionary Access Lists ( acl )

netsh http delete urlacl url=http://+:5725/
netsh http delete urlacl url=http://+:5726/

 

And that did the trick.

Also note that I saw this happen in one instance when the FQDN was different from the NetBIOS name and I hadn’t set the NetBIOSDomainNamesEnabled to 1.

If you can’t tell the difference between and FQDN and the NetBIOS name of your server, look at the environment variables …

Now, why oh why the SharePoint installer doesn’t check this, or why SPAutoInstaller doesn’t check this I don’t know. But it’s worth looking at, especially if the User Profile Service Application is driving you nuts and it won’t perform a sync, or gets stuck on synchronising or something similar.

Comments Off

11 Jul

Another way to have more than 7 colours on a SharePoint Calendar – and no overlays.

Posted in Javascript, Sharepoint on 11.07.13

It happens every few clients…
Client: We want multiple colours on our calendars!
Me: Sure, you do it with views and overlays. But you can only have 7 usable colours and you will be confused navigating.
Client: Do we have to?
Me: I’m sorry, it is a limitation of SharePoint. Perhaps you could try a third party solution?
Client: *Sigh* we can’t spend any more money since we gave the last of our gold to the handsom SharePoint consultant. We *sniff* must carry on regardless.
Me: Ok.

Not any more!!!!!
I’ve compiled a nice collection of javascripts from the internets that finally give a good user experience, with as many colours as they want.

Here’s what you do.

1.    Create a calendar.
2.    Add the field you want to colour by ( in this case ‘Resource Name’ ) to the Month View Title, Week View Title and the Day View Title of the view.

Change your View to match the field you want to separate your colours with

Change your View to match the field you want to separate your colours with

3.    Add a new Content Editor Web Part, link to the js below and make the web part hidden.
4.    Edit the js. Change the first parameter in ‘AddRowToTable’ to what ever you want to separate the colours by. In this case a user field ‘Resource Name’ but it could be anything.
5.    Done.

SharePoint Calendar with colours

SharePoint Calendar with colours. And no overlays

Link: resource_colour_all_events – colour calendars.js

<script>

/* Hide the overlays navigation in the quick launch. Not needed, but it looks better without this */
jQuery(“.ms-acal-apanel-outer”).hide();

_spBodyOnLoadFunctionNames.push(‘WaitForCalendarToLoad’);

function colorCalendarEventLinks()
{

/*Add the different elements. The first parameter is what to search for in the title, the second is the hex colour     */
AddRowToTable(“Sam”,”fef8d6″);
AddRowToTable(“Miguel”,”d0ffbc”);
AddRowToTable(“Mihir”,”feebcd”);
AddRowToTable(“Adam”,”c8f0ff”);
AddRowToTable(“Margaret”,”ffc8e8″);
AddRowToTable(“Harvinder”,”bee5ff”);
AddRowToTable(“Mick”,”e0e8f2″);

}

function AddRowToTable(title,colour)
{
var events = jQuery(‘div[title*="' + title +'"]‘);
events.css({“background-color”:”#” + colour  +”"});

}

/* Adds colorCalendarEventLinks to the event that runs when the calendar is refreshing */
function WaitForCalendarToLoad() {

if (typeof SP.UI.ApplicationPages.CalendarNotify.$4a == ‘undefined’) {
// post SP1
var pwold$4b = SP.UI.ApplicationPages.CalendarNotify.$4b;
SP.UI.ApplicationPages.CalendarNotify.$4b = function () {
pwold$4b();
colorCalendarEventLinks();

}
}
else {
// pre SP1
var pwold$4a = SP.UI.ApplicationPages.CalendarNotify.$4a;
SP.UI.ApplicationPages.CalendarNotify.$4a = function () {
pwold$4a();
colorCalendarEventLinks();

}
}
//Expand All Items – if you don’t want this, then comment out
SP.UI.ApplicationPages.SummaryItemRenderer.prototype.$2u = function ()
{
ULSvSp: ;
if (!this.$1A_1) this.$1A_1 = 100;
return this.$1A_1
}

SP.UI.ApplicationPages.CalendarViewBase.prototype.resetSelection = function () {
ULSSPg: ;
if (SP.UI.ApplicationPages.CalendarViewBase.prototype.$4u_1) {
SP.UI.ApplicationPages.CalendarViewBase.prototype.$4u_1.$1D();
}
colorCalendarEventLinks();
}
}

</script>

 

Comments Off

11 Jul

Fix IE10 Flicker in SharePoint opening model dialog boxes.

Posted in Sharepoint on 11.07.13

If you have read every other blog post, and you have come here, this may be your last resort.
To fill you in on the problem I was having, a client had a custom theme applied to their SharePoint 2010 environment.
When ever a user with IE10 opened a dialog box by adding a new calendar entry, the area around the dialog box would flicker and shake.
I found that disabling the scroll bars in the dialog box worked to remove the flicker, but in some cases we needed those scroll bars so it wasn’t a long term solution:

<!–[if IE]>
<style>
body #s4-workspace {overflow-x:visible!important; overflow-y:visible!important;}
</style>
<![endif]–>

In the end, the following CSS fixed it up for me:
<!–[if IE]>

body.v4master {
overflow: visible;
height: inherit;
width: inherit;
}

.ms-dlgOverlay {
width: 100% !important;
}
<![endif]–>

I got to keep my scroll bars and the mean flicker went away. Phew.

tags:

Comments Off

25 Jun

SQL Server Reporting Services SSRS Report Builder GUID Error – Item Not Found

Posted in Database, Sharepoint on 25.06.13

Using Report Builder 3.0, SharePoint Integrated Mode and SQL Server 2008R2.

On creating a new report in Report Builder, I kept getting the error:

‘Failed to preview the report. The Item XXX can not be found’.

XXX being a meaningless GUID.

Turns out, the Report needed to be saved to a SharePoint library for the preview to render.

Lean something new every day:

My Error

The Fix, thank you Technet:

http://social.technet.microsoft.com/wiki/contents/articles/982.aspx

Save to a SharePoint Library!

 

 

Comments Off

14 Mar

Find All ‘Authenticated Users’ instances in a SharePoint database

Posted in Sharepoint on 14.03.13

I reacently had to find every instance of ‘All Authenticated users’ in a site collection.

Powershell to the rescue:

$site = Get-SPSite http://’WebApp’
$groups = $site.RootWeb.sitegroups
foreach ($grp in $groups) {“Group: ” + $grp.name; foreach ($user in $grp.users) {“  User: ” + $user.name} }
$site.Dispose()

$spWeb = Get-SPWeb http://WebApp
$theuser = $spWeb.AllUsers.Item(“NT Authority\Authenticated Users”)
foreach ($grp in $theuser.Groups) {$grp.name}
$spWeb.Dispose()

Handy, my next step is to remove the instances of Authenticated Users and replace them with the specific AD Group.

 

Also liked this: Show All Effective Permissions in a site:

http://vlasenko.org/2010/03/19/sharepoint-2010-powershell-how-to-get-user-permissions-report/

$urlWeb = "http://mycompany/sites/mydepartment"

Get-SPUser -Web $urlWeb | select UserLogin, @{name="Exlicit given roles";expression={$_.Roles}}, @{name="Roles given via groups";expression={$_.Groups | %{$_.Roles}}},Groups | format-Table -auto

Comments Off

26 Feb

Add fixed image to announcement Content Query Web part with modal dialog on open

Posted in code snippets, Sharepoint on 26.02.13

I needed to have a bulleted list of announcements from across the site collection.
I created a new Content Type – GlobalAnnouncements
Applied the Content Type it to a list.
Added some items.
Edited SiteCollection/StyleLibrary/XSL Style Sheets/ItemStyle.xsl
Added a new template called GlobalAnnouncement:

<xsl:template name=”GlobalAnnouncement” match=”Row[@Style='GlobalAnnouncement']” mode=”itemstyle”>
<xsl:variable name=”SafeLinkUrl”>
<xsl:call-template name=”OuterTemplate.GetSafeLink”>
<xsl:with-param name=”UrlColumnName” select=”‘LinkUrl’”/>
</xsl:call-template>
</xsl:variable>
<xsl:variable name=”SafeImageUrl”>
<xsl:call-template name=”OuterTemplate.GetSafeStaticUrl”>
<xsl:with-param name=”UrlColumnName” select=”‘ImageUrl’”/>
</xsl:call-template>
</xsl:variable>
<xsl:variable name=”DisplayTitle”>
<xsl:call-template name=”OuterTemplate.GetTitle”>
<xsl:with-param name=”Title” select=”@Title”/>
<xsl:with-param name=”UrlColumnName” select=”‘LinkUrl’”/>
</xsl:call-template>
</xsl:variable>
<div style=”padding-right:0px;padding-left:10px;padding-top:0px;padding-botton:5px;”>
<xsl:if test=”string-length($SafeImageUrl) != 0″>
<div>
<a href=”{$SafeLinkUrl}”>
<xsl:if test=”$ItemsHaveStreams = ‘True’”>
<xsl:attribute name=”onclick”>
<xsl:value-of select=”@OnClickForWebRendering”/>
</xsl:attribute>
</xsl:if>
<xsl:if test=”$ItemsHaveStreams != ‘True’ and @OpenInNewWindow = ‘True’”>
<xsl:attribute name=”onclick”>
<xsl:value-of disable-output-escaping=”yes” select=”$OnClickTargetAttribute”/>
</xsl:attribute>
</xsl:if>
<img src=”{$SafeImageUrl}” title=”{@ImageUrlAltText}”>
<xsl:if test=”$ImageWidth != ””>
<xsl:attribute name=”width”>
<xsl:value-of select=”$ImageWidth” />
</xsl:attribute>
</xsl:if>
<xsl:if test=”$ImageHeight != ””>
<xsl:attribute name=”height”>
<xsl:value-of select=”$ImageHeight” />
</xsl:attribute>
</xsl:if>
</img>
</a>
</div>
</xsl:if>
<div>
<xsl:call-template name=”OuterTemplate.CallPresenceStatusIconTemplate”/>

<a onclick=”javascript:SP.UI.ModalDialog.ShowPopupDialog(‘{$SafeLinkUrl}’); return false;” onmouseover=”javascript:this.style.cursor=’hand’;” title=”{@LinkToolTip}”>
<img src=’/PublishingImages/News Button.jpg’ width=”25px” height=”25px”  align=”middle” style=”padding-right:5px;”></img>

<xsl:value-of select=”$DisplayTitle”/>
</a>
<div>
<xsl:value-of select=”@Description” />
</div>
</div>
</div>
</xsl:template>

 

And it all worked out fine. I need to add my styles to the sites css. But this is working nicely.

 

Comments Off

25 Feb

Curse you Excel Services

Posted in Sharepoint on 25.02.13

I don’t know what happened. We’d always been such good friends. But one client, one install, the damned thing wouldn’t refresh from a list.
After Binging ( googling ) ULS’s for a while, I stumbled upon a very helpful flowchart Microsoft has put together. It helped. I didn’t get THE answer. But it helped.
It does make me think that there have been plenty of stuck pumpkins before me on this this one. MS doesn’t often provide a huge flowchat for troubleshooting. I wish there were more …

Microsofts SharePoint 2010 Excel Services Troubleshooting Flowchart

PS: These were my errors:
ConnectionManager.GetConnection: Failed to create new connection, exception=Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException: Exception of type ‘Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException’ was thrown. at Microsoft.Office.Excel.Server.CalculationServer.Interop.EngineInterop.CreateConnection(QueryType queryType, String connectionString, String userName, Boolean isTensor, Boolean integratedAuthentication, Int32 lcid, SecureString password, String workbookUrl, Int32 timeout) at Microsoft.Office.Excel.Server.CalculationServer.ConnectionManager.CreateConnection(Credentials credentials, ConnectionInfo connectionInfo, Int32 keyLcid, Uri workbookUrl, Boolean auditConnection, SessionId sessionId), sessionId=1.V21.26vhnMHWSZdyQqQNWeB… 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.64* w3wp.exe (0x08C0) 0×2434 Excel Services Application Excel Calculation Services 6k4q Medium …dc90.5.en-US5.en-AU73.-0600#0000-04-00-01T03:00:00:0000#+0000#0000-10-00-01T02:00:00:0000#-006036.fab5481e-2082-4df1-af62-af0f9a6e7ea31.N, connectionString=Provider=Microsoft.Office.List.OLEDB.2.0;Data Source=”";ApplicationName=Excel;Version=12.0.0.0 pool count=0 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.64 w3wp.exe (0x08C0) 0×2434 Excel Services Application Excel Calculation Services eq3m High ConnectionManager.GetConnection: Caught an exception: Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException: Exception of type ‘Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException’ was thrown. at Microsoft.Office.Excel.Server.CalculationServer.Interop.EngineInterop.CreateConnection(QueryType queryType, String connectionString, String userName, Boolean isTensor, Boolean integratedAuthentication, Int32 lcid, SecureString password, String workbookUrl, Int32 timeout) at Microsoft.Office.Excel.Server.CalculationServer.ConnectionManager.CreateConnection(Credentials credentials, ConnectionInfo connectionInfo, Int32 keyLcid, Uri workbookUrl, Boolean auditConnection, SessionId sessionId) at Microsoft.Office.Excel.Server.CalculationServer.Con… 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.64* w3wp.exe (0x08C0) 0×2434 Excel Services Application Excel Calculation Services eq3m High …nectionManager.CreateConnectionAndAddToList(ConnectionRequest connectionRequest, ExtendedConnectionInfo extendedConnInfo, Credentials credentials, Boolean auditConnection, Int32 keyLcid, ConnectionInfo connectionInfo, ConnectionKey connectionKey, AutoReaderWriterLock autoPoolLock, Connection& connection, ConnectionList& connectionList) at Microsoft.Office.Excel.Server.CalculationServer.ConnectionManager.GetConnection(ConnectionRequest connectionRequest, ExtendedConnectionInfo extendedConnInfo, Credentials credentials, Int64 privateConnectionId, Boolean auditConnection) 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.64 w3wp.exe (0x08C0) 0×2434 Excel Services Application External Data 2051 Information Refresh failed for ‘Call Register Connection’ in the workbook ‘http://clientweb/reception/Documents/Book5.xlsx’. [Session: 1.V21.26vhnMHWSZdyQqQNWeBdc90.5.en-US5.en-AU73.-0600#0000-04-00-01T03:00:00:0000#+0000#0000-10-00-01T02:00:00:0000#-006036.fab5481e-2082-4df1-af62-af0f9a6e7ea31.N User: 0#.w|ad\user_id] 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.64 w3wp.exe (0x08C0) 0×2434 Excel Services Application Excel Calculation Services 3sls Medium ExternalSource.ValidateConnection: Unable to get a connection: Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException: Exception of type ‘Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException’ was thrown. at Microsoft.Office.Excel.Server.CalculationServer.Interop.EngineInterop.CreateConnection(QueryType queryType, String connectionString, String userName, Boolean isTensor, Boolean integratedAuthentication, Int32 lcid, SecureString password, String workbookUrl, Int32 timeout) at Microsoft.Office.Excel.Server.CalculationServer.ConnectionManager.CreateConnection(Credentials credentials, ConnectionInfo connectionInfo, Int32 keyLcid, Uri workbookUrl, Boolean auditConnection, SessionId sessionId) at Microsoft.Office.Excel.Server.CalculationS… 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.64* w3wp.exe (0x08C0) 0×2434 Excel Services Application Excel Calculation Services 3sls Medium …erver.ConnectionManager.CreateConnectionAndAddToList(ConnectionRequest connectionRequest, ExtendedConnectionInfo extendedConnInfo, Credentials credentials, Boolean auditConnection, Int32 keyLcid, ConnectionInfo connectionInfo, ConnectionKey connectionKey, AutoReaderWriterLock autoPoolLock, Connection& connection, ConnectionList& connectionList) at Microsoft.Office.Excel.Server.CalculationServer.ConnectionManager.GetConnection(ConnectionRequest connectionRequest, ExtendedConnectionInfo extendedConnInfo, Credentials credentials, Int64 privateConnectionId, Boolean auditConnection) at Microsoft.Office.Excel.Server.CalculationServer.ExternalSource.TryGetValidatedConnection(Request request, Credentials credentials, ExtendedConnectionInfo extendedConnectionInfo, Boolean shouldReportFailur… 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.64* w3wp.exe (0x08C0) 0×2434 Excel Services Application Excel Calculation Services 3sls Medium …e, Boolean auditConnection, Connection& connectionOut). sessionId=1.V21.26vhnMHWSZdyQqQNWeBdc90.5.en-US5.en-AU73.-0600#0000-04-00-01T03:00:00:0000#+0000#0000-10-00-01T02:00:00:0000#-006036.fab5481e-2082-4df1-af62-af0f9a6e7ea31.N, externalSource=Call Register Connection 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.66 w3wp.exe (0x08C0) 0×2434 Excel Services Application Excel Calculation Services 482l Medium ConnectionInfoManager.InitConnInfoFromOdcFile: ODC File Uri is not valid: 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.66 w3wp.exe (0x08C0) 0×2434 Excel Services Application Excel Calculation Services 8xk9 Medium ExternalSource.ExecuteOperation: We exhausted all available connection information. Exception: Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException: Exception of type ‘Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException’ was thrown. at Microsoft.Office.Excel.Server.CalculationServer.ConnectionInfoManager.GetConnectionInfo(Request request, String externalSourceName, Int32 externalSourceIndex, Boolean& shouldReportFailure) at Microsoft.Office.Excel.Server.CalculationServer.ExternalSource.ExecuteOperation(Request request, ExternalSourceStateInfo externalSourceStateInfo, ExternalSourceStateInfo prevExternalSourceStateInfo, Int32 index, ConnectionInfoManager connectionInfoManager, ExternalDataScenario scenario, DataOperation dataOpe… 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.66* w3wp.exe (0x08C0) 0×2434 Excel Services Application Excel Calculation Services 8xk9 Medium …ration, Boolean verifyPreOperationConnection), Data Connection Name: Call Register Connection, SessionId: 1.V21.26vhnMHWSZdyQqQNWeBdc90.5.en-US5.en-AU73.-0600#0000-04-00-01T03:00:00:0000#+0000#0000-10-00-01T02:00:00:0000#-006036.fab5481e-2082-4df1-af62-af0f9a6e7ea31.N, UserId: 0#.w|ad\user_id 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.66 w3wp.exe (0x08C0) 0×2434 Excel Services Application Excel Calculation Services eq3r Medium ConnectionRequest.ConnectionRequest: New connection request. SessionId=1.V21.26vhnMHWSZdyQqQNWeBdc90.5.en-US5.en-AU73.-0600#0000-04-00-01T03:00:00:0000#+0000#0000-10-00-01T02:00:00:0000#-006036.fab5481e-2082-4df1-af62-af0f9a6e7ea31.N, WorkbookVersion=ConnectionInfo.WorkbookVersion: Uri=http://clientweb/reception/Documents/Book5.xlsx, Version=Friday, 22 February 2013 05:22:54 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.66 w3wp.exe (0x08C0) 0x2B10 SharePoint Server Logging Correlation Data xmnv Medium Name=Job: CreateUserWorkbook 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.66 w3wp.exe (0x08C0) 0x2B10 SharePoint Server Logging Correlation Data xmnv Medium Document=http://clientweb/reception/Documents/Book5.xlsx 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.66 w3wp.exe (0x08C0) 0x2B10 Excel Services Application Excel Calculation Services 4n14 Medium UserWorkbook.CreateWorkbookJob: Starting to create a UserWorkbook for BaseWorkbook http://clientweb/reception/Documents/Book5.xlsx 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.66 w3wp.exe (0x08C0) 0x2B10 Excel Services Application Excel Calculation Services aizn Medium UserWorkbook.CreateFromPreviousWorkbookAsync: previous workbook is available, no re-loading was needed 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.66 w3wp.exe (0x08C0) 0x2B10 Excel Services Application Excel Calculation Services f1va Medium CWorkbookWrapper::CWorkbookWrapper: Created with ID=2 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.68 w3wp.exe (0x08C0) 0x2B10 Excel Services Application Excel Calculation Services aysl Medium Succeeded to initialize a chart. 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.68 w3wp.exe (0x08C0) 0x2B10 Excel Services Application Excel Calculation Services 4n15 Medium UserWorkbook.CreateWorkbookJobCallback: Successfully created a UserWorkbook for BaseWorkbook http://clientweb/reception/Documents/Book5.xlsx 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.68 w3wp.exe (0x08C0) 0x1F3C SharePoint Server Logging Correlation Data xmnv Medium Document=http://clientweb/reception/Documents/Book5.xlsx 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.68 w3wp.exe (0x08C0) 0x1F3C Excel Services Application Excel Calculation Services hly6 Medium OpenWorkbookOperation.OpenWorkbookComplete: CloseUri /reception/Documents, ClientUri http://clientweb/reception/Documents/Book5.xlsx 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.69 w3wp.exe (0x08C0) 0x1F3C SharePoint Server Logging Correlation Data xmnv Medium Result=Success 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.69 w3wp.exe (0x08C0) 0x1F3C Excel Services Application Excel Calculation Services 7921 Information

Comments Off

19 Feb

Next utility for my SharePoint Toolbox

Posted in Sharepoint, Toolbox, Uncategorized on 19.02.13

There are times when I need to verify what I am syncing using the User Profiles Synchronization. The problem is, many sites won’t give SharePoint consultants access to the domain controller. This makes it very difficult to query AD.

Sysinternals have a very useful tool called: ADExplorer.
It doesn’t need installing.
You don’t need to be a member of the domain, just run it and put in the credentials.
You can use your Farm or Profile Sync account as it will have read access to your OU as per your setup.

ADExplorer for Browsing Active Directory at SharePoint sites

Click here to download

tags:

Comments Off

17 Sep

AutoSPInstaller

Posted in Uncategorized on 17.09.12

Just stumbled across AutoSPInstaller. It’s a community SharePoint Installation script.

http://autospinstaller.codeplex.com

It seems to be a good start if you haven’t put together your own scripts. And it covers many things that often get forgotten, or need to be done manually ( iFilter for PDF ). But I am finding it a bit infuriating when it gets to the Web Application level. We shall see …..

tags: ,

Comments Off