IUCLID 5
Documentation | Training | Links | Get Reference substances | IUCLID format | FAQ | Service Desk Contact | Get EC Inventory

FAQ

Login

Data Entry

Import/Export

Plug-ins

Upgrade & Migration

Installation

Common Installation Problems


What is IUCLID 5?

For Industry, IUCLID 5 is a:

- Software tool for entering and storing information on chemicals, as well as for preparing and submitting dossiers to fulfil legislation requirements.

For the Agency & for Member state competent authorities, IUCLID 5 is:

- the central data repository for all dossiers submitted
- the basis for evaluating the risks of substances and requiring new information
- the basis for restricting and authorizing the use of chemicals to manage risks.

IUCLID 5 data comply with the REACH legislation requirements, but also with the requirements of OECD, HPV Chemicals Programme, US HPV Challenge programme, Japan Challenge programme and EU Biocides. All the OECD harmonised templates, together with the relevant endpoints for biocides and pesticides are included in IUCLID 5.

OECD harmonised templates provide a consistent way of reporting information on study reports across regulatory programmes.

The XML schema used in the templates enables IT systems to exchange data electronically. Field-names, guidance, and format, as well as all entries for the pick lists, predefined texts and tables to be used in the rich text editor fields, and executive summary text samples are provided by the OECD Harmonised templates.

Login

When I try to log into IUCLID 5 for the first time, why can I not log in?

The first time you log into IUCLID, your username is "SuperUser" (without the “”) and your password is "root" (without the “”).

I created a new user account on the IUCLID 5 website but I have not received the activation email. How can I activate my account?

Due to the large amount of spam that IT systems usually experience, corporate email management systems are set up with very restrictive policies. In some cases, emails coming from ECHA may be filtered out and considered to be spam. Therefore, it is possible that our notifications, activation account emails and other emails, do not reach IUCLID 5 users. If you have activated your account or made a request for a forgotten password, and you have not received the answer within an hour, it may be due to the spam filtering. In that case we advise you to contact your system administrator in order to validate iuclid5@echa.europa.eu email address and set it up as trusted address. You should then contact the IUCLID 5 support Team using the web-form at http://iuclid.eu, in order for us to activate your account manually.

Data Entry

When searching for a Substance/ Reference substance I do not get the expected results. What is wrong?

IUCLID 5 will fetch a maximum of 2.000 records when doing a search from the database. If your query results contain more than 2.000 matching records, only the first 2.000 will be displayed. Since sorting is done after the records are fetched, this is not always apparent. There will, however, be a warning in the lower left hand corner of the IUCLID 5 main window stating that the query result was limited. If you encounter this warning, you should refine your query parameters so that less than 2.000 matches are found.

The same problem can also occur when attaching Reference substances to a Substance dataset. This can be detected looking at the number of results found. If the maximum number of 2.000 records is reached, some records might not be displayed. Please refine your search to find the correct record.When searching for active Reference substances, it is better to use the first letter of your Reference substance, followed by an asterisk, for example k*, instead of * in the Reference substance name field, because this limits the amount of records displayed. The retrieved result can then be filtered setting the "active only" flag.Similar problems might also be encountered during some other query procedures. As a general advice you should always make the query as specific as possible to avoid the problem of truncated query results and to make it easier to find the desired results from the query results list.

When pressing the "Update" button for Substance /Reference substance etc. on the task panel, IUCLID 5 will return all entries from the database by default. If more than 2.000 entries have been found, IUCLID 5 will ask the user if this query should be skipped in the future. This is the only way to get a list with unlimited number of results – this query might take a long time to execute and can be disabled in the User Preferences.

The filtering on the query results works in the following way:

If the search string is "m", a wildcard (*) is automatically inserted by default before and after the string (*m*). The search returns results containing the desired string "m" whatever its position in the name If you want to search for all records beginning with "m", you must execute your search in the following way: m*.

Which contact address will be used by ECHA - the REACH-IT registration contact, the contact described in the IUCLID 5 legal entity or the contact given in the substance data set?

The most important contact address in the context of REACH registrations is the one given at the REACH-IT signup, since this is considered to be the most up-to-date information. There is no obligation to provide substance specific contact details in IUCLID 5.

Please explain Data exchange and anonymity

Appointing a third party representative is based on Art. 4 of the REACH Regulation. Send him your files. He will import your IUCLID files into his IUCLID database, and change the owner (legal entity) of the substance to his owner (legal entity), and send the information to the partners, using his legal entity.

Note that user information is tracked in the modification history. (See instructions below for changing the modification history after export.) Consider encoding directly, using the legal entity of your representative or writing a program for changing the legal entity.

  1. Export the data in question to an .i5z file
  2. Rename this .i5z file to .zip
  3. Open the .zip file with an appropriate tool (e.g. winzip)
  4. Open the .i5d file from which you want to remove the modification history entry with wordpad
  5. Search for "<i5:modificationHistory>" using the find function of WordPad
  6. The first entry marked by <i5:modification>... </i5:modification> is the creation entry for the record which has to exist – if needed you may change the contents

Where can I find Guidance on Categories?

Guidance on how to create a category with IUCLID can be found in the IUCLID 5 End User Manual chapter D.6.2. There you also find recommendations how to document read-across in IUCLDI 5 datasets.

Scientific guidance can be found in the “Guidance on information requirements under REACH” which will be available on the ECHA website in the section REACH/Guidance/Technical Guidance Documents

Why is there no comment in modification history for pasted endpoints?

When an endpoint is newly created, an entry into the modification history of the substance dataset is created including a comment on which endpoint has been added. When an endpoint is pasted to a substance dataset, the modification history is updated but no comment is attached.

Why does the clipboard short cut key (F8) not work?

The F8 key only works if the focus is currently in the data window of IUCLID 5. The menu entry will always open the clipboard.>

Text printed from rich text areas in IUCLID may not always have the same formatting as on screen

1) Migrated text is not wrapped correctly. Text may be cut at the right margin.
2) All text fonts applied in IUCLID are displayed in the font Helvetica.
3) All headings are displayed in font Helvetica and with standard sizes.
4) Empty cells in a table do not have a border when the table was copied from Microsoft Word.

Work-around:
1) see work-around for known issue with migrated text (copy to text editor, clear rich text area, copy and paste back)
2) and 3) remove the style definition in the printed html file, save and reopen the html file

Before:
------------------------------snip-----------------------------------
<html>
  <head><meta name="subject" content="IUC5-c282775f-1400-4bd5-b04b-74f60341f6d0/0" />
  <title>Endpoint study record: Melting point/freezing point, IUC4#1/Ch.2.1</title>
  <!-- Creator: IUCLID 5 -->
  <!-- Creationdate: Wed Oct 17 13:48:28 EEST 2007 -->
  <meta name="author" content="au" />
  <!-- iText 1.4.8 (by lowagie.com) -->
  <!-- CreationDate: Wed Oct 17 13:48:28 EEST 2007 -->
  <style><!-- Font { font-family: Helvetica; font-size: 10pt } div { font-family: Helvetica; font-size: 10pt }   --></style></head>

  <body leftmargin="50.0" rightmargin="50.0" topmargin="50.0" bottommargin="50.0">
