Can not create repository on MDM7.1SP9

[Former Member]

hi experts,

we use MDM7.1SP9 and MSSQL2008R2.

if try to create a repository, using MDM Console,

we've got an error message "Unable to modify database".

>MDM Console log here...

OLEDB error on SHAKA/master from statement: CREATE DATABASE test6_m000 ON (NAME = test6_m000_Dat, FILENAME = 'F:\BG3DATA1\BG3.mdf\test6_m000.Mdf', SIZE = 4096KB, MAXSIZE = UNLIMITED) LOG ON (NAME = test6_m000_Log, FILENAME = 'F:\BG3LOG1\BG3_log.ldf\test6_m000.Ldf', SIZE = 512KB, MAXSIZE = UNLIMITED)

ErrorRecord->HResult/NativeErr: 0x80040e14/0

Description: CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

Source/File/Line: Microsoft OLE DB Provider for SQL Server/.\OLEDB_DBConnection.cpp/2440

>DBMS Setting here...(Default Setting)

Data path: F:\BG3DATA1\BG3.mdf

Log path: F:\BG3LOG1\BG3_log.ldf

Default partitions: 2

we can connect to MSSQL2008R2 from MSSQLServerManagementStudio,

and can create database and table.

does anyone have a solution?

best regards,

Taotsu

[Former Member]

Tarun and Ravi,

Thank you for your replying.

We solved this problem by changing DBMS Settings below.

Previously settings:

Data path: F:\BG3DATA1\BG3.mdf

Log path: F:\BG3LOG1\BG3_log.ldf

Default partitions: 2

Current settings:

Data path: F:\BG3DATA1\

Log path: F:\BG3LOG1\

Default partitions: 2

We changed *path variables and now working fine.

Thank you.

Best Regards,

Taotsu

[Former Member]

Hi Taotsu,

In addition to above you can also review the permission of the user at DB level.One can also try creating a database manually at the DB level so as to eliminate reason pointing to user permission.

Thanks,

Ravi

[Former Member]

Taotsu,

Try the below solution, it may solve your problem:

• Kindly, enlarge the free space on the DBMS to the size required for the original repository.For more details please refer to SAP Note: Note 1324299 - Error message: unable to modify database.

• Clean files from "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA" location. You can delete them, if you do not need them, connect to database and then try to create repository.
  
  Basically, this trick works, if you have reinstalled MS SQL Server. Uninstallation of DBMS did not delete the databases and while reconnection it tries to create A2i_xCat_DBs. For more information see this thread: http://scn.sap.com/thread/3265067.

Hope this will solve your issue..!!

Thx/ -Tarun