Query Builder scripts with runtime errors

[Jimduq]

New to Query Builder and trying to see how it will help us but when we try to query for example: long running reports or reports using specific folder, always get runtime error.
Are there specific indexes we should use, etc?

Examples of queries:
select si_name,
si_parent_folder_cuid,
si_starttime,
si_endtime
from ci_infoobjects
where si_kind = 'CrystalReport'
and si_instance = 1
and si_parent_folder_cuid = 'AavN8Dlwl01HhM1WXNx.2O8'
and si_description like '%Monthly%'
and si_starttime >= '2011/01/01-10 :00 :00'
and si_starttime <= '2011/02/01-02 :00 :00'

select si_name,
si_parentid,
si_parent_folder
from ci_infoobjects
where si_kind = 'CrystalReport'
and si_instance = 1
and si_calendar_template_id = 1643732

 

[Turkbear]

Hi,
What runtime error is being reported?

Are you using the Query Builder 'click to select fields' method of building the query or manually writing it?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Jimduq]

My error is as follows. I am writing the query:

Server Error in '/businessobjects/Enterprise115/WebTools' Application.
________________________________________
Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

 

[Turkbear]

Hi,
Try running it on the server to get the detailed error - the queries do not seem to have any obvious flaws unless some of those items are not in the InfoObjects collection
or the where clauses are not parseable by Query Builder ( it is a rather specialized query language, not standard SQL)





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[hilfy]

The queries look ok to me too. Also, there are no indexes or anything like that which you can specify on your queries. The vast majority of the data that you can query through Query Builder is stored in a binary format in a blob field. So, the SDK has to convert the binary format to something readable in order to read the specific properties you're referencing in your where clause. If you have a lot of objects (in the 100's of thousands) in your CMS, this is going to take a while and can cause timeout problems.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.