SQL Warning: -1100, SQLState: 02000; no data

Owned by svitlana (Deactivated)
Last updated: Jul 30, 2018
1 min read

Problem

You might see such warning in the JIRA log on switching of the grid to the edit mode. 

It's insignificant warning that may be ignored




2016-12-03 15:07:25,914 ajp-nio-8009-exec-3 WARN ADM 919x253241x1 178a7vb 10.10.7.171 /rest/idalko-igrid/1.0/datagrid/data [o.hibernate.util.JDBCExceptionReporter] SQL Warning: -1100, SQLState: 02000 2016-12-03 15:07:25,914 ajp-nio-8009-exec-3 WARN ADM 919x253241x1 178a7vb 10.10.7.171 /rest/idalko-igrid/1.0/datagrid/data [o.hibernate.util.JDBCExceptionReporter] no data

Reason

Short answer: You can just ignore a warning.

Long explanation: It is shown during the normal work of the TGE. Before editing of the grid we are copying all the grid data to the temporary database so that the changes which are made in Edit Issue popup were applied to the persistent database only after the confirmation of the edit. Before copying we need to be sure that there is nothing left in the temporary table after the previous edit process. That's why we perform table clean-up on entering the edit mode. Sometimes it makes sense - temporary table contains data to be deleted, sometimes it is already empty. In the second case the warning is shown. It does not cause any errors or whatever. So just ignore it.



Workaround

It's insignificant warning that may be ignored