Loader Error 1.8.1[Solved]

Submitted by Ben_Charlton on Tue, 29/03/2016 - 03:22

General developer's discussion

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

Re: Loader Error 1.8.1

Submitted by Ben_Charlton on Tue, 29/03/2016 - 05:19.

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

Submitted by tanderson on Tue, 29/03/2016 - 12:20.

Are there any errors logged?

You can get more information by:

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

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

Submitted by Ben_Charlton on Tue, 29/03/2016 - 22:53.

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

Submitted by tanderson on Tue, 29/03/2016 - 23:59.

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

Re: Loader Error 1.8.1

Submitted by Ben_Charlton on Wed, 30/03/2016 - 00:59.

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

Submitted by tanderson on Wed, 30/03/2016 - 08:59.

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