Self check issues Solution Manager Diagnostics

[Former Member]

Hi all,

After installing diagnostics on SM 4.0 SPS 13 i have run a self check.

Everything is ok except for three issues:

1:

Sol2 / Production System - NW1 (0020255009) Failed SQL Command Console Database Configuration Never Succeeded

1 error(s) found:

Global property config.db.000000011000100|P|01200615320900001250|NW1-0020255009|Application Server ABAP-01200314690800000134-1 was not found

2:

Sol2 / Production System - NW1 (0020255009) Failed SQL Command Console Database Configuration Never Succeeded

1 error(s) found:

The test was not successfull [dbID:config.db.000000011000100|P|01200615320900001250|NW1-0020255009|Application Server Java-01200314690800000134-2,agent:nw01,sid:NW1] Problem in getManualDatabaseConfiguration:; nested exception is:

java.lang.ClassNotFoundException:

3:

Sol2 / Production System - NW1 (0020255009)

- Type: Dispatcher - Node ID: 17002900

- Host: NW01 Failed Dispatcher Connectivity Never Succeeded

Cannot initialize the Check 'Connectivity'!

com.sap.sup.admin.selfcheck.exception.CheckInitializationException: Cannot resolve the '$' environment variable: Cannot find the Http Configuration Handler! at com.sap.sup.admin.selfcheck.check.remote.http.HttpCheck.init(HttpCheck.java:131) at com.sap.sup.admin.selfcheck.check.AbstractCheck.process(AbstractCheck.java:143) at sun.reflect.GeneratedMethodAccessor307.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.sap.smd.server.exec.asio.AsioInvocationHandler$1.call(AsioInvocationHandler.java:87) at com.sap.smd.server.util.concurrent.FutureResult$1.run(FutureResult.java:90) at com.sap.smd.server.exec.asio.AsioInvocationHandler$AsioRunner.run(AsioInvocationHandler.java:266) at com.sap.smd.server.exec.TaskRunner.run(TaskRunner.java:45) at com.sap.smd.server.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:785) at java.lang.Thread.run(Thread.java:534) Caused by: com.sap.sup.admin.selfcheck.exception.EnvironmentVariableNotFoundException: Cannot resolve the '$' environment variable: Cannot find the Http Configuration Handler!

at com.sap.sup.admin.selfcheck.env.impl.RemotePortEnvironmentVariable.resolve(RemotePortEnvironmentVariable.java:62)

at com.sap.sup.admin.selfcheck.env.AbstractEnvironmentVariable.resolve(AbstractEnvironmentVariable.java:24)

at com.sap.sup.admin.selfcheck.env.EnvironmentVariableHandler.resolveEnvironmentVariable(EnvironmentVariableHandler.java:91)

at com.sap.sup.admin.selfcheck.check.remote.http.HttpCheck.init(HttpCheck.java:126)

... 10 more

Caused by: com.sap.sup.admin.landscape.configuration.exception.ConfigurationHandlerNotFoundException: Cannot find the config store list '[[IConfigStore: key=null, name=http.properties, path=dispatcher/configuration/services, type=null, alias=null, update=null, creation=null, crc=0, absolute=null]]' belonging to the configuration handler 'com.sap.sup.admin.landscape.configuration.handler.http.HttpHandler' below the landscape '[IInstance: key=1199884712360902, type=[Dispatcher], nodeId=17002900, creation=Wed Jan 09 14:18:31 CET 2008]'!

at com.sap.sup.admin.landscape.configuration.ConfigurationHandlerManager.createConfigurationHandler(ConfigurationHandlerManager.java:287)

at com.sap.sup.admin.landscape.configuration.ConfigurationHandlerManager.getConfigurationHandler(ConfigurationHandlerManager.java:137)

at com.sap.sup.admin.landscape.impl.AbstractStores.getConfigurationHandler(AbstractStores.java:583)

at com.sap.sup.admin.selfcheck.env.impl.RemotePortEnvironmentVariable.resolve(RemotePortEnvironmentVariable.java:55)

... 13 more

I can't find any documentation how to solve these issues. Can you please help me out?

Regards,

Koen Engelen

[Former Member · Accepted solution]

Hi Koen,

For issue 1 and 2 please apply sap note 1075276 to configure sql command console properly.

For issue 3, the variable REMOTE_PORT corresponds to the http port of the dispatcher. It means that the collect configuration data task did not run properly for this host, please check the result of the task.

Regards,

Luc

[Former Member · Accepted solution]

Hi Luc,

Thanks for replying to my questions. Implementing the note you suggested solved the first two issues. I will log a new question for the new issue as stated below.

Category: /Applications/AdminConsole/Scheduler

Location: com.sap.sup.admin.scheduler.JmsScheduler

Application: sap.com/tc_{webadministrator}scheduler~ejb

Thread: SAPEngine_Application_Thread[impl:3]_22

Data Source: D:\usr\sap\SO1\DVEBMGS01\j2ee\cluster\server0\log\defaultTrace.trc

Message ID: 00188BF8D66300600000000E0000100C0004435B00EFD9CE

Argument Objects: com.sap.sup.admin.scheduler.exception.FatalTaskExecutionException: 1 error(s) occured during abap configuration data collect on monitored host [nw01]. Check logs for details.

