Help Activities
Hi All, I am using below code. I wanted to extract either order ID or invoice ID or sometimes both from an .xml file. But it is giving below error: If anybody can help?? Attaching all relevant document…plz help New…xaml (19.4 KB) Data used here:Data.zip (3.7 KB) P.S. Run the code u will see the error
This means you are trying to reference an item in a collection that doesn’t exist. Say there are 5 items in the collection (index 0-4) and you try to reference item(5) - you’ll get this error. 1 Like
Array value is start index is Zero(0). ArrValue(ArrValue.Length-1) to get last value. Regards, 1 Like
Hi, The expression try to iterate 2 items from arr1.length. However arr2 and arr3 has only 1 item, then throw exception. Perhaps you should review your expression. Regards,
How it can be done…if u can help?
Which part u r talking about specifically in code?
Hi, I’m not sure what you want to do by this expression. However, for now, can you try to modify from arr1.length to arr2.length, as the following? (From x In Enumerable.Range(0,arr2.length) Let a = "LabelA: " & arr1(x) Let b = "LabelB: " & arr2(x) Let c = "LabelC: " & arr3(x) Select res = String.Join(Environment.newLine, {a,b,c})).toarrayRegards, 1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900
User launches Controller client. User chooses database. The following ideas do not solve the problem:
The following error appears after selecting the database: System.Web.Services.Protocols.SoapException: Server was unable to process request. --> System.IndexOutOfRangeException: Index was outside the bounds of the array. at Cognos.Controller.Proxy.ControllerReportNetService.RepNet.GetUserInfo (String sGuid, String sUser.String passportId) at Cognos.Controller.Proxy.CCRWS.GetUserInfo (String sGuid, String sUser. StringpassportId) --- End of inner exception stack trace --- at Cognos.Controller.Forms.Common.Main.DoLoginCognos8 (Form&frm) at CCR.AppContext.DoLogin() at CCR.AppContext.Login() Testing the Controller Web Service URL in Internet Explorer (http://<Controller Server FQDN>/ibmcognos/controllerserver/ccrws.asmx): The global attribute 'http://www.w3.org/XML/1998/namespace:lang' has already been declared
There are several possible causes for similar errors.
This technote specifically relates to the scenario where the cause is that the credentials (sent by Internet Explorer when performing the Controller SSO Login) have been corrupted.
Problem has been seen with:
However, it may affect other versions/environments.
The problem only affects one client device (one end user's PC).
Reset Internet Explorer settings.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3, 10.4","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Hi all, We have user that suddenly gets this error: Anyone know what to do about it?
Best answer by Hans Andersen @Manoj Ruwanhewa<\>\u00a0,\u00a0@Bhagya Wickramasinghe<\>\u00a0,\u00a0@Ben Monroe<\>\u00a0,<\> We had\u00a0to recreate the profile. Not optimal, but it is working now.<\>","className":"post__content__best_answer"}> View original
SQL Server 2008 SQL Server 2008 R2 More...Less Consider the following scenarios:
Scenario 1
In this scenario, the query does not successfully finish. Additionally, you receive the following error message:
An error occurred while executing batch. Error message is: Index was outside the bounds of the array. Note This problem also occurs if you run the same query by using SQL Server Management Studio 2005.Scenario 2
In this scenario, the application does not return the data from the XML data type column. Additionally, you receive following exception:
[IndexOutOfRangeException: Index was outside the bounds of the array.]System.Xml.XmlSqlBinaryReader.GetXsdKatmaiTokenLength(BinXmlToken token) +1207761System.Xml.XmlSqlBinaryReader.ScanOverAnyValue(BinXmlToken token, Boolean attr, Boolean checkChars) +524System.Xml.XmlSqlBinaryReader.ScanOverValue(BinXmlToken token, Boolean attr, Boolean checkChars) +159System.Xml.XmlSqlBinaryReader.ImplReadData(BinXmlToken tokenType) +119System.Xml.XmlSqlBinaryReader.ReadDoc() +589 System.Xml.XmlSqlBinaryReader.Read() +201 This problem occurs because of a known issue in the XmlReader class of the .NET Framework 2.0. To resolve this problem, apply this hotfix to the computer on which you use an application to return data from the XML data type column.To work around this problem, see the "Workaround" section. A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that described in this article. Apply this hotfix only to systems that are experiencing the problem described in this article. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix. Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft website: http://support.microsoft.com/contactus/?ws=supportNote The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language. The following list contains prerequisites for this hotfix:
You may have to restart the computer after you apply this hotfix. The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following tables. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.
To work around this problem, use one of the following methods. Use the CONVERT function when you query the XML data type column. For example, if XmlDoc is the name of the XML data type column, do not use a query that resembles the following: SELECT XmlDoc from dbo.Table1 Build an application that is based on the .NET Framework 4.0 to query the XML data type column. Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. For more information, visit the following Microsoft Developer Network (MSDN) websites: Implementing XML in SQL Server XmlReader Class
|