------------------------------snip-----------------------------------

After:
------------------------------snip-----------------------------------
<html>
   <head><meta name="subject" content="IUC5-c282775f-1400-4bd5-b04b-74f60341f6d0/0" />
   <title>Endpoint study record: Melting point/freezing point, IUC4#1/Ch.2.1</title>
   <!-- Creator: IUCLID 5 -->
   <!-- Creationdate: Wed Oct 17 13:48:28 EEST 2007 -->
   <meta name="author" content="au" />
   <!-- iText 1.4.8 (by lowagie.com) -->
   <!-- CreationDate: Wed Oct 17 13:48:28 EEST 2007 --></head>

   <body leftmargin="50.0" rightmargin="50.0" topmargin="50.0" bottommargin="50.0">
------------------------------snip-----------------------------------

4) Either enter a space in empty cells already in Microsoft Word before copying, or try using a different editor, e.g. OpenOffice.org Writer does not create this problem.

Text printed from the rich text area in IUCLID may not be complete when the less than (<) sign is used

When a less than sign is used in the rich text area and there is no separation between the < and the following text, the following text is removed until the next paragraph or until the next greater than (>) sign.

Work-around:
Make sure you always have a space after each less than sign.

Copy to rich text area behaves erroneously. When copying from a word processor to the rich text area, the result may not be what is expected.

Some special formatting (e.g. strikethrough) will cause the formatted text to be lost.
the less than(<) sign causes problems:

1) Copying from Microsoft Word 2003:
- When the less than (<) sign is separated from the following text by space, the sign is lost during the pasting to IUCLID
- When the less than (<) sign is not separated from the following text, the whole text until the end of the paragraph or until after the next greater than (>) sign is lost during pasting to IUCLID.
- Headings do not preserve formatting when copied from Microsoft Word
- Text formatted with styles (like Heading 1 etc.) in Microsoft word does not preserve the formatting when pasted to IUCLID. The designation as heading is preserved. The format can be redefined manually inside IUCLID.
- Text formatted without using styles is formatted correctly after pasting to IUCLID.

2) Copying from Microsoft Notepad or WordPad:
- All text after the first less then sign (<) is lost during the pasting to IUCLID regardless of separation from the text.
- When using Ctrl-v for pasting into IUCLID in a distributed installation the behaviour is correct.

There is an error in the hazard statement associated with 'Skin sensitization'. Why?

In section 2 of the IUCLID 5 dataset where a user can input the GHS classification and Labelling for their substance there is an error in the hazard statement associated with 'Skin sensitization'. The Hazard statement available reads: <"7204=may cause allergy or asthma symptoms or breathing difficulties if inhaled". We have added this to our list of identified errors to be addressed in future service releases.

Why does the site link disappear in section 3.3 when I change the substance name?

This a bug which has been added to our list of known issues that need to be fixed in a future IUCLID 5 release.

This problem can be replicated as follows:

  1. Create a new substance (or go into an existing one) and assign a production site in section 3.3
  2. Save the substance and return to the "Home" menu
  3. Get into the substance again and activate the "Edit" mode
  4. Go into section 1.1
  5. Under "Substance identification" change the first entry "Chemical name" into a different name
  6. Save the substance again
  7. Go into section 3.3
  8. --> The site reference is gone

I received the error : "error java.lang.OutOfMemoryError". What am I to do?

The error normally occurs when importing, exporting or saving large amounts of data, for example substance datasets or dossiers containing large attachments.

In the standalone environment:
In order to increase the usage of memory, when running the IUCLID 5 standalone version, you need to increase the –Xmx parameter found in the iuclid5.cmd file where all startup parameters are found. You also need to ensure that you have at least 1GB of memory available on your computer.

  1. Edit the iuclid5.cmd file.
  2. Change the command line:
    @start "IUCLID5" "javaw.exe" -Xms512m -Xmx768m ...
    into
    @start "IUCLID5" "javaw.exe" -Xms512m -Xmx1024m ... (assign 1GB)
    Or if your computer has a lot of memory:
    @start "IUCLID5" "javaw.exe" -Xms512m -Xmx2048m ... (assign 2GB)
    It is not recommended to assign more than half of the physical memory available.
  3. Save the file

In the distributed environment:
All files are loaded into memory on the client’s computer; therefore you need to run the client connection with more memory: You can do this by selecting, from the available connections on your browser, "install IUCLID 5 Client (with 768MB RAM)" or "(with 1 GB RAM)", as shown in the figure below:

Ensure that you have shut down all other applications and that you have sufficient memory on your client computer.

How can I modify the classification in section 2.1 because the options are "greyed out"?

In order to modify the default reason for no classification in section 2.1 in IUCLID 5, you need to choose the "blank" option in order to enable the classification field.

You will then be able to select your appropriate classification.

I cannot save my data in sections 3.5 and sections 3.6 in IUCLID 5.2. Is it a bug?

In IUCLID 5.2, sections 3.5 Identified uses and exposure scenarios and 3.6 Uses advised against, there are problems with the storage of the remarks field in the pick list of the field "Process category".

If you enter your data, save after each entry and leave the edit modus after saving (change into view modus), before starting with a new entry, all works well (see below).

But if you do not leave the edit modus between two entries (even if you save after each entry), the databases loses former entries, which were saved before (see below).

The same error occurs under "Uses by workers in industrial settings", "Uses by professional workers" and "Uses by consumers".

This is a bug and it has been fixed in the IUCLID 5.2.1 release, which we have received from the IUCLID 5 developer, however, it is currently being tested. It will be published towards the end of June 2010.

I cannot attach documents in section 1.4 of IUCLID 5.2, is it a bug?

1.4 Analytical Information

There are problems with attachments in the repeatable block "Results of analysis" in chapter 1.4 Analytical information. If you create a first block and add an attachment all works well. After saving the attachment “Dokument 1.doc” is listed in the Information bar.

If you create a second block (see below) and save your work the second document “Dokument 2.doc” is listed in the information bar but the first document disappeared (see below).

Trying to open the first attachment in the first repeatable block results in an error message (see below).

If you create a third block (see below) and try to save him you get directly an error message

You can only leave the substance by discarding the changes (repeatable block “Document 3”). But when you open chapter 1.4 of the substance once more, you find the attachment "Dokument 3.doc" in the Information bar.

If you try to create a fourth block you get directly an error message.

You can only leave the substance by discarding the changes (repeatable block "Document 4"). But when you open chapter 1.4 of the substance once more, you find the attachment "Dokument 4.doc" in the Information bar.

The creation of an additional repeatable block is not possible but the attached document is listed in the Information bar without a correlation to any repeatable block.

