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     [RESOLVED] COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 28?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[RESOLVED] COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 28?
 Login/Join
 
Expert
posted
So, what does "COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 28" (the number, 28, varies) really mean when executed via ReportCaster with Bursting in WebFOCUS 8?

This runs really well when executed from within WebFOCUS Developers Studio with the "ON TABLE PCHOLD FORMAT PDF" line in each of the associated fexes, each page has an individual report for the select burst value.

Here's an excerpt from the full notification:
    BTP1020         Task type: WebFOCUS Report
    BTP1020         Task domain: eongou02/
    BTP1020         Retrieving WebFOCUS Report: IBFS:/WFC/Repository/eongou02/std_reports/reportsdevel/si_sas_30_store_compound_reports_rcx1.fex
    BTP1020         Connecting to server EDASERVE with execution id dolee at 2015-09-09 08:19:58.960-0500 (1,441,804,798,960)
    BTP1020         Connection to the Reporting Server EDASERVE established at 2015-09-09 08:19:59.152-0500 (1,441,804,799,152)
    BTP1020         The time to establish a connection to the Reporting Server EDASERVE was 0.192 seconds
    BTP1020         Executing focexec.
    BTP1020         COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 28
    BTP1020         0 HOLDING PDF FILE ON PC DISK ...
    BTP1020         Connection to the Reporting Server EDASERVE closed at 2015-09-09 08:19:59.494-0500 (1,441,804,799,494)
    BTP1020         Job ran on the Reporting Server EDASERVE for 0.342 seconds
    BTP1020         Task error:  COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 24
    BTP1010         No report to distribute.
    BTP1010         Job finished at 2015-09-09 08:19:59.511-0500 (1,441,804,799,511)
    BTP1010         Job time on distribution server after the report completed was 0.0 seconds
    BTP1010         Total running time was 0.715 seconds
    BTP1010         Total elapsed time (including the queue time) was 0.715 seconds

Here's the compound fex, which I might add, does not show any contents when opened in associated tool after it's created:
-* Default Mode: ResourceLayout

SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='prop_with_names^Margins_Left=0.5^Margins_Top=0.5^Margins_Right=0.5^Margins_Bottom=0.5^thumbnailscale=1', MERGE=OFF, ORIENTATION=LANDSCAPE, PAGESIZE=Letter, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
OBJECT=BOX, NAME='line1', POSITION=(0.250 0.500), DIMENSION=(10.500 0.200), BACKCOLOR=BLACK, BORDER-COLOR=BLACK, METADATA='FONT-SIZE: 1pt; HEIGHT: 0.2in; WIDTH: 10.5in; POSITION: absolute; LEFT: 0.25in; Z-INDEX: 3; TOP: 0.5in; BACKGROUND-COLOR: black', $
OBJECT=BOX, NAME='line2', POSITION=(0.250 0.700), DIMENSION=(10.500 1.400), BACKCOLOR=RGB(220 220 220), BORDER-COLOR=RGB(220 220 220), METADATA='FONT-SIZE: 1pt; HEIGHT: 1.4in; WIDTH: 10.5in; POSITION: absolute; LEFT: 0.25in; Z-INDEX: 5; TOP: 0.7in; BACKGROUND-COLOR: rgb(220,220,220)', $
OBJECT=BOX, NAME='line8', POSITION=(4.479 0.970), DIMENSION=(6.000 0.975), BACKCOLOR=RGB(255 255 255), BORDER-COLOR=RGB(255 255 255), METADATA='FONT-SIZE: 1pt; HEIGHT: 0.970in; WIDTH: 6in; POSITION: absolute; LEFT: 4.479in; Z-INDEX: 4; TOP: 0.975in; BACKGROUND-COLOR: rgb(255,255,255)', $
OBJECT=STRING, NAME='pageheader', TEXT='<font face="CALIBRI" size=14><center><FONT size=12 face="CALIBRI ">[b]</B><B>[/b]<FONT size=14 face="CALIBRI ">Shrink Assessment Scorecard 3.0 - Store Dashboard</FONT>[b]</B><B>[/b]</FONT></center></font>', POSITION=(0.250 0.250), MARKUP=ON, WRAP=ON, DIMENSION=(10.500 0.271),  METADATA='WORD-WRAP: break-word; FONT-SIZE: 14pt; HEIGHT: 0.271in; FONT-FAMILY: CALIBRI; WIDTH: 10.5in; POSITION: absolute; TEXT-ALIGN: center; LEFT: 0.25in; Z-INDEX: 86; TOP: 0.25in', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.500 0.500), DIMENSION=(10.000 0.540),  ARREPORTSIZE=DIMENSION, METADATA='Z-INDEX: 1; POSITION: absolute; WIDTH: 10in; HEIGHT: 0.54in; TOP: 0.5in; LEFT: 0.5in', $
COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(0.500 0.750), DIMENSION=(05.000 1.771),  ARREPORTSIZE=DIMENSION, METADATA='Z-INDEX: 2; POSITION: absolute; WIDTH:  5in; HEIGHT: 1.771in; TOP: 0.750in; LEFT: 0.5in', $
COMPONENT='report3', TEXT='report3', TOC-LEVEL=2, POSITION=(4.500 0.750), DIMENSION=(05.000 1.771),  ARREPORTSIZE=DIMENSION, METADATA='Z-INDEX: 3; POSITION: absolute; WIDTH:  5in; HEIGHT: 1.771in; TOP: 0.750in; LEFT: 4.5in', $
END
SET COMPONENT='report1'
-*component_type report
-INCLUDE IBFS:/WFC/Repository/contentx/std_reports/reports/report1.fex
SET COMPONENT='report2'
-*component_type report
-INCLUDE IBFS:/WFC/Repository/contentx/std_reports/reports/report2.fex
SET COMPONENT='report3'
-*component_type report
-INCLUDE IBFS:/WFC/Repository/contentx/std_reports/reports/report3.fex

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




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Expert
posted Hide Post
Never mind. It's due to an "A255" field which needed to have a "A30" appended to it in the report itself...
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Expert
posted Hide Post
Then again. I do have some issues with the report contents being in the wrong "report_name" as per the bursting. I have an IB case on this.
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Virtuoso
posted Hide Post
As I think I noted once before, sometimes you can shed light on what report component crosses the line, by selecting a humungous paper size, and applying alternating BG colors.


- Jack Gross
WF through 8.1.05
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Expert
posted Hide Post
I agree, the BG colors, or just "color", is a great way to ensure you're analyzing what you think you're analyzing... Thanks, Doug
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Expert
posted Hide Post
And, the IB case, 22513556, on this is closed.
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 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     [RESOLVED] COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 28?

Copyright © 1996-2020 Information Builders