続・SP1が原因！？ディスカッションリストで「予期しないエラー」

ウチの環境では発生しているのに、他の方の環境では発生しない…という表題の障害。とりあえず、ウチのバージョンは12.0.0.6303でした。

いままで、「問題なく動作している」とコメントを頂いたバージョンは、12.0.0.6318 と 12.0.0.6219 です。
ウチのバージョンの方が古いのが、気になりますね…。

エラーの詳細については、SEさんが調査してくださいました。

開発環境でも再現されています。直接のエラー内容は以下になります。発行機能を使うことにより、ディスカッション掲示板のアイテム参照時に以下SQLを実行するのですが、このレコードが返らないためエラーとなっている模様です。

SELECT TOP 2147483648
t1.[Type] AS c0,
t2.[tp_ID] AS c5c7,
UserData.[ntext2],
UserData.[datetime1],
UserData.[tp_ItemOrder],
t1.[TimeLastModified] AS c15,
UserData.[ntext7],
UserData.[tp_Created],
UserData.[tp_ModerationStatus],
UserData.[nvarchar1],
t3.[nvarchar1] AS c11c6,
UserData.[tp_WorkflowInstanceID],
t1.[Id] AS c3,
t3.[tp_Created] AS c11c10,
UserData.[ntext1],
t1.[MetaInfo] AS c2,
UserData.[tp_Modified],
t2.[nvarchar5] AS c5c9,
UserData.[tp_UIVersion],
UserData.[nvarchar3],
UserData.[ntext6],
t4.[nvarchar1] AS c18,
UserData.[tp_ID],
UserData.[tp_CopySource],
t2.[tp_Created] AS c5c10,
t3.[nvarchar5] AS c11c9,
t1.[TimeCreated] AS c13,
UserData.[tp_InstanceID],
UserData.[tp_GUID],
UserData.[ntext3],
UserData.[tp_ThreadIndex],
UserData.[nvarchar5],
CASE
WHEN DATALENGTH(t1.DirName) = 0
THEN t1.LeafName WHEN DATALENGTH(t1.LeafName) = 0
THEN t1.DirName
ELSE t1.DirName + N’/’ + t1.LeafName
END AS c1,
UserData.[tp_Author],
t2.[nvarchar4] AS c5c8,
UserData.[tp_Editor],
t3.[nvarchar4] AS c11c8,
UserData.[tp_UIVersionString],
t1.[LeafName] AS c12,
t4.[nvarchar5] AS c17,
UserData.[tp_ContentType],
UserData.[nvarchar2],
UserData.[ntext5],
UserData.[int1],
t1.[ItemChildCount] AS c20,
UserData.[tp_ContentTypeId],
t3.[tp_ID] AS c11c7,
UserData.[tp_WorkflowVersion],
t1.[ProgId] AS c16,
UserData.[tp_Version],
t1.[ScopeId] AS c4,
UserData.[tp_IsCurrentVersion],
UserData.[nvarchar4],
UserData.[tp_HasCopyDestinations],
UserData.[tp_Level],
t2.[nvarchar1] AS c5c6,
UserData.[ntext4],
UserData.[tp_HasAttachment],
t1.[DirName] AS c14,
t3.[nvarchar6] AS c11c19
FROM UserData LEFT OUTER LOOP JOIN Docs AS t1
WITH (
NOLOCK
)
ON (
1 = 1
AND UserData.[tp_RowOrdinal] = 0
AND t1.SiteId = UserData.tp_SiteId
AND t1.SiteId = ‘fa548ec6-c7dc-4181-8eb4-7f5dd27c0cad’
AND t1.DirName = UserData.tp_DirName
AND t1.LeafName = UserData.tp_LeafName
AND t1.Level = UserData.tp_Level
AND t1.IsCurrentVersion = 1
AND ( 1 = 1 )
)
LEFT OUTER JOIN AllUserData AS t2
WITH(
NOLOCK, INDEX=AllUserData_PK
)
ON (
UserData.[tp_Author]=t2.[tp_ID]
AND UserData.[tp_RowOrdinal] = 0
AND t2.[tp_RowOrdinal] = 0
AND ( ( t2.tp_IsCurrent = 1 ) )
AND t2.[tp_CalculatedVersion] = 0
AND t2.[tp_DeleteTransactionId] = 0x
AND t2.tp_ListId = ‘6fb5d0a3-aa53-47db-b4d2-d8c930d5691c’
AND UserData.tp_ListId = ‘882211a6-2c18-4363-97be-f370cf1a60a2′
)
LEFT OUTER JOIN AllUserData AS t3
WITH(
NOLOCK, INDEX=AllUserData_PK
)
ON (
UserData.[tp_Editor]=t3.[tp_ID]
AND UserData.[tp_RowOrdinal] = 0
AND t3.[tp_RowOrdinal] = 0
AND ( (t3.tp_IsCurrent = 1) )
AND t3.[tp_CalculatedVersion] = 0
AND t3.[tp_DeleteTransactionId] = 0x
AND t3.tp_ListId = ‘6fb5d0a3-aa53-47db-b4d2-d8c930d5691c’
AND UserData.tp_ListId = ‘882211a6-2c18-4363-97be-f370cf1a60a2′
)
LEFT OUTER JOIN AllUserData AS t4
WITH(
NOLOCK, INDEX=AllUserData_PK
)
ON (
UserData.[int1]=t4.[tp_ID]
AND UserData.[tp_RowOrdinal] = 0
AND t4.[tp_RowOrdinal] = 0
AND ( (t4.tp_IsCurrent = 1) )
AND t4.[tp_CalculatedVersion] = 0
AND t4.[tp_DeleteTransactionId] = 0x
AND t4.tp_ListId = ‘882211a6-2c18-4363-97be-f370cf1a60a2′
AND UserData.tp_ListId = ‘882211a6-2c18-4363-97be-f370cf1a60a2′
)
WHERE
UserData.tp_ListID=’882211a6-2c18-4363-97be-f370cf1a60a2′
AND ( ( UserData.tp_IsCurrent = 1) )
AND UserData.tp_SiteId=’fa548ec6-c7dc-4181-8eb4-7f5dd27c0cad’
AND (
UserData.tp_DirName=’project/sweb/Lists/testmogemoge’
OR UserData.tp_DirName LIKE ‘project/sweb/Lists/testmogemoge’+N’/%’
)
AND UserData.tp_RowOrdinal=0
AND (
t1.SiteId=’fa548ec6-c7dc-4181-8eb4-7f5dd27c0cad’
AND (
t1.DirName=’project/sweb/Lists/testmogemoge’
OR t1.DirName LIKE ‘project/sweb/Lists/testmogemoge’+N’/%’
)
AND t1.Type=0
)
ORDER BY UserData.[tp_ID] Asc OPTION (FORCE ORDER)

続きます。

SP1が原因！？ディスカッションリストで「予期しないエラー」
SharaPoint Server 2007 のディスカッションリスト