InaPlex Forums

I am running a routine to update a field in contact2.  I am passing the accountno from the source connection.  The profile will find the contact1 accountno, but is unable to find the same accountno in contact2.  Running a SQL query on contact2 with the same accountno return the correct record.

This is the result from the debug log:

140521   [IP_Run] indexes.TableIndex:  match(rec): table = _Contact1  matchVal = A9012843615*A;MG9  found 1 matches
140521   [IP_Run] db.DBLogTable:  match: table = _Contact1  ParentKey = NULL  Num matches found = 1  matchVal found = A9012843615*A;MG9
140521   [IP_Run] profile.IPRun_Profile:  doTree: table.doOp returned 1 rows  --------------------------------
140521   [IP_Run] profile.IPRun_Profile:  doTree: about to call child _Contact2
140521   [IP_Run] profile.IPRun_Profile:  doTree: table _Contact2  op = 20   --------------------------------
140521   [IP_Run] indexes.TableIndex:  match(parentKey):  table = _Contact2  matchVal = A9012843615*A;MG9  found 0 matches
140521   [IP_Run] db.DBLogTable:  match: table = _Contact2  ParentKey = A9012843615*A;MG9  NO matches found
140552   [IP_Run] exceptions.MVException: 

 

Hi

As Contact2 is 1-1 from Contact 1, you do not need to supply match criteria.

Matching on any child table is a two step process:

1. Use the primary key and foreign key information in the Relationships tab to identify child records that belong to the matched parent record

2. Then use any match criteria in the Match tab to select the correct child record

For a 1-1 table, step 1 is sufficient to identify a unique child record, and you do not need to provide any further matching.

In your case, I suspect that the Relationships tab for Contact2 has been changed. Check that you have primary key #RECID and foreign key #ACCOUNTNO

Regards

Admin

I should have mentioned that a majority of the records updated correctly.  I was trying to determine the reason for the exceptions.

Hi

Can you email a PDF of your profile to support@inaplex.com so we can have a look.

To create a PDF, go to File - Print Preview, then Save As PDF

Regards

Admin