图文档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))