Repository hangs while creating repository schema..

[Former Member]

Hi All,

When i try to create the repository schema from console, the repository hangs and it is not creating schema too.

the repository comes to normal only when i restart the server.

Im using MDM 5.5 SP06 Patch 4

Please help to solve this issue.

Regards,

Nimal

[Former Member]

Hi Nimal

Before exporting schema from console do a verify of the repository. This will give you a report with errors,if any present. then do a repair of the repository and then try to export the schema. This should resolve the problem,

thanks

Ravi

[Former Member]

Hello,

Can you share your code on how yor get the repository schema?

below is the code,

GetRepositorySchemaCommand getRepositorySchemaCommand = new GetRepositorySchemaCommand(

connectionPool);

getRepositorySchemaCommand.setSession(repositorySessionId);

getRepositorySchemaCommand.execute();

repositorySchema = getRepositorySchemaCommand.getRepositorySchema();

In general i notcied there is some performance issue with this getRepositorySchema() method,try avoid using it as it consumed almost 2 sec.

Cheers

Sabarinathan

[Former Member]

Oops sorry ,it looks your doing via console and not via API..

[Former Member]

Hi Nimal,

Please try these options.

1) Login remotely to the MDM server and use MDM console to export schema.

2) Check the Available DB Log size for this Repository Database

Regards.

[Former Member]

Hi Nimal,

You mean you are trying Export Repository Schema command? If yes, does it ask for the file name? Verify/Repair the repository first and load the repository with update indices then try to perform the operation.

If you are trying to create fields and tables then check for the necessary disk space. Also if you have several repositories running on same MDM server then stop the unwanted repositories and unmount them and then try.

Regards,

Jitesh Talreja

Edited by: Jitesh Talreja on Jul 16, 2009 10:58 AM