Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SMS 2003 SP3 Installation FAILURE - Asset intelligence

21 views
Skip to first unread message

PaulMama

unread,
Sep 17, 2009, 7:17:03 AM9/17/09
to

Hi

I have tried to install SMS 2003 SP3 on a SMS 2003 SP2 machine and it has
failed with the error:

CSql::Execute failed, SQL error <[24000][0][Microsoft][ODBC Driver Manager]
Invalid cursor state

If i run the installation without the Asset Intelligence insstalled the
process runs through without incident

Any one got any ideas ? (this is on our systemtest environment) will soon
need to complete on the live environment (5 servers)

Full error message :

<09-17-2009 11:44:57> sql command sp_LU_Category @sCSVFile =
'"\\SYSMGT01\S00_AI$\LU_Category.csv"', @sFMTFile =
'"\\SYSMGT01\S00_AI$\LU_Category.fmt"', @sSQLServerName =
'SYSMGT01',@iFirstRow = 2, @sBCPErrFilePath =
'"\\SYSMGT01\S00_AI$\BCP_LOGS\LU_Category_114457.err"'
<09-17-2009 11:44:59> start of importing records from
\\SYSMGT01\S00_AI$\LU_SoftwareList.csv File
<09-17-2009 11:44:59> sql command sp_LU_SoftwareList @sCSVFile =
'"\\SYSMGT01\S00_AI$\LU_SoftwareList.csv"', @sFMTFile =
'"\\SYSMGT01\S00_AI$\LU_SoftwareList.fmt"', @sSQLServerName =
'SYSMGT01',@iFirstRow = 2, @sBCPErrFilePath =
'"\\SYSMGT01\S00_AI$\BCP_LOGS\LU_SoftwareList_114459.err"'
<09-17-2009 11:45:47> start of importing records from
\\SYSMGT01\S00_AI$\LU_SoftwareCode.csv File
<09-17-2009 11:45:47> sql command sp_LU_SoftwareCode @sCSVFile =
'"\\SYSMGT01\S00_AI$\LU_SoftwareCode.csv"', @sFMTFile =
'"\\SYSMGT01\S00_AI$\LU_SoftwareCode.fmt"', @sSQLServerName =
'SYSMGT01',@iFirstRow = 2, @sBCPErrFilePath =
'"\\SYSMGT01\S00_AI$\BCP_LOGS\LU_SoftwareCode_114547.err"'
<09-17-2009 11:46:25> start of importing records from
\\SYSMGT01\S00_AI$\LU_SoftwareHash.csv File
<09-17-2009 11:46:25> sql command sp_LU_SoftwareHash @sCSVFile =
'"\\SYSMGT01\S00_AI$\LU_SoftwareHash.csv"', @sFMTFile =
'"\\SYSMGT01\S00_AI$\LU_SoftwareHash.fmt"', @sSQLServerName =
'SYSMGT01',@iFirstRow = 2, @sBCPErrFilePath =
'"\\SYSMGT01\S00_AI$\BCP_LOGS\LU_SoftwareHash_114625.err"'
<09-17-2009 11:47:56> start of importing records from
\\SYSMGT01\S00_AI$\LU_CPU.csv File
<09-17-2009 11:47:56> sql command sp_LU_CPU @sCSVFile =
'"\\SYSMGT01\S00_AI$\LU_CPU.csv"', @sFMTFile =
'"\\SYSMGT01\S00_AI$\LU_CPU.fmt"', @sSQLServerName = 'SYSMGT01',@iFirstRow =
2, @sBCPErrFilePath = '"\\SYSMGT01\S00_AI$\BCP_LOGS\LU_CPU_114756.err"'
<09-17-2009 11:47:56> SqlExecute <sp_LU_CPU @sCSVFile =
'"\\SYSMGT01\S00_AI$\LU_CPU.csv"', @sFMTFile =
'"\\SYSMGT01\S00_AI$\LU_CPU.fmt"', @sSQLServerName = 'SYSMGT01',@iFirstRow =
2, @sBCPErrFilePath = '"\\SYSMGT01\S00_AI$\BCP_LOGS\LU_CPU_114756.err"'>
<09-17-2009 11:47:56> CSql::Execute failed, SQL error
<[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
>
<09-17-2009 11:47:56> Cannot execute sql command sp_LU_CPU @sCSVFile =
'"\\SYSMGT01\S00_AI$\LU_CPU.csv"', @sFMTFile =
'"\\SYSMGT01\S00_AI$\LU_CPU.fmt"', @sSQLServerName = 'SYSMGT01',@iFirstRow =
2, @sBCPErrFilePath = '"\\SYSMGT01\S00_AI$\BCP_LOGS\LU_CPU_114756.err"'
<09-17-2009 11:47:56> Successfully imported records in LU_CPU Table
<09-17-2009 11:47:56> Failed to import few of the records in LU_CPU Table,
Please see the E:\SMS\AI\BCP_LOGS\LU_CPU_114756.err file for more detailed
information
<09-17-2009 11:47:56> start of importing records from
\\SYSMGT01\S00_AI$\LU_ExecutableArtifact.csv File
<09-17-2009 11:47:56> sql command sp_LU_ExecutableArtifact @sCSVFile =
'"\\SYSMGT01\S00_AI$\LU_ExecutableArtifact.csv"', @sFMTFile =
'"\\SYSMGT01\S00_AI$\LU_ExecutableArtifact.fmt"', @sSQLServerName =
'SYSMGT01',@iFirstRow = 2, @sBCPErrFilePath =
'"\\SYSMGT01\S00_AI$\BCP_LOGS\LU_ExecutableArtifact_114756.err"'
<09-17-2009 11:47:56> SqlExecute <sp_LU_ExecutableArtifact @sCSVFile =
'"\\SYSMGT01\S00_AI$\LU_ExecutableArtifact.csv"', @sFMTFile =
'"\\SYSMGT01\S00_AI$\LU_ExecutableArtifact.fmt"', @sSQLServerName =
'SYSMGT01',@iFirstRow = 2, @sBCPErrFilePath =
'"\\SYSMGT01\S00_AI$\BCP_LOGS\LU_ExecutableArtifact_114756.err"'>
<09-17-2009 11:47:56> CSql::Execute failed, SQL error
<[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
>
<09-17-2009 11:47:56> Cannot execute sql command sp_LU_ExecutableArtifact
@sCSVFile = '"\\SYSMGT01\S00_AI$\LU_ExecutableArtifact.csv"', @sFMTFile =
'"\\SYSMGT01\S00_AI$\LU_ExecutableArtifact.fmt"', @sSQLServerName =
'SYSMGT01',@iFirstRow = 2, @sBCPErrFilePath =
'"\\SYSMGT01\S00_AI$\BCP_LOGS\LU_ExecutableArtifact_114756.err"'
<09-17-2009 11:47:56> Successfully imported records in LU_ExecutableArtifact
Table
<09-17-2009 11:47:56> Failed to import few of the records in
LU_ExecutableArtifact Table, Please see the
E:\SMS\AI\BCP_LOGS\LU_ExecutableArtifact_114756.err file for more detailed
information
<09-17-2009 11:47:56> start of importing records from
\\SYSMGT01\S00_AI$\LU_HardwareRequirements.csv File
<09-17-2009 11:47:56> sql command sp_LU_HardwareRequirements @sCSVFile =
'"\\SYSMGT01\S00_AI$\LU_HardwareRequirements.csv"', @sFMTFile =
'"\\SYSMGT01\S00_AI$\LU_HardwareRequirements.fmt"', @sSQLServerName =
'SYSMGT01',@iFirstRow = 2, @sBCPErrFilePath =
'"\\SYSMGT01\S00_AI$\BCP_LOGS\LU_HardwareRequirements_114756.err"'
<09-17-2009 11:47:56> SqlExecute <sp_LU_HardwareRequirements @sCSVFile =
'"\\SYSMGT01\S00_AI$\LU_HardwareRequirements.csv"', @sFMTFile =
'"\\SYSMGT01\S00_AI$\LU_HardwareRequirements.fmt"', @sSQLServerName =
'SYSMGT01',@iFirstRow = 2, @sBCPErrFilePath =
'"\\SYSMGT01\S00_AI$\BCP_LOGS\LU_HardwareRequirements_114756.err"'>
<09-17-2009 11:47:56> CSql::Execute failed, SQL error
<[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
>
<09-17-2009 11:47:56> Cannot execute sql command sp_LU_HardwareRequirements
@sCSVFile = '"\\SYSMGT01\S00_AI$\LU_HardwareRequirements.csv"', @sFMTFile =
'"\\SYSMGT01\S00_AI$\LU_HardwareRequirements.fmt"', @sSQLServerName =
'SYSMGT01',@iFirstRow = 2, @sBCPErrFilePath =
'"\\SYSMGT01\S00_AI$\BCP_LOGS\LU_HardwareRequirements_114756.err"'
<09-17-2009 11:47:56> Successfully imported records in
LU_HardwareRequirements Table
<09-17-2009 11:47:56> Failed to import few of the records in
LU_HardwareRequirements Table, Please see the
E:\SMS\AI\BCP_LOGS\LU_HardwareRequirements_114756.err file for more detailed
information
<09-17-2009 11:47:56> start of importing records from
\\SYSMGT01\S00_AI$\LU_MSProd.csv File
<09-17-2009 11:47:56> sql command sp_LU_MSProd @sCSVFile =
'"\\SYSMGT01\S00_AI$\LU_MSProd.csv"', @sFMTFile =
'"\\SYSMGT01\S00_AI$\LU_MSProd.fmt"', @sSQLServerName = 'SYSMGT01',@iFirstRow
= 2, @sBCPErrFilePath = '"\\SYSMGT01\S00_AI$\BCP_LOGS\LU_MSProd_114756.err"'
<09-17-2009 11:47:56> SqlExecute <sp_LU_MSProd @sCSVFile =
'"\\SYSMGT01\S00_AI$\LU_MSProd.csv"', @sFMTFile =
'"\\SYSMGT01\S00_AI$\LU_MSProd.fmt"', @sSQLServerName = 'SYSMGT01',@iFirstRow
= 2, @sBCPErrFilePath = '"\\SYSMGT01\S00_AI$\BCP_LOGS\LU_MSProd_114756.err"'>
<09-17-2009 11:47:56> CSql::Execute failed, SQL error
<[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
>
<09-17-2009 11:47:56> Cannot execute sql command sp_LU_MSProd @sCSVFile =
'"\\SYSMGT01\S00_AI$\LU_MSProd.csv"', @sFMTFile =
'"\\SYSMGT01\S00_AI$\LU_MSProd.fmt"', @sSQLServerName = 'SYSMGT01',@iFirstRow
= 2, @sBCPErrFilePath = '"\\SYSMGT01\S00_AI$\BCP_LOGS\LU_MSProd_114756.err"'
<09-17-2009 11:47:56> Successfully imported records in LU_MSProd Table
<09-17-2009 11:47:56> Failed to import few of the records in LU_MSProd
Table, Please see the E:\SMS\AI\BCP_LOGS\LU_MSProd_114756.err file for more
detailed information
<09-17-2009 11:47:56> End of importing data from CSV files
<09-17-2009 11:47:56> Successfully imported records in (null) Table
<09-17-2009 11:47:56> Successfully imported records in (null) Table
<09-17-2009 11:47:56> SqlExecute <sp_OptionExectionSQL2005 0>
<09-17-2009 11:47:56> CSql::Execute failed, SQL error
<[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
>
<09-17-2009 11:47:56> Cannot execute sql command sp_OptionExectionSQL2005 0
<09-17-2009 11:47:56> SqlExecute <sp_DropTempTables>
<09-17-2009 11:47:56> CSql::Execute failed, SQL error
<[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
>
<09-17-2009 11:47:56> Cannot execute sql command sp_DropTempTables
<09-17-2009 11:47:56> SqlExecute <drop procedure sp_DropTempTables>
<09-17-2009 11:47:56> CSql::Execute failed, SQL error
<[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
>
<09-17-2009 11:47:56> Cannot execute sql command drop procedure
sp_DropTempTables
<09-17-2009 11:47:56> Deleting AA SP's Created for temporary usage drop
procedure sp_LU_Category
<09-17-2009 11:47:56> SqlExecute <drop procedure sp_LU_Category>
<09-17-2009 11:47:56> CSql::Execute failed, SQL error
<[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
>
<09-17-2009 11:47:56> Cannot execute sql command drop procedure sp_LU_Category
<09-17-2009 11:47:56> Deleting AA SP's Created for temporary usage drop
procedure sp_LU_SoftwareList
<09-17-2009 11:47:56> SqlExecute <drop procedure sp_LU_SoftwareList>
<09-17-2009 11:47:56> CSql::Execute failed, SQL error
<[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
>
<09-17-2009 11:47:56> Cannot execute sql command drop procedure
sp_LU_SoftwareList
<09-17-2009 11:47:56> Deleting AA SP's Created for temporary usage drop
procedure sp_LU_SoftwareCode
<09-17-2009 11:47:56> SqlExecute <drop procedure sp_LU_SoftwareCode>
<09-17-2009 11:47:56> CSql::Execute failed, SQL error
<[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
>
<09-17-2009 11:47:56> Cannot execute sql command drop procedure
sp_LU_SoftwareCode
<09-17-2009 11:47:56> Deleting AA SP's Created for temporary usage drop
procedure sp_LU_SoftwareHash
<09-17-2009 11:47:56> SqlExecute <drop procedure sp_LU_SoftwareHash>
<09-17-2009 11:47:56> CSql::Execute failed, SQL error
<[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
>
<09-17-2009 11:47:56> Cannot execute sql command drop procedure
sp_LU_SoftwareHash
<09-17-2009 11:47:56> Deleting AA SP's Created for temporary usage drop
procedure sp_LU_CPU
<09-17-2009 11:47:56> SqlExecute <drop procedure sp_LU_CPU>
<09-17-2009 11:47:56> CSql::Execute failed, SQL error
<[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
>
<09-17-2009 11:47:56> Cannot execute sql command drop procedure sp_LU_CPU
<09-17-2009 11:47:56> Deleting AA SP's Created for temporary usage drop
procedure sp_LU_ExecutableArtifact
<09-17-2009 11:47:56> SqlExecute <drop procedure sp_LU_ExecutableArtifact>
<09-17-2009 11:47:56> CSql::Execute failed, SQL error
<[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
>
<09-17-2009 11:47:56> Cannot execute sql command drop procedure
sp_LU_ExecutableArtifact
<09-17-2009 11:47:56> Deleting AA SP's Created for temporary usage drop
procedure sp_LU_HardwareRequirements
<09-17-2009 11:47:56> SqlExecute <drop procedure sp_LU_HardwareRequirements>
<09-17-2009 11:47:56> CSql::Execute failed, SQL error
<[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
>
<09-17-2009 11:47:56> Cannot execute sql command drop procedure
sp_LU_HardwareRequirements
<09-17-2009 11:47:56> Deleting AA SP's Created for temporary usage drop
procedure sp_LU_MSProd
<09-17-2009 11:47:56> SqlExecute <drop procedure sp_LU_MSProd>
<09-17-2009 11:47:56> CSql::Execute failed, SQL error
<[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
>
<09-17-2009 11:47:56> Cannot execute sql command drop procedure sp_LU_MSProd
<09-17-2009 11:47:56> Failed to execute sql command alter table
LU_Category ADD CONSTRAINT LU_Category_Category_FK1 FOREIGN KEY
(ParentID) REFERENCES LU_Category (CategoryID)
<09-17-2009 11:47:56> FAILED SQL Script: Create SQL object
LU_Category_Category_FK1
<09-17-2009 11:47:56> SQL error <[24000][0][Microsoft][ODBC Driver Manager]
Invalid cursor state
[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
[24000][0][Microsoft][ODBC Driver Manager] Invalid cursor state
>

0 new messages