Opening the DSM Reporter, it may happen that the error below could appear:
“The DSM Reporter is not connected to a database and a DSM domain.
The following messages were retrieved from a non-localized, detailed trace log and may be helpful in further diagnosing the problem:
Unable to Retrieve Database Properties from Manager:CSITCM00.office.corp.sia.it. COAPI Returned:249
cAmo: Domain->Init failed
Data Manager - Unable to initialize ITRM domain “
In the logs we could see the below lines
251116-14:38:42.4618403L|006764|00001d20|REPORTER |amLogAndNotify |cAmoLog.h |000387|ERROR | Unable to Retrieve Database Properties from Manager:CSITCM00.office.corp.sia.it. COAPI Returned:249
It confirms the error mentioned above
the authentication of the reporter certificate is mentioned below
251116-14:38:42.4430050L|006764|00001d20|REPORTER |CFSMCAPI |CFSMCAPI |000000|DETAIL | SmiSession::AuthenticateSessionTransact : Peer says I authenticated as x509cert://dsm r11/cn=sia reporter access,o=sia spa,c=it
The mdb table "ca_security profile" must have the same value otherwise we will get the error
In this example there was a difference because the mdb table had the below default certificate
0xB53C91955220E644874D390B15D93945,x509cert://dsm r11/cn=reporter access,o=computer associates,c=us,Reporter database password access,NULL,1,105,0,-1,0
and hence the validation was failing as showed below
"cn=sia reporter access,o=sia spa,c=it"
"cn=reporter access,o=computer associates,c=us"