Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 8 of 8 total |
Migration when server is running as service |
Thu, Jan 10 2019 8:02 AM | Permanent Link |
Yusuf Zorlu MicrotronX - Speditionssoftware vom Profi | Hi all,
we can't start migration if the dbsrvr is running as service. Possible that the service can't open the migrationxx.dll files? If we stop the service, run the dbserver as application, the migration is ok. Is this a known problem or I'm doing something wrong? Yusuf Zorlu MicrotronX |
Thu, Jan 10 2019 9:59 AM | Permanent Link |
Fernando Dias Team Elevate | Yusuf,
It's probably the server not finding the dll. Put the dll in the same folder where you have the configuration file and check again. -- Fernando Dias [Team Elevate] |
Fri, Jan 11 2019 4:15 AM | Permanent Link |
Yusuf Zorlu MicrotronX - Speditionssoftware vom Profi | Fernando Dias wrote:
Yusuf, It's probably the server not finding the dll. Put the dll in the same folder where you have the configuration file and check again. Hi Fernando, we have the server and all dll's in same folder but not working. I think this is a limitation somewhere with services. Yusuf Zorlu MicrotronX |
Fri, Jan 11 2019 5:29 AM | Permanent Link |
Charles Bainbridge | Yusuf Zorlu wrote:
Hi all, we can't start migration if the dbsrvr is running as service. Possible that the service can't open the migrationxx.dll files? If we stop the service, run the dbserver as application, the migration is ok. Is this a known problem or I'm doing something wrong? I know exactly what the problem is, as we hit the same issue. If only I could remember what the solution is. I'll check it out and come back. |
Fri, Jan 11 2019 5:53 AM | Permanent Link |
Charles Bainbridge | Right.
This is an OS permissions issue. The EDB server service runs in the local SYSTEM account on the machine. The local SYSTEM account does not have permissions to access the folder where the soure of the migration is. You need to add the local SYSTEM account of the server machine to the list of objects which can access the migration source, which may be on a different machine. From what I wrote earlier:- When migrating a system from version 4 to version 5, the migration of the v4 DBISAM database in performed by the DBISAM4 migrator module, which runs as part of the ElevateDB database service process. As installed, the EDB servers are Windows services, which are installed to run using the local machine’s (the server on which it is installed) SYSTEM account. The SYSTEM account of a machine has access to all resources of the machine. The SYSTEM account however, doesn’t have access to resources on other machines. If the version 4 DBISAM data lives in a share on a different machine to that which will be hosting Exportmaster 5’s databases, the migration process will fail to find any tables to migrate. It won’t fail, it just won’t migrate anything. There is now a test in the migrator program to check that tables exist after performing the migration. It will fail if nothing has been migrated. There are two solutions (probably more) I have come up with so far:- 1. Grant ‘Everyone’ all permissions in the version 4 share. This does leave the Share wide open, so should be revoked after migration. 2. Grant the machine hosting the Exportmaster 5 databases all permissions in the version 4 share. Eg, if the EDB server for Exportmaster 5 is running on a machine called ‘WIN2008R2-TEST’, grant the necessary permissions on the version 4 share to a computer named ‘WIN2008R2-TEST$’. |
Fri, Jan 11 2019 11:42 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Yusuf,
<< we can't start migration if the dbsrvr is running as service. Possible that the service can't open the migrationxx.dll files? If we stop the service, run the dbserver as application, the migration is ok. >> Are you seeing an error message, either in the client application or in the logged events for the EDB Server ? Tim Young Elevate Software www.elevatesoft.com |
Mon, Jan 14 2019 2:50 AM | Permanent Link |
Yusuf Zorlu MicrotronX - Speditionssoftware vom Profi | Tim Young [Elevate Software] wrote:
>> Are you seeing an error message, either in the client application or in the logged events for the EDB Server ? Hi Tim, yes i see an error but don't remember. Will try today / tomorrow new migrations and will note the messages + post them here. Yusuf Zorlu MicrotronX |
Mon, Jan 14 2019 8:42 AM | Permanent Link |
Yusuf Zorlu MicrotronX - Speditionssoftware vom Profi | Solution was pretty simple:
We had the user SYSTEM with full access to the folder where all exe and dll files resists. Adding the user SERVICE has solved the problem. Yusuf Zorlu MicrotronX |
This web page was last updated on Sunday, May 5, 2024 at 07:30 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |