The ever helpful Oli has put together a nice list of things we should hate about Siebel Tools
The ever helpful Oli has put together a nice list of things we should hate about Siebel Tools
I am working on a brand new Siebel implementation, and we are seeing a lot of errors..Really. Huge log files with repeating errors on them. If you increase the Siebel component logging to maximum, Siebel will spit out Warnings to Errors, and everything in between. It becomes difficult to find out where the actual problem is.
I figured one way is to find out the most commonly occurring errors. Fortunately, we are on a Linux server system. So a little bit of googling, and using linux’s many commands solved the problem.
Running this command in the ses/siebsrvr/enterprises/*/logs folder prints the top occuring errors in the last 10 log files in reverse order:
grep "SBL-" `ls –tr *.log | tail -10` | grep -v "Warning" | grep -v ".spf" | grep -v 'err=' | cut -f 6-10 | uniq -c | sort –n
Here is a screenshot of errors for me. The command ignores Siebel Warnings, and errors related to .spf files, and also some errors from source files.
Hope it helps !
And what about Windows you ask ? Well, Windows guys are on their own. You can download windows ports of Unix commands.
http://slc02ojl.oracle.com:7780/analytics
http://slc02ojw.oracle.com:7780/analytics
username is prodney and password is Admin123.
Today I lost a whole day trying to get BI Publisher to print check boxes in PDF output reports. Though this issue is common on most implementations, and lots of solutions documented, none of that worked for me. I am documenting the changes I made to get it working here, hopefully it will help some one else.
My requirement was to get Siebel-BI Publisher reports to print checkboxes, for boolean fields in PDF output, for the same fields where Siebel displays checkboxes.
Siebel version : 8.1.1.11 SIA [23030] ENU (Open UI)
BI Publisher version : 10.1.3.4
Server OS: Solaris 2.6.39-400.17.1.el6uek.x86_64
RTF Template:
After you have installed the BIP Word Addon, you need to enable the Developer tab, to insert the CheckBox form control.
Ensure that the “Check box enable” option is checked. Also, you may specify default value, here I have selected “Not checked”, so the box would appear without a check in it be default.
Map the control to a field in the XML, and ensure it works on your local machine.
Now if the mapping is correct you should see a checkbox on it when you preview the report. If the font setup is incorrect on you Windows machine, you will see a Rhombus instead of a checkbox.
PDF Output:
This means that BIP is able to map the field to a checkbox, but the font installation is not complete on your Windows machine. This is OK, we need to ensure the fonts are installed correctly on the server.
Server side setup:
/oracle/apps/OraHome_1/jdk/jre/lib/fonts
If the font appears in the list, select it under Truetype. In the top Field, enter Windings2. Leave the Style and Weight as Normal. Leave the TTC Number blank.
Hope it helped !
I was getting tired triggering the report from Siebel every time I made a change, so I created a new standalone report directly in BIP, with a xml file for its input. This way, I could test changes directly in BIP without logging into Siebel.
I found that although Wingdings1 font had checkboxes, this would not appear in PDF output. The easiest way to see the chars in Word is to Insert ->Symbol.
Word will show you the code for each symbol when you insert them.
Wingings 1 font works right when you’re report has HTML output. But won’t work with PDF, it would come out as some junk chars. For PDF to work, you have to use Wingdings 2.
This is inputted in the cfg file :
<property name="rtf-checkbox-glyph">Wingdings2;0082;0163</property>
If you use Siebel functions in your BIP reports for date conversion, you will get “class-not-found” errors during your report generation.
The fix for this is to point BIP to the path where your Siebel JARs are installed.
In your Work designer: Go to Addins-> Tools –> Options, and add a the path to the Java option field, under Preview.
For me, Siebel is installed on D drive.
-Xmx256M -Xbootclasspath/a:D:\Siebel\8.1\Tools_1\CLASSES\SiebelXMLP.jar;D:\Siebel\8.1\Tools_1\CLASSES\XMLP.jar;D:\Siebel\8.1\Tools_1\CLASSES\siebel.jar;D:\Siebel\8.1\Tools_1\CLASSES\XSLFunctions.jar;D:\Siebel\8.1\Tools_1\CLASSES\SiebelCustomXMLP.jar;D:\Siebel\8.1\Tools_1\CLASSES\SiebelCustomXMLP_SIA.jar
The good folks at On-Demand education have setup an online Quiz to commemorate the 20th Anniversary of Siebel. There competition seems fierce, till last week I saw only 30 names on the leaderboard, now it’s double that. The questions are from everywhere, technical and functional Siebel thingies and some history. You can find some of the answers of the questions on @lex’s awesome Siebel site, and he was involved in setting up of the questions.
The page is still open, but the correct answers are not disclosed. So go ahead and give it a try !