[sqr-users] Migrating SPF files from HPS/SQR 8.2 to HPS/SQR 8.5

["Leonard, Kyle" <KyleLeonard@texashealth.org>]

The following log file shows the error which is produced by publishing
an SPF file in Hyperion Foundation version 8.5 which was generated by
SQR version 8.2.  I have traced the issue down to a line of code in the
SQR which requires an empty string in 8.5 but could be left blank in
8.2.  I can fix the SQR code and get it to run in 8.5.

 

We have a requirement to migrate the current SPFs without rerunning the
reports. Any thoughts on how can I get these SPFs to work in 8.5?

 

Thanks in advance!

 

<event logger="com.sqribe.transformer.SQRJobFactory"
timestamp="1163183189947" level="ERROR" thread="JF1_PHDFINRPT03-0"
sequence_no="1040">

<time>10 Nov 2006 12:26:29,947</time>

<context subject="administrator"
session_id="HBkYn3T5-0000010ed2ffa813-0000-068e-0aca0b87"
originator_type="JobService" originator_name="JF1_xxxxxxxxx03"
host="xxxxxxxxx03"/>

<message><![CDATA[1300307]]></message>

<throwable><![CDATA[Nov 10 12:26:29.947

Runtime error: exit code = Chart Error Invalid index accessed in
ChartTagTokenArray

Chart Error Invalid index accessed in ChartTagTokenArray

Chart Error Invalid index accessed in ChartTagTokenArray

Chart Error Invalid index accessed in ChartTagTokenArray

Chart Error Invalid index accessed in ChartTagTokenArray

PDFLib Error (12): [1054] PDF_open_image_file:
'd:\HyperionHPSu\BrioPlatform\server\JF1_PHDFINRPT03\tmp\JF1_PHDFINRPT03
-0\spf_output\031_1000_Executive_Summary_200501_200501_4.png' does not
appear to be a PNG file

 

com.sqribe.transformer.SQRException: Runtime error: exit code = Chart
Error Invalid index accessed in ChartTagTokenArray

Chart Error Invalid index accessed in ChartTagTokenArray

Chart Error Invalid index accessed in ChartTagTokenArray

Chart Error Invalid index accessed in ChartTagTokenArray

Chart Error Invalid index accessed in ChartTagTokenArray

PDFLib Error (12): [1054] PDF_open_image_file:
'd:\HyperionHPSu\BrioPlatform\server\JF1_PHDFINRPT03\tmp\JF1_PHDFINRPT03
-0\spf_output\031_1000_Executive_Summary_200501_200501_4.png' does not
appear to be a PNG file

 

            at com.sqribe.sqr.RunSQRSPF.execCommand(Unknown Source)

            at
com.sqribe.transformer.RunSQRSPFCommand.genSPFOutputStreams(Unknown
Source)

            at com.sqribe.transformer.RunSQRSPFCommand.runSQRSPF(Unknown
Source)

            at com.sqribe.transformer.RunSQRSPFCommand.execute(Unknown
Source)

            at com.sqribe.transformer.SessionCommand.execute(Unknown
Source)

            at com.sqribe.transformer.ClientThread.run(Unknown Source)

[1300307]: 

Chart Error Invalid index accessed in ChartTagTokenArray

Chart Error Invalid index accessed in ChartTagTokenArray

Chart Error Invalid index accessed in ChartTagTokenArray

Chart Error Invalid index accessed in ChartTagTokenArray

Chart Error Invalid index accessed in ChartTagTokenArray

PDFLib Error (12): [1054] PDF_open_image_file:
'd:\home\BrioPlatform\server\JF1_xxxxxxxxx03\tmp\xxxxxxxxxxxxx03-0\spf_o
utput\031_1000_Executive_Summary_200501_200501_4.png' does not appear to
be a PNG file

 

]]></throwable>

</event>

 

_________________________

Kyle J. Leonard

Sr. Programmer Analyst

Texas Health Resources

phone: (817) 462-7365

fax: (817) 462-7996

kyleleonard@texashealth.org <mailto:kyleleonard@texashealth.org> 

 



The information contained in this message and any attachments is intended only 
for the use of the individual or entity to which it is addressed, and may 
contain information that is PRIVILEGED, CONFIDENTIAL, and exempt from 
disclosure under applicable law.  If you are not the intended recipient, you 
are prohibited from copying, distributing, or using the information.  Please 
contact the sender immediately by return e-mail and delete the original message 
from your system.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users