Can't login to my own MDM Repository?

[Former Member]

Hi all,

I have worked in my MDM Repository named kaushikrepo.

There are two users kaushikb and Admin....

I have set both user password as taton@123

But now I am failing to login using the password.

It is showing invalid MDM Repository.

What to do?

I don't have any archive of the current repository from where

could I take backup?

Regards

Kaushik Banerjee

Edited by: Kaushik Banerjee on Apr 20, 2009 1:08 PM

[Former Member · Accepted solution]

HI Kaushik,

As rightly pointed in the above post,Invalid repository error means the repository is not getting recognized at the database level so it is not able to Connect to the MDM repository or Load it in the MDM server.

This error happens typically when the database instance connecting to the MDM server is having an issue.

You need to check from the database end for any connection break between MDM server and the Database server and fix these services.On doing this your MDM repository should work.

This task is better handled by the Basis or the Administrator who have set the connections.

Hope It Helped

Thanks & Regards

Simona Pinto

[Former Member · Accepted solution]

Hi,

I am able to login to MDMDBA User using sqlplus but the query

"select * from tab;" is not showing any records.

Regards

Kaushik Banerjee

Edited by: Kaushik Banerjee on Apr 20, 2009 2:25 PM

[Former Member · Accepted solution]

Hi Kaushik,

Restart your database server and then MDM Server once.

Regards,

Jitesh Talreja

[Former Member · Accepted solution]

Hi Kaushik,

Plase restart the DBMS as well as the MDM Server. Hopefully it should work, if the DBMS is on a different machine then try pinging to check the connectivity.

Hope this helps!!

Cheers,

Arafat

[Former Member · Accepted solution]

Hi,

I think to have forgot the repository password even if the login is Admin.

There are two ways out.

As, I have not taken any backup of my repository;

1> I should create a new repository and replicate the same logic.

2> I should retrieve the password from Oracle and update it with update commnad.

Now, I need to know the exact table where the password is going to be stored?

I am pasting list of my MDM tables.

A2I_1_207_HSL                  KAUSHIKREPO_M000
A2I_1_207_254                  KAUSHIKREPO_M000
A2I_1_86                       KAUSHIKREPO_M000

TABLE_NAME                     OWNER
------------------------------ ----------------
A2I_1_86_TEXT                  KAUSHIKREPO_M000
A2I_1_86_HSL                   KAUSHIKREPO_M000
A2I_50                         KAUSHIKREPO_M000
A2I_50_TEXT                    KAUSHIKREPO_M000
A2I_44                         KAUSHIKREPO_M000
A2I_44_TEXT                    KAUSHIKREPO_M000
A2I_42                         KAUSHIKREPO_M000
A2I_42_TEXT                    KAUSHIKREPO_M000
A2I_20                         KAUSHIKREPO_M000
A2I_20_TEXT                    KAUSHIKREPO_M000
A2I_24                         KAUSHIKREPO_M000

TABLE_NAME                     OWNER
------------------------------ ----------------
A2I_24_TEXT                    KAUSHIKREPO_M000
A2I_25                         KAUSHIKREPO_M000
A2I_25_TEXT                    KAUSHIKREPO_M000
A2I_51                         KAUSHIKREPO_M000
A2I_51_TEXT                    KAUSHIKREPO_M000
A2I_38                         KAUSHIKREPO_M000
A2I_38_TEXT                    KAUSHIKREPO_M000
A2I_15                         KAUSHIKREPO_M000
A2I_15_TEXT                    KAUSHIKREPO_M000
A2I_3                          KAUSHIKREPO_M000
A2I_3_TEXT                     KAUSHIKREPO_M000

TABLE_NAME                     OWNER
------------------------------ ----------------
A2I_H_3                        KAUSHIKREPO_M000
A2I_29                         KAUSHIKREPO_M000
A2I_29_TEXT                    KAUSHIKREPO_M000
A2I_H_29                       KAUSHIKREPO_M000
A2I_43                         KAUSHIKREPO_M000
A2I_43_TEXT                    KAUSHIKREPO_M000
A2I_H_43                       KAUSHIKREPO_M000
A2I_A_43                       KAUSHIKREPO_M000
A2I_A_43_TEXT                  KAUSHIKREPO_M000
A2I_C_43                       KAUSHIKREPO_M000
A2I_CN_43                      KAUSHIKREPO_M000

TABLE_NAME                     OWNER
------------------------------ ----------------
A2I_CA_43                      KAUSHIKREPO_M000
A2I_FV_43                      KAUSHIKREPO_M000
A2I_F_43                       KAUSHIKREPO_M000
A2I_MS_TYPES_43                KAUSHIKREPO_M000
A2I_MS_ATTRIBUTES_43           KAUSHIKREPO_M000
A2I_MS_FIELDS_43               KAUSHIKREPO_M000
A2I_4                          KAUSHIKREPO_M000
A2I_4_TEXT                     KAUSHIKREPO_M000
A2I_H_4                        KAUSHIKREPO_M000
A2I_37                         KAUSHIKREPO_M000
A2I_37_TEXT                    KAUSHIKREPO_M000

TABLE_NAME                     OWNER
------------------------------ ----------------
A2I_41                         KAUSHIKREPO_M000
A2I_41_TEXT                    KAUSHIKREPO_M000
A2I_2                          KAUSHIKREPO_M000

Regards

Kaushik Banerjee

[Former Member · Accepted solution]

Hi Kaushik,

You can refer to the passwords or reset them using the A2i_CM_Users table in the database.

Hope it helps.

Thanks,

Minaz

[Former Member · Accepted solution]

Hi,

I can't see A2i_CM_Users under KAUSHIKBREPO_M000 Owner while it is visible under

other owners.

Also many other tables are not visible under KAUSHIKBREPO_M000 Owner.

I think the best possible to solution is to recreate the MDM Repository and implement the

underneath logic.

Regards

Kaushik Banerjee

[Former Member · Accepted solution]

Hi Kaushik,

Are you able to login to other repositories? If yes, then there is no connectivity problem between your database server and MDM, in that case your repository might have damaged and you need to create it again.

Regards,

Jitesh Talreja

[Former Member]

Hi Kaushik,

It seems there is some problem with the connectivity between your mdm server and the database.

Try restarting your services and backend server.

Hope it helps.

Thanks,

Minaz

[Former Member]

Hi Kaushik,

Invalid MDM repository doesn't mean you are entering wrong user credentials. Check the database server.Restart both database server first then MDM Server and then try to login.

Regards,

Jitesh Talreja