Forums & Blog

Logging into the Agent Interface, as well as many operations in the Agent Interface is causing the following error (extracted from error log)

Unhandled error occurred.
Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection.
System.ArgumentException: Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection.
   at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
   at System.Collections.Generic.List`1.GetRange(Int32 index, Int32 count)
   at SmarterTrack.Data.UserEntityBase.GetListByPage(Int32 pageindex, Int32 pagesize, String select, String from, String orderby, String where, Int32& totalItems, SqlParameter[ parms)
   at SmarterTrack.Data.UserEntity.GetAllWithPaging(Int32 pageIndex, Int32 pageSize, Nullable`1 roleID, Nullable`1 isEmailVerified, String searchUsername, String searchDisplayName, String searchEmail, Nullable`1 isLockedOut, String sortOrder, Int32& totalItems, Nullable`1 isDeleted)
   at SmarterTrack.MRS.Settings.frmUsers.GenerateGrid()
   at SmarterTrack.MRS.Settings.frmUsers.Page_Load(Object sender, EventArgs e)
   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
   at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at SmarterTrack.MRS.HelperClasses.CustomPage.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Please post the database type and version you are using, and we'll look into it for you.

Microsoft SQL Server 2000

Kevin

An addon note here. This error is happening EVERYWHERE a list should be displayed (Tickets, Chats, Agents, etc.)

This IS on the same box as our production Smarter Tickets, but different database, IP, etc. I can get you a login if that would help.

We see the same here on SQL 2000.  Thanks.

Yes, same here on SQL 2000. System is un-usable.

 G.Ascione

Me to....same thing except I am running SQL 2005 on server 2003

Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection.

Source Error:

[ArgumentException: Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection.]
   System.ThrowHelper.ThrowArgumentException(ExceptionResource resource) +48
   System.Collections.Generic.List`1.GetRange(Int32 index, Int32 count) +63
   SmarterTrack.Data.TicketEntityBase.GetListByPage(Int32 pageindex, Int32 pagesize, String select, String from, String orderby, String where, Int32& totalItems, SqlParameter[ parms) +945
   SmarterTrack.Data.SpecialQueries.TicketLists.AdvancedSearch(TicketSearchParameters inputs, Int32 pageIndex, Int32 pageSize, Int32& totalItems, Nullable`1 UserIDSearching) +6355
   SmarterTrack.MRS.Tickets.frmTickets.GenerateGrid() +1459
   SmarterTrack.MRS.Tickets.frmTickets.Page_Load(Object sender, EventArgs e) +1898
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   SmarterTrack.MRS.HelperClasses.CustomPage.OnLoad(EventArgs e) +382
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436

We have not seen this issue on SQL 2005, but we'll investigate it.

thanks... and if you need any other info from me let me know and I will do the best i can to provide you with whatever i can....

Same here windows 2003, SQL 2000 Work Group Edition on seperate server.  This server currently runs Smarter Mail 3.x and Smarter Stats 3.x

My db server is an alias/instance not the default.  I am using SQL authentication.

Any word on this issue, or a work around? We cannot use the system at all.

G.Ascione

I get a similar error when using SqlServer Express 2005, IIS6, WinServer 2003, Integrated IIS Security.

 Can't get further than trying to enter the DB connection settings after the initial login.  The below is from the error log.

=====================
[2008-03-12 6:51:43 PM]
Agent: Admin (Admin)

Unable to connect to the database.  Check the data and try again.
Index was outside the bounds of the array.
System.IndexOutOfRangeException: Index was outside the bounds of the array.
   at SmarterTrack.Data.DataLayerImpersonate.BeginImpersonate(String connectionString)
   at SmarterTrack.Data.Utilities.DatabaseTest.TryConnectQuery(ConnectionString cs, String query, Boolean dontread, Exception& exception)

Same Issue, SQL Server 2000 SP4

We have tried in SQL2000 and SQL2005express and same thing in both

** Possible Work Around **

The problem is the developers are looking for 20 items in each agent role to display.  This means they need 20 users for each role.  I created some sample data with a 20 new test users and assigned them to the agent role and was able to get them loaded.  I am guess that Page Two will not work, but the users you have will display.  I would guess the SQL Server would not have anything to do with this