Skip to main content

NetApp_Insight_2020.png 

NetApp Knowledgebase

OnCommand Insight Data Warehouse Extract, Transform, and Load (ETL) fail due to a full table in the MySQL database

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

Applies to

OnCommand Insight Data Warehouse (DWH) 7.3.X

OnCommand Insight (OCI) 7.3.X

Issue

Queries against the DWH or OCI MySQL database fail with a message that the temp table is full. Queries may be run directly, during an ETL, or during report generation.

 
Following are examples of these errors in 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
 
An example of this error in .err is:
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
 
 

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support