The bug has now been fixed in IUCLID 5.2.1 which will be released towards the end of June 2010. The new IUCLID 5.2.1d version is currently being tested. In the meantime, to fix the problem, you can log in as SuperUser. You will not get the “Document not found!” message. The problem is then fixed and the normal users will then be able to modify and save the substance.

Import/Export

Why do export file contents differ Slightly?

XML export files created by IUCLID 5 can have slightly different contents for fields that are empty. In some cases notes that do not contain data are omitted, in other cases they are included as empty element (). This behaviour depends on how the exported object was created and which database management system is used. These differences do not have any practical impact on the behaviour of IUCLID 5.

I find that I cannot import or export from my Vista x64 based installation as Java exceptions are created. I have recently installed the latest Java runtime update (12). Why does this happen?

This error has now been corrected in IUCLID 5.1.1. which is available for download from the Get IUCLID 5 section of the IUCLID 5 website.

With IUCLID 5.1.0, when updating the Java version to 1.6.0_12 or higher, importing and exporting produce exception errors.

This exception message appears when:

  • a relative new version of the Java is installed on the client and
  • a dialogue is activated which offers the possibility to enter a file or
  • the drag & drop function is used for importing

Sample:
The message appears every time an export is initiated if the installed Java version is 1.6.0_12 or higher.

Problem page

