Problexi

err: ERROR Failed to get cluster name. (STU00165) err: Error description: Database access error. Reason Loading shared objects failed. First tried to load library clntsh and failed because of error: [clntsh: cannot open shared object file: No such file or directory]. Second tried to load library libclntsh.so and failed because of error: [libclntsh.so: cannot open shared object file: No such file or directory].

2010-03-10T12:40:00.000+02:00

I was using Business Objects XI 3.1 on Red Hat Enterprise Linux 5 and when run cmsdbsetup.sh to check the CMS repository I faced the following error: err: ERROR Failed to get cluster name. (STU00165) err: Error description: Database access error. Reason Loading shared objects failed. First tried to load library clntsh and failed because of error: [clntsh: cannot open shared object file: No such

QaaWS HTTP Servlet QaaWS error Sorry, something seems to have gone wrong... here are the details:

2010-03-07T11:19:00.000+02:00

When using Query as a Webservice, and you try to import the WSDL link into Xcelsius an error may pop up and say "Unable to load URL". Or when you paste the link into your internet browser an error occurs as following: QaaWS HTTP Servlet QaaWS error Sorry, something seems to have gone wrong... here are the details: Exception - com.crystaldecisions.sdk.exception.SDKServerException: An error

Cannot access the repository. (USR0013)

2010-02-23T15:00:00.001+02:00

[repo_proxy 13] SessionFacade::openSessionLogon with user info has failed(Transport error: Communication failure. (FWM 00001) (hr=#0x80042a01) If are facing this error then you need to add your computer name to the hosts file. You can find the hosts file at this directory C:\WINDOWS\system32\drivers\etc open the file with Notepad and add the ip and the server name for example: 192.1.1.200

Xcelsius 2008 error #2170

2010-02-18T15:24:00.001+02:00

If you are using Xcelsius and have encounter error #2170 when you viewing a published dashboard then you have to check the link, if you are using IP try to change it to the hostname, for example: use http://boserver:8080/.../.. instead of http://192.168.1.3:8080/../.. The problem could be also the crossdomain file which is elaborated at this website http://neverknewthat.wordpress.com/2008/03/19/

Could not determine the process id of the java process. Changing the IBMWAS6Service - ibmNode01 service status to the "stopped" state.

2010-02-10T12:47:00.003+02:00

Could not determine the process id of the java process. Changing the IBMWAS6Service - ibmNode01 service status to the "stopped" state. To prevent this error, try recreating this service with the -logRoot parameter. The value of the logRoot parameter should be the directory in which the server's .pid file is created.If the WAS is unable to strat and produce the previous error do the following:

Error-1904 Module C:\Business Object\BusinessObjectsEnterprise 12.0\win32_x86\AppPluginMgr.dll failed to register.HRESULT -214704769

2009-12-17T13:57:00.007+02:00

If you are facing this error: Error-1904 Module C:\Business Object\BusinessObjectsEnterprise 12.0\win32_x86\AppPluginMgr.dll failed to register.HRESULT -214704769 when you are trying to install Crystal Reports Server 2008 ( or other Business Objects product) then you need to disable the Data Execution Prevention (DEP).To Disable DEP do the following:Open the boot.ini ( located in your C drive by

Xcelsius: Application Error Couldn't load keydecoder.dll

2009-12-03T09:48:00.003+02:00

To solve that error you have to copy keydecoder.dll file from "Installation Directory\BusinessObjects Enterprise 12.0\win32_x86" folder and paste it to file into "Installation Directory\Xcelsius"

Unable to see tables in the Table Browser in Universe Designer using database IBM DB2

2009-11-05T13:18:00.004+02:00

If you can't see the Tables inside the Table Browser of the Business Objects Universe Designer and you are using IBM DB2 or you are facing the following error:[IBM] [CLI Driver][DB2/NT] SQL0443N Routine"SYSIBM.SQLTABLES' (specific name "TABLES") has returned an errorSQLSTATE with diagnostic text. "SYSIBM:CLI:-805", SQLSTATE=38553Then you need to BIND your database, in order to able to view the

Business Objects cannot logon to InfoView

2009-11-01T12:52:00.002+02:00

THE UNDERSCORE! "_". I faced a weird problem that Business Objects cannot login to the InfoView when I write the Hostname in the InfoView link: http://BO_SERVER:8080/InfoViewApp .I tried to login with localhost: http://LOCALHOST:8080/InfoViewApp and it logged successfully to the InfoView.The problem is the "_" in the hostname, I think Business Objects cannot resolve it or something. Honestly, I

Slowly Changing Dimension (SCD)

2009-10-15T15:59:00.006+02:00

Yes, it does.. it changes. Sometimes the data inside the dimension tables needs to be change from time to time according to the business. Lets make that clear, imagine an employee that is living in the United States:EmpID | Country141 | "United States"And then he moved to Canada. In this situation you can not simply insert a new record like this:EmpID | Country141 | "United

Why Business Intelligence?

2009-10-04T09:17:00.003+02:00

Any smart business owner today will tell you that appreciating the value of data is vital to a businesses success. Most businesses understand that value but not every business knows how to truly push the boundaries. In the past, Business Intelligence solutions were seen as something only the elite can afford and small to medium sized businesses were more than satisfied with using Microsoft Excel

Microsoft Access: SQL COUNT DISTINCT Alternative

2009-09-02T09:47:00.002+02:00

I was kind of taken by surprise yesterday when I was working on a small project of mine and realized that Microsoft Access does NOT support COUNT(DISTINCT)!Yeah I did not mistype. I have been working with Microsoft Access since Microsoft Access 2000 and I never ran into this problem before! Weird but expected since I attempt to avoid Microsoft Access whenever I could and only use it for those

Business Objects XI 3.1 error while installling on Linux (Redhat Enterprise Linux)

2009-07-06T14:48:00.004+03:00

When trying to install BusinessObjects XI 3.1 on Redhat Enterprise Linux 5 it gives that error:Patch checking complete Can't load '/opt/boe/boxi3.1/perl/lib/site_perl/auto/XML/LibXML/Common/Common.so' for module XML::LibXML::Common: /opt/boe/boxi3.1/perl/extlibs/libz.so.1: cannot restore segment prot after reloc: Permission denied at /opt/boe/boxi3.1/perl/lib/5.8.8/i686-linux/DynaLoader.pm line

Xcelsius: Default Selected Item From Dynamically Generated Labels

2009-06-29T16:18:00.006+03:00

I think we all have experienced the joy of generating a list of labels dynamically for a selector component in Xcelsius. I think we also might have experienced the frustration of trying to define a specific value from that dynamic list to be the default selected one.Consider this scenario. I have a Combo Box whose labels is a list of years retrieved by a web service. The range given for the Combo

Cannot Perform this operation. No Valid License found (Error: INF)

2009-05-25T10:45:00.003+03:00

If you encountered that error when trying to access a Web Intelligence report please do the following steps:Run> regeditGo to HKEY_Local_Machnie > SOFTWARE > Business Objects > Suite 12.0 > Shared Tools > keydecoder.dllChange the Path string to [BOBJ Directory]\BusinessObjects Enterprise 12.0\win32_x86\keydecoder.dllRestarts the serversInstalling Xcelsius 2008 after BusinessObjects may be the

DBDriver failed to load, dbd_db2cli.dll (The specified module could not be found)

2009-04-22T12:49:00.003+02:00

You may face the following error when you try to setup the repository connection for the performance manager:DBDriver failed to load : C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer\dbd_db2cli.dll (The specified module could not be found.)The default path for the DB2 client on the server is at the end of the windows "Path" variable. This is

Considering Optional Elements and Attributes In LINQ To XML

2009-04-16T09:42:00.008+02:00

Consider the following XML file:

0 0 0

LINQ To XML Mayhem

2009-04-14T13:56:00.005+02:00

I been playing around with LINQ To XML for quite some time now and I have to say that I am loving it more and more every day. One of the things that I have always hated about .NET, regardless of the language you use, is the confusing XML parsing API's available. Sure they are powerful and plentiful, but I hated them! I still do!Enter LINQ To XML, Microsoft's XML parsing extension to LINQ. It is

Applet aa.sa.SAAP notinited

2009-04-05T13:39:00.004+02:00

You may encounter this message in web browser status bar when you log into InfoView and go to the Dashboards and Analytics setup. I faced that problem and the solution was to install Windows Server 2003 service pack 2 ( SP2 )

Teradata ODBC Connection For Linux

2009-03-25T23:58:00.006+02:00

Here is the steps need to be done in order to get NCR Teradata run Business Objects XI 3.x Web Intelligence Red Hat Enterprise Linux 5 (RHEL 5):1. Install Teradata Client on the RHEL 52. Edit the ODBC.INI in the "bobje" directory and configure it as shown below :[ODBC Data Sources]teradataodbc= NCR 3600 running Teradata V2R6.1[teradataodbc]Driver=/usr/odbc/drivers/tdata.soDescription=NCR 3600

Hiding The Refresh Button In BusinessObjects XI R2 Web Intelligence Reports

2009-03-24T10:03:00.006+02:00

How To Do ItHiding the Refresh button in BusinessObjects XI R2 Web Intelligence reports might seem like a troublesome feat at first, particularly because BusinessObjects does not provide a built in option to do it out of the box. It is not and is considerably very simple.To do it, the editing of a simple JavaScript file is required. This JavaScript file is responsible for loading the default Web

Arabic language is not displayed properly in Dashboards and Analytics

2009-03-01T12:32:00.002+02:00

It seems that the SVG Viewer has problems while encoding Arabic in the dashboards and analytics. To overcome this problem in Business Objects XI Release 3 you have to use Flash as a viewer and not SVG. Follow these steps to switch the viewer to Flash:Logon to Business Objects InfoViewClick on PrefrencesClick on Dashboards and AnalyticsEnable the Checkbox beside " Use Macromedia Flash when

Western Degradation Of Middle Eastern Cultures

2009-02-19T17:27:00.003+02:00

This is yet another one of my posts that strays away from the general theme of this blog, but I simply could not resist.I was watching the third Indiana Jones movie just now, Indiana Jones and the Last Crusade, and I could not believe the degrading of Middle Eastern culture that was going on in that movie. I have to admit, I am not a bit surprised, since Western politics seems to forever want to

Refresh Table Structure In Designer

2009-02-08T14:44:00.006+02:00

So let's say you created your table structure in your database backend and you imported your table in Designer, BusinessObject's sementaic layer designer.You create your objects based on fields in the imported table structure. This is important to note since any modifications to the table structure in the database backend itself will not be reflected back into Designer!So now what? Do you delete

IBM DB2 Error: SQLSTATE=22001; String Data Right Truncation

2009-02-04T14:08:00.003+02:00

Here is one of those basic IBM DB2 errors that can be thrown at you. From the name, one can easily determine what the cause of the error is. Take a look at the following error:[IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001So what is up with this error? If you have any programming background, the error message is very easy to decipher, which is God send for an IBM product

The Wonderful World Of FTP

2009-02-01T02:51:00.003+02:00

This is one of those posts that completely deal with something other than the general theme of this blog.As I write this post, I have been waiting for my FTP client, FileZilla, which by the way is a wonderful free FTP client, to delete an installation of a web application I recently uploaded to my web server for testing purposes.The entire size of the web application is around 30 MB, made up of

IBM DB2 Error: SQLSTATE=55019; Table Cannot Be Accessed

2009-01-22T12:59:00.005+02:00

Here is a wondeful error you might encounter throughout your IBM DB2 development experiences. As you probably do NOT already know, IBM DB2 8 does not support the TRUNCATE command, infact, you will get a wonderful syntax error if you attempt to use it.So you browse the Internet and someone recommends that you use the ALTER TABLE command as follows:ALTER TABLE SCHEMA.TABLE ACTIVATE NOT LOGGED

SQL: DELETE, DROP, TRUNCATE

2009-01-18T23:39:00.003+02:00

I was kind of surprised when I was hit with this question from a junior coworker of mine a couple of days ago: "What is the difference between the SQL DELETE, DROP, and TRUNCATE commands?".Besides forming the acronym of my favorite professional wrestling move, DDT, there is quite a difference between the three commands.DELETEThe DELETE command is a logged row deletion operation. What does this

SQL0443N Routine "SYSIBM.SQLTABLES' (specific name "TABLES") has returned an error SQLSTATE with diagnostic text. "SYSIBM:CLI:-805", SQLSTATE=38553

2009-01-15T11:13:00.003+02:00

If you got this error : SQL0443N Routine "SYSIBM.SQLTABLES' (specific name "TABLES") has returned an error SQLSTATE with diagnostic text. "SYSIBM:CLI:-805", SQLSTATE=38553Issue the following commands to solve it:c:\SQLLIB\bnd>DB2 connect to dbnamec:\SQLLIB\bnd>DB2 bind @db2ubind.lst blocking all grant publicc:\SQLLIB\bnd>DB2 bind @db2cli.lst blocking all grant publicc:\SQLLIB\bnd>DB2 bind

A Look Inside Xcelsius' Model Layer

2009-01-04T23:57:00.003+02:00

When introducing Xcelsius to a prominent client a couple of weeks ago, I was hit with a question from them that I realized was of some confusion to most people being introduced to Xcelsius.Xcelsius is marketed as a data visualization tool that allows developers to create interactive and eye catching dashboards without the need to learn or understand a programming knowledge. I think that this is a

Microsoft ODBC For Oracle Driver Connectivity Problems

2009-01-03T20:24:00.013+02:00

Well it has been a long time since any new posts were posted here on this wonderful blog. It is not because I have run out of problems to write about, far from it. It is because I have not had enough time to write because of the so many problems.Anyway, what more wonderful of a topic to write about than that of the connectivity problems associated with Microsoft's ODBC drivers for Oracle?.NET

Error SQLSTATE=42727 When connecting DB2 database as a BOXIR3 Repository

2008-12-23T14:49:00.003+02:00

If you are using DB2 as a repository for Business Objects XI R3 (I think that applies also to XI R2 but not tested yet) you may encounter an SQLSTATE=427427. To solve this issue create a database on DB2 and set its "Buffer Pool" to 32k. And then create a "Table Space" and set its type to "User Temporary".

Business Objects XI Release 3 (BOXIR3) linking to reports through URL

2008-11-14T14:39:00.005+02:00

Okey, it seems that Business Objects changed the URL that links directly to the reports in Release 3 and the reason is ... I have no idea. Anyway here is the comparison between linking to reports in BOXIR2 and BOXIR3BOXIR2 : http://BOSERVER:PORT/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?iDocID=reportIDBOXIR3: http://BOSERVER:PORT/OpenDocument/opendoc/openDocument.jsp?

Xcelsius and White Space Characters

2008-10-27T20:18:00.006+02:00

As you begin to familiarize yourself with Xcelsius, not only will you being to appreciate it for its features but also for its irritating and time consuming bugs.Xcelsius has a control called a Combo Box. A Combo Box simply takes a list of values as a parameter and displays it a nice drop down list that the user can select.Assuming you have the following list of values saved in a Microsoft Excel

Time Stamp Incorrect In BusinessObjects Auditing Database

2008-10-22T14:54:00.003+02:00

Developers that are just getting started with BusinessObjects, or experienced developers that are not highly familiar with the internals of BusinessObjects, might be surprised when they view the BusinessObjects Auditing Database and find that it is incorrectly saving the time an event took place.In actuality though, it is not. BusinessObjects, by design, saves the time stamp of an event in

An error has occurred: Could not initialize Report Engine server. (Error: RWI 00226)

2008-10-14T13:12:00.004+02:00

Well this is a common error that can occur during using the so called Business Objects XI R2 when we try to create a Web Intelligence Report.The reason of this error is that the Web Intelligence Report Server is not running.To run the server go to the Cenral Configuration Management and Start it the the Web Intelligence Report Server.If its already running then go to the Central Management

Oracle Error: ORA-06401: NETCMN: Invalid Driver Designator

2008-10-09T12:48:00.003+02:00

As a BI Developer, I have the fortunate pleasure of working with numerous database engines such as Microsoft SQL Server, Oracle, IBM DB2, etc.Here is the catch though; I also have the privilege of running into every possible error produced by each and every single one of those database engines. Trust me when I say there are times I wish I can walk into Oracle headquarters and spit on their lead

Happy Eid 2008

2008-09-29T18:11:00.002+02:00

To all our Muslim readers, we wish you all a very blessing and enjoyable Eid.Mostafa and myself will be taking a little break for the duration of Eid so do not expect a lot of posts, if any, from either of us for the next week or so.

InfoView's Lack of Web Standards

2008-09-28T16:01:00.005+02:00

Ever wonder why InfoView is recommended to be accessed via Microsoft Internet Explorer? Why it looks like a drunken man when he is walking down the street when accessed via Mozilla Firefox, or worse yet, Apple Safari or Opera?For anyone that knows anything about anything that is web design, the simple answer is web standards. In short, the HTML pages that make up InfoView do not adhere to modern

Dealing with Bad Customers

2008-09-25T19:06:00.005+02:00

One of the biggest nightmares you could possibly face as a developer is one where you have to deal with bad customers. And I don't mean bad customers that do not know what they want, I mean customers that are just plain dumb, ones that expect everything to work the way they want to without understanding certain limitations a platform has. I know what your thinking; it is our job to overcome those

Linking To Web Intelligence Reports

2008-09-23T11:12:00.006+02:00

InfoView is not the only option to access your Web Intelligence reports. You can create your own portal with Adobe Flash, Xcelsius (which is a very powerful tool), or any other way you want and link them to a Web Intelligence report in 7 simple steps:Login to the Central Management Console with an administrator accountGo to Organize --> FoldersSelect the folder where the Web Intelligence report

Limiting User Sessions in InfoView: Part 1

2008-09-22T14:17:00.002+02:00

For those of you that are not familiar with BusinessObjects Enterprise’s license types, here is a quick shocker: there is no way to limit the number of user sessions throughout BusinessObjects Enterprise! What does that mean? To find the answer, we need to quickly summarize the license types available.To license BusinessObjects Enterprise, there are two types of licenses available for purchase, a

Embedding a Flash Video in an InfoView Corporate Dashboard

2008-09-20T19:12:00.005+02:00

A really interesting way to capture a user's attention is to create an attractive Flash Video and embed it in a Corporate Dashboard. The graphs and charts that come out of the box with BusinessObjects Enterprise are not that exciting enough to grab the user's attention.Embedding a Flash Video in a Corporate Dashboard is actually a 2 step process. First, you need to actually create the Flash Video

Logging InfoView Users' IP Address

2008-09-18T11:28:00.003+02:00

Recently, we were approached by our Department Manager with what seemed to be a simple request; he wanted to log the IP Address of every user that accessed InfoView.Our initial reaction was that it was simple enough; BusinessObjects Enterprise supposedly logs the IP Address of every user that accesses InfoView right? Wrong! As it turns out, BusinessObjects Enterprise logs the IP Address of the

Welcome To Problexi

2008-09-17T23:06:00.000+02:00

Welcome to Problexi, a blog offering highlights into the day to day activities of developing Business Intelligence solutions using some of the industries top development tools and platforms.Mostafa Khalil, the other contributor for this blog, and myself are currently employed by one of the top Business Intelligence development houses in Egypt and arguably the Middle East.On this blog, we hope to