...
Find transactions that have been processed by the first half of the daemons ie are queued in the Mantiki Temporary tables for writing to the SQL Server Dream Extractor database but not reached a 'done' state - this may be due to errors.
| Code Block |
|---|
select 'process_extract_dream_shipment', id, extract_customer_number, extract_shipment_created_on as created_on, extract_shipment_reference_number, record_status, record_status_comment from process_extract_dream_shipment where record_status != 'done' UNION select 'process_extract_dream_credit', id, extract_customer_number, extract_refund_created_on as created_on, extract_credit_reference_number, record_status, record_status_comment from process_extract_dream_credit where record_status != 'done' UNION select 'process_extract_dream_wbpayment_customer', id, extract_customer_number, extract_created_on as created_on, extract_payment_reference_number, record_status, record_status_comment from process_extract_dream_wbpayment_customer where record_status != 'done' UNION select 'process_extract_dream_wbrefund_customer', id, extract_customer_number, extract_created_on as created_on, extract_payment_reference_number, record_status, record_status_comment from process_extract_dream_wbrefund_customer where record_status != 'done' UNION select 'process_extract_dream_account_adjustment', id, extract_customer_number, extract_date as created_on, extract_account_type, record_status, record_status_comment from process_extract_dream_account_adjustment where record_status != 'done' ORDER BY created_on DESC; |
If you find your error in the above and the record_status_comment mentions a JDBC connectivity issue, then what you have is explained below - but basically Mantiki's failed to talk to the Preston database. If you're within two or three days of the error happening then you can reset the record_status to NEW and the record will be found by the daemon and processed. Find the id in the temporary table and make a query to update the rows.
The SQL will look like this: update
the table (will be one of process_extract_dream_shipment or process_extract_dream_credit or process_extract_dream_wbpayment_customer or process_extract_dream_wbrefund_customer or process_extract_dream_account_adjustment)set record_status = 'NEW' where id in ( the id/s in the table );
...