After much deliberation, I have finally answered the eternal question that is the core of this web site: “Is there life after Siebel”?
The answer, I’ve concluded, is absolutely! That life, however, is so focused on family, friends and a whole new career, that I simply do not have the time or resources to maintain the site any longer.
It is, therefore, with a mighty fanfare and no regrets, that I declare the site “closed for business”.
I have had a wonderful time, nearly two DECADES, working with Siebel technology and some of the most amazing people in the business. But it’s time to focus on other things. Farewell, Siebel Chums, may your lums forever reek!
Something completely different this week! I’ve been a bit of computer spod for most of my life, and it all started with a 48K ZX Spectrum home computer. My dad bought it in the early 80s and I took to writing games and keying in code listings from the likes of Your Computer and Your Sinclair. As a big fan of emulation and retro-computing, I’ve obviously acquired a Speccy simulator to relive the good old days.
Now, last week I was discussing the “Monty Hall Problem” with my missus. For the uninitiated, this is a probability problem that is often described in the context of a US game-show, where a contestant picks one of three doors. Behind one of these doors is the star prize, a car, with the other doors concealing a pair of undesirable goats. In the game, once the contestant has chosen a door, the host, the titular Monty Hall, reveals, at random, one of the goat doors and asks the contestant: “Do want to stick with your original choice or choose the other door?”. The Monty Hall problem suggests that the contestant has a 1 in 3 (33%) chance of winning with their original choice yet a 2 in 3 (66%) chance if they choose to swap. As such, the contestant should always choose to swap to have the best chance of winning the car. The problem can be proven mathematically, using Bayes Theorem, but is a fascinating problem to simulate using a simple computer program.
Combining these two interests, then, I’ve written a simulation of the Monty Hall Problem in BASIC on my simulated ZX Spectrum.
The solution is also available as .tap and .z80 files, which are available at the bottom of the listing. Next steps? To implement as a Siebel Workflow of course! 🙂
I’ve been around Siebel for nearly 20 years now. Yes, I know I don’t look old enough, but that would be the fresh Scottish air. Siebel has evolved over that time but never to any sort of degree that truly made life better for a Siebel developer. Now, with the release of IP 2017, and just in time for me to move away to do other things, Oracle have given us a game changer: Siebel Workspaces and the SRF’less World.
The clear goal, though a goal that’s not quite achieved, of Web Tools in IP 2017, is to allow configuration of the Siebel Application through the thin client UI. For simple changes, this is largely successful, though Oracle has a lot of work to do to do away with Siebel Tools altogether.
Here’s a walkthrough of the steps to add a new field and expose it on an applet, just to show you how neat Web Tools can be.
Log into Siebel Web Tools
Click the “Workspaces” icon in the top right
From the “Main” branch, click “Create” to create a new Workspace instance, giving it a name and a description
Close the Workspace window, with the big “X” in the top right
Click on “Business Component” and query for “Contact”. Note that, now you have an active Workspace, everything is now editable in Web Tools
Click “Fields” and add a new field:
Name: OLI Life After Siebel Flag
Now go to “Applets” and query for “Contact List Applet” and click “List” then “List Column” and add a new record:
Name: OLI Life After Siebel
Field: OLI Life After Siebel
Display Name String Override: Life After Siebel?
HTML Icon Map: CHECK
HTML Type: CheckBox
Go to “Applet Web Template”, click on “Edit List” and click the “Edit” button
Drag our new list column to placeholder 540
Our changes are done – easy peasy!
Now to publish the changes
Go to the Workspace page again
Select your “In Progress” workspace and click “Version” – now this is actually called “Checkpoint” in Siebel Tools but it doesn’t the same thing
Give the checkpoint a name and click the “Version” button
You’re ready to deploy the change!
With your “In Progress” Workspace selected, click the “Submit” button then click the “Deliver” button
Give the delivery a name and click “Deliver” – Web Tools will do its thing!
Now get into your Siebel application, Siebel Call Center in my case
Navigate to “Site Map”, then “Contacts” and finally “Contact List”
Behold your new field – all without an SRF or server restart in sight!
Web Tools is finally on the right path to deliver agility in Siebel development. It’s very clunky in places and you’re still bound to Siebel Tools for many tasks. However, this is a massive leap forward and I can’t wait to see what IP 2018 brings in this space.
A couple of people have asked me recently about the inactive “Edit Web Layout” menu item in Siebel Tools. Well, that functionality is gone – web templates are no longer stored locally in files, but in the database, and so the ability to access this function in Siebel Tools has simply been deactivated. However, all is not lost – “Edit Web Layout” is still available, but you’ll have to access that function through the new Web Tools.
To make matters even more entertaining, that function is not enabled by default nor is it enabled automatically via any of the Patch Sets currently available (up to 17.6 at the time of writing). However, 17.6 does dump a little gem into your Siebel Server BIN folder for you to stumble across, if you happen to read the entire contents of the “Known Issues” section of the patch release notes. Here’s a quick summary of what you have to do, in a Windows environment, to work around “Bug Id 27113012”:
Install the latest Patch Set (17.6 is what I’ve been using) to your Siebel Enterprise
Open a command line and change directory to the Siebel Server installation BIN folder (e.g. <SIEBEL_HOME>\ses\siebsrvr\bin\)
Execute the batch file named “EditWebLayout.bat”
After executing the batch file, you will be prompted to enter the following information:
Full path of ODBCSQL: <Siebel Server BIN Location>
ODBC Data Source: <ODBC DataSource Name>
Table Owner Name: <Table Owner User - 'SIEBEL' in most cases>
Table Owner Password: <Table Owner Password>
TBLO Name: <A cryptic one this. The batch file gives some garbage about ORAPQ100, or some such. I just used the table owner again, 'SIEBEL'>
Repository Name: <Repository Name - '"Siebel Repository"' in most cases. Yes, you have to put the quotes around it or the batch file will fail>
Check the output of the command in the log file, EditWebLayout.log, and you’ll see that a bunch of seed data has been loaded
Clear the browser cache and re-login to the Web Tools application
Navigate to your Applet then Applet Web Template
You’ll see an “Edit” icon in the bottom right (cunningly, the tooltip says “Preview” – great job, Oracle!)
Here’s the “Edit Web Template” button
Click this and you’re back on familiar(ish) ground
And… edit away!
Some wee observations:
Why do Oracle insist on disabling functionality before they fully implement an alternative?
Why do Oracle still find it so difficult to deliver repository and seed data fixes, outside of horribly written, unintuitive, manually executed batch scripts that I have to hunt in their obscure documentation to find?
Ho hum, I guess this sort of hack-around is what we’ve come to expect and accept from Siebel releases these days.
I’ve put together many tools and apps over the years, mostly to help me learn the C# language, but also to help me on my quest to get the most out of Siebel. The Siebel Store was an experiment in “commoditizing” these tools and my code, and it hasn’t really worked very well given the nature of what we expect (i.e. everything for free) and how niche developers work together as a community (through mutual sharing).
In the true hacker spirit, therefore, I’m making all the tools completely free to download from now and for ever more. Simply head on over to the Software Storeand choose your downloads – you don’t even need to be a registered user. I’m giving away:
Siebel Performance Log Analyser
Quickly see poorly performing SQL in your client or server SQL logs
Siebel Error Log Analyser
Quickly and easily identify critical “SBL” errors in your log files
Dynamic dedicated web client logging – and yes, it supports Siebel IP 17!
Advanced Microsoft MSMQ queue management in one handy app
I hope these tools help you on your own journey’s towards Siebel greatness!