Description of Cognos Impromptu error codes. Some error codes have solutions.
100 to 299 Critical errors. These can occur at either compile-time or run time, depending on the nature of the error.
300 to 499 Warnings. These are ignored unless the UseQueryWarnings property is set to 1.
500 or greater Critical run time errors.
100: Cannot execute query. Processing requirements exceed the current Client/Server limits.
101: Data item [%1] could not be found.
102: Data item [%1] is invalid because [%2] could not be found.
103: Using the Governor denied Database Column [%1].
104: This report will result in a 'cross product' query. This User Profile prevents the use of 'cross product' reports.
105: The query for this report contains an 'outer join'. This User Profile prevents the use of 'outer join' queries.
106: This report sorts on the non-indexed columns.
107: This report contains circular [DATASET] references: %1.
108: This report contains a prompt nested within a sub-report: %1.
109: This report uses %1 tables. This exceeds the current Governor restriction of %2 tables for a report.
110: Data item [%1] is invalid because it contains additional invalid Data Items.
111: Invalid SQL query. Use read-only SELECT statements.
112: Prompt uses column %1 of report %2 which doesn't exist.
113: Prompt displays column %1 of report %2 which doesn't exist.
300: This report is expected to use %1 tables.
301: This report is expected to return %1 rows.
302: The expected report preparation time is %1.
303: This report suppresses duplicates.
304: This report will result in a 'cross product' query.
305: This report sorts on the non-indexed columns.
306: The query for this report contains an 'outer join'.
307: This crosstab report contains a query column, %1, that no longer exists.
308: This crosstab report contains a bad reference to %2 in a conditional format.
309: This crosstab report contains a bad reference in %1 to %2.
310: This crosstab report contains a bad reference to %2 in the detail filter.
311: This crosstab report contains a bad reference to %2 in the summary filter.
500: This report exceeded the current Governor Restriction of %1 report preparation time.
501: Database Retrieval Limit reached. Governor restrictions specify a retrieval limit of %1 rows for the current User Profile.
502: Could not open the following [DATASET] report: %1.
An error has occurred during execution of the query.
An error condition has been detected during the execution of the current query.
The content of this message will vary depending on the nature of the problem.
The stored procedure name has to be initialized first.
You've attempted to execute a stored procedure before you've set the procedure name. Use the SetProcedure Method to set the name of the stored procedure.
Parameter number <type> type is not supported.
You've specified an invalid parameter type for a stored procedure parameter.
Syntax error the char descriptor has to be VarChar, Char, or LongVarChar.
You've specified an invalid descriptor for a variable length parameter of a stored procedure. Specify either VarChar[n], Char[n], or LongVarChar[n], where n indicates the maximum size for the variable length parameter. See the SetProcedure Method.
Stored procedure has to be executed first.
You've attempted to obtain the value of an output parameter before you've exected the stored procedure. Use the Execute Method to execute the stored procedure.
The user class password is not correct.
You've specified an invalid user class password. Ensure that the user class password is valid.
Out of memory.
The OLE automation procedure has run out of memory. Try closing some applications and running the automation script again.
Parameter <parm> is invalid.
You've specified an invalid parameter as the input to a method. For example, Impromptu has encountered a Boolean value for a parameter when a string value is expected.
Make sure that you've specified the parameters correctly. Ensure that you also provide a comma to delimit each parameter when omitting values for some parameters.
Catalog is not distributed. Cannot update.
You've tried to use the UpdateCatalog method to obtain the latest changes for a catalog. The UpdateCatalog method is valid only for distributed catalogs, not for personal, shared, or secured catalogs.
Update failed due to internal error. Contact customer support.
CognosScript has encountered a fatal internal error.
Current catalog specifies a master catalog which is not an Impromptu Catalog.
When attempting to update your local copy of a distributed catalog, Impromptu has encountered a problem with the master catalog.
Could not open the master catalog for update.
The UpdateCatalog method could not open the master catalog. Make sure that you have the necessary LAN access, and that the master catalog exists and is intact.
Master catalog is an incompatible version.
During an UpdateCatalog, the master catalog could not be opened because it was created with an earlier version of Impromptu. Contact your database administrator.
Catalog method called when no catalog was open.
You've attempted to call a method that operates on a catalog when no catalog is currently open. Use the OpenCatalog Method to open a catalog before using methods such as ChangeUserClass, ConnectDatabase, CloseCatalog, UpdateCatalog, or AddTable.
No valid selection for this operation.
The GetSelectedText method has not found any valid selected text. Use this error to trap whether an Impromptu user has selected text prior to launching a macro that uses the GetSelectedText method.
This catalog could not be found. <catalogname>
A catalog name specified in a method could not be found. Ensure that the name is specified correctly, and that you have read access to it.
Unable to open this catalog. <catalogname>
A catalog that you've specified in either the OpenCatalog method or or GenerateReport method could not be opened. Ensure that the name is specified correctly, and that you have read access to it.
Table name parameter is empty.
You have not specified a value for theTable from within either the GenerateReport method or the AddTable method.
Specified table was not found.
Within the GenerateReport method or the AddTable method, the specified Table could not be found. Ensure that you've specified the correct name for the table.
Unable to generate default report.
Login or table information is valid, however, the GenerateReport method is unable to generate a default report. Ensure that the template name is specified correctly. Ensure also that the method didn't try to create the report on a full disk, and that the name specified for the report doesn't already exist.
This Template could not be found. <templatename>
The ApplyTemplate method could not locate the specified template. Ensure that you've specified the correct name for the template and that you have the necessary LAN access to it.
Report could not be opened.
The OpenReport method could not locate the specified Impromptu report. Ensure that you've specified the correct name for the report and that you have the necessary LAN access to it.
Current catalog is read-only.
You've attempted to make changes to the current catalog with the UpdateCatalog method. Check that the catalog file (CAT) is not read-only.
Unable to add table <Database><HostDatabase><DBOwner><TableName>.
The AddTable method was unable to add the specified table. Ensure that the database (Impromptu logical database name), HostDatabase (Host database name), DBOwner (host database owner), and TableName are all specified correctly. Ensure also that your connection to the database is active.
Database name is invalid.
The AddTable method has detected an invalid database name. Ensure that the database (Impromptu logical database name) name is specified correctly.
Wrong or insufficient information provided. Could not connect database.
In the ConnectDatabase method, the information provided was not sufficient to connect the database. Ensure that you've provided all of the required parameters (user ID, password).
Login error while connecting the database.
In the ConnectDatabase method, an error other than a security error occurred during an attempt to connect to the database.
Database is already connected.
You've used the ConnectDatabase method when the catalog is already connected to its associated database.
Login error. <errortype>
In the ConnectDatabase method, the user ID and password are specified incorrectly or are not sufficient for the current level of security.
Cannot execute a method.
Impromptu is busy and cannot execute a macro method.
Cannot convert to a snapshot report.
The CreateSnapshot method is unable to save the current report as a snapshot. Ensure that your disk has sufficient space to store a snapshot of the report data.
This report cannot be converted to access the database.
The current report cannot revert to database access from a snapshot. Ensure that the connection to the database is active.
Invalid printer name.
You have specified the name of a printer that does not exist in the FileSetPrinter method. Make sure that the value specified for PrinterName matches exactly (including the case) the device name that's listed in the [Devices] section of your WIN.INI file. In general, this should be the name of the printer as it's displayed in Print Manager, up to but not including the "on <port number>" qualifier.
The printer driver is not installed.
Windows is unable to locate the printer driver for the printer that you've specified in the FileSetPrinter method. Ensure that the printer driver is installed correctly.
Extended device mode is not supported with this driver.
The driver could not get the size of the initialization buffer.
The report cannot be edited.
Multiple errors have occured with Impromptu. Use GetNextQueryError() method to retrieve the error information.
The current report cannot execute because of query errors. Use the GetNextQueryError method to return the error number(s) and description.
User class restriction.The report can not be created.
A user class restriction, such as being prohibited from accessing a specific table or folder, is preventing the current report from executing successfully. Ensure that the restrictions for the current user class do not conflict with the report requirements.
*** Unknown Error Type ***
Impromptu has encountered an unexpected error. Contact Cognos Customer Support.
Impromptu cannot open the required catalog.
The required catalog cannot be open. Ensure you have specified the correct catalog name.
Impromptu could not connect to the database.
Ensure that the correct database has been specified.