We are working for years with several EDB servers on a "stable" environment: a dedicated WindowsXXXX server. But now we've deployed an app to small teams. Server is a W7/10 PC which is started/stopped every day.

Just one customer, some days, when she starts this PC acting as a server has problems with EDBServer. Error is same when you mix ANSI/Unicode ini and EDBConfig.EDBCfg. #100 "Encryption password ..."

So, I guess EDBConfig.EDBCfg is corrupted in some way, may be due an invalid shutdown done yesterday.
Auto backup done by EDB (EDBConfig.EDBCfg.old) also fails (and it has same timestamp)

To fix it, I stop server (it's a service), delete EDBConfig.EDBCfg, start again (standalone or service) and force our app to recreate all databases, jobs, stores, modules.

My questions are:
* What can cause such corruption?
* Is there some way to fix it without destroy/create/configure?
* What can I do to avoid this file getting corrupted?

Thanks
Tiago Ameller
Menorca Zeros i Uns SL
www.sistemasc.net

Tiago


Never seen it, can't remember anyone reporting it before.

As a starter next time it happens have a look in edbsrvr.ini - the servers configuration file and see what Character Set is set to - I think 0 is ansi and 1 is unicode (but it could well be the other way round). If that's wrong it will at least give you an idea of which file is being changed.

Roy Lambert

Thanks, Roy: I was unable to check this post for some days.

I know this .ini. In fact, our custom EDB server installer creates a custom one in servers's folder.

Changing this setting don't fix error, I'm pretty sure config file is corrupted, only a fresh installation fixes it.

Sad to read there are no precedents to this issue. Next time, I'll double check ini file. May be server is reading file in some obscure localdata folder in system. We discovered if .ini is present in same folder than server, this is used first. Any comment about this?

Regards,
Tiago Ameller
Menorca Zeros i Uns SL
www.sistemasc.net

Tiago


I retired a couple of years ago and now just play with the local engine so I'm going on memory and guesswork.

Try running EDBServer as a program not a service and when started restore it, stop it and edit the options - check back to the ini file and see if you have the same.

The other thing that's going through my mind is what user the service runs as - that may not have the right permissions or something

Sorry I can't be much help

Roy Lambert

Thanks, Roy. I also like to be retired

Yes, when problems arise, I stop service and run server standalone. Next time (I hope no next time!) I'll try your advice. Problem is customer system is halted and having no time to investigate, just make it run again.
Tiago Ameller
Menorca Zeros i Uns SL
www.sistemasc.net