\n
————————————————————————-<\/del><\/ins>
\n\u5e94\u7528\u5bf9\u8c61\u7a0b\u5e8f\u5e93: Version : 12.0.0<\/p>\n
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.<\/p>\n
FNDGSCST module: \u7edf\u8ba1\u6570\u636e\u6536\u96c6\u6a21\u5f0f
\n~~————————————————————————-<\/del><\/ins><\/p>\n~~
\u5f53\u524d\u7684\u7cfb\u7edf\u65f6\u95f4\u4e3a 02-04-2020 00:01:15<\/p>\n
~~————————————————————————-<\/del><\/ins><\/p>\n~~
Starts**02-04-2020 00:01:15
\n*Ends<\/strong>*02-04-2020 00:46:07
\nORA-0000: normal, successful completion
\n————————————————————————-<\/del><\/ins>
\nFND_FILE \u4e2d\u65e5\u5fd7\u6d88\u606f\u5f00\u59cb
\n————————————————————————-<\/del><\/ins>
\nIn GATHER_SCHEMA_STATS , schema_name= ALL percent= 60 degree = 32 internal_flag= NOBACKUP
\nstats on table AQ$_WF_CONTROL_P is locked
\nstats on table FND_CP_GSM_IPC_AQTBL is locked
\nstats on table FND_SOA_JMS_IN is locked
\nstats on table FND_SOA_JMS_OUT is locked
\nError\u00a0#1<\/a>: ERROR: While GATHER_TABLE_STATS:
\nobject_name=GL.JE_BE_LINE_TYPE_MAP<\/b>ORA-20001: invalid column name or duplicate columns\/column groups\/expressions in method_opt<\/strong>**
\nError\u00a0#2<\/a>: ERROR: While GATHER_TABLE_STATS:
\nobject_name=GL.JE_BE_LOGS***ORA-20001: invalid column name or duplicate columns\/column groups\/expressions in method_opt***
\nError\u00a0 #3<\/a>: ERROR: While GATHER_TABLE_STATS:
\nobject_name=GL.JE_BE_VAT_REP_RULES***ORA-20001: invalid column name or duplicate columns\/column groups\/expressions in method_opt***
\n————————————————————————-<\/del><\/ins>
\nFND_FILE \u4e2d\u65e5\u5fd7\u6d88\u606f\u7ed3\u675f
\n————————————————————————-<\/del><\/ins>
\n\u6210\u529f\u5730\u91cd\u65b0\u63d0\u4ea4\u5177\u6709\u8bf7\u6c42\u7f16\u53f7 532437 \u7684\u5e76\u53d1\u7a0b\u5e8f FNDGSCST\uff0c\u4ee5\u5728 02-05-2020 00:01:01 \u542f\u52a8\u3002 (ROUTINE=AFPSRS)<\/p>\n
————————————————————————-<\/del><\/ins>
\n\u6b63\u5728\u6267\u884c\u8bf7\u6c42\u5b8c\u6210\u9009\u9879…<\/p>\n
Output file size:
\n0<\/p>\n
\u5df2\u5b8c\u6210\u6267\u884c\u8bf7\u6c42\u5b8c\u6210\u9009\u9879\u3002<\/p>\n
————————————————————————-<\/del><\/ins>
\n\u6b64\u8bf7\u6c42\u53d1\u5e03\u7684\u4f8b\u5916\uff1a
\nConcurrent Request for “\u7edf\u8ba1\u6570\u636e\u6536\u96c6\u6a21\u5f0f” has completed with error.<\/p>\n
————————————————————————-<\/del><\/ins>
\n\u5df2\u5b8c\u6210\u5e76\u53d1\u8bf7\u6c42
\n\u5f53\u524d\u7684\u7cfb\u7edf\u65f6\u95f4\u4e3a 02-04-2020 00:46:08<\/p>\n
<\/p>\n
\n
<\/p>\n<\/div>\n
\u89e3\u51b3\u65b9\u6848\uff1a
\n\u53c2\u8003\u6587\u4ef6\uff1a11i – 12 Gather Schema Statistics fails with Ora-20001 errors after 11G database Upgrade (Doc ID 781813.1)<\/p>\n
\u5177\u4f53\u64cd\u4f5c\uff1a<\/p>\n
\u901a\u8fc7\u4ee5\u4e0b\u547d\u4ee4\u67e5\u8be2\u51fa\u67092\u6761\u53ca\u4ee5\u4e0a\u6761\u6570\u7684\u8bb0\u5f55\uff0c<\/p>\n
select table_name, column_name, count()
\nfrom FND_HISTOGRAM_COLS
\ngroup by table_name, column_name
\nhaving count(<\/strong>) > 1;<\/p>\n
\u5907\u4efd\u540e\u5220\u9664\u5373\u53ef\u3002<\/p>\n
delete from FND_HISTOGRAM_COLS
\nwhere table_name = ‘&TABLE_NAME’
\nand column_name = ‘&COLUMN_NAME’
\nand rownum=1;<\/p>\n
— Use following SQL to delete obsoleted rows<\/p>\n
delete from FND_HISTOGRAM_COLS
\nwhere (table_name, column_name) in
\n(
\nselect hc.table_name, hc.column_name
\nfrom FND_HISTOGRAM_COLS hc , dba_tab_columns tc
\nwhere hc.table_name =’&TABLE_NAME’
\nand hc.table_name= tc.table_name ()
\nand hc.column_name = tc.column_name (<\/ins>)
\nand tc.column_name is null
\n);<\/p>\n
commit;<\/p>\n
\u7279\u522b\u8bf4\u660e\uff1a\u65e5\u5fd7\u4e2d\u53ea\u62a5\u4e863\u4e2a\u8868\u7684\u9519\u8bef\uff0c\u5b9e\u9645\u4e0a\u5982\u679c\u53ea\u5904\u7406\u8fd93\u4e2a\u8868\u7684\u95ee\u9898\uff0c\u4f9d\u7136\u4e0d\u80fd\u6b63\u5e38\u5b8c\u6210\u8bf7\u6c42\uff0c\u9700\u8981\u5c06\u6240\u6709\u5927\u4e8e\u7b49\u4e8e2\u7684\u6761\u6570\u7684\u6570\u636e\u5220\u9664\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u9519\u8bef\u63cf\u8ff0\uff1a \u63cf\u8ff0 ——————&#82 … \u7ee7\u7eed\u9605\u8bfb\u8d22\u52a1\u7cfb\u7edf\u751f\u4ea7\u73af\u5883\u7edf\u8ba1\u6536\u96c6\u6a21\u5f0f\u9519\u8bef\uff08\u4ece\u672a\u6210\u529f\uff09<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[262],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1737"}],"collection":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1737"}],"version-history":[{"count":3,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1737\/revisions"}],"predecessor-version":[{"id":1740,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1737\/revisions\/1740"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1737"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1737"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}