IBM Support

Report in Excel 2007 returns an error accessing Sybase IQ

Troubleshooting


Problem

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.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Report Studio","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.4.1;8.4;8.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Analysis Studio","Platform":[{"code":"","label":""}],"Version":"8.4","Edition":"Edition Independent","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Report Studio","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.3;8.4;8.4.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
08 May 2025

UID

swg21454653

Page Feedback