Looking for some help/guidance... I am a report developer, have been faced with outputting a grid that contains a magnifying glass in place of a value. I can get this to work in HTML all day long, but when switching output to other file formats (I have to output to powerpoint) I get various errors.

Here's an example of code that runs off of the CAR dataset and uses and included image from that project, and relatively closely mirrors the size of the data I'm working with:

 TABLE FILE CAR
BY CAR
ACROSS COUNTRY
SUM SALES
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt.sty,
$
TYPE=DATA, ACROSSCOLUMN=SALES, IMAGE='smplogo1.gif', SIZE=(.2 .2), WHEN= SALES GT 0, $
ENDSTYLE
END
 

This runs fine. If you change the code to PPTX output, the following error comes:

 
 (FOC1522) ntjprerr: CALLPGM execution error caused by:
 (FOC1522)  org.apache.james.mime4j.MimeException: Maximum line length limit
 (FOC1522)  exceeded. CPJAVA: Error in processing EXECUTE command for Class
 (FOC1522)  ibi.jsexcel.JscomExcelZip
 

Any idea what this means? Where it gets weird in troubleshooting, if I display only 1 column with the images in it, I can output to powerpoint fine...

 
TABLE FILE CAR
BY CAR
ACROSS COUNTRY
SUM SALES
WHERE COUNTRY EQ 'ENGLAND'
ON TABLE PCHOLD FORMAT PPTX
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt.sty,
$
TYPE=DATA, ACROSSCOLUMN=SALES, IMAGE='smplogo1.gif', SIZE=(.2 .2), WHEN= SALES GT 0, $
ENDSTYLE
END
 

.. but add just 1 more column,

  TABLE FILE CAR
BY CAR
ACROSS COUNTRY
SUM SALES
WHERE COUNTRY EQ 'ENGLAND' OR COUNTRY EQ 'JAPAN'
ON TABLE PCHOLD FORMAT PPTX
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt.sty,
$
TYPE=DATA, ACROSSCOLUMN=SALES, IMAGE='smplogo1.gif', SIZE=(.2 .2), WHEN= SALES GT 0, $
ENDSTYLE
END

...and the error appears again.


I'm at a loss. I've tried several different methods of displaying the columns, trying images of various sizes, no matter what technique I've used, if there are 2 columns with images in it, I get that error.

Any thoughts or suggestions?

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

This may be a job for Techsupport to help with.

But I guess the line "Maximum line length limit exceeded" may give an indication.

Hi Jason-

I had to comment out the stylesheet to get your code to run but in doing so, I did get output to PPTX with images in multiple columns.

-Barb

quote:

Originally posted by BKinPA:
Hi Jason-

I had to comment out the stylesheet to get your code to run but in doing so, I did get output to PPTX with images in multiple columns.

-Barb

Like this?

 -* File newfex.fex

TABLE FILE CAR
BY CAR
ACROSS COUNTRY
SUM SALES
WHERE COUNTRY EQ 'ENGLAND' OR COUNTRY EQ 'JAPAN'
ON TABLE PCHOLD FORMAT PPTX
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     -*INCLUDE = endeflt.sty, $
TYPE=DATA, ACROSSCOLUMN=SALES, IMAGE='smplogo1.gif', SIZE=(.2 .2), WHEN= SALES GT 0, $
ENDSTYLE
END

 

?

I still get the error

 

 0 NUMBER OF RECORDS IN TABLE=        6  LINES=      5
 (FOC1522) ntjprerr: CALLPGM execution error caused by:
 (FOC1522)  org.apache.james.mime4j.MimeException: Maximum line length limit
 (FOC1522)  exceeded. CPJAVA: Error in processing EXECUTE command for Class
 (FOC1522)  ibi.jsexcel.JscomExcelZip
 

OK; I know I have seen that error before. ANother area I would suggest looking into is how your system is creating the PPTX.

From the tech doc:

