Focal Point
[CLOSED] (FOC1071) VALUE FOR JOIN 'TO' FIELD OUT OF SEQUENCE

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

November 12, 2014, 10:35 AM
SWES
[CLOSED] (FOC1071) VALUE FOR JOIN 'TO' FIELD OUT OF SEQUENCE
Hello,

I have generated a SQL table in my procedures. When I try to right-click the table and then 'Data Profiling' and then click 'Statistics', it is giving me the following error: (FOC1071) VALUE FOR JOIN 'TO' FIELD OUT OF SEQUENCE. RETRIEVAL ENDED

I have no problem opening the table and it gives me data. I can also do the 'Count' function or 'Key Analysis'.

What can I try to make 'Statistics' work again?

Thank you for your suggestions.

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


WebFOCUS 8105m
Windows 7, All Outputs

Member of the Benelux Usergroup
November 12, 2014, 02:35 PM
Clif
Does Data Profiling work for some tables and not others? If so please open a hottrack case and upload the synonym for the table that is problematic.

Your signature shows WebFOCUS 7703. If you are still running that release (which first came out in 2011) you may want to consider upgrading to the current production release. Data Profiling has been much enhanced since then.


N/A
November 13, 2014, 09:10 AM
SteveBW
Have you ensured that the second table of the JOIN, the 'TO' table, has been ordered by the key by which you are joining the tables together?


WebFOCUS 7.6
Windows, All Outputs