Report in Excel 2007 returns an error accessing Sybase IQ

Technote (troubleshooting)


Problem(Abstract)

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)

Symptom

Report output format: Excel 2007 in 8.3 and 8.4

(a) Opened in Excel 2007: various errors:

GERMAN
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
/xl/worksheets/Sheet1.xml-Part

ENGLISH
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:
GERMAN
Der Konverter konnte die Datei nicht öffnen.

ENGLISH
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.



Cause

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

Environment

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

Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos 8 Business Intelligence
Report Studio

Software version:

8.3, 8.4, 8.4.1

Operating system(s):

Windows

Reference #:

1454653

Modified date:

2010-11-16

Translate my page

Machine Translation

Content navigation