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