If this is the error you are encountering, to resolve it do the following:

  1. Downgrade the Java version to at least Java version 1.6.0_11. In order to do that you have to uninstall the current version, and install the version recommended. See: http://java.sun.com/products/archive/. It is also recommended to disable the automatic update functionality of the software.
  2. Another option is to use the control panel of the Windows PC: go to the Java settings (this is also reachable through the start page of the IUCLID 5 server, for example http://localhost:8080/i5server, at the bottom "Start Application Manager").

    Problem page
    You will see something similar to:

    Problem page
    Select Edit/Preferences.
    Then go to the "Java" tab and press on the "View..." button of the "Java Application Runtime Settings". This is the lower button of the two view buttons in the screen.
    Maybe there is more than one Java version installed. Then it is possible to simply deactivate the Java version 1.6.0_12 in this screen.
    => see screenshots below

    Problem page

    Problem page

    If you still encounter problems, please send the ECHA Helpdesk your i5server.log file, which is normally found in the Tomcat root directory, or i5client.log file which is normally found in the /IUCLID 5 folder, as well as the exception report that you receive.

    Ensure that the 'Check for Updates Automatically' option in the Java Control Panel is disabled.

Plug-ins

I used a translated HelpSystem plug-in with IUCLID 5.1.0. What should I do to check if the wrong decimal separator was written in my database?

A bug was identified when using IUCLID 5.1.0 in combination with an extension to the resource plug-ins, for languages other than English or Maltese.

In this case numeric values in endpoints and endpoint summaries are written to the database with the wrong decimal separator if the language of IUCLID is not set to English or Maltese.

An endpoint analyser tool has been developed in order to scan the IUCLID 5 database for incorrect decimal separators and correct these invalid number values in endpoint documents.

Please follow the instructions available in the Endpoint Analyser plug-in manual before installing and using this plug-in.

Important note: you need to upgrade your IUCLID database to version 5.1.1 before using this plug-in to check your data. Please click here to download IUCLID 5.1.1 .

You can download the Endpoint Analyser plug-in manual here.

You can download the Endpoint Analyser plug-in here. (please note that in order to download this plug-in, you shall first log into the restricted area of the website using your previously created account. Use your username and password).

When I install the plugin for another language and change the user preferences to a language other than English, I no longer see the "free text template" and the "to delete the text area" icons. Why?

Example of problem:

Problem page Problem page
Problem page Problem page

The server initializes the free text templates only for the English (default) language in IUCLID 5.1.0. We have fixed this bug in IUCLID 5.1.1 which is available now for download from the Get IUCLID 5 section of the IUCLID 5 website.

The query tool indexer hangs on indexing documents and in the server log file contains the exception: 2009-02-17 00:01:03 ERROR JDBCExceptionReporter.java : 78 | ORA-12899: value too large for column "IUCLID5A"."QUERYINDEXITEM"."FIELDVALUE" (actual: 263, maximum: 255). Why?

  • This issue has been fixed in IUCLID 5.1.1, which is now available for download from the Get IUCLID 5 section of the IUCLID 5 website. If you do not wish to upgrade, please see below:

The problem occurs if IUCLID is installed in combination with an oracle database that uses as default the setting NLS_LENGTH_SEMANTICS=BYTE.

The setting of the ORACLE database can be verified with SQL+ by entering the following statement: select * from nls_database_parameters;

NLS_LANGUAGEAMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AL32UTF8
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 10.2.0.1.0

In this case the character columns for the query tool tables are created as VARCHAR2(255) instead of VARCHAR2(255 CHAR).
So the columns are created with a limitation of 255 single byte characters.
In UTF-8 some special characters need up to 4 single byte characters.
If the indexer write a string with maximum of 255 characters and this string contains some special characters (like α, β, γ, etc.) the available size in the database is exceeded and the indexer stops working.

How to reproduce: Create a substance with a chemical name, 260 characters long, containing characters like α, β, γ.

To fix the issue in IUCLID 5.1.0 download the patch file. This zip file has to be extracted to the classpath. The following steps are necessary:

Distributed installation (tomcat),

  • Extract the patch zip in the classes folder: <tomcatroot>\webapps\i5server\WEB-INF\classes\eu\eca\iuclid\server\integration\database\scripts\migrate_schemav47_patch.xml
  • Restart the server.
  • Recreate the index.

Workstation installation

  • Extract the patch zip in the workstation root folder <workstationroot>\eu\eca\iuclid\server\integration\database\scripts\migrate_schemav47_patch.xml
  • Restart the workstation.
  • Recreate the index.

Instead of installing the patch, it is also possible to solve the problem by:

  • Stop IUCLID (workstation or server)
  • Execute the following SQL statement (as ORACLE user "iuclid5"):
    ALTER TABLE UPDATEDINDEXITEM MODIFY
    (INDEXPK VARCHAR2(255 CHAR));
    ALTER TABLE QUERYINDEXITEM MODIFY
    (
    PARENTPK VARCHAR2 (255 CHAR),
    INDEXPK VARCHAR2 (255 CHAR),
    FIELDNAME VARCHAR2 (255 CHAR),
    REPBLOCKID VARCHAR2 (255 CHAR),
    TEMPLATEPK VARCHAR2 (255 CHAR),
    DOCREFPK VARCHAR2 (255 CHAR),
    DOCREFTYPE VARCHAR2 (255 CHAR),
    DOSSIERPK VARCHAR2 (255 CHAR),
    ECINVNO VARCHAR2 (255 CHAR),
    ENDPOINTKIND VARCHAR2 (255 CHAR),
    PARENTTYPE VARCHAR2 (255 CHAR),
    INDEXTYPE VARCHAR2 (255 CHAR),
    FIELDVALUE VARCHAR2 (255 CHAR),
    LOWERQUALIFIER VARCHAR2(255 CHAR),
    UPPERQUALIFIER VARCHAR2(255 CHAR),
    UNIT VARCHAR2 (255 CHAR),
    ORIGINAL VARCHAR2 (2000 CHAR)
    );
  • Restart the workstation or server.
  • Recreate the index.

Why can I no longer see my plug-ins after upgrading my IUCLID 5?

During the upgrade the plug-ins are not automatically copied to the appropriate folders from the old IUCLID 5 version. You need to copy your plug-ins again to the appropriate folders.

Why do I receive an exception error after having installed the CSR plugin, even though I have upgraded to IUCLID 5.1?

  • This bug has been fixed in IUCLID 5.1.1, which is now available for download from the Get IUCLID 5 section of the IUCLID 5 website. If you do not wish to upgrade, please see below:

We have recently found out that users who have updated their Java version to 1.6.0_12 or higher, receive exception errors when using the new CSR plugin, or when trying to import and export data into and from IUCLID 5.

In order to resolve this error that you are encountering, please follow these instructions.

Which plug-ins are compatible with which versions of IUCLID?

IUCLID : Plug-In compatibility matrix

The compatibility matrix show which essentials plug-in versions work with each IUCLID version.

IUCLID Client Plug-Ins
Plug-In   IUCLID 5.0.0 IUCLID 5.1.0 IUCLID 5.1.1 IUCLID 5.2.0
  Rollout 2007/07 2009/01 2009/06 2010/02
ClientExtensionPoint 5.0.0 2007/07  √  √  √  
ClientExtensionPoint 5.2.0 2007/07        √
XML Transform 5.0.0 2007/07  √  √  √  
XML Transform 5.1.0 2009/01  √  √ *√  
XML Transform (V10) 5.2.0 2010/02        √
XML Transform (V20) 5.2.0 2010/02        √
CSR 3.0.0 2009/03    √    
CSR 3.0.1 2009/05      √  
CSR 3.0.5 2009/06      √  
Migration 5.0.0 2007/07  √ *√ *√  
Migration 5.1.2 2007/12  √  √  √  
SNIF Migration 5.0.1 2008/11  √  √  √  
Pre Registration 5.0.1 2008/03  √  √  √  
Pre Registration 5.0.2 2008/06  √  √  √  
Query UI 5.0.0 2009/01    √  √  
Query UI 5.1.2 2009/04      √  
Query UI 5.1.3 2009/07      √  
Helpsystem 5.1.0 2009/02    √  √  
Helpsystem 5.2.0 2010/02        √
Bulk Export 5.1.1 2009/06    √  √  
Literature 5.0.0 2009/06  √  √  √  
TCC UI 5.1.10 2010/01      √  
TCC UI 5.2.0 2010/03        √
Back-up plugin 5.0.3 2010/02  √  √  √  

IUCLID Server Plug-Ins
Plug-In   IUCLID 5.0.0 IUCLID 5.1.0 IUCLID 5.1.1 IUCLID 5.2.0
  Rollout 2007/07 2009/01 2009/06 2010/02
ServerExtensionPoint 5.0.0 2007/07  √  √  √  
ServerExtensionPoint 5.2.0 2010/02        √
Resource provider 5.0.0 2007/07  √      
Resource provider 5.1.0 2009/01    √  √  
Resource provider 5.2.0 2010/02        √
Query Indexer 5.0.0 2009/01    √ *√  
Query Indexer 5.1.2 2009/05      √  
Query Indexer 5.1.3 2009/07      √  
TCC Server 5.1.10 2010/01      √  
TCC Server 5.2.0 2010/03        √

IUCLID Add-Ons
Add-On   IUCLID 5.0.0 IUCLID 5.1.0 IUCLID 5.1.1 IUCLID 5.2.0
  Rollout 2007/07 2009/01 2009/06 2010/02
Web-Services 2009/05    √ *√ *√
Web-Services 2010/02    √  √  √
Web-Services 2010/04    √  √  √

* Should not be used any more. Use the newest version instead.

Upgrade & Migration

What is the purpose of the IUCLID Backup-Plug-In?

The Backup-Plug-In does not perform any changes to the format of the data. It simply exports the whole database content including user accounts and roles to a smaller amount of files to avoid file system issues.

At which stage does IUCLID 5.2.0 perform the migration?

The migration itself is performed while importing the data into IUCLID 5.2.0. As such the migration of a dataset can be repeated even after having removed the previously installed version of IUCLID. The migration process itself is encapsulated in the IUCLID 5.2.0 client plug-in named "i5xform_v10".

If this plug-in is removed the affected IUCLID installation will not accept IUCLID 5.0.0, 5.1.0 and 5.1.1 compatible files anymore.

What data formats does the migration process accept and handle?

The migration process only accepts the official IUCLID format v1.0 emitted by IUCLID 5.0.0, 5.1.0 and 5.1.1. To migrate IUCLID 4 or SNIF datasets an old IUCLID installation (5.0 or 5.1.x) has to be used in combination with the relevant Migration Tool. In a secondary step the data can be imported and by that migrated into a IUCLID 5.2.0 installation.

Where can I find information on the changes performed during the migration process?

Relevant migration information is written to the file "iuclid.log" on a per document basis. This file serves as a migration log in case of any migration related problems. Relevant log entries can be found in a text editor i.e. Notepad using the document’s UUID or name.

Can the backup and migration processes be parallelised?

The backup process cannot be parallelised however if the backup is performed to separate files ("export to multiple XML files" option) these can be split into several bundles and then be imported in parallel on different machines to improve performance (only for distributed installation).

As a consequence you will have one migration log file per machine or IUCLID client that was used for the parallel migration.

Have the system requirements been changed for IUCLID 5.2.0?

In terms of hardware nothing has changed and there is no need to exchange or extend it. With regard to the related software, support for Java 5.0 has been ceased. IUCLID 5.2.0 can only be executed using a Java 1.6 JVM or higher.

Is there anything else to consider before performing the upgrade?

Yes, besides the fact that you might have to update your Java installation you should consider installing IUCLID 5.2.0 and your old IUCLID version in parallel. This allows direct comparison of the dataset before and after migration to the new IUCLID data format. In addition, this will help you when migrating IUCLID 4 or SNIF data to IUCLID format. The uninstallation of your old IUCLID version can still be performed later on.

I cannot upgrade to IUCLID 5.1.1 with my Oracle database.

In order to succeed with the upgrade of IUCLID 5.1.1, please ensure the following:

  1. you are running at least Oracle 10g Release 2 (10.2.0.4)
  2. you are using the latest jdbc driver (always do this) and have replaced \i5server\WEB-INF\lib\ojdbc14.jar in IUCLID 5 with ojdbc6.jar
  3. if you still encounter errors such as "Error executing SQL ALTER TABLE queryindexitem MODIFY (indextype varchar(255 CHAR))", ensure that you have read our other FAQs especially "The query tool indexer hangs on indexing documents...".

I want to upgrade to IUCLID 5.1, but I cannot find the manuals.

All installation manuals can be found on our website under Get Support/Documentation/ IUCLID 5 Installation manuals section.

When upgrading to 5.1, no plugins are available, do I need to reinstall them?

Unfortunately when upgrading to IUCLID 5.1, you need to re-install all your plugins by copying them into the appropriate folders, as they are not automatically saved during the upgrade process.

Why do I receive an error 403 after updating the distributed version from 5.0 to 5.1?

The error code 403 is related to the configuration of Apache Tomcat. Your users are able to communicate with the server, but either the server cannot find what is requested (could be due to file permissions) or the server is configured incorrectly.

Please check the following:

  1. If you have a Temp folder in Apache Tomcat, delete it.
  2. If you still get the error message, check your Tomcat version. We have found that:
    Tomcat 5.5.20 Works
    Tomcat 5.5.25 Broken -> 403 after login
    Tomcat 5.5.26 Broken -> Works
    Tomcat 5.5.27 Broken -> 403 after login
    Tomcat 6.0.14 Broken -> 403 after login
    Tomcat 6.0.18 Works
  3. If possible, please update your Tomcat version to one of the working versions.
  4. Please also check your /conf/tomcat-users.xml, which should include the role of 'admin'..e.g.
    <?xml version='1.0' encoding='utf-8'?>
    <tomcat-users>
    <role rolename="admin"/>
    <role rolename="manager"/>
    <role rolename="tomcat"/>
    <role rolename="role1"/>
    <user username="admin" password="secret" roles="manager,admin"/>
    <user username="tomcat" password="tomcat" roles="tomcat"/>
    <user username="role1" password="tomcat" roles="role1"/>
    <user username="both" password="tomcat" roles="tomcat,role1"/>
    </tomcat-users>
  5. You also need to ensure that after having copied the .war file into Tomcat, the Tomcat user is able to read it. Right click on the file and check / properties security. Users should have Read, Write and Execute permissions.
  6. In Apache the Tomcat Properties, Ensure that the logging level is set to Debug.

Send us the Tomcat log files, which are normally found in the folder /Tomcat x.x/logs, as well as the i5server.log file.

Why does migration fail with "java.lang.NumberFormatException"?

When the user specified comma as decimal separator in the User Preferences (User Preferences/Settings/IUCLID 5 user preferences/Decimal separator), migration fails with a " java.lang.NumberFormatException" error. As a work around please set the decimal separator to dot when the migration tool is executed. After migration the decimal separator can be reset.

Migration fails with "TransformationException: Null Pointer Exception caught." What can I do?

This error is caused in most cases by missing information in chapters 10.1 (End point summary) or 10.2 (Hazard summary) of IUCLID 4 when using the migration tool version 5.0.0. These chapters are expected to contain a reference to another chapter in the IUCLID 4 dataset. If this reference is missing, it is not possible to encode the corresponding data in IUCLID 5 as there is no unspecific summary foreseen in the data model.The error will not occur with the new version of the migration tool (version 5.1.1).

The malformed data will be reported in the migration report in case of chapter 10.1 (End point summary). For chapter 10.2 (Hazard summary), the data will be migrated to section 13 (Assessment Reports) in IUCLID 5.

Industrial category is not migrated from IUCLID 4. What can I do?

Using the migration tool version 5.0.0, the information stored in IUCLID 4 chapter 1.7.1 detailed use pattern was not migrated. This problem has been solved in the new migration tool (version 5.1.1). The information is now migrated correctly.

Text in a rich text area behaves erroneously when created during migration of IUCLID 4 data

1) long lines are not wrapped automatically
2) Long text is not broken to the next line when extending over the right border of the rich text area. This is true also in the printed document.
Lines can be broken manually by pressing the return key at the appropriate position in the next. Unfortunately this does not change the line breaking behaviour of the print.
3) It is not possible to insert tables into migrated text
4) When trying to create a table in a text created during migration, an exception occurs.

