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] FOC1522 error when doing output to PPT with mult columns containing images

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] FOC1522 error when doing output to PPT with mult columns containing images
 Login/Join
 
Member
posted
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,


WebFOCUS 8009
 
Posts: 14 | Registered: March 27, 2017Report This Post
Expert
posted Hide Post
This may be a job for Techsupport to help with.

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


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Silver Member
posted Hide Post
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


WebFocus 8.1.05, 8.2.01
 
Posts: 32 | Registered: November 21, 2013Report This Post
Member
posted Hide Post
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
 


WebFOCUS 8009
 
Posts: 14 | Registered: March 27, 2017Report This Post
Silver Member
posted Hide Post
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


WebFocus 8.1.05, 8.2.01
 
Posts: 32 | Registered: November 21, 2013Report This Post
Virtuoso
posted Hide Post
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


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
Member
posted Hide Post
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


WebFOCUS 8009
 
Posts: 14 | Registered: March 27, 2017Report This Post
Virtuoso
posted Hide Post
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


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
Member
posted Hide Post
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?


WebFOCUS 8009
 
Posts: 14 | Registered: March 27, 2017Report This Post
Virtuoso
posted Hide Post
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.


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
Member
posted Hide Post
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


WebFOCUS 8009
 
Posts: 14 | Registered: March 27, 2017Report This Post
Virtuoso
posted Hide Post
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.


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
  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] FOC1522 error when doing output to PPT with mult columns containing images

Copyright © 1996-2020 Information Builders