圖文檔2008R3.1回收站問題

shreea

這是objref.log的有關記錄

Wed May 05 11:09:25 2010
---- CPdemObjectRef:uickGetRelationObjects failed at ParseNodeAttribute<0x80004005>
---- CPdemObjectRef:uickGetRelationObjects failed at ParseNodeAttribute<0x80004005>
---- CPdemObjectRef:uickGetRelationObjects failed at ParseNodeAttribute<0x80004005>
---- CPdemDocumentRef::GetCurrentRevision failed at m_master->get_current_revision<0x80004005>

weiyanmin

在圖文檔文檔樹上點擊回收站，報未知的錯誤，暫時的解決的辦法，到圖文檔服務器上，進SqlServer 企業管理器，選擇數據庫pdem，執行下麵的sql語句，
DELETE FROM PDEMTBL_RecyclerDocument
WHERE (documentinrecycler_id NOT IN
          (SELECT obj_id
         FROM PDEMTBL_Document))

weiyanmin

DECLARE @id int DECLARE abc CURSOR FOR SELECT [docmasterforrevs_id]
                                                  FROM PDEMTBL_DocMasterComposition OPEN
                                                         abc FETCH next
FROM abc WHILE @@fetch_status = 0 BEGIN FETCH
FROM abc
INTO @id PRINT '@id = ' PRINT @id DECLARE @CountID int
SET @CountID =
          (SELECT COUNT(*)
         FROM PDEMTBL_DocMasterComposition
         WHERE docmasterforrevs_id = @id AND current_revision = 1);
      PRINT '@CountID= ' PRINT @CountID IF (@CountID = 0)
      BEGIN DECLARE @Maxdocrevofmaster_id int
SET @Maxdocrevofmaster_id =
          (SELECT MAX(docrevofmaster_id)
         FROM PDEMTBL_DocMasterComposition
         WHERE docmasterforrevs_id = @id AND current_revision = 0);
      PRINT 'teeeeeeeeeeeeeeeeeee'
          UPDATE PDEMTBL_DocMasterComposition
        SET  current_revision = 1
        WHERE docmasterforrevs_id = @id AND current_revision = 0 AND
              docrevofmaster_id = @Maxdocrevofmaster_id END END CLOSE abc DEALLOCATE
               abc

weiyanmin

在圖文檔文檔樹上點擊回收站，報未知的錯誤，暫時的解決的辦法，到圖文檔服務器上，進SqlServer 企業管理器，選擇數據庫pdem，執行下麵的sql語句，
DELETE FROM PDEMTBL_Document
WHERE (OBJ_ID NOT IN
          (SELECT docmasterforrevs_id
         FROM PDEMTBL_DocMasterComposition)) AND (delete_flag = 1)

DELETE FROM PDEMTBL_CappDocument
WHERE (OBJ_ID NOT IN
          (SELECT docmasterforrevs_id
         FROM PDEMTBL_DocMasterComposition)) AND (delete_flag = 1)

DELETE FROM PDEMTBL_3DDocument
WHERE (OBJ_ID NOT IN
          (SELECT docmasterforrevs_id
         FROM PDEMTBL_DocMasterComposition)) AND (delete_flag = 1)

DELETE FROM PDEMTBL_RecyclerDocument
WHERE (documentinrecycler_id NOT IN
          (SELECT obj_id
        FROM PDEMTBL_Document))