Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-13095

DatabaseTable Connector sample: Update sample to not require __NAME__ on create

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 7.0.0
    • Fix Version/s: None
    • Labels:
    • Environment:
      DBTableConnector 1.4.2.0-SNAPSHOT (1ec8540333a), OpenIDM 7.0.0-SNAPSHOT (f3d79e6)
    • Target Version/s:

      Description

      After OPENICF-903 fix, we should not enforce _NAME_ to be in create payload. We need to update sample to work without _NAME_ and remove required: true.

      Without required and _NAME_ we've got currently 500 Internal Server Error as UNIQUE_ID is not properly set,

      curl --header "X-OpenIDM-Username: openidm-admin" --header "X-OpenIDM-Password: openidm-admin" --header "Content-Type: application/json" --data '{"STATUS": "unknown", "NAME_FIRST": "foo", "NAME_LAST": "User", "TYPE": "employee"}' --request POST "http://localhost:8080/openidm/system/contractordb/__ACCOUNT__/?_action=create"
      
      Response Content:
      {"code":500,"reason":"Internal Server Error","message":"Operation CREATE failed with ConnectorException on system object"}
      

      OpenIDM logs

      SEVERE: Create account 'null' error
      java.sql.SQLException: Field 'UNIQUE_ID' doesn't have a default value
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
      	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
      	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
      	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
      	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199)
      	at org.identityconnectors.databasetable.DatabaseTableConnector.create(DatabaseTableConnector.java:314)
      	at org.identityconnectors.framework.impl.api.local.operations.CreateImpl.create(CreateImpl.java:88)
      	at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.identityconnectors.framework.impl.api.local.operations.ConnectorAPIOperationRunnerProxy.invoke(ConnectorAPIOperationRunnerProxy.java:104)
      	at com.sun.proxy.$Proxy76.create(Unknown Source)
      	at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.identityconnectors.framework.impl.api.local.operations.ThreadClassLoaderManagerProxy.invoke(ThreadClassLoaderManagerProxy.java:96)
      	at com.sun.proxy.$Proxy76.create(Unknown Source)
      	at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.identityconnectors.framework.impl.api.DelegatingTimeoutProxy.invoke(DelegatingTimeoutProxy.java:98)
      	at com.sun.proxy.$Proxy76.create(Unknown Source)
      	at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.identityconnectors.framework.impl.api.local.LocalConnectorFacadeImpl$ReferenceCountingProxy.invoke(LocalConnectorFacadeImpl.java:304)
      	at com.sun.proxy.$Proxy76.create(Unknown Source)
      	at org.identityconnectors.framework.impl.api.AbstractConnectorFacade.create(AbstractConnectorFacade.java:210)
      	at org.forgerock.openidm.provisioner.openicf.impl.ObjectClassResourceProvider.handleCreate(ObjectClassResourceProvider.java:278)
      	at org.forgerock.openidm.provisioner.openicf.impl.ObjectClassRequestHandler.handleCreate(ObjectClassRequestHandler.java:100)
      	at org.forgerock.json.resource.Router.handleCreate(Router.java:265)
      	at org.forgerock.json.resource.FilterChain$Cursor.handleCreate(FilterChain.java:65)
      	at org.forgerock.json.resource.ResourceApiVersionRoutingFilter.filterCreate(ResourceApiVersionRoutingFilter.java:47)
      	at org.forgerock.json.resource.FilterChain$Cursor.handleCreate(FilterChain.java:63)
      	at org.forgerock.json.resource.FilterChain.handleCreate(FilterChain.java:232)
      	at org.forgerock.json.resource.Router.handleCreate(Router.java:265)
      	at org.forgerock.json.resource.FilterChain$Cursor.handleCreate(FilterChain.java:65)
      	at org.forgerock.json.resource.Filters$ConditionalFilter.filterCreate(Filters.java:54)
      	at org.forgerock.json.resource.Filters$ConditionalFilter.filterCreate(Filters.java:52)
      	at org.forgerock.json.resource.FilterChain$Cursor.handleCreate(FilterChain.java:63)
      	at org.forgerock.openidm.authz.DelegatedAdminFilter.lambda$filterCreate$1(DelegatedAdminFilter.java:189)
      	at org.forgerock.util.promise.Promises$CompletedPromise.thenAsync(Promises.java:263)
      	at org.forgerock.util.promise.Promises$CompletedPromise.thenAsync(Promises.java:227)
      	at org.forgerock.openidm.authz.DelegatedAdminFilter.filterRequest(DelegatedAdminFilter.java:252)
      	at org.forgerock.openidm.authz.DelegatedAdminFilter.filterCreate(DelegatedAdminFilter.java:188)
      	at org.forgerock.json.resource.Filters$ConditionalFilter.filterCreate(Filters.java:52)
      	at org.forgerock.json.resource.FilterChain$Cursor.handleCreate(FilterChain.java:63)
      	at org.forgerock.openidm.authz.DelegatedAdminFilter.lambda$filterCreate$1(DelegatedAdminFilter.java:189)
      	at org.forgerock.util.promise.Promises$CompletedPromise.thenAsync(Promises.java:263)
      	at org.forgerock.util.promise.Promises$CompletedPromise.thenAsync(Promises.java:227)
      	at org.forgerock.openidm.authz.DelegatedAdminFilter.filterRequest(DelegatedAdminFilter.java:252)
      	at org.forgerock.openidm.authz.DelegatedAdminFilter.filterCreate(DelegatedAdminFilter.java:188)
      	at org.forgerock.json.resource.Filters$ConditionalFilter.filterCreate(Filters.java:52)
      	at org.forgerock.json.resource.FilterChain$Cursor.handleCreate(FilterChain.java:63)
      	at org.forgerock.openidm.audit.filter.AuditFilter.lambda$filterCreate$1(AuditFilter.java:121)
      	at org.forgerock.openidm.audit.filter.AuditFilter.logAuditAccessEntry(AuditFilter.java:171)
      	at org.forgerock.openidm.audit.filter.AuditFilter.filterCreate(AuditFilter.java:121)
      	at org.forgerock.openidm.router.filter.MutableFilterDecorator.filterCreate(MutableFilterDecorator.java:72)
      	at org.forgerock.json.resource.Filters$ConditionalFilter.filterCreate(Filters.java:52)
      	at org.forgerock.json.resource.FilterChain$Cursor.handleCreate(FilterChain.java:63)
      	at org.forgerock.openidm.servlet.internal.ServletConnectionFactory$3.lambda$filterCreate$1(ServletConnectionFactory.java:379)
      	at org.forgerock.openidm.servlet.internal.ServletConnectionFactory$3.handleRequestWithLogging(ServletConnectionFactory.java:430)
      	at org.forgerock.openidm.servlet.internal.ServletConnectionFactory$3.filterCreate(ServletConnectionFactory.java:379)
      	at org.forgerock.json.resource.FilterChain$Cursor.handleCreate(FilterChain.java:63)
      	at org.forgerock.openidm.router.filter.PassthroughFilter.filterCreate(PassthroughFilter.java:48)
      	at org.forgerock.openidm.router.filter.MutableFilterDecorator.filterCreate(MutableFilterDecorator.java:72)
      	at org.forgerock.openidm.router.filter.MutableFilterDecorator.filterCreate(MutableFilterDecorator.java:72)
      	at org.forgerock.json.resource.FilterChain$Cursor.handleCreate(FilterChain.java:63)
      	at org.forgerock.openidm.router.filter.PassthroughFilter.filterCreate(PassthroughFilter.java:48)
      	at org.forgerock.openidm.router.filter.MutableFilterDecorator.filterCreate(MutableFilterDecorator.java:72)
      	at org.forgerock.json.resource.Filters$ConditionalFilter.filterCreate(Filters.java:52)
      	at org.forgerock.json.resource.FilterChain$Cursor.handleCreate(FilterChain.java:63)
      	at org.forgerock.json.resource.FilterChain.handleCreate(FilterChain.java:232)
      	at org.forgerock.json.resource.InternalConnection.createAsync(InternalConnection.java:40)
      	at org.forgerock.json.resource.AbstractConnectionWrapper.createAsync(AbstractConnectionWrapper.java:101)
      	at org.forgerock.openidm.servlet.internal.ServletConnectionFactory$InternalConnectionWrapper.lambda$createAsync$1(ServletConnectionFactory.java:297)
      	at org.forgerock.openidm.metrics.MetricsCollector.time(MetricsCollector.java:112)
      	at org.forgerock.openidm.servlet.internal.ServletConnectionFactory$InternalConnectionWrapper.time(ServletConnectionFactory.java:286)
      	at org.forgerock.openidm.servlet.internal.ServletConnectionFactory$InternalConnectionWrapper.createAsync(ServletConnectionFactory.java:297)
      	at org.forgerock.json.resource.http.RequestRunner.visitCreateRequest(RequestRunner.java:160)
      	at org.forgerock.json.resource.http.RequestRunner.visitCreateRequest(RequestRunner.java:84)
      	at org.forgerock.json.resource.Requests$CreateRequestImpl.accept(Requests.java:254)
      	at org.forgerock.json.resource.http.RequestRunner.handleResult(RequestRunner.java:132)
      	at org.forgerock.util.promise.Promises$CompletedPromise.thenAsync(Promises.java:263)
      	at org.forgerock.util.promise.Promises$CompletedPromise.thenAsync(Promises.java:252)
      	at org.forgerock.json.resource.http.HttpAdapter.doRequest(HttpAdapter.java:739)
      	at org.forgerock.json.resource.http.HttpAdapter.doCreate(HttpAdapter.java:572)
      	at org.forgerock.json.resource.http.HttpAdapter.handle(HttpAdapter.java:297)
      	at org.forgerock.http.handler.Handlers$HandlerDescribableAsDescribableHandler.handle(Handlers.java:146)
      	at org.forgerock.http.filter.OptionsFilter.filter(OptionsFilter.java:69)
      	at org.forgerock.http.handler.Handlers$1.handle(Handlers.java:53)
      	at org.forgerock.http.routing.Router.handle(Router.java:100)
      	at org.forgerock.http.swagger.OpenApiRequestFilter.filter(OpenApiRequestFilter.java:63)
      	at org.forgerock.http.handler.Handlers$1.handle(Handlers.java:53)
      	at org.forgerock.openidm.auth.ProfileEnhancementCheckFilter.filter(ProfileEnhancementCheckFilter.java:145)
      	at org.forgerock.http.handler.Handlers$1.handle(Handlers.java:53)
      	at org.forgerock.openidm.auth.LoginCountFilter.filter(LoginCountFilter.java:60)
      	at org.forgerock.http.handler.Handlers$1.handle(Handlers.java:53)
      	at org.forgerock.caf.authentication.framework.AuthenticationFramework.grantAccess(AuthenticationFramework.java:188)
      	at org.forgerock.caf.authentication.framework.AuthenticationFramework.lambda$onValidateRequestSuccess$1(AuthenticationFramework.java:181)
      	at org.forgerock.util.promise.Promises$CompletedPromise.thenAsync(Promises.java:263)
      	at org.forgerock.util.promise.Promises$CompletedPromise.thenAsync(Promises.java:252)
      	at org.forgerock.caf.authentication.framework.AuthenticationFramework.validateRequest(AuthenticationFramework.java:144)
      	at org.forgerock.caf.authentication.framework.AuthenticationFramework.processMessage(AuthenticationFramework.java:134)
      	at org.forgerock.caf.authentication.framework.AuthenticationFilter.filter(AuthenticationFilter.java:84)
      	at org.forgerock.openidm.auth.AuthFilterWrapper.filter(AuthFilterWrapper.java:85)
      	at org.forgerock.http.handler.Handlers$1.handle(Handlers.java:53)
      	at org.forgerock.http.filter.TransactionIdInboundFilter.filter(TransactionIdInboundFilter.java:86)
      	at org.forgerock.http.handler.Handlers$1.handle(Handlers.java:53)
      	at org.forgerock.http.servlet.HttpFrameworkServlet.service(HttpFrameworkServlet.java:264)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
      	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)
      	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)
      	at org.eclipse.jetty.servlets.CrossOriginFilter.handle(CrossOriginFilter.java:311)
      	at org.eclipse.jetty.servlets.CrossOriginFilter.doFilter(CrossOriginFilter.java:265)
      	at sun.reflect.GeneratedMethodAccessor110.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.forgerock.openidm.servletregistration.impl.ServletRegistrationSingleton$FilterProxy.invoke(ServletRegistrationSingleton.java:302)
      	at com.sun.proxy.$Proxy70.doFilter(Unknown Source)
      	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1634)
      	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)
      	at org.ops4j.pax.web.service.jetty.internal.HttpServiceServletHandler.doHandle(HttpServiceServletHandler.java:71)
      	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
      	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
      	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
      	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
      	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
      	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
      	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1340)
      	at org.ops4j.pax.web.service.jetty.internal.HttpServiceContext.doHandle(HttpServiceContext.java:293)
      	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
      	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
      	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
      	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
      	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1242)
      	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
      	at org.ops4j.pax.web.service.jetty.internal.JettyServerHandlerCollection.handle(JettyServerHandlerCollection.java:80)
      	at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:690)
      	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
      	at org.eclipse.jetty.server.Server.handle(Server.java:503)
      	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:364)
      	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
      	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
      	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
      	at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
      	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
      	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
      	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
      	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
      	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
      	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
      	at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
      	at java.lang.Thread.run(Thread.java:748)
      
      [200] Apr 24, 2019 1:49:11.788 PM org.forgerock.openidm.servlet.internal.ServletConnectionFactory$3 lambda$handleRequestWithLogging$8
      WARNING: Resource exception: 500 Internal Server Error: "Operation CREATE failed with ConnectorException on system object"
      org.forgerock.json.resource.InternalServerErrorException: Operation CREATE failed with ConnectorException on system object
      	at org.forgerock.openidm.provisioner.openicf.impl.ExceptionHelper.adaptConnectorException(ExceptionHelper.java:159)
      	at org.forgerock.openidm.provisioner.openicf.impl.ObjectClassResourceProvider.handleCreate(ObjectClassResourceProvider.java:289)
      	at org.forgerock.openidm.provisioner.openicf.impl.ObjectClassRequestHandler.handleCreate(ObjectClassRequestHandler.java:100)
      	at org.forgerock.json.resource.Router.handleCreate(Router.java:265)
      	at org.forgerock.json.resource.FilterChain$Cursor.handleCreate(FilterChain.java:65)
      	at org.forgerock.json.resource.ResourceApiVersionRoutingFilter.filterCreate(ResourceApiVersionRoutingFilter.java:47)
      	at org.forgerock.json.resource.FilterChain$Cursor.handleCreate(FilterChain.java:63)
      	at org.forgerock.json.resource.FilterChain.handleCreate(FilterChain.java:232)
      	at org.forgerock.json.resource.Router.handleCreate(Router.java:265)
      	at org.forgerock.json.resource.FilterChain$Cursor.handleCreate(FilterChain.java:65)
      	at org.forgerock.json.resource.Filters$ConditionalFilter.filterCreate(Filters.java:54)
      	at org.forgerock.json.resource.Filters$ConditionalFilter.filterCreate(Filters.java:52)
      	at org.forgerock.json.resource.FilterChain$Cursor.handleCreate(FilterChain.java:63)
      	at org.forgerock.openidm.authz.DelegatedAdminFilter.lambda$filterCreate$1(DelegatedAdminFilter.java:189)
      	at org.forgerock.util.promise.Promises$CompletedPromise.thenAsync(Promises.java:263)
      	at org.forgerock.util.promise.Promises$CompletedPromise.thenAsync(Promises.java:227)
      	at org.forgerock.openidm.authz.DelegatedAdminFilter.filterRequest(DelegatedAdminFilter.java:252)
      	at org.forgerock.openidm.authz.DelegatedAdminFilter.filterCreate(DelegatedAdminFilter.java:188)
      	at org.forgerock.json.resource.Filters$ConditionalFilter.filterCreate(Filters.java:52)
      	at org.forgerock.json.resource.FilterChain$Cursor.handleCreate(FilterChain.java:63)
      	at org.forgerock.openidm.authz.DelegatedAdminFilter.lambda$filterCreate$1(DelegatedAdminFilter.java:189)
      	at org.forgerock.util.promise.Promises$CompletedPromise.thenAsync(Promises.java:263)
      	at org.forgerock.util.promise.Promises$CompletedPromise.thenAsync(Promises.java:227)
      	at org.forgerock.openidm.authz.DelegatedAdminFilter.filterRequest(DelegatedAdminFilter.java:252)
      	at org.forgerock.openidm.authz.DelegatedAdminFilter.filterCreate(DelegatedAdminFilter.java:188)
      	at org.forgerock.json.resource.Filters$ConditionalFilter.filterCreate(Filters.java:52)
      	at org.forgerock.json.resource.FilterChain$Cursor.handleCreate(FilterChain.java:63)
      	at org.forgerock.openidm.audit.filter.AuditFilter.lambda$filterCreate$1(AuditFilter.java:121)
      	at org.forgerock.openidm.audit.filter.AuditFilter.logAuditAccessEntry(AuditFilter.java:171)
      	at org.forgerock.openidm.audit.filter.AuditFilter.filterCreate(AuditFilter.java:121)
      	at org.forgerock.openidm.router.filter.MutableFilterDecorator.filterCreate(MutableFilterDecorator.java:72)
      	at org.forgerock.json.resource.Filters$ConditionalFilter.filterCreate(Filters.java:52)
      	at org.forgerock.json.resource.FilterChain$Cursor.handleCreate(FilterChain.java:63)
      	at org.forgerock.openidm.servlet.internal.ServletConnectionFactory$3.lambda$filterCreate$1(ServletConnectionFactory.java:379)
      	at org.forgerock.openidm.servlet.internal.ServletConnectionFactory$3.handleRequestWithLogging(ServletConnectionFactory.java:430)
      	at org.forgerock.openidm.servlet.internal.ServletConnectionFactory$3.filterCreate(ServletConnectionFactory.java:379)
      	at org.forgerock.json.resource.FilterChain$Cursor.handleCreate(FilterChain.java:63)
      	at org.forgerock.openidm.router.filter.PassthroughFilter.filterCreate(PassthroughFilter.java:48)
      	at org.forgerock.openidm.router.filter.MutableFilterDecorator.filterCreate(MutableFilterDecorator.java:72)
      	at org.forgerock.openidm.router.filter.MutableFilterDecorator.filterCreate(MutableFilterDecorator.java:72)
      	at org.forgerock.json.resource.FilterChain$Cursor.handleCreate(FilterChain.java:63)
      	at org.forgerock.openidm.router.filter.PassthroughFilter.filterCreate(PassthroughFilter.java:48)
      	at org.forgerock.openidm.router.filter.MutableFilterDecorator.filterCreate(MutableFilterDecorator.java:72)
      	at org.forgerock.json.resource.Filters$ConditionalFilter.filterCreate(Filters.java:52)
      	at org.forgerock.json.resource.FilterChain$Cursor.handleCreate(FilterChain.java:63)
      	at org.forgerock.json.resource.FilterChain.handleCreate(FilterChain.java:232)
      	at org.forgerock.json.resource.InternalConnection.createAsync(InternalConnection.java:40)
      	at org.forgerock.json.resource.AbstractConnectionWrapper.createAsync(AbstractConnectionWrapper.java:101)
      	at org.forgerock.openidm.servlet.internal.ServletConnectionFactory$InternalConnectionWrapper.lambda$createAsync$1(ServletConnectionFactory.java:297)
      	at org.forgerock.openidm.metrics.MetricsCollector.time(MetricsCollector.java:112)
      	at org.forgerock.openidm.servlet.internal.ServletConnectionFactory$InternalConnectionWrapper.time(ServletConnectionFactory.java:286)
      	at org.forgerock.openidm.servlet.internal.ServletConnectionFactory$InternalConnectionWrapper.createAsync(ServletConnectionFactory.java:297)
      	at org.forgerock.json.resource.http.RequestRunner.visitCreateRequest(RequestRunner.java:160)
      	at org.forgerock.json.resource.http.RequestRunner.visitCreateRequest(RequestRunner.java:84)
      	at org.forgerock.json.resource.Requests$CreateRequestImpl.accept(Requests.java:254)
      	at org.forgerock.json.resource.http.RequestRunner.handleResult(RequestRunner.java:132)
      	at org.forgerock.util.promise.Promises$CompletedPromise.thenAsync(Promises.java:263)
      	at org.forgerock.util.promise.Promises$CompletedPromise.thenAsync(Promises.java:252)
      	at org.forgerock.json.resource.http.HttpAdapter.doRequest(HttpAdapter.java:739)
      	at org.forgerock.json.resource.http.HttpAdapter.doCreate(HttpAdapter.java:572)
      	at org.forgerock.json.resource.http.HttpAdapter.handle(HttpAdapter.java:297)
      	at org.forgerock.http.handler.Handlers$HandlerDescribableAsDescribableHandler.handle(Handlers.java:146)
      	at org.forgerock.http.filter.OptionsFilter.filter(OptionsFilter.java:69)
      	at org.forgerock.http.handler.Handlers$1.handle(Handlers.java:53)
      	at org.forgerock.http.routing.Router.handle(Router.java:100)
      	at org.forgerock.http.swagger.OpenApiRequestFilter.filter(OpenApiRequestFilter.java:63)
      	at org.forgerock.http.handler.Handlers$1.handle(Handlers.java:53)
      	at org.forgerock.openidm.auth.ProfileEnhancementCheckFilter.filter(ProfileEnhancementCheckFilter.java:145)
      	at org.forgerock.http.handler.Handlers$1.handle(Handlers.java:53)
      	at org.forgerock.openidm.auth.LoginCountFilter.filter(LoginCountFilter.java:60)
      	at org.forgerock.http.handler.Handlers$1.handle(Handlers.java:53)
      	at org.forgerock.caf.authentication.framework.AuthenticationFramework.grantAccess(AuthenticationFramework.java:188)
      	at org.forgerock.caf.authentication.framework.AuthenticationFramework.lambda$onValidateRequestSuccess$1(AuthenticationFramework.java:181)
      	at org.forgerock.util.promise.Promises$CompletedPromise.thenAsync(Promises.java:263)
      	at org.forgerock.util.promise.Promises$CompletedPromise.thenAsync(Promises.java:252)
      	at org.forgerock.caf.authentication.framework.AuthenticationFramework.validateRequest(AuthenticationFramework.java:144)
      	at org.forgerock.caf.authentication.framework.AuthenticationFramework.processMessage(AuthenticationFramework.java:134)
      	at org.forgerock.caf.authentication.framework.AuthenticationFilter.filter(AuthenticationFilter.java:84)
      	at org.forgerock.openidm.auth.AuthFilterWrapper.filter(AuthFilterWrapper.java:85)
      	at org.forgerock.http.handler.Handlers$1.handle(Handlers.java:53)
      	at org.forgerock.http.filter.TransactionIdInboundFilter.filter(TransactionIdInboundFilter.java:86)
      	at org.forgerock.http.handler.Handlers$1.handle(Handlers.java:53)
      	at org.forgerock.http.servlet.HttpFrameworkServlet.service(HttpFrameworkServlet.java:264)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
      	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)
      	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)
      	at org.eclipse.jetty.servlets.CrossOriginFilter.handle(CrossOriginFilter.java:311)
      	at org.eclipse.jetty.servlets.CrossOriginFilter.doFilter(CrossOriginFilter.java:265)
      	at sun.reflect.GeneratedMethodAccessor110.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.forgerock.openidm.servletregistration.impl.ServletRegistrationSingleton$FilterProxy.invoke(ServletRegistrationSingleton.java:302)
      	at com.sun.proxy.$Proxy70.doFilter(Unknown Source)
      	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1634)
      	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)
      	at org.ops4j.pax.web.service.jetty.internal.HttpServiceServletHandler.doHandle(HttpServiceServletHandler.java:71)
      	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
      	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
      	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
      	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
      	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
      	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
      	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1340)
      	at org.ops4j.pax.web.service.jetty.internal.HttpServiceContext.doHandle(HttpServiceContext.java:293)
      	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
      	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
      	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
      	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
      	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1242)
      	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
      	at org.ops4j.pax.web.service.jetty.internal.JettyServerHandlerCollection.handle(JettyServerHandlerCollection.java:80)
      	at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:690)
      	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
      	at org.eclipse.jetty.server.Server.handle(Server.java:503)
      	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:364)
      	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
      	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
      	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
      	at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
      	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
      	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
      	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
      	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
      	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
      	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
      	at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
      	at java.lang.Thread.run(Thread.java:748)
      Caused by: org.identityconnectors.framework.common.exceptions.ConnectorException: Can not create account 'null'.
      	at org.identityconnectors.databasetable.DatabaseTableConnector.create(DatabaseTableConnector.java:326)
      	at org.identityconnectors.framework.impl.api.local.operations.CreateImpl.create(CreateImpl.java:88)
      	at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.identityconnectors.framework.impl.api.local.operations.ConnectorAPIOperationRunnerProxy.invoke(ConnectorAPIOperationRunnerProxy.java:104)
      	at com.sun.proxy.$Proxy76.create(Unknown Source)
      	at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.identityconnectors.framework.impl.api.local.operations.ThreadClassLoaderManagerProxy.invoke(ThreadClassLoaderManagerProxy.java:96)
      	at com.sun.proxy.$Proxy76.create(Unknown Source)
      	at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.identityconnectors.framework.impl.api.DelegatingTimeoutProxy.invoke(DelegatingTimeoutProxy.java:98)
      	at com.sun.proxy.$Proxy76.create(Unknown Source)
      	at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.identityconnectors.framework.impl.api.local.LocalConnectorFacadeImpl$ReferenceCountingProxy.invoke(LocalConnectorFacadeImpl.java:304)
      	at com.sun.proxy.$Proxy76.create(Unknown Source)
      	at org.identityconnectors.framework.impl.api.AbstractConnectorFacade.create(AbstractConnectorFacade.java:210)
      	at org.forgerock.openidm.provisioner.openicf.impl.ObjectClassResourceProvider.handleCreate(ObjectClassResourceProvider.java:278)
      	... 125 more
      Caused by: java.sql.SQLException: Field 'UNIQUE_ID' doesn't have a default value
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
      	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
      	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
      	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
      	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199)
      	at org.identityconnectors.databasetable.DatabaseTableConnector.create(DatabaseTableConnector.java:314)
      	... 148 more
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                petr.jurica Petr Jurica
                Reporter:
                michal.orlik@profiq.cz Michal Orlik
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: