74
Upgrading to GP 18.4 I get this error when trying to open the Transaction by Customer Inquiry Window:
I've looked at the DYNAMICS and company tables and SY01407 doesn't exist. It also didn't exist in their previous GP version (GP 2015).
After clicking ok, you can still access the window. Any ideas on to why this is throwing an error?
USE [DYNAMICS]
GO
/****** Object: Table [dbo].[SY01407] Script Date: 2/17/2022 9:25:22 PM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SY01407](
[USERID] [char](15) NOT NULL,
[DICTID] [smallint] NOT NULL,
[FORMNAME] [char](79) NOT NULL,
[WINNAME] [char](79) NOT NULL,
[FIELDNAM] [char](31) NOT NULL,
[IntegerValue] [smallint] NOT NULL,
[BinaryValue] [binary](4) NOT NULL,
[DEX_ROW_ID] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PKSY01407] PRIMARY KEY NONCLUSTERED
(
[USERID] ASC,
[DICTID] ASC,
[FORMNAME] ASC,
[WINNAME] ASC,
[FIELDNAM] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
Grant DYNGRP permissons on the table
You should have just been able to use the built in SQL Maintenance to create the table.
Including granting access to DYNGROUP and binding defaults.
David
Just to follow up on this, I was able to script out the table from an install where the SY01407 created ok (it had no records). I used that to create the table in the DYNAMICS database and the error is no longer there, so I believe this solved the issue.
I still don't know why that table was missed during the upgrade, but for now, this issue is resolved. Thanks for the input!
This table was never created in the new version. Not sure why as the 18.4 install went through the upgrade steps with no errors or warnings. I may try to install 18.4 to a test server and script out the table to insert it (assuming it upgrades and creates okay. Thanks for the ideas!
If your test databases still exist does this table exist there? If so, use SSMS to create the script to create the table. You could possibly use SQL Maintenance in GP to create this table as well.
Did you have this issue when performing your test upgrades?
This table is new to 18.4 -- where it stores the user defaults for the lookup windows in PM, RM and Bank Reconciliation.
Since it is new, there isn't any data that was ever stored in it -- I would think support could give you a script to run to create the table and any procedures and fix this.
Joe
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,321
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
