RE: dbimport error - 1263.....
Hi,
Mi suggest may be considered "crazy", but in a migration from online
5 to online 7 over solaris I have the same error,
examining the unl files all seems look well, then I edit the .sql file and
move to the end the table witch produce the error.
For my stupor, the dbimport finish without errors!!
In other cases, the .unl have corrupted data (like negative values
in datetime...)
To find the corrupted data, look the number of rows loaded in the
table and look the .unl file from this point to down.
I hope these help you.
Gustavo Tobares
Administrador de Sistemas y DBA
Centro de Computos - Red Megatone
TE: 0342-4500972 - Fax: 0342-4500940
-----Mensaje original-----
De: darren@orcsoftware.com [mailto:darren@orcsoftware.com]
Enviado el: Mi'rcoles, 04 de Junio de 2003 10:49 a.m.
Para: informix-list@iiug.org
Asunto: dbimport error - 1263.....
All the full message is displayed as:
*** put loadcur
1263 - A field in a datetime or interval values is incorrect or an
illegal operation specified on datetime field
I am using Informix 9.30 and Solaris 8. I have tried to import this
database onto the server that the export was done from (changed it's
name) and 2 other servers running the same OS/Informix version but all
the while I get this same error.
I have looked at the archives of this group and I gather that the
solution will be found in the .unl files - but how can I tell which
ones I should be looking at to attempt to find the wrong entry?
Thanks for any advice you may be able to give.
D.
"Gustavo Tobares" <gtobares@redmegatone.com> wrote in message
news:bbl9a0$mkt$1@terabinaries.xmission.com...
>
> Hi,
>
> Mi suggest may be considered "crazy", but in a migration from online
> 5 to online 7 over solaris I have the same error,
> examining the unl files all seems look well, then I edit the .sql file and
> move to the end the table witch produce the error.
>
> For my stupor, the dbimport finish without errors!!
>
> In other cases, the .unl have corrupted data (like negative values
> in datetime...)
>
> To find the corrupted data, look the number of rows loaded in the
> table and look the .unl file from this point to down.
>
Check DBDATE env variable is set the same in both the export and import
environments.
> I hope these help you.
>
> Gustavo Tobares
> Administrador de Sistemas y DBA
> Centro de Computos - Red Megatone
> TE: 0342-4500972 - Fax: 0342-4500940
>
> -----Mensaje original-----
> De: darren@orcsoftware.com [mailto:darren@orcsoftware.com]
> Enviado el: Mi'rcoles, 04 de Junio de 2003 10:49 a.m.
> Para: informix-list@iiug.org
> Asunto: dbimport error - 1263.....
>
>
> All the full message is displayed as:
>
> *** put loadcur
> 1263 - A field in a datetime or interval values is incorrect or an
> illegal operation specified on datetime field
>
> I am using Informix 9.30 and Solaris 8. I have tried to import this
> database onto the server that the export was done from (changed it's
> name) and 2 other servers running the same OS/Informix version but all
> the while I get this same error.
>
> I have looked at the archives of this group and I gather that the
> solution will be found in the .unl files - but how can I tell which
> ones I should be looking at to attempt to find the wrong entry?
>
> Thanks for any advice you may be able to give.
>
> D.