Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     OUT OF SEQUENCE Error

Read-Only Read-Only Topic
Go
Search
Notify
Tools
OUT OF SEQUENCE Error
 Login/Join
 
<Gauri>
posted
Hi, I am a new developer in the webfocus and we have webfocus 762.
I have a problem running a report, after runnig a report i get an error as
'(FOC1070) VALUE FOR JOIN 'FROM' FIELD OUT OF SEQUENCE. RETRIEVAL ENDED'
without a line # mentioned in the error.
The join is of 2 Holf Files.
Let me out few lines of code here,
-*------------------
JOIN
INNER
GL_TRANS_TEMP.MASTER_ACCT IN GL_TRANS_TEMP TO GL_BALANCES.MASTER_ACCT IN GL_BALANCES AS JX2
END
-*------------------------
TABLE FILE GL_TRANS_TEMP
PRINT
AMT
BEGIN_BAL
END
-*---------------
i m getting the error here.
Can anybody put some light on this.....
Thanks in advance
Gauri
 
Report This Post
Leah
Virtuoso
posted Hide Post
quote:
JOIN
INNER
GL_TRANS_TEMP.MASTER_ACCT IN GL_TRANS_TEMP TO GL_BALANCES.MASTER_ACCT IN GL_BALANCES AS JX2
END

When joining files, they both must have the same sequnce or index order, if not you will get the error.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
<Gauri>
posted
Leah,
the index fields are in sequence. I am still getinng the error.
 
Report This Post
GinnyJakes
Expert
posted Hide Post
Leah is correct. Unless the HOLD files were created with a special output type, they are just flat files. Both files must be sorted by the MASTER_ACCT field.

The MASTER_ACCT description in the masters for each file must have the same format.

Please double check this.


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
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     OUT OF SEQUENCE Error

Copyright © 1996-2020 Information Builders