It has been many, many months since my last blog update. Life has changed considerably for me in 2016 with my two kids growing up, school drop offs, homework and being aeroplanes in the garden taking precedence over writing articles and installing Siebel patches.
In addition to my focus on family life, I’ve also closed down my consultancy (the imaginatively named “Ollerenshaw IT Ltd”), hung up my Siebel gloves and explored the world of full time roles in the great wide world.
It’s been fun, if a little daunting: I’ve worked almost exclusively with Siebel for over 15 years, so immersing myself in other technologies and roles has been difficult. I’ve found that my new roles involve a lot less hands on technology and I now find myself in the fuzzy world of architecture and strategy. It’s no bad thing, and I enjoy the challenge of taking greater responsibility for overall solution designs, working with businesses to understand what’s really important and how I can help them achieve those goals. To me, it’s an important role as it’s always been the case that shiny, snazzy Siebel solutions (including some of the “awesome” capabilities of OpenUI) often exist in the world to satiate the appetites of hungry developers – there’s often little to no business or user benefit in a lot of what happens in technically focused IT.
As part of my current role, I get involved in a lot of talk about strategy and planning for the future. It’s interesting to hear, from the coal face as it were, what’s getting the IT industry excited. I work for a retail organisation, and each vertical has different needs and wants and different solutions appeal, but for us there’s something that currently stands out: Big Data.
Of course, we’re very excited here about the prospect of Cloud, including Infrastructure As A Service, Azure and AWS. We’re also excited about Software As A Service, which is now at a level of maturity where we believe we can actually start to map some of our business need onto these types of cloud services. Though not something we’re looking at here, Birst is a great example of SaaS: it’s Cloud BI by two of the guys responsible for OBIEE nee Siebel Analytics.
But Big Data is what it’s all about here. We’re talking Hadoop, MapR – we’re looking at some of the big players and some not so big. We’re also looking at data visualisation platforms – Tableau, PowerBI, Business Objects and many others. With a bit of luck, if the kids allow me the time to do so, I’ll pen some articles on my experiences in this ever growing buzz space.
Until then, wishing everyone in Siebel Land the very best for now and the future!
Having started on a new programme of work, I’ve come face to face once again with my dreaded nemesis – Oracle BI Publisher.
Not to worry, I thought – we’re working with Siebel 220.127.116.11, surely all of the niggles have been addressed by now! How wrong I was.
Once again, Oracle have really made a shambles of the documentation around installing and configuring BIP for Siebel. I just don’t understand how hard it can be to get this stuff right.
Here are the problems that I found with the new process for 18.104.22.168:
- The Reports Guide now no longer contains installation instructions – you are instead pointed to an article on MOS (1501378.1)
- The article on MOS has an attachment that is error strewn, is unfinished and even contains internal review comments (for example, part way in you’ll see: user_name is **Q: Siebel administrator user name?)
- The MOS article guide points to the ‘Supported Platform’ document for the BIP version – this in turn pointed BACK to MOS for yet another article stating which BIP version to use (1172844.1). Why not just have ALL information in ONE place?
- The version of BIP required is NOT the one made available in the Siebel Pack area of eDelivery. You need 10.1.3.4.2, NOT 10.1.3.4.0 which is the version in the Siebel home of eDelivery
The ‘Integrating BI Publisher…’ guide is just hopeless:
- The process describing the WSDL import is incorrect and does not list the correct IO objects to delete
- The section with command line statements for importing seed data input is insanely wrong – I spent over an hour correcting the command lines and finding the real location of the seed data files
- The same section says to use ‘ORCL’ as the database type in the command line, when in fact you need to use ‘ORACLE’
- Why provide ‘seed’ data import files and commands and then immediately have manual steps to set up views and responsibilities? Why not include ALL seed data?
It’s just not good enough – Actuate disappeared a long time ago and Oracle have had years to get BIP in it’s place. However, once again the documentation is badly written, full of errors and has clearly not gone through any sort of QA process.
When can we expect a straight forward installation of BIP in Siebel? Not in the near future, it would seem.
Here’s the seed data script that I finally came up with for use in Siebel 22.214.171.124 HOR.
More BIP fun today as I discovered yet another ‘gotcha’ while upgrading to Siebel 126.96.36.199.
I have been getting these errors while trying to upload report definitions:
SBL-EAI-05010: Class name incorrect or does not extend SiebelBusinessService
Okay, all very standard – just a typo in my CLASSPATH parameter for the Java Subsystem, right? Wrong! And here’s why:
Exception:java.lang.UnsupportedClassVersionError: com/siebel/data/SiebelPropertySet (Unsupported major.minor version 50.0)
A quick MOS search reveals a new article:
JRE version 1.6 required for all Siebel versions from Fix Pack 188.8.131.52 onward [ID 1285062.1]
Now, I saw no mention of this in the Siebel Reports Guide. I’ve always used the JRE that comes installed as part of BIP and most other configurators that I know do the same. Not so with 184.108.40.206! As usual, there is very little detail in the article other than ‘install JRE 6’.
Here is what I did to resolve. Now, I’m not sure all of this is required but I’m so fed up of messing around with BIP that I’ve just gone ahead and done the lot. Feel free to experiment:
- Download JRE 6
- Install on the Siebel Server – I put the JDK in D:\Java\ and the JRE in the same location
- Update your Java Subsystem with the path to the JVM. (For example, if you’ve install Java in D:\Java\jdk1.6.0_27)
change param DLL=D:\Java\jdk1.6.0_27\jre\bin\client\jvm.dll for named subsystem XMLPJvmSubsys
- (For Windows) Set the JAVA_HOME environment variable (For example: D:\Java\jdk1.6.0_27)
- (For *NIX) export JAVA_HOME (For example: export JAVA_HOME=/usr/java/jdk1.6.0_27/
- For good measure, I added JAVA_HOME\bin to my PATH
Rumour is that Siebel 220.127.116.11 is out and about – here’s hoping that some stability will be introduced into the BIP integration, not yet more problems!
Very quick post! I noticed recently that the new Siebel Reports Guide (Revision E) has an extensive ‘Troubleshooting’ section. This contains a large number of common errors and issues along with details for investigating and resolving them.
Well worth a look if you, like many others, are having problems with the Siebel and BI Publisher integration in Siebel 8.1.x.x
You can find the relevant chapter here.
It’s great that Oracle are taking developers concerns seriously and are really making an effort now to tighten up the integration with BI Publisher. I had a chat recently with the Product Manager and he outlined really quite extensive and positive plans for the future. I’m certainly hopeful for 8.2.2 and 18.104.22.168 that the underlying issues will be resolved and we can re-focus our efforts on developing really great Siebel implementations.
I’m still in upgrade mode and have recently been revisiting Actuate to BIP migration in an 22.214.171.124 environment. Much to my annoyance, but not great surprise, 126.96.36.199 has introduced further headaches (in addition to a smattering of improvements) to the whole Siebel and BIP integration process.
First up, 188.8.131.52 introduces some SIF and seed data files for you to import. Prepare yourself for some creative thinking as you try to work out what the Release Note author meant to write and not what he or she wrote – the documentation is appalling. Notably:
- The SIF file referenced doesn’t exist. You’ll have to locate a ZIP file, extract it then hunt around for a similarly named file to import into Tools
- The ‘commands’ given to import the seed data are completely wrong. You’ll need to refer to MOS for correct instructions on importing the seed data
- Application view records have been missed from the seed data files. Reports Guide revision D has instructions for their manual creation while revision E sees the instructions vanish into thin air
- When you do get round to assigning the views to responsibilities, be prepared for misspelled view names – hey, it’s only a computer program, who needs accuracy?
Finally, those who used Doc ID 823360.1 to implement functionality to generate reports through Workflow may find it no longer works after upgrading to 184.108.40.206. It would appear that some bodge has been introduced that breaks the ‘Bookmark’ argument to the XMLP Driver Service BS. Spooling the SQL shows Siebel creating a temporary PDQ, executing it then deleting it, in order to retrieve the data for the report request. I can’t quite believe this but I have the SQL spool to prove it. You’ll need to replace all of your Bookmark arguments with hefty PDQ friendly expressions.
You may get the impression that I’m not very happy with this latest release and you’d be right. The Siebel and BIP integration has been so hastily thrown together that it’s us, as developers and customers, who have to wade through lines of debug output and SQL and come up with workarounds to these irritations.
Let us know of your experiences with 220.127.116.11 or BIP integration in general.