Setting up IDM UI - errors

[Former Member]

Hi Experts,

We have installed IDM 7.2 and IDM UI. We have done the configuration for IDM UI as per the installation and configuration IDM UI guide. As in IDM 7.2, the user authentication will be done from UME database, i have created a user and assigned idm.authenticated role to the user. Even after  that, we are not able to login to the IDM UI, getting " Access Denied, Service Down" message. I have followed the steps in SAP NOTES 1573750 to fix the issue. everything is fine. But still we have the same issue. Please help.

Regards,

Krishna.

[Former Member · Accepted solution]

Hello Krishna,

Please ensure that the data source name is given as "IDM_DataSource" , "s" in Source should be in capital.

Thanks,

Dev

[former_member2987]

Krishna,

Make sure you have imported the SCA files and done the NW Configuration to set the keys.ini location.

Regards,

Matt

[Former Member]

Hello Matt,

Can you please let me know, which document I have to look into for importing of SCA files and NW Configuration to set keys.ini location.

Many Thanks,

Krish.

[Former Member]

Hello Matt, DevPriy, Chris,

Thanks for your helpful suggestions. I am able to resolve the issue. I have jus reconfigured the IDM_DataSource and it worked.

The IDM UI is up now. But I have a task created. When I click on the task, I am getting the following error.

Could not get schema for task 103Create User

Can you please help me to get it resolved.

[former_member2987]

Krishna,

http://scn.sap.com/docs/DOC-8397 is a good place to start.  There is a separate link if you are using NW IDM 7.1.

Probably the most helpful read for your question is:

SAP NetWeaver® Identity Management Identity Center Installing and configuring the Identity Management User Interface

[Former Member]

Hello Matt,

The installation and configuration of UI, is in par with the document you have mentined. I have validated each step. To investigate further, I have examined the server logs, and I am getting the error as attached & show below. We have installed IDM databse on SQL server 2008. If we maintain IDM Database on SQL Server 2005, will that solve my issue ?

