I'm trying to install GP 2010 R2 on my laptop and get this error when running Utilities. I tried the resolution the error suggests (namely, adding SQL and ODBC Log = True) to the Dex.ini and re-running Utilities) to no avail. Can anyone point me in the right direction on this?
Thanks!
*This post is locked for comments
The server is on my laptop too. I finally got it to work after cleaning every possible remnant of GP 2010 off the machine, including registry entries and then installed GP 2010 R2.
Thanks for all your help,
OK, let's try something a little different. I assume you have GP running on your server. So why don't you detach the DYNAMICS and TWO databases off the server and copy them to your laptop. Make sure you do this after hours and reattach immediately after the copy is done. Attach the ddatabases on your laptop then just fire up GP and logging as 'sa' on your laptop and you will have a working copy just like on your server. This is assuming the copy on your server is working and you have the same service pack level on your server and on your laptop.
I tried that Richard. No worky. I'm guessing there's something lurking in my registry that is giving me fits. I've uninstalled and reinstalled a number of times and no joy yet.
Thanks,
If this is the test company why don't you just use GP Utilities to re-add the sample company database. I would go into GP and delete FABRIKAM and then use GP Utilities to recreate.
Hi Frank,
This table exist in my TWO DB and contains actually 92 rows. Basically there are only two fields : ITEMNMBR and RCTSEQNM...
Maybe just re-create it from another company or use the script below :
USE [TWO]
GO
/****** Object: Table [dbo].[IV10202] Script Date: 08/23/2011 11:40:27 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[IV10202](
[ITEMNMBR] [char](31) NOT NULL,
[RCTSEQNM] [int] NOT NULL,
[DEX_ROW_ID] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PKIV10202] PRIMARY KEY NONCLUSTERED
(
[ITEMNMBR] 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
SET ANSI_PADDING OFF
GO
Thanks Richard. That did the trick. Now, I'm running into an error where Utilities is trying to upgrade IV10202 in Fabrikam, but no such table exists in the database. Grrrrrrrr.
Nope, haven't tried that Richard. I queried the table for dup records and found none. I'll give the delete records a try.
Thanks,
Have you tried deleting all the records out of the SY07240 table? Make a backup first, of course. It should rebuild itself when launching GP.
I haven't been able to find anything on PartnerSource about this either. I'll post a screenshot here of the error I receive when running Utilities -
Thank you,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156