# Error on window load when dropdown contains \> 9999 rows **URL:** \ **Category:** Ignition\ **Created:** [December 7, 2011, 11:17pm UTC](https://forum.inductiveautomation.com/t/error-on-window-load-when-dropdown-contains-9999-rows/3716 "2011-12-07T23:17:13Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Ron](https://avatars.discourse-cdn.com/v4/letter/r/ecae2f/32.png) [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Post date:** [December 7, 2011, 11:17pm UTC](https://forum.inductiveautomation.com/t/error-on-window-load-when-dropdown-contains-9999-rows/3716/1 "2011-12-07T23:17:13Z")
When I open a particular window in Ignition I get the error “Error setting dropdown data for dropdown ‘ddPackageID’; Illegal dropdown dataset: no columns.” I tried deleting the dropdown and recreating it and I get the error still. If I limit the dataset to SELECT TOP 9999 records, then I don’t get the error on load anymore. If I ignore the error when the window opens, everything seems to work just fine and the dropdown contains all 17,000 rows. ---
**Author:** ![Greg.Buehler](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\ **Post date:** [December 8, 2011, 4:27pm UTC](https://forum.inductiveautomation.com/t/error-on-window-load-when-dropdown-contains-9999-rows/3716/2 "2011-12-08T16:27:05Z")
Not to sound critical, but this seems like a higher level design problem than not being able to load \> 9999 rows. The operators are probably going to hate scrolling through more than 9999 records too. Is there any way you can force the user to filter this data so the result set is smaller? ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [December 8, 2011, 5:21pm UTC](https://forum.inductiveautomation.com/t/error-on-window-load-when-dropdown-contains-9999-rows/3716/3 "2011-12-08T17:21:16Z")
I cannot seem to reproduce this - I just filled up a dropdown with 11,000 values and it seemed fine. What are the column types of this dataset? ---
**Author:** ![Ron](https://avatars.discourse-cdn.com/v4/letter/r/ecae2f/32.png) [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Post date:** [December 8, 2011, 5:28pm UTC](https://forum.inductiveautomation.com/t/error-on-window-load-when-dropdown-contains-9999-rows/3716/4 "2011-12-08T17:28:02Z")
Integer and String like this: 18845 G-120811Z-KWS 18844 G-120711E-PAL 18843 G-120711U-PAL 18842 G-120711V-PAL 18841 G-120711D-PAL ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [December 9, 2011, 11:33pm UTC](https://forum.inductiveautomation.com/t/error-on-window-load-when-dropdown-contains-9999-rows/3716/5 "2011-12-09T23:33:06Z")
hmm, so was mine. What version are you running? ---
**Author:** ![Ron](https://avatars.discourse-cdn.com/v4/letter/r/ecae2f/32.png) [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Post date:** [December 10, 2011, 12:39am UTC](https://forum.inductiveautomation.com/t/error-on-window-load-when-dropdown-contains-9999-rows/3716/6 "2011-12-10T00:39:50Z")
We are running 7.3.2 I have attached sample window. [test.vwin](https://us1.discourse-cdn.com/inductiveautomation/original/1X/fca72c7a8367c57f0d96d83841c9e22ab00a8092.vwin) (3.45 KB) ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [December 21, 2011, 7:17pm UTC](https://forum.inductiveautomation.com/t/error-on-window-load-when-dropdown-contains-9999-rows/3716/7 "2011-12-21T19:17:48Z")
Thanks, I was able to track this down, it had to do with the serialization system. It has been fixed for 7.3.3.