Focal Point
[CLOSED] FOC1070 all of the sudden

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/934104723

December 29, 2009, 09:10 AM
developing
[CLOSED] FOC1070 all of the sudden
Hi, Does anyone know why a fex that has run every week (via a Scheduled job) with no errors, all of the sudden returns the (FOC1070) VALUE FOR JOIN 'FROM' FIELD OUT OF SEQUENCE. RETRIEVAL ENDED error?

Thanks for your time.

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6.10, Windows Vista, Oracle, Output-Excel/PDF/HTML
December 29, 2009, 09:25 AM
GinnyJakes
I would look at the data as that would be the only variable. Something in the data is leading FOCUS to believe that the two sequential files you are joining are not in the same sequence.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google