UDA-QOS-0006 Error OCCURED WHEN VALIDATING THE REPORT

[rama83]

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

[vij]

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
:)

[rama83]

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

[vij]

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.

[rama83]

Hi Vij,

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

Regards,
Rama

[blom0344]

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?

[rama83]

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...............