View Issue Details

IDProjectCategoryView StatusLast Update
0002950SymmetricDSBugpublic2019-08-26 08:45
ReportermonoranjangAssigned Toelong 
Priorityurgent 
Status closedResolutionopen 
Product Version3.8.9 
Target VersionFixed in Version 
Summary0002950: Failed to execute EXTRACT for node 1 and channel default StackTraceKey [SqlException:1239135777]
DescriptionI have a table with two CLOB datatype. Here is the configuration:
------------Channel Configuration----------
Channel Id*: MA_CREDENTIALS
Processing Order*: 1
Batch Algorithm*: Default
Max. Batch Size*: 1000
Max. Batch to Send*: 60
Max. Data to Route*: 100000
Max. KB/s*: 0
Data Loader Type*: Default
Queue Name*: default
Enabled: Checked
Reload Channel: Unchecked(Tried with checked also, same error)
File Sync Channel: Unchecked
Use Old Data to Route: Checked(Tried with checked also, same error)
Use Row Data to Route: Checked(Tried with checked also, same error)
Use Primary Key (PK) Data to Route: Checked(Tried with checked also, same error)
Tables Contain Big Lobs: Checked(Tried with checked also, same error)


------------------Trigger Configuration-------------
Trigger Id*: ms.ma_credentials
Source Catalog:
Source Schema: MS
Source Table*: MA_CREDENTIALS
Channel*: MA_CREDENTIALS
Sync on Insert: Checked
Sync on Update: Checked
Sync on Delete: Checked
Reload Channel Id*: reload
Sync on Insert Condition*: 1=1
Sync on Update Condition*: 1=1
Sync on Delete Condition*: 1=1
Custom Insert Trigger Text:
Custom Update Trigger Text:
Custom Delete Trigger Text:
Sync on Incoming: Unchecked
Stream Lobs: Checked
Capture Lobs: Checked
Capture Old Data: Checked
External Select: Checked
Excluded Column Names:
Included Column Names:
Sync Key Names:
Channel Expression:


---------------------Table Routing -----------------------
Trigger*: ms.ma_credentials
Router*: Server pushes for client MS
Initial Load Select:
Initial Load Delete
Initial Load Order*: 50
Initial Load Batch Count: 0
Enabled: Checked
Ping Back Enabled: Unchecked
Help


Steps To ReproduceCreate Channel, Trigger & Router for a table with clob datatype. Do initial load of the table with create table option
Additional Information2016-12-25 18:32:47,875 ERROR [server] [NodeCommunicationService] [server-extract-default-10] Failed to execute EXTRACT for node 1 and channel default StackTraceKey [SqlException:1239135777]

2016-12-25 18:32:49,711 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction

2016-12-25 18:32:51,224 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction

2016-12-25 18:32:52,738 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction

2016-12-25 18:32:54,228 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction

2016-12-25 18:32:54,865 INFO [server] [FileSyncExtractorService] [server-file_extract-default-6] Extracting batches for request 55. Starting at batch 1288. Ending at batch 1288

2016-12-25 18:32:55,404 INFO [server] [DataExtractorService] [server-extract-default-11] Extracting batches for request 55. Starting at batch 1288. Ending at batch 1288

2016-12-25 18:32:55,907 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction

2016-12-25 18:32:56,986 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction

2016-12-25 18:32:57,572 INFO [server] [FileSyncExtractorService] [server-file_extract-default-6] Done extracting 1 batches for request 55

2016-12-25 18:32:58,101 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction

2016-12-25 18:32:59,440 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is marked as ready but it has been deleted. Rescheduling it for extraction

2016-12-25 18:33:00,302 ERROR [server] [NodeCommunicationService] [server-extract-default-11] Failed to execute EXTRACT for node 1 and channel default StackTraceKey [SqlException:1239135777]

2016-12-25 18:33:01,831 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction

2016-12-25 18:33:03,028 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction

2016-12-25 18:33:04,708 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction

2016-12-25 18:33:05,945 INFO [server] [FileSyncExtractorService] [server-file_extract-default-7] Extracting batches for request 55. Starting at batch 1288. Ending at batch 1288

2016-12-25 18:33:06,291 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction

2016-12-25 18:33:06,485 INFO [server] [DataExtractorService] [server-extract-default-12] Extracting batches for request 55. Starting at batch 1288. Ending at batch 1288

2016-12-25 18:33:07,491 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction

2016-12-25 18:33:08,435 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction

2016-12-25 18:33:08,652 INFO [server] [FileSyncExtractorService] [server-file_extract-default-7] Done extracting 1 batches for request 55

2016-12-25 18:33:09,652 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is marked as ready but it has been deleted. Rescheduling it for extraction

2016-12-25 18:33:10,040 ERROR [server] [NodeCommunicationService] [server-extract-default-12] Failed to execute EXTRACT for node 1 and channel default StackTraceKey [SqlException:1239135777]

2016-12-25 18:33:12,624 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction

2016-12-25 18:33:15,124 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction

2016-12-25 18:33:17,631 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction

2016-12-25 18:33:18,173 INFO [server] [FileSyncExtractorService] [server-file_extract-default-8] Extracting batches for request 55. Starting at batch 1288. Ending at batch 1288

2016-12-25 18:33:18,714 INFO [server] [DataExtractorService] [server-extract-default-13] Extracting batches for request 55. Starting at batch 1288. Ending at batch 1288

2016-12-25 18:33:19,330 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction

2016-12-25 18:33:20,879 INFO [server] [FileSyncExtractorService] [server-file_extract-default-8] Done extracting 1 batches for request 55
2016-12-25 18:33:20,884 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction
Tagsextract

Activities

monoranjang

2016-12-27 01:13

reporter   ~0000944

Note: SymmetricDS Server Node(inside office premise under firewall) is connected with a schema SYMDBTEST. It fetches data from a schema called MS(office premise). Client node is in AWS connected to schema SYMDBTEST at AWS-RDS. Trying to push data to schema MS in AWS-RDS.

elong

2019-04-24 10:24

developer   ~0001427

The SqlException:1239135777 is an arbitrary abbreviation that points at the actual error, so it doesn't tell us what the extract error was. Can you get the first occurrence of the error in the log, along with the full stace trace, and post it here?

admin

2019-08-26 08:45

administrator   ~0001586

Auto closing all issues waiting for feedback after 4 months. We don't have enough information to take any action.

Issue History

Date Modified Username Field Change
2016-12-27 00:50 monoranjang New Issue
2016-12-27 01:13 monoranjang Note Added: 0000944
2017-01-11 12:17 chenson Project SymmetricDS Pro => SymmetricDS
2019-04-24 10:24 elong Assigned To => elong
2019-04-24 10:24 elong Status new => feedback
2019-04-24 10:24 elong Note Added: 0001427
2019-04-24 10:25 elong Tag Attached: extract
2019-08-26 08:45 admin Note Added: 0001586
2019-08-26 08:45 admin Status feedback => closed