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

I have the same question (0)

All responses (10)

Answers (0)

Sort by

Suggested answer

Derek Albaugh Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Angela Eckman Ebens... 1,218 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Tim Wappat 5,713 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Microsoft Dynamics ... 193 on at

Like (0)

Report
Copy link

Link copied!

The above link is not working. File not found.

Was this reply helpful? Yes No
Peggy Aitken 90 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Peggy Aitken 90 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Peggy Aitken 90 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Peggy Aitken 90 on at

Like (0)

Report
Copy link

Link copied!

Good news! Looks loading the 2022 YE Update rectified the problem.

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

Follow the tips at the bottom of this link.

community.dynamics.com/.../inquiry-error-message-missing-table-sy01407

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (1)

Report
Copy link

Link copied!

Yes, that would make senses as that table is now created.

Was this reply helpful? Yes No