Error while converting DB from NAV 2009R2 to NAV 2013

ratnesh272

Dear All,

I'm doing data migration from NAV 2009 to NAV 2013R2. But during database conversion from NAV 2009 to NAV 2013, I'm getting an error in "G/L Entry" table. Attached is the screen shot of the error.

Can anyone help on this?

Thanks in advance!!

ratnesh272

I have checked the fields in sql is Not Null. And what you mean by other Standard filed, and what to update and where

Request you to guide me on what i need to do.

postsaurav

Hi,
G/L Entry Table seems to be modified on SQL. When we create a Field From Navision the SQL Field Property Goes as Not Null.

Just compare the field property in SQL with other standard Fields in table and update here.

ratnesh272

I have checked the fields in sql is Not Null. And what you mean by other Standard filed, and what to update and where

Request you to guide me on what i need to do.

postsaurav

HI,
Can you Put Images of SQL Table Fields here?

Juha

You have a field 'msrepl_tran_version' added from outside NAV. When NAV do the conversion data is copied to a G_L Entry_$temp$ table, but NAV only copies the fields defined in NAV.
The problem is that you have a G_L Entry_$TEMP$ table with a field msrepl_tran_version defined with NOT NULL and the INSERT statement doesn't include msrepl_tran_version so the INSERT fails.
msrepl_tran_version is from some transactional sql replication.
I don't know anything about the replication, but to me it looks like your options are
- Delete msrepl_tran_version from SQL
- Add msrepl_tran_version in NAV

/Juha