Documentation | Training | Links | Get Reference substances | IUCLID format | FAQ | ECHA Helpdesk Contact | Get EC Inventory

FAQ

  1. What is IUCLID 5?

Login

  1. When I try to log into IUCLID 5 for the first time, why can I not log in?
  2. 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? (updated 04 October 2013)

Data Entry

  1. When searching for a Substance/ Reference substance, I do not get the expected results. What is wrong?
  2. 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?
  3. Please explain data exchange
  4. Why is there no comment in modification history for pasted endpoints?
  5. Why does the clipboard short cut key (F8) not work?
  6. Text printed from rich text areas in IUCLID may not always have the same formatting as on screen
  7. 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.
  8. How can I create my own Reference substance(s)?
  9. How can I create multiple substance datasets from the same Reference Substance assigned to different Legal Entities?
  10. What do the symbols preceding each IUCLID 5 section or subsection mean?
      (updated 05 December 2012)
  11. Why can I not import legal entity objects (LEOs) from REACH-IT into IUCLID versions prior to 5.4? (updated 17 June 2013) (updated 16 December 2013)
  12. How can I assign a legal entity to my user?
  13. Can I use the Import/Export function of IUCLID 5 as a method of data synchronisation?

Import/Export

  1. Why do export file contents differ slightly?
  2. I received the error : "error java.lang.OutOfMemoryError". What am I to do?
  3. When exporting a dossier, why do I sometimes get a different number of exported files?
  4. How can I verify that the IUCLID files I have received from a Third Party (e.g. the lead of a joint submission) are correct?

Plug-ins

  1. Which plugins are compatible with which versions of IUCLID? (updated 04 October 2013) (updated 14 March 2014)
  2. When trying to run the TCC plugin on a substance or on a dossier (by selecting the REACH substance/dossier I have created), I am getting an error message indicating that the TCC plugin can only check dossiers created with a REACH-specific template. What is wrong?
      (updated 05 December 2012)
  3. When I run the Validation Assistant (TCC), I get a SYS1500 error message, why?
      (updated 05 December 2012)  (updated 14 March 2014)
  4. How can I clear the IUCLID 5 cache? (updated 04 October 2013)


Upgrade and migration

  1. What is the purpose of the IUCLID Backup plugin? (updated 04 October 2013)
  2. Can I import a file generated with a previous IUCLID 5 version to the latest IUCLID 5 version?  (updated 05 December 2012) (updated 16 December 2013)
  3. Where can I find information on the changes performed during the migration process?  (updated 05 December 2012)
  4. Can the backup and migration processes be parallelised?
  5. I have upgraded to IUCLID 5.3 and I receive an error message while opening attachments. Why?
  6. Error message Connection to the database (jdbc:postgresql://localhost:5432/iuclid5) could not be established: FATAL: password authentication failed for user 'iuclid5' (published 15 February 2012) Updated (updated 30 May 2014)
  7. How do I modify the IUCLID 5 home folder location?  (updated 05 June 2012)
  8. The user accounts have expired. What should I do?  (published 05 June 2012) (updated 04 October 2013)
  9. When restoring users account in IUCLID 5.3.2, an error message is displayed. How can I fix it?  (published 05 June 2012)
  10. The distributed versions of IUCLID 5.3 or 5.4 do not run on my Oracle database after upgrading. I get the error message 'Loading a JDBC driver failed’. What is wrong?  (published 05 June 2012)
  11. When I launch IUCLID 5.4.1 I receive the following message: Error during initialisation. The following exception was thrown: org.hibernate.HibernateException: Missing column: includeAnnotations in public.dossierrecreationinfo  (published 19 October 2012)
  12. Which version of IUCLID should I use? (published 27 March 2013) (updated 04 October 2013)
  13. How can I upgrade from IUCLID 5.2x/5.3x to IUCLID 5.6 and still be able to access all my existing data? (published 27 March 2013)(updated 17 April 2014)
  14. How can I upgrade from IUCLID 5.0/1 to IUCLID 5.6 and still be able access all my existing data? (published 27 March 2013)
  15. When upgrading IUCLID, can I use the IUCLID functions Back-up and Restore, instead of using the database migration process that is carried out when the installer is run in upgrade mode? (published 27 March 2013)
  16. When a user tries to open an attachment, a "Service error on server (SYS1500)" is reported New (published 30 May 2014)

Installation

  1. In Vista/Windows 7, I receive an error message "pgpass.conf does not exist" when trying to update to IUCLID 5.2.x. How can I run the update successfully?
  2. I do not know how to start the IUCLID Installer on Windows Vista. What must I do?
  3. I cannot install IUCLID 5 on my Windows 7 computer, why?
  4. What architecture does IUCLID 5 apply?
  5. Can IUCLID 5 work in a multi-tier application environment where the Web Server, Application Server, and Oracle Server are all on separate servers?
  6. How will the IUCLID 5 client software be distributed to the client workstations in distributed installations? (updated 04 October 2013)
  7. How can I show a difference between different IUCLID installations in the IUCLID interface?  (updated 05 December 2012)
  8. How can I connect to IUCLID 5 through a proxy server?
  9. How can I make a backup of my IUCLID database?  (updated 27 March 2013)  (updated 14 March 2014)
  10. How to find the IUCLID 5 log files? (updated 04 October 2013)
  11. When attempting to install PostgreSQL on Vista I get the error message ”Database Cluster Initialisation Failed” at the end of the installation, what can I do?
  12. What are the recommended software and hardware requirements for IUCLID 5.5? (updated 11 September 2013)
  13. How can I distinguish user accounts when using Windows, IUCLID 5 standalone installation and PostgreSQL database? Updated (updated 30 May 2014)
  14. Which PostgreSQL version should be used with IUCLID 5? (updated 05 June 2012) (updated 16 December 2013)
  15. How to download the correct PostgreSQL version with IUCLID 5?  (updated 07 December 2011) (updated 16 December 2013)
  16. How can I uninstall IUCLID 5 standalone version from my Windows PC? (updated 16 December 2013)
  17. What is the compatibility between versions of IUCLID 5 and Java? (published 27 March 2013) (updated 16 December 2013)
  18. Which version of Java should I use with IUCLID 5.4.1 or 5.5? (published 27 March 2013) (updated 16 December 2013)
  19. Can I have both Java 6 and Java 7 installed on a computer at the same time? (published 27th March 2013)
  20. I have a shortcut on my Windows Desktop for IUCLID that was created by the Windows installer. When I use it to launch IUCLID, Java 6 is used. How can I change it to select Java 7? (published 27 March 2013)
  21. I am unable to connect to a distributed instance of IUCLID 5.4.1 or 5.5 using Java 7. I click on the web link, but I cannot get to the IUCLID interface. What is the problem? (published 27 March 2013) (updated 16 December 2013)
  22. How can I find out the version of Java that Windows uses by default on my computer? (published 27 March 2013)
  23. I have a shortcut on my Windows Desktop for IUCLID 5 that was created before version 5.4.1. When I double click on it, I get the following error: "The item 'javaw.exe' that this shortcut refers to has been changed or moved, so this shortcut will no longer work properly." (published 27 March 2013)
  24. I have a standalone installation of IUCLID prior to version 5.4.1 that was installed using the Windows installer. The Java version has been upgraded to Java 7, and now IUCLID does not run. How can I access my existing IUCLID data? (published 27 March 2013)
  25. Why does a "Connection attempt time out" error appear during the IUCLID 5 installation? (published 17 June 2013)
  26. IUCLID 5 does not start, but the following error message appears: "Error during initialisation. The following exception was thrown: Connection to the database (jdbc:postgresql://localhost:5432/iuclid5) could not be established. Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections".(published 17 June 2013) (updated 16 December 2013)

Common Installation Problems

  1. I get an error code 500 when trying to connect to IUCLID 5 from the Webserver, why?
  2. ‘Cannot create the destination folder’ error is displayed during the installation on Windows 7. What am I to do?

Known Issues- IUCLID application

Distributed Version
  1. After Java 7 update 51 it is not possible to launch the IUCLID 5 distributed client (published 16 December 2013)  (updated 14 March 2014)
  2. After Java 7 update 45 it is not possible to launch the IUCLID 5 distributed client (published 5 November 2013)
  3. Java memory issues on the server side of a IUCLID 5 distributed installation New (published 30 May 2014)
IUCLID 5.5.0
  1. After migrating to IUCLID 5.5.0 I cannot access the User management and Role management tools of IUCLID. Instead, I get the following error message "Service error on server (SYS1500)". (updated 11 September 2013)
IUCLID 5.4.1
  1. A user receives an incorrect message that they have exceeded the number of log in attempts allowed.(published 30 January 2013)
IUCLID 5.4
  1. After modifying the Exposure Scenario in Section 3.5 for a particular Use, the text in the table (under Exposure Scenario in section 3.5) is not refreshed and remains the same. When double clicking the Use, the correct link is displayed, but the Identifiers shown in the field are still the old ones.(published 27 July 2012)
IUCLID 5.3
  1. I cannot give a public name if the length is more than 255 characters. Why?
  2. Why can I not re-create the index with the Query plugin version 5.3.0?
IUCLID 5.2.2
  1. Even though I select check the checkbox "Reviewed by an assessor" when creating my dossier, the checkbox disappears later. When I run the TCC I get a TCC failure. Is this normal? Will my dossier fail when I submit it to ECHA?
  2. Even though I have ticked "Review by an assessor" in my dossier header and attached a "Review by an assessor" report in the dossier header, when submitting my dossier to REACH-IT, I get a "document not found" error message. What must I do in order for my dossier to be accepted?
IUCLID 5.2.0
  1. I cannot save my data in sections 3.5 and sections 3.6 in IUCLID 5.2. Is it normal?
  2. I cannot attach documents in section 1.4 of IUCLID 5.2, is it normal?

Known Issues- IUCLID plug-ins

Report Generator /version 5.5.1
  1. When trying to generate the CSR, no “rtf” file is generated.   (published 14 March 2014) Updated (updated 30 May 2014)
  2. I receive validation errors when I try to import a IUCLID file after I previously synchronised its content with Chesar data using the Report Generator   (published 14 March 2014)
Dissemination plug-in / version 5.4.1 running in IUCLID 5.5
  1. The content of the endpoint study records is not correctly filtered by the Dissemination plug-in when I use it with IUCLID 5.5 (updated 5 July 2013)
TCC plug-in / version 5.4.0
  1. I get the following BR200 failure when running the TCC plugin version 5.4.0 on my IUCLID substance dataset / dossier: Section 1.7 – Suppliers, Other importers: “You have attached a document to this substance dataset / dossier that lacks content. To ensure that your dossier contains all intended information, please ensure that you have attached the correct and complete documents before creating the dossier and submitting it.”However, I have verified that the document attached in this location is complete. What should I do?
    (published 27 July 2012)
CSR plug in / version 5.4.0
  1. Using the CSR plugin 5.4.0 on IUCLID 5.4.0 distributed version (Linux server), the titles and headers are missing from the CSR report.
    (published 27 July 2012)  (updated 05 December 2012)
CSR plug in / version 5.4.1
  1. When I try to synchronize the uses in the CSR plugin, I receive the error message: "Document access failure. It's possible the document is already locked for writing, or otherwise inaccessible" (published 27 March 2013)
  2. When I synchronise the uses in the CSR plug-in, the information I entered in the Chesar “internal remark” fields available in box 2 are transferred to IUCLID section 3.5.(published 17 June 2013)

Questions related to REACH Registration

  1. UUID synchronisation between REACH-IT and IUCLID 5 (video included) Updated (updated 30 May 2014)
  2. How can I check that my Legal Entity is the same in section 1.1 of IUCLID 5, in the dossier header and in REACH-IT? Updated (updated 30 May 2014)
  3. How can I check that my attachments is section 1.4 have been included when I submit my dossier?
  4. How can I ensure that I run the latest version of the Validation Assistant/TCC plugin on my substance dataset or dossier?
      (updated 05 December 2012) Updated (updated 30 May 2014)
  5. When I run the Validation Assistant plugin on my dossier, several Business Rules failures (BR failure) or Technical Completeness check failures (TCC failure) are detected. How can I correct them? Updated (updated 30 May 2014)

Questions related to Classification & Labelling Notification

  1. How can I run the Validation Assistant plugin for a Classification and Labelling (C & L) notification? Updated (updated 30 May 2014)

Questions related to Biocides

  1. How can I link compositions to C&L sections in a biocidal product in IUCLID 5?  (updated 04 October 2013)
  2. Is there a specific IUCLID 5 template for micro-organisms?  (published 04 October 2013)
  3. How can I use the Report Generator in IUCLID 5 to generate a Summary of Product Characteristics (SPC)?  (published 04 October 2013)
  4. Is there a Technical Completeness Check (TCC) plug-in available to check biocides dossiers prepared under the EU Biocidal Products Regulation (BPR)?  (published 04 October 2013)
  5. Which IUCLID template to use (and from which object should the dossier, substance or mixture be created) when creating the following type of dossier: application for inclusion on the list of active substance suppliers (BPR Art. 95)? (published 04 October 2013)
  6. How to provide the Legal Entity for the components of a biocidal product (active substance, non-active substance, substance of concern, mixture)? Whose Legal Entity should be inserted? New (published 30 May 2014)

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 and for the Member state competent authorities, IUCLID 5 is the:

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

IUCLID 5 data complies 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 which is 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.

  Back to Top


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 “”).

  Back to Top


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 may be filtered out and considered as 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. If this is the case, we advise you to contact your system administrator in order to validate the iuclid5@echa.europa.eu email address and set it up as a trusted address. You should then contact the ECHA Helpdesk via the contact form, so that we can activate your account manually.

  Back to Top


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*.

  Back to Top


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.

  Back to Top


