メインコンテンツまでスキップ

Exciting new changes are coming to the Knowledge Base site soon!
Starting April 4, 2023, you will notice Support-Specific categorization and improvements to the search filters on the site. In May, we will be launching a new and enhanced Site UI and Navigation. To know more, read our Knowledge Article.

OnCommand Insight Data Warehouse Extract 、 Transform 、および Load ( ETL )は、 MySQL データベース内のテーブル全体が原因で失敗します

Views:
27
Visibility:
Public
Votes:
0
Category:
oncommand-insight-data-warehouse
Specialty:
oci
Last Updated:

に適用されます

OnCommand Insight Data Warehouse ( DWH ) 7.3.x

OnCommand Insight ( OCI ) 7.3.x

問題

DWH または OCI MySQL データベースに対するクエリーが失敗し、一時テーブルがいっぱいであるというメッセージが表示されます。クエリーは、 ETL の実行中、またはレポートの生成中に直接実行できます。

 
次に、 DWH.log に記録されるエラーの例を示します。 
 
2018-11-23 01:47:48,024 INFO [Thread-277 (ActiveMQ-client-global-threads)]
CustomScriptRunnerBean (CustomScriptRunnerBean.java:56) -
E:\Program Files\SANscreen\wildfly\bin\service\amd64>rem
****************************************************
2018-11-23 01:47:48,040 ERROR [Thread-277 (ActiveMQ-client-global-threads)]
CustomScriptRunnerBean (CustomScriptRunnerBean.java:58) - 'name' is not recognized as an internal
or external command,
operable program or batch file.
mysql: [Warning] Using a password on the command line interface can be insecure
ERROR 1114 (HY000) at line 3878: The table 'E:\Program
Files\SANscreen\mysql\tmp\#sql5a8_329_61' is full
Knowledgebase
2019-01-09 02:24:32,743 ERROR [Thread-847 (ActiveMQ-client-global-threads)] JobDispatcherBean
(JobDispatcherBean.java:106) - InventoryJob{name='Inventory: connector 'xxxxxx', 'Jan 9, 2019 2:00
AM'', id=15899, connectorId=7, targetTime=1547020800006, current=true} failed
Caused by: com.netapp.sanscreen.dwh.applications.inventory.InventoryException: Extracting
performance into Table{name='vmdk_performance'} failed (using Context{connector=xxxxxx})
Caused by: com.netapp.sanscreen.dwh.util.SqlShellException: Failed to execute: INSERT IGNORE
INTO dwh_inventory_staging.tmp_vmdk_performance VALUES
Caused by: java.sql.SQLException: The table 'tmp_vmdk_performance' is full
 
.err に含まれるこのエラーの例を次に示します。
2 018-11-23T01:22:17.371221-08:00 809 [ERROR] MySQL: The table 'E:\Program
Files\SANscreen\mysql\tmp\#sql5a8_329_61' is full
 
 

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

Scan to view the article on your device