Powerpivot – Gemini BI

Published on

PowerPivot gives users the power to create compelling self-service BI solutions, facilitates sharing and collaboration on user-generated BI solutions in a Microsoft SharePoint Server 2010 environment, and enables IT organizations to increase operational efficiencies through Microsoft SQL Server 2008 R2-based management tools. If you dont have your own test server you can use the virtual … Continue reading Powerpivot – Gemini BI

How to auto populate InfoPath forms using the people picker

Published on

Step 1:Add the Contact Selector control to InfoPath – this only has to be done once within InfoPath, then it will be available for future forms. 1. From the Controls task pane, click on “Add or Remove Custom Controls…” then click Add. 2. Select “ActiveX Control” then click Next. 3. Locate “Contact Selector” in the … Continue reading How to auto populate InfoPath forms using the people picker

K2 Blackpoint: Troubleshooting & error logs

Published on

Troubleshooting anything to do with K2 Blackpoint the 1st port of call is going through your error logs: All logging configuration (excluding SmartObject logging) is done through the following file: C:Program FilesK2 blackpearlHost ServerBinHostServerLogging.config When you open the file in notepad, or any other text editor, you will see a section that looks like the … Continue reading K2 Blackpoint: Troubleshooting & error logs

K2 Process / Workflow Automation – Questions to ask

Published on

PROCESS QUESTIONS 1. Does the process require reporting, auditing, compliance or version control? 2. Can the process be mapped? Or has the process been mapped and optimized already? 3. Is this process in operation today, electronically, in paper or otherwise? 4. If the business process is new to the business, have the necessary participants of … Continue reading K2 Process / Workflow Automation – Questions to ask

K2 deployment error: The partner transaction manager has disabled its support for remote/network transactions

Published on

When deploying a new K2 workflow / process you get an error message containing: The partner transaction manager has disabled its support for remote/network transactions First check on the application server(s): 1. Go to “Administrative Tools > Services” 2. Turn on the “Distribute Transaction Coordinator” Service if it is not running If you still get … Continue reading K2 deployment error: The partner transaction manager has disabled its support for remote/network transactions

Deploying K2 process: Error occurred adding the feature to the farm Server was unable to process request. —> Access denied.

Published on

When deploying a K2 process you get the following error: Task Error: System.Exception: Error occurred adding the feature to the farm. —> System.Web.Services.Protocols.SoapException: Server was unable to process request. —> Access denied. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) This is normally a permission problem & you should … Continue reading Deploying K2 process: Error occurred adding the feature to the farm Server was unable to process request. —> Access denied.

K2 – “Insufficient SQL database permissions for user in database ‘SharePoint_Config’ on SQL Server instance ‘WSS1’.

Published on

If your seeing the below error in your event viewer: Error: “Insufficient SQL database permissions for user in database ‘SharePoint_Config’ on SQL Server instance ‘WSS1’. Additional error information from SQL Server is included below. EXECUTE permission denied on object ‘proc_putObject’, database ‘SharePoint_Config’, schema ‘dbo’.” Solution: The K2 Server account must be part of the Site … Continue reading K2 – “Insufficient SQL database permissions for user in database ‘SharePoint_Config’ on SQL Server instance ‘WSS1’.