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     [CLOSED] Error Message when RC: COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Error Message when RC: COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS
 Login/Join
 
Platinum Member
posted
Good morning All! I have a compound report that I am trying to distribute through Report Caster. When I run the compound report to view it as a PDF, it runs just fine, however when I run a report caster job to send me the report via email as an attachment, I get the following error log.

why would I be able to view the report just fine in PDF but not distribute it as such in an email?

Thanks in advance for your help.

Here is the error log from report caster.....

      Message Code    Message Text

    BTP1010         Schedule Executed On Demand at gvllc617a.dolgen.net:8200
    BTP1010         Job placed in the waiting queue at 2017-07-25 14:30:44.222-0500 (1,501,011,044,222)
    BTP1010         Job started running at 2017-07-25 14:30:44.222-0500 (1,501,011,044,222)
    BTP1010         Job remained in waiting queue for 0.0 seconds
    BTP1020         Starting task: Task 1
    BTP1020         Task type: WebFOCUS Report
    BTP1020         Task domain: b6gh4fd9/
    BTP1020         Retrieving WebFOCUS Report: IBFS:/WFC/Repository/b6gh4fd9/std_reports/reportsdevel/SAS_30_STORE_GROUPS/si_sas_30_store_dashboard.fex
    BTP1020         Connecting to server EDASERVE with execution id manglum at 2017-07-25 14:30:44.554-0500 (1,501,011,044,554)
    BTP1020         Connection to the Reporting Server EDASERVE established at 2017-07-25 14:30:44.638-0500 (1,501,011,044,638)
    BTP1020         The time to establish a connection to the Reporting Server EDASERVE was 0.084 seconds
    BTP1020         Executing focexec.
    BTP1020         COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 28
    BTP1020         0 NUMBER OF RECORDS IN GRAPH=      128  PLOT POINTS=    128
    BTP1020         0 NUMBER OF RECORDS IN GRAPH=      128  PLOT POINTS=    128
    BTP1020         Connection to the Reporting Server EDASERVE closed at 2017-07-25 14:32:06.771-0500 (1,501,011,126,771)
    BTP1020         Job ran on the Reporting Server EDASERVE for 82.133 seconds
    BTP1020         Task error:  COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 24
    BTP1010         No report to distribute.
    BTP1010         Job finished at 2017-07-25 14:32:06.788-0500 (1,501,011,126,788)
    BTP1010         Job time on distribution server after the report completed was 0.0 seconds
    BTP1010         Total running time was 82.566 seconds
    BTP1010         Total elapsed time (including the queue time) was 82.566 seconds

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
 
Posts: 111 | Registered: July 23, 2015Report This Post
Virtuoso
posted Hide Post
Sometime RC is more restrictive then other BI tool.

Do you have in your code :
SET PRINTPLUS = ON


Try by adding the following to your code
SET &ECHO = ALL
<your code that produce de PDF report>
-RUN
-TYPE FocErrNum : &FOCERRNUM
-EXIT


You may then see the Focus error number if it has one.
Then adding that error number to : " Administration Console / Configuration / Application Setting / Other / IBI_FOCUS_Warning_Numbers " may resolve the issue.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Platinum Member
posted Hide Post
I added the &ECHO=ALL to the fex that runs the compound report (not the .fex files that make up the compound report) I don't know if that matters or not... anyway here is the error log from reportcaster....

I also added the PRINTPLUS to all my fex files.

Also, when I run the compound report to view it, it still runs fine with no errors.


