in

InaPlex Forums

Forums and downloads for InaPlex customers and partners.

inaport.exceptions.MVException when transferring data from SQL Server to GoldMine 7 on MS SQL

Last post 04-25-2008 22:18 by admin. 7 replies.
Page 1 of 1 (8 items)
Sort Posts: Previous Next
  • 12-13-2007 18:55

    inaport.exceptions.MVException when transferring data from SQL Server to GoldMine 7 on MS SQL

    Am getting inaport.exceptions.MVException when running my profile, which is supposed to transferr data from SQL Server to GoldMine 7 MSSQL. I am currently importing into _Contact1 with _Contact2 as a child table. I have match rules set up on both contact1 and contact2 to Updating / Creating records. Any ideas?
  • 12-13-2007 18:57 In reply to

    Re: inaport.exceptions.MVException when transferring data from SQL Server to GoldMine 7 on MS SQL

    Full details from Log file: Date: 2007-12-13 18:50:40.395 +00 Profile: C:\Program Files\InaPlex\Inaport\My Profiles\tWebAppImport.ipp Data source: Connectors/Web Application Form Data Data target: Connectors/GoldMine Records excluded for match fail or data errors (source record number, reason, record data): -------------------------------------------------------------------------------------------- Operation stopped with an error. Error message: MVException: no = 2091 Fail appending to GoldMine table with handle 194812608 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.DBLogTable.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.ui.RunDialog.RunProfile.run()
  • 12-13-2007 19:58 In reply to

    Re: inaport.exceptions.MVException when transferring data from SQL Server to GoldMine 7 on MS SQL

    Hi Russell

    Do you have a numeric UDEF field in contact2? If so, you are running into a known issue with GM7.

    PROBLEM

    When an application (such as Inaport) creates a C2 record using the API, GoldMine issues an insert on the database, which succeeds. It then accumulates all the field values, and issues a single update to the record when the changes are commited by the application. For reasons best known to the developers, the WHERE clause to the UPDATE checks that each field being updated is currently null.

    Problem with this is that with GM7, the schema definition for UDEF numeric fields was changed to have them default to 0. That means any numeric fields are set to 0 when the record is first inserted, which in turn means that the where clause fails.

    WORKAROUND

    In Inaport, you can work around this problem by having two instances of the _contact2 table in your table map.

    On the first instance, set the operation to "Create not exist", and accept the default priamry key/foreign key settings.
    Do not specify any match criteria.
    Do NOT map any values to the fields - have an empty "Map for Create" grid

    On the second instance, set the operation to "Update single existing"
    Do not specify any match crieria
    Now map all your fields to the required fields in C2

    ----------

    In the medium term, we are working on having Inaport handle this silently for you, but at the moment this is the only work around.

    HTH

    Filed under:
  • 04-21-2008 17:21 In reply to

    Re: inaport.exceptions.MVException when transferring data from SQL Server to GoldMine 7 on MS SQL

    greetings ... to clarify, i have the following settings:

    _contact2 (first one)

    > create new record if not existing

    > standard matching

    > data error - stop

    > no matches - continue

    > multiple matches - stop

    > relationship ==> recid = accountno

    > match ==> empty

    > map ==> empty

     

    _contact2 (second one)

    > update existing record - unique match

    > standard matching

    > data error - stop

    > no matches - stop

    > multiple matches - stop

    > relationship ==> recid = accountno

    > match ==> empty

    > map ==> 5 fields

     

    now whenever i update an existing row in my source_db and fire it thru inaport to affect GM, i am getting the following errors:

    988    Multiple match: Multiple matches on table _Contact2    <<data here>>
    989    Multiple match: Multiple matches on table _Contact2    <<data here>>
    990    Multiple match: Multiple matches on table _Contact2    <<data here>>

     

    are those setting above correct? if so, is this error message the intended/desired result, something we have to live with until the GM ppl can fix their code?

    thanks in advance,

    -erik 

  • 04-23-2008 18:38 In reply to

    Re: inaport.exceptions.MVException when transferring data from SQL Server to GoldMine 7 on MS SQL

    bump
  • 04-24-2008 18:52 In reply to

    Re: inaport.exceptions.MVException when transferring data from SQL Server to GoldMine 7 on MS SQL

    Hi

    Apologies for delay in response.

    I suspect you have multiple C2 records for the C1 records you are matching on. Try the following SQL query:

    select accountno from contact2 group by accountno having count(accountno) > 1

    You can run this query in GoldMine

    Regards

    David

  • 04-25-2008 18:22 In reply to

    Re: inaport.exceptions.MVException when transferring data from SQL Server to GoldMine 7 on MS SQL

     yes, there are multiple C2 records ... i purged them yesterday and let the system do its thing ... after checking this morning there are 4 more dups, so clearly something is not configured correctly.

    can you review the settings i have above and let me know if the problem lies with this? or what other things should we check?
     

  • 04-25-2008 22:18 In reply to

    Re: inaport.exceptions.MVException when transferring data from SQL Server to GoldMine 7 on MS SQL

    Hi

    The settings look OK. Why don't you contact me on support@inaplex.com and we will set up a remote support session to have a looka at what is going on.

    Regards

    David

Page 1 of 1 (8 items)
InaPlex Limited 2011