IDDI Fails to Generate ExportDB Archive When an Offlinedb Folder Previously Exists

(Doc ID 1347813.1)

Last updated on JUNE 29, 2016

Applies to:

Oracle Retail Point-of-Service - Version 13.0.1 and later
Information in this document applies to any platform.
Checked for currency on Jan 27th 2015.

Symptoms

In Oracle Retail Point of Service (ORPOS), we find that IDDI (Intra-store Data Distribution Infrastructure)  fails to generate the exportdb archive when an exportdb folder previously exists.  The following error is seen in the orpos.log on the server.


ERROR 2011-06-03 01:16:38,203 201282
(InitialProducerThread:com.extendyourstore.foundation.iddi.AbstractDataSetProducer):

[oracle.retail.stores.domain.iddi.OfflineDBProducer.generateDatasetFiles(OfflineDBProducer.java:129)]
Exception while generating the source derby database in
AbstractDataSetProducer.generateDatasetFiles()


java.lang.NullPointerException
at
oracle.retail.stores.iddi.IDDIDerbyWriter.importTable(IDDIDerbyWriter.java:222)
at
oracle.retail.stores.domain.iddi.OfflineDBProducer.generateDatasetFiles(OfflineDBProducer.java:103)
at
com.extendyourstore.foundation.iddi.AbstractDataSetProducer.generateData(AbstractDataSetProducer.java:182)
at
com.extendyourstore.foundation.iddi.DataSetService.generateDataSet(DataSetService.java:185)
at
com.extendyourstore.foundation.iddi.InitialProducerThread.run(InitialProducerThread.java:92)
at java.lang.Thread.run(Thread.java:801)


Steps to Reproduce :

Prerequisites:

1. $store_home\pos\bin\IDDI\EXPORT_DB\offlinedb already exists
2. Edit $store_home/pos/config/context/ServiceContext.xml file as follows:

<bean id="service_DataSetService"
class="com.extendyourstore.foundation.iddi.DataSetService" singleton="true">
<property name="producers">
<map>
<entry key-ref="service_config_EMP_KEY"
value-ref="service_EmployeeProducer"/>
<entry key-ref="service_config_ITM_KEY"
value-ref="service_ItemProducer"/>
<entry key-ref="service_config_PRC_KEY"
value-ref="service_AdvancedPricingProducer"/>
<entry key-ref="service_config_TAX_KEY"
value-ref="service_TaxProducer"/>
<entry key-ref="service_config_CUR_KEY"
value-ref="service_CurrencyProducer"/>
<entry key-ref="service_config_MER_KEY"
value-ref="service_MerchandiseProducer"/>
<entry key-ref="service_config_STORE_KEY"
value-ref="service_StoreInfoProducer"/>
<entry key-ref="service_config_SHP_MTH_KEY"
value-ref="service_ShippigMethodProducer"/>
<entry key-ref="service_config_DISCOUNT_KEY"
value-ref="service_DiscountProducer"/>
<entry key-ref="service_config_RSN_CODE_KEY"
value-ref="service_ReasonCodeProducer"/>
<entry key-ref="service_config_OFFLINEDB_KEY"
value-ref="service_OfflineDBProducer"/>
</map>
</property>
<property name="generateAtStartup">
<list>
<ref local="service_config_OFFLINEDB_KEY"/>
</list>
</property>
</bean>

1. Start the ORPOS store server
2. Observe exportdb zip file is not created

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms