dba cockpit connection cannot be established

[Former Member]

Hi Experts,

I am getting the warning message "dba cockpit connection cannot be established" during the managed system configuration step "Enter System Parameters". See the screenshot in attachment.

Any ideas, please?

Thanks & kind regards,

Srinu

[manumohandas82]

Hi Sreenivas ,

Please check this note

2074769 - Solution Manager: Invalid alerts

This note is valid for Hana Database and the most recent once , it has valid corrections for the class CL_HDB_ADBC .. though nothing concrete is mentioned for this error

I would give it a go ..

Thanks ,

Manu

[manumohandas82]

Hi Srinu ,

I see a note in SMP  ,dont know whether this is relevant to you but might help

1827885 - DBACOCKPIT issues error 'Exception CX_DBA_ADBC in class CL_HDB_ADBC'

[Former Member]

Hi Manu,

SAP note that you mentioned above applies for Revision less than 57. I have HANA DB installed with Revision 82.

Any other ideas, please?

Thanks & kind regards,

Srinu

[divyanshu_srivastava3]

Have you try by updating the DBSL on solman system ?

Make sure this one also supports the managed system DB.

Regards,

[manumohandas82]

Hi Sreenivas  ,

What is ur SAP_BASIS release  in solution Manager . Check the following note

1674801- Implementation of MSS RDI in 702

if still the issue persists try as Divyan suggested to update the DBSL

Thanks ,

Manu

[Former Member]

Hi Srivastava,

I see that the DBSL has already green tick mark in DB02 in SolMan for HANA Managed system. Actually, i have an issue "Exception CX_DBA_ADBC in class CL_HDB_ADBC method GET_TABLES line 40 / RC=ADBC" (see screenshot in previous responses) after creating the managed system entry in DB02 of SolMan.

Any other ideas, please?

Thanks & best regards,

Srinu

[manumohandas82]

Hi Sreenivasa ,

Try to do the DB connection manually .

1 ) go to transaction db02 in solution manager

2 ) Under system configuration  , Click Add

3 ) Enter the  Hana DB  connectivity data

4 ) If the connection goes fine .. continue the activity in Managed System setup in solution manager

Try this and if errors happen in 3 or 4  attach the screenshots

Thanks ,

Manu

[Former Member]

Hi Manu,

I am getting error "Exception CX_DBA_ADBC in class CL_HDB_ADBC method GET_TABLES line 40 / RC=ADBC" after performing the steps that you mentioned above.

More information about the error (see in attached screenshot).

Any ideas, please?

Thanks & best regards,

Srinu

[manumohandas82]

Hi Srinu ,

What Database are you using for the solution manager  . From the error it seems to be sybase / DB2

If it is sybase please install the following correction

1558958

If it is DB6 please install the following snote

1456402

These are set of Correction notes 

If any other let  us know

Thanks ,

Manu

[Former Member]

Hi Manu,

I am using HANA DB for managed system configuration in SolMan. In TA: DB02 of SolMan, I created system configuration entry of managed system and then saved. It ended with the same error "Exception CX_DBA_ADBC in class CL_HDB_ADBC method GET_TABLES line 40 / RC=ADBC error".

Best regards,

Srinu

[manumohandas82]

Hi sreenivas

Is the solution manager also running on Sap hana

Thanks

manu

[Former Member]

Hi Manu,

No, SolMan system running on MS SQL DB. Managed system running on HANA DB.

Thanks & best regards,

Srinu

[shriramcse]

Hi Srinu,

In the setup screen you are not getting the option to give connection Parameter , usually this case arises when DB is not present in LMDB.

Check your DB is present under "Database System" in LMDB.

Regards,

Sriram

[Former Member]

Hi Mani,

I see that the DB system is available in LMDB.

For your information, the managed system is a SAP NW 7.4 HANA system. In our case, we have two different SID's, one for SAP GUI System and other for HANA DB. Both are installed on different server hosts.

Any other ideas, please?

Thanks & best regards,

Srinu

[manoj_nayak2]

Hi Srinu,

Please check below URL

http://wiki.scn.sap.com/wiki/display/SMSETUP/Managed+System+Setup+of+HANA+in+Solution+Manager+7.1

Regards,

Manoj

[Former Member]

Hi Manoj,

I already have this document.

Any other ideas, please?

Thanks & best regards,

Srinu