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     [SOLVED] (FOC1426) DATA ELEMENT VALUE TOO BIG FOR SEGMENT/FIELD ON Date field in SQL

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] (FOC1426) DATA ELEMENT VALUE TOO BIG FOR SEGMENT/FIELD ON Date field in SQL
 Login/Join
 
Lusheng
Platinum Member
posted
I have a SQL (2008) table which has fields with data type "date". The adapter generated the master with USAGE=YYMD, ACTUAL=DATE for those fields. I can use MODIFY to load data into this table without issue, but when I use WebFOCUS TABLE FILE to query this table, it gave error message (FOC1426) DATA ELEMENT VALUE TOO BIG FOR SEGMENT/FIELD for those date fields. However the data looks good through SQL select statement.

I am using WebFOCUS 7.7.03M in Windows Server 2008, SQL server 2008. Any help is appreciated.

This message has been edited. Last edited by: <Kathryn Henning>,
 
Posts: 118 | Location: Omaha, NE | Registered: June 12, 2003Report This Post
njsden
Virtuoso
posted Hide Post
Strange. Does the same happen if you open the synonym definition with the Synonym Editor and click the "Sample data" button?

Perhaps you can try using SQL passthru to read and temporarily hold your data to further analyze what WebFOCUS is "seeing":

SQL SQLMSS
select your_date_field 
  from your_table 
 where <any_filter_here>
;
TABLE ON TABLE HOLD AS HTEMP
END
-RUN
? HOLD HTEMP


I'd be interested to see:

1. If any errors are still raised when getting the data
2. If not, which field definition was created for the date field in the masterfile associated with the HOLD file you just created (it will be visible in your browser right away).


Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
GamP
Virtuoso
posted Hide Post
Did you do the TABLE command with or without IF/WHERE statement on the date field?
If would help if you included the code you used that produced the error message ...


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Lusheng
Platinum Member
posted Hide Post
I resolved the issue. We have a FOCUS database with a same name resides in the SU machine, though that file was NOT in the app path. However we have USE command in eda profile to use databases in SU machine. That seems OK for MODIFY FILE, but not for TABLE FILE. MODIFY FILE seems to search file based on APP PATH, but USE command seems to have higher priority than APP PATH in TABLE FILE. Once I issued USE CLEAR * before that TABLE FILE, it works and it picks the file from APP PATH.

Thanks for all your responses!
 
Posts: 118 | Location: Omaha, NE | Registered: June 12, 2003Report This Post
njsden
Virtuoso
posted Hide Post
Glad you figured it our. Would you please edit your post and prefix it with [CLOSED]? Thanks.


Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report 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     [SOLVED] (FOC1426) DATA ELEMENT VALUE TOO BIG FOR SEGMENT/FIELD ON Date field in SQL

Copyright © 1996-2020 Information Builders