Microsoft changed the format and structure of the PowerPoint (PPTX) presentation. The new .pptx file is a binary compilation of a group of xml files. Generating this new file format using WebFOCUS is a two-step process that consists of generating the xml files containing the report output and zipping the xml documents into the binary .pptx format. The Reporting Server performs the xml generation process. The zipping process can be completed either by the client (WebFOCUS Servlet) or the server (JSCOM3):
◾ WebFOCUS Servlet. The WebFOCUS Client within the application server performs the zipping process. This can be done within the local client or through a remotely accessed client. The servlet method is the default approach defined for each WebFOCUS Client, with the client by default pointing to itself.
◾ JSCOM3. The Java layer of the Reporting Server performs the zipping operation. This option should be used when the WebFOCUS Servlet is configured on a secured web or application server. This is because JSCOM3 does not require URL access to a remote WebFOCUS Client.

Syntax: How to Select the Method for Zipping the .pptx File

Designate the method and location where the zipping will occur by setting EXCELSERVURL to a URL (for the WebFOCUS Servlet) or to a blank (for JSCOM3). You can set this value for a specific procedure or for the entire environment:
◾ For a procedure. Issue the SET EXCELSERVURL command within the procedure.
◾ For the entire environment. Edit the IBIF_excelservurl variable in the WebFOCUS Administration Console by selecting:
Configuration/Client Settings/General/IBIF_excelservurl

For more information on accessing the WebFOCUS Administration Console and setting the IBIF_excelservurl variable, see the WebFOCUS Security and Administration manual.


The value you assign to EXCELSERVURL determines whether the WebFOCUS Servlet or JSCOM3 performs the zipping operation:
◾ Specifying the Servlet. To specify that the WebFOCUS Servlet should be used, set the EXCELSERVURL parameter or the IBIF_variable to the URL of a WebFOCUS client configuration. For example,
In a procedure:
SET EXCELSERVURL = http://servername:8080/ibi_apps

In the WebFOCUS Administration Console:
IBIF_excelservurl = http://servername:8080/ibi_apps

◾ Specifying JSCOM3. To specify that JSCOM3 should be used within the current Reporting Server, set EXCELSERVURL to a blank or an empty string.
In a procedure:
SET EXCELSERVURL = ''

In the WebFOCUS Administration Console:
IBIF_excelservurl = ''


By default, each WebFOCUS Client contains the following URL definition that points to itself:
&URL_PROTOCOL://&servername:&server_port&IBIF_webapp

Hi Jason

Based on the release I see you are running which is 8.0.09, this is a know problem that was fixed. See this post.

https://techsupport.informatio...m/mips/22893531.html

quote:

Originally posted by Chuck Wolff:
Hi Jason

Based on the release I see you are running which is 8.0.09, this is a know problem that was fixed. See this post.

https://techsupport.informatio...m/mips/22893531.html

I tried that link, signed in, but it says "The page cannot be found
The page you are looking for might have been removed, had its name changed, or is temporarily unavailable." -- is there an alternate link?
Thanks,
Jason

Here is what is posted in that link.

*****************************************************************************
* MIPS STATUS INFORMATION *
* *
* Problem # 22893531 Project : 173302 Task Opened: 15/10/16 *
* Status/Action : ATBA Task Committed: *
* Current Programmer : Current Dept: WEBSUPPT *
* Client Name : YOGESH AJMIRE *
* Company : US BANCORP *
* Programmer Severity : N Client Severity : 1 *
* Related Problem: 0 Product: WEBFOCUS *
* Major Release: 8009 Put/Gen Level: 66 *
* Target Release: Target Product: *
*****************************************************************************
Project: 173302 Gen Status

MIPS Summary: FOC1522 error when running report with inline image in PPTX

DATE TIME DEPT PGMR STATUS GEN REL GENTAKE #
---- ---- ----- ----- ------ ------- ----------

- Explanation Section -

Customer is running a report with in-line image and PPTX fomat. They have
defined the images using Decode and when they set the position of the image
to be the first Print field it throws the following error:

(FOC1522) ntjprerr: CALLPGM execution error caused by:
(FOC1522) org.apache.james.mime4j.MimeException: Maximum line length limit
(FOC1522) exceeded. CPJAVA: Error in processing EXECUTE command for Class
(FOC1522) ibi.jsexcel.JscomExcelZip

- Reproduction Section -

Repro Steps:

* Issue reproduces under: http://irt8009.ibi.com:8080/ibi_apps/
Under Content \ Monica \ USBANK1

