v11.50.fc6 - dbload problem
A user found that a dbload command file (delimited file, insert with literal values mixed with f01..f05 fields) failed with error -846 under IDS 11.50.FC6, although the identical file and table loaded fine on 11.50.FC5; copying the FC5 dbload binary onto the FC6 server also worked. IBM's John Miller identified it as known defect IC66043, and another poster confirmed he had reported it and been told it was fixed in xC7. Workarounds: request a patch from support, use the older dbload binary, or wait for FC7. The poster chose to wait.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello ... I am running the following command file in v11.50.fc6
file '../data/NDC.txt'
delimiter '|' 6 ;
insert into drug
(drug_num,
ndc,
drug_label_name,
drug_gnn,
gpi,
origin_id,
load_batch_id)
values (f01,f02,f03,f04,f05,'RXENT',1003221018);
When doing this I get a -846 error. The same data file, same table in
v11.50.fc5 works fine ...
I copied the v11.50.fc5 dbload executable over to the v11.50.fc6 server,
and the dbload runs fine. Has anyone else seen this behavior. If so, do
you know if it's been reported to IBM as a bug? Guess I will need to do
that if it hasn't been ...
Peter
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
This is defect IC66043. Hope it helps.
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 03/22/2010 09:59:23 AM:
> Hello ... I am running the following command file in v11.50.fc6
>
> file '../data/NDC.txt'
>
> delimiter '|' 6 ;
>
> insert into drug>
> (drug_num,
>
> ndc,
>
> drug_label_name,
>
> drug_gnn,
>
> gpi,
>
> origin_id,
>
> load_batch_id)
>
> values (f01,f02,f03,f04,f05,'RXENT',1003221018);
>
> When doing this I get a -846 error. The same data file, same table in
> v11.50.fc5 works fine ...
>
> I copied the v11.50.fc5 dbload executable over to the v11.50.fc6 server,
> and the dbload runs fine. Has anyone else seen this behavior. If so, do
> you know if it's been reported to IBM as a bug? Guess I will need to do
> that if it hasn't been ...
>
> Peter
>
> Peter Logan
> Senior Database Administrator
> Phone: 616/878-8309
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Thanks ...
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
From:
"John Miller iii" <miller3@us.ibm.com>
To:
ids@iiug.org
Date:
03/22/2010 01:11 PM
Subject:
Re: v11.50.fc6 - dbload problem [19375]
Sent by:
ids-bounces@iiug.org
This is defect IC66043. Hope it helps.
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 03/22/2010 09:59:23 AM:
> Hello ... I am running the following command file in v11.50.fc6
>
> file '../data/NDC.txt'
>
> delimiter '|' 6 ;
>
> insert into drug>
> (drug_num,
>
> ndc,
>
> drug_label_name,
>
> drug_gnn,
>
> gpi,
>
> origin_id,
>
> load_batch_id)
>
> values (f01,f02,f03,f04,f05,'RXENT',1003221018);
>
> When doing this I get a -846 error. The same data file, same table in
> v11.50.fc5 works fine ...
>
> I copied the v11.50.fc5 dbload executable over to the v11.50.fc6 server,
> and the dbload runs fine. Has anyone else seen this behavior. If so, do
> you know if it's been reported to IBM as a bug? Guess I will need to do
> that if it hasn't been ...
>
> Peter
>
> Peter Logan
> Senior Database Administrator
> Phone: 616/878-8309
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
I've run into the same thing. I did report it to IBM as a bug. I just got
confirmation that it's fixed in xC7.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Peter_Logan@spartanstores.com
Sent: Monday, March 22, 2010 11:59 AM
To: ids@iiug.org
Subject: v11.50.fc6 - dbload problem [19372]
Hello ... I am running the following command file in v11.50.fc6
file '../data/NDC.txt'
delimiter '|' 6 ;
insert into drug
(drug_num,
ndc,
drug_label_name,
drug_gnn,
gpi,
origin_id,
load_batch_id)
values (f01,f02,f03,f04,f05,'RXENT',1003221018);
When doing this I get a -846 error. The same data file, same table in
v11.50.fc5 works fine ...
I copied the v11.50.fc5 dbload executable over to the v11.50.fc6 server, and
the dbload runs fine. Has anyone else seen this behavior. If so, do you know
if it's been reported to IBM as a bug? Guess I will need to do that if it
hasn't been ...
Peter
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
<html>
<body>
<font size="1">
Teleformix Confidentiality Statement and Notice: This message and any
associated files are covered by the Electronic Communications Privacy Act, 18
U.S.C. 2510-2521. This message and any attached content are for INTENDED
RECEIPT ONLY. It may contain privileged or confidential information. If you
have received this communication in error, please delete all information both
electronic and hard copy. The information contained herein may contain
information that is privileged or confidential, and may be subject to
additional restrictions. If you are not the intended recipient you are hereby
notified that any dissemination, copying or distribution of this message, or
files associated with this message is strictly prohibited. If you are the
intended recipient or the employee or agent responsible for delivering this
communication to the intended recipient, you are hereby notified that any
unauthorized use, dissemination, distribution or copying of this communication
is strictly proh
ibited. All attached documents and files are classified CONFIDENTIAL and for
INTENDED RECIPIENT ONLY. If you need additional information or need to report
any incidents please call 630.285.6500. Your attention in this matter is
greatly appreciated.
</font>
</body>
</html>
Hopefully, 11.50.XC7 is JUST a pid drop and not another new feature release,
ala 11.50.XC6. Personally I hope that IBM gets back into the habit of having
each xC# just be bugfixes.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Jamie
Gedye
Sent: Monday, March 22, 2010 12:18 PM
To: ids@iiug.org
Subject: RE: v11.50.fc6 - dbload problem [19377]
I've run into the same thing. I did report it to IBM as a bug. I just got
confirmation that it's fixed in xC7.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Peter_Logan@spartanstores.com
Sent: Monday, March 22, 2010 11:59 AM
To: ids@iiug.org
Subject: v11.50.fc6 - dbload problem [19372]
Hello ... I am running the following command file in v11.50.fc6
file '../data/NDC.txt'
delimiter '|' 6 ;
insert into drug
(drug_num,
ndc,
drug_label_name,
drug_gnn,
gpi,
origin_id,
load_batch_id)
values (f01,f02,f03,f04,f05,'RXENT',1003221018);
When doing this I get a -846 error. The same data file, same table in
v11.50.fc5 works fine ...
I copied the v11.50.fc5 dbload executable over to the v11.50.fc6 server, and
the dbload runs fine. Has anyone else seen this behavior. If so, do you know
if it's been reported to IBM as a bug? Guess I will need to do that if it
hasn't been ...
Peter
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
<html>
<body>
<font size="1">
Teleformix Confidentiality Statement and Notice: This message and any
associated files are covered by the Electronic Communications Privacy Act, 18
U.S.C. 2510-2521. This message and any attached content are for INTENDED
RECEIPT ONLY. It may contain privileged or confidential information. If you
have received this communication in error, please delete all information both
electronic and hard copy. The information contained herein may contain
information that is privileged or confidential, and may be subject to
additional restrictions. If you are not the intended recipient you are hereby
notified that any dissemination, copying or distribution of this message, or
files associated with this message is strictly prohibited. If you are the
intended recipient or the employee or agent responsible for delivering this
communication to the intended recipient, you are hereby notified that any
unauthorized use, dissemination, distribution or copying of this communication
is strictly proh
ibited. All attached documents and files are classified CONFIDENTIAL and for
INTENDED RECIPIENT ONLY. If you need additional information or need to report
any incidents please call 630.285.6500. Your attention in this matter is
greatly appreciated.
</font>
</body>
</html>
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Peter.
You may contact support to get a patch.
Regards,
-Ping
----- Original Message ----
From: John Miller iii <miller3@us.ibm.com>
To: ids@iiug.org
Sent: Mon, March 22, 2010 12:11:21 PM
Subject: Re: v11.50.fc6 - dbload problem [19375]
This is defect IC66043. Hope it helps.
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 03/22/2010 09:59:23 AM:
> Hello ... I am running the following command file in v11.50.fc6
>
> file '../data/NDC.txt'
>
> delimiter '|' 6 ;
>
> insert into drug>
> (drug_num,
>
> ndc,
>
> drug_label_name,
>
> drug_gnn,
>
> gpi,
>
> origin_id,
>
> load_batch_id)
>
> values (f01,f02,f03,f04,f05,'RXENT',1003221018);
>
> When doing this I get a -846 error. The same data file, same table in
> v11.50.fc5 works fine ...
>
> I copied the v11.50.fc5 dbload executable over to the v11.50.fc6 server,
> and the dbload runs fine. Has anyone else seen this behavior. If so, do
> you know if it's been reported to IBM as a bug? Guess I will need to do
> that if it hasn't been ...
>
> Peter
>
> Peter Logan
> Senior Database Administrator
> Phone: 616/878-8309
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
I'll wait for fc7 ... Didn't have this in any production systems just yet
...
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
From:
"PING TANG" <ptang83@yahoo.com>
To:
ids@iiug.org
Date:
03/23/2010 09:36 AM
Subject:
Re: v11.50.fc6 - dbload problem [19388]
Sent by:
ids-bounces@iiug.org
Peter.
You may contact support to get a patch.
Regards,
-Ping
----- Original Message ----
From: John Miller iii <miller3@us.ibm.com>
To: ids@iiug.org
Sent: Mon, March 22, 2010 12:11:21 PM
Subject: Re: v11.50.fc6 - dbload problem [19375]
This is defect IC66043. Hope it helps.
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 03/22/2010 09:59:23 AM:
> Hello ... I am running the following command file in v11.50.fc6
>
> file '../data/NDC.txt'
>
> delimiter '|' 6 ;
>
> insert into drug>
> (drug_num,
>
> ndc,
>
> drug_label_name,
>
> drug_gnn,
>
> gpi,
>
> origin_id,
>
> load_batch_id)
>
> values (f01,f02,f03,f04,f05,'RXENT',1003221018);
>
> When doing this I get a -846 error. The same data file, same table in
> v11.50.fc5 works fine ...
>
> I copied the v11.50.fc5 dbload executable over to the v11.50.fc6 server,
> and the dbload runs fine. Has anyone else seen this behavior. If so, do
> you know if it's been reported to IBM as a bug? Guess I will need to do
> that if it hasn't been ...
>
> Peter
>
> Peter Logan
> Senior Database Administrator
> Phone: 616/878-8309
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.