Read table causes break in pgm non numeric data - index (AREV Specific)
At 13 MAR 2009 02:39:06PM Ted Archibald wrote:
Client has AREV 3.12 and OI8 system. Huge inventory system.
Major table called PROD has Relational and XREF indexes
One program, and only this program, sometimes crashes with a Non numeric data error. The line that crashed is the READ PROD.
We investigated and find nothing and re-run the program and it runs properly. This seems to happen on the first read (not verified)
This happens only with this table (PROD), this program (CV_POST) and on any workstation the program was launched on. We have reviewed this program and we see nothing strange.
We have removed and reloaded all indexes - crash still happens.
We suspect that there may be some data in one of the indexes that is causing the index to fail but if this was the case then wouldn't the abend happen for ALL reads? What would cause this to crash only occasionally?
Interesting problem.
Anybody have any ideas?
Cheers - Ted
At 13 MAR 2009 03:16PM Ted Archibald wrote:
Ok now we are getting this problem for same table but different programs.
This is now becoming a serious problem.
Help
At 14 MAR 2009 11:43PM Eric wrote:
The fact that file operation (read) breaks suggests that the indexing may be failing.
First, remove all indexes.
Second, programmatically remove any null keys from each table, and any keys that have delimiters (char 250-255) in the key.
Third rebuild the indexes.
Another possibility is an out-of-memory condition (say if the read pops available memory limits).
At 16 MAR 2009 01:31PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
We would suspect a problem in a custom MFS - we have seen similar to do with the allocation of labelled common and different behaviour between OI and AREV. Our memory is regretfully a bit woolly on this at this point.
World leaders in all things RevSoft
