Hi,

I recently installed BPA Server 7.1.3 on a Windows 7 machine. The setup part concluded issueless, however when I opened the server management console and tried to log in with my credentials (these being "Administrator" and "password", as in default) it would simply refuse to let the user log in, claiming "the user name and/or password is not valid" (I checked for BPA Agent and BPA Server on the local services section and both are running)

I've tested BPA Server installation before (on XP & Vista machines) and never had such a problem.

I've uninstalled and reinstalled the whole package 3 times but no effect. So does anyone have an idea how can I get past this or reset these values if necessary?

Category Survey

Hi Matt,

When you uninstall, make sure that the program files folder is empty, and the registry node HKEY_CURRENT_USER\Software\Network Automation\BPA Server is no longer present. That should clear you for a reinstall without inheriting anything from a previous attempt.

Category Survey

-------------------------
- Rick Johnson
Network Automation

Thank you Rick, I've reinstalled it the way you suggested, but no change.

Here's the excerpt from the event viewer, in case that helps.

----------------------

Problem with a custom query.
VistaDB.Diagnostic.VistaDBSQLException:
Error 632 (Provider v. 3.5.1.84): Incorrect syntax near the keyword LIKE
Line #: 1; Column #: 51

   at AutoMate.BPAServer.DataManager.VistaDbDataAdapter.QueryDataTable(DataSet theDataSet, String theQuery, BPAServerDataTableTypes theDataTableType)

 

---------------------------

QueryDataTable -> AutoMateConstructs: Retry #9
CommandQuery: SELECT * FROM AutoMateConstructs WHERE ResourceName like 'administrator' AND ResourceType = 10
CommandText: SELECT * FROM AutoMateConstructs WHERE ResourceName like 'administrator' AND ResourceType = 10
VistaDB.Diagnostic.VistaDBSQLException:
Error 632 (Provider v. 3.5.1.84): Incorrect syntax near the keyword LIKE
Line #: 1; Column #: 51

   at uX.ue.U(B0 , Int64 )
   at uX.ue.M(Int64 )
   at uX.ue.h(String , Int64 )
   at uX.ue.VistaDB.Engine.Internal.ILocalSQLConnection.CreateQuery(String )
   at VistaDB.Provider.VistaDBConnection.Z(String )
   at VistaDB.Provider.VistaDBCommand.A()
   at VistaDB.Provider.VistaDBCommand.V()
   at VistaDB.Provider.VistaDBCommand.ExecuteReader(CommandBehavior behavior)
   at VistaDB.Provider.VistaDBCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at AutoMate.BPAServer.DataManager.VistaDbDataSetTableAdapters.AutoMateConstructsTableAdapter.FillByWhereClause(AutoMateConstructsDataTable dataTable)
   at AutoMate.BPAServer.DataManager.VistaDbDataAdapter.QueryDataTable(DataSet theDataSet, String theQuery, BPAServerDataTableTypes theDataTableType)

Category Survey

Hi Matt,

Let's try manually switching your datastore over to XML files versus the VistaDb embedded database.

To do this, you will want to stop the BPA Agent ans BPA Server services, then navigate to the c:\ProgramData\Network Automation\AutoMate BPA Server folder and edit the Server Properties.xml file.
The line with should be changed from VistaDb to XML. Once this change has been saved, start the AutoMate BPA Server service back up, and once it starts, start the Agent service back up as well.

After this are you able to log in to SMC?

Category Survey

-------------------------
- Rick Johnson
Network Automation

I've changed the line from VistaDb to XML and SMC wouldn't connect to the server at all. Then I've changed it back to VistaDb and the connection was made, yet without any authorization success...

Category Survey

Hi Matt,

This data is then most likely being inherited from the previous VistaDb data.

If you remove the C:\ProgramData\Network Automation\AutoMate BPA Server
folder after uninstalling, you should be in the clear to install using the expected defaults.

Category Survey

-------------------------
- Rick Johnson
Network Automation