Loader Error 1.8.1[Solved]

Hit an odd error using the Kettle Loader:

Failed to validate Description of Patient (Pet): Failed to get value

obviously I am not setting it as it is a derived value usually...

Loader looks like below.

Field name    Map to    Exclude null    Value    Remove default objects
Name    <party.patientpet>name    N        Y
Species    <party.patientpet>species    N        Y
Breed    <party.patientpet>breed    N        Y
DOB    <party.patientpet>dateOfBirth    N        Y
Desex    <party.patientpet>desexed    N        Y
DOB    <party.patientpet>createdDate    Y        Y
Date Of Death    <party.patientpet>deceasedDate    Y        Y
Deceased    <party.patientpet>deceased    Y        Y
active    <party.patientpet>active    Y        Y
Colour    <party.patientpet>colour    Y        Y
Sex    <party.patientpet>sex    N        Y
Tag    <party.patientpet>identities[0]<entityIdentity.alias>alias    Y        Y
Microchip    <party.patientpet>identities[1]<entityIdentity.microchip>microchip    Y        Y

Using 1.8.1 release to do this 

 

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Loader Error 1.8.1

Disabling the derived value corrects the error and allows a load to occur...you can reenable it afterward  and it updates

Regards
 
Ben 
OpenVPMS Installer and Helper 
Ph: +61423044823 
Email: info[at]charltonit.com[dot]au

Re: Loader Error 1.8.1

Are there any errors logged?

You can get more information by:

  1. creating a log4j.properties in the directory that spoon.bat/spoon is run in:
    # Global logging configuration
    log4j.rootLogger=info, stdout, fileout
    
    # Console output
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
    log4j.appender.stdout.layout.conversionPattern=[%p,%c{1},%t] %m%n
    
    # Rolling log file output
    log4j.appender.fileout=org.apache.log4j.RollingFileAppender
    log4j.appender.fileout.File=openvpms.log
    log4j.appender.fileout.MaxFileSize=100000KB
    log4j.appender.fileout.MaxBackupIndex=1
    log4j.appender.fileout.layout=org.apache.log4j.PatternLayout
    log4j.appender.fileout.layout.conversionPattern=%d{DATE} %5p %c{1},%t:%L - %m%n
    
    
  2. adding the following to the end of the OPT= line in spoon.bat/spoon.sh:
 -Dlog4j.configuration=file:./log4j.properties

Re: Loader Error 1.8.1

