10.2 upgrade issues

problems came as a result of a 10.2 to 10.2.1 upgrade

•  in FM, Trim command does not work.  UDA-SQL-0043 The underlying database detected an error during processing the SQL request.

[IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0204 - TRIM_BOTH_SPACES in *LIBL type *N not found.

•  in FM,Cast from integer to Date does not work.  UDA-SQL-0107 A general exception has occurred during the operation "prepare".[IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0461 - CAST from INTEGER to DATE not supported.RSV-SRV-0042
• If the reports has java scripts, you must need to check them all, if working fine after upgrade. 
• If you are looking at performance gain, use DQM while republishing the package. DQM is strict when it comes to syntax and rules as compared to CQM. So you need to check if all reports behave correctly after published to work with DQM mode.
• There is a horrible bug in 10.2.1 that causes reports using packages with more than 1 data source to prompt the user for a connection to be used, even if only only one connection has been defined.
•  we cannot keep the system stable. Reports are queuing so badly that they finally halt the system. There have also been some changes to default behavior has been causing reports that require limited local processing to explicitly have that set when they didn't need to before.
• 8.4 to 10.2-->When I export the report to Excel, the formatting is horrible. In 8.4 the Excel formatted reports looked awesome... so there might be a bit of rework.
• 8.4 to 10.2-->We have both relational and dimensional data items in our reports. When you drill from the source report to the target report, you get prompted to pick which data source you want to use. Then you get re-prompted to enter in your report parameters and finally you get prompted for the other data source. Once you go through all that, the report executes. I opened up a PMR with IBM support and they determined that there's a defect in the software and I either apply a hotfix (which I chose not to do) or take the relational data items out of the dimensional reports and take the dimensional data items out of the relational reports (the option I chose).
• 8.4 to 10.2-->Common errors faced during bursting are as follows:
  1. Lot of BIBUS processes are seen in the task manager of each dispatcher and Cognos seems to hung after some time
  1. DPR-ERR-2072 Unable to Load Balance a Request With Absolute Affinity
• When we tested reports we found a issue with closingPeriod() function. There was a simple report based on a power cube with crosstab (e.g. product lines in rows and regions in columns). Then there was expression like this (last six months from a time dimension): 
  lastPeriods(6,closingPeriod([great_outdoor_sales_en].[Years].[Years].[Month])) used as a slicer. It works fine in C 10.1.1, but in C 10.2 the report shows empty crosstab. We investigated it and found a fix. We added second parameter for the closingPeriod function like this (the root member from the time dimension) lastPeriods(6,closingPeriod([great_outdoor_sales_en].[Years].[Years].[Month],[Years])) and the report works.
• One good reason is that DMR with version 10.1.x is not to be used due to unreliable results when using a factless query over common dimensions. Cognos in that case may use a join path thrugh other facts then the one you are reporting over in your starschema grouping. That by itself is a serious data issue. It has been recognized as a bug in 10.1.x but only fixed in 10.2 so far. The fact that there is no hotfix for 10.1.x is serieus I think as it is data related.

Borders with line width less than 1pt don't appear at all in Chrome browser (tested v32,v33). There is now an APAR for this:

APAR Nummer: PI14810 - BORDERS MISSING WITH CHROME IN 
V 10.2.1.2

•  Conditional rendering not working on saved outputs. We have parts of our reports that display only in HTML (like buttons) that we don't display in PDF. However this doesn't work after updating to 10.2.1.2. There is an APAR, and in fact, we've just been given an interim fix to test:

APAR: PI07186 
IF: IF1070 (10.2.5002.1070)

• Our third bug only came to light because of HTML alignment changes. Previously we had horizontally aligned a bar chart and line chart so that they looked like one chart. The reason being, we could not get nested labels to work on a combination chart with 2 y-axis. We wanted to show for each bar a month, and underneath that, grouping by years. So a simple trend chart. However, updating to 10.2.1.2 stopped our html aligment from working any more, so we revisited using a dual-y-axis chart.

There is a setting for nested labels (it works perfectly well on all other charts we've tried), and the IBM documentation states that nested labels is a feature of the charts, but in Cognos 10 (all versions) it will concatenate your labels, even if you select 'nested labels'. 
After bringing this up with IBM, we have finally been told it's apparently not a bug, but should never have been there in the first place. So the only fix they are going to provide it to update the documentation. For our team this is the biggest bug, but as it wasn't working in 10.1 either, probably won't be relevant to you.

• Has anyone successfully upgraded Portal 10.2 to 10.2.1?
  I've tried 3 times on a backed up Portal install and each time it fails and the Portal is broken. Other people in my organisation are having the same issue.
  After the "upgrade" I have two copies of my portal folders ie;
  
  content
  content_10.2
  db
  db_10.2
  index
  index_10.2
  logs
  temp
  
  I can access the Portal but when I try to sign in it asks me to create a new initial administrator account. If I attempt to do this (even though it was previously set up) it hangs for a while and then says there was a problem.
  I've tried to list and create a users through the command line tools but it says its looking for a file called config-store-connection.json which is not present.
  Under the hood it look like Postgres is not starting up when the service is started.

======================================================================
packages with more than 1 data source to prompt the user for a connection to be used, even if only only one connection has been defined:
IBM have recognised this as a defect, but there is a workaround you can use until they issue a fix for it.

Log in as an Administrator, and launch the Admin console
Go to the Configuration tab and select Dispatchers and Services
Press the "Set Properties - Configuration" button in the top right corner of the page
Go to the Settings tab
Find the "Advanced Settings" entry and press the Edit link alongside it
Enter a new parameter called RSVP.CONTENTMANAGER.USECACHE with a value of cmcs (note, the value must be in lower case)

After pressing OK and OK, wait for a few minutes and the issue should stop happening.

**Update**
We have been doing some more troubleshooting with IBM and BlueNet Tech today and we found out if we increase the "Maximum memory for Tomcat in MB" in "IBM Cognos Configuration" we are able to work with more users. We currently have it set to 4096; server is a VM with 12GB available to it. We have also noticed that the java.exe gets stuck at 2,497,600K when the reports stop displaying for users.

**Update 2**
10.2.1 has huge problem with cleaning the cache in the BIBus when reports are ran with mulpite data connection.
I would not recommend anyone upgrade to 10.2.1 until this issue has a fix.
http://www.cognoise.com/index.php/topic,21917.0.html

PMR 04322,442,000
http://www-01.ibm.com/support/docview.wss?crawler=1&uid=swg1PM91815

IBM has told us that this is not a workaround. It is more like a small fix until they have a fix. It works sometimes if the report doesn't lock up the BIBUS.exe.