Re: FW: d/w informix extract scripts

Posted in 2004

Topics: Transactions, Locking & Isolation, Migration, Import/Export & Data Conversion

Paul Watson — Mon, 19 Apr 2004 16:32:15 +0100 — source: Usenet: comp.databases.informix

There is a lock on one of the tables "McCabe-Reed, Barbara SIK" wrote: > > Can someone indicate what is going on with the below error that the users > are receiving? Thanx. > > > -----Original Message----- > > From: Nash, Laurie SIK > > Sent: Monday, April 19, 2004 10:32 AM > > To: McCabe-Reed, Barbara SIK; Berlenbach, Elizabeth C SIK > > Cc: Guliano, Christine A SIK; Nash, Laurie SIK > > Subject: FW: d/w informix extract scripts > > > > Barbara, > > > > > > Below is the message we get that stops the extract from completing. > > > > 244: Could not do a physical-order read to fetch next row. > > Error in line 123> > Near character position 20 > > > > > > > > > > The sql that executes are simple extracts, such as: > > > > select a.*, order_no > > from fourgen.stoshipd a, fourgen.stoordre b > > where a.doc_no = b.doc_no > > > > Does this help any?? > > > > > > -----Original Message----- > > From: Guliano, Christine A SIK > > Sent: Monday, April 19, 2004 10:21 AM > > To: Nash, Laurie SIK > > Subject: d/w informix extract scripts > > > > > > Laurie, > > This is the message we see when we get the row lock condition: > > > > > > 244: Could not do a physical-order read to fetch next row. > > Error in line 123> > Near character position 20 > > > > > > Below are the extract jobs method of data retrieval: > > > > > > Job A50EO15E order header extract uses: > > > > This script will start sql * > > /sikorsky/pgmY/aix/fgen/sik/vers10/sql/stoordre.sql > > Sql to run > > unload to /local/tmp1/stoordre.dat> > > > > > Job A50EO14E order line extract uses: > > > > This script will start sql * > > /sikorsky/pgmY/aix/fgen/sik/vers10/sql/stoordrd.sq > > Sql to run > > unload to /sikorsky/pgmY/aix/fgen/sik/vers10/data/stoordrd.dat> > > > > > Job A50EO18E order shipment extract uses: > > > > This script will start sql * > > /sikorsky/pgmY/aix/fgen/sik/vers10/sql/stoshipd.sq > > Sql to run > > unload to /sikorsky/pgmY/aix/fgen/sik/vers10/data/stoshipd.dat> > > > > > Please let me know what you find out. Thanks. > > > > > > > > Regards, > > Christine Guliano > > Spares Group > > Sikorsky Aircraft - Information Technology > > Ext. 6-5020 E-mail cguliano@sikorsky.com > > Phone 203-386-5020 > > E-fax 860-998-4869 > > > sending to informix-list -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

↪ replying to Paul Watson

David Williams — Mon, 19 Apr 2004 19:57:47 +0100 — source: Usenet: comp.databases.informix

"Paul Watson" <paul@oninit.com> wrote in message news:4083F0FF.72A5C18F@oninit.com... > There is a lock on one of the tables > There is no isam error listed so we cannot be sure...get the person to list the isam error as well. > "McCabe-Reed, Barbara SIK" wrote: > > > > Can someone indicate what is going on with the below error that the users > > are receiving? Thanx. > > > > > -----Original Message----- > > > From: Nash, Laurie SIK > > > Sent: Monday, April 19, 2004 10:32 AM > > > To: McCabe-Reed, Barbara SIK; Berlenbach, Elizabeth C SIK > > > Cc: Guliano, Christine A SIK; Nash, Laurie SIK > > > Subject: FW: d/w informix extract scripts > > > > > > Barbara, > > > > > > > > > Below is the message we get that stops the extract from completing. > > > > > > 244: Could not do a physical-order read to fetch next row. > > > Error in line 123> > > Near character position 20 > > > > > > > > > > > > > > > The sql that executes are simple extracts, such as: > > > > > > select a.*, order_no > > > from fourgen.stoshipd a, fourgen.stoordre b > > > where a.doc_no = b.doc_no > > > > > > Does this help any?? > > > > > > > > > -----Original Message----- > > > From: Guliano, Christine A SIK > > > Sent: Monday, April 19, 2004 10:21 AM > > > To: Nash, Laurie SIK > > > Subject: d/w informix extract scripts > > > > > > > > > Laurie, > > > This is the message we see when we get the row lock condition: > > > > > > > > > 244: Could not do a physical-order read to fetch next row. > > > Error in line 123> > > Near character position 20 > > > > > > > > > Below are the extract jobs method of data retrieval: > > > > > > > > > Job A50EO15E order header extract uses: > > > > > > This script will start sql * > > > /sikorsky/pgmY/aix/fgen/sik/vers10/sql/stoordre.sql > > > Sql to run > > > unload to /local/tmp1/stoordre.dat> > > > > > > > > Job A50EO14E order line extract uses: > > > > > > This script will start sql * > > > /sikorsky/pgmY/aix/fgen/sik/vers10/sql/stoordrd.sq > > > Sql to run > > > unload to /sikorsky/pgmY/aix/fgen/sik/vers10/data/stoordrd.dat> > > > > > > > > Job A50EO18E order shipment extract uses: > > > > > > This script will start sql * > > > /sikorsky/pgmY/aix/fgen/sik/vers10/sql/stoshipd.sq > > > Sql to run > > > unload to /sikorsky/pgmY/aix/fgen/sik/vers10/data/stoshipd.dat> > > > > > > > > Please let me know what you find out. Thanks. > > > > > > > > > > > > Regards, > > > Christine Guliano > > > Spares Group > > > Sikorsky Aircraft - Information Technology > > > Ext. 6-5020 E-mail cguliano@sikorsky.com > > > Phone 203-386-5020 > > > E-fax 860-998-4869 > > > > > sending to informix-list > > -- > Paul Watson # > Oninit Ltd # Growing old is mandatory > Tel: +44 1436 672201 # Growing up is optional > Fax: +44 1436 678693 # > Mob: +44 7818 003457 # > www.oninit.com #