2,611
Hello,
I got below error on GP build number 18.4.1361.
as of now i got this error while open inquiry screen.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name '.SY01407'.
Yes, that would make senses as that table is now created.
Follow the tips at the bottom of this link.
community.dynamics.com/.../inquiry-error-message-missing-table-sy01407
Good news! Looks loading the 2022 YE Update rectified the problem.
I'm getting the same error after upgrading to
18.4.1436 (2021)
Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'DYNAMICS.dbo.SY01407'.
I did verify it does not exist and I'm hoping you can tell me how to recreate it.
TIA
I just upgraded to 18.4.1436 (2021) and I am getting the same error. I did verify that sy0147 does not exist. Sure hope you can tell me how to recreate the table.
TIA
Peggy Aitken
I just upgraded to 18.4.1436 (2021) and I am getting the same error. I did verify that sy0147 does not exist. Sure hope you can tell me how to recreate the table.
TIA
Peggy Aitken
The above link is not working. File not found.
I just encountered the same issue, this was my solution :
timwappat.info/.../syWindowDefaults_SY01407
(Basically use SQL tools in GP to recreate the missing objects. )
Hi!
What inquiry window are you trying to get into? What is the path? Inquiry > XXX > ZZZ?
I'll see what I can find out.
Thanks for using Microsoft Dynamics Communities,
Angela Ebensteiner
SR Technical Advisor
Microsoft Dynamics GP
The SY01407 table is the System Windows Defaults table, so, the first question is whether this table exists or not?
You can verify by running this script against your GP system database:
Select * from SY01407
From what I can tell, this table was added when upgrading to Dynamics GP 18.4, as I don't see it on my GP 18.3 environment.
If it doesn't exist in the GP system database, open a support case and we can verify that table, along with the indexes and dex procedures for it are created.
Then, after adding this new table and a backup of the GP system database, have users verify whether they still get this error message or not when opening the inquiry screen.
Thanks
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
