DX Unified Infrastructure Management

 View Only
  • 1.  SPECTRUMGW error "Invalid character value for cast specification"

    Posted Jul 24, 2020 03:03 PM
    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!


  • 2.  RE: SPECTRUMGW error "Invalid character value for cast specification"
    Best Answer

    Posted Jul 24, 2020 03:24 PM
    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=128958

    that 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
    ------------------------------



  • 3.  RE: SPECTRUMGW error "Invalid character value for cast specification"

    Posted Jul 24, 2020 05:51 PM
    Thanks David!
    I have just installed the spectrumgtw and data_engine fix, seems to be working fine. I think the spectrumgtw hf6 include a fix to maitenance issue that i have too.

    Regards

    ------------------------------
    Cordinador Ingenieria y Soporte
    Banco Patagonia
    ------------------------------