When I work/save in any session of baan, It gives one error message that

Error : Read row error 205 on <table name> (error 0)
Fatal error : Error 205 (Out of range) on select

I noticed that it comes in all sessions which contains date field. Also I note down the events occured.

Event-1:
Event Type: Error
Event Source: Baan
Event Category: <Unknown>
Event ID: 1000
Date: 10/23/2007
Time: 7:16:46 PM
User: ROLEX\baan
Computer: BAANSERVER
Description:
Env : baan (e:\baan)
Program : msql7 file dbs_data.c # 722
Keyword : Fill_column
Username : baan type:S language:2
Process : 1920
ProcessSet : baan@BAANSERVER:2452
Lasterror : 0
Errno : 0
BdbErrno : 0
Message : Fill column ddtb table dbo.ttdpur045888 data error.

Event-2
Event Type: Error
Event Source: Baan
Event Category: <Unknown>
Event ID: 1000
Date: 10/23/2007
Time: 7:16:46 PM
User: ROLEX\baan
Computer: BAANSERVER
Description:
Env : baan (e:\baan)
Program : msql7 file \MSQL\msql_data.c # 800
Keyword : Date out of range
Username : baan type:S language:2
Process : 1920
ProcessSet : baan@BAANSERVER:2452
Lasterror : 997 (Overlapped I/O operation is in progress.)
Errno : 0
BdbErrno : 0
Message :
dbs_errno = 205, Error 205 occurred:
bshell date -2147483648 (-2147483648 days) is not supported. The valid supported range of dates are from 02/01/1753 (639907 days) to 31/12/9999 (3652059 days) [dd/mm/yyyy].
DBMS Input: Data out of range for R_GTEQ on dbo.ttdpur045888.
Flushed at \MSQL\msql_row.c : #244.

Event-3
Event Type: Error
Event Source: Baan
Event Category: Bshell
Event ID: 1000
Date: 10/23/2007
Time: 7:16:46 PM
User: ROLEX\baan
Computer: BAANSERVER
Description:
Env : baan (e:\baan)
Program : bshell file bdb_fun.c # 1127
Keyword : DB error
Username : baan type:S language:2
Process : 2452
ProcessSet : baan@BAANSERVER:2452
Lasterror : 0
Errno : 0
BdbErrno : 205 (Out of range)
Message : Error 205 (Out of range) on SELECT

can anybody help, my system is down right now.

Thanks

I am not sure if this will help but Whats the System Date Format? Is it because of a format mismatch at DB level?

sk

1. bse$:\tmp --> delete unnecessary file
2. Check u'r database
3. restart u'r baan services.

Hi all,


My problem is not solved even i got the same problem as nilesh as mentioned above
its giving error 205 whenever date field is included in session
i have tried with the suggestions but not resolved


please help me in this regard
urgent requirement


thanks in advance
deepa

The problem seems not to be in the format, but in the content of a field of type date:


bshell date -2147483648 (-2147483648 days) is not supported. The valid supported range of dates are from 02/01/1753 (639907 days) to 31/12/9999 (3652059 days) [dd/mm/yyyy].


The date format is a long, so the database supports the limits -2147483648 and +-2147483649. But the data dictionary doesn't support it...
You have to find and correct the record ontaining this bad date, maybe thru ttaad4100 or in the oracle directly.