looks like a data_engine problem
data_engine 9.02 fails to insert QoS into the database
Article Id: 128958
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=128958that links the hotfix site and for uim 9.2.0 you want:
data_engine_9.20_HF5.zip
data_engine_9.20_HF5.txt
doubt it is related but there is also
spectrumgtw_8.67_HF6.zip
------------------------------
Support Engineer
Broadcom
------------------------------
Original Message:
Sent: 07-24-2020 03:02 PM
From: Gabriel Orlando
Subject: SPECTRUMGW error "Invalid character value for cast specification"
Hello All,
Today i started to see some alerts in the spectrumgtw:
Jul 24 15:27:47:287 [7444] 0 de: ciHostLookup - failed for dbuim,1433 (11001)
Jul 24 15:27:47:287 [7444] 0 de: ciOpen - failed to get device identifer for dbuim,1433 (3)
Jul 24 15:27:47:290 [7444] 0 de: QoS - hmm, server is responding ... something went wrong with the ADO_BulkInsert
Jul 24 15:27:19:819 [7448] 0 de: InsertRows - ERROR: Code=0x80004005 Source=Microsoft OLE DB Provider for SQL Server Description=Invalid character value for cast specification.
Jul 24 15:27:19:819 [7448] 0 de: lastsamplevalue_thread - BatchUpdate() returned: error (1)
Im getting this errors every 15 minutes, exactly at the Spectrum -> UIM Incremental alert sync.
UIM version 9.2
spectrumgtw version 8.67hf4
Spectrum version 10.4.0.0.95
Im using the UIM to Spectrum Alarms
Anyone know if this is an alert with impact and how to resolved it?
Thanks for your help!