Troubleshooting
Problem
While creating a new Cognos Analytics 11 Data Modules using Data Server with IIS Web Server Gateway. Click on (+) New -> Data Modules, selects Source as 'Data Servers' and selects the Data server i.e. datasource e.g.'great_outdoors_sales' and select on the schema user i.e. 'GOSALES/gosales'. The Select sources listed as 'GOSALES/gosales'. Click on Start button. Receive the error message '400: Bad Request' message with the option to Hide or Cancel.
Symptom
When creating a new Cognos Analytics 11 Data Modules using Data Server with IIS Web Server Gateway.
Click on (+) New -> Data Modules, selects Source as 'Data Servers' and selects the Data server i.e. datasource e.g.'great_outdoors_sales' and select on the schema user i.e. 'GOSALES/gosales'.
The Select sources listed as 'GOSALES/gosales'.
Click on Start button.
Receive the error message '400: Bad Request' message with the option to Hide or Cancel.
Workaround
----------
Create Data Module through Dispatcher URI instead i.e. <dispatcher_server>:<port>/bi/v1/disp
Cause
Using Microsoft IIS Webserver with .NET 4.0 framework with Request URLs with special character encoding for colons ":", HTTP Request validation prevents the URL POST.
The HTTP POST Request URL in the format -
'<web_server>:<port>/<website_alias>/bi/v1/metadata/base_modules/great_outdoors_sales:great_outdoors_sales:GOSALES:gosales?async=true' (<web_server>:<port>/<website_alias>/bi/v1/metadata/base_modules/great_outdoors_sales:great_outdoors_sales:GOSALES:gosales?async=true') with colons ":".
Environment
Microsoft IIS Web Server on Windows
Resolving The Problem
Within Microsoft IIS webserver, under the virtual directory alias web site directory, use Configuration Editor to set the following -
A. Using IIS Configuration Editor
---------------------------------
Within Configuration Editor, select the Section 'system.web/httpRuntime' and the From 'Default Web Site/<alias_website> Web.config' drop downs.
Set the following attributes -
requestPathInvalidCharacters=""
requestValidationMode="2.0"
Under the Section 'system.web/pages' and the From 'Default Web Site/<alias_website> Web.config' drop downs.
validateRequest="False"
Click 'Apply'.
Restart IIS web server.
OR
B. Update the 'web.config' file.
The above changes should be observed under the tags <system.web> and <pages>.
Add the following XML entries to the 'web.config' located under <analytics_install>/webcontent folder.
<system.web>
<httpRuntime requestPathInvalidCharacters="" requestValidationMode="2.0" />
<pages validateRequest="false" />
</system.web>
Restart IIS web server.
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21989770