Work-around:
In order to correct this behaviour, one has to remove all formatting from the migrated text by copying it from IUCLID to a simple text editor (e.g. Notepad, not Word). Than the rich text area has to be cleared by using the “New File” button which can be found above the rich text area in the upper left hand corner. Now copy the text from the text editor back to IUCLID using Ctrl-v. Please be aware of the copy-and-paste issues described above. If necessary change the font of the text to a non-proportional font (e.g. Courier) to preserve tables designed in IUCLID 4.

When upgrading from IUCLID 5.1.0 to IUCLID 5.1.1 I can no longer connect to my Oracle database, why?

During the upgrade the SQL command is run: SQL ALTER TABLE queryindexitem MODIFY (repblockid varchar(255 CHAR)) causing the Error message: ORA-01450: maximum key length (6398) exceeded.

When creating an index, the total length of the index cannot exceed a certain value. Primarily this value depends on DB_BLOCK_SIZE. For an 8K block size, the maximum index key length is 3218. When installing Oracle the default block size is 8K.

The maximum index key length is measured by: Maximum index key length=Total index length (Sum of the width of all the indexed columns +the number of indexed columns) +the Length of the key(2 bytes) +ROWID(6 bytes)+the length of the rowid(1 byte) The index key size is limited by the value of db_block_size, because a key value may not span multiple blocks. It is required that any index block must contain at least TWO index entries per block.

So we can say that the maximum key length for an index will be less than half of the DB_BLOCK_SIZE. But we know that in a block space is also needed for PCTFREE, INITRANS and space for block overhead(Block Header,ROW Directory, Table Directory, etc). After considering these bytes the actual space that can be used for the Index key is actually just over 1/3 of the DB_BLOCK_SIZE.

To solve the problem, you need to create a second tablespace with 16k. You need to drop all indexes on the table queryindexitem (from the current tablespace). Recreate all indexes on table queryindexitem (in the new tablespace). Please see the script below on how to do this: 


/* IUCLID 5.1.1 */
/* Script to move table QUERYINDEXITEM with it’s indexes to */ 
/* a new created tablespace with block size 16k */

/* the red text have to be replaced by the ORACLE DBA */

CONNECT system/pwd@ora10

ALTER SYSTEM SET db_16K_cache_size = 8M;

CREATE TABLESPACE IUCLID5_16K
datafile 'E:\U10\U10\IUCLID5P16k_TS.DBF' 
size 5000M 
blocksize 16k; 

ALTER USER IUCLID5 QUOTA UNLIMITED ON IUCLID5_16K;


CONNECT IUCLID5/pwd@ora10

DROP TABLE QUERYINDEXITEM;