Please explain data exchange

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

  Back to Top


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.

  Back to Top


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.

  Back to Top


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.

  Back to Top


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.

  Back to Top


How can I create my own Reference substance(s)?

There are two types of inventory lists, the EC inventory and the Reference substance inventory.
The EC inventory (the chemicals identifiers catalogue) contains approximately 70.000 Reference substances and is centrally managed and provided by the European Commission/ European Chemicals Agency.
The Reference substance inventory is a local inventory managed and upgraded by the users on their IUCLID installations as appropriate.

To create your own Reference substance(s), follow the steps below:

  1. Go Home to the Task panel if you are not already there
  2. Under Reference substance click New
  3. The Reference substance wizard comes up and prompts you to enter a name for the Reference substance. This name should be unique in the IUCLID database.

  4. Click the Finish button.
  5. The Reference substance is created and the data entry window opens.

    Note: You are free to assign any name to the Reference substance. Nevertheless a chemical identifier (e.g. EC number, EC name, CAS number, CAS name, IUPAC or other) can help keeping the Reference substance inventory well organised.

  6. Once you have created the reference substance you will then be able to link it to your substance dataset in section 1.1 of IUCLID 5. Click the Link button to select the Reference substance and establish the link.

This information is also available at the IUCLID 5 End-user Manual, Section 11.3-Feature'Reference substance-New':How to create a Reference substance. This document is fully integrated in the IUCLID 5 help system.

  Back to Top


How can I create multiple substance datasets from the same Reference Substance assigned to different Legal Entities?

A) Use a substance dataset as a 'Template'

  1. Create a substance dataset, and complete all the necessary information

  2. Left click on the arrow as illustrated in the image below, and select ‘Copy contents to clipboard’

  3. Keep the clipboard open

  4. From the 'Tasks' menu, select a 'New' Substance

  5. Give a new name to your substance and assign a different Legal Entity to it

  6. From the clipboard menu, select 'Paste all items from clipboard' (do not select the option 'Paste reference for all items from clipboard' as it will only paste the links and not the actual data)

  7. Press 'yes' to the following warnings (below one example)

  8. The Substance now contains all the fields which have been pasted from the clipboard, it is assigned under a different Legal Entity and has a different name.

B) Use the 'Template' functionality (IUCLID End-user manual D.5.1.- What is a Template dataset?)

B.1) Type of template: 'COPY'

  1. From the Tasks menu, select 'New Template' and select 'Copy' as the type of template

  2. Fill in all the information which will be used later at the creation of your substance datasets

  3. Copy the data to the clipboard

  4. From the 'Tasks' menu, select a 'New' Substance

  5. Select 'Paste all items from clipboard'(do not select the option 'Paste reference for all items from clipboard' as it will only paste the links and not the actual data)

  6. The substance dataset now contains all the data which have been pasted from the clipboard

B.2) Type of template: 'INHERIT'

'Inherit' type Template: For 'inheriting' endpoint data to specific substance dataset(s). This means that a substance dataset refers to one or several Endpoint study record(s) or endpoint summary record(s), which are seamlessly available in the substance dataset. Because the referred endpoint data are then write protected in the target Substance dataset, it is obvious that this type of Template is only sensible in cases where complete records can be used. If the source records are modified in the Template, the corresponding records in the substance dataset(s) will be updated accordingly.

A major advantage of managing Endpoint records in an Inherit Template is that the endpoint data are created and updated in one container only, but can be used in several substance datasets. This can be of particular relevance for organising endpoints for similar substances. For instance, it may be sensible to store all endpoint data for substance A in Template A and all data for substance B in Template B. By creating different associations it will then be possible to create different dossiers to fulfil specific requirements, e.g.

Dossier 1 for substance A (Template A assigned to substance A only)

Dossier 2 for substance B (Template B assigned to substance B only)

Dossier 3 for substance C (Templates A and B assigned to substance C)

This example is illustrated for the fictitious case of the substance naphtalene (substance C), which is produced in two different specifications, i.e. naphtyl (substance A) and naphtynol (substance B). It is even possible to store all endpoint data in one Template and make the selection of records to be included in the dossier in the dossier wizard (see IUCLID 5 End-user Manual Chapter D.8 Dossier -Create Dossier and browse Dossier data).

The following figure illustrates how substance datasets can be filled with endpoint data by referring to Inherit Templates:

Note: You need to modify the modification history in the XML file, as all changes (including Legal Entity information) will be displayed in the modification history. You can find instructions on how to change the modification history after export, in our FAQ 'Please explain data exchange'. This will prevent confidential data in this section from being displayed.

Important information and further features can be found at section 'D.4.10- Creating a copy a substance dataset', 'D.4.7.9- Copying Endpoint study records' and D.5- Template, 'Create and update Template related information' of the IUCLID 5 End-user Manual . This document is fully integrated in the IUCLID 5 help system, and answers specific questions on IUCLID 5 functionalities in an easy and friendly way.

  Back to Top


What do the symbols preceding each IUCLID 5 section or subsection mean?

The meaning of the symbols preceding each section or subsection (if expanded) is as follows:
is the symbol displayed for subsections subsumed under sections 1 to 3 only indicating that these subsections are handled as records per se as opposed to sections 4 to 14 where records have to be created. For further information, see chapter D.4.6.1 Differences between sections 0 - 3 and sections 4 – 14 of the IUCLID 5 End-user manual.
means that a section is closed on the section tree, i.e. subsections can be expanded by clicking the Plus symbol
means that a section is open on the section tree, i.e. all subsections are expanded.

For the section titled 0 Related Information, where relations to Templates, Categories and Mixtures are indicated, the following symbols are displayed:
denotes section 0.1 Templates
denotes section 0.2 Categories
denotes section 0.3 Mixtures

In the Complete view mode, the symbols above (apart from those for section 0 Related Information) are all coloured green. When you select another view mode, you will notice differently coloured symbols. The colours have the following meanings:
Green: optional data point, i.e. no formal data requirement, but information can be provided
and colour red: required data point. Please note that the indication that the data is required for a given regulatory purpose is for information only. Depending on specific conditions this indication can be unreliable.
and colour red: required data point without information available yet. Please note that the indication that the data is required for a given regulatory purpose is for information only. Depending on specific conditions this indication can be unreliable.

  Back to Top


Why can I not import legal entity objects (LEOs) from REACH-IT into IUCLID versions prior to 5.4?

The current version of REACH-IT is based on IUCLID 5.4 and only accepts dossiers generated by IUCLID 5.4 or more recent versions of IUCLID 5. The legal entity object (LEO) exported from REACH-IT complies with the IUCLID 5.4 format and therefore cannot be used with versions earlier than IUCLID 5.4.

IUCLID 5 is 'backward compatible' which principally means that any files generated with a newer version of IUCLID cannot be imported into an older IUCLID 5 version. As an exception to this, the files generated with IUCLID 5.5.1 remain compatible with IUCLID 5.5 (and IUCLID 5.4 for REACH data). See FAQ Can I import a file generated with a previous IUCLID 5 version to the latest IUCLID 5 version?

  Back to Top


How can I assign a legal entity to my user?

  1. Log in as SuperUser
  2. Go to Tools and administration and choose ‘User management’
  3. Select your User from the left pane
  4. Click the green Plus button under assigned Legal Entities.
    The following dialog appears:
  5. Enter your search criteria (wildcards such as * can be used)
  6. Click the Search button to run the query. IUCLID 5 returns a list of Legal Entities meeting your search criteria

    If your list appears empty, deselect (untick) 'show only active values', and follow the instructions in the previous point to 'activate' your Legal entity.

    if a Legal entity appears 'greyed out' in the list, you need to 'activate' it before assigning it. To do so, right-click on the Legal entity name and select 'Active trade partner'.

  7. Select the Legal Entity and click the Assign button to complete the process.

  8. Click the Save button. The following message appears. Click OK

  9. Log out (as SuperUser) and log in again as your User.

  Back to Top


Can I use the Import/Export function of IUCLID 5 as a method of data synchronisation?

Below, we illustrate an example of Import/Export between two different IUCLID 5 environments, identifying the actions taken within each step and the final result.
Details of the synchronisation steps indicated in the image above:

  1. Creation of substance dataset X in IUCLID instance A
    -Creation of Endpoint in section 4.1
    -Creation of Endpoint in section 4.2
    -Creation of Endpoint in section 4.3
    -Creation of Endpoint in section 4.4
  2. Export the substance dataset X file from IUCLID instance A
  3. Import the substance dataset X file to IUCLID instance B
  4. Modification of the substance dataset X in IUCLID instance B
    -Addition of Endpoint 4.5
    -Modification of Endpoint 4.1
    -Deletion of Endpoint 4.2
  5. Export the substance dataset X from IUCLID instance B
  6. Import the substance dataset X to IUCLID instance A

The final result in IUCLID instance A when setting the overwrite mode to:

  1. 'newer than existing' will be:
    -Section 4.1: modified since the version coming from instance B of IUCLID is more recent (of course this is only true if the same endpoint in section 4.1 has not been modified in IUCLID instance A)
    -Section 4.2: exists even though it was deleted at step 4
    -Section 4.3: remains the same
    -Section 4.4: remains the same
    -Section 4.5: is created
  2. 'never' will be:
    -Section 4.1: not modified
    -Section 4.2: exists even though it was deleted at step 4
    -Section 4.3: remains the same
    -Section 4.4: remains the same
    -Section 4.5: is created
  3. 'always' will be:
    -Section 4.1: modified
    -Section 4.2: exists even though it was deleted at step 4  
    -Section 4.3: remains the same
    -Section 4.4: remains the same
    -Section 4.5: is created
  4. 'ask user' will be:
    -Section 4.1: modified
    -Section 4.2: exists even though it was deleted at step 4
    -Section 4.3: remains the same
    -Section 4.4: remains the same
    -Section 4.5: is created

The import/export functionality cannot ensure a full synchronisation of different datasets in all cases and the following principles should be followed:

a) An Endpoint Study Record should be modified only in one IUCLID instance at a time as only the latest update will be available after import if ‘overwrite’ is selected.
b) An existing Endpoint Study record cannot be deleted during the import of a file which does not contain this specific record.
c) Sections 1, 2 and 3 are considered one record. If overwrite is selected, all information available in these sections will be replaced by the ones from the imported file.

These constraints apply to the any update of IUCLID datasets using the Export / Import mechanism. These constraints would be acceptable if users are working on different records or are responsible for a defined set of information. In case several users are modifying the same dataset without clear repartition of tasks, we would advise using a distributed IUCLID version where multiple users can share the same database.

  Back to Top


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.

  Back to Top


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:

