Sharepoint error: EXECUTE permission was denied on the object ‘proc_putObject’

This is really a part of a longer story but I wanted to get this bit documented before I lost track of which error occurred when.

I was following this blog reference in order to fix something else but had another error occur mid-process.

Basically the instructions are:

  1. Disable Publishing in the site
  2. Disable Publishing in the site collection
  3. Enable Publishing in the site collection
  4. Enable Publishing in the site.

The error occurred when trying step #3 to re-enable the publishing.

The EXECUTE permission was denied on the object ‘proc_putObject’, database ”, schema ‘dbo’.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Bool…..


…..lingJobDefinitions(SPSite site)


It appears that the Disable option is not permission controlled while the enable option is. What I discovered was that while the service account had permissions on most of the sharepoint db’s it was not dbo_owner on the config DB. I found this using SQL Management tools and made the appropriate change to add db_owner permissions.

I could then re-enable the Publishing service.

SugarCRM contacts.php email1 column issue

My original post in the SugarCRM forums was titled 5.1 Contacts export file shows email1 column twice but with invalid data.

I had not looked at this for some time but it raised its head again this week and I noted that while I had issued a bug report and it has been assigned, it will not be deployed until v5.5. so I’ll need to keep making the manual changes in the various v5.1/v5.2 sites that I manage.

Bigpond Cable Usage Limits

I’ve used Bigpond Cable (alongside Foxtel) as my broadband provider for over 10 years and recently the top level plan of 60G is proving to be problematic with slight over-runs costing a small fortune @ $0.15 per Mbyte particularly when I cannot figure out what is using the bandwidth.

So as a starting point I used a freebie bandwidth meter on all the pc’s we use at home. This was ok as it provided some guidance as to usage stats but they did not relate to the actual Bigpond Usage page which is what I get billed for.

So today I’ve installed the last release of the Usage Agent by Christiaan Cable from SourceForge. Now this is no longer supported but the source is available if it needs mods but for now it will do what I need to alert the family as we progress through the month.

I also looked at these locations as references:
http://asp.digitaldj.net/
http://forums.whirlpool.net.au/forum-replies-archive.cfm/763834.html
http://www.wpool.com/bpwatcher/ (Installed but too many errors)

Mindjet MindManager and Sharepoint

Notes on modifications to get Sharepoint to recognise MindMap file types

http://www.wssdemo.com/Pages/mindmanager.aspx

gives these instructions but the paths were not the same for my SharePoint 2007 installation. So I modified these instructions as:

Server Configuration:

Open the file
Local_Drive:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions12TEMPLATEXMLDocIcon.xml

Add the following line within the ByExtension element in DocIcon.xml:

Save DocIcon.xml

Copy the file MindManager.gif to the
Local_Drive:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions12TEMPLATEIMAGES directory
See note below on how to get the MindManager.gif file

Add the following MIME type to IIS using the IIS Manager (Select Mime Types -> Add)

Extension: .mmp .mmap .mmpt .mmat .mmmp .mmas
MIME type: application/vnd.mindjet.mindmanager

MindManager Icon

The icon file for MindManager in V8 includes a variety of sizes of icons. The default is 48px square while 16px square is really what we want for a standard Sharepoint file listing.

So I used IconFX to extract the 16px icon as a .gif file and used that instead.

MindMap v8 Icon gif file

MindMap 8 Icon

Finally

Issue an iisreset on the Sharepoint web server to get the new config uploaded.