1) Run the following code:
DEFINE FILE CAR
FLAG/A12=
DECODE COUNTRY ( 'ENGLAND' 'uk' 'ITALY' 'italy'
'FRANCE' 'france' 'JAPAN' 'japan' 'W GERMANY' 'GERMANY' );
END
TABLE FILE CAR
HEADING CENTER
"Car File with Flags"
" "
PRINT FLAG AS 'PICTURE' CAR MODEL
BY COUNTRY NOPRINT
ON TABLE SET PAGE NOPAGE
ON TABLE PCHOLD FORMAT PPTX
ON TABLE SET STYLE *
TYPE=REPORT,COLOR=BLUE,$
TYPE=HEADING, SIZE = 18, FONT = ARIAL, COLOR=RED,$
TYPE=DATA,COLUMN=FLAG,IMAGE=(FLAG),SIZE=(1 1),$
ENDSTYLE
END

* Notice the error that is displayed.

3) Go back and change the PRINT line to the following:

PRINT CAR MODELFLAG AS 'PICTURE'

4) Run the report
5) Notice that the report displays without a problem.

15/10/30 16:51:57 MedProj SYS INFO

** MedProj comments by Kathy Kendall; project# 173302 **
This issue was resolved as part of a larger body of work in
Project 162223.

Yoram will extract the specific fix for this issue and return as
private sources in this project.
External_Explanation updated
Target_Release=7705
Proj_Priority=XCustomerX
Prbin_Fixed_in 7.7.06M
link_PM Lisa.Scipio
link_Observer Kathy.Kendall
link_Observer Yoram.Eisenstadter
link_QA Gregory.Griskowitz
Old External_Explanation:
NONE

15/10/30 16:55:18 MedProj SYS INFO

** MedProj comments by Kathy Kendall; project# 173302 **
For US Bank.

Yoram will provide private sources.
SRVPACK_Request:7.7.05M
SRVPACK_TEST:stms0045.focexec

15/10/30 17:15:17 MedProj SYS INFO

** MedProj comments by Kathy Kendall; project# 173302 **
For US Bank
Pfrm_REQUESTED_ Windows x86_64 64bit@winx64

15/11/02 09:54:07 MedProj LAW INFO

** MedProj comments by Lee Wilson; project# 173302 **
SRVPACK_Approve:7.7.05M

15/11/05 18:46:24 MedProj WHT INFO

** MedProj comments by William Teevan; project# 173302 **
Gen 208 has been posted to the domestic and emea ftp sites.
Pfrm_POSTED_ Windows x86_64 64bit@winx64
Please have an IBIer go to the Techsupport Download Site (linked
above) and register the customer for this download.
Product: WEBFOCUS
Symptom: NA
Functional Area: NA, WFRPTFMTSTY
Operating System: WIN764
Keywords: 22893531, WFRPTFMTSTY, PRINT, PPTX, IMAGE, FOC1522, DEFINE
Docid: 22893531

Chuck -
I am able to follow along with that post and replicate -- it is showing if the first column is an image, they get that error.. but if it is not the first column, they do not get the error.

I'm not sure that exactly mirrors what I am experiencing though... I can get 1 column with images to display fine, but displaying more than 1 throws the error. Any thoughts?

Jason

It may not be exactly the same but still may be the issue. I just want to verify the version / gen level you are currently using. If you go to your WebFOCUS browser session and choose Help / About WebFOCUS it will display that info.

quote:

Originally posted by Chuck Wolff:
Jason

It may not be exactly the same but still may be the issue. I just want to verify the version / gen level you are currently using. If you go to your WebFOCUS browser session and choose Help / About WebFOCUS it will display that info.

WebFOCUS Business Intelligence

Edition: WebFOCUS
Product Release: 8.0
Service Pack: 09
Build Version: branch8009_hotfix
Build/GEN Number: 124
Build/GEN Date: Tue Jul 19 05:39:52 CDT 2016
Application Server: IBM WebSphere Application Server/8.0

Jason

Based on your gen level of 124 and the gen level listed in the MIPS which is 208 so this may be the issue. I'm not suggesting an upgrade at this point I just find this interesting you are having this error. I do think you should open a case with techsupport and let them help you debug this.