Data lost during upgrade

HrynyukAndrey

Hi all,
I am upgrading a database from 2009 to 2018 and I faced an issue. After the upgrade the table 77 Report selections does not contain 2 tables that were present at clean 2018 Navision. Reports 116 Statement and 1303 Standard Sales - Draft Invoice are present into a database but are missing in the table 77.
Any ideas why do that entries disappear?

swpolo

The problem usually causes with custom reports. During migration Classic to RTC it is important that reports objects were presented on database. Migration procedure checks table 77 if report objects exist and remove them if cant find.

Yury

Hi, Andrey
That is the result of wrong merging of table 77 from 2009 to 2018. What kind of upgrading tool do you use? There is a "Usage" fields, which contains related document types.

HrynyukAndrey

Yury wrote: »

Hi, Andrey
That is the result of wrong merging of table 77 from 2009 to 2018. What kind of upgrading tool do you use? There is a "Usage" fields, which contains related document types.

Table 77 was not modified. All customer data were transferred to nav 2018 after upgrade except only these 2 entries

Yury

Did you try to add them manually from RTC?

HrynyukAndrey

I want to know why that entries were not added during the upgrade procedure. is that a bug or not. I will modify the upgrade codeunit to insert these rows if they shall be present at target database

Yury

Check data conversion function of field "Usage" of this table. There are different option strings. Change it in case of bug.

swpolo

The problem usually causes with custom reports. During migration Classic to RTC it is important that reports objects were presented on database. Migration procedure checks table 77 if report objects exist and remove them if cant find.