Newbie with record mismatch issue

CloverDX Platform
1

Hello Folks,

I am just getting started with Clover and have inherited a system that is having an issue. This was working and just stopped one day.

I have included the log entry, grf and mnt files below.

TIA…

Mike

In the logs I get:

CloverETL data record coremetricsWeekly contains less fields than target JDBC record !

The graph file:

and the metadata:

[Clover] phase: 0 initialized successfully.
[WatchDog] Starting up all nodes in phase [0]
[WatchDog] INPUT1 … started
[WatchDog] OUTPUT1 … started
[WatchDog] Sucessfully started all nodes in phase!
[WatchDog] Execution of phase [0] successfully finished - elapsed time(sec): 1
---------------------** Start of tracking Log for phase [0] **-------------------
Time: 24/06/08 17:04:03
Node Status Port #Records
---------------------------------------------------------------------------------
INPUT1 OK
Out:0 1
OUTPUT1 FATAL_ERROR
In:0 1

2

Sorry bout that. Here is the fmt file:

<?xml version="1.0" encoding="UTF-8" ?>

and the grf:

<?xml version="1.0" encoding="UTF-8"?>

[/code]

3

Hi,
this looks like the structure of the database table has changed. Can you compare the structure of the table with the structure of the Clover metadata?

Jaro

4

Yes, I looked at that. The column names are identical. The types are the same also. I am pasting the DDL for the table.

CREATE TABLE “ODS_PRD”.“CRE_WEEKLY_COREMETRICS”
( “WEEK_NUMBER” NUMBER(*,0) NOT NULL ENABLE,
“UNIQUE_VISITORS” NUMBER(*,0) NOT NULL ENABLE,
“FIRST_TIME_VISITORS” NUMBER(*,0) NOT NULL ENABLE,
“REPEAT_VISITORS” NUMBER(*,0) NOT NULL ENABLE,
“VISITS” NUMBER(*,0) NOT NULL ENABLE,
“FIRST_TIME_VISITS_CONV” NUMBER(17,6) NOT NULL ENABLE,
“REPEAT_VISITS_CONV” NUMBER(17,6) NOT NULL ENABLE,
“REPEAT_BUYS_CONV” NUMBER(17,6) NOT NULL ENABLE,
“EMAIL_CONV” NUMBER(17,6) NOT NULL ENABLE,
“PAID_SEARCH_CONV” NUMBER(17,6) NOT NULL ENABLE,
“HOME_PAGE_NET_SALES” NUMBER(17,6) NOT NULL ENABLE,
“HOME_PAGE_ABANDON_RATE” NUMBER(17,6) NOT NULL ENABLE,
“SHOPPING_CART_ABANDON_RATE” NUMBER(17,6) NOT NULL ENABLE,
“PROD_VIEWS_PER_VISIT” NUMBER(22,6) NOT NULL ENABLE,
“TOP_ENTRY_PAGE_1” VARCHAR2(255 BYTE) NOT NULL ENABLE,
“TOP_ENTRY_PAGE_2” VARCHAR2(255 BYTE) NOT NULL ENABLE,
“TOP_ENTRY_PAGE_3” VARCHAR2(255 BYTE) NOT NULL ENABLE,
“TOP_EXIT_PAGE_1” VARCHAR2(255 BYTE) NOT NULL ENABLE,
“TOP_EXIT_PAGE_2” VARCHAR2(255 BYTE) NOT NULL ENABLE,
“TOP_EXIT_PAGE_3” VARCHAR2(255 BYTE) NOT NULL ENABLE
)