ReplicaDB icon indicating copy to clipboard operation
ReplicaDB copied to clipboard

Complete data is not copied(total rows are around 4,50,000)

Open sandeepraghu opened this issue 1 year ago • 0 comments

it is copying around 1,50,000 rows and then stuck here shared below and after an hour or two it is saying connection reset.

(venv) sandeepraghuvanshi@Sandeeps-MacBook-Pro ReplicaDB % sudo docker run -v /Users/sandeepraghuvanshi/Desktop/replica/ReplicaDB/conf/mssql.conf:/home/replicadb/conf/replicadb.conf your_custom_image:latest 2024-03-13 05:04:38,322 INFO ReplicaDB:63 Running ReplicaDB version: 0.15.1 2024-03-13 05:04:38,324 INFO ReplicaDB:66 Setting verbose mode INFO 2024-03-13 05:04:38,379 INFO SqlManager:373 Truncating sink table with this command: TRUNCATE TABLE dbo.Job 2024-03-13 05:04:40,758 INFO ReplicaTask:35 Starting TaskId-0 2024-03-13 05:04:40,758 INFO ReplicaTask:35 Starting TaskId-1 2024-03-13 05:04:40,760 INFO ReplicaTask:35 Starting TaskId-2 2024-03-13 05:04:40,760 INFO ReplicaTask:35 Starting TaskId-3 2024-03-13 05:04:44,026 INFO SqlManager:128 TaskId-0: Executing SQL statement: SELECT * FROM dbo.Job_22022024 where ABS(CHECKSUM(%% physloc %%)) % 4 = ? 2024-03-13 05:04:44,058 INFO SqlManager:128 TaskId-1: Executing SQL statement: SELECT * FROM dbo.Job_22022024 where ABS(CHECKSUM(%% physloc %%)) % 4 = ? 2024-03-13 05:04:44,076 INFO SqlManager:128 TaskId-3: Executing SQL statement: SELECT * FROM dbo.Job_22022024 where ABS(CHECKSUM(%% physloc %%)) % 4 = ? 2024-03-13 05:04:44,081 INFO SqlManager:128 TaskId-2: Executing SQL statement: SELECT * FROM dbo.Job_22022024 where ABS(CHECKSUM(%% physloc %%)) % 4 = ? 2024-03-13 05:04:44,081 INFO SqlManager:148 TaskId-1: With args: 1, 2024-03-13 05:04:44,081 INFO SqlManager:148 TaskId-2: With args: 2, 2024-03-13 05:04:44,081 INFO SqlManager:148 TaskId-3: With args: 3, 2024-03-13 05:04:44,082 INFO SqlManager:148 TaskId-0: With args: 0, 2024-03-13 05:08:57,144 WARN ConnManager:188 Options source-columns and sink-columns are null, getting from Source ResultSetMetaData: Job,Sales_Rep,Customer,Ship_To,User_Values,Quote,Contact,Ship_Via,Terms,Tax_Code,Sales_Code,Top_Lvl_Job,Type,Order_Date,Status,Status_Date,Part_Number,Rev,Description,Ext_Description,Drawing,Build_To_Stock,Order_Quantity,Extra_Quantity,Pick_Quantity,Make_Quantity,Split_Quantity,Completed_Quantity,Shipped_Quantity,FG_Transfer_Qty,Returned_Quantity,In_Production_Quantity,Assembly_Level,Certs_Required,Time_And_Materials,Open_Operations,Scrap_Pct,Est_Scrap_Qty,Est_Rem_Hrs,Est_Total_Hrs,Est_Labor,Est_Material,Est_Service,Est_Labor_Burden,Est_Machine_Burden,Est_GA_Burden,Act_Revenue,Act_Scrap_Quantity,Act_Total_Hrs,Act_Labor,Act_Material,Act_Service,Act_Labor_Burden,Act_Machine_Burden,Act_GA_Burden,Priority,Unit_Price,Total_Price,Price_UofM,Currency_Conv_Rate,Trade_Currency,Fixed_Rate,Trade_Date,Commission_Pct,Customer_PO,Customer_PO_LN,Sched_End,Sched_Start,Quantity_Per,Profit_Pct,Labor_Markup_Pct,Mat_Markup_Pct,Serv_Markup_Pct,Labor_Burden_Markup_Pct,Machine_Burden_Markup_Pct,GA_Burden_Markup_Pct,Lead_Days,Profit_Markup,Prepaid_Amt,Split_To_Job,Note_Text,Comment,Last_Updated,Order_Unit,Price_Unit_Conv,Holder_ID,Source,Order_Taken_By,Plan_Modified,ObjectID,Released_Date,Prepaid_Tax_Amount,Prepaid_Trade_Amt,Last_Updated_By,CommissionIncluded 2024-03-13 05:08:57,531 INFO ReplicaTask:67 A total of 151617 rows processed by task 1

sandeepraghu avatar Mar 13 '24 05:03 sandeepraghu