Report in Excel 2007 returns an error accessing Sybase IQ

Technote (troubleshooting)


Report output in MS-Excel 2007 format returns errors accessing Sybase IQ data source (ODBC connection) or does not display specific characters properly (i.e. output format Execl 2000 or PDF)


Report output format: Excel 2007 in 8.3 and 8.4

(a) Opened in Excel 2007: various errors:

MS-Excel 2007 Fehlermeldung:
Von Excel wurde unlesbarer Inhalt in '....(1).xlsx' gefunden. Möchten
Sie den Inhalt dieser Arbeitsmappe wiederherstellen? Wenn Sie der Quelle
dieser Arbeitsmappe vertrauen, klicken Sie auf 'Ja'.

Reparaturen in - '....(1).xlsx'
Die Datei konnte von Excel geöffnet werden, indem der nicht lesbare
Inhalt repariert oder entfernt wurde.
Entfernter Teil: /xl/sharedStrings.xml-Part mit XML-Fehler.
(Zeichenfolge) Ungültiges xml-Zeichen. Zeile 1, Spalte 1145.
Entfernte Datensätze: Zellinformation von

MS-Excel 2008 error mesage:
Excel found unreadyble content in <filename>. Do you want to recover the contents of this workbook. If you trust the source of the workbook, click Yes.

Excel is able to open the file after repairing or removing unreadable content.
Removed content: /xl/sharedStrings.xml-Part with error (characters/ string) Invalid xml-character Line 1 column 1145
Removed records: cell information from /xl/worksheets/Sheet1.xml-Part

(b) Opened in Excel 2003 incl. compatibility pack:
Der Konverter konnte die Datei nicht öffnen.

The converter could not open file.

Report output format: Excel 2000 or PDF (8.3, 8.4) or Excel 2007 (generated with 8.4.1):

No errors, but instead of the specific character (here Euro or Trade Mark symbol) a square box is displayed.


Specific characters cause the issue. Particular with the Euro and Trade Mark symbol the error could be replicated.


IBM Cognos 8 BI running on Windows.

ODBC connection to Sybase IQ v12.7

Sybase IQ character set: iso_1; DefaultCollation: ISO1LATIN1; Language: us_english

Resolving the problem

In the Sybase IQ ODBC configuration specify the character set defined for the Sybase IQ data base.

In this case it must be set to: iso_1

Cross Reference information
Segment Product Component Platform Version Edition
Business Analytics Cognos 8 Business Intelligence Analysis Studio 8.4 Edition Independent
Business Analytics Cognos Business Intelligence Report Studio Windows 8.3, 8.4, 8.4.1 Edition Independent

Document information

More support for:

Cognos 8 Business Intelligence
Report Studio

Software version:

8.3, 8.4, 8.4.1

Operating system(s):


Reference #:


Modified date:


Translate my page

Content navigation