Select Page

Siebel Repository Analyser – FREE!

After years of plugging away at my C# / Siebel experiment, I think it’s time to call it a day. I enjoyed working on the Repository Analyser mainly as an educational experiment for myself but also as a tool to help others. I’ve learned all I can from it and it’s time to move on to something else.

Siebel Repository Analyser C# Code

Siebel Repository Analyser C# Code

As such, from today the Repository Analyser source code is now available in a public Github project that you are free to use, modify and defile at your own risk.

I will no longer be enhancing the tool but will continue to support existing users via the forums.

Thanks to all who supported the development of the software.

Blog and Store Registration Problems

I’ve had a few complaints recently that the registration and password reminder system is not working properly on the site. This includes creating a Siebel Store account, as well as registering for the Blog.

The problem seems to be related to / email servers rejecting the “New User Registration” emails. I suspect this is because the WordPress site uses the host SMTP server, resulting in a mismatch of domains that causes suspicion with that provider (and probably others).

I’ve now resolved this by using the Google Mail API to send all site emails. The result is that recipient mail servers should be far less likely to reject / block the email that is send on registration or when you request a password reminder.

What you SHOULD receive

What you SHOULD receive

Apologies for any inconvenience caused.

SQL Log Analyser 1.5

I’ve released an updated version of my Siebel SQL Log File Analyser:


The new version will now read and parse locally generated SQL spool files. Simply generate a log file using the /s switch on the Siebel Dedicated Client command line and load it into the tool. You’ll then see an ordered list of the slowest performing SQL; double clicking an entry will take you to the beginning of the SQL block in question.

You can download the tool now from the Siebel Store and use the Help > Check for Updates… menu item to download the new version.

Oracle Statement of Direction for IP2015 – Siebel Composer

You will probably already know that Oracle have released their Statement of Direction (SoD), outlining the proposed content of Innovation Pack 2015. In keeping with previous IP releases, I would expect this to drop around November / December of this year.

The SoD document itself is pretty dry and some of the “innovations” aren’t as exciting as I might have liked (seriously, enhanced help text on installation wizard screens?). However, one item jumps out: Siebel CRM Composer (Developer Preview).

So long, Siebel Tools!

So long, Siebel Tools!

This item is begging for screenshots but instead we are given some high level statements about what CRM Composer might give us:

  • Siebel CRM Composer allows multiple instances of application functionality to be created: Finally, versioning of configuration objects in the Siebel Repository
  • [Ability for configuration to be] placed into production via the web based administrative user interface with no downtime: The end of the SRF? Here’s hoping!
  • Obviates the need for proprietary web templates: Are we going to see the end of all external file based configuration?

This is fantastic news from Oracle and, given my well known and slightly irrational hatred of Siebel Tools, something I’m really excited about. Not only is this news exciting from a developer perspective, Siebel Composer could finally take full fat Siebel into the cloud. I doubt are quaking in their boots, but this may well give them something to think about.

It looks like another exciting year for Siebel!

Christmas Shutdown

2014 has flown by and much has happened over here at Ollerenshaw Towers: a new addition to the family, in the shape of wee Callum Ollerenshaw, and the arrival of IP2014! It’s been a fun and challenging year and I don’t expect 2015 to be any different. We’ve seen Siebel go from strength to strength over the last 12 months and I’m convinced now that the nae-sayers who foretold the end of Siebel have been firmly put back in their boxes! Personally, I’m looking forward to IP2015 and the transformation of Siebel Tools – well, one can but dream!

We’ll be shutting our blog doors for the Winter but will be back in January with more Siebel fun and games. Until that time, wishing you all a very


and a happy and prosperous New Year.

Oli Ollerenshaw

Siebel Open UI – Oracle Community Forums

As with many others who are implementing, or have implemented, Siebel OpenUI, I’ve come across bugs and issues. I, personally, really struggled with the response time and quality of Service Requests that I subsequently raised in My Oracle Support. I may have just been unlucky and I’m sure OpenUI has brought with it a surge in the volume of SRs being raised in MOS, but I found the experience frustrating and lengthy. Things have improved, for me anyway, over the past month though so it looks like Oracle is getting it’s act together.


Before I venture on to MOS these days, I first visit the Oracle Community Forums – or more specifically the My Oracle Support Community (MOSC) forums. These are private forums for My Oracle Support users only – they are not open to the general public. However, they are governed and monitored by Oracle staff so the questions asked and information shared is generally of a high quality and very specific to the topic at hand. I’ve been squatting in the OpenUI forum for some weeks now, posting up my concerns, issues and questions and the response I’ve been getting is absolutely fantastic. Clearly, Oracle have some highly skilled Siebel bods on board and when these guys and girls get unleashed on the forum, it’s a different experience altogether when compared to SRs in MOS.

I would, therefore, like to encourage all of my readers and passers by, who have an interest in OpenUI, to go along and join in the community discussion. I bet there are people out there who are struggling to get the answers they need and this is the place to get them. There are also highly skilled individuals around, who have been through the OpenUI process, who’s knowledge and expertise would be invaluable. I’d highly recommend getting involved, sharing knowledge and upping your profile within the Siebel Community.