Query exceeded fixed time limit: . (IES 10902) UNX Compatibilityb with BO 4.1

[former_member360582]

Hi

We have converted a Universe from UNV to UNX format.

Our database is Teradata.

But after converting this,we are getting error

Query Exceeded Fixed time limit : (IES 10902)   only after query the webi report from the newly converted UNX.

Just wanted to update that this converted UNX is working for BO 4.0

So is there any setting which needs to be done at BO side .

Regards

Gaurav.

[Former Member]

Hi,

The logical steps to debug such issue are:

• Open your report, Edit Query and then view script.
• take the SQL generated statement and run it on your DB client.
• If it works fine then we don't have any issue or restriction on database. If not, then we have something wrong need to be fixed on database.
• Run the query by creating a new Query in Business Layer by using exactly dimensions and measures & filters that you are using in your report. if you face an issue then check the Universe limits properties.
• If everything is ok then you need to check your report query properties.

Hope that helps...

Taha M. Mahmoud, PMP, ITIL, TOGAF, CSM
Senior BI consultant
EJADA Systems Company Limited
Mobile: + (966 50) 725 6498
E-Mail: tabouelfootooh@ejada.com

1. P. O. Box: 67372, Riyad 11596, KSA

Author of: Creating Universes with SAP BusinessObjects

[Former Member]

Gaurav,

Maybe this note applies to you: 1972096 - "Query exceeded fixed time limit: . (IES 10902)" when runnig a Web intelligence query base....

The steps to resolve are:

1. Edit teradata.sbo under C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\odbc

2. Go to the line <Parameter Name="Cost Estimate Available">True </Parameter>

3. Change True to False

4. Save and close the file

5. Restart servers

[nscheaffer]

What is the "Limit execution time" setting on the Query Options tab of the Business Layer of the universe set to?  Maybe that needs to be increased.

Does that help?

Noel

[Former Member]

Hi Neol,

There are two places, where you can set query execution time,

One in IDT which you already know and second you can define the same in webi query properties i.e. max query retrieval time in seconds.

Try to un-check both option and see if you are able to run your query.

Regards,

Priyank Bhayani

[former_member190895]

Hi All,

Again we have faced the same issue. As there are two properties as below:

1) One in IDT which you already know  - This is unchecked

2)Yu can define the same in webi query properties i.e. max query retrieval time in seconds. -This is unchecked

Still the issue exist.

[Former Member]

Hi,

Can you confirm following,

• Confirm there is no restriction applied at database level.
• Check you are able to run query in IDT.

Can you also share error screenshot and also mention the duration after which you get error.