GP-How to troubleshooting version

1. A copy of the GP_LoginErrors.log file. This file was not attached if it was intended to attach.

2. Script results of the following:

sp_helpdb

select * from DB_Upgrade

select * from DB_DU000020

select CMPANYID, INTERID, CMPNYNAM from DYNAMICS..SY01500

SELECT b.fileOSName, a.fileNumber, a.PRODID, a.Status, a.errornum, a.errordes, c.CMPANYID, c.INTERID
FROM DYNAMICS.dbo.DU000030 a
JOIN
DYNAMICS.dbo.DU000010 b
ON a.fileNumber = b.fileNumber
AND a.PRODID = b.PRODID
JOI
DYNAMICS.dbo.SY01500 c
ON a.companyID = c.CMPANYID
WHERE (a.Status <> 0 or a.errornum <> 0) and a.Status <>15

3. A copy of the DYNAMICS.set file from the SQL Server. This file can be found by default in the path:

C:\Program Files\Microsoft Dynamics\GP\