Out of Memory

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

  Back to Top


When exporting a dossier, why do I sometimes get a different number of exported files?

1. When CREATING a substance dataset, ensure that you select the appropriate dossier template. Hence, only the required/concerned sections will appear for you to fill in.

  1.1 At this stage, you should make sure that you have flagged your data, choosing the appropriate regulatory programme as can be seen in the example below:

2. When EXPORTING a record/dossier/substance dataset:

  2.1 Select the appropriate dossier template

  2.2 If you have flagged all your data according to the instructions described in step 1.1, you must then select the same flag which you selected previously, for example 'Use restricted to selected regulatory programmes'

However, if you are unsure whether you have flagged all your data, it is then suggested to 'Select All' at both 'Confidentiality' and 'Use restricted to selected regulatory programmes'. This will prevent the exclusion of any necessary information.

  Back to Top


How can I verify that the IUCLID files I have received from a Third Party (e.g. the lead of a joint submission) are correct?

Whenever receiving a dossier or endpoint or any IUCLID document, from a Third Party, we recommend importing it into IUCLID using the standard import mechanism to check that the format is correct. It might be that these files have been created by a tool other than IUCLID, and the format may be invalid. For example, errors such as ‘cvc-complex-type.2.4.a: Invalid content was found starting with element 'i5:LIST_BELOW_POP’ may appear, and they will need to be fixed manually.

  Back to Top


Plugins


Which plugins are compatible with which versions of IUCLID?

The compatibility matrix tables below show which plugin works with which IUCLID version.

Core plug-ins

(These plugins are installed with IUCLID as standard)

Non-core plug-ins

(Those plugins are available as separate downloads)

  Back to Top


When I run the Validation Assistant (TCC), I get a SYS1500 error message, why?

1) Check whether the TCC plugin has been installed correctly. Make sure that you follow the instructions in the Validation Assistant/TCC user manual and copy the files to the correct folder:

Note: For the standalone version, make sure that you copy both files into the correct location

The Validation Assistant/TCC plugin user manual is included in the installation package (zip folder) you have downloaded from http://iuclid.echa.europa.eu.

2) Clear the cache:
Remember to CLEAR YOUR CACHE after an upgrade (for instructions see How can I clear the IUCLID 5 cache?).

Note: Ensure that you have at least 1GB of memory available on your computer.

3) Ensure that there is enough memory available: Make sure that you have at least 1GB of memory available on your computer. Run IUCLID with more memory (for instructions check How to run IUCLID 5 with more memory).

4) If the problem persists, you need to know whether it is caused by:

  a) An installation problem or

  b)Corrupted data

To diagnose which is your case, please follow the instructions below:

a) INSTALLATION

  1. Make sure you have upgraded to the latest TCC version and then clear the cache (as described above).

  2. Run the TCC on an empty test substance (no endpoints, no attachments).

  - If you do not get any error message, proceed to step b) CORRUPTED DATA

  - If you still get an error message, try to re-install the TCC plugin being careful to place the correct files into the correct folders and clear the cache.

b) CORRUPTED DATA

Before executing the following steps, make sure that you have database level and IUCLID level backups of data available. It may also be beneficial to manually save all important data (especially attachment documents) from the substance dataset affected with this issue.  

  If there is no problem with the installation, then most likely there is a problem with the substance. Check if you can open/view/delete any attachments in sections 1.4, 11 and 13 (or if you have attachments elsewhere in your substance dataset).

  - If you cannot, then there are possibly corrupted data/broken links with the attachments in your database.In that case, remove the attachments and re-attach them. Run the Validation Assistant/TCC again.

  - After the removal and re-attachment, if you still get an error message, then try to follow this procedure with the substance affected by this issue:

  1. Install a new, separate instance of IUCLID 5 (i.e. Standalone version) of exactly the same version as the original IUCLID 5 instance.
  2. In the original IUCLID 5 instance, export the raw substance that is affected by this issue.
  3. In the new IUCLID 5 instance, import the substance dataset.
  4. In the new IUCLID 5 instance, as a test, create a dossier for the substance and run the Validation Assistant/TCC plugin. This should run without error. If there is no error, continue with this procedure. If there is an error stop with the procedure and contact the ECHA Helpdesk.
  5. In the new IUCLID 5 instance, export the substance dataset.
  6. In the original IUCLID 5 instance, delete the raw substance.
  7. In the original IUCLID 5 instance, import the substance dataset.
  8. In the original IUCLID 5 instance, create a dossier and run the Validation Assistant/TCC plugin.
  9. If the problem is resolved, then delete all invalid dossiers for the instance.

After this, the new instance of IUCLID 5 is no longer needed. If this does not solve the issue, please contact the ECHA Helpdesk.

  Back to Top


How can I clear the IUCLID 5 cache?

In some cases, it is necessary to clear the IUCLID 5 cache. For example, after the installation of a new version of a IUCLID plug-in, the old version of the same plug-in could still be available in the system cache and may create a version conflict or incompatibility.

The cache can be cleared as follows:

STANDALONE version:

Delete the folder ‘C:\Users\*your username*\.iuclid5\.jpf_shadow’.

This folder will be recreated when you start IUCLID 5 again.

DISTRIBUTED version:

Go to the folder ‘/work/Catalina/localhost’ and delete the ‘localhost’ folder.

It will be recreated when you start IUCLID 5 again.

Furthermore, also ensure that the folder ‘C:\Users\[your username]\.iuclid5\.jpf_shadow’ on the client computer(s) is deleted.

This folder will be recreated when the user reconnects to the IUCLID 5 server.

  Back to Top


Upgrade & Migration


What is the purpose of the IUCLID Backup plugin?

This plug-in is compatible only with IUCLID 5.0 and 5.1. 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. Instead of this plug-in, IUCLID versions from 5.2 onwards directly include a built-in backup functionality, which can be found from the IUCLID 5 application – Administrative tools – Backup/Restore.

  Back to Top


Can I import a file generated with a previous IUCLID 5 version to the latest IUCLID 5 version?

IUCLID 5 files generated with a previous IUCLID 5 version can be imported to the latest IUCLID 5 version.

IUCLID 5 is 'backward compatible' which principally means that any files generated with a newer version of IUCLID cannot be imported into an older IUCLID 5 version. As an exception to this, the REACH information exported from IUCLID 5.5 remains compatible with IUCLID 5.4. The files compatible between IUCLID 5.5 and 5.4 are the REACH (or CLP) dossiers exported from IUCLID 5.5 and the substance datasets exported from IUCLID 5.5 using a REACH or CLP template. In addition, the legal entities exported from IUCLID 5.5.1 have been made compatible with IUCLID 5.4.

IUCLID versions

The migration itself is performed while importing the data into IUCLID 5. As such, the migration of a dataset can be repeated even after removing the previously installed version of IUCLID.

The migration process is encapsulated in the IUCLID 5 client plugin named "i5xform_vxx". If this plugin is removed, the affected IUCLID 5 installation will no longer accept compatible files from the previous IUCLID 5 version.

To migrate IUCLID 4 or SNIF datasets, an old IUCLID installation (5.1.1) has to be used in combination with the SNIF Migration tool and the Migration tool plugins. In a secondary step, the data can be imported and by that migrated into a more recent IUCLID installation.

  Back to Top


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

Relevant migration information is written to the file "iuclidMT.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.

Instructions on how to find IUCLID 5 log files are available at: How to find the IUCLID 5 log files?

  Back to Top


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.

  Back to Top


I have upgraded to IUCLID 5.3 and I receive an error message while opening attachments. Why?

The problem appears because of the insufficient tablespace in the database (DB).

There is a specific migration step, which attempts to first copy all attachments from the ATTACHMENTDOCUMENT.RAWCONTENT column to the new RAWCONTENT.RAWCONTENT column. Note that the RAWCONTENT column contains the actual raw bytes of the attached files. Every attachment is copied in a separate DB transaction. When all the records have been copied, the old ATTACHMENTDOCUMENT.RAWCONTENT column is dropped.

If you have e.g.10GB of attachments in your DB you need another 10GB of free tablespace to ensure that the copy operation completes successfully. If your system has enough space, the migration will certainly succeed.

Use the 'Restore' functionality (from the File menu- Administrative tools) to restore data from a previous IUCLID 5 Back up. Instructions on how to use the 'Restore' functionality can be found at Chapter D.18.3 Restoring backed-up data of the IUCLID 5 End-user manual.
Note that when restoring from the backup you will loose the data which is added and/or modified after the backup has been taken.

  Back to Top


