Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
sandeepraghu opened this issue Mar 13, 2024 · 0 comments
Open

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

sandeepraghu opened this issue Mar 13, 2024 · 0 comments

Comments

@sandeepraghu
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant