Categories

Archives

SharePoint 2013 | O365 Enabling External User Access

English

SharePoint Online provides cloud base SharePoint portal to the subscriber. Whether you subscribe Enterprise plan that allow many internal users or Small Business plan starting with 1 to 20 users, you always be able to invite external user.

This scenario is very useful when you build a start-up company and decide to use SharePoint Online for your portal. You can start with very cheap subscription of 1 user as the company administrator, and invite other staff as external user to the site. The external user will be able Contribute to the portal, devoted as Site Collection Administrator or as simple as ordinary reader – the only limitation is they need to buy separate Office client license to work with [read more...]

Project Server 2010 | Removing orphan baseline

English

Orphan baseline prevents Project Server 2010 report publishing queue to complete its job. In our environment it was caused by sudden disconnection of either client or SQL server during the publish command. I search arround internet and found following discussion on orphan baseline : http://social.technet.microsoft.com/Forums/projectserver/en-US/f4d638ad-003e-421c-85d9-7ed5d7fda029/project-server-2007-error-24006-reportingprojectchangemessagefailed-insert-statement-conflicted .

The solution suggested by that discussion is:

delete from MSP_TASK_BASELINES where MSP_TASK_BASELINES.PROJ_UID =’[PROJECT UID]‘ AND MSP_TASK_BASELINES.TASK_UID NOT IN ( select TASK_UID from dbo.MSP_TASKS where PROJ_UID =’[PROJECT UID]‘ )

For me, I believe that any TASK_UID not in TASK_UID of MSP_TASKS table are orphan baseline. So, change the above SQL statement to below statement will clear off any orphan baseline in EPM

delete from MSP_TASK_BASELINES where MSP_TASK_BASELINES.TASK_UID NOT IN (select TASK_UID from [read more...]

SharePoint 2010 | How to delete orphaned Web Application

English

Orphaned web application? I don’t know how it happened – but let call the symptoms orphaned web application.

Definition

Orphaned web application is a situation where you can not performed essential modification to the web application such as adding new content databases, remove extended IIS, delete web application or create new site collection. In short, the web application exists but it doesn’t work and Administrator can not remove it.

Symptoms

You will experience any of following symptoms:

Site collection are dissapear unexpectedly When you open Site Collection List for particular web application ([CA]/_admin/SiteCollections.aspx?ReturnSelectionPage=/applications.aspx), all site collection that you believe exist in that web application are missing. No operation such as content database removal has been done on that [read more...]

K2Studio | Make it alive in new .NET Framework

English

We have request to support very old application, built using K2.NET 2003. K2.NET 2003 is a workflow engine (BPM) product by SourceCode Technology Holding Inc. It was initially released on 2003, before replace by the sucessor K2 Blackpearl in 2007 (see the history here). An 13 years old product, and yes we still have some application using it. While most of our development tools have been upgraded, the latest K2.NET 2003 service pack (SP4) was released on 2006; therefore it still uses .NET Framework 2.

If we install the product into our new environment, we will get following error in the event log. This is simply because by default the assembly will be executed under .NET framework [read more...]