An unhandled exception of type 'System.ExecutionEngineException' occurred in crdb_adoplus.dll

"Query Engine Error" With Crystal Reports .NET

There are two main reasons this error is thrown when using the PUSH (dataset) method of getting data to a Crystal Report.

1) The schema of the datatable differs from what the report was designed from.  This can be either a different field name, or a missing field, or in a different order.  The easiest way to debug this is to bind the dataset to a datagrid, and compare the resulting schema to the XSD you used to design the report.  Compare data types, column names, etc. 

2) The name of the data table is incorrect.  When you designed your report from an XSD, the report saved the name of the data table(s) that were in your dataset.  When you filled your dataset, you probably forgot to specify the name of the data table.  If you're using a DataAdapter, your command should be:

MyAdapter.Fill(MyDataSet, "MyTableName")

Check your XSD and compare the table name in the XSD with what you are setting in your Fill command.  To check the table name, open your XSD and look at the column headers for your data table.  That's the table name (unless you've manually been tinkering with the XSD, and then you're on your own).

Clear Cache in MS Sql Server

DBCC FREEPROCCACHE

--TO Clear Buffer from Buffer Pool

DBCC DROPCLEANBUFFERS

exec ReindexTables

Memory Details

-Memory Details

============

WITH VAS_Summary

AS ( SELECT Size = VAS_Dump.Size,

Reserved = SUM(CASE ( CONVERT(INT, VAS_Dump.Base) ^ 0 )

WHEN 0 THEN 0

ELSE 1

END),

Free = SUM(CASE ( CONVERT(INT, VAS_Dump.Base) ^ 0 )

WHEN 0 THEN 1

ELSE 0

END)

FROM

(

SELECT CONVERT(VARBINARY, SUM(region_size_in_bytes)) [Size],

region_allocation_base_address [Base]

FROM sys.dm_os_virtual_address_dump

WHERE region_allocation_base_address <> 0x0

GROUP BY region_allocation_base_address

UNION

SELECT CONVERT(VARBINARY, region_size_in_bytes) [Size],

region_allocation_base_address [Base]

FROM sys.dm_os_virtual_address_dump

WHERE region_allocation_base_address = 0x0

) AS VAS_Dump

GROUP BY Size

)

SELECT SUM(CONVERT(BIGINT, Size) * Free) / 1024 AS [Total avail mem, KB],

CAST(MAX(Size) AS BIGINT) / 1024 AS [Max free size, KB]

FROM VAS_Summary

WHERE Free <> 0

TO DISABLE FIBER MODE (LIGHHTWEIGHT POOLING)

--TO DISABLE FIBER MODE (LIGHHTWEIGHT POOLING)

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'lightweight pooling', 0;

GO

RECONFIGURE;

GO

OpenDataSource and OpenRowSet Example

--ACCESS SQL SERVER FROM QUERY ANALYSER

SELECT * FROM OPENDATASOURCE('SQLOLEDB','Data Source=192.168.1.3;User ID=sa;Password=shore').[Save].dbo.Material

--ACCESS MSDB DATABASE

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','D:\pacetam\Dbase\Trn0109.mdb'; 'admin';'',Trn0109)

To enable to access datasource and datarowset

--To enable to access datasource and datarowset using MS Sql Server

=================================================

sp_configure 'show advanced options', 1

RECONFIGURE

sp_configure 'Ad Hoc Distributed Queries', 1

RECONFIGURE

GO

Get Version in MS Sql Server

--Get Version

SELECT SERVERPROPERTY('productversion'),

SERVERPROPERTY ('productlevel'),

SERVERPROPERTY ('edition')

Best Regards,

Ragavachari B

Shrink Database

To shrink database using MS Sql Server

============================

use [db_name]

--Delete data log

Alter database [db_name] set recovery SIMPLE

DBCC SHRINKFILE ( db_name,TRUNCATEONLY)

--To Clear Cached plan

DBCC FREEPROCCACHE

--TO Clear Buffer from Buffer Pool

DBCC DROPCLEANBUFFERS