IMC
cancel
Showing results for 
Search instead for 
Did you mean: 

IMC Database New database Creation error

SOLVED
Go to solution
regnander
Occasional Contributor

IMC Database New database Creation error

Hi,

Im trying to install the UAM component on my IMC standard.

When deploying it I end up with an error stating that the DB for UAM is not created.

Begin to install EAD database and data...
--------------------------------
Begin dboptions.DBS
Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement to install.
Configuration option 'Ad Hoc Distributed Queries' changed from 1 to 1. Run the
RECONFIGURE statement to install.
End dboptions.DBS
--------------------------------
Begin to create EAD database...
execute ead.DBS ... ...
Msg 5133, Level 16, State 1, Server SQL13PROD\HPIMC, Line 2
Directory lookup for the file "E:\MSSQL.HPIMC\Data\\ead_data01.mdf" failed
with the operating system error 3(The system cannot find the path specified.).
Msg 1802, Level 16, State 1, Server SQL13PROD\HPIMC, Line 2
CREATE DATABASE failed. Some file names listed could not be created. Check
related errors.

 

My issue is that my db files are on a different drive, not E:. This is cause the DBA want to split DB and logs and have moved them to different drives. The first install was made with the default E: path, but later moved.

How can i specify and in which config file that the path is moved to another drive letter.

Also. Is the duble backslash an issue? E:\MSSQL.HPIMC\Data\\ead_data01.mdf

Any comments, Have anyone a simliar experience?

Regards

Regnadner

2 REPLIES
LindsayHill
Honored Contributor
Solution

Re: IMC Database New database Creation error

 I've seen something similar, a few years ago. Basically the way around it is to let IMC go ahead and create the DB & logs on the same disk, then stop the DB, move the logs, then restart it.

But when you go to add a new component, it will create a new DB. It will default to doing that using the same path as you used originally. You need to go through the same steps for this new DB.

Create the "E:\MSSQL.HPIMC\Data\" directory, run through the UAM install, then shut down IMC, move those DB files around as your DBA needs, then re-start IMC.

 

regnander
Occasional Contributor

Re: IMC Database New database Creation error

Thanks for the tip. That totally made it work.