[sims] Discover failed to connect to database during transfer

[Liam]

Had some training today, it's just a shame that the data wasn't up to date.

I can't force a manual transfer as I keep getting the above error message. The scheduled task runs but obviously a similar message is being recieved.

 

I'm stumped. I have tried everything other than a reinstall of the discover server.

 

Any suggestions before I go ahead and do this?

 

Thanks

[round2it]

i had something similar after an upgrade.

 

the issue was a dodgy config file cant remember which one

 

will check tomorrow

[Liam]

That does make sense. I would really appreciate it as it is following an upgrade. Thanks

[round2it]

will discover run on the server ?

 

mine did but clients got upset

[Liam]

No it wont run on the server. But it does on the clients. It says catalog failed to load. So I assume there is a dodgy file

[round2it]

will check tomorrow for you. it was a simple entry in a config file that broke discover for me.

[round2it]

ok the file I had issues with was Discover.Designer.Desktop.exe.local.config

c:\programdata\discover

change your server and database names in the file

mine now reads (please check line for line as it was something or nothing i had to change sorry cant remember what though

 

Edited July 11, 2014 by round2it

[Liam]

All seems well. Strange one

[round2it]

is every line the same?

i had to delete 2 characters out of my old config file to get it working

 

i would remove discover completely and reinstall its a quick job and wont affect sims

[Liam]

Nothing a uninstall and reinstall can't solve. I assume permissions went a little screwy. Anyway thanks for your help

[Jons]

Yes I had this problem, my solution was -

 

ON THE SERVER-

Uninsall SIMS Discover services from add/remove progs.

Run the Discover CD setup, server typical installation with SERVER\SIMS2008 or SERVER\SIMS2012 etc

Note the first screen asks for the database - Discover

The second screen looks identical but is asking for the SIMS database

 

Then I immediately ran the Discover client on the server (useful) and the databases actually validate (often don't on a remote client)

Then you should have a proper icon for Discover Transfer Utility and Discover Client in the SIMS folder on the start menu

Then the transfer worked first time...

 

Cheers.