TheoMauger
Programmer
Hello,
I'm very new to Actuate so please forgive any obvious ingnorance..
I'm using Report Designer Professional v6 and am trying to optimise some reports that we generate. In order to so this I want to use 'set forceplan on' within the SQL run in order to make some large joins more efficient.
I've firstly found that you cannot append this directly to the SQL-part of the report design - I have to concatenate it in the VB script, where a method picks up the rest of the SQL.. On doing this, I can compile a .rox file and run it. However, on checking the status of the job in the Actuate web interface after a few minutes or so, its status is failed with the following error:
Status No: 1 :
Basic Error: 1011
Module: db.bas
Line: 180
Database Error
2: Error generated by the connected data source ...
63: ct_results(): user api layer: internal Client Library error: Read from the server has timed out.
The job was working before I tried to add forceplan into the SQL. Additionally, if I exectute the SQL query with forceplan set on directly in Sybase (i.e. not running it through Actuate), it works fine, so I know that that is correct on its own. So, is it just that Actuate doesn't like forceplan, or is there a setting or different way of doing things that I could try to get it to work?
Hope this makes sense and thanks in advance for any help!
Regards,
Theo
I'm very new to Actuate so please forgive any obvious ingnorance..
I'm using Report Designer Professional v6 and am trying to optimise some reports that we generate. In order to so this I want to use 'set forceplan on' within the SQL run in order to make some large joins more efficient.
I've firstly found that you cannot append this directly to the SQL-part of the report design - I have to concatenate it in the VB script, where a method picks up the rest of the SQL.. On doing this, I can compile a .rox file and run it. However, on checking the status of the job in the Actuate web interface after a few minutes or so, its status is failed with the following error:
Status No: 1 :
Basic Error: 1011
Module: db.bas
Line: 180
Database Error
2: Error generated by the connected data source ...
63: ct_results(): user api layer: internal Client Library error: Read from the server has timed out.
The job was working before I tried to add forceplan into the SQL. Additionally, if I exectute the SQL query with forceplan set on directly in Sybase (i.e. not running it through Actuate), it works fine, so I know that that is correct on its own. So, is it just that Actuate doesn't like forceplan, or is there a setting or different way of doing things that I could try to get it to work?
Hope this makes sense and thanks in advance for any help!
Regards,
Theo