Error message: Connection to the database (jdbc:postgresql://localhost:5432/iuclid5) could not be established: FATAL: password authentication failed for user 'iuclid5'

Parts of this error message can also appear in another language, depending on Windows language settings.
Check that the workstation.properties file settings are correct. The file is usually located at C:\Program Files\IUCLID5\5.6.0\conf\workstation.properties.
The workstation.properties file should look something similar to:
(Note that this is an example of the file)

Modify the settings according to your own information. Check that the correct database, username, password and the port have been used. Rewrite the password in clear text and save the file.

Open PgAdminIII and make sure that the database user is the same as in the workstation.properties file. In this example, the database username is iuclid560.


Check the 'Login Roles', right-click on the login role 'iuclid560', and select 'Properties…'

Re-type the password which you used in the workstation.properties file. In this example, the password in the workstation.properties for the iuclid560 database('hibernate.connection.url=jdbc:postgresql://localhost:5432/iuclid560') is defined in: 'hibernate.connection.password=iuclid5', therefore, type in the same password in the iuclid560 Login Role window.

Back to Top


How do I modify the IUCLID 5 home folder location?

IUCLID 5 stores temporary cache files to the IUCLID 5 home folder .iuclid5, which is by default under the Windows user profile. Sometimes, e.g. if the roaming profiles are in use, there might be a need to modify the IUCLID 5 home folder location.

Since IUCLID 5.4, it is possible to modify the IUCLID 5 home folder location under Tools and Administration/User preferences by entering the home folder‘s path in the 'Cache folder' field. If you have a different path in the startup icon, the default path will be the path specified in this field.

When using the IUCLID 5.3 (or earlier) standalone version, the modification of the home folder location can be done as follows.

Right click IUCLID 5 icon on your desktop and choose properties. Modify the Target-field as marked in red as shown in the example below. Replace the 'C:\Temp' folder given in the example with a folder of your choice in order to define your new IUCLID 5 home folder.
'C:\Program files\Java\jre6\bin\javaw.exe' -Duser.home=C:\Temp -Xms512m -Xmx768m [... rest of the command]

Back to Top


The user accounts have expired. What should I do?

In IUCLID version 5.4.1 and later, each expired account can be unexpired individually from within the user management function. For versions prior to 5.4.1, there are two ways of working around the problem, as described below.

  1. It is possible to simply turn off the expiry feature temporarily. If a user logs in while the expiry feature is temporarily turned off, when it is turned back on again, the account is restored. To turn off the expiry feature, run the IUCLID server with the value of parameter password.expiry set to zero (0) in the settings file server.properties. See the server installation manual section 2.7.2.
  2. 1.The idea is to set the value of the parameter that determines the date when the users last logged in, to a value of never. Once this has been done, the last login dates are no longer too far in the past, so the accounts are no longer expired. The value of the parameter is set by exporting the user data, manually editing it, and then re-importing it. The process is described below:
    • Before proceeding, ensure you have a backup of your IUCLID application and the associated database.
    • In IUCLID 5, log in with SuperUser rights and then select the menu item File / Administrative tools / Backup.
    • At step 1, select only User, user preferences and roles. Choose the password option you require, and then click on next.
    • At step 2, choose an empty folder where the data will be stored and select the option export to multiple xml files (with extension i5D).
    • Click Finish.
    • Make a backup copy of the file usermanagement.i5m in a safe place, other than the export folder.
    • Open the exported file usermanagement.i5m in your favourite text editor.
    • For each account that is to be unexpired, set the value of the XML element lastLoginDate to zero (0), i.e. the XML element is set to:“<lastLoginDate>0</lastLoginDate>”.
    • Save the file usermanagement.i5m.
    • In IUCLID 5, select the menu item File / Administrative tools / Restore.
    • Set the location from which to restore as the folder that contains the newly edited version of the file usermanagement.i5m.
    • Set Overwrite mode to always.
    • At step 2, select only User, user preferences and roles.
    • Click Finish.
    • Under the function User management, check the values of the last login. The value is shown per user at the top of the window.

Note: In versions of IUCLID 5.3.0 and earlier, there is no option to output only the file usermanagement.i5m. All the data is backed-up, which for large databases, can take a long time. However, the file usermanagement.i5m is output first, so if you need only the user configuration, you may interrupt the backup procedure as soon as the user configuration file has been exported.

Back to Top


When restoring users account in IUCLID 5.3.2, an error message is displayed. How can I fix it?

Note: Before proceeding, ensure you have kept a back up of your IUCLID application

In the target folder, where the back up has been saved, there will be a file called usermanagement.i5m.

If this does not work, manually edit the usermanagement.i5m file as explained hereafter.

To restore the usermanagement.i5m XML file, you need to open it with an XML or text editor (for example 'Notepad') and manually edit it. You need to modify the section:

< users>
...
< /users>

to

< users isNewDefaultPwd="true">
...
< /users>

The value of the variable must be:
- true, if the backup contains passwords which the administrator has just reset
- false, if the passwords are the original ones

Save the changes you made to the file usermanagement.i5m and import it into your IUCLID application using the File - Administrative tools - Restore functionality. By doing this, you can restore the user details to your new IUCLID.

Back to Top


The distributed versions of IUCLID 5.3 or 5.4 do not run on my Oracle database after upgrading. I get the error message 'Loading a JDBC driver failed’. What is wrong?

You need to:

  1. Download the ojdbc6.jar driver from the Oracle website: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
  2. Copy it to the IUCLID folder i.e. WEB-INF/lib.
  3. Stop and start Tomcat
  4. Restart IUCLID

Back to Top


When I launch IUCLID 5.4.1 I receive the following message: Error during initialisation. The following exception was thrown: org.hibernate.HibernateException: Missing column: includeAnnotations in public.dossierrecreationinfo

A migration step is needed when upgrading an existing IUCLID installation from version 5.4 to version 5.4.1. If this step is not completed during the installation, it is not possible to start the application and the error message indicated below is displayed.

Please refer to the section 'Upgrading [...] to IUCLID 5.4.1' of the relevant installation manual for more information on how to perform the migration step for IUCLID 5.4.1.

Back to Top

Which version of IUCLID should I use?

ECHA recommends using the most recent version of IUCLID to ensure that you have access to the latest range of functionalities, and to minimise the chances of running into problems.

To see how the version of IUCLID used to create a dossier affects its compatibility with a particular regulation, see the documentation specific to that regulation. For example, the upgrade to version 5.5.1 is not compulsory by companies who need to submit dossiers to ECHA. It depends only on the users' will or need to take advantage of the fixes and improvements contained in the latest version.

Files generated with IUCLID 5.5.1 remain compatible with IUCLID 5.5 (and IUCLID 5.4 for REACH data).

Back to Top

How can I upgrade from IUCLID 5.2x/5.3x to IUCLID 5.6 and still be able to access all my existing data?

It is possible to use the migration scripts to upgrade IUCLID stepwise from 5.2x to 5.3x to 5.4x to 5.5. However, unless the database contains a very large amount of data, the following alternative procedure is recommended.

  1. Make a backup of your data in IUCLID 5.2x/5.3x using the built-in backup tool. If you are unable to start IUCLID 5.2x/5.3x, see the previous two FAQ entries on Java and its versions.
  2. If the latest update of Java 7 is not already installed on the installation computer, install it now.
  3. Use the Windows installer to make a fresh installation of IUCLID 5.5. To apply the best possible protection to the data from IUCLID 5.2x/5.3x, it is recommended to keep the existing database until IUCLID 5.5 up and running with all the IUCLID 5.2x/5.3x data accessible. To do this, on page three of the installer, ensure that the database name has the value iuclid550, as shown below.
    database name
    This step assumes that the fresh installation is being made on the same machine as IUCLID 5.2x/5.3x and that the database has not been altered manually in any way.
  4. Run IUCLID 5.5.0 by double clicking on the newly created shortcut.
  5. At the prompt in the “first Steps” wizard, choose to restore from your backup of IUCLID 5.2x/5.3x.
  6. At the end of the installation process, the database software PostgreSQL contains two databases, one named iuclid5 for IUCLID 5.2x/5.3x and one named iuclid550 for IUCLID 5.5. If you are sure you no longer need it, the older database can be deleted using the tool pgAdmin3 that is supplied with PostgreSQL.

Back to Top

How can I upgrade from IUCLID 5.0/1 to IUCLID 5.6, and still be able access all my existing data?

There is no automatic method available so you have to carry out the following manual steps.

  1. If you are unable to start IUCLID 5.0/1, see the FAQ entries on Java and its versions.
  2. If it is not already present, download and install the Backup plugin-5.0.3 for IUCLID 5.1.1.
  3. Use the plugin to back up all your IUCLID data.
  4. If the latest update of Java 7 is not already installed on the installation computer, install it now.
  5. Make a fresh installation of IUCLID 5.5 according to the installation manual supplied with the installation package.
  6. Whilst running IUCLID 5.5 for the first time, at the prompt in the “first Steps” wizard, choose to restore from your backup.

Back to Top

When upgrading IUCLID, can I use the IUCLID functions Back-up and Restore, instead of using the database migration process that is carried out when the installer is run in upgrade mode?

The simple answer is yes. However, the more data there is in the database, the relatively more efficient and quicker the migration option is. Back-up takes the data out of the database and saves it as files, which Restore must then put back into the database, after it has been upgraded to a new version. During the restore process, IUCLID converts the data from the files into the appropriate format for the new database. By contrast, in the migration process, the database is upgraded to the new version and the data is converted into the new format, all in one process. There is no need to manage back-up files.

Back to Top

When a user tries to open an attachment, a "Service error on server (SYS1500)" is reported

This issue may take place after migration of the database from Postgres 8.x to 9.x. In the IUCLID 5 server logs, there would be entries like: 'ERROR: permission denied for large object '

In PostgreSQL releases prior to 9.0, large objects did not have access privileges. However, in PostgreSQL 9.x, access privileges to large objects have been introduced.

Make sure that you have a valid backup of your IUCLID 5 database. Please take both the database level and IUCLID 5 level backups. The back-up procedure is described in the IUCLID 5 FAQ:

http://iuclid.echa.europa.eu/index.php?fuseaction=home.faq&type=public#216

Only after taking both backups of your data, address this issue by executing the following procedure:

  1. Connect to the PostgreSQL database using psql.exe as user postgres. Below is an example command.
    "C:\Program Files\PostgreSQL\9.x\bin\psql.exe" -U postgres
  2. Enter the password for the user postgres.
  3. Run the following command:
    SHOW lo_compat_privileges;
    The 'lo_compat_privileges' will probably be off.
  4. If the value is off then run the following:
    SET lo_compat_privileges = true;
  5. Open the PostgreSQL configuration file (typically "postgresql.conf" - you can find its location with the command "SHOW config_file;") and change the following line:
    #lo_compat_privileges = off
    to:
    lo_compat_privileges = on
    This is the "large object compatibility privileges" instruction and allows maximum compatibility between PostgreSQL 8 and PostgreSQL 9 on the issue of large objects. Alternatively, it is possible to change owners of the large objects (refer to the PostgreSQL documentation).

Back to Top


Installation


In Vista/Windows 7, I receive an error message "pgpass.conf does not exist" when trying to update to IUCLID 5.2.x. How can I run the update successfully?

Some of our users have reported that when disabling the User Account Contol, this has also enabled them to install IUCLID 5.2.x successfully.

UAC or User Access Control in Windows Vista/Windows 7 is meant to enhance the security of your system. Each time an application is installed, an important system change is made by a user or by a running process, the screen is blacked out and temporarily disabled and a dialog is shown with the choices to allow or deny the action. If the logged in user is not an administrator, Windows Vista will also ask for the administrator password.

Disabling UAC is not recommended by Microsoft because it can expose you to several security threats, so if you choose to disable it please make sure you have the proper security in place for your system.

In order to disable the UAC:

  Back to Top


I do not know how to start the IUCLID Installer on Windows Vista. What must I do?

  Back to Top


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:

  Back to Top


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.

  Back to Top


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. Therefore a separate web (additional to the used servlet container) server will not be used.

  Back to Top


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

The software can be distributed to the client workstations by using the JNLP / Java WebStart technology, which is included by default in Java SE 6 and 7. No local physical intervention is required to install the IUCLID 5 client. WebStart 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).

  Back to Top


How can I show a difference between different IUCLID installations in the IUCLID interface?

  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 <nativelib /> and not as <jar />.
# 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

For example modify the file "jnlp.properties", addding the lines:


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

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

3.   Creating an announcement

An announcement can be created that indicates to users which particular instance of IUCLID they are viewing. You can choose the text of the announcement. Set it so that it has no expiry date. The announcement feature is under the menu item File / Administrative tools / Edit Announcements. Only users with SuperUser rights can edit announcements.

  Back to Top


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

Please refer to the IUCLID 5 Proxy Configuration Manual.

  Back to Top


How can I make a backup of my IUCLID database?

There are two ways to back up your IUCLID 5 data: using the IUCLID backup tool and/or using the database’s own backup tools. It is, however, recommended to use IUCLID tools and use PostgreSQL level backup as a supplementary tool.

IUCLID 5 backup:

To back up IUCLID 5 data using the IUCLID backup tool (which is included in IUCLID 5, versions 5.2 and above), you need to:

  1. Log in as SuperUser.
  2. Select 'Backup' from the File menu - Administrative tools. The backup assistant will start.
  3. Select the type of documents to be backed up. Note that you can define the new default password or tick the box if you want to keep the existing ones. If you continue with the default settings, the new default password will be empty.
  4. Click the Next button.
  5. Select the folder where the backed up files should be stored.
  6. Select whether to export a single file or multiple files.
  7. Select the overwrite mode.
  8. Select ‘Finish’.

Along with the backup files, the backup folder contains the backup log file, for example, backup20130226-123456.log, which tells the results of the backup.

Important: If you store the backup to portable media, for example, to a USB key, remember to also copy the ...chksum.xml file.

IUCLID 5 restore:

To restore files saved with the IUCLID backup tool follow these steps:

  1. Log in as SuperUser.
  2. Select the 'Restore' from the File menu - Administrative tools. The restore assistant will start.
  3. Select the location to restore from as well as the overwrite mode.
  4. Select Next.
  5. Select what you want to restore.
  6. Select Finish.

PostgreSQL backup:

Important: The PostgreSQL database backup can only be restored to the same level IUCLID 5 installation from which the backup has been taken. In other words, if you have a IUCLID 5.3 database backup taken by PostgreSQL tools, you can only restore it to be used with IUCLID 5.3.

To back up the PostgreSQL database, use the pg_dump.exe tool. Run it from the command prompt (as Administrator). If you have PostgreSQL installed in the C:\Program Files\PostgreSQL\8.4 folder, run the backup with the following parameters:

"C:\Program Files\PostgreSQL\8.4\bin\pg_dump.exe” -i -h localhost -p 5432 -U postgres -F c -b -f "C:\Your_backup_folder\iuclid5.backup" iuclid5

where: –U is the PostgreSQL database user, -p is the portnumber and iuclid5 is the database name. The folder where the backup will be placed should exist. 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.

It is good to test the restore of the backup on a different computer where you have installed PostgreSQL. You first need to make sure that you have created an empty UTF8 database with PGAdminIII.

PostgreSQL restore:

You can use the following command from the command prompt (as Administrator):

"C:\Program Files\PostgreSQL\8.4\bin\pg_restore.exe” -i -h localhost -p 5432 -U postgres -d iuclid5restore -O -v "C:\Your_backup_folder\iuclid5.backup"

where: –U is the PostgreSQL database user, -p is the portnumber and iuclid5restore is the database name. The empty UTF8 database must exist before the restore can be completed.

You can find more information and details on the PostgreSQL website

Automation of the backup

You can use the pg_dump tool to take the backup manually or if you prefer then you can automate the backup by running it as a scheduled task in Windows. Please see the Windows documentation/Help on how to do this.

It is possible to automate backup for both the standalone and distributed versions of IUCLID. However, when the backup is executed, the database server must be up and running. From that perspective, the distributed version of IUCLID 5 seems more suitable for the automation of backup. This will also work well with the standalone version if the database is on during the backup but users often turn off their workstations when they leave and even if they do not, workstations are most often configured to go into a sleep mode after being inactive for some time. If this happens, the backup will not be executed.

Oracle backup:

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

  Back to Top


How to find the IUCLID 5 log files?

In some cases, it is necessary to have the log files in order to troubleshoot possible problems. The most common log files are as follows and, depending on the case, one or more of these are required for troubleshooting.

  1. IUCLID 5 standalone log file i5workstation.log or iuclid5.log:
    From version 5.3.2 onwards, the name of the IUCLID 5 standalone log file is i5workstation.log and in earlier IUCLID 5 versions the log file is called iuclid5.log. The log file (i5workstation.log or iuclid5.log) is by default located in:
    Windows 7 'C:\Users\Your_ user_name\.iuclid5\'
    Windows XP 'C:\Documents and settings\ Your_ user_name\.iuclid5\'
    If you cannot find the log file, it is also possible that the location was manually configured in the i5workstation.logging.properties file located in the 'conf\' folder of your IUCLID installation folder.
    For example: log4j.appender.FileApp.File=C:/temp/i5workstation.log
  2. IUCLID 5 distributed architecture log files, the server log i5server.log and the client log i5client.log:
    In the IUCLID 5 distributed architecture, there are two log files located on both the server and on the client side. Server log:
    By default, the name of the server log file is i5server.log and the default location is the working directory of the servlet container. e.g. C:\Program files\Apache Software Foundation\Tomcat X.x\i5server.log.
    If you do not find the log file, the exact location of the iuclid5 server is configured in the i5server.logging.properties file in the WEB-INF\classes directory. For example: log4j.appender.FileApp.File=C:\logs\i5server.log
    Client log:
    The IUCLID 5 client creates the i5client.log file in the current working directory. If you use Internet Explorer, the current working directory is usually your desktop.
  3. The migration log - iuclidMT.log file:
    In the standalone version, the migration log file iuclidMT.log is normally found in the same folder as the i5workstation.log or the iuclid5.log file. On the server version, the migration log file iuclidMT.log is normally found in the same folder as the i5server.log file. Details on how to find IUCLID 5 logs are given at the beginning of this FAQ.
  4. IUCLID 5 backup and restore log files:
    The backup log file, for example backup-20120507-084801.log and the restore log file, for example restore-20120420-104407.log, can be found in the same folder in which the IUCLID backups are stored. For example, if the IUCLID backups are stored in F:\IUCLID5 backups\5.3.0, the backup and restore log files will be found in the same location.
  5. The Postgres log file:
    The PostgreSQL log files can be found within a sub folder of the PostgreSQL installation directory, e.g. C:\ProgramFiles\PostgreSQL\8.4\data\pg_log\postgresql-2012-05-16235839.log (or similar), where 'postgresql-2012-05-16235839' is the most recent PostgreSQL log file.

  Back to Top


When attempting to install PostgreSQL on Vista I get the error message 'Database Cluster Initialisation Failed' at the end of the installation, what can I do?

Vista has safety features associated with setting permissions on the Program Files folder. Even if you are an administrator, you cannot change permissions on some folders like Program Files and Windows folder itself. This causes initdb to be unable to create some folders and the database cluster. What this means for you is that you need to install PostgreSQL in another folder that is not inside Program Files.

  Back to Top


What are the recommended software and hardware requirements for IUCLID 5.5?

For previous IUCLID versions, the specific software requirements are available in the relevant installation manuals.

The recommended softwares to be used with IUCLID 5.5.1 are:

* IUCLID 5.5.1 is compatible with Java 6, but the vendor, Oracle, recommends to uninstall Java SE 6, and then to install the latest update of Java 7.

** As Oracle no longer supports the development of Oracle 10g, if any new bugs arise with this Oracle version, you will have to upgrade to Oracle 11g.

(1) This is the list of softwares versions supported by the IUCLID team. Tests have been carried out to make sure IUCLID can be run using the softwares listed in these columns.
(2) Although no specific testing has been performed using the softwares listed in column 2, reports were sent by users that IUCLID was able to be run with these softwares.
(3) Issues were reported with the use of IUCLID in combination with the softwares listed in column 3 and hence they should not be used.

Note:

The recommended hardware requirements for IUCLID 5 are as follows.
Note that the following requirements are provided only as a guide.

An installation of IUCLID 5 will most likely run on a lowerspecified machine but the performance might not be satisfactory. The requirements also depend on the version of Windows and the IUCLID plugins that are in use. For example, using the Query Tool plugin will increase the resources required to obtain a reasonable running speed, particularly on a large database. The handling of large attachments also increases the memory requirements. In addition, Java can be highly memory-intensive.

MAC OS X

Although the use of IUCLID with MAC OS X is not supported, IUCLID as a Java program should be able to run under this Operating System. In that case, the manual installation process will have to be followed for the standalone version. Do not hesitate to send any feedback on using IUCLID with MAC OS to the ECHA Helpdesk.

  Back to Top


How can I distinguish user accounts when using Windows, IUCLID 5 standalone installation and PostgreSQL database?

There are three different user accounts and passwords when installing/using IUCLID 5 and PostgreSQL. There is also a user account created by the SuperUser and the IUCLID 5 -web site also has a separate login account. If you need to reset the password for a particular account, it is necessary to distinguish which account a password belongs to.

Basic accounts are as follows:
1) Postgres - Same name for two accounts – for the PostgreSQL database administration and for the Postgres service under Windows.
2) Iuclid5 - Database account
3) SuperUser - Administrator account for IUCLID 5 administrative tasks
4) Own user accounts in IUCLID 5 - created by the SuperUser
5) User account for the IUCLID 5 web site

1. Postgres – same name for two accounts - for the PostgreSQL database administration and for the Postgres service under Windows.

The postgres account is automatically created during the PostgreSQL installation (see Installation Guide for IUCLID 5 Standalone Application) and at that point the password is set by the user. The installer creates two separate accounts at the same time (see Figure 1 below) with the same name postgres: a) the administrator account to manage the PostgreSQL database server and b) Windows special account to run the Postgres service under Windows.


Figure 1

When the database connection is created for the first time you need to type this password for the PostgreSQL superuser in the password field (see Figure 2). At this point the title of this account is superuser but it is not the same as the SuperUser account that one uses to log in to IUCLID 5 for the first time. The IUCLID 5 name SuperUser refers to IUCLID5 built-in account.


Figure 2

2. Iuclid5 - database account

The user name iuclid5 is created and the password will be set when the database connection is created for the first time (figure 3). This account is used transparently for the database connection between IUCLID 5 and PostgreSQL. This password will be set in this phase of the installation.


Figure 3

3. SuperUser - Administrator account to IUCLID 5

In IUCLID 5 (figure 4) there is a build-in user account called SuperUser and by default the password is root.


Figure 4

This account is used only for administrative purposes, such as, the creation of new users, back ups, etc. You cannot create substances with this account, you need to create new user account(s) in IUCLID5, see point 4.

4. Own user accounts in IUCLID 5 - created by the SuperUser

Follow the instructions below (figure 5)


Figure 5

For further details, see section 16.2 Feature 'User Management': How to create a new User of the IUCLID 5 end user manual.

5. User account to IUCLID 5 web site

In order to logon to the IUCLID 5 web site (figure 6), you need to have a user account. This one can be restored using a password recovery-function and this account is valid only for the web site.

Figure 6

  Back to Top


Which PostgreSQL version should be used with IUCLID 5?

Even though PostgreSQL is a prerequisite software for the installation of IUCLID 5, it is a third party software developed and supported by the respective publishers. ECHA can only recommend the successfully tested versions, which might not be the latest ones although the latest versions could also work fine with IUCLID. For more details check FAQ: What are the recommended software and hardware requirements for IUCLID 5.5?

  Back to Top


How to download the correct PostgreSQL version with IUCLID 5?

Before downloading PostgreSQL, check the list of the supported versions by IUCLID 5 from the FAQ: What are the recommended software and hardware requirements for IUCLID 5.5?

PostgreSQL is available to be downloaded at www.postgresql.org/download. Choose 'Download' and under the title 'Binary packages' you can find different versions for various operating systems. In this example, where to find the supported PostgreSQL installer for Windows is described.

Click the 'Windows' link.

Postgres Windows Download

Choose 'Download the installer…'. By opening this link the connection will be automatically redirected to the EnterpriseDB website where PostgreSQL is available.

Postgres Windows Download

Select a supported PostgreSQL version for IUCLID 5 and choose a 32 bit or 64 bit version depending on your operating system. As an example, some Windows installers are indicated in the screenshot below:

Postgres Windows Download

If the download does not start automatically or does not start after clicking the information bar, start the download by choosing 'this link'- link.

  Back to Top


How can I uninstall IUCLID 5 standalone version from my Windows PC?

To uninstall IUCLID 5 standalone version from your Windows PC, follow the steps below. Please be aware that all the information contained in your IUCLID database will be deleted during the process.

  1. On your Windows PC, go to 'Start' – 'Control Panel' – 'Programs and Features' – select 'PostgreSQL x.x' and click Un-install/Change to un-install PostgreSQL.
  2. The message 'The data directory (C:\Program Files\PostgreSQL\x.x\data) and service user account(postgres) have not been removed' will appear. Depending on the Windows version, the default data directory will be found at C:\Program Files\PostgreSQL\x.x\data or at C:\Program Files (x86)\PostgreSQL\x.x\data
  3. 1.To delete the service user account, go to ‘Start’ – ‘All Programs’ – ‘Accessories’ – ‘Command Prompt’ and execute the following command: C:\net user postgres /delete
  4. Delete the IUCLID 5 installation directory. Depending on the Windows version the default installation directory is: C:\Program Files\iuclid5 or C:\Program Files (x86)\iuclid5
  5. Delete the directory: %homepath%\*your username*\.iuclid5 (e.g. on Windows XP it is C:\documents and settings\*your username*\.iuclid5).
  6. Delete the IUCLID 5 desktop icon

The uninstallation of the software is now complete.

  Back to Top

What is the compatibility between versions of IUCLID 5 and Java?

Note: for Java 7 update 45 see FAQ After Java 7 update 45 it is not possible to launch the IUCLID 5 distributed client

The first IUCLID version to be compatible with Java 7 is IUCLID 5.4.1. IUCLID 5.4.1 and 5.5 work with both Java 6 and 7. For versions of IUCLID prior to 5.4.1, only Java 6 works. More details are available in the table below.

  Java 6 Java 7
IUCLID 5.5.x yes yes
IUCLID 5.4.1 yes yes
IUCLID 5.4.0 yes no
IUCLID 5.3.x yes no
IUCLID 5.2.x yes no
IUCLID 5.1 yes no
IUCLID 5.0 yes no

Back to Top

Which version of Java should I use with IUCLID 5.4.1 or 5.5?

Note: for Java 7 update 45 see FAQ After Java 7 update 45 it is not possible to launch IUCLID 5 distributed client

IUCLID 5.4.1 and IUCLID 5.5 both work with Java 6 and Java 7; but Oracle, the vendor of Java, recommends the use of Java 7. Free security updates for Java 6 are soon to be discontinued. For more information, see the Oracle website.

Back to Top

Can I have both Java 6 and Java 7 installed on a computer at the same time?

The simple answer is yes; but bear in mind the precautions that must be taken when two versions of Java are present on the same machine. For more information, see the FAQ on the Oracle website at the following address: http://www.oracle.com/technetwork/java/javase/documentation/autoupdate-1667051.html

Back to Top

I have a shortcut on my Windows Desktop for IUCLID that was created by the Windows installer. When I use it to launch IUCLID, Java 6 is used. How can I change it to select Java 7?

The shortcut created by the IUCLID Windows installer automatically starts IUCLID using the version of Java under which the installer was run. If the installer was run under Java 6, and you would like to re-use the shortcut with Java 7, it is possible to edit the shortcut so that it selects Java 7. First, right click on the short cut, and then select Properties. Under the Shortcut tab, click in the field Target, and then scroll all the way to the start of the value, i.e. to the left. Change the value "jre6" to "jre7" and then click OK. These steps are shown in the figure below:
Select Java 7
The version of Java set by the shortcut overrides the default version used by Windows. Windows will not allow a shortcut to be created for a non-existent target.

Back to Top

I am unable to connect to a distributed instance of IUCLID 5.4.1 or 5.5.0 using Java 7. I click on the web link, but I cannot get to the IUCLID interface. What is the problem?

Note: for Java 7 update 45 see FAQ After Java 7 update 45 it is not possible to launch IUCLID 5 distributed client

Although the IUCLID 5.4.1 or IUCLID 5.5 application itself works with Java 7, the Java Webstart technology used to launch IUCLID from the web link does not work with updates 7 to 10 of Java 7. This problem has been fixed by the publishers of Java in later updates. Therefore, if you experienced the problem with one of the affected updates of Java, upgrading to the latest Java 7 should solve the problem.

Back to Top

How can I find out the version of Java that Windows uses by default on my computer?

To determine the version of Java that Windows uses by default, execute the following in a command prompt window:

C:\>java –version

If you are not sure how to do that, perform the following steps:

  1. Click on the Start button at the bottom left of the Windows Desktop.
  2. Enter the text “cmd” into the window at the bottom left of the Start menu, and then press the Enter key.
  3. A command prompt window should open, like the one shown in the screenshot below.
  4. Enter the text “java –version” and then press the Enter key.
  5. The version of java is shown, as in the example screenshot below.
  6. If an error is shown, either java is not installed, or it needs to be re-installed.

Find Java Version

Back to Top

I have a shortcut on my Windows Desktop for IUCLID 5 that was created before version 5.4.1. When I double click on it, I get the following error: "The item 'javaw.exe' that this shortcut refers to has been changed or moved, so this shortcut will no longer work properly."

Shortcut Problem

The most likely explanation is that Java has been upgraded to Java 7, and Java 6 has been removed. If you would like to run a version of IUCLID prior to version 5.4.1, see FAQ "I have a standalone installation of IUCLID prior to version 5.4.1 that was installed using the Windows installer. The Java version has been upgraded to Java 7, and now IUCLID does not run. How can I access my existing IUCLID data?"

Back to Top

I have a standalone installation of IUCLID prior to version 5.4.1 that was installed using the Windows installer. The Java version has been upgraded to Java 7, and now IUCLID does not run. How can I access my existing IUCLID data?

If the computer on which you run IUCLID has had its Java upgraded from 6 to 7, and Java 6 is no longer installed, you cannot run your existing version of IUCLID because versions of IUCLID prior to 5.4.1 do not work with Java 7. However, your data is still there and can be accessed. If you simply want to run the existing installation of IUCLID, revert to Java 6. To use Java 6, it is not technically essential to remove Java 7, but bear in mind the precautions that must be taken when two versions of Java are present on the same machine. For more information, see the FAQ on the Oracle website at the following address: http://www.oracle.com/technetwork/java/javase/documentation/autoupdate-1667051.html

To launch IUCLID, double click on the shortcut on the Windows desktop that was created by the IUCLID installer. The shortcut automatically selects Java 6, even if Java 7 is still installed on the computer.

Back to Top

Why does a "Connection attempt time out" error appear during the IUCLID 5 installation?

Before you can install the IUCLID 5 Standalone version, you need to have Java and PostgreSQL database installed on your computer. The error "Connection attempt time out" may appear if the PostgreSQL database is missing. To install PostgreSQL, carefully follow the instructions given in the IUCLID 5 installation manual.

If the PostgreSQL is already installed, but the error still appears, continue troubleshooting with the next FAQ.

Back to Top

IUCLID 5 does not start, but the following error message appears: "Error during initialisation. The following exception was thrown: Connection to the database (jdbc:postgresql://localhost:5432/iuclid5) could not be established. Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections".

The most common reason for this is that the PostgreSQL service is not running. The following example illustrates how to fix the situation when using Windows 7 and PostgreSQL, and this operation requires sufficient access rights to the operating system.

To check if the PostgreSQL service is running:

Back to Top


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 X.x\logs"
3. Delete all the i5server.log files in the folder "C:\Program Files\Apache Software Foundation\Tomcat X.x"
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 X.x"
7. Please send us the i5server.log file found in the C:\Program Files\Apache Software Foundation\Tomcat X.x" 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:
 
2011-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 "iuclid5"
 
it means that you may have entered the wrong login or/and password and that is why the error messages appears.
 
Check the settings of the server.properties file:
-----------SNIP----------------------
#-----------------
# Settings for using PostgreSQL
#-----------------
hibernate.connection.url=jdbc:postgresql://localhost:5432/iuclid5
hibernate.connection.username=iuclid5
hibernate.connection.password=iuclid5
hibernate.connection.driver_class=org.postgresql.Driver
hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
#
-----------SNIP----------------------

Ensure that the correct database username and the correct password have been entered. Check also the location of the server.properties file. It should be in the webapps\i5server\WEB-INF\classes subdirectory.
 
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?

  Back to Top


‘Cannot create the destination folder’ error is displayed during the installation on Windows 7. What am I to do?'

The problem appears of insufficient access rights to the operating system. This can be fixed with one of the following ways:

  1. Run the installer from the Command prompt which is elevated to administrator. To run from the command line:
    - Open the application Command Prompt using the option Run as administrator
    - Enter the administrator password if prompted
    - In the Command Prompt window, move to the folder that contains the installer Java file
    - Enter the name of the Java file then press Enter
  2. Select a destination folder to which the installer has write access, i.e. replace the default value C:\Program Files\iuclid5 with something suitable on your system.
  3. If you have access to a built-in type Administrator account, log in to it and start the installer by double-clicking on the file iuclid5_install.jar.

  Back to Top


Known Issues- IUCLID application

Distributed version

After Java 7 update 51 it is not possible to launch the IUCLID 5 distributed client

The update 51 of Java 7 released in January 2014 includes strengthened security rules that prevent the IUCLID distributed version from running on the client computers. To anticipate this update, a new installation package has been published on the IUCLID website (see the latest update of the IUCLID distributed version).

To be able to run the IUCLID clients with Java 7 update 51, it is necessary to re-install the IUCLID 5.5.1 application with the installation package published on 16 December 2013. No migration is required with this re-installation step. For more information about the installation, please consult the installation manual available.

Alternatively you can open the "Java Control Panel" on your computer, select the "Security" tab and add the IUCLID 5 application to an “Exception Site List” as shown in the screenshot below. Make sure that you enter the URL that points to your IUCLID 5 server. The URL from the screenshot below is only an example.

Java Control Panel

  Back to Top

After Java 7 update 45 it is not possible to launch IUCLID 5 distributed client

This issue has been fixed on 5 November 2013.

Due to changes in the Oracle security policy for Java applications an issue appears related to the use of Java Web Start to launch the IUCLID client to connect to a IUCLID server. It affects only the IUCLID 5 clients of the distributed version. The IUCLID 5 workstation version works normally with Java 7 update 45.

For the users of the IUCLID 5 distributed version who have Java 7 update 45 installed, the following fix is proposed:

========INSTRUCTIONS START========

After applying the change below, re-installation and execution of IUCLID5 client with Java 7 update 45 will allow normal start of the application. Although there is no need for redeployment of the application for the fix to be applied, it is recommended to stop the IUCLID server before proceeding with the modification below.

  1. Open the deployed i5server folder at the local Tomcat installation folder.
    Default for Windows: %TOMCAT_HOME%/webapps/i5server
    Default for Linux: $TOMCAT_HOME/webapps/i5server

    NOTE: %TOMCAT_HOME% or $TOMCAT_HOME is the Tomcat installation directory at Windows or Linux installations (i.e. the one including Tomcat distribution’s /bin or /webapps directories; for example C:\Tomcat\ for Windows or /usr/local/tomcat for Linux)
  2. Find the config.jsp file and replace it with the one you can download from here (config.zip - MD5 checksum for config.jsp: e3ca2289402051694ed12f773e84bf80). This file is
    %IUCLID5_TOMCAT_HOME%/webapps/i5server/config.jsp on Windows or
    $IUCLID5_TOMCAT_HOME/webapps/i5server/config.jsp on Linux.

As an alternative option you can also find the config.jsp file and open it for edit: - Go to line 743 and make the following modification:

[property name="client.properties.url"] should be replaced with [property name="jnlp.client.properties.url"]

NOTE: "[" and "]" characters mark the start and end of the replaced text respectively; they are not part of the property being updated

- Save the config.jsp file.

========INSTRUCTIONS END========

This fix has been integrated in the IUCLID 5.5.1 distributed server version available for download on the IUCLID website as of 5 November 2013.

  Back to Top

IUCLID 5.5.0

After migrating to IUCLID 5.5.0 I cannot access the User management and Role management tools of IUCLID. Instead, I get the following error message "Service error on server (SYS1500)".

This issue has been fixed in IUCLID 5.5.1 which was released on 11 September 2013.

Some users who have created customised roles have reported this problem after migrating to IUCLID 5.5.0. The exception is characterised by the following log file entry:

ERROR eu.eca.iuclid.common.service.ServiceDispatcher - Service 'User' threw undeclared exception:
java.lang.NullPointerException
          at eu.eca.iuclid.common.integration.usermanagement.EndpointAccessControlOperation.clone(EndpointAccessControlOperation.java:351)
          at eu.eca.iuclid.common.util.Utils.cloneArray(Utils.java:318)
                    

If you have encountered this problem and you need urgent assistance, please contact the ECHA Helpdesk who will support you in resolving the issue.

  Back to Top


IUCLID 5.4.1

A user receives an incorrect message that they have exceeded the number of log in attempts allowed.

This happens after the account manager has reset the account, allowing the user back in, after the limit of attempts was exceeded. For example, a user might block an account because they have forgotten the password. The account manager gives the user a new password, and un-suspends the account. The user logs in with the new password, and resets the password if required. However, when the user logs out then back in again, they immediately get a message that the attempt limit has been exceeded. This behaviour is seen for both methods of authentication: password and secure question.

Limits to the number of attempts to log in can be set only for the distributed version of IUCLID.

This issue has been identified in IUCLID 5.4.1. It will be fixed in a future release of IUCLID. To avoid the problem, the account manager must make changes to only one user account at a time; closing the user management page between each account. Do not save data more than once during a single account management session. For example, to allow a user to log in again after the limit of log in attempts has been exceeded, do the following:

  1. Open the user management page.
  2. Click on the login name of the user.
  3. Un-check the box Suspended.
  4. Set the password.
  5. If required, check the box Expire password upon next login. This is not obligatory.
  6. Exit the user management page by clicking on the home icon.
  7. Click Save in the dialogue, and OK for the warning message.
  8. You can now act on another account, if required.

  Back to Top

Java memory issues on the server side of a IUCLID 5 distributed installation

If the server side of a IUCLID 5 distributed installation runs out of memory, the application will fail and the operation will not be executed. On the Client side, it will be reported as a “Communication error”, “Communication to server failed (SYS1404)”. On the server side “Java Out-Of-Memory” may be reported (i.e. message “java.lang.OutOfMemoryError: GC overhead limit exceeded”). In such cases, the size of the Java heap and Java Permanent Generation space need to be increased.

WINDOWS

To increase Java heap on Windows, connect to the server, open Apache Tomcat 'Properties', select the 'Java' tab and increase values in “Initial memory pool” and “Maximum memory pool”. To increase the Permanent Generation space, add the following string:
- XX:MaxPermSize=512m

After that click on the Apply button and restart Apache Tomcat.

Tomcat 7 properties

LINUX

Open the script used to start Tomcat (i.e. catalina.sh) and define Java memory settings in CATALINA_OPTS:
export CATALINA_OPTS="-Xms512m –Xmx1024m -XX:MaxPermSize=256m"
-Xms – initial heap size
-Xmx – maximum heap size
-XX:MaxPermSize – Permanent Generation space size

