FAQ
Login
- When I try to log into IUCLID 5 for the first time, why can I not log in?
- 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?
Data Entry
- When searching for a Substance/ Reference substance, I do not get the expected results. What is wrong?
- 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?
- Please explain data exchange
- Why is there no comment in modification history for pasted endpoints?
- Why does the clipboard short cut key (F8) not work?
- Text printed from rich text areas in IUCLID may not always have the same formatting as on screen
- 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.
- How can I create my own Reference substance(s)?
- How can I create multiple substance datasets from the same Reference Substance assigned to different Legal Entities?
- What do the symbols preceding each IUCLID 5 section or subsection mean?
(updated 05 December 2012) - Why can I not import legal entity objects (LEOs) from REACH-IT to IUCLID 5.3 (i.e. the previous IUCLID version)?
(updated 05 December 2012) - How can I assign a legal entity to my user?
- Can I use the Import/Export function of IUCLID 5 as a method of data synchronisation?
Import/Export
- Why do export file contents differ slightly?
- I received the error : "error java.lang.OutOfMemoryError". What am I to do?
- When exporting a dossier, why do I sometimes get a different number of exported files?
- 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
- Why can I no longer see my plug-ins after upgrading my IUCLID 5 standalone version with the Windows installer? (updated 07 December 2011)
- Which plug-ins are compatible with which versions of IUCLID?(updated 19 October 2012)
- When trying to run the TCC plug-in 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 plug-in can only check dossiers created with a REACH-specific
template. What is wrong?
(updated 05 December 2012) - When I run the TCC, I get a SYS1500 error message, why?
(updated 05 December 2012) - How can I clear the IUCLID 5 cache? (published 05 December 2012)
Upgrade & Migration
- What is the purpose of the IUCLID Backup plug-in for IUCLID 5.2?
- Can I import a file generated with a previous IUCLID 5 version to the latest IUCLID 5 version? (updated 05 December 2012)
- Where can I find information on the changes performed during the migration process? (updated 05 December 2012)
- Can the backup and migration processes be parallelised?
- I cannot upgrade to IUCLID 5.1.1 with my Oracle database.
- I want to upgrade to IUCLID 5.1, but I cannot find the manuals.
- Why do I receive an error 403 after updating the distributed version from 5.0 to 5.1?
- Why does migration fail with "java.lang.NumberFormatException"?
- Migration fails with "TransformationException: Null Pointer Exception caught." What can I do?
- Industrial category is not migrated from IUCLID 4. What can I do?
- Text in a rich text area behaves erroneously when created during migration of IUCLID 4 data
- When upgrading from IUCLID 5.1.0 to IUCLID 5.1.1, I can no longer connect to my Oracle database, why?
- I have upgraded to IUCLID 5.3 and I receive an error message while opening attachments. Why?
- 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)
- How do I modify the IUCLID 5 home folder location? (updated 05 June 2012)
- The user accounts have expired. What should I do? (published 05 June 2012) (updated 05 December 2012)
- When restoring users account in IUCLID 5.3.2, an error message is displayed. How can I fix it? (published 05 June 2012)
- 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)
- 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)
- Which version of IUCLID should I use?
(published 27 March 2013) - How can I upgrade from IUCLID 5.2x/5.3x to IUCLID 5.5.0 and still be able to access all my existing data? (published 27 March 2013
- How can I upgrade from IUCLID 5.0/1 to IUCLID 5.5.0 and still be able access all my existing data? (published 27 March 2013)
- 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)
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?
- I do not know how to start the IUCLID Installer on Windows Vista. What must I do?
- I cannot install IUCLID 5 on my Windows 7 computer, why?
- What are the hardware and software requirements for installing the Tomcat Application Server?
- What are the hardware and software requirements for installing the database server?
- What architecture does IUCLID 5 apply?
- Can IUCLID 5 work in a multi-tier
application environment where the Web Server, Application Server, and
Oracle Server are all on separate servers?
- How will the IUCLID 5 client software be distributed to the client workstations in distributed installations?
- How can I show a difference between different IUCLID installations in the IUCLID interface? (updated 05 December 2012)
- How can I connect to IUCLID 5 through a proxy server?
- How can I make a backup of my IUCLID database?
(updated 27 March 2013) - How to find the IUCLID 5 log files? (published 05 June 2012)
- 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?
- What are the recommended software and hardware requirements for IUCLID 5.5? (updated 27th March 2013)
- How can I distinguish user accounts when using Windows, IUCLID 5 stand alone installation and PostgreSQL database?
- Which PostgreSQL version should be used with IUCLID 5? (updated 05 June 2012)
- When installing Chesar 1.x on my 64-bit Windows 7, Chesar does not work, why?
- How to download the correct PostgreSQL version with IUCLID 5? (updated 07 December 2011)
- How can I uninstall IUCLID 5 standalone version from my Windows PC?
- What is the compatibility between versions of IUCLID 5 and Java? (published 27th March 2013)
- Which version of Java should I use with IUCLID 5.4.1 or 5.5.0? (published 27th March 2013)
- Can I have both Java 6 and Java 7 installed on a computer at the same time? (published 27th March 2013)
- 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 27th March 2013)
- 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? (published 27th March 2013)
- How can I find out the version of Java that Windows uses by default on my computer? (published 27th March 2013)
- 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 27th March 2013)
- 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 27th March 2013)
Common Installation Problems
- I get an error code 500 when trying to connect to IUCLID 5 from the Webserver, why?
- With Tomcat 5.5.26 HTTP 500 error message is displayed in the browser.
- ‘Cannot create the destination folder’ error is displayed during the installation on Windows 7. What am I to do?
Known Issues- IUCLID application
- IUCLID 5.4.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
- IUCLID 5.3
- 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?
- 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
Known Issues - IUCLID plug-ins
- Dissemination plug-in / version 5.4.1 running in IUCLID 5.5
- TCC plug-in / version 5.4.0
- CSR plug-in / version 5.4.0
- Using the CSR
plug-in 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)
- Using the CSR
plug-in 5.4.0 on IUCLID 5.4.0 distributed version (Linux server), the
titles and headers are missing from the CSR report.
- CSR plug-in / version 5.4.1
Questions related to REACH Registration
- UUID synchronisation between REACH-IT and IUCLID 5 (VIDEO INCLUDED!)
- 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?
- How can I check that my attachments is section 1.4 have been included when I submit my dossier?
- How can I ensure that I run the latest version of TCC plug-in on my substance dataset or dossier?
(updated 05 December 2012) - When I run the TCC plug-in on my
dossier, several Business Rules failures (BR failure) or Technical
Completeness check failures (TCC failure) are detected. How can I
correct them?
Questions related to Classification & Labelling Notification
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.
Login
When I try to log into IUCLID 5 for the first time, why can I not log in?
The first time you log into IUCLID, your username is "SuperUser" (without the “”) and your password is "root" (without the “”).
I created a new user account on the
IUCLID 5 website but I have not received the activation email. How
can I activate my account?
Due to the large amount of spam that IT systems usually experience, corporate email management systems are set up with very restrictive policies. In some cases, emails may be filtered out and considered to be spam. Therefore, it is possible that our notifications, activation account emails and other emails, do not reach IUCLID 5 users. If you have activated your account or made a request for a forgotten password, and you have not received the answer within an hour, it may be due to the spam filtering. In that case, we advise you to contact your system administrator in order to validate iuclid5@echa.europa.eu email address and set it up as trusted address. You should then contact the IUCLID 5 support Team using the web-form at http://iuclid.echa.europa.eu, in order for us to activate your account manually.
Data Entry
When searching for a Substance/ Reference substance, I do not get the expected results. What is wrong?
IUCLID 5 will fetch a maximum of 2.000 records when doing a
search from the database. If your query results contain more than 2.000
matching records, only the first 2.000 will be displayed. Since sorting
is done after the records are fetched, this is not always apparent.
There will, however, be a warning in the lower left hand corner of the
IUCLID 5 main window stating that the query result was limited. If
you encounter this warning, you should refine your query parameters so
that less than 2.000 matches are found.
The same problem can
also occur when attaching Reference substances to a substance dataset.
This can be detected looking at the number of results found. If the
maximum number of 2.000 records is reached, some records might not be
displayed. Please refine your search to find the correct record.When
searching for active Reference substances, it is better to use the
first letter of your Reference substance, followed by an asterisk, for
example k*, instead of * in the Reference substance name field, because
this limits the amount of records displayed. The retrieved result can
then be filtered setting the "active only" flag.Similar problems might
also be encountered during some other query procedures. As a general
advice you should always make the query as specific as possible to
avoid the problem of truncated query results and to make it easier to
find the desired results from the query results list.
When
pressing the "Update" button for Substance /Reference substance etc. on
the task panel, IUCLID 5 will return all entries from the database
by default. If more than 2.000 entries have been found, IUCLID 5
will ask the user if this query should be skipped in the future. This
is the only way to get a list with unlimited number of results – this
query might take a long time to execute and can be disabled in the User
Preferences.
The filtering on the query results works in the following way:
If
the search string is "m", a wildcard (*) is automatically inserted by
default before and after the string (*m*). The search returns results
containing the desired string "m" whatever its position in the name If
you want to search for all records beginning with "m", you must execute
your search in the following way: m*.
Which contact address will be used by ECHA
- the REACH-IT registration contact, the contact described in the
IUCLID 5 legal entity or the contact given in the substance data
set?
The most important contact address in the context of REACH registrations is the one given at the REACH-IT signup, since this is considered to be the most up-to-date information. There is no obligation to provide substance specific contact details in IUCLID 5.
Please explain data exchange
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.
- Export the data in question to an .i5z file
- Rename this .i5z file to .zip
- Open the .zip file with an appropriate tool (e.g. winzip)
- Open the .i5d file from which you want to remove the modification history entry with wordpad
- Search for "<i5:modificationHistory>" using the find function of WordPad
- 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
Why is there no comment in modification history for pasted endpoints?
When an endpoint is newly created, an entry into the modification history of the substance dataset is created including a comment on which endpoint has been added. When an endpoint is pasted to a substance dataset, the modification history is updated but no comment is attached.
Why does the clipboard short cut key (F8) not work?
The F8 key only works if the focus is currently in the data window of IUCLID 5. The menu entry will always open the clipboard.
Text printed from rich text areas in IUCLID may not always have the same formatting as on screen
1) Migrated text is not wrapped correctly. Text may be cut at the right margin.
2) All text fonts applied in IUCLID are displayed in the font Helvetica.
3) All headings are displayed in font Helvetica and with standard sizes.
4) Empty cells in a table do not have a border when the table was copied from Microsoft Word.
Work-around:
1) see work-around for known issue with migrated text (copy to text editor, clear rich text area, copy and paste back)
2) and 3) remove the style definition in the printed html file, save and reopen the html file
Before:
------------------------------snip-----------------------------------
<html>
<head><meta name="subject" content="IUC5-c282775f-1400-4bd5-b04b-74f60341f6d0/0" />
<title>Endpoint study record: Melting point/freezing point, IUC4#1/Ch.2.1</title>
<!-- Creator: IUCLID 5 -->
<!-- Creationdate: Wed Oct 17 13:48:28 EEST 2007 -->
<meta name="author" content="au" />
<!-- iText 1.4.8 (by lowagie.com) -->
<!-- CreationDate: Wed Oct 17 13:48:28 EEST 2007 -->
<style><!-- Font { font-family: Helvetica; font-size: 10pt } div { font-family: Helvetica; font-size: 10pt }
--></style></head>
<body leftmargin="50.0" rightmargin="50.0" topmargin="50.0" bottommargin="50.0">
------------------------------snip-----------------------------------
After:
------------------------------snip-----------------------------------
<html>
<head><meta name="subject" content="IUC5-c282775f-1400-4bd5-b04b-74f60341f6d0/0" />
<title>Endpoint study record: Melting point/freezing point, IUC4#1/Ch.2.1</title>
<!-- Creator: IUCLID 5 -->
<!-- Creationdate: Wed Oct 17 13:48:28 EEST 2007 -->
<meta name="author" content="au" />
<!-- iText 1.4.8 (by lowagie.com) -->
<!-- CreationDate: Wed Oct 17 13:48:28 EEST 2007 --></head>
<body leftmargin="50.0" rightmargin="50.0" topmargin="50.0" bottommargin="50.0">
------------------------------snip-----------------------------------
4)
Either enter a space in empty cells already in Microsoft Word before
copying, or try using a different editor, e.g. OpenOffice.org Writer
does not create this problem.
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:
- 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. - 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.
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:
- Go Home
to the Task panel if you are not already there
- Under Reference substance
click New - 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.
- Click the Finish button.
- 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. - 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.
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'
- Create a substance dataset, and complete all the necessary information
- Left click on the arrow as illustrated in the image below, and select ‘Copy contents to clipboard’
- Keep the clipboard open
- From the 'Tasks' menu, select a 'New' Substance
- Give a new name to your substance and assign a different Legal Entity to it
- 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)
- Press 'yes' to the following warnings (below one example)
- 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'
- From the Tasks menu, select 'New Template' and select 'Copy' as the type of template
- Fill in all the information which will be used later at the creation of your substance datasets
- Copy the data to the clipboard
- From the 'Tasks' menu, select a 'New' Substance
- 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)
- 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.
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.
Why can I not import legal entity objects (LEOs) from REACH-IT to IUCLID 5.3 (i.e. the previous IUCLID version)?
The current version of REACH-IT accepts dossiers created only with IUCLID 5.4. The legal entity object (LEO) exported from REACH-IT is converted to IUCLID 5.4 format and therefore cannot be used with IUCLID 5.3 or earlier versions. IUCLID 5 files are ‘forward compatible’ and any files created with, or converted for a newer version, cannot be used with the older IUCLID 5 versions.
How can I assign a legal entity to my user?
- Log in as SuperUser
- Go to Tools and administration and choose ‘User management’
- Select your User from the left pane
- Click the green Plus
button under assigned Legal Entities.
The following dialog appears:
- Enter your search criteria (wildcards such as * can be used)
- 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'.
- Select the Legal Entity and click the Assign button to complete the process.
- Click the Save button. The following message appears. Click OK
- Log out (as SuperUser) and log in again as your User.
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:
- 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 - Export the substance dataset X file from IUCLID instance A
- Import the substance dataset X file to IUCLID instance B
- 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 - Export the substance dataset X from IUCLID instance B
- Import the substance dataset X to IUCLID instance A
The final result in IUCLID instance A when setting the overwrite mode to:
- '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 - '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 - '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 - '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.
Import/Export
Why do export file contents differ slightly?
XML export files created by IUCLID 5 can have slightly different contents for fields that are empty. In some cases notes that do not contain data are omitted, in other cases they are included as empty element (). This behaviour depends on how the exported object was created and which database management system is used. These differences do not have any practical impact on the behaviour of IUCLID 5.
I 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.
- Edit the iuclid5.cmd file.
- 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. - Save the file
In the distributed environment:
All
files are loaded into memory on the client’s computer; therefore you
need to run the client connection with more memory: You can do this by
selecting, from the available connections on your browser, "install
IUCLID 5 Client (with 768MB RAM)" or "(with 1 GB RAM)", as shown
in the figure below:
Ensure that you have shut down all other applications and that you have sufficient memory on your client computer.
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.
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.
plug-ins
Why can I no longer see my plug-ins after upgrading my IUCLID 5 standalone version with the Windows installer?
During a ‘major ‘version upgrade of IUCLID 5 (e.g. from IUCLID 5.2 to 5.3), plug-ins are not automatically copied to the appropriate folders from the old IUCLID 5 version. plug-ins are only automatically copied when a maintenance release is installed, i.e. when the ‘major’ version number remains the same (for example 5.3.1 to 5.3.2). If the ‘major’ version number changes, you need to download the compatible plug-ins from the IUCLID website and install them in the appropriate folders.
Which plug-ins are compatible with which versions of IUCLID?
The compatibility matrix tables below show which plug-in works with which IUCLID version.
When trying to run the TCC plug-in 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 plug-in can only check dossiers created with a REACH-specific template. What is wrong?
The problem lies in the client's cache. The user should clear their cache after an upgrade to resolve the problem (the cache stored by an old version of IUCLID5 plug-ins creates a version conflict/incompatibility). Instructions on how to clear the cache can be found in question How can I clear the IUCLID 5 cache?
When I run the TCC, I get a SYS1500 error message, why?
1) Ensure that you follow the instructions in the TCC user manual and copy the files to the correct folder:
Note: For the standalone version, ensure that you copy BOTH files into the correct location
The TCC plug-in user manual, is included in the installation package (zip folder) you have downloaded from http://iuclid.echa.europa.eu.
2) 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) If the problem persists, it needs to be distinguished whether it is caused by:
a) An installation problem or
b)Corrupted data
In order 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 plug-in being careful to place the correct files into the correct folders and clear the cache.
b) CORRUPTED DATA
1. 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 TCC again.
- If (after the removal and re-attachment) you still get the error message, then try to export, delete and re-import the substance dataset selecting the ‘if newer than existing’ option. Before doing so, please make sure you have a back up of your data, using the IUCLID 5 back up function. For more instructions on how to back up your data, please refer to section ‘D.18.2- Backing up data’ of the IUCLID 5 end-user manual.This document is fully integrated in the IUCLID 5 help system.
How can I clear the IUCLID 5 cache?
Sometimes it is necessary to clear the IUCLID 5 cache. For example, the cache stored by an old version of IUCLID 5 plug-ins may create a version conflict/incompatibility.
The cache can be cleared as follows:
STANDALONE version:
Delete the directory: C:\Documents and Settings\*your username*\.iuclid5\.jpf_shadow.
The directory will be recreated when you start IUCLID5 again.
DISTRIBUTED version:
Go to /work/Catalina/local host and delete the ‘local host’ directory.
It will be recreated when you start IUCLID 5 again.
Also, ensure that the folder C:\Documents and Settings\[your username]\.iuclid5\.jpf_shadow on the client computer(s) is deleted.
This folder will be recreated when they reconnect to IUCLID 5.
Upgrade & Migration
What is the purpose of the IUCLID Backup plug-in for IUCLID 5.2?
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. This plug-in is compatible with IUCLID 5.0 and 5.1
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.
Note that IUCLID 5 files are ‘forward compatible’ and any files created with, or converted for a newer version, cannot be used with the older IUCLID 5 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 having removed the previously installed version of IUCLID.
The migration process is encapsulated in the IUCLID 5 client plug-in named "i5xform_v10". If this plug-in is removed, the affected IUCLID 5 installation will not accept compatible files from the previous IUCLID 5 versions anymore.
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 plug-ins .In a secondary step the data can be imported and by that migrated into a more recent IUCLID installation.
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?
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.
I cannot upgrade to IUCLID 5.1.1 with my Oracle database.
In order to succeed with the upgrade of IUCLID 5.1.1, please ensure the following:
- you are running at least Oracle 10g* Release 2 (10.2.0.4)
- you
are using the latest jdbc driver (always do this) and have replaced
\i5server\WEB-INF\lib\ojdbc14.jar in IUCLID 5 with ojdbc6.jar
* As Oracle no longer supports the development of Oracle 10g, if any new bugs arise you need to upgrade to 11g.
I want to upgrade to IUCLID 5.1, but I cannot find the manuals.
All installation manuals can be found on our website under Get Support/Documentation/IUCLID 5 Installation manuals section.
Why do I receive an error 403 after updating the distributed version from 5.0 to 5.1?
The error code 403 is related to the configuration of Apache Tomcat. Your users are able to communicate with the server, but either the server cannot find what is requested (could be due to file permissions) or the server is configured incorrectly.
Please check the following:
- If you have a Temp folder in Apache Tomcat, delete it.
- If you still get the error message, check your Tomcat version. We have found that:
Tomcat 5.5.20 Works
Tomcat 5.5.25 Broken -> 403 after login
Tomcat 5.5.26 Broken -> Works
Tomcat 5.5.27 Broken -> 403 after login
Tomcat 6.0.14 Broken -> 403 after login
Tomcat 6.0.18 Works - If possible, please update your Tomcat version to one of the working versions.
- Please also check your /conf/tomcat-users.xml, which should include the role of 'admin'..e.g.
<?xml version='1.0' encoding='utf-8'?>
<tomcat-users>
<role rolename="admin"/>
<role rolename="manager"/>
<role rolename="tomcat"/>
<role rolename="role1"/>
<user username="admin" password="secret" roles="manager,admin"/>
<user username="tomcat" password="tomcat" roles="tomcat"/>
<user username="role1" password="tomcat" roles="role1"/>
<user username="both" password="tomcat" roles="tomcat,role1"/>
</tomcat-users> - You also need to ensure that after having copied the .war file into Tomcat, the Tomcat user is able to read it. Right click on the file and check / properties security. Users should have Read, Write and Execute permissions.
- In Apache the Tomcat Properties, Ensure that the logging level is set to Debug.
Send us the Tomcat log files, which are normally found in the folder /Tomcat x.x/logs, as well as the i5server.log file.
Why does migration fail with "java.lang.NumberFormatException"?
When the user specified comma as decimal separator in the User Preferences (User Preferences/Settings/IUCLID 5 user preferences/Decimal separator), migration fails with a " java.lang.NumberFormatException" error. As a work around please set the decimal separator to dot when the migration tool is executed. After migration the decimal separator can be reset.
Migration fails with "TransformationException: Null Pointer Exception caught." What can I do?
This error is caused in most cases by missing information in chapters 10.1 (End point summary) or 10.2 (Hazard summary) of IUCLID 4 when using the migration tool version 5.0.0. These chapters are expected to contain a reference to another chapter in the IUCLID 4 dataset. If this reference is missing, it is not possible to encode the corresponding data in IUCLID 5 as there is no unspecific summary foreseen in the data model.The error will not occur with the new version of the migration tool (version 5.1.1).
The malformed data will be reported in the migration report in case of chapter 10.1 (End point summary). For chapter 10.2 (Hazard summary), the data will be migrated to section 13 (Assessment Reports) in IUCLID 5.
Industrial category is not migrated from IUCLID 4. What can I do?
Using the migration tool version 5.0.0, the information stored in IUCLID 4 chapter 1.7.1 detailed use pattern was not migrated. This problem has been solved in the new migration tool (version 5.1.1). The information is now migrated correctly.
Text in a rich text area behaves erroneously when created during migration of IUCLID 4 data
- Long lines are not wrapped automatically
- Long
text is not broken to the next line when extending over the right
border of the rich text area. This is true also in the printed document.
Lines can be broken manually by pressing the return key at the appropriate position in the next. Unfortunately this does not change the line breaking behaviour of the print. - It is not possible to insert tables into migrated text
- When trying to create a table in a text created during migration, an exception occurs.
Work-around:
In order to correct this behaviour, one has to remove all formatting from the migrated text by copying it from IUCLID to a simple text editor (e.g. Notepad, not Word). Than the rich text area has to be cleared by using the “New File” button which can be found above the rich text area in the upper left hand corner. Now copy the text from the text editor back to IUCLID using Ctrl-v. Please be aware of the copy-and-paste issues described above. If necessary change the font of the text to a non-proportional font (e.g. Courier) to preserve tables designed in IUCLID 4.
When upgrading from IUCLID 5.1.0 to IUCLID 5.1.1, I can no longer connect to my Oracle database, why?
During the upgrade the SQL command is run:SQL ALTER TABLE queryindexitem MODIFY (repblockid varchar(255 CHAR)) causing the Error message: ORA-01450: maximum key length (6398) exceeded.
When creating an index, the total length of the index cannot exceed a certain value. Primarily this value depends on DB_BLOCK_SIZE. For an 8K block size, the maximum index key length is 3218. When installing Oracle the default block size is 8K.
The maximum index key length is measured by: Maximum index key length=Total index length (Sum of the width of all the indexed columns +the number of indexed columns) +the Length of the key(2 bytes) +ROWID(6 bytes)+the length of the rowid(1 byte)
The index key size is limited by the value of db_block_size, because a key value may not span multiple blocks.It is required that any index block must contain at least TWO index entries per block.
So we can say that the maximum key length for an index will be less than half of the DB_BLOCK_SIZE.But we know that in a block space is also needed for PCTFREE, INITRANS and space for block overhead(Block Header,ROW Directory, Table Directory, etc). After considering these bytes the actual space that can be used for the Index key is actually just over 1/3 of the DB_BLOCK_SIZE.
To solve the problem, you need to create a second tablespace with 16k. You need to drop all indexes on the table queryindexitem (from the current tablespace). Recreate all indexes on table queryindexitem (in the new tablespace). Please see the script below on how to do this:
/* IUCLID 5.1.1 */
/* Script to move table QUERYINDEXITEM with it’s indexes to */
/* a new created tablespace with block size 16k */
/* the red text have to be replaced by the ORACLE DBA */
CONNECT system/pwd@ora10
ALTER SYSTEM SET db_16K_cache_size = 8M;
REATE TABLESPACE IUCLID5_16K
datafile 'E:\U10\U10\IUCLID5P16k_TS.DBF'
size 5000M
blocksize 16k;
ALTER USER IUCLID5 QUOTA UNLIMITED ON IUCLID5_16K;
CONNECT IUCLID5/pwd@ora10
DROP TABLE QUERYINDEXITEM;
CREATE TABLE QUERYINDEXITEM
(
PARENTPK VARCHAR2(255 char) not null,
INDEXPK VARCHAR2(255 char) not null,
FIELDNAME VARCHAR2(255 char) not null,
REPBLOCKID VARCHAR2(255 char) not null,
TIMESTAMP NUMBER,
TEMPLATEPK VARCHAR2(255 char),
DOCREFPK VARCHAR2(255 char),
DOCREFTYPE VARCHAR2(255 char),
DOSSIERPK VARCHAR2(255 char),
ECINVNO VARCHAR2(255 char),
ENDPOINTKIND VARCHAR2(255 char),
PARENTTYPE VARCHAR2(255 char),
INDEXTYPE VARCHAR2(255 char),
FIELDVALUE VARCHAR2(255 char),
LOWERQUALIFIER VARCHAR2(255 char),
LOWERVALUE FLOAT,
UPPERQUALIFIER VARCHAR2(255 char),
UPPERVALUE FLOAT,
UNIT VARCHAR2(255 char),
ORIGINAL VARCHAR2(2000 char),
CONSTRAINT QUERYINDEXITEM_PK PRIMARY KEY (PARENTPK,INDEXPK,FIELDNAME,REPBLOCKID)
) TABLESPACE IUCLID5_16K;
/* The content of the table can be re-created via the IUCLID */
/* user interface: Query Tool>Administration */
/* DROP INDEX QUERYINDEXITEM_COMB1_IDX; */
CREATE INDEX QUERYINDEXITEM_COMB1_IDX ON QUERYINDEXITEM
(
REPBLOCKID,
PARENTTYPE,
INDEXTYPE,
FIELDVALUE
) TABLESPACE IUCLID5_16K;
/* DROP INDEX QUERYINDEXITEM_COMB2_IDX; */
CREATE INDEX QUERYINDEXITEM_COMB2_IDX ON QUERYINDEXITEM
(
FIELDNAME,
REPBLOCKID,
ENDPOINTKIND,
PARENTTYPE,
INDEXTYPE
) TABLESPACE IUCLID5_16K;
/* DROP INDEX QUERYINDEXITEM_COMB3_IDX; */
CREATE INDEX QUERYINDEXITEM_COMB3_IDX ON QUERYINDEXITEM
(
DOCREFPK
) TABLESPACE IUCLID5_16K;
/* DROP INDEX QUERYINDEXITEM_COMB4_IDX; */
CREATE INDEX QUERYINDEXITEM_COMB4_IDX ON QUERYINDEXITEM
(
INDEXPK,
DOCREFPK
) TABLESPACE IUCLID5_16K;
/* DROP INDEX QUERYINDEXITEM_COMB5_IDX; */
CREATE INDEX QUERYINDEXITEM_COMB5_IDX ON QUERYINDEXITEM
(
PARENTPK,
ENDPOINTKIND
) TABLESPACE IUCLID5_16K;
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.
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.3.x\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 ensure that the database user is the same as in the workstation.properties file. In this example, the database username is iuclid5.
Check the 'Login Roles', right-click on the login role 'iuclid5', 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 iuclid5 database('hibernate.connection.url=jdbc:postgresql://localhost:5432/iuclid5') is defined in: 'hibernate.connection.password=iuclid5', therefore, type in the same password in the iuclid5 Login Role window.
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]
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.
- It is possible to simply turn off the expiry feature temporarily. If a user logs in whilst 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.8.2 at: http://iuclid.eu/download/documents/installation/5.3.2/i5_install_server_windows.pdf
- 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 back up 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 before it has finished.”
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.
- Launch IUCLID 5.3.x
- Select File - Administrative tools - Restore
- Select the folder which contains the usermanagement.i5m file
- Click Finish
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.
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:
- Download the ojdbc6.jar driver from the Oracle website: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
- Copy it to the IUCLID folder i.e. WEB-INF/lib.
- Stop and start Tomcat
- Restart IUCLID
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.
Which version of IUCLID should I use?
ECHA recommends using the most recent version of IUCLID. This ensures that you have access to the best range of functionalities, and minimises your chances of running in to 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.
How can I upgrade from IUCLID 5.2x/5.3x to IUCLID 5.5.0 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.0. However, unless the database contains a very large amount of data, the following alternative procedure is recommended.
- 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.
- If the latest update of Java 7 is not already installed on the installation computer, install it now.
- Use the Windows installer to make a fresh installation of IUCLID 5.5.0. 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.0 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.
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. - Run IUCLID 5.5.0 by double clicking on the newly created shortcut.
- At the prompt in the “first Steps” wizard, choose to restore from your backup of IUCLID 5.2x/5.3x.
- 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.0. If you are sure you no longer need it, the older database can be deleted using the tool pgAdmin3 that is supplied with PostgreSQL.
How can I upgrade from IUCLID 5.0/1 to IUCLID 5.5.0, 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.
- If you are unable to start IUCLID 5.0/1, see the FAQ entries on Java and its versions.
- If it is not already present, download and install the Backup plug-in-5.0.3 for IUCLID 5.1.1.
- Use the plug-in to back up all your IUCLID data.
- If the latest update of Java 7 is not already installed on the installation computer, install it now.
- Make a fresh installation of IUCLID 5.5.0 according to the installation manual supplied with the installation package.
- Whilst running IUCLID 5.5.0 for the first time, at the prompt in the “first Steps” wizard, choose to restore from your backup.
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.
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:
- Enter the Control Panel and type UAC in the search box. The first
result returned by the search will be User Accounts - Turn User Account
Control (UAC) on or off.
- Click on it and the UAC window will open. Deselect the option Use
User Account Control (UAC) to help protect your computer and press the
OK button.
- Windows Vista will ask you to restart your computer. After the restart, UAC will be disabled. After the installation you may enable the UAC again.
I do not know how to start the IUCLID Installer on Windows Vista. What must I do?
- Save the package to a folder. For example: "\Users\i5\iuclid5_install",
- Unzip the package and copy the contents of the package to the same folder. For example: \Users\i5\iuclid5_install
- Select Start/Command Prompt
- Right-click and select "Run as administrator"
- The command prompt opens
- Change Directory (CD) to the path where you unzipped you package
- Start the IUCLID 5 installation wizard by writing the following command and pressing enter:
>java –jar iuclid5_install_5.2.0.jar
I cannot install IUCLID 5 on my Windows 7 computer, why?
For IUCLID 5 to run successfully on Windows 7 (32 or 64 bit), ensure the following:
- you have installed the latest and correct JRE version, see http://www.java.com/en/download/faq/java_win64bit.xml
- you have installed the appropriate PostgreSQL version. For manuals see http://www.postgresql.org/docs/manuals/
- you have set the environment variables in Windows 7:
Select Start/computer/properties.
Select "Advanced system settings".
Select "Environment variables"
Select "Path/Edit"
Add your java path, for example, if you have java 6 installed in: "c:\Program Files(x86)\Java\jre6\bin\", add the same path variable value to the end of the "Path" variable. - If you are encountering problems installing PostgreSQL, please check the PostgreSQL Frequently asked questions at: http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows
What are the hardware and software requirements for installing the Tomcat Application Server?
For Tomcat, with JDK, you need around 1000MB of disk space (around 600MB for installation and around 400MB for execution). This does not include the log files. Minimum requirements for a development workstation running Tomcat are: 733 MHz Pentium and 1GB of memory. Do not save on memory because Java can be highly memory-intensive.
What are the hardware and software requirements for installing the database server?
With a clean installation of IUCLID 5, 500MB of disk space is
used. This includes the Reference substance and EC inventory import. We
have not calculated how much space is needed for log files, etc.
To
calculate how much space is needed for the actual substance information
data on your database server, you must know some of your companies’
internal parameters. A Substance or Dossier containing a lot of
endpoints, summaries etc. without attachments needs between 1-5 MB
database space each. In IUCLID 5, all added attachments are stored
inside the database (db) so every added attachment adds its size to the
needed db size. Since the amount of substances and dossiers will differ
between companies, we do not have a model for disk requirements.
2 CPUs with 2 GHz clock rate and 2GB RAM are needed.
What architecture does IUCLID 5 apply?
IUCLID 5 is a three-tier application, the three tiers being:
- database tier
- server tier
- client tier
This
architecture is fully implemented for distributed installations; in
order to simplify installation and running tasks for simple stand-alone
installations, the middle tier is physically executed within the JRE
environment in a workstation installation.
Can IUCLID 5 work in a multi-tier
application environment where the Web Server, Application Server, and
Oracle Server are all on separate servers?
Yes. However, it is important to note that IUCLID 5 is not a classical web application, i.e. no HTML will be produced for displaying the user interface. Therefore a separate web (additional to the used servlet container) server will not be used.
How will the IUCLID 5 client software be distributed to the client workstations in distributed installations?
By using the JNLP / Java WebStart technology, which is included in the JRE 5.0. No local physical intervention is required to install the IUCLID 5 client. Web Start will automatically retrieve the application from the local IUCLID 5 server once the IUCLID WebStart link is clicked for the first time: The application is installed and can then be used. Subsequent calls of the application will of course not need the installation step (unless a new version of the application is detected).
How can I show a difference between different IUCLID installations in the IUCLID interface?
- 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 ||.
- 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=StagingThis 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.
How can I connect to IUCLID 5 through a proxy server?
Please refer to the IUCLID 5 Proxy Configuration Manual.
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:
In order 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:
- Log in as SuperUser.
- Select 'Backup' from the File menu - Administrative tools. The backup assistant starts.
- 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.
- Click the Next button.
- Select the folder where the backed up files should be stored.
- Select whether to export a single or multiple files.
- Select the overwrite mode.
- Press ‘Finish’.
Along with the backup files, the backup folder contains the backup log file, e.g. backup20130226-123456.log which tells the results of the backup.
Important: If you store the backup to portable media, e.g. to a USB key, remember to copy also the ...chksum.xml file.
IUCLID 5 restore:
To restore files saved with the IUCLID backup tool follow these steps:
- Log in as SuperUser.
- Select the 'Restore' from the File menu - Administrative tools. The Restore assistant starts.
- Select the location to restore from as well as the overwrite mode.
- Select Next.
- Select what you want to restore.
- Select Finish.
PostgreSQL backup:
Important: 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 for example 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 ensure 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
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.
Oracle backup:
Oracle database backup is explained very well on Oracle's FAQ website section where they discuss general backup and recovery questions, user managed backup and recovery, and RMAN backup and recovery.
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.
For example: log4j.appender.FileApp.File=C:/temp/iuclid5.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:
IUCLID 5 client creates the
i5client.log file in the current working directory. The current working directory,if you use Internet Explorer, 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.
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.
- If you have forgotten your Postgres account password while
installing the first time, run Command Prompt in Vista as administrator.
- Then type the command 'net user'. You will see a list of users on your computer.
- Find the Postgre account. It is usually “postgres“.
- Change the password by typing 'net user postgres new_password' where 'new_password' is a new password for the Postgres account. You need the Postgres account during install.
- Use the Control Panel or the PostgreSQL installer in the install folder to uninstall any failed installations before installing again.
- During the install, you will be prompted to choose where you want to install the program. Just select a location in another place, for example 'C:\PostgreSQL' or something similar, but not inside Program Files and not inside the Windows folder.
- After the install, you will still see the error message, or something similar such as: 'non-fatal error occurred'. (For Windows Power Users, we are assigning Full Control permission to the Postgres account on the new PostgreSQL install folder). For other users, see below, if you don’t know how to do it.
- Go to where you just installed PostgreSQL. In this case, the C: drive.
- Right-click on the folder (for example, PostgreSQL), and go to Properties – Security tab.
- Click on the Edit button. You will now see some usernames, etc.
- Click on the Add button.
- In the 'Enter the object names to select' box, enter 'postgres' and press Check.
- The Postgres’ user account should appear there.
- Click on Ok.
- From the 'Group or Usernames' box, select the Postgres account.
- In the window below, with lots of checkboxes, assign permission “Full Control” in the Allow Column to it.
- If you don’t want to allow full control, just give it read/write.
- Click on Ok and wait a bit for permissions to be applied.
- Do a re-install. Do not uninstall anything. Just run the setup again. It will say that a PostgreSQL install folder already exists, etc.. Just click on Next until the install finishes. If you see 'file cannot be copied' errors, click on the 'ignore' button when needed.
- PostgreSQL should be up and running on Vista.
- For the original text, please see: http://www.geekscribes.net/blog/2009/04/22/postgresql-database-cluster-initialisation-failed-solution/
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 are:
* 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.
Note:
- Other software versions or components may work, but remain unsupported.
- BEA WebLogic application server is no longer supported
The recommended hardware requirements for IUCLID 5 are as follows.
Note that the following requirements are provided only as a guide.
- At least 2 GB of RAM on the motherboard; 4 GB if PostgreSQL is run on the same machine as IUCLID 5
- Intel Pentium Dual @ 1.8 GHz
- 10 GB of hard drive space for the installation. The needed disk space also depends on the amount of data (substances, dossiers, attachments) stored subsequently in the database. Larger databases containing thousands of documents can easily reach 200-500 GB.
An installation of IUCLID 5 will most likely run on a lower specified machine but the performance might not be satisfactory. The requirements also depend on the version of Windows and the IUCLID plug-ins that are in use. For example, using the Query Tool plug-in 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.
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.
How can I distinguish user accounts when using Windows, IUCLID 5 stand alone 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 logon account. In case 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 e.g. Installation guide for IUCLID 5 version 5.2 Stand alone application, page 10) 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 Super User 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 which 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 6.2.1 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 via a password recovery-function and this account is valid only for the web site.
Figure 6
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. IUCLID 5.4.x currently supports PostgreSQL versions 8.4.x and 9.0.x.
IMPORTANT: PostgreSQL version 9.1.1 is not supported.
When installing Chesar 1.x on my 64-bit Windows 7, Chesar does not work, why?
Currently, Chesar 1.x has been compiled for 32-bit systems and cannot be run on 64-bit systems.
How to download the correct PostgreSQL version with IUCLID 5?
The supported PostgreSQL versions with IUCLID 5 are: s PostgreSQL 8.4.x. or 9.0.5-1. PostgreSQL version 9.1.1 uses a new jdbc driver, which may cause problems and has currently not been tested.
PostgreSQL is available at www.postgresql.org/download. Under the title 'Binary packages' you can find different versions for various operating systems. In this example, it is described where to find the PostgreSQL 8.4 or PostgreSQL 9.0 installer for Windows.
Click the 'Windows' link.
Choose 'Download the one click installer'. By opening this link the connection will be automatically redirected to the EnterpriseDB web site where PostgreSQL is available.
Select either PostgreSQL version 8.4.9-1 or 9.0.5-1 and choose 32bit or 64 bit version depending on your operating system.
If the download does not start automatically or does not start after clicking the information bar, start the download by choosing 'this link'- link.
When downloading begins, save the file to an appropriate place.
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:
- On your Windows PC, go to ‘Start’ - ‘Control Panel’ – ‘Add and Remove Programs’ - select ‘PostgreSQL 8.4’ and click Change/Remove to uninstall Postgres 8.4.
- The message ‘The data directory and the service user account were not deleted. You can delete the data directory afterwards manually’ will appear. Depending on the Windows version, the default data directory will be found at C:\Program Files\PostgreSQL\8.4\data or at C:\Program Files (x86)\PostgreSQL\8.4\data
- To delete the service user account, go to ‘Start’ – ‘All
Programs’ –‘Accessories’ - ‘Command Prompt’ and execute the following
command:
C:\net user postgres /delete - Delete the IUCLID5 installation directory. Depending on the Windows version the default installation directory is: C:\Program Files\iuclid5 or C:\Program Files (x86)\iuclid5
- Delete the directory: %homepath%\*your username*\.iuclid5. (E.g. on Windows XP it is C:\documents and settings\*your username*\.iuclid5)
- Delete the IUCLID5 desktop icon
The uninstallation of the software is now complete.
What is the compatibility between versions of IUCLID 5 and Java?
The first version to be compatible with Java 7 is IUCLID 5.4.1. IUCLID 5.4.1 and 5.5.0 work with both Java 6 and 7. For versions of IUCLID prior to 5.4.1, only Java 6 works
| 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 |
Which version of Java should I use with IUCLID 5.4.1 or 5.5.0?
IUCLID 5.4.1 and IUCLID 5.5.0 work with both Java 6 and Java 7, but Oracle, the vendor of Java, recommends the use of Java 7 where possible. Free security updates for Java 6 are soon to be discontinued. For more information, see the Oracle website.
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
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:
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.
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?
Although the IUCLID 5.4.1 or IUCLID 5.5.0 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.
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:
- Click on the Start button at the bottom left of the Windows Desktop.
- Enter the text “cmd” into the window at the bottom left of the Start menu, and then press the Enter key.
- A command prompt window should open, like the one shown in the screenshot below.
- Enter the text “java –version” and then press the Enter key.
- The version of java is shown, as in the example screenshot below.
- If an error is shown, either java is not installed, or it needs to be re-installed.
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."
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?"
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.
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?
With Tomcat 5.5.26 HTTP 500 error message is displayed in the browser.
After having successfully installed the distributed version of IUCLID5 with Tomcat 5.2.26 (or later), the HTTP 500 error message is displayed in the browser, followed by details of the error.
Please find here the explanation and how to fix the problem.
‘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:
- 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 - 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.
- 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.
Known Issues- IUCLID application
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:
- Open the user management page.
- Click on the login name of the user.
- Un-check the box Suspended.
- Set the password.
- If required, check the box Expire password upon next login. This is not obligatory.
- Exit the user management page by clicking on the home icon.
- Click Save in the dialogue, and OK for the warning message.
- You can now act on another account, if required.
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.
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
Why can I not re-create the index with the Query plug-in version 5.3.0?
This bug has been fixed in the Query plug-in version 5.3.1 which was released on 20 May 2011
Users have reported the following issue:‘After having installed the Query plug-in (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 plug-in, 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 plug-in version 5.3.1.
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-plug-in 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-plug-in 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:
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.
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".
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.
Known Issues- IUCLID plug ins
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
There is a known incorrect behaviour of the dissemination plug-in 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. ECHA is currently working on a solution to this issue. In the meantime, the possibility to download the dissemination plug-in for IUCLID 5.5 has been removed from the website.
TCC plug in / version 5.4.0
I get the following BR200 failure when running the TCC plug-in 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 plug-in which was released on 17 July 2012
There is a known incorrect BR200 failure in the TCC plug-in 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.
CSR plug-in / version 5.4.0
Using the CSR plug-in 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.
When I try to synchronize the uses in the CSR plug-in, 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 plug-in, when synchronising the "uses" of the Chesar assessment file with the substance dataset in IUCLID.
This can be caused by:
- One of the documents belonging to IUCLID sections 1 to 3 being open in "edit mode". If this is the case, you need to set the open section to "read only".
- The length of one or more "use name" field defined in Chesar is greater than 255 characters. To solve the problem, go to Chesar box 2 of the substance assessed and check the size of the longest "use names" appearing in the life cycle tree. If one or more is exceeding 255 characters, then you need to reduce it (currently Chesar can accommodate up to 4000 characters in this particular field). Once shortened, you will need to re-create the zip file in box 4 to allow the data to be synchronised with IUCLID 5. This problem will be solved in the next Chesar release.
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 the question No 15 under 'Technical aspects' : 'UUID synchronisation between REACH-IT and IUCLID 5', 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.
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 end 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 ensure that you use a IUCLID User Account for the Legal Entity which corresponds with the submitting Legal Entity in REACH-IT. This Legal Entity is visible at the bottom of 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
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 plug-in 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 plug-in 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.
How can I ensure that I run the latest version of TCC plug-in on my substance dataset or dossier?
We have recently found out that users who already have the TCC plug-in installed, and upgrade to the latest version, may encounter the following:
At step 1 of the TCC wizard, the status appears as “Current plug-in is up to date”
However, at step 3, the ‘Detailed version information’ of the TCC plug-in, 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.plug-in.tccvalidate.ui.zip
file into the folder <iuclid5-folder>\plug-ins\client (for the standalone version of IUCLID 5) or into the folder <iuclid5-webapp-folder>\i5clientplug-ins\remoteplug-ins (for the distributed version of IUCLID 5),
they forget to also copy the latest version of the eu.echa.iuclid.server.plug-in.tccvalidate.zip file into the folder <iuclid5-folder>\plug-ins\server (for the standalone version of IUCLID 5)
or <iuclid5-webapp-folder>\WEB-INF\classes\plug-ins
(for the distributed version of IUCLID 5). Consequently, the
installation of the TCC plug-in is incomplete, as both of the files are
not of the latest version.</iuclid5-webapp-folder></iuclid5-folder></iuclid5-webapp-folder></iuclid5-folder>
Ensure you carefully read the TCC plug-in 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 plug-in. The ‘detailed version information’ is always specified in the ‘Release notes’ text file of each TCC plug-in.
Note: Remember to always clear the cache after an upgrade. The cache stored by an old version of the IUCLID 5 plug-in 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?
When I run the TCC plug-in on my dossier,
several Business Rules failures (BR failure) or Technical Completeness
check failures (TCC failure) are detected. How can I correct them?
The TCC plug-in 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 TCC plug-in 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 TCC plug-in,
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)
Right-click the link and choose 'Save Link As...' to save the file.Download the video
An overview of the steps required to ensure that a dossier passes the Business Rules can be found in the Data Submission Manual 4: How to pass Business Rule Verification (‘Enforce Rules’)
Questions related to Classification & Labelling Notification
How can I run the TCC tool for a Classification and Labelling (C & L) notification?
The TCC tool 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 TCC tool on the dossier.
- Instructions on how to create the substance dataset for a C&L notification can be found at 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 at Chapter 6 of the Data Submission Manual Part 12- How to Prepare and Submit a Classification and Labelling Notification using IUCLID
- To run the TCC tool on the created C&L notification dossier, right click on the dossier and select ‘Run TCC’.
