Error saying "Error in the module RSQL accessing the database interface"
there is a standard program available for retrieving the assets for the given cost centres on the selection screen.
Our requirement is instead of cost centre we have to retrieve the assets for the given cost centre group.
We have to find all the cost centres available on the given cost centre group and its child nodes.
For all these cost centres we will be retriving the asset history data.
So we copied the standard program into another Y program and made the changes to it.
What's happening is if we give the top most Cose centre group node there are 16000 cost centres available . while retriving the asset history data for all these cost centres an runtime error occurs in a standard program saying
"Error in the module RSQL accessing the database interface, " DBIF_RSQL_INVALID_RSQL ".
The error occurs while executing the statement Fetch Next cursor in a standard Include program.
<b>This happens only if we give huge range of data. If we give small range of data it
Can anyone help me in this by saying why it occurs and what will be the solution for this.