Error in table grid editor

We realise that after installing the Table Grid Editor and adding 2 tables to our screen the error below keep popping up in our error log.  We've tried renaming the table differently but it didn't work.  Any advice?

2015-04-15 16:41:06,381 http-bio-8180-exec-15 ERROR projectadmin 1001x300977x1 1a0qe26 10.238.2.22,127.0.0.1 /rest/idalko-igrid/1.0/datagrid/data [org.hibernate.util.JDBCExceptionReporter] The operation failed because an index or statistics with name 'screening_checklist2_iId' already exists on table 'screening_checklist2_c14597'.
2015-04-15 16:41:06,381 http-bio-8180-exec-15 WARN projectadmin 1001x300977x1 1a0qe26 10.238.2.22,127.0.0.1 /rest/idalko-igrid/1.0/datagrid/data [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1913, SQLState: 42S11
2015-04-15 16:41:06,162 http-bio-8180-exec-15 ERROR projectadmin 1001x300976x1 1a0qe26 10.238.2.22,127.0.0.1 /rest/idalko-igrid/1.0/datagrid/data [org.hibernate.util.JDBCExceptionReporter] The operation failed because an index or statistics with name 'screening_checklist_iId' already exists on table 'screening_checklist_c14552'.
2015-04-15 16:41:06,162 http-bio-8180-exec-15 WARN projectadmin 1001x300976x1 1a0qe26 10.238.2.22,127.0.0.1 /rest/idalko-igrid/1.0/datagrid/data [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1913, SQLState: 42S11
2015-04-15 16:15:46,085 http-bio-8180-exec-14 ERROR wopqmh 975x300395x1 1am8h9y 10.240.104.160,127.0.0.1 /rest/idalko-igrid/1.0/datagrid/data [org.hibernate.util.JDBCExceptionReporter] The operation failed because an index or statistics with name 'screening_checklist2_iId' already exists on table 'screening_checklist2_c14597'.
2015-04-15 16:15:46,085 http-bio-8180-exec-14 WARN wopqmh 975x300395x1 1am8h9y 10.240.104.160,127.0.0.1 /rest/idalko-igrid/1.0/datagrid/data [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1913, SQLState: 42S11
2015-04-15 16:15:45,366 http-bio-8180-exec-14 ERROR wopqmh 975x300394x2 1am8h9y 10.240.104.160,127.0.0.1 /rest/idalko-igrid/1.0/datagrid/data [org.hibernate.util.JDBCExceptionReporter] The operation failed because an index or statistics with name 'screening_checklist_iId' already exists on table 'screening_checklist_c14552'.
2015-04-15 16:15:45,366 http-bio-8180-exec-14 WARN wopqmh 975x300394x2 1am8h9y 10.240.104.160,127.0.0.1 /rest/idalko-igrid/1.0/datagrid/data [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1913, SQLState: 42S11




1 answer

1 accepted

Hi Thomas,

The subject of the log statements is harmless - when accessing a grid table, hibernate does a couple of checks like 'is the index available'.   The way it does this check is by trying to create it, which results in this error.

Still the logging is troubling quite a bit of users, so I created a bug to be resolved in an upcoming release
https://support.idalko.com/browse/IGRID-3265 

 

Thanks for raising the issue.

 

 

Francis

 

Thanks for such a quick response. Looking forward to the fix in the new version. Cheers.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,831 views 12 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot