Error upgrading from ofbiz-09.04 to 10.04

[Varun Bhansaly]

I have been facing issues  in installing seed data while trying to upgrade
from ofbiz release09.04@978897 to release10.04@1137445

The error come up when system executes
applications/accounting/data/AccountingTypeData.xml

and especially while executing the seed snippet,

   <PaymentGatewayPayflowPro paymentGatewayConfigId="PAYFLOWPRO_CONFIG"
certsPath="${sys:getProperty('ofbiz.home')}/applications/accounting/pfcerts"
hostAddress="pilot-payflowpro.paypal.com" hostPort="443" timeout="80"
proxyAddress="" proxyPort="80" proxyLogon="" proxyPassword=""
        vendor="[Vendor]" userId="[PayFlow UserID]" pwd="[PayFlow
Password]" partner="[PayFlow Partner]" checkAvs="Y" checkCvv2="Y"
preAuth="Y" enableTransmit="true"
logFileName="${sys:getProperty('ofbiz.home')}/runtime/logs/payflow_java.log"
loggingLevel="6" maxLogFileSize="1000000" stackTraceOn="N"
returnUrl="[Express Checkout Return URL]" cancelReturnUrl="[Express
Checkout Cancel Return URL]" redirectUrl="[Express Checkout Customer
Redirect URL]"/>


Following exception is thrown
Exception: org.ofbiz.base.util.GeneralRuntimeException
Message: null (Odd number of characters.)
---- stack trace
---------------------------------------------------------------
org.ofbiz.base.util.GeneralRuntimeException: null (Odd number of
characters.)
org.ofbiz.base.util.StringUtil.fromHexString(StringUtil.java:430)
org.ofbiz.entity.util.EntityCrypto.decrypt(EntityCrypto.java:86)
org.ofbiz.entity.GenericDelegator.decryptFields(GenericDelegator.java:3116)
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1409)
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:286)
org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:423)
javolution.xml.sax.XMLReaderImpl.parseAll(XMLReaderImpl.java:337)
javolution.xml.sax.XMLReaderImpl.parse(XMLReaderImpl.java:100)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:262)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:222)
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:214)
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:389)
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
org.ofbiz.base.start.Start.startStartLoaders(Start.java:273)
org.ofbiz.base.start.Start.startServer(Start.java:323)
org.ofbiz.base.start.Start.start(Start.java:327)
org.ofbiz.base.start.Start.main(Start.java:412)
org.apache.commons.codec.DecoderException: Odd number of characters.
org.apache.commons.codec.binary.Hex.decodeHex(Hex.java:69)
org.ofbiz.base.util.StringUtil.fromHexString(StringUtil.java:427)
org.ofbiz.entity.util.EntityCrypto.decrypt(EntityCrypto.java:86)
org.ofbiz.entity.GenericDelegator.decryptFields(GenericDelegator.java:3116)
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1409)
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:286)
org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:423)
javolution.xml.sax.XMLReaderImpl.parseAll(XMLReaderImpl.java:337)
javolution.xml.sax.XMLReaderImpl.parse(XMLReaderImpl.java:100)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:262)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:222)
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:214)
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:389)
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
org.ofbiz.base.start.Start.startStartLoaders(Start.java:273)
org.ofbiz.base.start.Start.startServer(Start.java:323)
org.ofbiz.base.start.Start.start(Start.java:327)
org.ofbiz.base.start.Start.main(Start.java:412)


As per my observations, system is *unable to decrypt* text "[PayFlow
Password]"

If anyone has faced this issue before, please do share.

--
Regards,
Varun Bhansaly

[Varun Bhansaly]

Was able to upgrade after commenting out snippet <PaymentGatewayConfig*
in AccountingTypeData.xml.

On Wed, May 16, 2012 at 10:56 PM, varun bhansaly <[hidden email]>wrote:

> I have been facing issues  in installing seed data while trying to upgrade
> from ofbiz release09.04@978897 to release10.04@1137445
>
> The error come up when system executes
> applications/accounting/data/AccountingTypeData.xml
>
> and especially while executing the seed snippet,
>
>    <PaymentGatewayPayflowPro paymentGatewayConfigId="PAYFLOWPRO_CONFIG"
> certsPath="${sys:getProperty('ofbiz.home')}/applications/accounting/pfcerts"
> hostAddress="pilot-payflowpro.paypal.com" hostPort="443" timeout="80"
> proxyAddress="" proxyPort="80" proxyLogon="" proxyPassword=""
>         vendor="[Vendor]" userId="[PayFlow UserID]" pwd="[PayFlow
> Password]" partner="[PayFlow Partner]" checkAvs="Y" checkCvv2="Y"
> preAuth="Y" enableTransmit="true"
> logFileName="${sys:getProperty('ofbiz.home')}/runtime/logs/payflow_java.log"
> loggingLevel="6" maxLogFileSize="1000000" stackTraceOn="N"
> returnUrl="[Express Checkout Return URL]" cancelReturnUrl="[Express
> Checkout Cancel Return URL]" redirectUrl="[Express Checkout Customer
> Redirect URL]"/>
>
>
> Following exception is thrown
> Exception: org.ofbiz.base.util.GeneralRuntimeException
> Message: null (Odd number of characters.)
> ---- stack trace
> ---------------------------------------------------------------
> org.ofbiz.base.util.GeneralRuntimeException: null (Odd number of
> characters.)
> org.ofbiz.base.util.StringUtil.fromHexString(StringUtil.java:430)
> org.ofbiz.entity.util.EntityCrypto.decrypt(EntityCrypto.java:86)
> org.ofbiz.entity.GenericDelegator.decryptFields(GenericDelegator.java:3116)
> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1409)
> org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:286)
> org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:423)
> javolution.xml.sax.XMLReaderImpl.parseAll(XMLReaderImpl.java:337)
> javolution.xml.sax.XMLReaderImpl.parse(XMLReaderImpl.java:100)
> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:262)
> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:222)
> org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:214)
>
> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:389)
> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
> org.ofbiz.base.start.Start.startStartLoaders(Start.java:273)
> org.ofbiz.base.start.Start.startServer(Start.java:323)
> org.ofbiz.base.start.Start.start(Start.java:327)
> org.ofbiz.base.start.Start.main(Start.java:412)
> org.apache.commons.codec.DecoderException: Odd number of characters.
> org.apache.commons.codec.binary.Hex.decodeHex(Hex.java:69)
> org.ofbiz.base.util.StringUtil.fromHexString(StringUtil.java:427)
> org.ofbiz.entity.util.EntityCrypto.decrypt(EntityCrypto.java:86)
> org.ofbiz.entity.GenericDelegator.decryptFields(GenericDelegator.java:3116)
> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1409)
> org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:286)
> org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:423)
> javolution.xml.sax.XMLReaderImpl.parseAll(XMLReaderImpl.java:337)
> javolution.xml.sax.XMLReaderImpl.parse(XMLReaderImpl.java:100)
> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:262)
> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:222)
> org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:214)
>
> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:389)
> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
> org.ofbiz.base.start.Start.startStartLoaders(Start.java:273)
> org.ofbiz.base.start.Start.startServer(Start.java:323)
> org.ofbiz.base.start.Start.start(Start.java:327)
> org.ofbiz.base.start.Start.main(Start.java:412)
>
>
> As per my observations, system is *unable to decrypt* text "[PayFlow
> Password]"
>
> If anyone has faced this issue before, please do share.
>
> --
> Regards,
> Varun Bhansaly
>
>

--
Regards,
Varun Bhansaly