Things to consider when tuning Java memory:

  1. Maximum memory pool (maximum heap size) should be less than 50% of memory that is available to the server. Therefore, in some cases RAM should be added to the server.
  2. Maximum memory pool (maximum heap size) must be greater than or equal to the Initial memory pool (initial heap size). In the stable systems, both values will be the same.
  3. 32 bit Java is limited to a maximum heap size of 4 Gb (2^32 bytes). However, it is not possible to have a 4 Gb heap. On Windows systems, the maximum heap size will be somewhere between 1 Gb and 2 Gb and if you try to assign more, it will result in error. For the 64 bit Java, the maximum heap size is limited to 2^64 bytes which is around 16 billion Gigabytes. If you need a large heap size consider using 64 bit Java.

Back to Top


IUCLID 5.4

After modifying the Exposure Scenario in Section 3.5 for a particular Use, the text in the table (under Exposure Scenario in section 3.5) is not refreshed and remains the same. When double clicking the 'Use', the correct link is displayed, but the Identifiers shown in the field are still the old ones.

This issue has been identified in IUCLID 5.4 and it will be fixed in a future release of IUCLID. The correct data is the one displayed in the Use. For example, in the figure below, if you can see the correct link between 3.5 and 3.7.1 when opening the entry in the tables of section 3.5, then the information in your dossier is correct.

  Back to Top


IUCLID 5.3


I cannot give a public name if the length is more than 255 characters. Why?

This bug has been fixed in IUCLID 5.3.1 which was released on 25 August 2011

Even though the IUCLID user interface is configured to allow 2000 characters, unfortunately the database accepts only 255 characters. This bug has been reported and will be fixed in a future maintenance release of IUCLID 5.3

  Back to Top


Why can I not re-create the index with the Query plugin version 5.3.0?

This bug has been fixed in the Query plugin version 5.3.1 which was released on 20 May 2011

Users have reported the following issue:‘After having installed the Query plugin (version 5.3.0), I tried to re-create the index. I first tried to delete the index created by a previous version of the Query plugin, but I got the error ‘Communication to server failed (SYS1404)’. In the query administration, it looked like the index was deleted. I then tried to create a new index, but I got an error message ‘SYS1500’. Even though I do not have much data in my IUCLID 5 installation, in the query administration, I can see that the indexing mode has been creating an index for more than one day.’

This is a bug and rebuilding the index consistently fails in IUCLID 5.3 even in a database with very few little data. It has now been corrected in the Query plugin version 5.3.1.

  Back to Top


IUCLID 5.2.2


Even though I select check the checkbox "Reviewed by an assessor" when creating my dossier, the checkbox disappears later. When I run the TCC I get a TCC failure. Is this normal? Will my dossier fail when I submit it to ECHA?

This bug has been fixed in IUCLID 5.2.3 which was released on 21 October 2010

In IUCLID 5 the following occurs during the creation of a registration dossier.

Steps:

1. Find the substance and create a dossier using the dossier creation wizard as far as step 6 (header information)

2. For the header information tick on the checkbox "Reviewed by an assesor" and fill-in the remarks field (see Figure 1).

Figure 1

3. After finishing the dossier creation, review the dossier information. The checkbox "Reviewed by an assessor" is ticked (Figure 2).

Figure 2:

4. Executing the TCC-Plugin shows no errors or warnings (Figure 3).

Figure 3:

5. After a short time (about 1 hour) review the same dossier again. This time the checkbox "Reviewed by an assessor" is not ticked and the TCC-Plugin shows an error in the dossier header (see Figure 4 and Figure 5). You can also restart IUCLID 5 to clear the cache. The "review by an assessor" tickbox is not checked anymore.

Figure 4:

Figure 5:

  Back to Top


Even though I have ticked "Review by an assessor" in my dossier header and attached a "Review by an assessor" report in the dossier header, when submitting my dossier to REACH-IT, I get a "document not found" error message. What must I do in order for my dossier to be accepted?

This bug has been fixed in IUCLID 5.2.3 which was released on 21 October 2010

This is a feature in IUCLID 5.2.2 which will fail whenever something is attached in "Review by assessor". In order to attach the "review by an assessor" report, please attach it in section 13 under 'assessment reports', and use 'other' for the 'type of report', then indicate in the free text field that this is a "review by an assessor" report.

  Back to Top


IUCLID 5.2.0


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

This bug has been fixed in IUCLID 5.2.3 which was released on 21 October 2010

In IUCLID 5.2.0, 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".

  Back to Top


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

This bug has been fixed in IUCLID 5.2.2 which was released on 09 August 2010

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 been fixed in IUCLID 5.2.2. Normal users can now modify and save the substance. However, if the substance dataset had been created in IUCLID 5.2.0, the problem had already been introduced there and upgrading to IUCLID 5.2.2 might not fix it. In that case, in order to repair the broken links, the attachments have to be deleted and re-attached.

  Back to Top


Known Issues- IUCLID plug ins


Report Generator /version 5.5.1

When trying to generate the CSR, no “rtf” file is generated.

The behaviour of the plug-in has been improved in version 5.5.2. However, in the case of the generation of a CSR from a dataset containing a lot of records (several hundred), it might still be necessary to increase the memory allocated to the IUCLID application.

This issue is related to the amount of memory allocated to IUCLID.

For the Standalone version of IUCLID, modify the iuclid.cmd file as follows:

  1. Edit the iuclid5.cmd file. Change the command line:
    @start "IUCLID5" "javaw.exe" -Xms512m -Xmx1024m -XX:MaxPermSize=128m -classpath %IUC5CP% -Djava.library.path=./lib/native eu.eca.iuclid.client.WorkstationLauncher
    Note that the MaxPermSize parameter might be particularly important. If the application does not start with 128m, try using 256m.
  2. It is not recommended to assign more than half of the physical memory available.
  3. Save the file.
  4. For the Distributed version, the link to start the client can be modified as follows:
    http:///i5client.jnlp?prop=/i5client/jnlp.properties&initHeap=512&maxHeap=2024&MaxPermSize=128

  Back to Top

I receive validation errors when I try to import a IUCLID file after I previously synchronised its content with Chesar data using the Report Generator

For the fields “initial” and “local release factor”, Chesar allows a precision that is rounded at the 10E-20 and IUCLID has a defined field precision of 10E-9 (in section 3.7.1). This difference results in validation errors when trying to reimport the substance into IUCLID.

In order to fix the issue follow the following steps:

  1. Go back to Chesar box 3 – environmental assessment and round all values that are smaller than 10E-9 in the field “Initial release factor (%)” (if the “Release factor” method was selected as the release method) and/or in the field “Local release rate (kg/day)” (if the “measured release” method was selected as the release method).
  2. Delete all entries in section 3.7.1 in IUCLID.
  3. Re-synchronise IUCLID and Chesar using the Report Generator plugin.

  Back to Top


Dissemination plug-in / version 5.4.1 used with IUCLID 5.5

The content of the endpoint study records is not correctly filtered by the Dissemination plug-in when I use it with IUCLID 5.5

This issue has been fixed in the Dissemination plug-in version 5.5.0 which was released on 27 June 2013.

There is a known incorrect behaviour of the dissemination plug-in 5.4.1 when it is used together with IUCLID 5.5. Most of the content of sections 4 to 13 of IUCLID is not filtered correctly and the outcome is not a correct representation of the parts of the dossier that will be made available on the ECHA website.

Back to Top


TCC plug in / version 5.4.0

I get the following BR200 failure when running the TCC plugin version 5.4.0 on my IUCLID substance dataset / dossier: Section 1.7 – Suppliers, Other importers: “You have attached a document to this substance dataset / dossier that lacks content. To ensure that your dossier contains all intended information, please ensure that you have attached the correct and complete documents before creating the dossier and submitting it.”However, I have verified that the document attached in this location is complete. What should I do?

This bug has been fixed in version 5.4.1 of the TCC plugin which was released on 17 July 2012

There is a known incorrect BR200 failure in the TCC plugin version 5.4.0. If you verified that the document attached to this particular location (Section 1.7 – Suppliers, Other importers) are correct (i.e. you are able to open them from IUCLID), please ignore the BR200 failure for this specific IUCLID section. Your dossier will not fail BR200 when submitting it via REACH-IT.

Back to Top


CSR plugin / version 5.4.0


Using the CSR plugin 5.4.0 on IUCLID 5.4.0 distributed version (Linux server), the titles and headers are missing from the CSR report.

This issue has been fixed in IUCLID version 5.4.1 which was released on 19 October 2012

In order to solve this issue, the following sequence needs to be performed on the Tomcat server:

1. Copy the “fix_csr_report.sh” in the “temp” directory (located by default in “[installation path of Tomcat]\temp”) of the Tomcat server on which the IUCLID application is deployed (ensuring that you have the permission to write on this directory).
TIP: A “.iuclid5” directory should be located inside the “temp” directory used by Tomcat.

2. Execute the script using the following command line: sh ./fix_csr_report.sh

3. Restart the IUCLID 5 application from the Tomcat manager.

Important note: on some Linux distributions, the Tomcat “temp” directory may be cleaned with the restart of the Tomcat server. In this case, please ensure that script “fix_csr_report.sh” is executed after each start of Tomcat.

Back to Top


When I try to synchronize the uses in the CSR plugin, I receive the error message: "Document access failure. It's possible the document is already locked for writing, or otherwise inaccessible"

The error appears in step 4 of the CSR plugin, when synchronising the "uses" of the Chesar assessment file with the substance dataset in IUCLID.

This can be caused by:

Back to Top

When I synchronise the uses in the CSR plug-in, the information I entered in the Chesar "internal remark" fields available in box 2 are transferred to IUCLID section 3.5.

This problem will be solved with the next IUCLID CSR-plugin release. The information entered in the Chesar "internal remark" fields are wrongly transferred to the section 3.5 "remark" of IUCLID during the synchronisation process performed by the CSR plug-in. Be aware that the same text will be transferred from section 3.5 in IUCLID to the CSR (part B section 2 Manufacture an uses in the table column "other information").

To prevent this, you can manually remove the "remark" text from IUCLID after the synchronisation process.

Back to Top


Questions related to REACH Registration


UUID synchronisation between REACH-IT and IUCLID 5 LEO (video included)

Only an official legal entity object (LEO) originating from the IUCLID website or from your REACH-IT account can be used for functionalities where it is critical to ensure uniqueness of the Legal Entity information. These for example could be to specify your own company/organisation or the company that you represent (in case you are a service provider).

If you need to update your legal entity information, it is strongly recommended that you also update the information submitted at creation time on the IUCLID web site to ensure consistency.

On the REACH-IT FAQ, in particular Q&A 371 under 'LEO and UUID', you can find information on how to manage and update your legal entity information.

The video tutorial below, illustrates how to synchronise the UUID between REACH-IT and IUCLID 5 LEO and what are the next steps in IUCLID 5.

Right-click the link and choose 'Save Link As...' to save the file.Download the video

The table below shows the various topics illustrated in the video, the time and the duration of each topic.

  Back to Top


How can I check that my Legal Entity is the same in section 1.1 of IUCLID 5, in the dossier header and in REACH-IT?

While compiling a substance dataset, then creating a dossier and submitting it in REACH-IT, there are three instances where the Legal Entity needs to be indicated. Moreover, the UUID of the Legal Entity in section 1.1 of your substance dataset in IUCLID 5, the Legal Entity in the dossier header in your dossier and the submitting Legal Entity in REACH-IT must be the same.

1) How to find the UUID of the Legal Entity linked to the substance dataset?

a) Click on 'Substance' in the IUCLID 5 main screen

b) Choose the substance in question from the query list

c) Click on the blue arrow on the right side of the 'Legal Entity' field

d) In the 'Information' field, under the 'Information' tab, you can find the UUID of the Legal Entity associated with this substance

2) How to find the UUID of the Legal Entity that is 'creating' the dossier?

When creating the dossier, you must make sure that you use a IUCLID User Account for the Legal Entity that corresponds to the submitting Legal Entity in REACH-IT. This Legal Entity is visible at the bottom of the IUCLID 5 screen, in the status bar and you can find the UUID as follows:

