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.

New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.

What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.

During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Truncated fieldname error?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Truncated fieldname error?
 Login/Join
 
Master
posted
We have a report that runs fine unless a user tries to use OLAP sorting on a particular column "Gross_Commission" in which case they get this error.


0 ERROR AT OR NEAR LINE 149 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC016) THE TRUNCATED FIELDNAME IS NOT UNIQUE: GROSS_COMMISSION
BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT


I've searched focal point on this, and added a
-SET FIELDNAME = NOTRUNC; to my report with no difference.

here's a snippet from the .fex
TABLE FILE MATRIX_COMM_TBL
SUM
EXT_SALES_DOLLARS_COMM/P11BM AS 'Sales,TY'
P1EXT_SALES_DOLLARS_COMM/P11BM AS 'Sales,LY MTD'
COMPUTE LYSALES_PERC/D12.2B% = ((EXT_SALES_DOLLARS_COMM- P1EXT_SALES_DOLLARS_COMM) / EXT_SALES_DOLLARS_COMM) * 100; AS '% of LY,Sales'
NET_COMMISSIONS/P11BM AS 'Net,Comm'
P1NET_COMMISSIONS/P11BM AS 'LY,Net,Comm'
GROSS_COMMISSION/P11BM AS 'Gross,Comm'
-*P1GROSS_COMMISSION/P11BM AS 'LY,Gross,Comm'
COMPUTE MARGIN_ACT_PERC/D12.2B% = ((EXT_SALES_DOLLARS_COMM- EXT_ACT_COST_COMM)/EXT_SALES_DOLLARS_COMM) * 100; AS 'Margin,Act %'
COMPUTE MARGIN_ACT/P11BM = EXT_SALES_DOLLARS_COMM- EXT_ACT_COST_COMM; AS 'Margin,Act $'
COMPUTE LY_MARGIN_ACT/P11BM = P1EXT_SALES_DOLLARS_COMM- P1EXT_ACT_COST_COMM; AS 'LYMargin,Act $'
COMPUTE MARGIN_PERCOFCHG/D12.2B% = (((EXT_SALES_DOLLARS_COMM-EXT_ACT_COST_COMM)- (P1EXT_SALES_DOLLARS_COMM-P1EXT_ACT_COST_COMM)) / (EXT_SALES_DOLLARS_COMM-EXT_ACT_COST_COMM)) * 100; AS 'Margin,% of,LY Margin'
-IF &CHR EQ 'BYMONTH' THEN GOTO BS_BYMONTH ELSE GOTO MY_ONE;
-BS_BYMONTH
BY HIGHEST YEARMONTH AS 'Month'

Has anyone else seen this before?


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
 
Posts: 611 | Registered: January 04, 2007Report This Post
Virtuoso
posted Hide Post
quote:
GROSS_COMMISSION


Is it possible your master has a field that starts with the characters GROSS_COMMISSION, that's usually when I get that type of error message when passing a define or compute.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
Guru
posted Hide Post
quote:
-SET FIELDNAME = NOTRUNC;


This should be
SET FIELDNAME=NOTRUNC


The '-SET' and ';' are used for amper variables. You are trying to change an environmental setting.


ttfn, kp


Access to most releases from R52x, on multiple platforms.
 
Posts: 346 | Location: Melbourne Australia | Registered: April 15, 2003Report This Post
Gold member
posted Hide Post
Hi Jason,

I think this error happens because you are using column reformatting:
quote:

GROSS_COMMISSION/P11BM

This causes WebFocus to actually 'code' the following behind the scenes:
GROSS_COMMISSION NOPRINT
COMPUTE GROSS_COMMISSION/P11BM = GROSS_COMMISSION;

Therefore you will have 2 columns with the same name and I guess this causes OLAP to get in trouble. Looks like a bug in OLAP.


Roland

Prod: WF 7.1.5
Test: WF 7.6.4
Unix Sun Solaris
HTML, PDF, EXL2K
 
Posts: 54 | Location: Switzerland | Registered: May 13, 2003Report This Post
Master
posted Hide Post
Roland,
You're right. I took the formatting off the field and it's running. Unfortunately,it's not really a professional report with a column of 4 decimal places while all others are integers, set with Money format.

I also find this interesting. The Fex has been set up this whole time with two columns for both Net and Gross comissions.

SUM
NET_COMMISSIONS/P11BM AS 'Net,Comm'
P1NET_COMMISSIONS/P11BM AS 'LY,Net,Comm'
GROSS_COMMISSION/P11BM AS 'Gross,Comm'
P1GROSS_COMMISSION/P11BM AS 'LY,Gross,Comm'

when I sort on the Net Comissions fields, there is no problem. The gross commission created the problem. It seems like the problem with "GROSS_COMMISSION" is deeper than this level, or the fact that it's the third field?

Any ideas?


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
 
Posts: 611 | Registered: January 04, 2007Report This Post
Virtuoso
posted Hide Post
Jason

If you do the reformating of that field in a define like

DEFINE FILE XXX
GCOM/P11BM=GROSS_COMMISSION;
END


you can use the already reformatted field in your report

You might also put the calculated fields first into an hold file and then report from that holdfile.

before the creation of the holdfile say

SET HOLDLIST=PRINTONLY




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Master
posted Hide Post
Frank,
That's a Great idea! Thank you.
I'm not sure if I'm doing everything properly, however, as I'm getting another error of
THE FIELDNAME IS NOT RECOGNIZED: GCOM when I use OLAP to sort the field. The report runs just fine initially, again the problem is only with olap.

The fex looks like this now:
DEFINE FILE MATRIX_COMM_TBL
GCOM/P11BM=GROSS_COMMISSION;
END
....
TABLE FILE MATRIX_COMM_TBL
SUM
NET_COMMISSIONS/P11BM AS 'Net,Comm'
P1NET_COMMISSIONS/P11BM AS 'LY,Net,Comm'
GCOM AS 'Gross,Comm'
P1GROSS_COMMISSION/P11BM AS 'LY,Gross,Comm'

Am I doing this correctly?


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
 
Posts: 611 | Registered: January 04, 2007Report This Post
Virtuoso
posted Hide Post
I've seen this happen before, but it was in some older version of webfocus (think it was a 5-x release).
When a request is run in OLAP mode, the entire request gets put into a javascript array and is manipulated from the java applet. It happened, that this translation into java sometimes did not produce correct code, resulting in strings being truncated. I found this by looking at the 'view source' of the htm page. In it you can see what is being put into this java applet. Maybe something happens in this case along the lines of the older problem?
If that is the case, then it may help to shorten the code in the table by putting all reformatting columns into define and using the shorter syntax to create your report.
Hope this helps.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Master
posted Hide Post
turns out that I was missing a letter on my fieldname.

Instead of gross_commission, the database field name was gross_commissionS. I changed it and it works fine now.

I expected an error of "could not find field" or soemthing of that nature, so "truncated fieldname..blah blah" through me a loop, especially since the report ran with the wrong fieldname initially and only errored on OLAP.


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
 
Posts: 611 | Registered: January 04, 2007Report This Post
Expert
posted Hide Post
Oh, the joys of FOCUS trying to make things easy for you and trying to match a truncated fieldname to something within the meta data you specify.

You start using a new facility ....

And then it bites you!!!!!!

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report 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     Truncated fieldname error?

Copyright © 1996-2020 Information Builders