Network Automation Software We are currently migrating this forum
over to our HelpSystems domain. Please
post all new threads in our new
HelpSystems Community Portal.
Post to the HelpSystems Forum
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
Topic Title: Credential Problem
Topic Summary:
Created On: 07/26/2011 11:21 AM
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
 07/26/2011 11:21 AM
User is offline View Users Profile Print this message

Author Icon
MattBirch
n00b (>6 posts)

Posts: 3
Joined: 07/26/2011

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
 07/26/2011 04:19 PM
User is offline View Users Profile Print this message

Author Icon
Rick Johnson
AUTOMATE EMPLOYEE

Posts: 2757
Joined: 07/14/2008

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
 07/27/2011 08:12 AM
User is offline View Users Profile Print this message

Author Icon
MattBirch
n00b (>6 posts)

Posts: 3
Joined: 07/26/2011

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
 07/27/2011 02:58 PM
User is offline View Users Profile Print this message

Author Icon
Rick Johnson
AUTOMATE EMPLOYEE

Posts: 2757
Joined: 07/14/2008

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
 07/28/2011 10:26 AM
User is offline View Users Profile Print this message

Author Icon
MattBirch
n00b (>6 posts)

Posts: 3
Joined: 07/26/2011

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
 07/28/2011 02:26 PM
User is offline View Users Profile Print this message

Author Icon
Rick Johnson
AUTOMATE EMPLOYEE

Posts: 2757
Joined: 07/14/2008

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
Statistics
18258 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 5551 on 01/08/2018 at 11:11 AM.
There are currently 1543 guests browsing this forum, which makes a total of 1543 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2020 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog