MMS cockpit error - cannot load data types

[kishorp]

please check below screenshot.

[anton_levin · Accepted solution]

Please, check IoT FAQ [1] for two potential causes of your issue.

[1] https://help.sap.com/viewer/7436c3125dd5491f939689f18954b1e9/Cloud/en-US/a012a3788b6e498a8971dd27c97... > "IoT Cockpit" > Why does the Internet of Things service cockpit display error messages telling me that entities cannot be loaded?

[kishorp · Accepted solution]

Thanks this worked, the IoT service cockpit loads up data.

Now my MMS cockpit does not load up it gives message Service Unavailable.

can you help here ?

Thanks,

Kishor

[kishorp · Accepted solution]

This what the log says :

Caused by: com.sap.iotservices.mms.exception.InitializationError: Failed to retrieve the database connection from the SAP Cloud Platform SAP HANA / SAP ASE Service. Please check if you specified a valid data source binding for the MMS in the SAP Cloud Platform Cockpit.

[anton_levin · Accepted solution]

Same FAQ [1] > "MMS" > Why does the MMS not start or stays in state 'STARTING' or 'ERROR'? or Why does the MMS return HTTP status 500?

[1] https://help.sap.com/viewer/7436c3125dd5491f939689f18954b1e9/Cloud/en-US/a012a3788b6e498a8971dd27c97...

[kishorp · Accepted solution]

I have the database and schema in place but still the app does not start.

also binding exits

[anton_levin · Accepted solution]

What is the name of your "Data Source" in SCP Cockpit > Java Applications > iotmms > Configuration > Data Source Binding? "Data Source" has to be a default one "DEFAULT"

[kishorp · Accepted solution]

It is "default"

[anton_levin · Accepted solution]

From the remote logs I see "SQLInvalidAuthorizationSpecException: [10]: authentication failed" exceptions when MMS tries to establish a connection with the DB. I see you are on Trial and using MDC HANA. Be advised that the default DB user is "SYSTEM" and not your P-user. Also, re-cehck the password. IoT MMS will require a restart after you do the data source re-binding.

[kishorp · Accepted solution]

Thanks for your quick response, the app has now started.

i get below error when i click on the cockpit link.

Access to the requested resource is forbidden (HTTP 403).

[kishorp · Accepted solution]

below screenshot

[anton_levin · Accepted solution]

Dear user, I really insist that you read and follow the online documentation before posting questions. See IoT FAQ [1] and respective documentation about assigning roles [2].

Please, also familiarize yourself with the Community Rules of Engagements [3] and especially with:

#3 Search before you post.

#13 Do not hijack - a current question (original) is supposed to be answered. Resolution is - wrong role assignment for IoT RDMS component. Follow-up question also resolved. Resolution is - DB binding and DB credentials were wrong. Latest follow-up question - see above.

#8 Be responsive.

Regards,

Anton (Moderator)

[1] https://help.sap.com/viewer/7436c3125dd5491f939689f18954b1e9/Cloud/en-US/a012a3788b6e498a8971dd27c97... > MMS > Why does the MMS return HTTP status 403?

[2] https://help.sap.com/viewer/7436c3125dd5491f939689f18954b1e9/Cloud/en-US/6fec84d8fd944b6b9a547d452c1...

[3] https://www.sap.com/community/about/rules-of-engagement.html

[anton_levin · Accepted solution]

Type your p-user correctly. "1" is missing at the end.

[kishorp · Accepted solution]

Thanks for all the help. It works now !