Focal Point
[RESOLVED] COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 28?

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

September 09, 2015, 09:42 AM
Doug
[RESOLVED] COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 28?
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
September 09, 2015, 02:49 PM
Doug
Never mind. It's due to an "A255" field which needed to have a "A30" appended to it in the report itself...
September 09, 2015, 02:51 PM
Doug
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.
September 09, 2015, 03:45 PM
j.gross
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
September 25, 2015, 08:43 AM
Doug
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
September 25, 2015, 08:45 AM
Doug
And, the IB case, 22513556, on this is closed.