cancel
Showing results for 
Search instead for 
Did you mean: 

EVmonitoring database failed to verify post SQL database relocation

itms-systems
Level 4

Hi there,

I am doing EV upgrade from 9.0.4 to 10.0.3, and moving the SQL database at the same time.

I am using server migration wizard, and stuck on the verify database instances. All Databases passed the verification (directory, storage, fingerprint) except EVMonitoring database. I have run the sql command to change the monitoring database server name as instructed in "moving sql database to another server" doc.

When I run "selelct SQLserver from MonitoringSettings" against EnterpriseVaultDirectory database, it does return the correct new sql database name.

My server migration wizard accetp all other database instances on the new sql server but not monitoring database.

Any help are appreciated.

cheers

ying

1 ACCEPTED SOLUTION

Accepted Solutions

JesusWept3
Level 6
Partner Accredited Certified
Actually try checking this tech it's out and see if it applies http://www.symantec.com/business/support/index?page=content&id=TECH173532
https://www.linkedin.com/in/alex-allen-turl-07370146

View solution in original post

9 REPLIES 9

JesusWept3
Level 6
Partner Accredited Certified
Don't suppose there's a system DSN created for monitoring holding the old name is there?
https://www.linkedin.com/in/alex-allen-turl-07370146

itms-systems
Level 4

Hi JesusWept3,

Thanks for you reply. I could not reply to your message, thus started a new commnet.

How do I check the system DSN?

cheers

Ying

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

if you know you did it correctly and you see the correct info with your manual tests can you just skip past it?

JesusWept3
Level 6
Partner Accredited Certified
Go to administrative tools -> Data sources (ODBC) then go to the System DSN tab You might have one for monitoring, update it with the new SQL server and try again
https://www.linkedin.com/in/alex-allen-turl-07370146

itms-systems
Level 4

@JesusWep3: no system DSN cofigured

@andrewB: can't skip server migration wizard if failed at any step

JesusWept3
Level 6
Partner Accredited Certified
I take it no DSN configured on any of the other tabs? Maybe worth getting a DTrace of the evmigrationwizard and seeing if you can find where this value is coming from
https://www.linkedin.com/in/alex-allen-turl-07370146

JesusWept3
Level 6
Partner Accredited Certified
Actually try checking this tech it's out and see if it applies http://www.symantec.com/business/support/index?page=content&id=TECH173532
https://www.linkedin.com/in/alex-allen-turl-07370146

itms-systems
Level 4

mmm, schemaVersion is 7.3.0.5 already. 

I think I made the whole upgrade process too complecated by move database at the same time. I'd better step back and con. to use the old sql database. 

Arjun_Shelke
Level 6
Employee Accredited

The System DSN which you check for EV on 64 bit OS is little different. Because EV is 32 bit application.

For example, goto C:\Windows\SysWOW64 and run odbcad.32.exe.

This will show you 32 bit System DSN's, make sure its pointing to correct Server.

I hope this helps..