{"id":8970,"date":"2026-08-21T00:26:39","date_gmt":"2026-08-20T16:26:39","guid":{"rendered":"http:\/\/pipingpig.com\/index.php\/2026\/08\/21\/%e6%97%a0%e6%b3%95%e4%b8%baworkshare%e9%a1%b9%e7%9b%ae%e8%ae%be%e7%bd%aeinterference-checking-service\/"},"modified":"2026-08-21T00:27:47","modified_gmt":"2026-08-20T16:27:47","slug":"wufaweiworksharexiangmushezhiinterference-checking-service","status":"publish","type":"post","link":"https:\/\/www.pipingpig.com\/index.php\/2026\/08\/21\/wufaweiworksharexiangmushezhiinterference-checking-service\/","title":{"rendered":"\u65e0\u6cd5\u4e3aWorkshare\u9879\u76ee\u8bbe\u7f6eInterference Checking Service"},"content":{"rendered":"

\u6700\u8fd1\u5728\u9879\u76ee\u652f\u6301\u8fc7\u7a0b\u4e2d\u9047\u5230\u4e00\u4e2a\u95ee\u9898\uff0c\u5f53\u5728Project Management\u91cc\u8bbe\u7f6eInterference Checking Service\u65f6\u51fa\u73b0<\/span>Object variable or with block variable not set\u7684\u9519\u8bef\u63d0\u793a\uff0c\u5982\u4e0b\u56fe\uff1a<\/span><\/p>\n

<\/p>\n

\n

\u95ee\u9898\u5206\u6790\uff1a<\/p>\n

    \n
  1. \n

    \u8fd9\u662f\u4e00\u4e2aGlobal\u00a0Workshare\u9879\u76ee<\/p>\n<\/li>\n

  2. \n

    \u8fd1\u671f\u7531\u4e8eSatellite\u7ad9\u70b9\u66f4\u6362\u670d\u52a1\u5668\u91cd\u65b0\u642d\u5efa\u4e86GWC<\/p>\n<\/li>\n

  3. \n

    \u91cd\u65b0\u642d\u5efa\u65f6\u4f7f\u7528\u7684Satellite\u7ad9\u70b9\u7684Model\u5907\u4efd\uff0c\u800c\u4e0d\u662fHost\u7aef\u7684\u5907\u4efd<\/p>\n<\/li>\n

  4. \n

    \u5728Errorlog\u4e2d\u53d1\u73b0Stored Procedure \u201cITFCHKIFCPilotStatus\u201d did not return any row for oid\u7684\u9519\u8bef\u63d0\u793a<\/span><\/span><\/p>\n<\/li>\n<\/ol>\n

    \u95ee\u9898\u539f\u56e0\uff1a<\/p>\n

    \u5bf9\u4e8eGlobal\u00a0<\/span>Workshare<\/span>\u9879\u76ee\uff0cMDB\u4e2dITFCHKIFCPilotStatus\u8868\u7684\u6570\u636e\u53ea\u5b58\u50a8\u5728Host\uff0c\u5e76\u4e0d\u4f1a\u590d\u5236\u5230Satellite\u7ad9<\/span>\u70b9<\/span>\uff0c\u5f53Host\u7aef\u4f7f\u7528Satellite\u7684MDB\u5907\u4efd\u91cd\u65b0\u642d\u5efa\u73af\u5883\u65f6\uff0cMDB\u4e2d\u6b64\u8868\u7684\u6570\u636e\u662f\u7f3a\u5931\u7684\uff0c\u5c31\u4f1a\u63d0\u793a\u6b64\u9519\u8bef<\/span><\/span><\/span><\/p>\n

    <\/span><\/span><\/span><\/p>\n

    \u89e3\u51b3\u529e\u6cd5\uff1a<\/p>\n

    Host\u7aef\u7684Smart3D Admin\u9700\u8981\u5728SQL Server Management Studio\u4e2d\u5bf9MDB<\/span>\u6267\u884c\u4ee5\u4e0bl\u8bed\u53e5<\/span><\/p>\n

    if exists(select * from ITFCHKIFCPilotStatus)\n  BEGIN\n    Raiserror( N'One or more rows exists in ITFCHKIFCPilotStatus table -- so new row is not inserted', 10, 1);\n  END\nELSE\n  DECLARE curBOs  CURSOR FOR\n  SELECT A.ObjectOid FROM dbo.CoreNamedObjects as A\n      JOIN dbo.COREBaseClass B with(nolock) on ((A.ObjectName like 'IfcPilotStat%')\n      and (A.ObjectOid = B.oid))\n  DECLARE @boOid uniqueidentifier\n  DECLARE @coun int\n  SET @coun = 0\n  OPEN  curBOs\n  FETCH NEXT FROM curBOs INTO @boOid\n    WHILE @@FETCH_STATUS = 0\n      BEGIN\n        SET @coun = @coun + 1;\n        FETCH NEXT FROM curBOs INTO @boOid\n      END;\n  CLOSE curBOs\n  DEALLOCATE curBOs\n  if @coun = 0\n    BEGIN\n      Raiserror( N'No row exists in CoreNamedObjects table starting with IfcPilotStat -- so new row is not inserted in ITFCHKIFCPilotStatus table', 10, 1);\n      RETURN\n    END\n  if @coun > 1\n    BEGIN\n      Raiserror( N'More than one row exists in CoreNamedObjects table starting with IfcPilotStat -- so new row is not inserted in ITFCHKIFCPilotStatus table', 10, 1);\n      RETURN\n    END\n  BEGIN\n    DECLARE @dat as DATE\n    DECLARE @mindat as DATE\n    SET @dat = GetUTCDate();\n    set @mindat = (Select MIN(DateCreated) from COREBaseClass);\n    Raiserror( N'New row inserted in ITFCHKIFCPilotStatus table', 10, 1);\n    exec sp_executesql N'execute dbo.ITFCHKIfcPilotStatusSetProc @P1 , @P2, @P3,\n    @P4, @P5, @P6, @P7, @P8, @P9, @P10, @P11, @P12, @P13, @P14, @P15, @P16, @P17, @P18,\n    @P19, @P20, @P21, @P22, @P23, @P24, @P25, @P26',N'@P1 uniqueidentifier,\n    @P2 int,@P3 int,@P4 int,@P5 int,@P6 int,@P7 datetime,@P8 datetime,@P9 datetime,\n    @P10 datetime,@P11 datetime,@P12 int,@P13 int,@P14 int,@P15 int,@P16 int,@P17 datetime,\n    @P18 datetime,@P19 datetime,@P20 datetime,@P21 datetime,@P22 int,@P23 int,\n    @P24 nvarchar(1),@P25 datetime,@P26 float',\n    @boOid,1,0,2,0,0,@dat,@dat,@dat,0,@dat,1,0,2,0,0,@dat,@mindat,@dat,0,@dat,2,0,NULL,0.0,0.0\n  END<\/code><\/pre>\n
    \u7ed3\u679c\u5982\u4e0b\u56fe\uff1a<\/span><\/p>\n
    <\/span><\/p>\n
    <\/p>\n
    \u6b64\u8bed\u53e5\u4e5f\u53ef\u5728\u4ee5\u4e0b\u8def\u5f84\u627e\u5230\uff1a[Smart3D \u5b89\u88c5\u8def\u5f84]\\FoulCheck\\Tools\\bin\\IFCPilotStatusScript.sql,\u5982\u679c\u662fOracle\u6570\u636e\u5e93\uff0c\u8bf7\u6267\u884cIFCPilotStatusScriptORA.sql<\/span><\/p>\n
    <\/p>\n
    \u6267\u884cIFCPil<\/span>otStatusScript<\/span>.s<\/span>ql\u8bed\u53e5\u540e\uff0c\u91cd\u65b0\u6253\u5f00Project Management\uff0c\u6b64\u65f6\u5df2\u53ef\u6b63\u5e38\u8bbe\u7f6eI<\/span>nterference\u00a0<\/span>C<\/span>hecking Service<\/span><\/span><\/span><\/span><\/p>\n
    <\/p>\n
    <\/p>\n
    <\/mp-style-type><\/p>\n","protected":false},"excerpt":{"rendered":"
    \u6700\u8fd1\u5728\u9879\u76ee\u652f\u6301\u8fc7\u7a0b\u4e2d\u9047\u5230\u4e00\u4e2a\u95ee\u9898\uff0c\u5f53\u5728Project Management\u91cc\u8bbe\u7f6eInterference Ch […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[9],"tags":[],"class_list":["post-8970","post","type-post","status-publish","format-standard","hentry","category-smart3d"],"_links":{"self":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts\/8970","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/comments?post=8970"}],"version-history":[{"count":1,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts\/8970\/revisions"}],"predecessor-version":[{"id":9069,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts\/8970\/revisions\/9069"}],"wp:attachment":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/media?parent=8970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/categories?post=8970"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/tags?post=8970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}