Posts Tagged Configuration

PDF Font Errors in Cognos 10

Posted by Scott Andrews in Cognos on December 22, 2011

If you are unable to render Cognos reports as PDFs but they run correctly as HTML, you likely are experiencing a font error.  Check for this error to confirm:

CCLAssertError:0:Fatal: CCL_ASSERT_NAMED(bFoundFont, “[RSPdfOutputText::onDISetText] No font available for the text data”);

Cognos report PDF generation requires that you have:

  1. fonts installed on your Cognos server, and
  2. the Cognos configuration setting for fonts defined properly so those fonts can be found.

To resolve this, you need to go into Cognos Configuration and modify the settings for the Environment > Font Settings > Physical Font Location.  The fonts included with your Cognos 10 installation should be found in your C10/bin/fonts directory.  To see these fonts, make sure your font setting includes “../bin/fonts”.

, ,

No Comments

Oracle Configuration Errors in Cognos 10

Posted by Scott Andrews in Cognos, Oracle on November 14, 2011

If you ever get the following error when attempting to connect Cognos Framework Manager with an Oracle data source, you have an Oracle configuration problem:

QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
DataSource
UDA-SQL-0432 Unable to locate the gateway “cogudaor”

If you have a valid Oracle client installed on your machine (Oracle 9 or up for Cognos 8/10), then check your System Environment variables.  I had a recent experience at a client where both Oracle 8 and Oracle 10 client software were installed on a machine.  Because the ora805\bin reference appeared before the ora10\bin reference in the Path variable, Cognos Framework Manager could not connect to the data source and reported the above error.  Simply by changing the order of those references in the Path variable, the configuration problem was resolved.

,

No Comments