reports

Adding a true-type font to Reports Services while running Reports deployed on the web

Problem: A report, designed for generating PDF with the true-type font Univers in it, does not work while deployed on the web, and uses other fonts instead.
Cause: there’s no Univers installed in the Reports Services on Unix.
Solution: install the font and configure the Reports Service!  Sounds simple…

In the process of figuring this out, I had several error-messages, like rep-1352 (The fonts specified for this report cannot be found for the character set specified by NLS_LANG) , and rep-1 (nothing else…).
Took a lot of time to eliminate those errors, partly because there was a feature in the specified report what did’nt speed up the process of resolving this issue: embedded html. This caused for example the “rep-1″-error.

With special thanks to Marc Riesewijk, developer:

1. First, make a so called ‘AFM’-file of the font-files from your windows-client, which will be used to copy to the Linux-server.

In the case of Univers there are the following files in c:\windows\fonts:
-unvr55w.TTF
-unvr56w.TTF
-unvr57w.TTF
-unvr58w.TTF
-unvr65w.TTF
-unvr66w.TTF
-unvr67w.TTF
-unvr68w.TTF

zv7qrnb
By |August 11th, 2009|Categories: App. Server|Tags: , , , |0 Comments

Creating / deleting a reports server in OAS 10.1.2, integrated with EM/AS-console

Creating a reports server and integrate it with Enterprise Manager / iasconsole

Why:
– Under control of opmn (wil be automatically restarted)
– Visible and manageable under Enterprise Manager.

1. Create/start a new reports server : “$ORACLE_HOME/bin/rwserver.sh repproject
2. A small window will pop-up, showing that the reports server is starting up.
3. After it’s status is ready, stop this server.
4. Register this new reports server (you can do this also by hand, in the section of deleting this, you can also see what files you will have to update to insert or delete a reports server).

$ORACLE_HOME/bin/addNewServerTarget.sh repproject

The command addNewServerTarget.sh registers the reports server to OPMN and Enterprise Manager.

The following entry is added to $ORACLE_HOME/opmn/conf/opmn.xml (sorry for the layout) :

<ias-component id=”repproject” status=”enabled” id-matching=”false”>
<process-type id=”ReportsServer” module-id=”ReportsServices”>
<process-set id=”repproject” restart-on-death=”true” numprocs=”1″>
<environment>
<variable id=”PATH” value=”/home/ias10g/OraHome1/bin:/usr/bin:/usr/ccs/bin:/bin:/usr/kerberos/bin:/opt/IBMJava2-131/bin:/opt/IBMJava2-131/jre/bin:/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin”/>
</environment>
< module-data>
<category id=”general-parameters”>
<data id=”batch” value=”yes”/>
</category>
<category id=”restart-parameters”>
<data id=”reverseping-timeout” value=”120″/>
</category>
</module-data>
<dependencies>
<OID infrastructure=”true”/>
<database infrastructure-key=”portal”/>
<managed-process ias-component=”OC4J” process-type=”OC4J_BI_Forms” process-set=”default_island” autostart=”true”/>
<managed-process ias-component=”HTTP_Server” process-type=”HTTP_Server” process-set=”HTTP_Server” autostart=”true”/>
</dependencies>
<start timeout=”120″ retry=”3″/>
<stop timeout=”120″/>
<restart timeout=”120″/>
<ping timeout=”30″ interval=”30″/>
</process-set>
</process-type>
</ias-component>

By |July 10th, 2009|Categories: App. Server|Tags: , |1 Comment