About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
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.
Was this topic helpful?
Document Information
More support for:
Cognos Business Intelligence
Software version:
8.4.1, 8.4, 8.3
Operating system(s):
Windows
Document number:
411627
Modified date:
08 May 2025
UID
swg21454653
Manage My Notification Subscriptions