Missing parameter in db2iseries.prm file

In BusinessObjects Enterprise XI 3.0 I ran into what seems like a bug. I am talking specifically about using Designer in combination with an AS/400. After having migrated content from a 6.5 environment I had problems with viewing column or table values of newly added tables. After some investigation it seemed to happen only to libraries, tables and columns with characters like @ and #.

I inquired with SAP Business Objects support and they came back with a solution, adding

<parameter name="IDENTIFIER_DELIMITER">&quot;</parameter>

to the first (configuration) part of the db2iseries.prm file in \Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\db2\.

A few weeks ago I upgraded a client from R2 to 3.1. They too have universes based on AS/400 libraries and they too were experiencing the same issue. Apparently the missing parameter doesn’t classify as a bug or perhaps didn’t make its way into a Service Pack of Fix Pack, who knows? I thought I’d type it up, just in case someone else runs into the same issue.

Comments

• Find It

• About

  In 1999, although trained as an economist and marketeer, I started working with an application called Crystal Reports (I don't even remember the version). I realised then that what I wanted to be was a, even though I don't think the term was already coined back then, Business Intelligence specialist.

  Over the years my training and experience has amassed and expanded into various fields of expertise and technologies. I am currently working as a BI consultant and trainer for IIPS, ACN, Intenzz with a focus on SAP Business Objects, IBM Cognos and Microsoft SQL Server technology.

  I am particularly interested in the technical aspects of Business Intelligence, i.e. how to implement and deliver a well performing BI solution, and not so much how to get it right from a business perspective.

  This is a personal weblog, and the opinions expressed here are not those of my employer.

• Twitter

  @hansdezwart I'm not going to be there. # 2012/02/03

  @xjhacking Why stuff like that never happens to me? :'( # 2012/02/03

  Traffic is as usual this morning. Crazy. http://t.co/KWy0cVO0 # 2012/02/03

  It's probably going to take a few trains before I can get on and go home... #waytoomanypeople http://t.co/h0lL828n # 2012/02/01

  Ridiculous! http://t.co/gAKnBBkF # 2012/01/30

• Recently Written

  • A couple of remarks with regard to SAP BusinessObjects (Advanced) Analysis for Microsoft Excel
  • Welcome back ForceMerge() AKA MultiCube()!
  • SQL Server 2008 R2 is RTM
  • Data Integrator part of the new SAP BusinessObjects certification programme after all
  • Business Objects Certified Professional certification soon to be retired

• Categories

  • ABDOP
    • Business Intelligence
  • Amusing
  • Aside
  • Current events
  • Design
  • Food and drink
    • Wine
  • Gadgets
  • Games
  • Hardware
  • Health
  • Humour
  • Life
  • Linguistics
  • Music
  • Photography
  • Software
  • Spanish
  • Sports
  • Technology
  • Travel
  • TV and film
  • Uncategorized
  • Virtualization
  • Webdev

• Monthly Archives

  • November 2010
  • April 2010
  • March 2010
  • February 2010
  • November 2009
  • October 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009
  • February 2009
  • January 2009
  • November 2008
  • October 2008
  • September 2008
  • August 2008
  • July 2008
  • June 2008
  • May 2008
  • March 2008
  • February 2008
  • October 2007
  • September 2007
  • August 2007
  • July 2007
  • June 2007
  • March 2007
  • February 2007
  • January 2007
  • December 2006

Copyright © 2007 Sandor R. de Heij's blog • Using Dropshadow theme by Brian Gardner