ERR_WIS_30270 when refreshing report created by IDT

[Former Member]

I have created for testing first report using IDT. I have downloaded audit Universe and published on repository. When I'm trying refresh (using Rich Client) EventId data I received error:

An internal error occurred while calling 'processDPCommandsEx' API. (Error: ERR_WIS_30270) (WIS 30270)

When I limited EventID to 10 only I have received data. I have verified Universe Properties. Limit of rows is unchecked. Do you know what is going on?

[amitrathi239]

This is a generic error.is there any combined query in the report?

or try with one or two objects and see.

run the integrity check in universe  and check if objects are parsed or not.

[mhmohammed]

Hi Konrad,

It's interesting that you don't get that error when you restrict in Universe to get just 10 rows. Similar options (Max retrieval time and Max rows retrieved) exist in the Query Properties as well, which can be see from the Query Panel, please check if there's a restriction applied.

As Amit said, this is a generic error, please let us know if you tried to pull objects from different contexts, make sure you don't pull any incompatible objects. Please check to make sure that the Aggregate Navigation is setup properly.

As you've downloaded the Audit Universe, I assume that's from 's blog, please make sure that custom objects and/or filters created in the Universe can be parsed, in short, please check the Integrity of the Universe before creating a sample report against it.

Thanks,
Mahboob Mohammed

[Former Member]

Hi Mahboob,

I have tried get one object as I said (the query you will get below):

SELECT

  BOE_AUDIT.dbo.ADS_EVENT.Event_ID

FROM

  BOE_AUDIT.dbo.ADS_EVENT

As you see it is very simple query.

Probably it was downloaded from Mathew's site.Max retrieval time is unchecked...other options too. The other report (only with Event StartTime object) refreshed with the same error message but with Event Status only wihout any problems.

I will verify integrity of Universe

[Former Member]

Hi again,

I have verified Integrity of Universe. I received errors like those below:

Check Business Filter :

Failed to execute the expression for business object 'Object name LIKE'. Check the object properties

Check Business Object Expression:

Failed to execute the expression for business object 'Event Measures\Run Time\RUN Event Duration - avg'. Check the object properties

Failed to execute the expression for business object 'Event Measures\Run Time\RUN Event Duration - sum'. Check the object properties

Failed to execute the expression for business object 'Event Measures\Refresh Time\REFRESH Event Duration - avg'. Check the object properties

Failed to execute the expression for business object 'Event Measures\Refresh Time\REFRESH Event Duration - sum'. Check the object properties

Failed to execute the expression for business object 'Event Measures\Duration (ms)\Event Duration (ms) - sum'. Check the object properties

Check Join:

Invalid expression. Parsing of expression for the business object "ADS_EVENT_DETAIL_V2.Event_Detail_Type_ID=dbo.ADS_EVENT_DETAIL_TYPE_STR.Event_Detail_Type_ID" failed: Audit";"ADS_EVENT_DETAIL_V2.Event_Detail_Type_ID=dbo.ADS_EVENT_DETAIL_TYPE_STR.Event_Detail_Type_ID

but nothing related to ADS_Event directly. I just would like to receive only eventi_d which is stored in ADS_Event

[Former Member]

Another think. Select all rows take about 10 minutes using SQL Management Studio and receiving about 14 mln records. Maybe it could help.

[mhmohammed]

Hi Konrad,

That's a lot of records and obviously it'll fail when you run in Webi as you said it takes around 10mins and if the Max retrieval time restriction is set to 10 mins. Please try to add necessary filters to the report to bring less data. Ex. Filter on Report Name or Refresh Date or Report Folder or User Name or Universe Name or something else.

Thanks,
Mahboob Mohammed