Crystals cache memory

[cjbrown815]

XP Pro// CRXIr2// SQL2005


Is there a way to clean out crystals cache?

-CJ

 

[Turkbear]

Hi,
What problem are you trying to solve?
To clear cached database records, use the refresh button to re-access the data...





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[cjbrown815]

I've published about 20 reports using one as a template and just tweaking the select statement a little. Now Crystal can't find the database, or this table doesnt exist, or it's kicking me out. IT said they think it has something to do with the cache.

-CJ

 

[cjbrown815]

Crystal Reports Error

Failed to retrieve data from the database,
Details: ADO Error Code: 0x
Source: Microsoft SQL Native Client
Description: An inconsistency was detected during an internal operation in the database ‘DB_NAME”. Please contact technical support. Reference number #
SQL State: HY000
Native Error: [Database Vender Code: 5242]


-CJ

 

[cjbrown815]

After that error it want to remove tables from my report because it can't find them.

-CJ

 

[Turkbear]

Hi,
Have you changed datasources ( databases) ?

Do a 'Verify Database' after any change...

Are you using the tempdb?







To Paraphrase:"The Help you get is proportional to the Help you give.."