Friday, 23 December 2011

Alchemy cannot display PDFs

[Alchemy]  When viewing a PDF document within Alchemy you receive the following message:

"Alchemy needs to install a plug-in to the installed version of Adobe Acrobat or Reader on your system.  Do you wish to proceed?"

Upon clicking Yes you then receive the following message:

"Alchemy needs to terminate Adobe Acrobat or Reader to continue the install.  Do you wish to proceed?"

Upon clicking Yes you then receive a blank message box.

Ensure that you are running the latest version/service pack as detailed here.  If you still receive this error then you need to clear the "Enable Protected Mode at Startup" option within Adobe Acrobat Reader's options.

Further information about this issue can be found in the Read Me document for Alchemy v8.3sp6 or at the following location:


Viewing PDF documents in Alchemy

[Alchemy]  In Alchemy 8.3 changes were made to the method for viewing PDF documents.  Alchemy no longer uses it's own internal plugin instead it leverages the power of Adobe Acrobat Reader.

For this reason it is important that any workstation which wishes to view PDF documents within Alchemy also has Adobe Acrobat Reader installed.

As of writing this post the current recommended versions for Alchemy and Adobe Acrobat Reader are:

Alchemy v8.3sp6
Adobe Acrobat Reader X (v10)


Alchemy Installations

[Alchemy]  When installing any Alchemy version and/or service pack all installation documentation and associated Read Me documents should be read prior to installation and followed to the letter.

This is important as these documents contain important information specific to the version you are installing including information on how to configure other software components which are required for Alchemy to perform as expected.


Determining which version of the Alchemy Client is installed

[Alchemy]  To determine the version and build of your Alchemy client, open Alchemy Administrator/Search, and click About on the Help menu.

The About Alchemy Administrator/Search dialog box displays your release and build number.

For Alchemy 8.3, the build references are as follows:

8.3.Build 100.43   - 8.3 Base
8.3.Build 200.31   - 8.3 SP1
8.3.Build 300.63   - 8.3 SP2
8.3.Build 400.105  - 8.3 SP3
8.3.Build 500.204  - 8.3 SP4
8.3 Build 600.213  - 8.3 SP5
8.3 Build 700.270  - 8.3 SP6 (supersedes 700.268)
A full list of Alchemy v8.x build numbers can be found at the following link:

64 Bit Windows OS Support - Alchemy

[Alchemy] 64 Bit support was introduced into Alchemy from V8.3 SP4.

When installing Alchemy on a Windows 7 / Server 2008 64 Bit machine it is important that you use the v8.3sp4 combined installation.  Installing v8.3 then updating to sp4 will NOT work as the v8.3 install is NOT 64 Bit compatible.

Once v8.3sp4 combined has been installed it is highly recommended that you upgrade to the latest service pack which is currently v8.3sp6.  ALL server and client components within your infrastructure will need upgrading to this latest version.


NOTE:- OpenText specify that all server and client components should be of the same build number and this is a requirement to obtain full support.

Thursday, 22 December 2011

MS Office 64 Bit compatibility with Formate

[Formate] Even when installed on a 64 Bit Windows OS, Formate is a 32 bit application and so can not interact with a 64 bit copy of MS Office. For a fuller explanation please see the Microsoft article;

This limits Formate when installed on the 64 Bit OS to sending emails via SMTP, and will prevent any interaction with MS Word or MS Excel, unless a 32 bit Version of MS Office is installed.

Note: in MS office 2010 installed version is available under File|Help


Wednesday, 14 December 2011

Using an Oracle Database with Inforouter

[Inforouter] If using Oracle 9i or higher as the back-end database of Inforouter, there must be an 11g Client with ODAC (Oracle data access components) installed on the Inforouter server. This provides dotnet connectivity to Oracle Databases, and the 11g Client will be backwards compatible with earlier Oracle database versions. (PCA)

An empty field is not nothing!

[Formate]  When checking an equality in Formate, a mapped input field with no text is not nothing, but a series of spaces equal to the lenght of the field, so checking to see if @Field = "" will never be true. If the input data field is 5 characters in lenght an empty field is actually equal to "     ". To resolve this you need to apply a trim, either the the field in its properties or in code and all is ok as the trim removes empty spaces, so trim(@Field) ="" can be true. (PCA)

Tuesday, 13 December 2011

Custom Property set lookups from databases

[Inforouter] When using a Database lookup with an Inforouter custom property set field, the custom property set field names which are to be filled from the database must have the same names as ther database fields, or an alias must be used to return data with a matching name, or if the same look up is required to populate two separate custom property fields.

With alias - will populate custom property field "TESTNAME" with data from Supplier_Name field in database. (example to populate a list box)

Select Supplier_Name "TESTNAME" from ATT_TradeSuppliers order by supplier_name

Without alias - will populate custom property field "Supplier_name" with data from Supplier_Name field in database.

Select Supplier_Name from ATT_TradeSuppliers order by supplier_name

An example to use an entered value to return the resutls of a search, into the Employee_num, department, and surname custom property fields based upon the forname entered into the forname custom property field.

SELECT Employee_num , department, surname, forname from Employees WHERE forname like '<%=VALUE%>%'

(PCA - with thanks to JN)

Friday, 9 December 2011

Printer Privileges - Formate Server Service

[Formate] Service Account running Formate Server Service requires "Manage Printer" rights to any printer to be used by Formate Server. Also aplies to logged in user if running Formate Server as an Application (pca)

Controlling the Formate Server Service - Permissions ( Windows 2008 )

[Formate] When attempting to control the Formate Server Service, (Start, stop or Install) from Formate Server Application or Configuration, the logged on user needs privileges to control services. This can be controlled by a group policy and may not be granted automatically on a given domain. See

If you not not have the required privileges you may get an error such as


Monday, 5 December 2011

Christmas 2011 - Closed 23rd December - Re-Opening 3rd January 2012

Christmas 2011 - Closed 23rd December - Re-Opening 3rd January 2012. 

The Document Genetics Support Department is closed from 23rd December, reopening on the 3rd January 2012. Please email any requests to, and your query will be dealt with in the order received upon our return (pca)

Happy Christmas

The Support Team