Sunday, February 7, 2016

Pentaho schema workbench 3.7.0 unable to retrieve column of data

05:40:53,819 INFO [MondrianProperties] Mondrian: properties loaded from 'file=C
:\Users\mypc\Desktop\jasperanalysis-workbench-3.7.0\JasperAnalysis-Workbench-3.
7.0\mondrian.properties (exists=true)'
05:40:53,946 INFO [MondrianProperties] Mondrian: properties loaded from 'file:/
C:/Users/mypc/Desktop/jasperanalysis-workbench-3.7.0/JasperAnalysis-Workbench-3
.7.0/mondrian.properties'
05:40:53,946 INFO [MondrianProperties] Mondrian: loaded 0 system properties
05:41:30,844 ERROR [JdbcMetaData] setColumns
java.sql.SQLException: Disk full (/tmp/#sql_780_1.MAI); waiting for someone to f
ree some space... (errno: 28 "No space left on device")
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2637)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2566)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1464)
at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2472)

at com.mysql.jdbc.IterateBlock.doForAll(IterateBlock.java:50)
at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:2346
)
at mondrian.gui.JdbcMetaData.setColumns(JdbcMetaData.java:431)
at mondrian.gui.JdbcMetaData.setColumns(JdbcMetaData.java:415)
at mondrian.gui.JdbcMetaData.getAllColumns(JdbcMetaData.java:581)
at mondrian.gui.SchemaPropertyCellEditor.getTableCellEditorComponent(Sch
emaPropertyCellEditor.java:570)
at javax.swing.JTable.prepareEditor(Unknown Source)
at javax.swing.JTable.editCellAt(Unknown Source)
at javax.swing.plaf.basic.BasicTableUI$Handler.adjustSelection(Unknown S
ource)
at javax.swing.plaf.basic.BasicTableUI$Handler.mousePressed(Unknown Sour
ce)
at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionP
rivilege(Unknown Source)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionP
rivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionP
rivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)



This problem occur due to the server error (jave heap out of memory) where the database (datasource) is located. Restart the tomcat or server to resolve the issue.