ContactReview :: View topic

dreamweaver7777 · n00b

I am trying to run an update of fields on existing records in the GM database. Running Goldbox-7, on Goldmine 7 .00.70302, SQL Server 2000 database. Phases 1 and 2 completes, but when Phase 3 begins, I get the error:

Database Engine Error: Could not find object.

File: D:\Apps\Goldbox\nuimport.prg
Routine: GXIDOFINISH
Line: 4957

Your help is greatly appreciated.

Thanks
Andy Weaver

=====
LifeRing file follows below:
=====
WINDOWS System: Windows NT version 5.02
FREE DiskSpace: 81,183.609 Megabytes
B D E Version: 5.1.1.1
Folder: D:\Apps\GoldMine\Setup\BDEShare\idapi32.cfg
GOLDMINE Exe: q:\goldmine
GMbase: PPI_GOLDMINE
User: DATDYN
Sync: ON
GX7 Version: 2006-D
Folder: q:\goldbox
Serial #: G7701010
Licensee: PARK PLACE INTERNATIONAL

OPERATION: IMPORT / UPDATE
Category: UPD-MAIN/NU
Description: MTI Contract load 1
Launch ID: IGMTICN1.DBF

SOURCE TABLE: q:\goldbox\working\xxx-mt~1\cont1a.dbf
SOURCE FILTER:
START AT RECD: 1
QTY TO IMPORT: ALL
PARK AND STOP: NO
TARGET TABLE: PPI_GOLDMINE
DDE or TABDel: NO
INDEXED MATCH:
CUSTOM MATCH: Tgt->Userdef14
INCLUDE FILTER:
ADD NO-MATCHES: NO
DETAIL NAME:
DETL SRCH FLD:
MULT MATCH UPD: NO
BYPASS MATCHES: NO
INDEXED MATCH:
CUSTOM MATCH:
SOURCE EXPRN:

SOURCE Table: CONT1A.DBF Fields: 12 Records: 184
1. CUSTNO C 8 0
2. CUSTNAME C 28 0
3. SVR1 C 20 0
4. SVRWD1 D 8 0
5. SVR2 C 17 0
6. SVRWD2 C 10 0
7. SVR3 C 10 0
8. SVRWD3 C 10 0
9. SVR4 C 10 0
10. SVRWD4 C 10 0
11. STG1 C 10 0
12. STGWD1 C 10 0

FIELD-NAME T LEN D DESCRIPTION FIELD-1 FIELD-2 SHD Cas WB RQ
---------- - --- - -------------------- ---------- ---------- --- --- -- --
LASTNAME C 15 0 Last |e
PARK EXPN: ActualLast(GXI->Contact, GXI->Lastname)

PHONE_FMT C 1 0 Phone Format U=USA|e
PARK EXPN: 'U'

CURTAIN_CD C 1 0 CURTAIN Cd (0,1,2,3)|e
PARK EXPN: '0'

USERDEF14 C 10 0 HH Site ID |CUSTNO

UNEWPLAT C 15 0 Server 1 |SVR1

UOTHSVRW1 D 8 0 WD1 |SVRWD1

UOTHSVRW2 D 8 0 WD2 |SVRWD2 mm/dd/yy

USTORAGE C 25 0 Storage 1 |STG1

USTORAGEW D 8 0 WD1 |STGWD1 mm/dd/yy

UOTHSVR2 C 25 0 Server 2 |SVR2

UOTHSVR3 C 25 0 Server 3 |SVR3

UOTHSVR4 C 25 0 Server 4 |SVR4

UOTHSVRW3 D 8 0 WD3 |SVRWD3 mm/dd/yy

UOTHSVRW4 D 8 0 WD4 |SVRWD4 mm/dd/yy

(END OF LISTING) Created 12/19/2007 05:14:34 PM

BobTaylor · GoldBox Guru

The only thing I see is a difference in your Customer Number field, and the UserDef to which it is mapped. When used for matching, the field lengths should be the same, or an expression to compensate should be used.

But I don't think that's it; doesn't seem to fit the error message. Try updating to the latest version of GX7.

If that doesn't work, I recommend that you contact Dave Petonic directly, and give him that error message, including the line number.

dreamweaver7777 · n00b

Bob:

The update did the trick. Thanks for the suggestion!

BobTaylor · GoldBox Guru

Great, thanks for the feedback!