We’ve developed some resources to help you work effectively from home during COVID-19 Click to learn more

DBSetup returns "User crm7 on data source ODBC:SuperOffice has to be BOTH a valid database user AND a valid SuperOffice (System) user", when trying to update counters

Hi,

I am trying to update SAINT Counters using DBSetup, as there are issues upating them using the Travel Gateway.  But when I try to run it I get the following error.

"DBSetup User crm7 on data source ODBC:SuperOffice has to be BOTH a valid database user AND a valid SuperOffice (System) user"

In the log file I see

190809 14:17:46 [DBSetup.exe] NS Config override --> central, dsn=ODBC:SuperOffice. Src: SSuperOfficeIni::OverrideNetServerConfig at c:\agent1\_work\146\s\clients\sm.win\source\dbdll\superofficeini.cpp v line 568
190809 14:17:46 [DBSetup.exe] Opening NetServer session for user 'crm7'. Src: NSSoSession::_OpenSession at c:\agent1\_work\146\s\clients\sm.win\source\netserver\nssosession.clr.cpp v line 38
190809 14:17:46 [DBSetup.exe] Authentication failed!
Authentication failed!
Object reference not set to an instance of an object. Src: NSSoSession::_OpenSession at c:\agent1\_work\146\s\clients\sm.win\source\netserver\nssosession.clr.cpp v line 57
190809 14:17:46 [DBSetup.exe] Exception stacktrace:. Src: NSSoSession::_OpenSession at c:\agent1\_work\146\s\clients\sm.win\source\netserver\nssosession.clr.cpp v line 58
190809 14:17:46 [DBSetup.exe] Authentication failed!

at SuperOffice.SoContext.Authenticate(SecurityToken[] tokens)
at SuperOffice.SoSession.Authenticate(String user, String password)
at NSSoSession._OpenSession(SvStr* i_UserId, SvStr* i_Passwrd)

But the same DBSetup with the same credentials does upgrade the database, and if I test that part again, I get no errors, only a message saying that the tables are up to date.

Any ideas why I would be getting this.

Many thanks,

Trevor

RE: DBSetup returns "User crm7 on data source ODBC:SuperOffice has to be BOTH a valid database user AND a valid SuperOffice (System) user", when trying to update counters

Thank you for this, that does make a lot of sense.  I will log on to the customers server and give this a try.

Trevor

Von: Trevor Sharp 14. Aug 2019

RE: DBSetup returns "User crm7 on data source ODBC:SuperOffice has to be BOTH a valid database user AND a valid SuperOffice (System) user", when trying to update counters

Hi Wilhelm,

I had no joy with this, I am afraid.  I tried adding a new user, and using an existing user, but I got the same error.  My main tests were around the ejSysUser user used by Customer Service.  The system user is enabled and I can log in to SuperOffice Admin with this account.

I created the user in SQL, with the same password, and gave the user DBOwner rights to SuperOffice (even tried giving it the sysadmin role at some point), but when running DBSetup for update counters, I go the same error.

I know I have entered the correct password for the SQL account, as when I peform a database upgrade using the newly created (in SQL) ejSysUser account, the upgrade process runs fine with these credentials, and tells me the database is up to day.

I just don't seem to be able to run the update counters, despite having a user with the same name in SQL and SuperOffice with the same password in both.

Is there anything else I could be missing.

Many thanks,

Trevor

 

Von: Trevor Sharp 15. Aug 2019

RE: DBSetup returns "User crm7 on data source ODBC:SuperOffice has to be BOTH a valid database user AND a valid SuperOffice (System) user", when trying to update counters

Just one thing I have just found that may be relevant, is that the password for the crm7 account is the same in SQL as it is for the system user in SuperOffice, so really the crm7 account should have worked.

Very strange.

Thanks,

Trevor

 

Von: Trevor Sharp 15. Aug 2019

RE: DBSetup returns "User crm7 on data source ODBC:SuperOffice has to be BOTH a valid database user AND a valid SuperOffice (System) user", when trying to update counters

Hi

did someone find a solution for that?

I know it was working in older versions when crm7 in SQL and crm7 table admin had the same (short - no more allowed) password.

But even with user crm7 on boh sites with same password will not work. I also tried a regular user with role 'User level 0' and function right to create tables in the database and created this user in SQL - it is not working.

Any hint? Because regenerating the counters over TravelGateway service looks not to be working well. When recreating the counters in WEB admin it works - but this is manually and needs to be done once a day.

Von: Christian Kogel 18. Mai 2020

RE: DBSetup returns "User crm7 on data source ODBC:SuperOffice has to be BOTH a valid database user AND a valid SuperOffice (System) user", when trying to update counters

Hi Christian,

In the end we wrote a small app using ISaintAgent.RegenerateCounters and ISaintAgent.RegenerateStatusMonitors, and run it each night as a scheduled task.  Runs much faster than the travel gateway, and I believe works in the same way as if you were to run the counter and status updates in the web admin client.  You can even see the running tasks in the System Notifications.

Trevor

Von: Trevor Sharp 18. Mai 2020