COGNOS 8.3 sqlPrepareWithOptions status=’-9’

We came across this issue very recently when we updated over ODBC driver from 3.51.12 to 3.51.27. The main reason why we upgraded the ODBC was because of the ‘Auto Reconnect’ property that is available. Especially when pulling large DB and network issues, it is advised that we have this new ODBC which can reconnect automatically when the connection is lost due to network problem or large data size.
Anyways, coming back to the error message here; the framework was also throwing this error and I was thinking that it was something to do with the joins. But later found out that, when a filter is added on to the query subject and this filter has ‘=’ to the prompt ([service date] = ?date_prompt?) then SQL bind parameter issue was coming up. So I changes it to ‘IN’ instead and things started working properly.

Even though I made the changes in the framework, the reports were still having issues. I had to changes all the filters in the errors to ‘IN’ from ‘=’ in place where the prompt was considering a ‘numeric’ filter.

I don’t know if this is best solution and the only solution to the problem but temporarily I am able to run the reports. I am pretty sure I did see this issue before for which I had a different solution then.

Second COGNOS Conference Successfully !!!!!!

Successfully made it to the second year of COGNOS conference at Hyatt Residency, Boston. The day was pretty interesting from driving all the way from Westborough to Cambridge which took me one hour and ten minutes with all the traffic and the rain pouring badly.

Started with the Key Note presentation where the concentration was majorly on the new COGNOS iPhone app and the COGNOS integration with SAP. They were also showing COGNOS Express and COGNOS Go Dashboard which were already shown in the previous conference.

The first session I sat was the Report/ Dashboards and Scorecards. There was only one report that really impressed me. All the other stuff that they were demoing where the regular ones.

The second session was the COGNOS Express Manager – Integration of excel sheet with IBM COGNOS. The new feature they showed was the updation of the data from the excel creates immediate effect on the reports that are generated from the excel sheet. The COGNOS Express had some good featuers like the Scorecards (which have interesting features like the charts with default values and calculator, just like a computer app.) and COGNOS Configuration and Log files and ODBC and Users list; are all added to the Xccelator GUI at the Home level. Ifelt it is a Fantastic approach, especially to the install team at my company who can have much faster and easier way to update clients. So the installation and configuration will just a click away.

Third session --- experience of COGNOS USER. Big client with 85 million records who use Teradata. Not the best of presentations but was OK. They seem to be using the cubes rather the live DB due to their humungous data. This session also spoke about how important is it to maintain global standards and documentation, centralization of things.Fourth and the final session – balanced scorecard methodology… I have no clue and I need to ready about it. Case study about Eneco (GATNER) . This was more about Metric Studio.The most funny part was that, in each of the presentation they had the same dashboard and everyone was explaining it in their own way. It actually shows us that how we can interpret one single report into so many ways.

After seeing all these people presenting on the stage… I strongly believe I can give a better presentation of COGNOS .

From query studio to a pdf link from the right click property called Glossary

Apache and IIS as default webserver and not Web Sphere.

The default DB which comes with COGNOS is Informix and Not DB2.

COGNOS 8.3 Query Studio report must update Error

The above image actually shows 2 different errors. The first error asks you to update to the newer package that was published (This usually occurs when the query studio is open and a newer publish has been published during that time period.) During which we usually, log out of query studio and log in again. But here, we could not even do that and when we click on ‘OK’ it took us to the second error ‘Failed to load the pluggable shared library’.
The error that COGNOS is throwing and the actual issue are completely different according to me. The issue here was that, ‘Guarantor Name’ metadata in the development layer had a different spelling than what it was before and so the Presentation layer was not able to retrieve the metadata from the development layer. Once I ran the query subject in the framework to test, it through an error which clearly identified that the development layer did not have the metadata which the query was looking for.
The solution here was that I had to update the development query with the right path for each of the metadata elements in that query subject.

COGNOS 8.3 – sqlpreparewithoptions status = -17 Error

I have seen this issue couple of times on the machine where there are too many users or at places where the DB is massive. My general solution to this issue is to restart COGNOS services every night (setting up a scheduled job) or weekly once. If this does not work then try the alternative solution.
The alternative steps that I do follow are:
1. Go to task manager, look for Derby.exe under the process and end the process.
2. Go to COGNOS/c8/bin and delete all the *.dmp files. (DMP – Are basically memory / error dump files)
3. Increase the memory size in the COGNOS Configuration.
4. Restart COGNOS.

COGNOS 8.3 Report Studio /Package issue Model /Package does not exist Error

The basic nature of this error is that the report that we are trying to open does not have a package assigned / selected and the solution is to the open the report in a report studio and select report package option from the file option. Save it.
I got this error at of the end users machine. Accordingly to my analysis, there are 2 reasons for this error to occur:
1. This report could be pointing to a different package rather than the package from which it was deployed. One more similar issue could be that people could have opened the report and might have cancelled the package loading to check some formatting and may be they saved the report that way before closing.
2. The second issue could be, sometimes (very rarely) we have seen that the package is not created properly by COGNOS itself but in this case when the report does not have a package selected; the error is a little bit different. (Multi processing - framework is been published and some one is trying to create a package at the same time)
Due to lack of time my language is not in its best. 

COGNOS Home in COGNOS Admin page

When this first happened, I was actually on a call with the IBM support going through an older error that we were facing. If you look at the second image you can see that; the more I drill down, the no of pages increases. For a while I was thinking I need to re install everything on the server. But when I tried the same ‘COGNOS Administrator’ from my local machine through a URL, things seemed to be working fine.

So I believe the problem seems to be with the browse and its settings rather than COGNOS. So I upgraded the web browser on the server and things got back to normal. One can also try to delete the cache memory in the browser.

COGNOS 8.3 [the_dispatcher] com.cognos.pogo.performance.PerformanceIndicationHandler Error

I came across this bizarre issue while running an existing report. This particular report used to run fine; but all of a sudden it started throwing this error. I was wondering why ? We never touched the report and the modified date was dated way back last year.
Coming to the point, I tried checking the metadata and other totals / sub totals in the report. We even restarted the cognos service thinking it is something to do with the dispatcher.
But the solution was ……. We had added a some new filters to the metadata and the report was running on older filters. So all we had to do was to rename the filters in the report to the newer ones and things got going smoothly.

The problem with COGNOS is that, it does not point out the exact error message.