InaPlex Forums

Hi - I am getting "Row cannot be located for updating" error in Goldmine which events (5) are generated from GMxS32 and then one from Inaport as below:

6/4/09 Source Inaport Time 10.25.42 AM
The description for Event ID ( 0 ) in Source ( Inaport ) cannot be found. The local computer may not have the necessary registry information or message DLL
files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details.
The following information is part of the event: MVException:  no = 2091
Fail appending to GoldMine table with handle 65208104

com.inaplex.inaport.exceptions.MVException
   at com.inaplex.inaport.db.goldmine.GM.Append(Int32 handle)
   at com.inaplex.inaport.db.goldmine.GMPhysTable.insertRec(ITRecord rec, TablePrimaryKey parentKey, Boolean updateIndex)
   at com.inaplex.inaport.db.goldmine.GMPhysTable.insertRec(ITRecord rec, TablePrimaryKey parentKey)
   at com.inaplex.inaport.db.goldmine.GMLogTableCSBase.insertRec(ITRecord srcRec, ITRecord targRec, TablePrimaryKey parentKey)
   at com.inaplex.inaport.db.DBLogTable.doOp(ITRecord srcRec, TablePrimaryKey parentKey, TablePrimaryKey currentMatch)
   at com.inaplex.inaport.profile.IPRun_Profile.doTree(IPTableNode node, ITRecord srcRec, TablePrimaryKey parentKey)
   at com.inaplex.inaport.profile.IPRun_Profile.doTree(IPTableNode node, ITRecord srcRec, TablePrimaryKey parentKey)
   at com.inaplex.inaport.profile.IPRun_Profile.priv_doIt(IPLicenseMgr licMgr)
   at com.inaplex.inaport.InaPort.main(String[] args)

Any ideas?   Frontrange is looking at Inaport as the problem, but I have demonstrated that Goldmine generates their errors (ADORecordset) even if Inaport is turned off.  But we also need to look at the Inaport event.  We are on Version 7.0, Build 8130, Rev 1Thanks  Dave

Hi Dave

Not clear what you mean by GoldMine generates errors even if Inaport is turned off. does that mean you are getting errors whenever you try to create a detail record in GoldMine, fo example?

You might want to look at database maintenance - might be an indexing issue.

if that does not wrok, generate a debug log in Inaport (Tools - Satrt Debug Logging, do a run) and send the log file to support@inaplex.com

Regards

Admin

I might have found a clue in the forum - MVException 2091 indicates a problem with C2 records being inserted with UDEF fields which were created as numbers.

We did create some new UDEF fields as numbers in the C2 table.   Would the recommendation be to move those fields to CONTSUPP or some other table?

Or  create a second instance of C2 referenced in the forum item:  inaport.exceptions.MVException when transferring data from SQL Server to GoldMine 7 on MS SQL

Is there a fix yet?

The error indicates that you were having a problem with the contsupp table - details or additional contacts perhaps.

If you really are going into contact2, then yes, do what is suggested in the knowledge base article.

Regards

Admin