crystal report disp_e_badindex

• Latest Articles
• Top Articles
• Posting/Update Guidelines
• Article Help Forum

• View Unanswered Questions
• View All Questions
• View C# questions
• View C++ questions
• View Javascript questions
• View Python questions
• View PHP questions
• CodeProject.AI Server
• All Message Boards...
• Running a Business
• Sales / Marketing
• Collaboration / Beta Testing
• Work Issues
• Design and Architecture
• Artificial Intelligence
• Internet of Things
• ATL / WTL / STL
• Managed C++/CLI
• Objective-C and Swift
• System Admin
• Hosting and Servers
• Linux Programming
• .NET (Core and Framework)
• Visual Basic
• Web Development
• Site Bugs / Suggestions
• Spam and Abuse Watch
• Competitions
• The Insider Newsletter
• The Daily Build Newsletter
• Newsletter archive
• CodeProject Stuff
• Most Valuable Professionals
• The Lounge  
• The CodeProject Blog
• Where I Am: Member Photos
• The Insider News
• The Weird & The Wonderful
• What is 'CodeProject'?
• General FAQ
• Ask a Question
• Bugs and Suggestions

Crystal Report Problem ( Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)))

2 solutions

• Most Recent

Add your solution here

• Read the question carefully.
• Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
• If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

• Ask a Question
• Write a Blog Post
• Login / Sign-up

Error Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)) for CR Run in SAP B1

We are facing error Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)) while running specific crystal report in SAP B1.

We have upgraded our SAP Version to SAP B1 10.0 PL 2108 HF 01 on HANA released on 1st September.

After upgrade we are facing error Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)) for some reports in SAP B1.

Crystal reports works properly if run directly as crystal report but shows error while running in SAP B1.

Crystal Report Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))

asp.net crystal-reports-2008

I have made a crystal report in asp.net for web application. Some report open nicely. But sometimes it does not. It shows the following problem.

Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)) 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.Runtime.InteropServices.COMException: Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)) Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [COMException (0x8002000b): Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))] Report_Viewer.Page_Load(Object sender, EventArgs e) +894 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +50 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

Version Information: Microsoft .NET Framework Version:2.0.50727.4927; ASP.NET Version:2.0.50727.4927

My VS: VS 2008, Database:MS SQL Express 2005, OS:Windows 7

Is there any one to solve my problem..

NB: My code is in a Class

Report Viewer Page load

Best Solution

That is because the parameters (or parameters names) you set in your code are different from defined parameters in your report

Related Solutions

C# – timeout expired. the timeout period elapsed prior to completion of the operation or the server is not responding. the statement has been terminated.

Looks like you have a query that is taking longer than it should. From your stack trace and your code you should be able to determine exactly what query that is.

This type of timeout can have three causes;

• There's a deadlock somewhere
• The database's statistics and/or query plan cache are incorrect
• The query is too complex and needs to be tuned

A deadlock can be difficult to fix, but it's easy to determine whether that is the case. Connect to your database with Sql Server Management Studio. In the left pane right-click on the server node and select Activity Monitor . Take a look at the running processes. Normally most will be idle or running. When the problem occurs you can identify any blocked process by the process state. If you right-click on the process and select details it'll show you the last query executed by the process.

The second issue will cause the database to use a sub-optimal query plan. It can be resolved by clearing the statistics:

If that doesn't work you could also try

You should not do this when your server is under heavy load because it will temporarily incur a big performace hit as all stored procs and queries are recompiled when first executed. However, since you state the issue occurs sometimes , and the stack trace indicates your application is starting up, I think you're running a query that is only run on occasionally. You may be better off by forcing SQL Server not to reuse a previous query plan. See this answer for details on how to do that.

I've already touched on the third issue, but you can easily determine whether the query needs tuning by executing the query manually, for example using Sql Server Management Studio. If the query takes too long to complete, even after resetting the statistics you'll probably need to tune it. For help with that, you should post the exact query in a new question.

Related Question

1661223 - Error: Invalid index - using Crystal Report SDK for Visual Studio .NET

• Attempting to retrieve objects from a report
• This results in the following error:

Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))

Environment

• Crystal Reports for Visual Studio 2010
• Visual Studion 2010

Reproducing the Issue

• Use the following code block:

     2.    Run a report

     3.   The error will be thrown at the following line of code:

The index is set incorrectly:

• Rather than using:

CR2010 2010 CR4VS2010 CR4VS VS2010 NET2010 Crystal Reports for .NET Framework 4.0 crforvs 13 indexing count bad code SDK solution developer kit VS , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , How To

Privacy | Terms of use | Legal Disclosure | Copyright | Trademark

