cdr check returns sql -201 error
Posted in 2015
When I execute the cdr check commamd I get a -201 (SQL Syntax error) returned.
This is so weird because I have many replicates on this server and database
that work normally. I tried deleting and re-defining the replicate but it
didn't make any difference. Any ideas?
I've included my commands below; all seems to work normally until I run the
cdr check command
$uname -a
Linux psdb05spr.state.ut.us 2.6.32-431.23.3.el6.x86_64 #1 SMP Wed Jul 16
06:12:23 EDT 2014 x86_64 x86_64 x86_64 GNU/Linux
$onstat -
IBM Informix Dynamic Server Version 12.10.FC4 -- On-Line -- Up 1 days 13:32:16
-- 6550832 Kbytes
$cdr define repl -M g_dld05sl -C timestamp -S tran --ats --ris
driver_license_driver_review_note
"driver_license@g_dld05sl:informix.driver_review_note" "select * from
driver_review_note" "driver_license@g_dld10rf:informix.driver_review_note""select * from driver_review_note"
$cdr list repl driver_license_driver_review_note
DEFINED REPLICATES ATTRIBUTES
------------------------------
REPLICATE: driver_license_driver_review_note
STATE: Active ON:g_dld05sl
CONFLICT: Timestamp
FREQUENCY: immediate
QUEUE SIZE: 0
PARTICIPANT: driver_license:informix.driver_review_note
OPTIONS: transaction,ris,ats,fullrow
REPLID: 3407943 / 0x340047
REPLMODE: PRIMARY ON:g_dld05sl
APPLY-AS: INFORMIX ON:g_dld05sl
REPLTYPE: Master
$cdr list repl brief driver_license_driver_review_note
REPLICATE TABLE SELECT
----------------------------------------------------------------------------
driver_license_driver_review_note
driver_license@g_dld05sl:informix.driver_review_note select t.idx,
t.driver_review_idx, t.note_text, t.note_date, t.insert_datetime,
t.insert_uid, t.insert_agency, t.modify_datetime, t.modify_uid,
t.modify_agency, t.ifx_insert_checksum, t.ifx_row_version from
driver_review_note t
driver_license_driver_review_note
driver_license@g_dld10rf:informix.driver_review_note select t.idx,
t.driver_review_idx, t.note_text, t.note_date, t.insert_datetime,
t.insert_uid, t.insert_agency, t.modify_datetime, t.modify_uid,
t.modify_agency, t.ifx_insert_checksum, t.ifx_row_version from
driver_review_note t
$cdr check repl -v -m g_dld05sl -r driver_license_driver_review_note g_dld10rf
Feb 17 2015 16:27:40 ------ Table scan for driver_license_driver_review_note
start --------
Error returned from createStatement: prepare recheck_1 from select idx as idx
, ifx_checksum(t.idx,
ifx_checksum(t.driver_review_idx,
ifx_checksum(t.note_text::lvarchar,
ifx_checksum(t.note_date,
ifx_checksum(t.insert_datetime,
ifx_checksum(t.insert_uid::lvarchar,
ifx_checksum(t.insert_agency::lvarchar,
ifx_checksum(t.modify_datetime,
ifx_checksum(t.modify_uid::lvarchar,
ifx_checksum(t.modify_agency::lvarchar,NULL)))))))))) as ifx_checksum_1,
from driver_license@g_dld05sl:"informix".driver_review_note t where idx = ?
SQLCODE -201 ISAM 0
Error Details:
201: A syntax error has occurred.
Current Connection:conn2, Database:driver_license@g_dld05sl
command failed -- SQL failure (195)