Read table causes break in pgm non numeric data - index (AREV Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Read table causes break in pgm non numeric data - index (AREV Specific) ====
=== At 13 MAR 2009 02:39:06PM Ted Archibald wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
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
</QUOTE>
----

=== At 13 MAR 2009 03:16PM Ted Archibald wrote:  ===

<QUOTE>Ok now we are getting this problem for same table but different programs.

This is now becoming a serious problem.

Help

</QUOTE>

----

=== At 14 MAR 2009 11:43PM Eric wrote:  ===

<QUOTE>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).

</QUOTE>

----

=== At 16 MAR 2009 01:31PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:  ===

<QUOTE>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.



[url=http://www.sprezzatura.com]The Sprezzatura Group[/url]

[i]World leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=1A65A0AAB2F7081D8525757800667533|View this thread on the  forum...]]