Skip navigation
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
2414 Views 7 Replies Latest reply: Jan 17, 2013 1:34 AM by sonnv RSS
wayne chen Newcomer 1 posts since
Jun 15, 2012
Currently Being Moderated

Jun 15, 2012 6:20 AM

Foundstone update error After Installed

Hello All:

 

    I had a problem with first update after install foundstone.

 

    But, update is successfully,  is there any problem ?

 

    ps: my sqlserver account 'sa' is good, and the password is correct.

 

    the log descripted as following:

 

6/15/2012 5:22:39 PM CheckSQLServerVersionByADONET() is called.

6/15/2012 5:22:39 PM CheckSQLServerVersionByADONET() call succeeded.

6/15/2012 5:22:39 PM

6/15/2012 5:22:40 PM GetServerLoginMode() is called.

6/15/2012 5:22:40 PM Connecting to server 'EDC-SW-006' succeeded in the 'GetServerLoginMode()' call.

6/15/2012 5:22:40 PM GetServerLoginMode() call succeeded.

6/15/2012 5:22:40 PM

6/15/2012 5:22:40 PM CheckSQLServerVersionByADONET() is called.

6/15/2012 5:22:40 PM Login failed for user 'sa'.

System.Data.SqlClient.SqlException

   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

...

...

...

 

6/15/2012 5:22:40 PM CheckSQLServerVersionByADONET() call failed.

6/15/2012 5:22:40 PM FoundstoneDBInstall Critical method failed.

6/15/2012 5:22:40 PM

 

6/15/2012 5:23:14 PM CheckSQLServerVersionByADONET() is called.

6/15/2012 5:23:14 PM Login failed for user 'sa'.

System.Data.SqlClient.SqlException

   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

...

...

 

6/15/2012 5:23:14 PM CheckSQLServerVersionByADONET() call failed.

6/15/2012 5:23:14 PM FoundstoneDBInstall Critical method failed.

 

 

   the all log as attchements.

 

Thanks for attentions.

 