Report Caster error log:

  
ReportCaster Log Report Schedule ID: S99654d41s8339s4a88s867bs9aa287d58395, Job Description: SAS 3.0 Store Group Distribution
 
 
                  Process:    Jc30f108bj4f20j4b3ajbdd6j055cb58f126b
              Schedule ID:    S99654d41s8339s4a88s867bs9aa287d58395
               Start Time:    2017-07-26 09:10:17
                 End Time:    2017-07-26 09:12:00
 

    Message Code    Message Text

    BTP1010         Schedule Executed On Demand at gvllc617a.dolgen.net:8200
    BTP1010         Job placed in the waiting queue at 2017-07-26 09:10:17.635-0500 (1,501,078,217,635)
    BTP1010         Job started running at 2017-07-26 09:10:17.636-0500 (1,501,078,217,636)
    BTP1010         Job remained in waiting queue for 0.001 seconds
    BTP1020         Starting task: Task 1
    BTP1020         Task type: WebFOCUS Report
    BTP1020         Task domain: b6gh4fd9/
    BTP1020         Retrieving WebFOCUS Report: IBFS:/WFC/Repository/b6gh4fd9/std_reports/reportsdevel/SAS_30_STORE_GROUPS/si_sas_30_store_dashboard.fex
    BTP1020         Connecting to server EDASERVE with execution id manglum at 2017-07-26 09:10:17.826-0500 (1,501,078,217,826)
    BTP1020         Connection to the Reporting Server EDASERVE established at 2017-07-26 09:10:18.851-0500 (1,501,078,218,851)
    BTP1020         The time to establish a connection to the Reporting Server EDASERVE was 1.025 seconds
    BTP1020         Executing focexec.
    BTP1020         PDF PPT XMLR EXL97 EXL2K EXL07 AHTML AFSWF APDF
    BTP1020         COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 24
    BTP1020         COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 28
    BTP1020         0 NUMBER OF RECORDS IN GRAPH=      128  PLOT POINTS=    128
    BTP1020         0 NUMBER OF RECORDS IN GRAPH=      128  PLOT POINTS=    128
    BTP1020         WARNING: PRINTPLUS DISABLED FOR THIS REPORT, REASON:  4
    BTP1020         0 HOLDING PDF FILE ON PC DISK ...
    BTP1020         FocErrNum : 0
    BTP1020         Connection to the Reporting Server EDASERVE closed at 2017-07-26 09:12:00.400-0500 (1,501,078,320,400)
    BTP1020         Job ran on the Reporting Server EDASERVE for 101.549 seconds
    BTP1020         Task error:   VALID VALUES ARE OFFLINE-FMT=OFF ALPHA STANDARD POSTSCRIPT HTML DHTML
    BTP1010         No report to distribute.
    BTP1010         Job finished at 2017-07-26 09:12:00.411-0500 (1,501,078,320,411)
    BTP1010         Job time on distribution server after the report completed was 0.0 seconds
    BTP1010         Total running time was 102.775 seconds
    BTP1010         Total elapsed time (including the queue time) was 102.776 seconds
 


WebFOCUS 8
Windows, All Outputs
 
Posts: 111 | Registered: July 23, 2015Report This Post
Virtuoso
posted Hide Post
Hi Manglum

I found the following solution on the techsupport site.

A copy of the stylesheet used for the failing report was picked up via the
APPROOT PATH on the WebFOCUS EDASERVER, which was corrupted.

Once this corrupted copy of the stylesheet was removed, the issue was resolved.

This could possibly be causing your problem..


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Platinum Member
posted Hide Post
quote:
Originally posted by Chuck Wolff:
Hi Manglum

I found the following solution on the techsupport site.

A copy of the stylesheet used for the failing report was picked up via the
APPROOT PATH on the WebFOCUS EDASERVER, which was corrupted.

Once this corrupted copy of the stylesheet was removed, the issue was resolved.

This could possibly be causing your problem..


Chuck, I wish I was smart enough to know what that means...lol


WebFOCUS 8
Windows, All Outputs
 
Posts: 111 | Registered: July 23, 2015Report This Post
Guru
posted Hide Post
manglum,

Try the following....
- remove the stylesheet from the report
- the easiest way - if using AppStudio or DevStudio - edit the focexec
- right mouse click on the focexec
- select Edit as text in the popup menu
- scroll down the code until you find something similar to - this is a simple example
- Select the lines - right mouse click and "add comment"

ON GRAPH SET STYLE *

-* comment out all lines between these 2 lines

ENDSTYLE
END


- run the graph to ensure it runs correctly
- the graph should run correctly outside of Report Caster first before adding it to a schedule.

Your output from Report Caster is also saying - COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 24 (and column 28)

See if you can create a graph with less columns - for testing add a filter into the graph.

Since we do not have the graph code it is hard to say what the exact issue is with the above.

Let us know if the graph is running correctly outside of Report Caster.


Thank you for participating in the Focal Point Forum!
Tamra Colangelo
Focal Point Moderator
Information Builders


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Report 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     [CLOSED] Error Message when RC: COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS

Copyright © 1996-2020 Information Builders