Unable to "View More Failed Data" in IS - Table alias not found

[Former Member]

Hi all,

I have configured a scorecard in Information Steward. The failed records are stored in a database (Microsoft SQL Server 2008)

and it's possible to show these failed records via "view failed data" in Information Steward.

When I try to "view more failed data" as a next step, I'm getting the following error:

com.sap.isws.faileddata.FDException: Table alias not found. Response returned: <?xml version="1.0" encoding="UTF-8"?><ViewDataReply xmlns="http://www.sap.com/DataServices/ViewDataXSD" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns1="http://www.sap.com/DataServicesObjects/DataServicesObjectsXSD" xsi:schemaLocation="http://www.sap.com/DataServices/ViewDataXSD D:\ViewDataServer\XSD\ICC_ViewData\ViewDataReply.xsd"><ID>ViewData.ViewData.SharedSP1.235f209e-281c-4c5c-8cc7-27ca760ffaab</ID><Status><StatusCode>Success</StatusCode></Status><HeaderInfo><ns1:Column Name="TABLE_ALIAS" DataType="varchar" Size="30" ></ns1:Column></HeaderInfo></ViewDataReply>.(FDS-101)

Information Steward and Data Services are both up to date. Any ideas? Thanks in advance!

Hannes

[former_member308526]

Hi Hannes,

did you ever get this problem solved ?

[Former Member]

Allan,

Just to eliminate all possibilities, are you writing your failed records to a table via the highlighted option when you run 'Calculate Score'?

-Chaitanya

[former_member308526]

yes - and this is only a problem with views - not tables.

[former_member366064]

I'm having that same error message in IS 4.2

I found that (in my case) it is some kind of bug or glitch.  If I restart the server process (EIMAdaptiveProcessingServer) in the Central Management Console, then everything works and I can view failed data correctly.

After a few days, the problem comes back again and I have to restart the process again.

Mine is happening on SQL Server tables, not IS views.

[Parthis]

We do see similar error when users trying to "view more failed data" . The message we see in the screen is "Cannot view failed data because failed date connection is not configured.(UID-10040)"

But we already have that setup to our SQL server in Data Insight connection. As Hannes said, it happens only when user clicks on "View more".

We didn't try restarting the server process yet as per Alan.

[Former Member]

Hi Alan, I also tried this, but unfortunately it didn't help.

The error still occurs.

[former_member366064]

That's too bad.  I opened a support message with SAP for my problem scenario, but I have not received an answers from them.

[former_member366064]

Just to follow up on my particular case:  SAP did get back to me, and identified my problem as a bug that was fixed in Info Steward 14.2.2.553 "patch 2".

I installed that version/patch, and stopped getting the error every few days.   In the last 4 months since then, the error only happened one time, so I consider it a big improvement.

[former_member308526]

OK, We are on 14.2.3.514 - so they might reintroduced the error

[Former Member]

Additional information:

The problem only occurs when trying to "view more failed data" for a a rule linked to a view in IS.

If the rule is linked directly to a ECC-table or to a flat file, "view more failed data" will work properly.