a) On the bottom of the IUCLID 5 main screen, in the status bar, the selected Legal Entity is visible

b) Click on 'Legal Entity' on the IUCLID 5 main screen

c) Choose the same Legal Entity from the query list that you had seen at the bottom of the main screen previously

d) In the 'Information' field, under the 'Information' tab, you can find the UUID of the selected Legal Entity

3) How to find the UUID of the submitting Legal Entity in REACH-IT?

The REACH-IT account you use will determine the Legal Entity that ECHA will consider as associated with all the regulatory processes and/or communications related to the submitted dossier.

a) Point to 'Company' and click on 'View'

b) The second row in the 'General Information' field contains the UUID of the submitting Legal Entity

  Back to Top


How can I check that my attachments in section 1.4 have been included when I submit my dossier?

The issue related to a problem with attachments in section 1.4 was introduced in IUCLID 5.2.0, and is described in IUCLID 5 FAQ I cannot attach documents in section 1.4 of IUCLID 5.2, is it normal?.  
This issue had been fixed in IUCLID 5.2.2 which was released on 09 August 2010.

However, if a substance dataset was created in IUCLID 5.2.0, the problem was already introduced there and therefore, upgrading to IUCLID 5.2.2 or higher might not fix it. If, while checking the attachments, you receive errors or they do not open, in order to repair the broken links to the attachments in your database, the attachments have to be deleted and re-attached.

Registrants, before submitting their dossier to ECHA, have to ensure that the attachments are included in section 1.4 of their dossier.

1) In section 1.4 of your substance dataset, ensure that all attachments appear both at the Analytical Information repeatable blocks and at the Information pane and confirm you can open and view them.

2) Run the TCC plugin on your substance dataset and correct any detected failures.

3) Create your dossier from the substance dataset.

4) Once you get the message ‘Dossier creation successfully completed’, select ‘View dossier’

5) Ensure that the same number of attachments appear in section 1.4 of your Dossier (both at the Analytical information repeatable blocks and at the Information pane)

If the attachments do not appear, check whether you have flagged certain information as confidential and you have accidentally excluded it from the created dossier. More information on this matter can be found at the FAQ When exporting a dossier, why do I sometimes get a different number of exported files?

6) Run the TCC plugin on your dossier. In case of any failures, rectify them in your substance dataset and create the dossier again.

Note: Similarly, broken links to attachments can also occur in sections 1.7, 1.9 and 3.10 of IUCLID 5, therefore, it is strongly recommended that the registrants verify those sections as well.

  Back to Top


How can I ensure that I run the latest version of the Validation Assistant/TCC plugin on my substance dataset or dossier?

We have recently found out that users who already have the Validation Assistant/TCC plugin installed, and upgrade to the latest version, may encounter the following:

At step 1 of the TCC wizard, the status appears as “Current plugin is up to date”

However, at step 3, the ‘Detailed version information’ of the Validation Assistant/TCC plugin, which appears at the bottom of the TCC results table, is not the latest one.

Note: This inconsistency might have an impact on the accuracy of the TCC results table.

The problem is caused by an incomplete installation. More specifically, while Users copy the latest version of the eu.echa.iuclid.client.plugin.tccvalidate.ui.zip file into the folder <iuclid5-folder>\plugins\client (for the standalone version of IUCLID 5) or into the folder <iuclid5-webapp-folder>\i5clientPlugins\remotePlugins (for the distributed version of IUCLID 5), they forget to also copy the latest version of the eu.echa.iuclid.server.plugin.tccvalidate.zip file into the folder <iuclid5-folder>\plugins\server (for the standalone version of IUCLID 5) or <iuclid5-webapp-folder>\WEB-INF\classes\plugins (for the distributed version of IUCLID 5). Consequently, the installation of the TCC plugin is incomplete, as both of the files are not of the latest version.</iuclid5-webapp-folder></iuclid5-folder></iuclid5-webapp-folder></iuclid5-folder>

Make sure you carefully read the Validation Assistant/TCC plugin installation manual and copy the correct files into the correct location.

Additionally, verify the version appearing at the bottom of the TCC result table against the ‘detailed version information’ of the plugin. The ‘detailed version information’ is always specified in the ‘Release notes’ text file of each Validation Assistant/TCC plugin.

Note: Remember to always clear the cache after an upgrade. The cache stored by an old version of the IUCLID 5 plugin creates a version conflict/incompatibility. Instructions on how to clear the cache can be found in the following question - How can I clear the IUCLID 5 cache?

  Back to Top


When I run the Validation Assistant/TCC plugin on my dossier, several Business Rules failures (BR failure) or Technical Completeness check failures (TCC failure) are detected. How can I correct them?

The Validation Assistant can be used to check the completeness of a dossier or a substance dataset.

When checking a dossier, it will -by default- perform the Technical Completeness Check applying the rules for the dossier template used in the creation of the dossier.

When using the Validation Assistant on a substance dataset, the user needs to select which rules need to be applied for the TCC.

Note: The correction of any failures can only be done on a substance dataset, as a dossier is a read-only document which cannot be modified.

The video below illustrates how to create a dossier, run the TCC plugin, correct the failures on the substance dataset and re-create the dossier. (The example presented in the video, concerns a lead dossier for a joint submission and the TCC plugin, but the same instructions apply to the Validation Assistant plugin)

Right-click the link and choose 'Save Link As...' to save the file.Download the video

An overview of the steps required to make sure that a dossier passes the Business Rules can be found in the Data Submission Manual 4: How to pass Business Rule Verification (‘Enforce Rules’)

  Back to Top


Questions related to Classification & Labelling Notification


How can I run the Validation Assistant plugin for a Classification and Labelling (C & L) notification?

The Validation Assistant runs on C&L Notification dossiers only, and not on substance datasets. Therefore, fill in your substance dataset, create your C&L notification dossier, and thereafter, run the Validation Assistant on the dossier.

- Instructions on how to create the substance dataset for a C&L notification can be found in Chapter 4 of the Data Submission Manual Part 12- How to Prepare and Submit a Classification and Labelling Notification using IUCLID

- Instructions on how to create a C&L notification dossier can be found in Chapter 6 of the Data Submission Manual Part 12- How to Prepare and Submit a Classification and Labelling Notification using IUCLID

- To run the Validation Assistant on the created C&L notification dossier, right click on the dossier and select 'Run Validation Assistant'.

  Back to Top


Questions related to Biocides


How can I link compositions to C&L sections in a biocidal product in IUCLID 5?

Linking compositions to Classification and Labelling sections is not possible in a biocidal product dataset.

The presence of the field 'Related compositions' in the Classification and Labelling sections is caused by the use of the same templates for other legislations, such as REACH.

If several classifications are recorded for the same product or for a product family, you need to indicate in the remarks field available in the classification and labelling block to which Biocidal product composition such classification is related to. You need to specify the Biocidal product name as identifier.

  Back to Top


Is there a specific IUCLID 5 template for micro-organisms?

There is no specific template for micro-organisms. However, you can find the units relevant for micro-organisms, such as: CFU/g, CFU/L, IU/g, IU/L for biocidal product related information 'Application dose' and 'Final concentration in treated article or system' (section 7.6). You should use the existing templates dedicated to biocides in IUCLID 5.5 (BPR Active substance application and BPR Biocidal product authorisation) including as much information as possible.

Everything that cannot be included into the existing IUCLID templates should be sent as a document attached to the respective section endpoint in IUCLID.

For endpoints that are marked as mandatory (in red) in IUCLID sections tree, but are not relevant for micro-organisms, i.e. Flammability, please select 'Data waiving', and provide 'Justification for data waiving'.

  Back to Top


How can I use the Report Generator in IUCLID 5 to generate a Summary of Product Characteristics (SPC)?

The Report Generator plug-in can generate a draft SPC document based on a biocidal product dataset contained in IUCLID. It generates the complete structure of the SPC including all main sections and subsections. The generated file, in XML or rtf format, can be saved.

In order to generate the draft SPC, you will need to:

  1. Install the 'Report generator' plugin in IUCLID 5.
  2. Access IUCLID 5 and click on the link 'Run' under Report Generator Report Generator icon
  3. Select 'BPR – draft summary of product characteristics' under the heading 'Select the type of report' and 'dataset' under 'Select the source of information.' Click on the golden chain, search for the dataset and click on the button 'Assign.' Report Generator Assign
  4. Select the report format –rtf or XML- and save the file. Report Generator Format
  5. Click on the 'Generate report' button to display your draft SPC.

While you may edit manually your draft SPC, it is recommended that you make any needed changes in the IUCLID dataset to avoid inconsistencies.

Further instructions on how to install the SPC Report Generator and how to fill in correctly your IUCLID dataset sections to generate the draft SPC can be found in the download section as 'Report Generator (CSR Plug-in)' at: http://iuclid.eu/index.php?fuseaction=home.menuNOTSignedUp&page=home.download55.

  Back to Top


Is there a Technical Completeness Check (TCC) plug-in available to check biocides dossiers prepared under the EU Biocidal Products Regulation (BPR)?

Under the REACH Regulation, Article 20(2) defines the duty of the European Chemicals Agency to perform a technical completeness check of registration dossiers and PPORD notifications. Under the BPR, the validation of the applications is the responsibility of the evaluating competent authority (Cf. for example, BPR Article 7(3) for the application for the approval of an active substance and Article 29(2) for a biocidal product authorisation application). Therefore, at present ECHA has no plan to develop a tool for validating biocides applications.

The TCC plug-in not only includes technical completeness check rules but also gives the possibility for an applicant to verify the business rules. These business rules are verified by the Agency to ensure that the IUCLID dossiers contain the required information to be further processed by the IT systems. Business rules for Biocides dossiers are currently available only in R4BP 3. ECHA is investigating the possibility of including a set of business rules for biocides dossiers provided they can be applied independently from R4BP 3 (i.e. only in IUCLID).

  Back to Top


Which IUCLID template to use (and from which object should the dossier, substance or mixture be created) when creating the following type of dossier: application for inclusion on the list of active substance suppliers (BPR Art. 95)?

To create a dossier containing information required by Article 95 of the BPR:

  1. Create a substance dataset
  2. Fill in all the required information using the template BPR Active substance application
  3. Create a biocidal product dataset and link the substance dataset previously created in the biocidal product composition section
  4. Based on this biocidal product, create a BPR Active substance application dossier following the dossier creation wizard
  5. Export your dossier to be able to submit it to ECHA using the relevant submission form in R4BP 3

More information and instructions for IUCLID dossier creation can be found in:

In some cases, a letter of access can be submitted instead of a dossier.

  Back to Top

How to provide the Legal Entity for the components of a biocidal product (active substance, non-active substance, substance of concern, mixture)? Whose Legal Entity should be inserted?

A dataset for active substance(s), non-active substance(s), and substance(s) of concern or mixture(s) will need to be created before the applicant enters the relevant composition in section 2.3 of the “BPR Biocidal product authorisation” dataset. The relevant templates for those components are: “BPR Active substance application”, “BPR basic information (substance)”, “BPR substance of concern” and “BPR basic information (mixture)”. The template should be selected to create a dataset depending on the substance or mixture the applicant refers to.

In each of the above mentioned templates, in section 1.3 there is a place to enter the Legal Entity of the supplier (manufacturer, importer, and formulator) of the substance/mixture. For the “BPR Active substance application”, the information about active substance manufacturer is mandatory. For the remaining templates, this information is optional, but recommended to be inserted if known.

Section 1.3 is named currently in IUCLID 5.5 and 5.6 ‘Active substance manufacturer’ in all substance related templates or ‘Biocidal product manufacturer’ in a mixture related template. This is a mistake as this name is appropriate only for “BPR Active substance application”. In the following templates: “BPR basic information (substance)”, “BPR substance of concern” and “BPR basic information (mixture)”, section 1.3 names will be corrected to ‘Suppliers’ in a future maintenance release.

All Legal Entities entered in the components’ datasets will be linked to section 2.3 of the biocidal product dataset together with all other data.

The Legal Entity of the applicant is displayed in section 2.1 of the BPR Biocidal product authorisation dataset.

Back to Top

around corner