InaPlex
»
InaPlex
»
Support
»
DBUpdate() expression : “something not implemented” Error
Rank: Member
Groups: Registered
Joined: 8/28/2015(UTC) Posts: 10  Location: London Thanks: 1 times
|
Ive been trying to update my source CRM records, with a DBUpdate() expression.
Im fairly sure my syntax is right, but i get a strange error message.
here is the error, from the preview pane error pop up dialog - it which ends with the highlighted text here :
Full text of the error message: Called something not implemented: MSCrmPhysDB.update(sql)
what does it mean ? can I rectify this ? Am i missing any system components ?
The expression i used was this one (though ive shortened my field names) :
Dbupdate("S","UPDATE servicenumber SET integ_count = '#[InaportExtractCounter]' WHERE servicenumberid = '#[servicenumberid]'")
-
Russell / Non Profit / IT Dept / UK Based |
Russell / Non Profit / IT Dept / UK Based
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/17/2015(UTC)
Posts: 22
Was thanked: 2 time(s) in 2 post(s)
|
Hi Russell Normally this approach would be fine, although we would probably recommend doing the update of the source in the "Post-Operation Table Expressions" sub-tab of tab 5. The advantage of this is you can selectively update the source based on whether the table was updated or inserted, and you also have access to the primary key of the target record just touched. For more information, see the expressions in the "Pre and Post Table Op Expression" section in the Expression Editor. Useful functions include: Code:wasinserted() - return true if the entity had a row inserted
wasupdated() - return true if the matched row in the entity was updated
pk() - return the primary key of the row just inserted or updated The problem you have is that the Microsoft CRM web service API does not actually support SQL. Inaport does support doing SQL queries, which are translated to to a web service call under the hood. This does not extend to update statements. The only way to update a record in MS CRM is to have MS CRM as the target, and Map and Match to the required entity. You could use the dbupdate() or dbinsert() functions to write information to another database using a different connector, then use that information in a second profile to update MSCRM.
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 8/28/2015(UTC) Posts: 10 Location: London Thanks: 1 times
|
Originally Posted by: ipadmin  Hi Russell Normally this approach would be fine, although we would probably recommend doing the update of the source in the "Post-Operation Table Expressions" sub-tab of tab 5. The advantage of this is you can selectively update the source based on whether the table was updated or inserted, and you also have access to the primary key of the target record just touched. For more information, see the expressions in the "Pre and Post Table Op Expression" section in the Expression Editor. Useful functions include: Code:wasinserted() - return true if the entity had a row inserted
wasupdated() - return true if the matched row in the entity was updated
pk() - return the primary key of the row just inserted or updated The problem you have is that the Microsoft CRM web service API does not actually support SQL. Inaport does support doing SQL queries, which are translated to to a web service call under the hood. This does not extend to update statements. The only way to update a record in MS CRM is to have MS CRM as the target, and Map and Match to the required entity. You could use the dbupdate() or dbinsert() functions to write information to another database using a different connector, then use that information in a second profile to update MSCRM. Aha, ok get it. I hadnt got as far as making sense of the post operation options - Now i see. Thanks. |
Russell / Non Profit / IT Dept / UK Based
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (2)
|
InaPlex
»
InaPlex
»
Support
»
DBUpdate() expression : “something not implemented” Error
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.