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,

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.

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
 

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..

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

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