Cognos error when using Internet Explorer
Question:
This document does not contain a valid report specification.
Reason:
The namespace prefix is not allowed to start with the reserved string "xml".
URL:
Line:
7715
Character:
100
Source:
<selection><dataItem name="Donor ID Number" aggregate="none" rollupAggregate="none"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">[Advancement].[Gifts].[Donor ID Number]</expression><XMLAttributes><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataType" value="1" output="no"/><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Donor Name" aggregate="none" rollupAggregate="none"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">[Advancement].[Gifts].[Donor Name]</expression><XMLAttributes><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataType" value="3" output="no"/><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataUsage" value="identifier" output="no"/></XMLAttributes></dataItem><dataItem name="Gift Amount" aggregate="total"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">[Advancement].[Gifts].[Gift Amount]</expression><XMLAttributes><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataType" value="2" output="no"/><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataUsage" value="fact" output="no"/></XMLAttributes></dataItem><dataItem name="Gift Receive Date" aggregate="none" rollupAggregate="none"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">[Advancement].[Gifts].[Gift Receive Date]</expression><XMLAttributes><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataType" value="7" output="no"/><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataUsage" value="identifier" output="no"/></XMLAttributes></dataItem><dataItem name="Gift Appeal Code" aggregate="none" rollupAggregate="none"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">[Advancement].[Gifts].[Gift Appeal Code]</expression><XMLAttributes><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataType" value="3" output="no"/><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Gift Designation Code" aggregate="none" rollupAggregate="none"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">[Advancement].[Gifts].[Gift Designation Code]</expression><XMLAttributes><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataType" value="3" output="no"/><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Gift Designation Description" aggregate="none" rollupAggregate="none"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">[Advancement].[Gifts].[Gift Designation Description]</expression><XMLAttributes><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataType" value="3" output="no"/><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Gift Form Code" aggregate="none" rollupAggregate="none"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">[Advancement].[Gifts].[Gift Form Code]</expression><XMLAttributes><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataType" value="3" output="no"/><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Gift Credit - Y/N" aggregate="none" rollupAggregate="none"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">[Advancement].[Gifts].[Gift Credit - Y/N]</expression><XMLAttributes><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataType" value="3" output="no"/><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Gift Status" aggregate="none" rollupAggregate="none"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">[Advancement].[Gifts].[Gift Status]</expression><XMLAttributes><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataType" value="3" output="no"/><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem></selection>
---------------------------------------------------------------------------------------------------^
Answer:Adam,
This error was reported to me by Jan Yost. I can click on the Run arrow icon on the main screen beside the report name and it runs without error. But, if I try to open it in Report Studio, I get the error above. Should I open a ticket with Jenzabar? Or, do you have some suggestions on this first?
Should have included Jan's email below where she gave the file location:
Is something going on with cognos right now? I am trying to run the report Monthly Donors in Public Folders/Advancement Report/Current Advancement Report. It returns the error RSV-BBP-0031 The request was improperly signed. With no details of course. I am pretty sure I have run this before and it worked.
Jan,
I reviewed the error. It appears that this error is only displayed in Internet Explorer. When you access Report Studio in either Chrome or Firefox the error does not present itself. Therefore, as a workaround, for now, I would edit this report using Report Studio in Chrome or Firefox. Sylvia will be submitting a ticket to Jenzabar to see how to resolve the issue you are experiencing with Internet Explorer. Thanks.
Adam Skiles
Director of Information & Technology Services
Jan,
We tested in both Firefox and Chrome and did not have any errors on our end. I will give you a call to run a support session and see what may be causing the issue for you.
Adam Skiles
Director of Information & Technology Services
I re-ran the report using Firefox (which I am 99% sure I used on Thursday) from the page Explorer-Run Report - Excel 2007. Then I re-ran within the last query, and then from the first query (view tabular data). Each time I still received the original error from last week.
I was able to run a different report with no problems.
Jan,
I will give you a call to test out the problem. Thanks.
Adam Skiles
Director of Information & Technology Services
Adam,
I already submitted a ticket with Jenzabar on this. I failed to put their response here. Doing that now.
Hi Sylvia,
On this one, since they can use Firefox and Chrome with no issues, the issue must be in IE.
Attached is documentation on settings in IE.
Please check this out on their IE and let me know if this resolves the issue.
Thank you,
Janet
Incident 397691
Caller: Sylvia Reed Huntington University
Phone: 260-359-4124
Summary: Cognos Error when using Internet Explorer
Click here to view this call in the ITSM Portal
Added by Reed, Sylvia on Friday, October 20, 2017 1:37 PM
Summary: Cognos Error when using Internet Explorer
A Cognos Report that has worked before is now returning an error in IE. THe report is named "Monthly Donors" in Public Folders/Advancement Report/Current Advancement Report. It returns the error RSV-BBP-0031 The request was improperly signed. With no details of course.
The larger error I received is below. The report will still run. But, if you try to open it in Report Writer you get the error in IE but not in Firefox or Chrome. Please advise.
Out of the box, Internet Explorer will block Cognos running a report as Excel. Also it will hobble some of Cognos’s abilities.
These instructions show you how to set Internet Explorer 8, 9, 10 or 11 to work best with Cognos.
Note: This edits security settings on your Intranet. You will need to have Admin permissions to do this.
Getting to Internet Options a) Open Internet Explorer
b) Click ‘Tools’ on the Menu bar
If you don’t see the Menu bar below the Address bar, tap the Alt key on your Keyboard (To save screen space IE hides the Menu bar)
c) Click ‘Internet Options’ (it’s the bottom item on the ‘Tools’ menu)
Assigning Cognos to your Trusted Sites To help keep our Internet Security settings secure, we will be adding Cognos to Trusted sites. This will let us not change how IE handles most websites, only those we assign as trusted.
a) Click the ‘Security’ tab
b) Click the ‘Trusted sites’ Icon
c) Click the ‘Sites’ button
d) Uncheck the box by “Require server verification…” if it is checked.
e) In the ‘Add this website to the zone:’ box type *://cognos.graceland.edu and click the ‘Add’ button
This will make it so both https:// and http:// forms of cognos.graceland.edu are supported
f) If any other cognos.graceland.edu addresses are in the ‘Websites:’ list click on them and click the ‘Remove’ button
g) Click the ‘Close’ button to close the ‘Trusted Sites’ window
Setting the Security Level Now we need to tell Internet Explorer how to handle the settings for our Trusted Sites
a) Under the ‘Security level for this zone’ click the ‘Custom level…’ button
b) Make sure the following settings are set:
1 ‘Downloads’ à ‘File download’: Enable
This allows you to have file downloads
2 ‘Miscellaneous’ à ‘Display Mixed Content’: Enable
This allows you to see images from both secure and unsecure websites (many images are hosted on an unsecure website so you can see them)
3 ‘Miscellaneous’ à ‘Launching applications and unsafe files’: Prompt
This allows you to have Excel Downloads when File Downloads is Enabled
4 ‘Miscellaneous’ à ‘Use Pop-up Blocker’: Disable
This prevents Cognos from blocking File download Pop-ups (Authors: it also allows you to open some studios)
5 ‘Scripting’ à ‘Enable XSS Filter’: Disable
XSS Filtering is a security feature of Internet Explorer. Not all websites work with it, and a few features of Cognos do legitimate Cross-Site Scripting (XSS). We don’t want IE getting in the way of this legitimate use.
c)
If you are an Author, you should also set the following: 1
‘Miscellaneous’ à ‘Allow websites to open windows without address or status bars’: Enable This is for the studios that open in new windows to work (such as Report Studio or Event Studio)
2 ‘Scripting’ à ‘Allow Programmatic clipboard access’: Enable
This makes it so you don’t have to answer the question about letting a Studio have access to your clipboard every time you launch it (such as Report Studio)
d) Click the ‘OK’ button to close the ‘Security Settings – Trusted Sites Zone’ window
Finishing Up and Note about Pop Up blockers a) Click the ‘OK’ button to close the ‘Internet Options’ window
b) Close all Internet Explorer windows and reopen Internet Explorer
c) Note: If the next time you try to download an Excel file, it is still blocked, you may have 3rd Party Pop-Up blockers installed, such as Bing, Yahoo, or Google toolbars. You will need to adjust settings in each of these.
IE 10 & 11 settings a) Click ‘Tools’ on the Menu bar
If you don’t see the Menu bar below the Address bar, tap the Alt key on your Keyboard (To save screen space IE hides the Menu bar)
b) Click ‘Compatibility View”
c) Certain features in Cognos 10.1.1 will not work with IE 10, such as Page Preview. It’s not a significant issue, but just be aware.
This document does not contain a valid report specification.
Reason:
The namespace prefix is not allowed to start with the reserved string "xml".
URL:
Line:
7715
Character:
100
Source:
<selection><dataItem name="Donor ID Number" aggregate="none" rollupAggregate="none"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">[Advancement].[Gifts].[Donor ID Number]</expression><XMLAttributes><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataType" value="1" output="no"/><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Donor Name" aggregate="none" rollupAggregate="none"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">[Advancement].[Gifts].[Donor Name]</expression><XMLAttributes><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataType" value="3" output="no"/><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataUsage" value="identifier" output="no"/></XMLAttributes></dataItem><dataItem name="Gift Amount" aggregate="total"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">[Advancement].[Gifts].[Gift Amount]</expression><XMLAttributes><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataType" value="2" output="no"/><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataUsage" value="fact" output="no"/></XMLAttributes></dataItem><dataItem name="Gift Receive Date" aggregate="none" rollupAggregate="none"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">[Advancement].[Gifts].[Gift Receive Date]</expression><XMLAttributes><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataType" value="7" output="no"/><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataUsage" value="identifier" output="no"/></XMLAttributes></dataItem><dataItem name="Gift Appeal Code" aggregate="none" rollupAggregate="none"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">[Advancement].[Gifts].[Gift Appeal Code]</expression><XMLAttributes><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataType" value="3" output="no"/><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Gift Designation Code" aggregate="none" rollupAggregate="none"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">[Advancement].[Gifts].[Gift Designation Code]</expression><XMLAttributes><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataType" value="3" output="no"/><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Gift Designation Description" aggregate="none" rollupAggregate="none"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">[Advancement].[Gifts].[Gift Designation Description]</expression><XMLAttributes><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataType" value="3" output="no"/><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Gift Form Code" aggregate="none" rollupAggregate="none"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">[Advancement].[Gifts].[Gift Form Code]</expression><XMLAttributes><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataType" value="3" output="no"/><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Gift Credit - Y/N" aggregate="none" rollupAggregate="none"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">[Advancement].[Gifts].[Gift Credit - Y/N]</expression><XMLAttributes><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataType" value="3" output="no"/><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Gift Status" aggregate="none" rollupAggregate="none"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">[Advancement].[Gifts].[Gift Status]</expression><XMLAttributes><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataType" value="3" output="no"/><XMLAttribute xmlns:xml="http://www.w3.org/XML/1998/namespace" name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem></selection>
---------------------------------------------------------------------------------------------------^
Answer:Adam,
This error was reported to me by Jan Yost. I can click on the Run arrow icon on the main screen beside the report name and it runs without error. But, if I try to open it in Report Studio, I get the error above. Should I open a ticket with Jenzabar? Or, do you have some suggestions on this first?
Should have included Jan's email below where she gave the file location:
Is something going on with cognos right now? I am trying to run the report Monthly Donors in Public Folders/Advancement Report/Current Advancement Report. It returns the error RSV-BBP-0031 The request was improperly signed. With no details of course. I am pretty sure I have run this before and it worked.
Jan,
I reviewed the error. It appears that this error is only displayed in Internet Explorer. When you access Report Studio in either Chrome or Firefox the error does not present itself. Therefore, as a workaround, for now, I would edit this report using Report Studio in Chrome or Firefox. Sylvia will be submitting a ticket to Jenzabar to see how to resolve the issue you are experiencing with Internet Explorer. Thanks.
Adam Skiles
Director of Information & Technology Services
Jan,
We tested in both Firefox and Chrome and did not have any errors on our end. I will give you a call to run a support session and see what may be causing the issue for you.
Adam Skiles
Director of Information & Technology Services
I re-ran the report using Firefox (which I am 99% sure I used on Thursday) from the page Explorer-Run Report - Excel 2007. Then I re-ran within the last query, and then from the first query (view tabular data). Each time I still received the original error from last week.
I was able to run a different report with no problems.
Jan,
I will give you a call to test out the problem. Thanks.
Adam Skiles
Director of Information & Technology Services
Adam,
I already submitted a ticket with Jenzabar on this. I failed to put their response here. Doing that now.
Hi Sylvia,
On this one, since they can use Firefox and Chrome with no issues, the issue must be in IE.
Attached is documentation on settings in IE.
Please check this out on their IE and let me know if this resolves the issue.
Thank you,
Janet
Incident 397691
Caller: Sylvia Reed Huntington University
Phone: 260-359-4124
Summary: Cognos Error when using Internet Explorer
Click here to view this call in the ITSM Portal
Added by Reed, Sylvia on Friday, October 20, 2017 1:37 PM
Summary: Cognos Error when using Internet Explorer
A Cognos Report that has worked before is now returning an error in IE. THe report is named "Monthly Donors" in Public Folders/Advancement Report/Current Advancement Report. It returns the error RSV-BBP-0031 The request was improperly signed. With no details of course.
The larger error I received is below. The report will still run. But, if you try to open it in Report Writer you get the error in IE but not in Firefox or Chrome. Please advise.
Out of the box, Internet Explorer will block Cognos running a report as Excel. Also it will hobble some of Cognos’s abilities.
These instructions show you how to set Internet Explorer 8, 9, 10 or 11 to work best with Cognos.
Note: This edits security settings on your Intranet. You will need to have Admin permissions to do this.
Getting to Internet Options a) Open Internet Explorer
b) Click ‘Tools’ on the Menu bar
If you don’t see the Menu bar below the Address bar, tap the Alt key on your Keyboard (To save screen space IE hides the Menu bar)
c) Click ‘Internet Options’ (it’s the bottom item on the ‘Tools’ menu)
Assigning Cognos to your Trusted Sites To help keep our Internet Security settings secure, we will be adding Cognos to Trusted sites. This will let us not change how IE handles most websites, only those we assign as trusted.
a) Click the ‘Security’ tab
b) Click the ‘Trusted sites’ Icon
c) Click the ‘Sites’ button
d) Uncheck the box by “Require server verification…” if it is checked.
e) In the ‘Add this website to the zone:’ box type *://cognos.graceland.edu and click the ‘Add’ button
This will make it so both https:// and http:// forms of cognos.graceland.edu are supported
f) If any other cognos.graceland.edu addresses are in the ‘Websites:’ list click on them and click the ‘Remove’ button
g) Click the ‘Close’ button to close the ‘Trusted Sites’ window
Setting the Security Level Now we need to tell Internet Explorer how to handle the settings for our Trusted Sites
a) Under the ‘Security level for this zone’ click the ‘Custom level…’ button
b) Make sure the following settings are set:
1 ‘Downloads’ à ‘File download’: Enable
This allows you to have file downloads
2 ‘Miscellaneous’ à ‘Display Mixed Content’: Enable
This allows you to see images from both secure and unsecure websites (many images are hosted on an unsecure website so you can see them)
3 ‘Miscellaneous’ à ‘Launching applications and unsafe files’: Prompt
This allows you to have Excel Downloads when File Downloads is Enabled
4 ‘Miscellaneous’ à ‘Use Pop-up Blocker’: Disable
This prevents Cognos from blocking File download Pop-ups (Authors: it also allows you to open some studios)
5 ‘Scripting’ à ‘Enable XSS Filter’: Disable
XSS Filtering is a security feature of Internet Explorer. Not all websites work with it, and a few features of Cognos do legitimate Cross-Site Scripting (XSS). We don’t want IE getting in the way of this legitimate use.
c)
| If you use one of the following Studios to create (author) reports, then YES you are an author! Query Studio Analysis Studio Report Studio Business Insight Advanced |
| Am I an “Author” ? |
2 ‘Scripting’ à ‘Allow Programmatic clipboard access’: Enable
This makes it so you don’t have to answer the question about letting a Studio have access to your clipboard every time you launch it (such as Report Studio)
d) Click the ‘OK’ button to close the ‘Security Settings – Trusted Sites Zone’ window
Finishing Up and Note about Pop Up blockers a) Click the ‘OK’ button to close the ‘Internet Options’ window
b) Close all Internet Explorer windows and reopen Internet Explorer
c) Note: If the next time you try to download an Excel file, it is still blocked, you may have 3rd Party Pop-Up blockers installed, such as Bing, Yahoo, or Google toolbars. You will need to adjust settings in each of these.
IE 10 & 11 settings a) Click ‘Tools’ on the Menu bar
If you don’t see the Menu bar below the Address bar, tap the Alt key on your Keyboard (To save screen space IE hides the Menu bar)
b) Click ‘Compatibility View”
c) Certain features in Cognos 10.1.1 will not work with IE 10, such as Page Preview. It’s not a significant issue, but just be aware.