Hi,

I'm getting a

"1263: A field in a datetime or interval value is incorrect or an illegal operation
specified on datetime field."

Error when trying to do a check on a replicate

[informix@rhea(10.173.1.21) ~]$ cdr check repl -m g_nzs060vmw10s -r olga_scorecard_nzs060vmw10s -a

Aug 17 2011 10:38:33 ------ Table scan for olga_scorecard_nzs060vmw10s start --------

Error returned from getRow: fetch of baseCursor_2
SQLCODE -1263 ISAM 0

Error Details:
1263: A field in a datetime or interval value is incorrect or an illegal operation
specified on datetime field.

Current Connection:conn5, Databaselga_scorecard@g_rhea
command failed -- SQL failure (195)
[informix@rhea(10.173.1.21) ~]$


I assume this means I have some kind of bad date in my olga_scorecard database, any ideas how I might find it?

I've tried various oncheck's but none found any issues...

rhea:
RHEL 4
Informix 11.50.UC5

g_nzs060vmw10s
RHEL5
Informix 11.70.FC2GE

[informix@rhea(10.173.1.21) ~]$ cdr list repl brief olga_scorecard_nzs060vmw10s

REPLICATE TABLE SELECT
----------------------------------------------------------------------------
olga_scorecard_nzs060vmw10s olga_scorecard@g_rhea:sdev.olga_scorecard SELECT * FROM olga_scorecard
olga_scorecard_nzs060vmw10s olga@g_nzs060vmw10s:sdev.olga_scorecard SELECT* FROM olga_scorecard

Cheers,

James Brunskill

[cid:image001.jpg (AT) 01CC5CD1 (DOT) 57336CD0]

Acting Process Information Team Lead

james.brunskill (AT) fonterra (DOT) com
Phone: +64 7 849 2411 (ext 77808)
MES Support: +64 7 849 7895
Fonterra Co-operative Group Limited
PO Box 459, Hamilton, 3240, Automation and Process Control, Fonterra Te Rapa, SH1, Hamilton, New Zealand


[cid:image002.png (AT) 01CC5CD1 (DOT) 57336CD0]


________________________________
DISCLAIMER
This email contains information that is confidential and which may be legally privileged. If you have received this email in error, please notify the sender immediately and delete the email. This email is intended solely for the use of the intended recipient and you may not use or disclose this email in any way.