Impromptu Errors

[donafran]

Please reference the complete error text between <<<<< and >>>> lines below:

We are running Impromptu Client v 7.1.339.0 on a WIN 2003 server.
This report has been in production for over 2 years under WIN NT on Impromptu v6.0.613. It was upgraded, along with several other reports about in October 2003.
I have been working today since 7:00am.
I opened THIS report, saved it as another name in a different location. Closed the report, Closed Impromptu. Opened the new copy of the report, changed the filter criteria and ran the new report.
Closed the report, CLOSED Impromptu, Opened the original report again to check the original filter criteria. Closed the report again, Closed Impromptu.
Opened a completely different report, that ran fine.
Closed the report, closed Impromptu. Tried to open the original report, got the attached error messages.
Closed Impromptu, opened several other reports -- All ran fine. Tried to open this report again, same error. Closed the report, closed Impromptu
Re-booted the Server.
Opened several other reports, again FINE. Open this report, SAME ERRORS !
Copied this report using WINDOWS EXPLORER copy/paste command.
Tried to open the copy, tried to open the original, tried to open the first copy I made this morning...ALL GET THIS ERROR !!
Other reports still run fine.

We have ONLY ONE Impromptu catalog -- ALL reports use this ONE catalog.

Please help !! Need to adjust report to re-save as .IQD for Transformer input.

Why would this suddenly happen ????

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
ERTRAP-F-OS_SEG_VIOLATION,A segmentation violation has occurred.
Error number -239:

DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'.
DMS-E-RDS_OLEDB, The OLE DB provider has returned the following error:
HRESULT: DB_E_NOCOMMAND
Microsoft OLE DB Provider for SQL Server
Command text was not set for the command object.
ERTRAP-F-OS_SEG_VIOLATION, A segmentation violation has occurred.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

 

[puppyquestion1]

donafran, try this. Your error seems similiar to one in which Cognos references this solution:

To resolve this issue, create a new database definition with the same name as used for the catalog in Impromptu 6.0 and 7.0. This will allow the reports that issued errors to run again. To do this, follow these steps:

1. Close the catalog
2. Go to Catalog > Database. The Database Definition Manager dialog opens.
3. Select the Microsoft SQL Server OLE-DB gateway and click New Database?4. Give the database the same logical database name as the upgraded catalog.
5. In Definition parameters, enter the following:
Provider: SQLOLEDB
Data source: <Servername>
Provider string: Initial Catalog=<database name>
6. Click Test to ensure that the connection works.
7. Restart Impromptu.