VERIFIED SOLUTION i
X

Resolve 'CException: XML corrupted attribute' error while selecting ALL values in plan prompt of Sagent Weblink

Issue

While executing the plan in Weblink, if <<ALL>> value selected in a plan prompt, error "CException: XML Corrupted attributes" is encountered.

Following scenarios are also observed:
  • Plan runs fine in Design Studio for all prompts.
  • In weblink, issue occurs only when we select <ALL> as prompt input.
  • If a particular value present in database, is input as prompt, result is as expected.
  • If any random value that is not present in database, is given in the prompt, there is no result. In this case, there is no error message as well.

Cause

Possible root cause for this issue could be any of the following:

1. ASP Buffer limit reached.
2. The call with <<ALL>> prompt value gets rejected by UrlScan 3.1 installed at C:\Windows\system32\inetsrv\urlscan\urlscan.dll” location on the machine and configured as ISAPI filters in IIS.

Resolution

UPDATED: June 21, 2017


Following are the steps to be performed in different scenarios respectively:

1. ASP Buffer limit reached:
  • Go to the Control Panel -> Administrative Tools -> Internet Information Services
  • Go to path: Home -> IIS -> ASP -> LIMITS PROPERTIES
  • Increase the value for "Response Buffering Limit" to maximum (It is an integer in the range from 0 to 2147483647 and the default value is 4194304)
  • Go to Command Prompt (Start -> Run -> cmd), type “iisreset”, to restart IIS.
User-added image
2. Rejection of <<ALL>> value by URL scan:
  • Go to the Control Panel -> Administrative Tools -> Internet Information Services
  • Go to path: Home -> IIS -> ISAPI Filters
  • Find URLScan in the list, click Remove button, then OK to save
  • Go to Command Prompt (Start -> Run -> cmd), type “iisreset”, to restart IIS.
Note - IIS log files default path is "%SystemDrive%\inetpub\logs\LogFiles". This can be confirmed under LOGGING feature of IIS.

Environment Details

Product Feature: Sagent Weblink Client

Downloads

  • No Downloads