Skip to main content
NetApp Response to Russia-Ukraine Cyber Threat
In response to the recent rise in cyber threat due to the Russian-Ukraine crisis, NetApp is actively monitoring the global security intelligence and updating our cybersecurity measures. We follow U.S. Federal Government guidance and remain on high alert. Customers are encouraged to monitor the Cybersecurity and Infrastructure Security (CISA) website for new information as it develops and remain on high alert.
NetApp Knowledge Base

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

Last Updated:

Applies to

OnCommand Insight Data Warehouse (DWH) 7.3.X

OnCommand Insight (OCI) 7.3.X


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 ( -
E:\Program Files\SANscreen\wildfly\bin\service\amd64>rem
2018-11-23 01:47:48,040 ERROR [Thread-277 (ActiveMQ-client-global-threads)]
CustomScriptRunnerBean ( - '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
2019-01-09 02:24:32,743 ERROR [Thread-847 (ActiveMQ-client-global-threads)] JobDispatcherBean
( - 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


Scan to view the article on your device

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