Page 1 of 1

Strange ODBC error after upgrading to 6.4.4

Posted: Mon Nov 09, 2020 2:14 am
by JohnsonCat
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?

Re: Strange ODBC error after upgrading to 6.4.4

Posted: Mon Nov 09, 2020 8:10 am
by FTP
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)

Re: Strange ODBC error after upgrading to 6.4.4

Posted: Wed Nov 11, 2020 4:49 am
by JohnsonCat
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.

Re: Strange ODBC error after upgrading to 6.4.4

Posted: Wed Nov 11, 2020 11:23 am
by FTP
That's great! Thanks for your feed back!