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

This widget could not be displayed.

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 Sign up to answer
Community showcase
Published Friday in Jira

New 5k User Limit and Other Cloud Updates

Hi all! Lauren here from the Enterprise Cloud marketing team.  I have some exciting Cloud updates from #AtlassianSummit that I wanted to share. We want everyone in your organization to be ab...

85 views 0 2
Read article

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