Sybase DB details of BOBJ system not available in Solman

[Former Member]

Dear Experts,

I am configuring a BOBJ system with a sybase DB in our Solution Manager landscape. I used AC tool to push the data to SLD. The system details (BOE & Tomcat) are available in Solman system, however the DB details are not getting transferred. Based on SAP suggestion, we installed SAPTOOLS in the sybase DB and tried to push the data again. However, the DB data is still not getting pushed. Please let me know if you have faced similar issue and have resolved them.

The diagnostic agent has the following log in the e2edcc_db.0.log file,

Apr 19, 2016 6:53:40 AM [Thread[ExRun:OutsideDiscovery_1,5,OutsideDiscovery:ExecTG]] Info

[DatabaseInfoPushJob] Check cached database information for Database[BOP][BOP]

[syb]

Apr 19, 2016 6:53:40 AM [Thread[ExRun:OutsideDiscovery_1,5,OutsideDiscovery:ExecTG]] Info	[DatabaseInfoPushJob] Database information do not require update.
Apr 19, 2016 6:53:40 AM [Thread[ExRun:OutsideDiscovery_1,5,OutsideDiscovery:ExecTG]] Info	[DatabaseInfoPushJob] end.
Apr 19, 2016 7:08:39 AM [Thread[ExRun:OutsideDiscovery_1,5,OutsideDiscovery:ExecTG]] Info	[DatabaseInfoPushJob] wakeup
Apr 19, 2016 7:08:40 AM [Thread[ExRun:OutsideDiscovery_1,5,OutsideDiscovery:ExecTG]] Error	[DatabaseInfoPushJob] Exception getting dbProperties

[EXCEPTION]

javax.xml.rpc.soap.SOAPFaultException: Database user authentication failed: No access to SecureStore or DB_CONNECT/SYB/SADB_USER or DB_CONNECT/SYB/SADB_PASSWORD is missing in

SecureStore or password is incorrect. Provide credentials for user sapsa via command input or provide access to SecureStore.

	at com.sap.engine.services.webservices.jaxrpc.wsdl2java.soapbinding.MimeHttpBinding.buildFaultException(MimeHttpBinding.java:747)
	at com.sap.engine.services.webservices.jaxrpc.wsdl2java.soapbinding.MimeHttpBinding.processDocumentFault(MimeHttpBinding.java:870)
	at com.sap.engine.services.webservices.jaxrpc.wsdl2java.soapbinding.MimeHttpBinding.call(MimeHttpBinding.java:1454)
	at com.sap.smd.agent.wsclients.saphostcontrol.SAPHostControlStub.getDatabaseProperties(SAPHostControlStub.java:1300)
	at com.sap.smd.agent.wsclients.saphostcontrol.SAPHostControlStub.getDatabaseProperties(SAPHostControlStub.java:1316)
	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:597)
	at com.sap.smd.api.util.SynchronizedProxy$SyncHandler.invoke(SynchronizedProxy.java:32)
	at com.sap.smd.agent.facade.hostagent.HostAgentSyncProxy$SyncHandler.singleInvoke(HostAgentSyncProxy.java:144)
	at com.sap.smd.agent.facade.hostagent.HostAgentSyncProxy$SyncHandler.invoke(HostAgentSyncProxy.java:87)
	at com.sun.proxy.$Proxy4.getDatabaseProperties(Unknown Source)
	at com.sap.smd.agent.plugins.dcc.job.DatabaseInfoPushJob.getDatabaseProperties(DatabaseInfoPushJob.java:295)
	at com.sap.smd.agent.plugins.dcc.job.DatabaseInfoPushJob.run(DatabaseInfoPushJob.java:183)
	at com.sap.smd.server.exec.TaskRunner.run(TaskRunner.java:47)
	at com.sap.smd.server.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:785)
	at java.lang.Thread.run(Thread.java:763)

P.S. - The BOBJ system version is BOE 4.0 SP4 and the DB version is 15.7.0.101

Thanks,

Vivek

[Former Member]

hello Seshadri,

Please make sue that you have check following link.

It will give you more insight

Managed System Setup of BOE 4.0 system in Solman 7.1 - SAP Solution Manager Setup - SCN Wiki

regards

Anand

[yakcinar]

Hello Vivek,

Did Setup DBA Cockpit Connection run without errors on Managed System Config Enter System Parameters phase?

Can you check also extractors for BOBJ System from WCenter SolMan Administration, Infrastructure and Extractor Framework? Is there any errors for BOBJ system?

Regards,

Yuksel AKCINAR