Re: Online V7.11 problems

Mr. Munaf A.Razzak wrote: } } Hi, } I work in the manufacturing industry and use informix online. I have had a } peculiar problem which is that we have recently developed and want to } implement an application which uses Gupta SQL-Windows > I-Net > Informix } Online V7.11 (This denotes the type of connectivity also). Some bozo tried } to load data from flat files which was not a problem but in case of an error } in the data he used a WHENEVER ERROR err_routine and the err_routine tried } to put the error data in another table which in turn just kept looping and } made the engine crash (what the hell is that? yes, engine crash). } I tried my level best reducing transaction time, resourcse available, etc... } but the process never got timed out or interrupted and continued on till the } engine crashed. My local informix(india) have looked over the onconfig, } online.log and said "Yes, Tonto you have error, will be OK after upgrade to } 7.12. Will come in two weeks plus or minus ...". Sounds good, but my worry } is what if the engine crashes again and most of all I wait for two weeks } which is sunk time. } I was hoping somebody out there could relate to this and hopefully mail me } some help ... } } Thanks in advance ... } } Munaf A Razzak } email : g086mnf@bomplant3.appl.ge.com Hi Munaf! What kind of errors does the loader program looks at ( duplicate values ? ) (data integrity ?), I seems like your engine is experimenting the long transaction problem. Is the loader program written in gupta ? If this is a script, would you post it ?, I can't imagine that an upgrade to the engine would solution your problem, I mean it is a load of data with something checking !, may be the one who wrote the application made a mistake !!! Regards, ------------------------------ Mario Estrada | LESCO, S.A. Systems Engineer | ------------------------------