29 Mar 2016 21:53:53,988  INFO UpdateTimestampsCache,Thread-11:57 - starting update timestamps cache at region: org.hibernate.cache.UpdateTimestampsCache
29 Mar 2016 21:53:53,990  INFO StandardQueryCache,Thread-11:75 - starting query cache at region: org.hibernate.cache.StandardQueryCache
29 Mar 2016 21:53:54,003  INFO HibernateTransactionManager,Thread-11:415 - Using DataSource [org.apache.commons.dbcp.BasicDataSource@46d36e16] of Hibernate SessionFactory for HibernateTransactionManager
29 Mar 2016 21:53:54,353  INFO UpdateChecker,net.sf.ehcache.CacheManager@5fc12abd:97 - New update(s) found: 2.4.7 [http://www.terracotta.org/confluence/display/release/Release+Notes+Ehcache+Core+2.4]
29 Mar 2016 21:53:56,549  WARN ArchetypeDescriptorCacheDB,Thread-11:166 - Failed to load descriptor entityLink.customerLocation.1.0 b/c of error  [java.lang.ClassNotFoundException: org.openvpms.component.business.domain.im.common.EntityLink].
29 Mar 2016 21:53:56,549  WARN ArchetypeDescriptorCacheDB,Thread-11:166 - Failed to load descriptor entityLink.HL7PharmacyGroupPharmacy.1.0 b/c of error  [java.lang.ClassNotFoundException: org.openvpms.component.business.domain.im.common.EntityLink].
29 Mar 2016 21:53:56,549  WARN ArchetypeDescriptorCacheDB,Thread-11:166 - Failed to load descriptor entityLink.HL7ServiceLocation.1.0 b/c of error  [java.lang.ClassNotFoundException: org.openvpms.component.business.domain.im.common.EntityLink].
29 Mar 2016 21:53:56,550  WARN ArchetypeDescriptorCacheDB,Thread-11:166 - Failed to load descriptor entityLink.HL7ServiceReceiver.1.0 b/c of error  [java.lang.ClassNotFoundException: org.openvpms.component.business.domain.im.common.EntityLink].
29 Mar 2016 21:53:56,550  WARN ArchetypeDescriptorCacheDB,Thread-11:166 - Failed to load descriptor entityLink.HL7ServiceSender.1.0 b/c of error  [java.lang.ClassNotFoundException: org.openvpms.component.business.domain.im.common.EntityLink].
29 Mar 2016 21:53:56,550  WARN ArchetypeDescriptorCacheDB,Thread-11:166 - Failed to load descriptor entityLink.HL7ServiceUser.1.0 b/c of error  [java.lang.ClassNotFoundException: org.openvpms.component.business.domain.im.common.EntityLink].
29 Mar 2016 21:53:56,550  WARN ArchetypeDescriptorCacheDB,Thread-11:166 - Failed to load descriptor entityLink.practiceServiceUser.1.0 b/c of error  [java.lang.ClassNotFoundException: org.openvpms.component.business.domain.im.common.EntityLink].
29 Mar 2016 21:53:56,551  WARN ArchetypeDescriptorCacheDB,Thread-11:166 - Failed to load descriptor entityLink.batchLocation.1.0 b/c of error  [java.lang.ClassNotFoundException: org.openvpms.component.business.domain.im.common.EntityLink].
29 Mar 2016 21:53:56,551  WARN ArchetypeDescriptorCacheDB,Thread-11:166 - Failed to load descriptor entityLink.batchManufacturer.1.0 b/c of error  [java.lang.ClassNotFoundException: org.openvpms.component.business.domain.im.common.EntityLink].
29 Mar 2016 21:53:56,551  WARN ArchetypeDescriptorCacheDB,Thread-11:166 - Failed to load descriptor entityLink.batchProduct.1.0 b/c of error  [java.lang.ClassNotFoundException: org.openvpms.component.business.domain.im.common.EntityLink].
29 Mar 2016 21:53:56,551  WARN ArchetypeDescriptorCacheDB,Thread-11:166 - Failed to load descriptor entityLink.locationProductType.1.0 b/c of error  [java.lang.ClassNotFoundException: org.openvpms.component.business.domain.im.common.EntityLink].
29 Mar 2016 21:53:56,552  WARN ArchetypeDescriptorCacheDB,Thread-11:166 - Failed to load descriptor entityLink.productIncludes.1.0 b/c of error  [java.lang.ClassNotFoundException: org.openvpms.component.business.domain.im.common.EntityLink].
29 Mar 2016 21:53:56,552  WARN ArchetypeDescriptorCacheDB,Thread-11:166 - Failed to load descriptor entityLink.productPharmacy.1.0 b/c of error  [java.lang.ClassNotFoundException: org.openvpms.component.business.domain.im.common.EntityLink].

 

Using loader 1.8.1

Regards
 
Ben 
OpenVPMS Installer and Helper 
Ph: +61423044823 
Email: info[at]charltonit.com[dot]au

Re: Loader Error 1.8.1

Do you have multiple versions of the openvpms-framework jar in the plugins/steps/OpenVPMSLoader/ directory?

Re: Loader Error 1.8.1

No...I did check that

 

Regards
 
Ben 
OpenVPMS Installer and Helper 
Ph: +61423044823 
Email: info[at]charltonit.com[dot]au

Re: Loader Error 1.8.1

Check for any openvpms-framework jars in any directory in the kettle tree. There should only be the one in the plugins/steps/OpenVPMSLoader/ directory.

> cd <PDI HOME>

> find . -name 'openvpms-framework*'

Re: Loader Error 1.8.1

Solved this one ...you were right I found 1.5 jars in a random directory that was getting dragged into the classpath..

Regards
 
Ben 
OpenVPMS Installer and Helper 
Ph: +61423044823 
Email: info[at]charltonit.com[dot]au

Re: Loader Error 1.8.1

Solved this one ...you were right I found 1.5 jars in a random directory that was getting dragged into the classpath..

Regards
 
Ben 
OpenVPMS Installer and Helper 
Ph: +61423044823 
Email: info[at]charltonit.com[dot]au
Syndicate content