Finance | Project Operations, Human Resources, ...

Inquiry error message missing table SY01407.

(0) Share

Report

Posted on by Hossam Fathy

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'.

Categories:

Microsoft Dynamics GP

All responses (10)

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (1)

Report

RE: Inquiry error message missing table SY01407.

Yes, that would make senses as that table is now created.
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Inquiry error message missing table SY01407.

Follow the tips at the bottom of this link.

community.dynamics.com/.../inquiry-error-message-missing-table-sy01407
Peggy Aitken 90 on at

Like (0)

Report

RE: Inquiry error message missing table SY01407.

Good news! Looks loading the 2022 YE Update rectified the problem.
Peggy Aitken 90 on at

Like (0)

Report

RE: Inquiry error message missing table SY01407.

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
Peggy Aitken 90 on at

Like (0)

Report

RE: Inquiry error message missing table SY01407.

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
Peggy Aitken 90 on at

Like (0)

Report

RE: Inquiry error message missing table SY01407.

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
Microsoft Dynamics ... 193 on at

Like (0)

Report

RE: Inquiry error message missing table SY01407.

The above link is not working. File not found.
Tim Wappat 5,703 on at

Like (1)

Report

RE: Inquiry error message missing table SY01407.

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. )
Angela Eckman Ebens... 1,216 on at

Like (0)

Report

RE: Inquiry error message missing table SY01407.

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
Suggested answer

Derek Albaugh on at

Like (1)

Report

RE: Inquiry error message missing table SY01407.

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