My Oracle Support Banner

BDI Transmitter CLI Tool:Exception From ReceiverUrl Receiver Status Failed (Doc ID 2758009.1)

Last updated on MARCH 15, 2021

Applies to:

Oracle Retail Enterprise Inventory Cloud Service - Version 19.1 and later
Oracle 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.