Tip of the Day: Database Timeout problem w/ complex filters
If you are using a complex filter in Target Designer, the following error message may appear.
The CMI encountered the following error: 0x80042335 (-2147212491) A database error occurred within the CMI.
What's happening is that the CMI connection to SQL is timing out while SQL is searching the component database. To resolve this, add the HKEY_LOCAL_MACHINE\ SOFTWARE\ Microsoft\ Windows Embedded\ CMI\DBCmdTimeout registry key.
You can then create the DBCmdTimeout DWORD and set the value to 300, which is five minutes. If the error occurs again, or if you are using a more complex filter algorithm, you may need to increase the DBCmdTimeout value.
- Andy
Comments
- Anonymous
August 11, 2008
PingBack from http://www.easycoded.com/tip-of-the-day-database-timeout-problem-w-complex-filters