Page 1 of 1

Error while comparing data

Posted: Tue 29 May 2018 09:40
by orcodb
Hello guys!

I've been using the evaluation trial to compare and synchronize data on a deprecated DB we have, to store it in a new machine.

The program itself runs really well, but for some reason, when the table is too big, the server stops, always in the same spot (when it reaches 2.4 million objects approximately, it gives an error, see screenshots).


It translates to: "An attempt was made to move the file pointer before the beginning of the file." The error doesn't say much to be fair, but neither in Output nor the db servers itself, leaves any other message.

We've changed all the timeout values, max packets allowed, maximum size of each packet... But no success.

dbforge version is 7.4.201 and we are using the Standard Version (evaluation).

Let me know if you need further info, I'll provide it. Hopefully you can give us some more insight as we have no clue what could be happening.

Thanks in advance

Re: Error while comparing data

Posted: Wed 30 May 2018 09:51
by alexa
We will investigate this issue and will answer you as soon as possible.

Re: Error while comparing data

Posted: Wed 30 May 2018 15:43
by alexa
Could you please provide us the versions of the Source and Target servers and perform the following:
1. Select 'Tools -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.

Also, if possible, please try to determine the object that caused the error (it should be mentioned at the end of the log file) and provide us its CREATE definitions for both Source and Target.

You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

Re: Error while comparing data

Posted: Thu 31 May 2018 09:53
by orcodb
Hi alexa!

Thanks for reaching out.

I uninstalled the standard version yesterday, and today I saw your comment so I installed the enterprise edition (evaluation still). Now it suddenly works?! It doesn't crash at 2.4 million objects, it just goes without errors!

Is there any limitation on the Standard version for some reason?

Thanks for your help! :)

Re: Error while comparing data

Posted: Thu 31 May 2018 13:44
by alexa
There is no limitation. it's limited only by the amount of features included ... tions.html