{"id":4376,"date":"2021-02-26T22:03:22","date_gmt":"2021-02-26T14:03:22","guid":{"rendered":"http:\/\/pipingpig.com\/index.php\/2021\/02\/26\/smart3d-0132\/"},"modified":"2026-08-20T18:19:52","modified_gmt":"2026-08-20T10:19:52","slug":"smart3d-0132","status":"publish","type":"post","link":"https:\/\/www.pipingpig.com\/index.php\/2021\/02\/26\/smart3d-0132\/","title":{"rendered":"Regenerate Report database\u9519\u8bef\u5904\u7406"},"content":{"rendered":"
\n

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

<\/p>\n

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

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

\u6709\u65f6\u5728regenerate report database\u65f6\uff0c\u6709\u65f6\u4f1a\u9047\u5230\u4e00\u4e0b\u7a00\u5947\u53e4\u602a\u7684\u9519\u8bef\u3002\u5728\u751f\u6210\u4e4b\u540e\u5f97\u5230\u5982\u4e0a\u7684\u63d0\u793a\u3002\u67e5\u770b\u76f8\u5173log\u6587\u4ef6\uff0c\u6211\u4eec\u53ef\u4ee5\u53d1\u73b0\u76f8\u5173\u7684\u9519\u8bef\u63d0\u793a\u3002<\/h2>\n
\u6bd4\u5982\uff0c\u4e0b\u56fe\u4e2d\u63d0\u5230\u4e86\uff0c\u51fa\u73b0\u4e86duplicate codelist table\u3002\u7ecf\u6d4b\u8bd5\uff0c\u53ef\u4ee5\u8fdb\u5165catalog\u4e2d\u67e5\u8be2\u4e4b\u540e\uff0c\u4f7f\u7528\u5982\u4e0b\u7c7b\u4f3c\u7684sql \u811a\u672c\u8fdb\u884c\u6570\u636e\u5e93\u66f4\u65b0\u3002<\/span><\/section>\n
Update IJNamedObject SET Name =’Hvac Component types’ WHERE oid = (select oid from CodelistTableInfoView clv where clv.Name = ‘HvacComponentTypes’\uff09<\/span><\/section>\n
\u5c06\u4e0a\u9762\u4e2d\u7684codelist\u540d\u79f0\u8fdb\u884c\u66ff\u6362\uff0c\u628aHVAC component types\u6362\u4e3a\u91cd\u590d\u7684codelist table\u3002
<\/span><\/section>\n
x x x x x x x x x
<\/span><\/section>\n

<\/p>\n

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

<\/span>\u6b64\u5916\uff0c\u53ef\u80fd\u4f1a\u9047\u5230\u8fd9\u6837\u7684\u9519\u8bef\u201c<\/span>Regenerate<\/span>\u00a0<\/span>Reports<\/span>\u00a0Database fails with “<\/span>Invalid<\/span>\u00a0column<\/span>\u00a0name<\/span>\u00a0‘xxx ‘<\/span><\/span>”\u00a0<\/span>error<\/span>.<\/span>\u201d<\/span><\/section>\n

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

<\/p>\n

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

\u7ecf\u6d4b\u8bd5\u53d1\u73b0\uff0c\u4f7f\u7528\u4e4b\u524d\u6587\u7ae0<\/span><\/section>\n

\u300aSmart 3D \u5e38\u7528\u5de5\u5177\u7b80\u4ecb\u4e4bView Generator<\/a>\u300b
<\/h2>\n
\u4e2d\u4ecb\u7ecd\u7684view generator\u5de5\u5177\u53ef\u4ee5\u89e3\u51b3\u8be5\u95ee\u9898\u3002<\/section>\n
\u53ea\u9700\u8981\u5148\u5bf9\u9879\u76ee\u7684catalog\u8fdb\u884c\u91cd\u751f\uff0c\u7136\u540e\u5bf9Model\u7684database\u8fdb\u884c\u91cd\u751f\u3002\u4e24\u6b21\u64cd\u4f5c\u540e\u95ee\u9898\u57fa\u672c\u4e0a\u5c31\u53ef\u4ee5\u89e3\u51b3\u4e86\u3002<\/section>\n
x x x x x x x x x<\/span><\/section>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

x x x x x x x x x x x x x x x x x x x x x x x x x x x \u6709 […]<\/p>\n","protected":false},"author":1,"featured_media":4373,"comment_status":"open","ping_status":"open","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,14],"tags":[],"class_list":["post-4376","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-smart3d","category-14"],"_links":{"self":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts\/4376","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=4376"}],"version-history":[{"count":3,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts\/4376\/revisions"}],"predecessor-version":[{"id":7916,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts\/4376\/revisions\/7916"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/media\/4373"}],"wp:attachment":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/media?parent=4376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/categories?post=4376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/tags?post=4376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}