tag:blogger.com,1999:blog-423831008800861797.post4338347488924400077..comments2022-05-22T05:40:47.508-07:00Comments on Talkin' DAX: DIXF timeout issuesBradhttp://www.blogger.com/profile/05328248031071623888noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-423831008800861797.post-18634156602369228402017-01-13T10:40:15.023-08:002017-01-13T10:40:15.023-08:00Thanks for the response!
Without this setting 30K ...Thanks for the response!<br />Without this setting 30K records were added successfully but error came on after that.<br />Hopefully it will get fixed. <br />Anonymoushttps://www.blogger.com/profile/08352490872704431243noreply@blogger.comtag:blogger.com,1999:blog-423831008800861797.post-46199026664263637082017-01-13T09:54:07.795-08:002017-01-13T09:54:07.795-08:00Depends on what type of records. The values I set...Depends on what type of records. The values I set in the post were for around 300k records and it worked ok. I would push your time up even longer (Maybe 3 hours). <br /><br />You could also cut your file in half or thirds or fourths and do some testing. See how long each file goes.Bradhttps://www.blogger.com/profile/05328248031071623888noreply@blogger.comtag:blogger.com,1999:blog-423831008800861797.post-80515233850928440402017-01-13T07:29:50.437-08:002017-01-13T07:29:50.437-08:00I set send time out and receive timeout to 01:30:0...I set send time out and receive timeout to 01:30:00, but it still gave the same error. Can you tell me how much values should be given roughly for 50000 records?Anonymoushttps://www.blogger.com/profile/08352490872704431243noreply@blogger.comtag:blogger.com,1999:blog-423831008800861797.post-83636196117487581462015-09-30T12:03:54.195-07:002015-09-30T12:03:54.195-07:00I'm glad it was able to help!I'm glad it was able to help!Bradhttps://www.blogger.com/profile/05328248031071623888noreply@blogger.comtag:blogger.com,1999:blog-423831008800861797.post-31810767360421553432015-09-30T08:41:06.307-07:002015-09-30T08:41:06.307-07:00Thanks for publishing the tip, Brad. We received ...Thanks for publishing the tip, Brad. We received this message attempting to insert only 8000 customers into the staging table. The source SQL view was slow, however, with many scalar functions used.ian_schohttps://www.blogger.com/profile/13346032420070380865noreply@blogger.com