nmRecordSet Error

Error occured in call to Open

Error Desc: Timeout expired
Error Number: -2147217871
Error Source: Microsoft OLE DB Provider for SQL Server

VarName: strQry
Var Value:SELECT [product].[product_name], CASE WHEN (DATALENGTH(COALESCE([descitemchan].[text], '')) > 0) THEN [descitemchan].[text] ELSE [descitemdef].[text] END AS [longdescription], CASE WHEN (DATALENGTH(COALESCE([descitemchan].[short_desc], '')) > 0) THEN [descitemchan].[short_desc] ELSE [descitemdef].[short_desc] END AS [shortdescription] FROM [product] LEFT JOIN ( SELECT [description].[description_key], [descitem].[short_desc], [descitem].[text], [descItemChannel].[channel_fkey], [descitem].[descitem_key] FROM [description] INNER JOIN [descitem] ON [description].[description_key] = [descitem].[description_key] INNER JOIN [descItemChannel] ON [descitem].[descitem_key] = [descItemChannel].[descitem_fkey] INNER JOIN [Lookup] ON [descitemchannel].[channel_fkey] = [lookup].[lookup_key] AND ([lookup].[field] = 'channel' AND [lookup].[lookup_id] = 'ActExm') WHERE [descitem].[language_key] = 1 ) AS [descitemchan] ON [product].[product_desc] = [descitemchan].[description_key] LEFT JOIN ( SELECT [description].[description_key], [descitem].[short_desc], [descitem].[text], [descitem].[descitem_key] FROM [description] INNER JOIN [descitem] ON [description].[description_key] = [descitem].[description_key] LEFT JOIN [descItemChannel] ON [descitem].[descitem_key] = [descItemChannel].[descitem_fkey] WHERE [descitem].[language_key] = 1 AND ([descitemchannel].[channel_fkey] IS NULL OR [descitemchannel].[channel_fkey] = 0) ) AS [descitemdef] ON [product].[product_desc] = [descitemdef].[description_key] WHERE [product].[product_key] = 49183

VarName: iCursor
Var Value:0

VarName: iLock
Var Value:1

VarName: vOptions
Var Value:0