Informatica Cloud and Windows Server 2012 R2 – CreateProcess error=14001

I just setup a new Windows 2012 R2 server with SQL Server 2012, and hooked it up to Salesforce with Informatica Cloud.

The configuration of the connections was very easy, as was the mapping of source to target fields.

However when I tried to run the mapping I got the following error:

“Internal error. The DTM process failed to start due to the following error: [CreateProcess error=14001, The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log or use the command-line sxstrace.exe tool for more detail”

Apparently this is just down to the Informatica Secure Cloud Agent not having VC++ binaries installed. This is rather confusing given there isn’t very much on this error message. Anyway I found and installed the the VC++ and all worked well.


Informatica KB on the issue:


Link to the VC++ binaries that everyone seems to insist that you don’t need:


Recover lost Powerpoint files in Office for Mac 2016

I’m finding the new Microsoft Office for Mac 2016 rather buggy, and this evening PowerPoint crashed losing all my changes throughout the day!

Powerpoint has a ‘Restore’ command under its ‘File’ menu, which was… empty.

There are lots of answers on Google to restore under this scenario for PowerPoint 2011, but nothing for the new version

So after working backwards from a solution for Excel 2016, I discovered that you just have to look in:

/Users/”User Name”/Library/Containers/

(Obviously change “User Name” with that of the user you lost the file under)

You should hopefully see some files with the word ‘_autorecover’ appended at the end. Identify one with a timestamp close to where you want to recover.

Copy that file somewhere safe (such as the desktop) and give it a .pptx suffix at the end.

Finally you can try opening with PowerPoint but it may tell you that it is corrupted. If this happens try one of the following strategies:

  • Change the suffix to .ppt and try open again with PowerPoint 2016
  • Open with Apple KeyNote instead
  • Change the suffix to .rtf and try open again in PowerPoint (this was suggested in the comments, I haven’t tried myself) and the Content Management System – Part 3

Part 1 and Part 2 of this series was about how to create a simple site in the Content Management System.

I left the Publish part for Part 3, since this can be a discrete action that a business may want to execute in isolation from the content generation.

You probably want to have a look at the simple ‘Site Configuration’ panel, which will give you some options around ‘click jacking’ (preventing the rendering of your site in an iFrame from another site), as well as allowing you to set the HTML files that will be used for the default ‘Home’ page as well as the ‘404 Not Found’ page.

‘Enable Anonymous Preview’ is useful if you want to test from a variety of devices.

Screen Shot 2015-07-21 at 11.34.15 AM

There are a few more panels which provide the ability to:

  • Custom properties : Constant values that could be reused throughout the site, such as a phone number
  • Branding properties : Expressions for use in Stylesheets
  • IP Restrictions : Restrict access to specific assets in your site based on an IP range
  • URL Redirects : Single place to manage redirects
  • User Roles : All users with access to will be listed here already
  • Languages : Add other languages variants to your site

Unfortunately my Developer edition does not allow publishing as part of the licensing, however if I had another edition then I would see a ‘Publish Changes…‘ button on the toolbar. (Note to Salesforce: Why not just have the button disabled? Hiding it makes no sense at all).

You should then be able to see your site published. The following screenshots are cheating, since I am just using Preview, but it should look exactly the same.



It is also important to note that you can duplicate and export entire sites, so it is possible to experiment as much as you like in your developer instance and later export to production when you are ready. manages basic web hosting quite effectively. It is not versatile enough for complex web hosting, and in a way it is probably a good thing because at this level of functionality it is possible to give business users a direct method to publish content.

I would still probably advise a technical administrator actually oversees the process however, since you are restricted to 25 sites, which means inevitably you will get reuse, deletions and overwriting of existing content. and the Content Management System – Part 2

My previous post gave a quick look at creating a new site.

I thought this post would be about the difficulties around getting a ‘real world’ site to work, however I was surprised how easy this actually was.

I identified some HTML5 sites that can be freely downloaded as ZIP files. I chose the Parallelism example, which has the folder structure on the left.

As you can see it is fairly comprehensive, with one html main page along with lots of CSS stylesheets, images, fonts and javascript.

It is also a good example because it is ‘responsive’, and should render appropriately on different browsers and devices.

You can run this example just by opening the index.html file in your local browser.

Screen Shot 2015-07-21 at 10.52.06 AM

Download the ZIP file containing the site you want, and do not extract.

Screen Shot 2015-07-21 at 11.07.54 AM On your empty site, just click the ‘Import‘ button
Then select the ZIP file and import it with all the options ticked.  Screen Shot 2015-07-21 at 11.15.06 AM

And that is … it. automatically places all the files into its own folder structure:

Screen Shot 2015-07-21 at 11.24.16 AM

You can then click the ‘Preview’ button to see how it looks hosted on

The great thing about this is that for relatively simple web content that you may receive from a Creative Agency, then the technical barrier to directly import, preview and then publish that content is very low indeed.

My next post will look at the Publishing action. and the Content Management System – Part 1 and the Content Management System – Part 1

There is a content management system feature of that doesn’t get that much attention: can be used to host public facing websites on the platform. It is rather lightweight and not really intended for complex content management requirements.

Currently there are some limits. All non-Development editions are limited to 40GB of bandwidth every day, with between 500,000 and 1,000,000 daily views depending on the edition you are using. This actually covers quite a lot of small to medium publishing scenarios. If you think this could be too low for you then you should put some serious consideration into a higher end CMS product.

There are also no workflows for publishing, which is rather important to those who want to move the mechanics of publishing to the realm of the Business User.

There are some help pages on the subject, but I thought it would help people generally to show the process and give some visualization.

In this article I will just show the basics of getting started with a brand new site.

Firstly you need a Salesforce edition with enabled:


Then Navigate to Setup -> Administration Setup -> Manage Users -> Users .

Go ahead and edit the user you want for this. There are two types, which are ‘Contributor’ and ‘Publisher’.


Obviously in a ‘real world’ scenario you almost certainly want the roles of contributor and publisher separate, with the publisher reviewing and giving their approval for the content to be published.

Click on the ‘’ app and click the ‘New’ button:


You will then get a simple dialog box for creating a blank new site, or import an existing site or template. Here is an example how to create a new site:


This will then create a completely empty site ready for you to work with:


My next article will show some more details around creating and publishing content.

Fixing Bluetooth keyboard and mouse issues on MacBook Yosemite

The one big thing I miss about Windows is that with about 5 minutes Google-fu you can find a technical solution to your problem.

The big problem with an Apple Mac is that if someone has a specific issue with their device, then there are hundreds of forum pages with helpful comments such as ‘yes! me too!’ or ‘Well I don’t have that problem, my machine is OK’.

So, simple problem. Suddenly by Bluetooth keyboard and Magic Mouse started being ‘sticky’. Frequently key strokes and mouse clicks were not being registered, and nothing in the settings seemed to help. Restarting also didn’t help.

The following will delete all your other Bluetooth devices from your Mac. For me it is trivial to pair them again afterwards, but it is your call.

The quick way to fix this and get on with work is to:

  1. Go to “\Macintosh HD\Library\Preferences”
  2. Delete  ( Make a copy on the desktop if you want to be really safe )
  3. Restart

That is it! The file will be recreated when you restart.

Quick Overview of the Salesforce Marketing Cloud Audience Builder

Quick Overview of the Salesforce Marketing Cloud Audience Builder

The Audience Builder in the Salesforce Marketing Cloud is a way to create specific groups of people to send emails to, as well as further split that group up into smaller more targeted groups for different email content.

There is an official overview on the ExactTarget help pages (Public), as well as an online course with video walkthroughs in the course catalog of the 3sixty website (private). The videos, although professionally created, are a bit hard to follow owing to the user interface having been recently revamped. There is also a ‘certification’ exam, which is rather easy if you had been paying attention through the course. I can see the exam being useful if you need to verify if someone actually knows how Audience Builder hangs together.

The first question would be where to find it? It does have to be enabled by ExactTarget, and if it has then you should see it under Data & Analytics (and if you can’t then you need to contact ExactTarget).

Where is audience builder

Before diving in, it is probably helpful to get familiar with some of the terms that are used in Audience Builder, such as Universe, Population and Contact. I made a quick cheat sheet to help remember, although if your attributes and dimensions are already set up then you just have to use them rather than know how to define them.

AB Attributes and Dimensions

Once you have that, then you must understand how Segments work on your resultant Audience. You should note how Priority between segments work, as well as Waterfall suppression of which Audience members enter which segment. This will help avoid unexpected questions about why certain members were not included in an intended email mailing.

AB Segments

If you’re now comfortable with that, it is worth to just look at the Audience Builder screen to get an idea how it works. The Overview screen just shows a long list of all currently defined Audiences:

Audience Builder Overview

If you go ahead and click any of these, then the Summary tab has everything that you would expect, which is a high level breakdown of your Audience, including how much of the Population your Audience is using and what is its current Segmentation:

Adience Builder Summary

The Filter tab is also straightforward. It defines the rule or rules that make up your Audience before segmenting. In this case all males between certain ages:

Audience Builder Filter Definition

The Segment screen allows you to further split up your Audience. You don’t need to actually define any Segments, however you can edit or add new Segments here if you wish. You can check the impact (in terms of Audience numbers) of any change here. Again, Waterfall Suppression comes in effect here, with priority to the lowest numbered Segments in the list.

Audience Builder Segments

Finally when you are ready, you can Preview or Publish your Audience on the Publish tab:

Audience Builder Publish

Once your Audience is published, then you are ready to start defining emails to send to them, as well as particular variations on each segment.

There is a good deal more detail if you drill down into each screen, however I feel that the online course will do it more justice. If you have access to the Salesforce Marketing Cloud then you should be able to see all the details in the associated 3sixty course.