got strange errors in domain log after upgrading to 6.4.4
ODBC ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'wftp_table_upgrade622'
it seems to happen everytime after i edit user properties.
i can tell the table is there in the sql database. any idea?
Strange ODBC error after upgrading to 6.4.4
-
- Posts: 10
- Joined: Mon Nov 02, 2020 5:58 am
-
- Site Admin
- Posts: 2080
- Joined: Tue Sep 29, 2009 6:09 am
Re: Strange ODBC error after upgrading to 6.4.4
OK, please check whether exists the table "wftp_table_upgrade622", if not exist, please create this table manually:
CREATE TABLE wftp_table_upgrade622 (version int)
CREATE TABLE wftp_table_upgrade622 (version int)
-
- Posts: 10
- Joined: Mon Nov 02, 2020 5:58 am
Re: Strange ODBC error after upgrading to 6.4.4
i actually figured out after i post.
the database was created with the service account as db scheme, for example, it was created as [domain\account].database, so i transfer the scheme to sql default scheme [dbo]., and restart wftp server, the error is gone.
the database was created with the service account as db scheme, for example, it was created as [domain\account].database, so i transfer the scheme to sql default scheme [dbo]., and restart wftp server, the error is gone.
-
- Site Admin
- Posts: 2080
- Joined: Tue Sep 29, 2009 6:09 am
Re: Strange ODBC error after upgrading to 6.4.4
That's great! Thanks for your feed back!