Error at SAMBP 9.4 install (502 Views)
Reply
Occasional Advisor
Pasol
Posts: 15
Registered: ‎08-02-2012
Message 1 of 5 (502 Views)

Error at SAMBP 9.4 install

Try to install SAMBP 9.4. In the log see "Error: seTipe don't exist in amInventModel table..."
As a result don't imported SKU Library.

I try install it on AM 9.30 and AM 9.32, results were identic.

Do I need install some path or previus vercions of SAMBP?

 

HP Expert
Priya_B
Posts: 534
Registered: ‎10-25-2012
Message 2 of 5 (466 Views)

Re: Error at SAMBP 9.4 install

Could you let us know the OS version where you are installing the package ?

 

ALso, the exact error received.

 

 

 

HP Support - If this post or any post helps you resolve an issue, please be sure to mark it as an acceptable solution.
Like a post, Please click Kudos to show appreciation !
Occasional Advisor
Pasol
Posts: 15
Registered: ‎08-02-2012
Message 3 of 5 (452 Views)

Re: Error at SAMBP 9.4 install

[ Edited ]

Windows Server Enterprise SP2 (32-bit)

 

Error text is very long (also there are other errors, insert full log):

[Info] [Db] Connecting to server 'AMDemo93en'... 
[Info] FIPS mode not supported by the SSL library. 
[Info] [Db] User login 'Admin' 
[Info] [Db] Checking database structure... 
[Info] [Db] Reading database structure... 
[Info] [Db] Checking database structure... 
[Info] Verifying Asset Manager Automated Process Manager 
[Warning] Asset Manager Automated Process Manager has not been launched on this database for more than an hour. this process, monitoring functions are suspended (alarms, deadlines, purchase approvals, stock levels). 
[Info] Loading import script... 
[Info] Starting import... 
[Info] Starting import... 
[Info] Opening source database... 
[Info] [Db] Connecting to server 'sam4commonfuncdomain.scr'... 
[Info] Verifying reconciliation keys 
[Info] Count records 
[Info] Counting records in table 'FuncDomain (FuncDomain)' 
[Info] Importing table: 'FuncDomain (FuncDomain)'... 
[Info] End of import of table 'FuncDomain (FuncDomain)', 3 record(s) processed in 0s 
[Info] Import successfully completed (Total time=0s). 
[Info] [Db] Disconnecting from server 'sam4commonfuncdomain.scr'... 
[Info] Loading import script... 
[Info] Starting import... 
[Info] Starting import... 
[Info] Opening source database... 
[Info] [Db] Connecting to server 'statistics.scr'... 
[Info] Verifying reconciliation keys 
[Info] Count records 
[Info] Counting records in table 'dashquery (dashquery)' 
[Info] Counting records in table 'dashstat (dashstat)' 
[Info] Counting records in table 'dashctn (dashctn)' 
[Info] Counting records in table 'da**bleep**em (da**bleep**em)' 
[Info] Importing table: 'dashquery (dashquery)'... 
[Info] End of import of table 'dashquery (dashquery)', 1 record(s) processed in 0s 
[Info] Importing table: 'dashstat (dashstat)'... 
[Info] End of import of table 'dashstat (dashstat)', 6 record(s) processed in 0s 
[Info] Importing table: 'dashctn (dashctn)'... 
[Info] End of import of table 'dashctn (dashctn)', 0 record(s) processed in 0s 
[Info] Importing table: 'da**bleep**em (da**bleep**em)'... 
[Info] End of import of table 'da**bleep**em (da**bleep**em)', 0 record(s) processed in 0s 
[Info] Import successfully completed (Total time=0s). 
[Info] [Db] Disconnecting from server 'statistics.scr'... 
[Info] Loading import script... 
[Info] Starting import... 
[Info] Starting import... 
[Info] Opening source database... 
[Info] [Db] Connecting to server 'fdview.scr'... 
[Info] Verifying reconciliation keys 
[Info] Count records 
[Info] Counting records in table 'fdviews (fdviews)' 
[Info] Counting records in table 'fdvactions (fdvactions)' 
[Info] Counting records in table 'fdvstatistics (fdvstatistics)' 
[Info] Counting records in table 'fdvreports (fdvreports)' 
[Info] Importing table: 'fdviews (fdviews)'... 
[Info] End of import of table 'fdviews (fdviews)', 1 record(s) processed in 0s 
[Info] Importing table: 'fdvactions (fdvactions)'... 
[Info] End of import of table 'fdvactions (fdvactions)', 0 record(s) processed in 0s 
[Info] Importing table: 'fdvstatistics (fdvstatistics)'... 
[Info] End of import of table 'fdvstatistics (fdvstatistics)', 6 record(s) processed in 0s 
[Info] Importing table: 'fdvreports (fdvreports)'... 
[Info] End of import of table 'fdvreports (fdvreports)', 0 record(s) processed in 0s 
[Info] Import successfully completed (Total time=0s). 
[Info] [Db] Disconnecting from server 'fdview.scr'... 
[Info] Loading import script... 
[Info] Starting import... 
[Info] Starting import... 
[Info] Opening source database... 
[Info] [Db] Connecting to server 'sam4commonsyscfg.scr'... 
[Info] Verifying reconciliation keys 
[Info] Count records 
[Info] Counting records in table 'sysconfig (sysconfig)' 
[Info] Importing table: 'sysconfig (sysconfig)'... 
[Info] End of import of table 'sysconfig (sysconfig)', 2 record(s) processed in 0s 
[Info] Import successfully completed (Total time=0s). 
[Info] [Db] Disconnecting from server 'sam4commonsyscfg.scr'... 
[Info] Loading import script... 
[Info] Starting import... 
[Info] Starting import... 
[Info] Opening source database... 
[Info] [Db] Connecting to server 'sam4commonnature.scr'... 
[Info] Verifying reconciliation keys 
[Info] Count records 
[Info] Counting records in table 'Nature (Nature)' 
[Info] Importing table: 'Nature (Nature)'... 
[Info] Importing line 7 from table 'Nature' 
[Error] (-2010) Value '9' is not valid in the itemized list ('Portfolio item', 'Work order', 'Contract', 'Training', 'Cable', 'Nothing')
[Error] (-2010) Incorrect value '9' in field 'seBasis (seBasis)'
[Info] End of import of table 'Nature (Nature)', 7 record(s) processed in 0s 
[Info] Import successfully completed (Total time=0s). 
[Info] [Db] Disconnecting from server 'sam4commonnature.scr'... 
[Info] Loading import script... 
[Info] Starting import... 
[Info] Starting import... 
[Info] Opening source database... 
[Info] [Db] Connecting to server 'model.scr'... 
[Info] Verifying reconciliation keys 
[Info] Count records 
[Info] Counting records in table 'Model (Model)' 
[Info] Importing table: 'Model (Model)'... 
[Info] End of import of table 'Model (Model)', 4 record(s) processed in 0s 
[Info] Import successfully completed (Total time=0s). 
[Info] [Db] Disconnecting from server 'model.scr'... 
[Info] Loading import script... 
[Info] Starting import... 
[Info] Starting import... 
[Info] Opening source database... 
[Info] [Db] Connecting to server 'sam4commonCalculatedFields.scr'... 
[Info] Verifying reconciliation keys 
[Info] Count records 
[Info] Counting records in table 'CalculatedFields (CalculatedFields)' 
[Info] Importing table: 'CalculatedFields (CalculatedFields)'... 
[Info] Importing line 5 from table 'CalculatedFields' 
[Error] (-2004) ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'dbo.amCalcField' with unique index 'Cf_TableNameDescri'. SQLSTate: 23000
[Error] (-2004) ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. SQLSTate: 01000
[Error] (-2004) Index error: A record in table 'Calculated fields (amCalcField)' with the values 'amSoftLicCounter' for field 'Table (TableName)', 'Cost For Compliance' for field 'Description (Description)' already exists in the database.
[Error] (-2004) Index error: A record in table 'Calculated fields (amCalcField)' with the values 'amSoftLicCounter' for field 'Table (TableName)', 'Cost For Compliance' for field 'Description (Description)' already exists in the database.
[Warning] CalculatedFields: : Invalid record encountered importing into table 'Calculated fields (amCalcField)' 
[Warning] C:\Program Files\HP\HP Asset Manager SAM Best Practice Package Installer\sambpscript\common\content\calculatedfields\CalculatedFields.txt (Line 5) 
[Info] End of import of table 'CalculatedFields (CalculatedFields)', 3 record(s) processed in 0s 
[Info] Import successfully completed (Total time=0s). 
[Info] [Db] Disconnecting from server 'sam4commonCalculatedFields.scr'... 
[Info] Loading import script... 
[Info] Starting import... 
[Info] Starting import... 
[Info] Opening source database... 
[Info] [Db] Connecting to server 'scriptlib.scr'... 
[Info] Verifying reconciliation keys 
[Info] Count records 
[Info] Counting records in table 'Sam4CommonLib (Sam4CommonLib)' 
[Info] Importing table: 'Sam4CommonLib (Sam4CommonLib)'... 
[Info] End of import of table 'Sam4CommonLib (Sam4CommonLib)', 3 record(s) processed in 0s 
[Info] Import successfully completed (Total time=0s). 
[Info] [Db] Disconnecting from server 'scriptlib.scr'... 
[Info] Loading import script... 
[Info] Starting import... 
[Info] Starting import... 
[Info] Opening source database... 
[Info] [Db] Connecting to server 'wfeventupdate.scr'... 
[Info] Verifying reconciliation keys 
[Info] Count records 
[Info] Counting records in table 'wfevent (wfevent)' 
[Info] Importing table: 'wfevent (wfevent)'... 
[Info] End of import of table 'wfevent (wfevent)', 0 record(s) processed in 0s 
[Info] Import successfully completed (Total time=0s). 
[Info] [Db] Disconnecting from server 'wfeventupdate.scr'... 
[Info] Loading import script... 
[Info] Starting import... 
[Info] Starting import... 
[Info] Opening source database... 
[Info] [Db] Connecting to server 'wf.scr'... 
[Info] Verifying reconciliation keys 
[Info] Count records 
[Info] Counting records in table 'wfwactn (wfwactn)' 
[Info] Counting records in table 'wfrole (wfrole)' 
[Info] Counting records in table 'wfwf (wfwf)' 
[Info] Counting records in table 'wfstart (wfstart)' 
[Info] Counting records in table 'wfactiv (wfactiv)' 
[Info] Counting records in table 'wfchoic (wfchoic)' 
[Info] Counting records in table 'wfevent (wfevent)' 
[Info] Counting records in table 'wftrans (wftrans)' 
[Info] Counting records in table 'wfstop (wfstop)' 
[Info] Counting records in table 'wfrelac (wfrelac)' 
[Info] Counting records in table 'wfwalrm (wfwalrm)' 
[Info] Counting records in table 'wfenums (wfenums)' 
[Info] Importing table: 'wfwactn (wfwactn)'... 
[Info] Importing line 9 from table 'wfwactn' 
[Error] (-53) Field 'seType' is unknown in table 'Inventoried models (amInventModel)'.
[Error] (-70) Error in Basic script ''Database action' of table 'Inventoried models (amInventModel)''' This action is triggered by a Workflow when an inventory model is resolved or when a portfolio item gets linked to an inventory model.' It updates the portfolio item's (items') Model and VersionLevel based on amInventModel.ModelFinal and .VersionLevel respectivelylErr As Long[bResolved] <> 0 Then '----------------------------------------------- ' Resolved Items : update portfolio items ' Note : both [lModelFinalId] and [bResolved] must be set ! '----------------------------------------------- '----------------------------------------- ' For the possibility of change softwareindtall of other tenant '----------------------------------------- If [CurrentUser.bAdminRight] Then    AmSetVisibleTenants(3) End IF If [seType] = 0 Then    lErr = amDbExecAql("UPDATE amSoftInstall SET lModelId = " & [lModelFinalId] & ", VersionLevel = '" & [VersionLevel] & "' WHERE lInventModelId = " & [lInventModelId] )    lErr = amDbExecAql("UPDATE amPortfolio SET lModelId = " & [lModelFinalId] & " WHERE lInventModelId = " & [lInventModelId])    lErr = amDbExecAql("UPDATE amMonitoredApp SET lModelId = " & [lModelFinalId] & " WHERE lInventModelId = " & [lInventModelId])    lErr = amDbExecAql("UPDATE amMonSWComp SET lModelId = " & [lModelFinalId] & " WHERE lInventModelId = " & [lInventModelId]) Else    lErr = amDbExecAql("UPDATE amPortfolio SET lModelId = " & [lModelFinalId] & ", Asset.lModelId = " & [lModelFinalId] & ", Asset.VersionLevel = '" & [VersionLevel] & "', Asset.lLicTypeId = " & [ModelFinal.lLicTypeId] & " WHERE lInventModelId = " & [lInventModelId]) End IfIf
[Info] Importing line 10 from table 'wfwactn' 
[Error] (-53) Field 'lSoftLicUseRights' is unknown in table 'Inventoried models (amInventModel)'.
[Error] (-70) Error in Basic script ''Database action' of table 'Inventoried models (amInventModel)''hqModel As LonghrModel As LonglModelId As LonglErr As LongModelName As String= [ModelName][lModelFinalId] <> 0 Then Print "sysCreateLicModelFinal - A definitive model already exists for this SKU"[lModelParentId] = 0 Then Err.Raise( -1, "The definitive model cannot be created because the category (parent model) has not been specified" )ModelName = "" Then Err.Raise( -1, "The definitive model cannot be created because the name has not been specified" ) 'All the data is there. Check for conflicts hqModel = AmQueryCreate() lErr = AmQueryGet( hqModel, "SELECT lModelId, lBrandId, VersionLevel FROM amModel WHERE lParentId = " & [lModelParentId] & " AND Name = '" & ModelName & "'" ) If lErr = 0 Then   'The model already exists. Use it.   lModelId = AmGetFieldLongValue( hqModel, 0 )   If [lBrandId] <> AmGetFieldLongValue( hqModel, 1 ) Then Print "sysCreateLicModelFinal - Warning: The brand of the definitive model that is being used is not the same as the one specified for the SKU"   If [VersionLevel] <> AmGetFieldStrValue( hqModel, 2 ) And "" <> AmGetFieldStrValue( hqModel, 2 ) Then Print "sysCreateLicModelFinal - Warning: The version of the definitive model that is being used is not the same as the one specified for the SKU"   lErr = AmReleaseHandle( hqModel ) Else   'The model does not exist yet. Create it.   lErr = AmReleaseHandle( hqModel )   If [lModelTmpId] = 0 Then     Err.Raise( -1, "The definitive model cannot be created because the temporary model has not been specified" )   Else     hrModel  = AmCreateRecord( "amModel" )       lModelId = AmGetRecordId( hrModel )       lErr = AmSetFieldLongValue( hrModel, "lParentId",  [lModelParentId] )       lErr = AmSetFieldStrValue( hrModel, "Name", ModelName )       If [lSoftLicUseRights] > 0 Then lErr = AmSetFieldStrValue( hrModel, "lSoftLicUseRights", [lSoftLicUseRights] )       If [P
[Info] End of import of table 'wfwactn (wfwactn)', 10 record(s) processed in 0s 
[Info] Importing table: 'wfrole (wfrole)'... 
[Info] End of import of table 'wfrole (wfrole)', 1 record(s) processed in 0s 
[Info] Importing table: 'wfwf (wfwf)'... 
[Error] (-2010) The context of the start object cannot be changed for workflow scheme 'Update version of licenses under maintenance' for as long as it contains initial events.
[Error] (-2010) An integrity was not correctly applied (no additional information available).
[Info] Error occurred while importing (Total time=0s). 
[Info] [Db] Disconnecting from server 'wf.scr'... 
[Info] [Db] Disconnecting from server 'AMDemo93en'... 
[Info] Operation completed (RC=-2010) 

 

HP Expert
Priya_B
Posts: 534
Registered: ‎10-25-2012
Message 4 of 5 (417 Views)

Re: Error at SAMBP 9.4 install

Hello,

 

Do you have the same error in all the versions ? Is SAM BP already installed ? If it is we might have to raise a defect for the same. Could you try in another system ?

 

COuld you give us the exact options you select during install ?

HP Support - If this post or any post helps you resolve an issue, please be sure to mark it as an acceptable solution.
Like a post, Please click Kudos to show appreciation !
HP Expert
Priya_B
Posts: 534
Registered: ‎10-25-2012
Message 5 of 5 (405 Views)

Re: Error at SAMBP 9.4 install

Importing all the SKUs will take a very long time around 2 hours. Could you let us know which operating system is being used here ? ALso is this an upgrade from a previous version and were there any SAM BPs installed in there before ?

HP Support - If this post or any post helps you resolve an issue, please be sure to mark it as an acceptable solution.
Like a post, Please click Kudos to show appreciation !
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.