Database execution failed: Invalid column name 'SYSROWVERSION'. - [FINTAGBIENTITY]

(4) Share

Report

Posted on by Huggins Mafigu

511

Good day, Everyone,

I'm in the process of upgrading my dev VM from 10.0.44 to 10.0.45. During the upgrade, the process is able to run without issues until Step 24 and then produces the following error. I'm not sure how to resolve this because it is a standard entity, and there are no modifications to both the entity and the underlying table. Efforts to find similar issues online did not yield results. If I do run Full DB Sync on the environment manually, I get the same results.

Can someone with an idea of how to navigate through this please assist?

Error log

Environment change history

Manual Full DB Sync results

Thanks in advance.

I have the same question (0)

All responses (2)

Answers (1)

Sort by

André Arnaud de Cal... 305,797 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Huggins,

As this is your DEV VM, can you try to delete the view FINTAGBIENTITY from SQL and then try to perform the database sync?

You can also consider deploying a new DEV VM.

Was this reply helpful? Yes No
Verified answer

Huggins Mafigu 511 on at

Like (1)

Report
Copy link

Link copied!

Hi @André Arnaud de Calavon,

Yes, it's my VM.

However, I managed to get a breakthrough. I went to SQL Server, added the 'SYSROWVERSION' column manually to the FINTAG table, ran a successful DB Sync, and proceeded with the upgrade to 10.0.45 without any issues.

Thank you.

Was this reply helpful? Yes No