BDI Transmitter CLI Tool:Exception From ReceiverUrl Receiver Status Failed
(Doc ID 2758009.1)
Last updated on APRIL 25, 2022
Applies to:
Oracle Retail Enterprise Inventory Cloud Service - Version 19.1 and laterOracle Retail Integration Cloud Service - Version 19.1 and later
Information in this document applies to any platform.
Symptoms
When attempting to integrate from Retail Integration Cloud Service (RICS) to EICS-BDI for external price via BDI Transmitter CLI, the following error occurs in the bdi-server.out log.
ERROR
-----------------------
Using SQL(merge into EXT_PRICE_IN using dual on (bdi_seq_id=? and bdi_app_name=?) when matched then update set BDI_DATASET_TYPE=?,BDI_DATASET_ACTION=?,ITEM_ID=?,STORE_ID=?,EFFECTIVE_DATE=?,END_DATE=?,PRICE_TYPE=?,PROMOTION_NAME=?,SELLING_UNIT_RETAIL=?,SELLING_UNIT_RETAIL_CURRENCY=?,SELLING_UOM=?,MULTI_UNITS=?,MULTI_UNIT_RETAIL=?,MULTI_UNIT_RETAIL_CURRENCY=?,MULTI_UNIT_SELLING_UOM=?,CREATE_DATETIME=?,REC_ID=?,RETAIL_CHANGE_IND=?,MULTI_UNIT_IMPACT=?,PRICE_EVENT_ID=? when not matched then insert (BDI_SEQ_ID,BDI_APP_NAME,BDI_DATASET_TYPE,BDI_DATASET_ACTION,ITEM_ID,STORE_ID,EFFECTIVE_DATE,END_DATE,PRICE_TYPE,PROMOTION_NAME,SELLING_UNIT_RETAIL,SELLING_UNIT_RETAIL_CURRENCY,SELLING_UOM,MULTI_UNITS,MULTI_UNIT_RETAIL,MULTI_UNIT_RETAIL_CURRENCY,MULTI_UNIT_SELLING_UOM,CREATE_DATETIME,REC_ID,RETAIL_CHANGE_IND,MULTI_UNIT_IMPACT,PRICE_EVENT_ID) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)) to upload data for interface(ExtPrice_Tx.Ext_Price).
Error in writeItems for items([[1614789819427, EXT, FULL, CREATE, 100637113, 5000, 2018-07-03T00:00:00, , 202, , 49.99, USD, EA, , , , , 2018-10-12 12:00:00.000000000]]) and INTERFACE_NAME(ExtPrice_Tx.Ext_Price).
java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
Steps to Reproduce:
1. Run ./bdi-file-transmitter.sh -m ExtPrice_Tx.
Changes
The CLI tool that applies to your RICS version needs to be downloaded from My Oracle Support.
For example for 19.1.x, <Patch 32522004> - UPLOAD CLIENT CONNECTOR FOR ORACLE RETAIL INTEGRATION CLOUD SERVICE 19.1.002.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |