After removing a managed system i get errors in sm21

[denny-k]

Hi experts.

I removed a java-system from our solman (with sid "jas") and now i get still errors in sm21 all the time:

08:00:50 DIA  004 010 SM_EFWK	BY  2 Database error 12154 at CON
08:00:50 DIA  004 010 SM_EFWK	BY  0 > con=2(sapjas:1521/JAS): ORA-12154: TNS:could not
08:00:50 DIA  004 010 SM_EFWK	BY  0 > resolve the connect identifier specified
08:00:50 DIA  004 010 SM_EFWK	BY  1 Database error 12154
08:01:50 DIA  004 010 SM_EFWK	BY  2 Database error 12154 at CON

I removed the system from the lmdb, cannot the system in smsy anymore.

also in "managed system configuration" and techincal monitroing in solman_workcenter.

from my side i cannot see it anymore but still get those errors.

any ideas? thank you in advance!

EDIT:

i see in "technical monitoring" at "technical maintenance / technical system" the JAS ! but does that matter?

I deleted it also from the SLD.

[former_member186752 · Accepted solution]

Hello Dennis

Here are some points to be checked:

- remove the extractors (and monitoring if configured)

- remove the logical component and adapt the solution accordingly

- cleanup the SLD (SLD - LMDB synch job will run)

- check and cleanup LMDB (after the synch job was successfully executed)

- DBACOCKPIT remove the connection to the system; pay attention here: there are 2 entries that must be removed (first entry when you call TA DBACOCKPIT and second entry when you select Database connections [under system landscape on the left side])

Might have missed something but basically this is the cleanup procedure.

Cheers

Marian

[denny-k · Accepted solution]

Hello Marian

Thank you fot the the point with the second entry in dbacockpit!

I deleted the system there and until one hour and an half i got no errors in sm21.

I think that was it, thank you very much.

[denny-k · Accepted solution]

Under solman_workcenter / technical monitoring / template maintenance --> i still see under techical system the system with the assigned template "SAP Early Watch Alerts". Do you have an idea for this point, too? Thank you in advance

[former_member186752 · Accepted solution]

For better understanding: would it be possible to attach a screenshot?

[denny-k · Accepted solution]

Yes:

[Former Member]

Hello Dennis,

Check note 1840919 - EFWK RESOURCE MANAGER - DB extractor - Error messages during managed system offline backup

BR,

K.

[Reagan]

Check whether there is still an entry in the DBCON table.

Regards

RB

[Former Member]

Hi Dennis,

You also need to remove the Hosts also from LMDB. because normally CCDB stores the host and DB informations separately. hence you should remove them.

LMDB -> HOST remove DB and application host from there.

check in DBACOCKPIT , if you have your DB connected to solman, remove from there to.

Also make sure before you delete in LMDB, you were  moved the corresponding entries in SLD.

Thanks

Jansi

[denny-k]

Thank you!

I removed it from dbacockpit.

Edit: I got still the same errors.

It is removed from the SLD.

Could you also tell me how could i get the entry from sap early watch alert away? see atachment and thank you in advance

[denny-k]

The system is not anymore in the lmdb.. it is neither in the sld.

but i get still the errors in sm21.

[Former Member]

Hi Dennis,

Please check the below document

https://websmp104.sap-ag.de/~sapidb/011000358700000631992012E.PDF

4.6 Solution Manager clean-up tasks for no longer relevant managed systems . 43

Please follow the step to clean up the system in solman.

Rg,

Karthik

[Former Member]

HI,

Does system JAS still exist? If not just remove from tnsnames.ora

08:00:50 DIA  004 010 SM_EFWK	BY  0 > con=2(sapjas:1521/JAS): ORA-12154: TNS:could not
08:00:50 DIA  004 010 SM_EFWK	BY  0 > resolve the connect identifier specified

Referring to oracle connection.

Kind Regards,

Johan

[denny-k]

Hi Karthik,

thank you. I followd the points (without the bw-clean). until now i got still errors in sm21.

[denny-k]

Hi Johan.

Thank you, i will ask our db-admin. but why does the solman still searching for a system i removed.