• Featured Products

Fix: Unhandled Exception (HRESULT: 0x8002000B DISP_E_DABINDEX)

If you attempt to generate a Crystal Report, you may receive an unhandled exception error per below that prevents your reports from generating.

Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately.

Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_DABINDEX))

• Check your stored procedure in SQL Server and Visual Studio and parameters names are correct.
• Do not use a parameter name for SetParameterValue and instead use the index which will start from 0.
• Verify linked sheets actually exist (such as sheets in an Excel workbook).
• Finally, remember that field names in Crystal Reports are case sensitive . Ensure spelling and case is exactly the same when you pass them in parameters.

Related Posts

How to fix: “an error occurred while moving your channel” (youtube brand account), fix: maximum display brightness + windows boot camp, can’t play – 0xc00d36f2 windows media player, fix: sorry, you need to sign out of teams and sign in again before you can schedule your meeting., fix: acrobat distiller unable to create the temporary folder error: 183, fix: microsoft access has detected that this database is in an inconsistent state and will attempt to recover the database..

• Disqus Comments

In order to provide you with the best online experience this website uses cookies.

By using our website, you agree to our use of cookies. Learn more

There is a section in the LDSDAdministrator guide called Sending a report when an assignment or reminder is sent.  Here are some additional pointers if you are having trouble getting this to work:

The report itself

When you add the report onto the required object in object designer, the report is actually stored in the database at this point.  This means that if you make changes to the report via crystal it will not be updated in the outbound email until you go back into object designer to reload the report into the database again.

You may want to start by just using the incident.rpt that you normally use in the system whilst you are testing that this functionality works ok.  You must ensure that you database - set location on this report in crystal before you start so that it points to your database.

However, if you are creating a new report from scratch in Crystal, please be aware that you need to set the report to populate based on the guid of the parent object as this is what is sent at runtime.

In order to do this you need to for create a Parameter Field called Guid and then set the record selection formula.  For example if you are creating a report on the im_reminder object you need to create a record selection formula where {im_reminder.im_incident_guid} = {?Guid}.

If you don't set any guid record selection formula you may see the error Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))" or the mail will not send at all (depending on your version).

If you had accidentally set the record selection formula on the collection object your report will still be sent but will contain no data.  An example where this might happen is if you are creating a report on the im_reminder object if you set {im_reminder.im_guid} = {?Guid}.  Adjust this to be {im_reminder.im_incident_guid} = {?Guid}.

Outbound mail

An obvious point perhaps but firstly ensure that outbound mails without attached reports are working ok before you even start to attach reports.  See the community articles regarding troubleshooting outbound mail.

You may find it useful to switch on trace mail logging so that you can see everything outbound mail is doing in event viewer  http://community.landesk.com/support/docs/DOC-6815

Possible errors that you may see in the event log and their causes:

• Failed      to logon - Outbound mail isn't working at all.  The outbound mail      username and outbound mail password in the config file for the mail      service in \program files\landesk\landesk applications is not      correct.  This should specify a ServiceDesk login and password.       Run the \program files\landesk\landesk      applications\Touchpaperpasswordtool.exe (In 7.5 this is configured in the Configuration Centre) to update this.
• Logon      failed - Login failed for user x (where x is the database  connection      password). The crystal reports username and crystal reports password in      the config file  for the mail service in \program      files\landesk\landesk applications (In 7.5 this is configured in the Configuration Centre) is  not correct.  This should      specify a Database login and password that matches that used to create      your crystal report.  Run  the \program files\landesk\landesk      applications\Touchpaperpasswordtool.exe (In 7.5 this is configured in the Configuration Centre)  to update this.
• Terms & Conditions
• Privacy Policy

• TECHNOLOGIES
• An Interview Question
• Monthly Leaders
• Forum guidelines

Nitol Biswas

Invalid index. (exception from hresult: 0x8002000b ), answers ( 1 ).

Invoking Crystal Reports report via .NET interface throws System.Runtime.InteropServices.COMException

Invoking crystal reports report via .net interface throws system.runtime.interopservices.comexception apr 11, 2014 • knowledge, information.

The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.

Related Articles

• Number of Views 26.7K
• Number of Views 4.58K
• Number of Views 57.57K
• Number of Views 3.8K
• Number of Views 1.15K

Copyright © 2023 Progress Software Corporation and/or its subsidiaries or affiliates. All Rights Reserved.

Progress, Telerik, Ipswitch, Chef, Kemp, Flowmon and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.

Terms of Use | Privacy Center | Trademarks | License Agreements | Careers | Offices