at com.sap.sup.admin.scheduler.task.remote.config.ConfigGatherTask.process_AbapConfiguration(ConfigGatherTask.java:340)

at com.sap.sup.admin.scheduler.task.remote.config.ConfigGatherTask.process(ConfigGatherTask.java:148)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.sap.smd.server.exec.asio.AsioInvocationHandler$1.call(AsioInvocationHandler.java:87)

at com.sap.smd.server.util.concurrent.FutureResult$1.run(FutureResult.java:90)

at com.sap.smd.server.exec.asio.AsioInvocationHandler$AsioRunner.run(AsioInvocationHandler.java:266)

at com.sap.smd.server.exec.TaskRunner.run(TaskRunner.java:45)

at com.sap.smd.server.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:785)

at java.lang.Thread.run(Thread.java:534)

Caused by: java.lang.Exception: Error collecting abap system [sid:NW1] [install:0020255009].

at com.sap.sup.admin.upload.abapconfig.provider.AbapConfigurationProvider.collectAbapConfigurationContent(AbapConfigurationProvider.java:332)

at com.sap.sup.admin.upload.abapconfig.provider.AbapConfigurationProvider.collectAbapConfiguration(AbapConfigurationProvider.java:266)

at com.sap.sup.admin.upload.abapconfig.provider.AbapConfigurationProvider.collectAndStoreAbapConfiguration(AbapConfigurationProvider.java:199)

at com.sap.sup.admin.scheduler.task.remote.config.ConfigGatherTask.process_AbapConfiguration(ConfigGatherTask.java:287)

... 11 more

Caused by: com.sap.mw.jco.JCO$Exception: (104) RFC_ERROR_SYSTEM_FAILURE: Table does not exist in database.

at com.sap.mw.jco.MiddlewareJRfc.generateJCoException(MiddlewareJRfc.java:455)

at com.sap.mw.jco.MiddlewareJRfc$Client.execute(MiddlewareJRfc.java:1442)

at com.sap.mw.jco.JCO$Client.execute(JCO.java:3979)

at com.sap.mw.jco.JCO$Client.execute(JCO.java:3416)

at com.sap.sup.admin.upload.abapconfig.provider.AbapConfigurationProvider.collectAbapConfigurationContent(AbapConfigurationProvider.java:321)

... 14 more

,

Arguments: com.sap.sup.admin.scheduler.exception.FatalTaskExecutionException: 1 error(s) occured during abap configuration data collect on monitored host [nw01]. Check logs for details.

at com.sap.sup.admin.scheduler.task.remote.config.ConfigGatherTask.process_AbapConfiguration(ConfigGatherTask.java:340)

at com.sap.sup.admin.scheduler.task.remote.config.ConfigGatherTask.process(ConfigGatherTask.java:148)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.sap.smd.server.exec.asio.AsioInvocationHandler$1.call(AsioInvocationHandler.java:87)

at com.sap.smd.server.util.concurrent.FutureResult$1.run(FutureResult.java:90)

at com.sap.smd.server.exec.asio.AsioInvocationHandler$AsioRunner.run(AsioInvocationHandler.java:266)

at com.sap.smd.server.exec.TaskRunner.run(TaskRunner.java:45)

at com.sap.smd.server.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:785)

at java.lang.Thread.run(Thread.java:534)

Caused by: java.lang.Exception: Error collecting abap system [sid:NW1] [install:0020255009].

at com.sap.sup.admin.upload.abapconfig.provider.AbapConfigurationProvider.collectAbapConfigurationContent(AbapConfigurationProvider.java:332)

at com.sap.sup.admin.upload.abapconfig.provider.AbapConfigurationProvider.collectAbapConfiguration(AbapConfigurationProvider.java:266)

at com.sap.sup.admin.upload.abapconfig.provider.AbapConfigurationProvider.collectAndStoreAbapConfiguration(AbapConfigurationProvider.java:199)

at com.sap.sup.admin.scheduler.task.remote.config.ConfigGatherTask.process_AbapConfiguration(ConfigGatherTask.java:287)

... 11 more

Caused by: com.sap.mw.jco.JCO$Exception: (104) RFC_ERROR_SYSTEM_FAILURE: Table does not exist in database.

at com.sap.mw.jco.MiddlewareJRfc.generateJCoException(MiddlewareJRfc.java:455)

at com.sap.mw.jco.MiddlewareJRfc$Client.execute(MiddlewareJRfc.java:1442)

at com.sap.mw.jco.JCO$Client.execute(JCO.java:3979)

at com.sap.mw.jco.JCO$Client.execute(JCO.java:3416)

at com.sap.sup.admin.upload.abapconfig.provider.AbapConfigurationProvider.collectAbapConfigurationContent(AbapConfigurationProvider.java:321)

... 14 more

,

DSR Component: n/a

DSR Transaction: c7887740bf5f11dc893b00188bf8d663

DSR User: n/a

Message Code: n/a

Session: 0

Transaction: n/a

User: J2EE_GUEST

Host: so1

System: SO1

Instance: 01

Node: Server 0 1_17087

Edited by: Koen Engelen on Jan 11, 2008 11:40 AM

[Former Member]

Hi Koen,

Have you check RFC connection with all the systems, I think problem seems to be with your RFC connection.

Regards,

Rajesh