7 Replies Latest reply: Jan 17, 2013 1:34 AM by sonnv RSS

    Foundstone update error After Installed

    wayne chen

      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

        • 1. 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

          • 2. Re: Foundstone update error After Installed
            sonnv

            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
            • 3. 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

              • 4. Re: Foundstone update error After Installed
                sonnv

                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 ?

                • 5. 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

                  • 6. Re: Foundstone update error After Installed
                    sonnv

                    Thanks Cgrim,

                    We will make plan to upgrade the appliance.

                    • 7. Re: Foundstone update error After Installed
                      sonnv

                      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 ?