Hi,
Last week we got a power-failure problem.
Our SUN server running Solaris 2.3 and Informix-Online 5.02
crashed. Since then we encounter 'strange' things; some
of them may have been there already, but were not noticed
before, but one is definitely new, i.e. it occurred after
the SUN re-booted :
** SQL Error on fetch Acdt_due_c: code -1262
** (file a_tts_cdt.ec, function Atts_cdt_loop, line 248)
** (Non-numeric character in datetime or interval.)
finderr -1262 gives:
-1262 Non-numeric character in datetime or interval.
The form of a DATETIME or INTERVAL literal is very limited. One may
contain only decimal digits and the allowed delimiters: the hyphen between
year, month, and day numbers; the space between day and hour; the colon
between hour, minute, and second, and the decimal point between second
and fraction. Any other characters, or these characters in the wrong order,
will be detected as an error.
This error is generated by an Esql/C application that retrieves
rows from a table, every n minutes. Before the power-failure there
was no error, but now there is! The program constructs a select;
the error occurs during the fetch. If we select the rows using
dbaccess: no problem. We tbcheck'ed the table: no problem.
Questions:
- what could be wrong with this table ?
- what should we do if we get an power-failure again ?
Thanks for any help
Robert Bos (rbos@hacktic.nl or rbo@dasc.nl)
P.S.: please reply via e-mail, as I don't have easy access to this
news-group!