CREATE TABLE QUERYINDEXITEM
(
   PARENTPK       VARCHAR2(255 char) not null,
   INDEXPK        VARCHAR2(255 char) not null,
   FIELDNAME      VARCHAR2(255 char) not null,
   REPBLOCKID     VARCHAR2(255 char) not null,
   TIMESTAMP      NUMBER,
   TEMPLATEPK     VARCHAR2(255 char),
   DOCREFPK       VARCHAR2(255 char),
   DOCREFTYPE     VARCHAR2(255 char),
   DOSSIERPK      VARCHAR2(255 char),
   ECINVNO        VARCHAR2(255 char),
   ENDPOINTKIND   VARCHAR2(255 char),
   PARENTTYPE     VARCHAR2(255 char),
   INDEXTYPE      VARCHAR2(255 char),
   FIELDVALUE     VARCHAR2(255 char),
   LOWERQUALIFIER VARCHAR2(255 char),
   LOWERVALUE     FLOAT,
   UPPERQUALIFIER VARCHAR2(255 char),
   UPPERVALUE     FLOAT,
   UNIT           VARCHAR2(255 char),
   ORIGINAL       VARCHAR2(2000 char),
   CONSTRAINT QUERYINDEXITEM_PK PRIMARY KEY (PARENTPK,INDEXPK,FIELDNAME,REPBLOCKID) 
) TABLESPACE IUCLID5_16K;

/* The content of the table can be re-created via the IUCLID */
/* user interface: Query Tool>Administration */

/* DROP INDEX QUERYINDEXITEM_COMB1_IDX; */
CREATE INDEX QUERYINDEXITEM_COMB1_IDX ON QUERYINDEXITEM
(
  REPBLOCKID,
  PARENTTYPE,
  INDEXTYPE,
  FIELDVALUE
) TABLESPACE IUCLID5_16K;


/* DROP INDEX QUERYINDEXITEM_COMB2_IDX; */
CREATE INDEX QUERYINDEXITEM_COMB2_IDX ON QUERYINDEXITEM
(
  FIELDNAME,
  REPBLOCKID,
  ENDPOINTKIND,
  PARENTTYPE,
  INDEXTYPE
) TABLESPACE IUCLID5_16K;

/* DROP INDEX QUERYINDEXITEM_COMB3_IDX; */
CREATE INDEX QUERYINDEXITEM_COMB3_IDX ON QUERYINDEXITEM
(
  DOCREFPK
) TABLESPACE IUCLID5_16K;


/* DROP INDEX QUERYINDEXITEM_COMB4_IDX; */
CREATE INDEX QUERYINDEXITEM_COMB4_IDX ON QUERYINDEXITEM
(
  INDEXPK,
  DOCREFPK
) TABLESPACE IUCLID5_16K;


/* DROP INDEX QUERYINDEXITEM_COMB5_IDX; */
CREATE INDEX QUERYINDEXITEM_COMB5_IDX ON QUERYINDEXITEM
(
  PARENTPK,
  ENDPOINTKIND
) TABLESPACE IUCLID5_16K;

Installation

I have problems installing IUCLID 5.2 on Windows Vista, what must I do?

  • Save the package to a folder. For example: "\Users\i5\iuclid5_install",
  • Unzip the package and copy the contents of the package to the same folder. For example: \Users\i5\iuclid5_install
  • Select Start/Command Prompt
  • Right-click and select "Run as administrator"
  • The command prompt opens
  • Change Directory (CD) to the path where you unzipped you package
  • Start the IUCLID 5 installation wizard by writing the following command and pressing enter:
    >java –jar iuclid5_install_5.2.0.jar

I cannot install IUCLID 5 on my Windows 7 computer, why?

For IUCLID 5 to run successfully on Windows 7 (32 or 64 bit), ensure the following:

What products will be supported as DBMS and Application server?

The following products are supported (i.e. tested and certified) as application servers:

- Apache Tomcat 5.5.x and higher (recommended, since no additional features of BEA WebLogic 9.0 will be needed by the IUCLID 5 server application). For versions higher than 5.5.x please see FAQ on error code 403
- BEA WebLogic Server, Version 9.0 and higher (Both WLS Premium and WLS Advantage versions are acceptable).

IUCLID 5 has no dependencies on libraries or mechanisms specific to the BEA WebLogic server (e.g. IUCLID 5 does not depend on JRockit9.0_1.5.0_03, although this JVM may be used). IUCLID 5 only depends on a J2EE compliant implementation of the included servlet container. Support of WebLogic has been foreseen only for those bound to a commercial product, not willing to switch to Tomcat.

The following products are supported (i.e. tested and certified) as DBMS:

- Oracle 10g and higher
- PostgreSQL 8.2.x and higher

For an overview of the necessary and recommended versions of these products, refer to the relevant answers in the ‘Installation and System Software Requirements” section.

In what environment can I install the setup.exe?

The IUCLID 5 client workstation will require:

Software

- JRE (Version 1.5 and above),
- Acrobat Reader
- Microsoft Windows 2000, XP or Vista

Hardware

- RAM: Minimal: 1GB.
- 2GHz CPU

How will IUCLID 5 be installed in a stand-alone environment?

By executing the deployment kit setup.exe. this will install the application itself, a suitable JRE which will not interfere with an already existing one on the same computer and the open source database PostgreSQL.

What are the hardware and software requirements for installing the Tomcat Application Server?

For Tomcat, with JDK, you need around 1000MB of disk space (around 600MB for installation and around 400MB for execution). This does not include the log files. Minimum requirements for a development workstation running Tomcat are: 733 MHz Pentium and 1GB of memory. Do not save on memory because Java can be highly memory-intensive.

What are the hardware and software requirements for installing the database server?

With a clean installation of IUCLID 5, 500MB of disk space is used. This includes the Reference substance and EC inventory import. We have not calculated how much space is needed for log files, etc.

To calculate how much space is needed for the actual Substance information data on your database server, you must know some of your companies’ internal parameters. A Substance or Dossier containing a lot of endpoints, summaries etc. without attachments needs between 1-5 MB database space each. In IUCLID 5 all added attachments are stored inside the database so every added attachment adds its size to the needed db size. Since the amount of substances and dossiers will differ between companies, we do not have a model for disk requirements.

2 CPUs with 2 GHz clock rate and 2GB RAM are needed.

What architecture does IUCLID 5 apply?

IUCLID 5 is a three-tier application, the three tiers being:

- database tier
- server tier
- client tier

This architecture is fully implemented for distributed installations; in order to simplify installation and running tasks for simple stand-alone installations, the middle tier is physically executed within the JRE environment in a workstation installation.

Can IUCLID 5 work in a multi-tier application environment where the Web Server, Application Server, and Oracle Server are all on separate servers?

Yes. However, it is important to note that IUCLID 5 is not a classical web application, i.e. no HTML will be produced for displaying the user interface, as pointed out in the answer to question 1. Therefore a separate web (additional to the used servlet container) server will not be used.

How will the IUCLID 5 client software be distributed to the client workstations in distributed installations?

