For all you .Net gurus go download it now!

Great work David.

I recently came across this error after a clean install of UCM 10gR3 on win2003, MS SQL 2005.

Unable to execute install ‘(Err)’” Folders Unable to alter table ‘!csDbTableMissing’. Database table does not exist.

Unable to execute service UPDATE_META_TABLE and function updateMetaTable.
(System Error: Unable to alter table ‘!csDbTableMissing’.) Unable to alter table
‘!csDbTableMissing’. Database table does not exist.)

It had me scratching my head trying to figure out what was going wrong…
The content server seemed to be working fine, but when I installed new components; like ‘folders’ the Tables in the database i.e. collections weren`t being created?

First I thought the DB users role had changed, but I could manually log in and create tables..
Later on I realised that the problem was actually down to the schema name setting. Ooops..

Read on to see how to configure UCM correctly to work with a Database Schema Name..

(more…)

I`v not really had any luck with using SSPU`s ftp. (personally I think there’s a bug and ftp has never worked in SSSPU 7.x, but then again no ones complained, so maybe I`m doing something wrong??? or everyone is scared to work with SSPU :D)
The strange thing is my ftp status in SSPU always comes back as successful with no errors, but no files appear on the destination server.

So, I decided to write up my own ftp configuration, to transfer files as soon as SSPU had done its transformations.

Read on to find out how its done

(more…)

Every time I move jobs, I seem to end up rewriting this little script which allows Broad Bean to post jobs to other websites/application.

So I am going to post it here.. Just encase I get asked to write it again..
lol and I`m sure some one else may find it useful..

If anyone is setting up a Broad bean Job import feel free to use this code; although you will have to write out your own store procedures to map out the xml data into your database.

Click here to download the example.

You may find some of these references useful:
XML DOM MSDN

First off I HATE SSPU.

Why!!! Why would you buy this product, bolt it on and rebrand it as stellent/oracle?..
It causes so many problems and gives me real bad headaches, especially when trying to setup transformations..

The documentation for SSPU makes everything sound so simple… That is; if you can find any documentation… it makes SSPU sound like a great asset.. But in reality I haven`t been able to get a third of the commands to work.. Maybe I`m using them incorrectly.. But your try raising a service request with Oracle and the engineers run into the same problems..

I just don`t understand why Stellent didn’t just write their own transformation tool which plugged into the inbound refinery.. Now that would of been a good idea and I really hope that Oracle have plans to replace it in the future.

Any way over the next couple of months I will be updating this post with some of the XML configs I use to do transformation you never know it may help some of you guys in the future..

Read On to see the examples..

(more…)