wayne

  • Community Leader 479 posts since
    Nov 3, 2009
    Currently Being Moderated
    1. Jun 26, 2012 4:57 PM (in response to wayne chen)
    Re: Foundstone update error After Installed

    Hi Wayne,


    Sorry for the late reply... have you worked this out yet?  These errors usually indicate SQL Client Tools aren't installed on the system where FSUpdate is running...  can you try running FSUpdate on the Database?  if that's not an option, and if you're having issues getting the client tools installed, you should open a Service Request.

     

    For contact details:

    -  Go to: http://www.mcafee.com/us/about/contact/index.html
    -  Non-US customers - select your country from the list of Worldwide Offices.


    Alternatively:
    Log in to the ServicePortal at: https://mysupport.mcafee.com:

    -  If you are a registered user, type your User Id and Password and click OK.
    -  If you are not a registered user, click New User and complete the required fields. Your password and login instructions will be emailed to you.

     

    I hope that helps!
    Cathy

  • sonnv Newcomer 16 posts since
    Aug 2, 2010
    Currently Being Moderated
    2. Sep 27, 2012 10:41 PM (in response to cgrim)
    Re: Foundstone update error After Installed

    Hi Cgrim,

        When my appliance updates vulnerability database. An error occurs, there is a warning "Error attempting to connect to Foundscan database. Check the FoundscanDBlog.txt in your "My Documents" directory for additional information. Unable to update"

       FoundscanDBlog.txt is attached as this message. below as some lines of FoundscanDBlog.txt

    "

    09/26/2012 16:18:29 -> Importing .bcp file C:\USR\APPLIA~1\LOCALS~1\Temp\1\FoundScanDBTemp\SupportFolder\FSContent\Vulns\v ulncategories.bcp succeeded

     

     

    09/26/2012 16:18:29 -> Running script file 'C:\USR\APPLIA~1\LOCALS~1\Temp\1\FoundScanDBTemp\SupportFolder\FSContent\Vulns\ vulncategoriesCheckConstraint.sql' succeeded

    09/26/2012 16:18:29 -> Running script file 'C:\USR\APPLIA~1\LOCALS~1\Temp\1\FoundScanDBTemp\SupportFolder\FSContent\Vulns\ vulncategoriesUpdate.sql' succeeded

    09/26/2012 16:18:29 -> Running database script command 'Update Version SET Version = '7.5.343', UpdateTime = GetDate() WHERE Name = 'vulncategories'' succeeded

    09/26/2012 16:18:29 ->

    09/26/2012 16:18:29 -> Patch table Vulns:

    09/26/2012 16:18:29 -> Running script file 'C:\USR\APPLIA~1\LOCALS~1\Temp\1\FoundScanDBTemp\SupportFolder\FSContent\Vulns\ VulnsCleanTempTable.sql' succeeded

    09/26/2012 16:18:29 -> Start of importing data...

    09/26/2012 16:19:13 -> Bulk Copy completed successfully.

    09/26/2012 16:19:13 -> Source: C:\USR\APPLIA~1\LOCALS~1\Temp\1\FoundScanDBTemp\SupportFolder\FSContent\Vulns\V ulns.bcp

    09/26/2012 16:19:13 -> Destination: [dbo].[VulnsTemp]

    09/26/2012 16:19:13 -> Rows copied: 39677

    09/26/2012 16:19:13 -> Bulk Copy duration: 0 minutes and 43.640 seconds

    09/26/2012 16:19:13 -> End of importing data...

     

     

    09/26/2012 16:19:13 -> Importing .bcp file C:\USR\APPLIA~1\LOCALS~1\Temp\1\FoundScanDBTemp\SupportFolder\FSContent\Vulns\V ulns.bcp succeeded

     

     

    09/26/2012 16:19:13 -> Running script file 'C:\USR\APPLIA~1\LOCALS~1\Temp\1\FoundScanDBTemp\SupportFolder\FSContent\Vulns\ VulnsCheckConstraint.sql' succeeded

     

     

      Microsoft SQL-DMO (ODBC SQLState: 42000) Error: -2147221334

     

     

      [Microsoft][ODBC SQL Server Driver][SQL Server]Line 455: Incorrect syntax near 'TRY'.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Line 480: Incorrect syntax near 'TRY'.

    [Microsoft][ODBC SQL Server Driver][SQL Server]'ERROR_MESSAGE' is not a recognized function name.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Line 504: Incorrect syntax near 'CATCH'.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'END'.

     

     

      Unknown error 0x800400AA

     

     

     

     

    09/26/2012 16:19:13 -> Running script file 'C:\USR\APPLIA~1\LOCALS~1\Temp\1\FoundScanDBTemp\SupportFolder\FSContent\Vulns\ VulnsUpdate.sql' failed

    09/26/2012 16:25:54 ->

     

    "

     

     

       Do you have experience in this case ? Could you please share it with me?

       Thanks you so much.

     

    Message was edited by: sonnv on 9/27/12 10:41:04 PM CDT
    Attachments:
  • Community Leader 479 posts since
    Nov 3, 2009
    Currently Being Moderated
    3. Sep 28, 2012 11:02 AM (in response to sonnv)
    Re: Foundstone update error After Installed

    Hi Sonny,

     

    The problem I see is:

     

    09/26/2012 16:18:28 -> The FoundScan  database current version is '6.0.651'.

     

    FSUpdare will not work with a version so old as that.   Current MVM Version is 7.5.  You can/should run the Installer to upgrade to either supported version of 7.5 or 7.0, *then* run FSUpdate.

     

    I hope that helps!
    Cathy

  • sonnv Newcomer 16 posts since
    Aug 2, 2010
    Currently Being Moderated
    4. Sep 29, 2012 3:38 AM (in response to cgrim)
    Re: Foundstone update error After Installed

    Hi Cgrim,

    Many thanks your support,

    In fact, Because of some problems, we can't upgrade FS to newer version this time. Can we update FS database manually in this case ? If manual update is fail, does FS still work ?

  • Community Leader 479 posts since
    Nov 3, 2009
    Currently Being Moderated
    5. Oct 1, 2012 3:09 PM (in response to sonnv)
    Re: Foundstone update error After Installed

    Hi Sonny,

     

    I'm not sure I follow your question.

     

    The database and product both need to be upgraded at the same time.

     

    -Cathy

  • sonnv Newcomer 16 posts since
    Aug 2, 2010
    Currently Being Moderated
    6. Oct 4, 2012 10:39 AM (in response to cgrim)
    Re: Foundstone update error After Installed

    Thanks Cgrim,

    We will make plan to upgrade the appliance.

  • sonnv Newcomer 16 posts since
    Aug 2, 2010
    Currently Being Moderated
    7. Jan 17, 2013 1:34 AM (in response to cgrim)
    Re: Foundstone update error After Installed

    Hi Cgrim,

    We have a problem with MVM 7.0. When my appliance updates vulnerability database. An error occurs, there is a warning "Error attempting to connect to Foundscan database. Check the FoundscanDBlog.txt in your "My Documents" directory for additional information. Unable to update"

       FoundscanDBlog.txt is attached as this message. below as some lines of FoundscanDBlog.txt

     

    1/16/2013 6:48:16 PM Connecting to server 'MVM3100-3B6B005' succeeded in the 'InitDB()' call.

    1/16/2013 6:48:17 PM GetDBVersion() call succeeded.

    1/16/2013 6:48:17 PM The current version of FoundScan database 'faultline' is '7.0.159'.

    1/16/2013 6:48:17 PM Run data patch scripts with database version checking enabled:

    1/16/2013 6:48:17 PM Patch table 'FSUpdate':

    1/16/2013 6:48:17 PM ExecuteNonQuery failed for Database 'faultline'.

    Microsoft.SqlServer.Management.Smo.FailedOperationException

       at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

       at FoundstoneDBInstall.DBHelper.RunDBSQLScript(String scriptFileFullName)

     

     

    1/16/2013 6:48:17 PM Running script file 'C:\Users\applianceadmin\AppData\Local\Temp\FoundScanDBTemp\SupportFolder\FSCon tent\FSUpdate\FSUpdateCleanTempTable.sql' failed.

    1/16/2013 6:48:17 PM Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

    System.IO.FileNotFoundException

       at Microsoft.SqlServer.Management.Common.ServerConnection.GetStatements(String query, ExecutionTypes executionType, Int32& statementsToReverse)

       at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

       at Microsoft.SqlServer.Management.Smo.ExecuteSql.ExecuteImmediate(String query)

       at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)

       at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)

       at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnum Result sqlresult, ResultType resultType)

       at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)

       at Microsoft.SqlServer.Management.Smo.Environment.GetData()

       at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)

       at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)

       at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[] fields, OrderBy[] orderby)

       at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[] fields, OrderBy[] orderby)

       at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean allProperties)

       at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.InitializeChildObject(Obje ctKeyBase key)

       at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.GetObjectByKey(ObjectKeyBa se key)

       at Microsoft.SqlServer.Management.Smo.TableCollection.get_Item(String name)

       at FoundstoneDBInstall.DBHelper.RunBulkCopyUsingBCP(String tableName, String bcpFile, String bcpFormatFile)

     

     

    1/16/2013 6:48:17 PM Running bulk copy table 'FSUpdateTemp' failed.

    1/16/2013 6:48:17 PM FoundstoneDBInstall Critical method failed.

     

    Could you please help me this case ? 

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 5 points
  • Helpful Answers - 3 points