By using the JNLP / Java WebStart technology, which is included in the JRE 5.0. No local physical intervention is required to install the IUCLID 5 client. Web Start will automatically retrieve the application from the local IUCLID 5 server once the IUCLID WebStart link is clicked for the first time: The application is installed and can then be used. Subsequent calls of the application will of course not need the installation step (unless a new version of the application is detected).

How can I differentiate between different IUCLID installations?

  1. Colour of the background

    The colour of the background or user interface theme can be changed by selecting user preferences from the IUCLID 5 Task Panel and clicking the User interface theme combo box to select a preferred colour. The colour options are: || Blue || Grey and Blue || Grey || Light Brown || Green || Pitch Black ||.

  2. Setting the Default Client Window Title

The default client window title can be configured in IUCLID 5. This feature is available in IUCLID 5 version 5.1.1. or newer.

The window title is configured with the property "connection.client.window.title". The IUCLID 5 client reads this property and sets the window title as defined in this property.

There are two possible types of clients in a distributed IUCLID 5 installation: locally installed clients and clients launched through the Java Webstart mechanism. The property "connection.client.window.title" is defined in the file "client.properties" for a locally installed client. The typical IUCLID 5 client is started through the Java Webstart mechanism. Webstart Clients receive the file "client.properties" from the IUCLID 5 server. The file "client.properties" is dynamically created by the IUCLID 5 server. Administrators can use the file "jnlp.properties" to configure the generation process of the file "client.properties" and include the default window title for clients in this file.

The file "jnlp.properties" can be found in the IUCLID 5 server war in the i5client folder, i.e. locate "i5client/jnlp.properties" in the extracted WAR file.

The file "jnlp.properties" contains the following lines: 


#
# Properties file for the creation of a JNLP descriptor
#

# Directory containing all components of the application (JARs, Properties)
dir=/i5client/jars

# Pattern for retrieving files within 'dir' as regex
# Example:
# pattern=(.*\\.jar|.*\\.properties|.*\\.xml)
pattern=(.*\\.jar$)


# Listing of libraries that have to be added as nativelib to the jnlp
# Note:
# This parameter is also used to reduce the listing matched by 'pattern'.
# If a library is listed in 'natives' and is also matched by 'pattern' it
# will only be included as  and not as .
# Manually created listings in 'jars' are NOT modified. To keep these two properties
# in sync ist the task of the developer!
natives=jdic-native.jar


# FALL-BACK:
# Normally config.jsp will determine the JARs which belong
# this JNLP application automatically from the content of
# the directory given in the parameter 'dir' above and the
# regex provided with 'pattern'
#
# On BEA WebLogic this is not possible when the webapp
# was deployed as a WAR file. As a fall-back mechanism
# this list will be used instead.
#
# CAUTION:
# The paramters dir is needed despite this fall-back

#
# Properties shown in WebStart
#

# The title shown when starting the application
webstart.title=IUCLID5

# The vendor's name shown
webstart.vendor=European Commission

# The project home page displayed in SUN's WebStart manager application
webstart.homepage=http://www.iuclid.eu/

# A description of the application
webstart.description=IUCLID5

# The icon to be shown in WebStart
webstart.icon.file=images/start-button.png
webstart.icon.width=48
webstart.icon.height=48

# Java version
webstart.javaversion=1.5+

# The main class to be started
webstart.mainclass=eu.eca.iuclid.client.ClientLauncher

# The JAR containing the main class of the application (Only state the file name without path)
webstart.mainclass.jar=i5client.jar

# Optional explicit JNLP descriptor timestamp in ISO-8601 (GMT) format
# YYYY-MM-DD hh:mm:ssZ (2002-04-23 19:21:05Z)
# http://java.sun.com/j2se/1.4.2/docs/guide/jws/downloadservletguide.html
webstart.explicit_timestamp=2007-06-01 12:00:00Z

Modify the file "jnlp.properties" and add the lines: 


# default window title for clients 
connection.client.window.title=Staging

This modifies the default window title of all IUCLID 5 clients that are started via webstart from the IUCLID 5 server with the modified "jnlp.properties" to "Staging".

How can I connect to IUCLID 5 through a proxy server?

Please refer to the IUCLID 5 Proxy Configuration Manual.

When attempting to install IUCLID 5 from a Terminal Services session, why do I receive an error message?

Unfortunately, the PostgreSQL backend won't run from a TS session, and in order to do initdb, the installer has to start a standalone backend. Therefore, installation has to be performed from the console. If you are using Windows Server 2003, you can get remote access to the actual console and not just an administrative session. To do this, start the Remote Desktop Connection by executing mstsc /console, and then connect as usual. This will lock the local console of the server and give you control over that session. In this scenario, PostgreSQL should install just fine. Please see the PostgreSQL FAQ’s.

Once you have successfully managed to install the PostgreSQL database, the IUCLID 5 installation should succeed.

How can I ensure that my data is backed up in my PostgreSQL/Oracle database?

Backup of the PostgreSQL database can be done with the pg_dump tool, which you can automate by running it as a scheduled task in windows. You do not need to close IUCLID 5 when running this scheduled task.

The following steps are required to set up a scheduled task in windows:

  1. Select "add scheduled task", & a wizard will start
  2. Choose pg_dump.exe as the command
  3. Set the schedule Daily at 2:00 AM for example
  4. When the wizard finishes, open the properties of the task and add the following command parameters: pg_dump.exe -i -h localhost -p 5432 -U postgres -F c -b -f "c:\Temp\iuclid5.backup" postgres

IMPORTANT: IUCLID 5 stores the attached documents as binary large objects, therefore the -b option must be used in order to include them in the backup.

If asked for a database password for the user postgres check the installation log file which can be found in the folder C:\Document and Settings\<your name>\Local Settings\Temp\iuclid50<installation date-time>.log

Please do not forget to test the restore of the backup on a different computer with the following command: pg_restore.exe -i -h localhost -p 5432 -U postgres -d postgres -O -v "c:\Temp\iuclid5.backup"

You can find more information and details on the PostgreSQL website

Oracle database backup is explained very well on Oracle's FAQ website section where they discuss general backup and recovery questions, User managed backup and recovery and RMAN backup and recovery.

Common Installation Problems

I get an error code 500 when trying to connect to IUCLID 5 from the Webserver, why?

Server Error 500 is a generic error code, which means that the IUCLID 5 client application is unable to communicate with the server. 
In order to identify the cause of the problem please follow these steps:
 
1. Stop Tomcat.
2. Delete all the log files in the folder "C:\Program Files\Apache Software Foundation\Tomcat 5.5\logs"
3. Delete all the i5server.log files in the folder "C:\Program Files\Apache Software Foundation\Tomcat 5.5"
4. Start Tomcat
5. Verify the status of IUCLID 5 server again on the webpage http://yourserver:8080/i5server/ (where 8080 is the port number you have used)
6. If the server status is not OK then please look into the i5server.log file in the folder "C:\Program Files\Apache Software Foundation\Tomcat 5.5"
7. Please send us the i5server.log file found in the C:\Program Files\Apache Software Foundation\Tomcat 5.5" subdirectory. (If this log is empty and you created a IUCLID account, be sure that this new user you created has full rights to write, since it is possible that this user does not have enough rights and that is why he/she is not able to write the log).
If you see something similar in the log file to:
 
