Re: Error at SAMBP 9.4 install (255 Views)
Reply
Occasional Advisor
Pasol
Posts: 15
Registered: ‎08-02-2012
Message 1 of 5 (305 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?

 

Please use plain text.
HP Expert
Priya_B
Posts: 531
Registered: ‎10-25-2012
Message 2 of 5 (269 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 !
Please use plain text.
Occasional Advisor
Pasol
Posts: 15
Registered: ‎08-02-2012
Message 3 of 5 (255 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) 

 

Please use plain text.
HP Expert
Priya_B
Posts: 531
Registered: ‎10-25-2012
Message 4 of 5 (220 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 !
Please use plain text.
HP Expert
Priya_B
Posts: 531
Registered: ‎10-25-2012
Message 5 of 5 (208 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 !
Please use plain text.
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