Hi board,
I created a simple query using easy sql query functionality.
When I run the query, it throws the following error:
"Value dsnrows=1003 out of range" then "DS_REQERRMESS process terminated by display server".
I´m suspecting DS stands for Display Server.
Anybody have faced similar problem? Where I can set those variables to acceptable values in order avoid this problem?
Here is my query:

select
whwmd210.cwar, | Warehouse
whwmd210.item, | Item
tcibd001.citg, | Item Group
tcibd001.dsca, | Descripción
tcmcs023.dsca | Description
from
tcibd001, | Artículos generales
tcmcs023, | Item Groups
whwmd210 | Item Data by Warehouse
where
whwmd210.cwar >= whwmd210.cwar.f and
whwmd210.cwar <= whwmd210.cwar.t and
whwmd210.item >= whwmd210.item.f and
whwmd210.item <= whwmd210.item.t and
tcibd001.citg >= tcibd001.citg.f and
tcibd001.citg <= tcibd001.citg.t and
tcibd001.citg = tcmcs023.citg and
whwmd210.item = tcibd001.item
order by whwmd210.item

I assume there must be something in the data. Try to run the report in debug mode, continue and examine the variables and function stack after you hit the error.

I would also check to see if any of the LOG files had any other errors. If I ran into some errors like this I would also break down the query to 1 table only (like whwmd210) see if it works fine, then add in second table (like tcibd001) see if there is an error. I have found sometimes the baan driver to oracle does it own thing.