Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: rama83 on 28 May 2009 09:48:29 AM

Title: UDA-QOS-0006 Error OCCURED WHEN VALIDATING THE REPORT
Post by: rama83 on 28 May 2009 09:48:29 AM
Hi All,

I am using cognos 8.2 software.When I am validating the report in Report Studio following error getting

UDA-QOS-0006 Error
UDA-SQL-0198 The maximum number of tables "31" in a request has been exceeded.

Please any one suggest me.

Regards,
Rama
Title: Re: UDA-QOS-0006 Error OCCURED WHEN VALIDATING THE REPORT
Post by: vij on 29 May 2009 03:30:45 AM
Hi rama83 ,
Please check the following and see it works or not ....

1)open the report in Report Studio
2)select the query(s) of the report in "Query Explorer"
in the properties pane search for entry "Use SQL With Clause"
3)set the value for this entry to "Yes"



hope it helps u


vij
:)
Title: Re: UDA-QOS-0006 Error OCCURED WHEN VALIDATING THE REPORT
Post by: rama83 on 29 May 2009 08:03:25 AM
Hi Thanks for ur replay,

I am applied what u say in the above but still the following error occured.

UDA-QOS-0006 Error
UDA-SQL-0198 The maximum number of tables "31" in a request has been exceeded.
QE-DEF-0459 CCLException
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-208'.
UDA-SQL-0198 The maximum number of tables "31" in a request has been exceeded.

Is there any limit for number of queries in report studio.

Please any one suggest me.

Regards,
Rama
Title: Re: UDA-QOS-0006 Error OCCURED WHEN VALIDATING THE REPORT
Post by: vij on 29 May 2009 08:19:20 AM
HI rama83 ,

did u try this one.......

This error comes from the database used. There is a limitation that prevent the use of redundant tables in the same query.
If the query subject is not referencing 31 tables: review and verify if inefficient SQL is not referencing these tables.

According to the requirements, create query subjects with less sub query subjects that are more efficient.

Review model and remodel.


Title: Re: UDA-QOS-0006 Error OCCURED WHEN VALIDATING THE REPORT
Post by: rama83 on 03 Jun 2009 03:40:55 AM
Hi Vij,

Thanks for your replay.
I am not getting what you say,Please can you explain more detail.

Regards,
Rama

Title: Re: UDA-QOS-0006 Error OCCURED WHEN VALIDATING THE REPORT
Post by: blom0344 on 03 Jun 2009 05:36:01 AM
Depending on the database that is being queried there is a limit to the complexity to the query that can be compiled on the database server. For instance SQL server 2005 has an upper limit of 256 tables addressed in a query. however, complexity plays a role. Very complex SQL will take this number down.

What database are you querying?

Title: Re: UDA-QOS-0006 Error OCCURED WHEN VALIDATING THE REPORT
Post by: rama83 on 03 Jun 2009 11:24:46 PM
Hi,

I am using SQL Server 2005.In the data base level we have 258 tables.I imported all the tables in to FM level.Your saying the SQL Server 2005 have limit of 256 tables.What i need to do.

Please any suggestions...............
Text only | Text with Images