75,730
I tried to apply the 2021 year-end update(18.4.1384) and I received this error message:
The error was: ERROR [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'TRXBEGDT'.
The odd thing is when I ran GP Utilities a second time without restoring the databases and starting over I did not get this message.
The only table with a column called TRXBEGDT is the UPR10302 in this stored procedure.
This was strange not only because the second time upgraded just fine but when I did another upgrade the tables were upgraded correctly and again the upgrade went through successfully. I am keeping my eye on all the tables that were changed as listed by Terry. She is the best!!!
I think Richard and I worked through this one, it was only and issue on the Sample company TWO and for some reason the UPR10301 was not created properly and when that happens the load stored procedures will fail as it cannot find the column in the table needed for the procedure.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (