cannot post when restored database from backup

vasilis6669

Hi,

I am using nav 2009. I have created a backup and when i restore it to a new server if there are unposted invoices i cannot post them. When i post a sales invoice then the program get stack and the cursor is running all the time. No message is shown.

If anyone has experienced this error please let mw know

Regards,
Vasilis

ara3n

try to compile all the object. Are you running on sql or classic?
Turn on the debugger and see what it is doing. Are there any mods in the db?
What version is the database in?

vasilis6669

I have compiled all the objects,

I am running on SQL server 2008 with navision 6.0

I receive no error message when is posting a sales invoice.

The program gets stack on the Posting Balance Line

How can i a avoid this case. The backup is useless if there are unposted entries.

Regards,
Vasilis

ara3n

What version of db do you have is it a Cronus db or you have modifications?

Have you checked event log? Is there anything in event log?

vasilis6669

It is a new company.

The same form works fine on the live. It is when I test the restore where the problem occurs.

What event log should i check? SQL, Windows?

Regards,
Vasilis

ara3n

Ok so you are using classic 2009 executable. When you restore, did you restore it into a blank db or you already had a db? Are the objects the same and in sync?

Turn on the debugger and see where it stops.

vasilis6669

I have created a new database and then restore the .fbk file

it stops on codeunit 225 Gen. Jour. CheckAgainstApplnCurrency(
IF (ApplnCurrencyCode = CompareCurrencyCode) THEN
EXIT(TRUE);

Is there any setting with posting dates or applied date i should check?

Regards,
Vasilis