[Info-ingres] Unexpected end of user data while filling domain

Anne O'Kelly

unread,

Dec 2, 2005, 12:29:26 PM12/2/05

to

Hi,

I have the following problem trying to copy a large table into a new database.

Is there any way I can edit the flat file to see what is on row 2018298??

Any suggestions welcome!

Thanks,

Anne

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

nl= d1)

from '/ohtest/ingres/002/aok_unload/ft_debit_and_credit.old'

with row_estimate = 4797450

Executing . . .

E_CO0040 COPY: Unexpected end of user data while filling domain

dc_actioned_date for row 2018298.

E_CO002A COPY: Copy has been aborted.

continue

* * set journaling on ft_debit_and_credit

Executing . . .

continue

*

Your SQL statement(s) have been committed.

Ingres Version II 2.6/0207 (su9.us5/02) logout

Fri Dec 2 17:19:58 2005

SunOS-otdba->

********************************************************************
This message is intended only for the use of the person(s) ("the intended recipient(s)") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by LGCSB (Local Government Computer Services Board).

Any attachments have been checked by a virus scanner and appear to be clean. Please ensure that you also scan all messages, as LGCSB does not accept any liability for contamination or damage to your systems.
********************************************************************

Peter Gale

unread,

Dec 3, 2005, 6:52:36 AM12/3/05

to

Hi Anne,

You can display the line using sed as follows

sed –n ‘2018298p’ ft_debit_and_credit.old

or a range either side the line using

sed –n ‘2018295,2018300p’ ft_debit_and_credit.old

Once you can see the problem then you can also use sed to edit the line. You will need to redirect the output to a new file. For example you may want to replace some part of the record with something new

sed ‘2018298s/old_string/new_string/’ ft_debit_and_credit.old > new_file

or add something to the end of the line

sed ‘2018298s/$/extra_bits/’ ft_debit_and_credit.old > new_file

Once the changes are made you can either swap the old file for the new or change the COPY statement to use the new file.

Peter Gale
Comprehensive Solutions (US)

Comprehensive Solutions International (UK)
T: +44 (0)1398 341777 M: +44 (0)7831 513181
PG...@Comp-Soln.co.uk www.Comp-Soln.co.uk

Henrik G. Sørensen

unread,

Dec 5, 2005, 8:20:19 AM12/5/05

to

For me it almost sounds like your running out off permitted pages on your 2K-page table meaning

Create the table on more than one location/spread the table on more than one location.

Kind regards, med venlig hilsen

Henrik Georg Sørensen
Organisator - Denmark

"Anne O'Kelly"
<AOK...@lgcsb.ie>
Sent by: To
info-ingres-admin@cari <info-...@cariboulake.com>
boulake.com cc

Subject
02-12-2005 18:29 [Info-ingres] Unexpected end of user data while

Ingres Forums

unread,

Mar 10, 2014, 3:27:15 AM3/10/14

to

Henrik G. =?ISO-8859-1?Q?S=F8rensen?=;16101 Wrote:
> For me it almost sounds like your running out off permitted pages on
> your 2K-page table meaning
>
> Create the table on more than one location/spread the table on more than
> one location.
>
> Kind regards, med venlig hilsen
>

> Henrik Georg S�rensen

Hi,

i am also getting same error .

but it get resolved now,

i would suggest ,please check the file you are trying to copy into
table(.csv,.txt)....etc

--
rahulrai
------------------------------------------------------------------------
rahulrai's Profile: http://community.actian.com/forum/member.php?userid=119642
View this thread: http://community.actian.com/forum/showthread.php?t=5651