2007-11-15 21:50:15,835 [Thread-1] ERROR eu.eca.iuclid.server.AbstractSystemBootStrap - System bootstrap failed
eu.eca.iuclid.common.service.ServiceException: Connection to the database (jdbc:postgresql://localhost:5432/iuclid5) could not be established:
FATAL: password authentication failed for user "postgres"
 
it means that you may have entered the wrong login or/and password and that is why the error messages appears.
 
Please check the settings of the server.properties file:
-----------SNIP----------------------
#
# Settings for using PostgreSQL
#
hibernate.connection.username=postgres
hibernate.connection.password={aTVQb3N0Z3Jlcw==}
hibernate.connection.driver_class=org.postgresql.Driver
hibernate.connection.url=jdbc:postgresql://localhost:5433/iuclid5
hibernate.hbm2ddl.auto=validate
hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
hibernate.jdbc.use_streams_for_binary=false
 
-----------SNIP----------------------

Ensure that the correct database username and the correct password have been entered - please rewrite the password in clear text and without the curly brackets.
 
We also recommend that you check the location of the server.properties file. It should be in the webapps\i5server\WEB-INF\classes subdirectory.
 
Please also check that you can log into the database with the "IUCLID"  database username to test the database connection.
 
When starting the webpage, the server status should be "OK".

If you still encounter problems, when using the url: http://servername:8080/i5server  to connect to the IUCLID 5 application, on the computer where you get the error code, run the following test:
1) type the full server name including the domain name, for e.g.
 http://servername.domainname:8080/i5server/
2) type the IP address of the server, for e.g.  http://10.1.10.40:8080/i5server/  
3) check  the DNS settings of clients. Do all clients have the same problem?

Please also check the settings on javaws
- Select  Start/Run/javaws
- Edit/Preferences/Network Settings

Installation fails with error code 1326, why?

If installation fails with error code 1326 Logon failure: unknown user name or bad password, do the following:

- Check that the "postgres" service is running (Right-click on the My computer icon, select Manage, Select services and applications, select services).

- Send the IUCLID 5 Support Team following log files so that they can analyse your problem further: C:\program files\iuclid5\workstation\i5workstation.log and C:\program files\iuclid5\postgres\pg_log\postgresql-2007-06-16235839.log (or similar), where "postgresql-2007-06-16235839" is the most recent postgresql log file.

- Also check that the workstation.properties file settings are correct, they should look similar to:
-----------SNIP----------------------
hibernate.connection.username=postgres
hibernate.connection.password={aTVQb3N0Z3Jlcw==}
hibernate.connection.driver_class=org.postgresql.Driver
hibernate.connection.url=jdbc:postgresql://localhost:5432/iuclid5
hibernate.hbm2ddl.auto=validate
hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
hibernate.jdbc.use_streams_for_binary=false
-----------SNIP----------------------

- Check that the correct database username and the correct password have been used - rewrite the password in clear text, without the curly brackets

- Ensure that the service account has write access permission to the installation directories. If not, then this causes errors. By default all users have permission to write to the default installation directory, C:\Program Files\... but if your company have stricter security policies, these privileges might have been removed. For example: if you have created a user postgres to create and run the postgreSQL service, this user needs permissions on the installation directory.

- Create the user postgres before installation, and ensure the following:
o The user must not belong to any administrator or power users groups. The user must be a local user.

- The PostgreSQL service account needs read permissions on all directories leading up to the service directory. It needs write permissions only on the data directory. Specifically, the user should not be granted anything other than read permissions on the directories containing binary files. (All directories below the installation directory are set by the installer, so unless you change something, there should be no problem with this).

- In the Local Security Policy, with MMC, set the rights for the PosgreSQL user: "Log on as a Service", "Log on locally" (needed for installation only), "Log on as a Batch job", "Act as part of the operating system"

- Disable all antivirus and firewall software for the time of the installation. If you still get error messages, we recommend that you then install IUCLID 5 manually. Please download the IUCLID 5 Standalone version Microsoft® Windows® Installation Guide (manual) from the IUCLID5 website and follow the instructions in the document.

Installation fails with error code 1385, why?

Error code 1385 means that your user does not have the "logon as a batch job" rights.  When installing PostgreSQL please ensure that the service account has write access permission to the installation directories. If not, then this causes errors. By default all users have permission to write to the default installation directory, C:\Program Files\... but if your company has stricter security policies, these privileges might have been removed. For example: if you have created a user postgres to create and run the postgreSQL service, this user needs permissions on the installation directory. Create the user postgres before installation, and ensure the following:

- The user must not belong to any administrator or power users groups
- The PostgreSQL service account needs read permissions on all directories leading up to the service directory. It needs write permissions only on the data directory. Specifically, the user should not be granted anything other than read permissions on the directories containing binary files. (All directories below the installation directory are set by the installer, so unless you change something, there should be no problem with this).
- In the Local Security Policy, with MMC, set the rights for the PosgreSQL user: "Log on as a Service", "Log on locally" (needed for installation only), "Log on as a Batch job", "Act as part of the operating system"
- Disable all antivirus and firewall software for the time of the installation.

Startup fails with error code 1069, why?

The "Error 1069: The service did not start due to a logon failure" occurs when:

- The password is changed on the account the service is configured to use to log on (i5postgres)
- The password data in the registry is damaged
- The right to "log on as a service" is revoked for the specified user account.

Solution
You need to update the password in the i5postgres_port_5433 service account on the host computer.
If the password data in the registry is damaged, you need to re-install (try this as a final solution).

The account being used for the service to logon with has not been granted the "Logon as a Service" security policy. Windows Systems vary in how to achieve this; the most common are highlighted below.

As an administrator, open the service properties from the Services dialog box (Start > Settings > Control Panel, Administrative Tools, Services) and ensure the user is listed in the Logon tab. Click OK. A message should be returned that says the user has been granted the Logon as a Service policy.

Or
Start > Settings > Control Panel. Open Administrative Tools and open Local Security Policy.

Find the Logon as a Service policy (Windows Settings/Security Settings/Local Policies/User Rights Assignment/Log on as a Service) and double-click to open the properties page. Click the Add button to open a dialog box that will enable you to add the user starting the service. Click OK to close the property page. Reload the policies by right-clicking Security Settings and choosing Reload.

Also ensure that "Log on locally" (needed for installation only), "Log on as a Batch job" and "Act as part of the operating system" are selected. The i5postgres user account also needs these rights.

With Tomcat 5.5.26 HTTP 500 error message is displayed in the browser.

After having successfully installed the distributed version of IUCLID5 with Tomcat 2.2.26 (or later), the HTTP 500 error message is displayed in the browser, followed by details of the error.

Please find here the explanation and how to fix the problem.

around corner