IDS Forum

RE: Intermittent Loss of eAuth Response Comments

Posted By: Knox, Ernest
Date: Thursday, 19 January 2012, at 5:02 p.m.

In Response To: Re: Intermittent Loss of eAuth Response Comments (Art Kagel)

IDS: 10.00.TC9X3
OS: MS Windows 2000 SP4
ODBC Driver: Informix 3.33 32 Bit Version 3.33.00.10688

Question: Is there a 2k limit on the text entered in the following field, w=
hich could be based on the IDS version or the ODBC driver version? It work=
s fine for data entered below 2k, but seems to be lost if greater than 2k.

fleet_cust_comment lvarchar=20

default null,

DBSCHEMA Schema Utility INFORMIX-SQL Version 10.00.TC9X3=20=20
Copyright IBM Corporation 1996, 2006 All rights reserved

{ TABLE "informix".cc_repair_rational row size =3D 4448 number of columns =
=3D 41 index=20

size =3D 14 }
create table "informix".cc_repair_rational=20
(

workorder_no char(7) not null ,

seq_no smallint not null ,

date_time_sent datetime year to second,

date_time_received datetime year to second,

epo_status char(1),

shc_comments lvarchar=20

default null,

fleet_cust_comment lvarchar=20

default null,

in_shop char(1),

towed_in char(1),

coupon_number varchar(20),

min_brk_pad_rf decimal(8,3),

min_brk_pad_rr decimal(8,3),

min_brk_pad_lf decimal(8,3),

min_brk_pad_lr decimal(8,3),

tire_tread_lf_in smallint,

tire_tread_lf_mid smallint,

tire_tread_lf_out smallint,

tire_tread_lr_in smallint,

tire_tread_lr_mid smallint,

tire_tread_lr_out smallint,

tire_tread_rf_in smallint,

tire_tread_rf_mid smallint,

tire_tread_rf_out smallint,

tire_tread_rr_in smallint,

tire_tread_rr_mid smallint,

tire_tread_rr_out smallint,

spare_tread_in smallint,

spare_tread_mid smallint,

spare_tread_out smallint,

roter_actual_sp_lf decimal(9,3),

roter_actual_sp_rf decimal(9,3),

roter_actual_sp_lr decimal(9,3),

roter_actual_sp_rr decimal(9,3),

eng_dia_code1 varchar(10),

eng_dia_code2 varchar(10),

eng_dia_code3 varchar(10),

eng_dia_desc1 varchar(50),

eng_dia_desc2 varchar(50),

eng_dia_desc3 varchar(50),

error_code smallint,

error_desc varchar(30),

primary key (workorder_no,seq_no) constraint "informix".ct_cc_repair_r=
a1
) extent size 32 next size 32 lock mode page;

Thanks,
*******************************************************************
Ernie Knox
IT Database=A0Administrator Specialist
Sears Holdings - BU: I & T Group
3333 Beverly Rd.
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Email: Ernest.Knox@searshc.com
Blackberry:=A02244650553@messaging.sprintpcs.com
Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com
Informix Primary: INFORMIXDBAPrimaryPager@searshc.com
Informix Secondary: INFORMIXDBASecondaryPager@searshc.com
MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com
MySQL Primary: MYSQLDBAPrimaryPager@searshc.com
MySQL Secondary: MYSQLDBASecondaryPager@searshc.com

" Yes we can make a Change! "
" It's always a great day to watch=A0Sports: "
" Lets GO Detroit: Lions, Tigers, Pistons, and Red Wings! "
" Lets GO Chicago: Bears, Cubs, White Sox, Bulls, and Black Hawks! "
GSU
*******************************************************************

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art K=
agel
Sent: Thursday, January 12, 2012 2:38 PM
To: ids@iiug.org
Subject: Re: Intermittent Loss of eAuth Response Comments [25912]

TRACE ON/OFF only works within stored procedures. Couple of options that I
see:=20

1. You can try the xtrace utility and see what it catches.=20

2. Try to catch the offending SQL using AGS Sentinel=20

3. See if iWatch from Exact-Solutions can work with 10.00 (don't=20

remember). If it does it will capture the update and the session details=20

of where the update came from.=20

Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/=20

Disclaimer: Please keep in mind that my own opinions are my own opinions an=
d do not reflect on my employer, Advanced DataTools, the IIUG, nor any othe=
r organization with which I am associated either explicitly, implicitly, or=
by inference. Neither do those opinions reflect those of other individuals=
affiliated with any entity with which I am affiliated nor those of the ent=
ities themselves.=20

