# Index 1 out of bounds for length 1 **URL:** \ **Category:** Ignition\ **Tags:** ignition81\ **Created:** [July 21, 2023, 11:57am UTC](https://forum.inductiveautomation.com/t/index-1-out-of-bounds-for-length-1/76702 "2023-07-21T11:57:44Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Marc-Antoine\_Thibaul](https://avatars.discourse-cdn.com/v4/letter/m/cab0a1/32.png) [@Marc-Antoine\_Thibaul](https://forum.inductiveautomation.com/u/Marc-Antoine_Thibaul)\ **Post date:** [July 21, 2023, 11:57am UTC](https://forum.inductiveautomation.com/t/index-1-out-of-bounds-for-length-1/76702/1 "2023-07-21T11:57:44Z")
I want to make a report in Ignition using data in a database. This is my querry : ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/7/1706a948c6f05a8b4d664168d87ff1654b61b138.png) This is the error I get : ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/b/9b9cb1c672dff925e037a47a62aeac95a7eb553a.png) Did someone already had this issue ? Thank you ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [July 21, 2023, 12:07pm UTC](https://forum.inductiveautomation.com/t/index-1-out-of-bounds-for-length-1/76702/2 "2023-07-21T12:07:54Z")
You haven't supplied enough information. What is looking for Index 1? Is your query returning any data? ---
**Author:** ![Marc-Antoine\_Thibaul](https://avatars.discourse-cdn.com/v4/letter/m/cab0a1/32.png) [@Marc-Antoine\_Thibaul](https://forum.inductiveautomation.com/u/Marc-Antoine_Thibaul)\ **Post date:** [July 21, 2023, 12:18pm UTC](https://forum.inductiveautomation.com/t/index-1-out-of-bounds-for-length-1/76702/3 "2023-07-21T12:18:39Z")
I don't know what is looking for Index 1, I just want to import data. I see the informations I want in the XML in the Preview tab ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [July 21, 2023, 2:35pm UTC](https://forum.inductiveautomation.com/t/index-1-out-of-bounds-for-length-1/76702/4 "2023-07-21T14:35:54Z")
Please post the stacktrace you get from clicking the 'full' text in the error message you showed. ---
**Author:** ![Mike\_Huneycutt](https://avatars.discourse-cdn.com/v4/letter/m/3ab097/32.png) [@Mike\_Huneycutt](https://forum.inductiveautomation.com/u/Mike_Huneycutt)\ **Post date:** [July 21, 2023, 2:47pm UTC](https://forum.inductiveautomation.com/t/index-1-out-of-bounds-for-length-1/76702/5 "2023-07-21T14:47:01Z")
Hey Marc-Antoine\_Thibaul, I ran into that issue recently as well. I closed and restarted the designer and it started working again for me. ---
**Author:** ![Marc-Antoine\_Thibaul](https://avatars.discourse-cdn.com/v4/letter/m/cab0a1/32.png) [@Marc-Antoine\_Thibaul](https://forum.inductiveautomation.com/u/Marc-Antoine_Thibaul)\ **Post date:** [July 21, 2023, 2:59pm UTC](https://forum.inductiveautomation.com/t/index-1-out-of-bounds-for-length-1/76702/6 "2023-07-21T14:59:23Z")
Okay I just closed and restated the deisgner, it works now. Thank you ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [July 21, 2023, 3:17pm UTC](https://forum.inductiveautomation.com/t/index-1-out-of-bounds-for-length-1/76702/7 "2023-07-21T15:17:15Z")
> [@Error saving window, and font issue -v8.1.21](https://forum.inductiveautomation.com/t/error-saving-window-and-font-issue-v8-1-21/76344/5): > > Guys, you're killing me. You gotta get this stuff in to support so I can actually fix it. Proceed with workarounds as you will, but give me a chance to fix it too! ---
**Author:** ![Mike\_Huneycutt](https://avatars.discourse-cdn.com/v4/letter/m/3ab097/32.png) [@Mike\_Huneycutt](https://forum.inductiveautomation.com/u/Mike_Huneycutt)\ **Post date:** [July 24, 2023, 12:57pm UTC](https://forum.inductiveautomation.com/t/index-1-out-of-bounds-for-length-1/76702/8 "2023-07-24T12:57:52Z")
Hey PGriffith, My support ticket: 87212 It should have stack track, images and logs with the ticket. Thanks, Mike