<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Source Sans Pro";}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link="#0563C1" vlink="#954F72" style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal>Hello!<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I have a MS SQL with View, accessible with SQL Management Studio, all ok.<o:p></o:p></p><p class=MsoNormal>Now I’ve used next configuration to setup the resource in Midpoint:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><connectorRef oid="88cd0194-1ace-4d17-a613-14edd35dc292" relation="org:default" type="c:ConnectorType"><o:p></o:p></p><p class=MsoNormal> <!-- ConnId org.identityconnectors.databasetable.DatabaseTableConnector v1.4.9.1 --><o:p></o:p></p><p class=MsoNormal></connectorRef><o:p></o:p></p><p class=MsoNormal><connectorConfiguration xmlns:icfc=<a href="http://midpoint.evolveum.com/xml/ns/public/connector/icf-1/connector-schema-3">http://midpoint.evolveum.com/xml/ns/public/connector/icf-1/connector-schema-3</a>><o:p></o:p></p><p class=MsoNormal> <icfc:configurationProperties><o:p></o:p></p><p class=MsoNormal> <icscdbtable:host>XXX.com</icscdbtable:host><o:p></o:p></p><p class=MsoNormal> <icscdbtable:port>1433</icscdbtable:port><o:p></o:p></p><p class=MsoNormal> <icscdbtable:user>XXX </icscdbtable:user><o:p></o:p></p><p class=MsoNormal> <icscdbtable:password><o:p></o:p></p><p class=MsoNormal> <t:encryptedData><o:p></o:p></p><p class=MsoNormal> <t:encryptionMethod><o:p></o:p></p><p class=MsoNormal> <t:algorithm xmlns=<a href="http://prism.evolveum.com/xml/ns/public/types-3">http://prism.evolveum.com/xml/ns/public/types-3</a>><a href="http://www.w3.org/2001/04/xmlenc#aes256-cbc</t:algorithm">http://www.w3.org/2001/04/xmlenc#aes256-cbc</t:algorithm</a>><o:p></o:p></p><p class=MsoNormal> </t:encryptionMethod><o:p></o:p></p><p class=MsoNormal> <t:keyInfo><o:p></o:p></p><p class=MsoNormal> <t:keyName>XXXXX</t:keyName><o:p></o:p></p><p class=MsoNormal> </t:keyInfo><o:p></o:p></p><p class=MsoNormal> <t:cipherData><o:p></o:p></p><p class=MsoNormal> <t:cipherValue>XXX</t:cipherValue><o:p></o:p></p><p class=MsoNormal> </t:cipherData><o:p></o:p></p><p class=MsoNormal> </t:encryptedData><o:p></o:p></p><p class=MsoNormal> </icscdbtable:password><o:p></o:p></p><p class=MsoNormal> <icscdbtable:database>XXXX</icscdbtable:database><o:p></o:p></p><p class=MsoNormal> <icscdbtable:table>Profiles</icscdbtable:table><o:p></o:p></p><p class=MsoNormal> <icscdbtable:keyColumn>Staff Id</icscdbtable:keyColumn><o:p></o:p></p><p class=MsoNormal> <icscdbtable:jdbcDriver>com.microsoft.sqlserver.jdbc.SQLServerDriver</icscdbtable:jdbcDriver><o:p></o:p></p><p class=MsoNormal> <icscdbtable:quoting>Single</icscdbtable:quoting><o:p></o:p></p><p class=MsoNormal> <icscdbtable:jdbcUrlTemplate>jdbc:sqlserver://%h:%p;encrypt=false;databaseName=%d;</icscdbtable:jdbcUrlTemplate><o:p></o:p></p><p class=MsoNormal> </icfc:configurationProperties><o:p></o:p></p><p class=MsoNormal></connectorConfiguration><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Test Connection is ok, schema generation is ok – everything seems to be fine, now when I try to browse objects from resource or run import task I get exception: <o:p></o:p></p><p class=MsoNormal align=right style='text-align:right;background:white'><b><span style='font-size:10.5pt;font-family:"Source Sans Pro",sans-serif;color:#333333'>Operation<o:p></o:p></span></b></p><p class=MsoNormal style='margin-left:36.0pt;background:white'><b id=id6b9c><span style='font-size:10.5pt;font-family:"Source Sans Pro",sans-serif;color:#333333'>org.identityconnectors.framework.api.ConnectorFacade.search</span></b><span style='font-size:10.5pt;font-family:"Source Sans Pro",sans-serif;color:#333333'><o:p></o:p></span></p><p class=MsoNormal align=right style='margin-left:97.5pt;text-align:right;background:white'><b><span style='font-size:10.5pt;font-family:"Source Sans Pro",sans-serif;color:#333333'>Message<o:p></o:p></span></b></p><p class=MsoNormal style='margin-left:36.0pt;background:white'><span style='font-size:10.5pt;font-family:"Source Sans Pro",sans-serif;color:#333333'>Configuration error: SQL param name should be not null<o:p></o:p></span></p><p class=MsoNormal align=right style='margin-left:195.0pt;text-align:right;background:white'><b><span style='font-size:10.5pt;font-family:"Source Sans Pro",sans-serif;color:#333333'>Parameters<o:p></o:p></span></b></p><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 style='margin-left:36.0pt;border-collapse:collapse;box-sizing: border-box;border-spacing: 0px'><tr style='box-sizing: border-box'><td valign=top style='padding:0cm 0cm 0cm 0cm'><p class=MsoNormal><b>objectClass</b><b><o:p></o:p></b></p></td><td style='padding:0cm 15.0pt 0cm 3.75pt;box-sizing: border-box;white-space:pre-wrap'><p class=MsoNormal style='word-break:break-all'>[ObjectClass: __ACCOUNT__]<o:p></o:p></p></td></tr></table><p class=MsoNormal style='margin-left:36.0pt;background:white'><span style='font-size:10.5pt;font-family:"Source Sans Pro",sans-serif;color:#333333;display:none'><o:p> </o:p></span></p><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 style='margin-left:36.0pt;border-collapse:collapse;box-sizing: border-box;border-spacing: 0px'><tr><td style='padding:.75pt .75pt .75pt .75pt'></td></tr></table><p class=MsoNormal align=right style='margin-left:390.0pt;text-align:right;background:white'><b><span style='font-size:10.5pt;font-family:"Source Sans Pro",sans-serif;color:#333333'>Error</span></b><b><span style='font-size:10.5pt;font-family:"Source Sans Pro",sans-serif;color:#333333'><o:p></o:p></span></b></p><p class=MsoNormal style='margin-left:36.0pt;background:white'><span style='font-size:10.5pt;font-family:"Source Sans Pro",sans-serif;color:#333333'>Configuration error: SQL param name should be not null<o:p></o:p></span></p><p class=MsoNormal style='margin-left:36.0pt;background:white'><span style='font-size:10.5pt;font-family:"Source Sans Pro",sans-serif;color:#333333'><a href="https://idm-play.tedo.ru/midpoint/result?87"><span style='color:#3C8DBC;text-decoration:none'>show</span></a><o:p></o:p></span></p><p class=MsoNormal style='margin-left:36.0pt;background:white'><span style='font-size:8.5pt;font-family:"Courier New";color:#333333'>com.evolveum.midpoint.util.exception.ConfigurationException: Configuration error: SQL param name should be not null at com.evolveum.midpoint.provisioning.ucf.impl.connid.ConnIdUtil.processConnIdException(ConnIdUtil.java:169) at com.evolveum.midpoint.provisioning.ucf.impl.connid.ConnIdUtil.processConnIdException(ConnIdUtil.java:87) at com.evolveum.midpoint.provisioning.ucf.impl.connid.SearchExecutor.executeConnIdSearch(SearchExecutor.java:236) at com.evolveum.midpoint.provisioning.ucf.impl.connid.SearchExecutor.execute(SearchExecutor.java:110) at com.evolveum.midpoint.provisioning.ucf.impl.connid.ConnectorInstanceConnIdImpl.search(ConnectorInstanceConnIdImpl.java:1787) at com.evolveum.midpoint.provisioning.impl.resourceobjects.ResourceObjectConverter.searchResourceObjects(ResourceObjectConverter.java:1382)<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Timeout wise seems that Midpoint is getting the data – query takes around 27 seconds to run on server, more-or-less same time I wait till I get this error in Midpoint interface.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Any suggestions would be much appreciated, thank you!<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Cheers,<o:p></o:p></p><p class=MsoNormal>Dmitry<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>