Re: More: ORA-01013,

[Ram Venkat <moolyam@HOTMAIL.COM>]

an immediate workaround could be to connect directly to the server
instead of going thro the SQL NET.

(USERNAME / PASSWORD (without @connectstring or host string)

Ram Venkat

>From owner-sqr-users@list.iex.net Mon Jul  6 06:49:00 1998
>Received: from list.iex.net (list.iex.net [192.156.196.15]) by
list.iex.net (8.8.5/8.8.5) with SMTP id HAA17038; Mon, 6 Jul 1998
07:48:35 -0600 (MDT)
>Received: from LIST.IEX.NET by LIST.IEX.NET (LISTSERV-TCP/IP release
1.8b) with
>          spool id 5170023 for SQR-USERS@LIST.IEX.NET; Mon, 6 Jul 1998
07:48:28
>          +1800
>Received: from mail.iex.net (mail [192.156.196.5]) by list.iex.net
>          (8.8.5/8.8.5) with ESMTP id HAA17028 for
<sqr-users@list.iex.net>;
>          Mon, 6 Jul 1998 07:48:26 -0600 (MDT)
>Received: from mx04.netaddress.usa.net (mx04.netaddress.usa.net
>          [204.68.24.141]) by mail.iex.net (8.8.5/8.7.5) with SMTP id
HAA11254
>          for <sqr-users@mail.iex.net>; Mon, 6 Jul 1998 07:45:00 -0600
(MDT)
>Received: (qmail 11037 invoked by uid 0); 6 Jul 1998 13:47:54 -0000
>Received: from algoma.com [208.128.155.10] by mx04 via mtad (2.6) with
ESMTP id
>          mx04-cgFNv20154; Mon, 06 Jul 1998 13:47:53 GMT
>Received: by gateway.algoma.com id <27779>; Mon, 6 Jul 1998 09:49:19
-0400
>MIME-Version: 1.0
>Content-Type: text/plain; charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Mailer: Microsoft Outlook Express 4.71.1712.3
>X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
>Message-ID:  <98Jul6.094919edt.27779@gateway.algoma.com>
>Date:         Mon, 6 Jul 1998 09:50:24 -0400
>Reply-To: SQR-USERS@USA.NET
>Sender: "Discussion of SQR,
>              SQRiBE Technologies's database reporting language"
>              <SQR-USERS@list.iex.net>
>From: Paul Cruz <pcruz@ALGOMA.COM>
>Subject:      Re: More: ORA-01013, "user requested cancel of current
operation"
>X-To:         SQR-USERS@usa.net
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>
>Just adding my 2 cents..
>This is a known bug in Oracle RDBMS ver 7.2 ( not sure if it also exist
in
>7.3). We encountered this same problem on a script (not written in SQR)
that
>does the same thing, loading from a flat file. Oracle Support should be
able
>to provide you a patch for it.
>
>-----Original Message-----
>From: Eric Dimick Eastman <erice@ONTKO.COM>
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>Date: Sunday, July 05, 1998 6:18 PM
>Subject: Re: More: ORA-01013, "user requested cancel of current
operation"
>
>
>>Hello,
>>
>>I posted a message about this exact problem a while ago and have had
it
>>as an ongoing problem for the last year.  I get it while loading flat
>>files into Oracle.  There doesn't seem to be any rhyme or reason to
it.
>>I have worked around this problem by making my load programs robust.
>>I have a on-error clause on each begin-sql and begin-select that
prints
>>an error to a log file and puts the offending datafile lines in an
error
>>file to be re-run.  I get that error about 1 record per 100,000.
>>
>>I will continue to work on this problem, and if find anything out I
>>would love to hear it.
>>
>>Thanks,
>>Eric
>>
>>On Fri, 3 Jul 1998, jlwyant wrote:
>>
>>> All,
>>>
>>> Thanks to everyone who has already responded.
>>>
>>> As I mentioned early I'm passing this message on for a friend... I
have
>>> a few more details and now know that he did not press control-c or
any
>>> other cancelling operation. I do know that he is loading flat files
into
>>> Oracle. He has been able to load small tables with ten thousand
records
>>> or less. It is the larger loads that appear to quit with the
ORA-01013
>>> error. He informs me that after running the same SQR multiple times
it
>>> never errors in the same procedure or record count. I suggested as a
>>> wild guess that he try issuing a commit after say 500 hundred
inserts.
>>> My thinking here is the possibility of a full rollback segment.
>>>
>>> Thanks for all your help. Jim
>>>
>>
>>------------------------------------------------------------------------
>>Eric Dimick Eastman  |Ray Ontko & Co | This space for rent.
>>erice@ontko.com      |Richmond, IN   | Your opinion here.
>>http://www.ontko.com |               |
>


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com