On Thu, Jan 12, 2012 at 1:27 PM, Knox, Ernest <Ernest.Knox@searshc.com>wrot=
e:=20

> IDS: 10.00.TC9X3
>=20
> OS: MS Windows 2000 SP4
>=20
> =3D20
>=20
> Would the TRACE ON and TRACE OFF help in the below case?=20
>=20
> =3D20
>=20
> In a nutshell, we are intermittently losing the update to a column=20
> containing fleet management work order authorization comments. We know=20
> that the update initially occurs, but for unknown reasons the update=20
> does not stick or is somehow set to null later. There are no error=20
> return codes to indicate why. The problem can be recreated in the lab,=20
> and users would like to trace this in a lab environment.
>=20
> =3D20
>=20
> Is there an easy way to turn on a trace within Informix that might=20
> give us more information?
>=20
> =3D20
>=20
> It would be helpful to confirm that subsequent SQL is not setting the=20
> column to null after the update. We could not find any evidence of=20
> this in the application code ... just want to eliminate this for sure=20
> as a potential root cause.
>=20
> =3D20
>=20
> Thanks,
>=20
> *******************************************************************
>=20
> Ernie Knox
>=20
> IT Database Administrator Specialist
>=20
> Sears Holdings - BU: I & T Group
>=20
> 3333 Beverly Rd.=20
>=20
> Hoffman Estates, IL. 60179
>=20
> Office: (847) 286-5735
>=20
> Email: Ernest.Knox@searshc.com
>=20
> Blackberry: 2244650553@messaging.sprintpcs.com
> <mailto:2244650553@messaging.sprintpcs.com>=3D20
>=20
> Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com
>=20
> Informix Primary: INFORMIXDBAPrimaryPager@searshc.com
>=20
> Informix Secondary: INFORMIXDBASecondaryPager@searshc.com
>=20
> MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com
>=20
> MySQL Primary: MYSQLDBAPrimaryPager@searshc.com
>=20
> MySQL Secondary: MYSQLDBASecondaryPager@searshc.com
>=20
> =3D20
>=20
> " Yes we can make a Change! "=20
>=20
> " It's always a great day to watch Sports: "=20
>=20
> " Lets GO Detroit: Lions, Tigers, Pistons, and Red Wings! "=20
>=20
> " Lets GO Chicago: Bears, Cubs, White Sox, Bulls, and Black Hawks! "=20
>=20
> GSU
>=20
> *******************************************************************
>=20
> This message, including any attachments, is the property of Sears=20
> Holdings =3D Corporation and/or one of its subsidiaries. It is=20
> confidential and may cont=3D ain proprietary or legally privileged=20
> information. If you are not the inten=3D ded recipient, please delete it=
=20
> without reading the contents. Thank you.
>=20
>=20
>=20
>=20
***************************************************************************=
****=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20
>=20
>=20

--90e6ba6e89144e480204b659e1dc=20

***************************************************************************=
****
Forum Note: Use "Reply" to post a response in the discussion forum.=20

This message, including any attachments, is the property of Sears Holdings =
Corporation and/or one of its subsidiaries. It is confidential and may cont=
ain proprietary or legally privileged information. If you are not the inten=
ded recipient, please delete it without reading the contents. Thank you.

Messages In This Thread

• Intermittent Loss of eAuth Response Comments
  Knox, Ernest -- Thursday, 12 January 2012, at 1:27 p.m.
  • Re: Intermittent Loss of eAuth Response Comments
    John Miller iii -- Thursday, 12 January 2012, at 2:04 p.m.
  • Re: Intermittent Loss of eAuth Response Comments
    Art Kagel -- Thursday, 12 January 2012, at 2:37 p.m.
    • RE: Intermittent Loss of eAuth Response Comments
      Knox, Ernest -- Thursday, 12 January 2012, at 11:34 p.m.
    • Re: Intermittent Loss of eAuth Response Comments
      Neville Monteiro -- Thursday, 12 January 2012, at 11:45 p.m.
      • Re: Intermittent Loss of eAuth Response Comments
        Art Kagel -- Friday, 13 January 2012, at 5:41 a.m.
      • RE: Intermittent Loss of eAuth Response Comments
        Paul Watson -- Friday, 13 January 2012, at 6:00 a.m.
    • RE: Intermittent Loss of eAuth Response Comments
      Knox, Ernest -- Thursday, 19 January 2012, at 5:02 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.