<div dir="ltr">Hi folks,<div><br></div><div>1) DBTable connector is only for one table (or view). </div><div>Can you create a DB view in your situation?</div><div><br></div><div>2) please see also connectorErrorCriticality on page:</div><div><a href="https://wiki.evolveum.com/display/midPoint/Resource+Definition+Sections">https://wiki.evolveum.com/display/midPoint/Resource+Definition+Sections</a></div><div><br></div><div>Best regards,</div><div><br></div><div>Gustav</div><div><br><div class="gmail_extra"><br><div class="gmail_quote">2017-05-24 16:14 GMT+02:00 Shilen Patel <span dir="ltr"><<a href="mailto:shilen@duke.edu" target="_blank">shilen@duke.edu</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div style="word-wrap:break-word;color:rgb(0,0,0);font-size:14px;font-family:Calibri,sans-serif">
<div>Hi folks,</div>
<div><br>
</div>
<div>I am relatively new to using MidPoint and have recently started to look at how to integrate with a resource that stores user objects in a database table (Oracle). I'm using the built-in DatabaseTableConnector (v1.4.2.0). The database table is only a
provisioning target. So only outbound mappings and nothing inbound. A have a couple of questions that I was hoping I could get some insight into.</div>
<div><br>
</div>
<div>1. Most of the data needs to go to a single table. However, there is one attribute that needs to go to another table. The other table has a foreign reference to the primary table. Does the built-in DatabaseTableConnector connector provide a means to
insert a row into the secondary table when a row is inserted into the primary table? If not, I think I know how to work around it. I think I can easily extend the connector to do what I need to do there, but wanted to make sure there wasn't another way.</div>
<div><br>
</div>
<div>2. I'm trying to figure out how error handling is supposed to work. I've read through some of the background wiki pages, e.g. <a href="https://wiki.evolveum.com/display/midPoint/Consistency+mechanism" target="_blank">https://wiki.evolveum.<wbr>com/display/midPoint/<wbr>Consistency+mechanism</a></div>
<div><br>
</div>
<div>I want to see what would happen when the target database is down (e.g. unexpected outage, scheduled maintenance, etc). I figure when I have a lot of these external resources, I need to make sure a single resource having an issue doesn't make the whole
MidPoint instance have issues. So to force an error, I changed the database and jdbc connection url strings to have an invalid SID. But then, using the web interface, if I try updating any attribute on a user that has a linked account for that resource,
I get the following error:</div>
<div><br>
</div>
<div>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">
2017-05-24 09:37:02,270 [] [Thread-21] ERROR (com.evolveum.midpoint.<wbr>provisioning.ucf.impl.IcfUtil)<wbr>: ICF Exception java.lang.RuntimeException in connector:cbf461fb-12f8-4fb3-<wbr>b705-ceba4b7af0ab(ICF org.identityconnectors.<wbr>databasetable.<wbr>DatabaseTableConnector v1.4.2.0):
resource:48b3a4c2-0a55-426d-<wbr>b21a-bed707837e72(TestDB) while getting object identified by ICF UID '102': java.sql.SQLException: Listener refused the connection with the following error:</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0);min-height:14px">
<br>
</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">
java.lang.RuntimeException: java.sql.SQLException: Listener refused the connection with the following error:</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0);min-height:14px">
<br>
</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">
at org.identityconnectors.<wbr>dbcommon.SQLUtil$2.access(<wbr>SQLUtil.java:207) ~[dbcommon-1.4.2.0.jar:na]</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">
at org.identityconnectors.common.<wbr>security.GuardedString.access(<wbr>GuardedString.java:116) ~[connector-framework-1.4.2.<wbr>18.jar:na]</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">
at org.identityconnectors.<wbr>dbcommon.SQLUtil.<wbr>getDriverMangerConnection(<wbr>SQLUtil.java:198) ~[dbcommon-1.4.2.0.jar:na]</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">
at org.identityconnectors.<wbr>databasetable.<wbr>DatabaseTableConnection.<wbr>getNativeConnection(<wbr>DatabaseTableConnection.java:<wbr>102) ~[connector-databasetable-1.4.<wbr>2.0.jar:na]</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">
at org.identityconnectors.<wbr>databasetable.<wbr>DatabaseTableConnection.<wbr>createDBTableConnection(<wbr>DatabaseTableConnection.java:<wbr>74) ~[connector-databasetable-1.4.<wbr>2.0.jar:na]</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">
at org.identityconnectors.<wbr>databasetable.<wbr>DatabaseTableConnector.<wbr>getConn(<wbr>DatabaseTableConnector.java:<wbr>212) ~[connector-databasetable-1.4.<wbr>2.0.jar:na]</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">
at org.identityconnectors.<wbr>databasetable.<wbr>DatabaseTableConnector.<wbr>checkAlive(<wbr>DatabaseTableConnector.java:<wbr>192) ~[connector-databasetable-1.4.<wbr>2.0.jar:na]</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">
at org.identityconnectors.<wbr>framework.impl.api.local.<wbr>ConnectorPoolManager$<wbr>ConnectorPoolHandler.<wbr>testObject(<wbr>ConnectorPoolManager.java:149) ~[connector-framework-<wbr>internal-1.4.2.18.jar:na]</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">
at org.identityconnectors.<wbr>framework.impl.api.local.<wbr>ConnectorPoolManager$<wbr>ConnectorPoolHandler.<wbr>testObject(<wbr>ConnectorPoolManager.java:83) ~[connector-framework-<wbr>internal-1.4.2.18.jar:na]</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">
at org.identityconnectors.<wbr>framework.impl.api.local.<wbr>ObjectPool.borrowObject(<wbr>ObjectPool.java:250) ~[connector-framework-<wbr>internal-1.4.2.18.jar:na]</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">
at org.identityconnectors.<wbr>framework.impl.api.local.<wbr>operations.<wbr>ConnectorAPIOperationRunnerPro<wbr>xy.invoke(<wbr>ConnectorAPIOperationRunnerPro<wbr>xy.java:87) ~[connector-framework-<wbr>internal-1.4.2.18.jar:na]</p>
</div>
<div><br>
</div>
<div>I can provide the full stack trace if it would be useful. I was expecting/hoping that any error on an individual outbound resource wouldn't fail the entire transaction. I saw that there is a configuration option called "Rethrow all SQLExceptions", but
that didn't seem to change this particular behavior. I think ideally the update of the attribute in MidPoint would succeed and the update to the resource would either be automatically retried later or just ignored and handled by a reconciliation task. Is
that possible? Am I doing something wrong?</div>
<div><br>
</div>
<div>Thanks!</div><span class="gmail-HOEnZb"><font color="#888888">
<div><br>
</div>
<div>- Shilen</div>
<div><br>
</div>
</font></span></div>
<br>______________________________<wbr>_________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a><br>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">http://lists.evolveum.com/<wbr>mailman/listinfo/midpoint</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><div>Gustáv Pálos</div><div>Identity Engineer</div><a href="http://evolveum.com/" rel="noreferrer" style="color:rgb(17,85,204);font-size:12.8px" target="_blank">evolveum.com</a><br></div></div>
</div></div></div>