#2.0#2012 08 23 14:02:33:723#+0530#Error#com.sap.sql.jdbc.direct.DirectPreparedStatement#
#BC-JAS-PER-SQL#opensqlkernel#C000AC1979E200990000000200007234#73607450000000004#sap.com/tc~idm~wd~workflow#com.sap.sql.jdbc.direct.DirectPreparedStatement#21008#6##88AE0F60ECFC11E1B21D00000463291A#d4e6bce3ecfc11e1ab4500000463291a#d4e6bce3ecfc11e1ab4500000463291a#0#Thread[HTTP Worker [@2102414971],5,Dedicated_Application_Thread]#Plain##
SQL error occurred on connection CCH1WPSAP1:mxmc_db:mxmc_oper_u: code=207, state="S0001", message="Invalid column name 'atDirectOnly'.";
SQL statement is "SELECT attr_id, AttrName, Min_len, Max_len, Access_code, required_attr, encrypted_attr, display_name, datatypeid, presentationtypeid, MixedChar, CharNumb, ConfInput, HiddenInput, ToolTip, ExternalIndication, ExternalRepository, ExternalReference, SQLValues, MultiValue, ReferenceObjectClass, atNumRows, SqlAccessTask, atMaxNumToShow, task_required_attr, atDefaultShow, task_access_code, display_order, listed, DefaultValue, task_display_name, task_ConfInput, task_ToolTip, task_HiddenInput, task_SQLValues, LayoutAttr, task_SqlAccessTask,SqlValuesTable,SqlValuesId, SqlValuesUseLanguage, task_SqlValuesTable, task_SqlValuesId, task_SqlValuesUseLanguage, uniquevalue, owner_id, task_regexvalidate, regexvalidate, multivaluesearch,serverfunction, atDirectOnly, atShowFuture, atStatusFilter, task_atDirectOnly, task_atShowFuture, task_atStatusFilter, atFilterReadOnly, task_atFilterReadOnly, atDefaultFilter, task_atDefaultFilter, atShowAdvancedSearch, task_atShowAdvancedSearch, atEntryTypeSelect, task_atEntryTypeSelect FROM MXWV_TaskAttributes where taskid=? order by display_order".
[EXCEPTION]
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'atDirectOnly'.
                at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
                at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
                at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
                at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
                at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
                at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
                at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
                at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
                at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
                at com.sap.sql.jdbc.basic.BasicPreparedStatement.executeQuery(BasicPreparedStatement.java:102)
                at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeQuery(DirectPreparedStatement.java:313)
                at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeQuery(DirectPreparedStatement.java:270)
                at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:345)
                at com.sap.idm.jmx.ic.TaskUtil.getAttributes(TaskUtil.java:1993)
                at com.sap.idm.jmx.ic.TaskUtil.getTaskSchema(TaskUtil.java:1765)
                at com.sap.idm.jmx.ic.TaskUtil.getTaskSchema(TaskUtil.java:1737)
                at com.sap.idm.jmx.ic.EntryUtil.getEntry(EntryUtil.java:900)
                at com.sap.idm.jmx.impl.SAP_ITSAM_IDM_Service_Impl_Impl.retrieveEntry(SAP_ITSAM_IDM_Service_Impl_Impl.java:598)
                at com.sap.idm.jmx.SAP_ITSAM_IDM_ServiceWrapper.invoke(SAP_ITSAM_IDM_ServiceWrapper.java:832)
                at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:836)
                at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:761)
                at com.sap.pj.jmx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:468)
                at com.sap.pj.jmx.server.interceptor.MBeanServerWrapperInterceptor.invoke(MBeanServerWrapperInterceptor.java:288)
                at com.sap.engine.services.jmx.CompletionInterceptor.invoke(CompletionInterceptor.java:547)
                at com.sap.pj.jmx.server.interceptor.BasicMBeanServerInterceptor.invoke(BasicMBeanServerInterceptor.java:277)
                at com.sap.jmx.provider.ProviderInterceptor.invoke(ProviderInterceptor.java:365)
                at com.sap.engine.services.jmx.RedirectInterceptor.invoke(RedirectInterceptor.java:340)
                at com.sap.pj.jmx.server.interceptor.MBeanServerInterceptorChain.invoke(MBeanServerInterceptorChain.java:367)
                at com.sap.engine.services.jmx.MBeanServerSecurityWrapper.invoke(MBeanServerSecurityWrapper.java:289)
                at com.sap.engine.services.jmx.ClusterInterceptor.invoke(ClusterInterceptor.java:813)
                at com.sap.pj.jmx.server.interceptor.MBeanServerInterceptorChain.invoke(MBeanServerInterceptorChain.java:367)
                at com.sap.idm.wd.jmx.SAP_ITSAM_IDM_Service$Impl.retrieveEntry(SAP_ITSAM_IDM_Service.java:1022)
                at com.sap.idm.wd.modelwrapper.ModelWrapperInterface.getEntryWithAudit(ModelWrapperInterface.java:612)
                at com.sap.idm.wd.modelwrapper.ModelWrapperInterface.getEntry(ModelWrapperInterface.java:223)
                at com.sap.idm.wd.modelwrapper.wdp.InternalModelWrapperInterface.wdInvokeMethod(InternalModelWrapperInterface.java:581)
                at com.sap.tc.webdynpro.progmodel.generation.ExternalControllerPI$ExternalInterfaceInvocationHandler.invoke(ExternalControllerPI.java:339)
                at $Proxy2326.getEntry(Unknown Source)
                at com.sap.idm.wd.wf.entrydetails.EditEntry.wdDoInit(EditEntry.java:249)
                at com.sap.idm.wd.wf.entrydetails.wdp.InternalEditEntry.wdDoInit(InternalEditEntry.java:335)
                at com.sap.tc.webdynpro.progmodel.generation.DelegatingComponent.doInit(DelegatingComponent.java:161)
                at com.sap.tc.webdynpro.progmodel.controller.Controller.initController(Controller.java:227)
                at com.sap.tc.webdynpro.progmodel.components.Component.initController(Component.java:258)
                at com.sap.tc.webdynpro.progmodel.controller.Controller.init(Controller.java:206)
                at com.sap.tc.webdynpro.progmodel.components.ComponentUsage.createComponentInternal(ComponentUsage.java:418)
                at com.sap.tc.webdynpro.progmodel.components.ComponentUsage.createComponent(ComponentUsage.java:352)
                at com.sap.tc.webdynpro.progmodel.components.ComponentUsage.createComponent(ComponentUsage.java:306)
                at com.sap.idm.wd.wf.task.TaskComp.initTask(TaskComp.java:487)
                at com.sap.idm.wd.wf.task.TaskComp.wdDoInit(TaskComp.java:170)
                at com.sap.idm.wd.wf.task.wdp.InternalTaskComp.wdDoInit(InternalTaskComp.java:179)
                at com.sap.tc.webdynpro.progmodel.generation.DelegatingComponent.doInit(DelegatingComponent.java:161)
                at com.sap.tc.webdynpro.progmodel.controller.Controller.initController(Controller.java:227)
                at com.sap.tc.webdynpro.progmodel.components.Component.initController(Component.java:258)
                at com.sap.tc.webdynpro.progmodel.controller.Controller.init(Controller.java:206)
                at com.sap.tc.webdynpro.clientserver.cal.ClientApplication.init(ClientApplication.java:586)
                at com.sap.tc.webdynpro.clientserver.cal.ClientApplication.doPreprocessing(ClientApplication.java:1453)
                at com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doPreprocessing(ApplicationSession.java:658)
                at com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doProcessing(ApplicationSession.java:347)
                at com.sap.tc.webdynpro.clientserver.session.RequestManager.doProcessing(RequestManager.java:325)
                at com.sap.tc.webdynpro.serverimpl.core.AbstractDispatcherServlet.doContent(AbstractDispatcherServlet.java:87)
                at com.sap.tc.webdynpro.serverimpl.wdc.DispatcherServlet.doContent(DispatcherServlet.java:89)
                at com.sap.tc.webdynpro.serverimpl.core.AbstractDispatcherServlet.doGet(AbstractDispatcherServlet.java:55)
                at javax.servlet.http.HttpServlet.service(HttpServlet.java:734)
                at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
                at com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:152)
                at com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.doWork(RequestDispatcherImpl.java:364)
                at com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:487)
                at com.sap.tc.webdynpro.serverimpl.wdc.ForwardServlet.doPost(ForwardServlet.java:63)
                at com.sap.tc.webdynpro.serverimpl.wdc.ForwardServlet.doGet(ForwardServlet.java:31)
                at javax.servlet.http.HttpServlet.service(HttpServlet.java:734)
                at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
                at com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:152)
                at com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:38)
                at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:453)
                at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:210)
                at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:441)
                at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:430)
                at com.sap.engine.services.servlets_jsp.filters.DSRWebContainerFilter.process(DSRWebContainerFilter.java:38)
                at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
                at com.sap.engine.services.servlets_jsp.filters.ServletSelector.process(ServletSelector.java:81)
                at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
                at com.sap.engine.services.servlets_jsp.filters.ApplicationSelector.process(ApplicationSelector.java:276)
                at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
                at com.sap.engine.services.httpserver.filters.WebContainerInvoker.process(WebContainerInvoker.java:81)
                at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)
                at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
                at com.sap.engine.services.httpserver.filters.ResponseLogWriter.process(ResponseLogWriter.java:60)
                at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)
                at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
                at com.sap.engine.services.httpserver.filters.DefineHostFilter.process(DefineHostFilter.java:27)
                at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
                at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
                at com.sap.engine.services.httpserver.filters.MonitoringFilter.process(MonitoringFilter.java:29)
                at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
                at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
                at com.sap.engine.services.httpserver.filters.SessionSizeFilter.process(SessionSizeFilter.java:26)
                at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
                at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
                at com.sap.engine.services.httpserver.filters.MemoryStatisticFilter.process(MemoryStatisticFilter.java:57)
                at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
                at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
                at com.sap.engine.services.httpserver.filters.DSRHttpFilter.process(DSRHttpFilter.java:43)
                at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
                at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)
                at com.sap.engine.services.httpserver.server.Processor.chainedRequest(Processor.java:462)
                at com.sap.engine.services.httpserver.server.Processor$FCAProcessorThread.process(Processor.java:270)
                at com.sap.engine.services.httpserver.server.rcm.RequestProcessorThread.run(RequestProcessorThread.java:56)
                at com.sap.engine.core.thread.execution.Executable.run(Executable.java:122)
                at com.sap.engine.core.thread.execution.Executable.run(Executable.java:101)
                at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:328)

#

#2.0#2012 08 23 14:02:33:727#+0530#Error#com.sap.idm.jmx.ic.TaskUtil#
##sap.com/tc~idm~jmx~app#C000AC1979E200990000000300007234#73607450000000004#sap.com/tc~idm~wd~workflow#com.sap.idm.jmx.ic.TaskUtil#21008#6##88AE0F60ECFC11E1B21D00000463291A#d4e6bce3ecfc11e1ab4500000463291a#d4e6bce3ecfc11e1ab4500000463291a#0#Thread[HTTP Worker [@2102414971],5,Dedicated_Application_Thread]#Plain##
Could not get schema for task 99Assign Role:Invalid column name 'atDirectOnly'.
                OpenSQLExceptionCategories: [NON_TRANSIENT, COLUMN_UNKNOWN]#

[Former Member]

Hello ,

Am not sure about the issue but could you please check the version of JDBC driver for the respective java , refer page 13 of " SAP NetWeaver ® Identity Management Identity Center

Installation overview "

Thanks,

Dev

[Former Member]

Hi,

What version of NW AS Java did you install the UI on? 

Thanks,

Chris

[Former Member]

Hello Chris

NW AS Java is 7.3.

Regards,

Krishna.