DX Operational Intelligence

SOI 3.3.2 error on SA Manager

  • 1.  SOI 3.3.2 error on SA Manager

    Posted 12-01-2019 10:24 AM
    Hi can someone help me? Tried restarting SOI services but it didn't come back up.
    The order of restart was
    1. Stopped CA Catalyst Container(SCOM connector), CA SAM Integration Services(Spectrum Connector), CA SAM Event management
    2. Stopped UI Server CA SAM User Interface Server and CA SAM Store Indexer
    3. runned soitoolbox.exe --stopAllServices on SA Manager server
    4. Start "CA SAM Application Server" Service 
    5. Start "CA UCF Broker" Service
    6. Go to "Triage Tests" in the left side menu
      Click on Run Tests
      Wait until "Sever application startup" is COMPLETED, It takes about 5-10 min.
    7. Start "CA SAM Event Management" Service
    8. Started UI Servers.
    9. Started Connectors.

    This is my first time to encounter this error.

    Please see error logs
    51054: 2019-12-01 10:14:33,371 INFO  [JMS SOICONNJ02.eyedcny.local] connector.ConnectorManager$MyListener.onCIStagingBulk(1289)  - java.lang.Exception: Error writing objects. org.hibernate.exception.DataException: could not update: [com.ca.sam.manager.hibernate.CIStaging#component[ciNamespaceMapId,connectorID]{connectorID=13, ciNamespaceMapId=0x11603f}]:[InstanceID=Port:devicednsname,core_sw02.pt01_ethernet1/31:Port:ethernetCsmacd:00-2A-6A-2F-AC-E6:Module:Unknown:436330496, DeviceID=devicednsname,core_sw02.pt01_ethernet1/31, ClassID=29, IPAddress=10.10.0.3, Vendor=Cisco Systems, Inc., Label=Core_SW02.PT01_Ethernet1/31, Description=Ethernet1/31, CILiCURL=null, CINamespaceMapID=0x11603f, ConnectorId=13, Category=ethernetCsmacd, siloResourceId=Port:sysname,core_sw02.pt01:Port:ethernetCsmacd:00-2A-6A-2F-AC-E6:Module:Unknown:436330496, CiId=238724, KeyValue1=Core_SW02.PT01, KeyValue2=Core_SW02.PT01, KeyValue3=null, KeyValue4=null, KeyValue5=SSI1711076E;TED1639CQ43;TED1639CQ43;TED1639CQ43;TED1639CQ43;TED1639CQ43;JUS1711B71S;JUS1711B71S;JUS1711B71S;JUS1711B71S;JUS1711B71S;JUS1711B7C7;JUS1711B7C7;JUS1711B7C7;JUS1711B7C7;JUS1711B7C7;JUS1710BC5F;JUS1710BC5F;JUS1710BC5F;JUS1710BC5F;JUS1710BC5F;JUS1710BC7C;JUS1710BC7C;JUS1710BC7C;JUS1710BC7C;JUS1710BC7C;JUS1710BC5L;JUS1710BC5L;JUS1710BC5L;JUS1710BC5L;JUS1710BC5L;JUS1710BC5M;JUS1710BC5M;JUS1710BC5M;JUS1710BC5M;JUS1710BC5M;JUS1710BC5P;JUS1710BC5P;JUS1710BC5P;JUS1710BC5P;JUS1710BC5P;JUS1710BC5Q;JUS1710BC5Q;JUS1710BC5Q;JUS1710BC5Q;JUS1710BC5Q;JUS1710BC5N;JUS1710BC5N;JUS1710BC5N;JUS1710BC5N;JUS1710BC5N;JUS1710BC5K;JUS1710BC5K;JUS1710BC5K;JUS1710BC5K;JUS1710BC5K;JUS1711B8LT;JUS1711B8LT;JUS1711B8LT;JUS1711B8LT;JUS1711B8LT;JUS1711B7C5;JUS1711B7C5;JUS1711B7C5;JUS1711B7C5;JUS1711B7C5;AVD1725A9WA;AVD1725A9WA;AVD1725A9WA;AVD1725A9WA;AVD1725A9WA;FNS17361YHW;FNS17361YHW;FNS17361YHW;FNS17361YHW;FNS17361YHW;FNS18272PEE;FNS18272PEE;FNS18272PEE;FNS18272PEE;FNS18272PEE;FNS18272MY4;FNS18272MY4;FNS18272MY4;FNS18272MY4;FNS18272MY4;FNS18272ER7;FNS18272ER7;FNS18272ER7;FNS18272ER7;FNS18272ER7;AGA144747A9;AGA144747A9;AGA144747A9;AGA144747A9;AGA144747A9;SPC151808ZP;SPC151808ZP;SPC151808ZP;SPC151808ZP;SPC151808ZP;FNS18283873;FNS18283873;FNS18283873;FNS18283873;FNS18283873;FNS18291A83;FNS18291A83;FNS18291A83;FNS18291A83;FNS18291A83;AVA1730AMH7;AVA1730AMH7;AVA1730AMH7;AVA1730AMH7;AVA1730AMH7;AVA1730A2L9;AVA1730A2L9;AVA1730A2L9;AVA1730A2L9;AVA1730A2L9, KeyValue6=null, KeyValue7=null, KeyValue8=null, KeyValue9=10.10.0.3, KeyValue10=00-2A-6A-2F-AD-01, KeyValue11=null, KeyValue12=null, KeyValue13=null, KeyValue14=null, KeyValue15=null, KeyValue16=null, adminStatus=0, notebookId=EC6AB7460AEC47D8997DEEDFA95C4F75, sheetID=4E4DFA323D04450FAC9F6A6739DB8CE5, tenantID=null, userCol1=null, userCol2=null, userCol3=null, userCol4=null, userCol5=null, userCol6=null, userCol7=null, userCol8=null, userCol9=null, userCol10=null]
    51055: 2019-12-01 10:14:33,409 ERROR [JMS SOICONNJ02.eyedcny.local] util.JDBCExceptionReporter.logExceptions(78)  - Data truncation
    51056: 2019-12-01 10:14:33,410 ERROR [JMS SOICONNJ02.eyedcny.local] util.JDBCExceptionReporter.logExceptions(78)  - String or binary data would be truncated.
    51057: 2019-12-01 10:14:33,410 ERROR [JMS SOICONNJ02.eyedcny.local] def.AbstractFlushingEventListener.performExecutions(301)  - Could not synchronize database state with session
    51058: org.hibernate.exception.DataException: could not update: [com.ca.sam.manager.hibernate.CIStaging#component[ciNamespaceMapId,connectorID]{connectorID=13, ciNamespaceMapId=0x116302}]
    51059: 	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
    51060: 	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
    51061: 	at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2430)
    51062: 	at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2312)
    ...
    [467] ==== 51163,24 ==== (
    prev
    -
    more
    -
    next
    )
    51160: 	... 36 more
    51161: 
    51162: 2019-12-01 10:14:33,412 INFO  [JMS SOICONNJ02.eyedcny.local] connector.ConnectorManager$MyListener.onCIStagingBulk(1289)  - java.lang.Exception: Error writing objects. org.hibernate.exception.DataException: could not update: [com.ca.sam.manager.hibernate.CIStaging#component[ciNamespaceMapId,connectorID]{connectorID=13, ciNamespaceMapId=0x116302}]:[InstanceID=Port:devicednsname,core_sw01.pt01_ethernet106/1/44:Port:ethernetCsmacd:50-06-04-82-1C-2D:Module:Unknown:526977728, DeviceID=devicednsname,core_sw01.pt01_ethernet106/1/44, ClassID=29, IPAddress=10.10.0.2, Vendor=Cisco Systems, Inc., Label=Core_SW01.PT01_Ethernet106/1/44, Description=Ethernet106/1/44, CILiCURL=null, CINamespaceMapID=0x116302, ConnectorId=13, Category=ethernetCsmacd, siloResourceId=Port:sysname,core_sw01.pt01:Port:ethernetCsmacd:50-06-04-82-1C-2D:Module:Unknown:526977728, CiId=242251, KeyValue1=Core_SW01.PT01, KeyValue2=Core_SW01.PT01, KeyValue3=null, KeyValue4=null, KeyValue5=SSI171100HS;TED1639CQ43;TED1639CQ43;TED1639CQ43;TED1639CQ43;TED1639CQ43;JUS1711B8LU;JUS1711B8LU;JUS1711B8LU;JUS1711B8LU;JUS1711B8LU;JUS1711B7C8;JUS1711B7C8;JUS1711B7C8;JUS1711B7C8;JUS1711B7C8;JUS1711B9FZ;JUS1711B9FZ;JUS1711B9FZ;JUS1711B9FZ;JUS1711B9FZ;JUS1711B9FP;JUS1711B9FP;JUS1711B9FP;JUS1711B9FP;JUS1711B9FP;JUS1711B8MN;JUS1711B8MN;JUS1711B8MN;JUS1711B8MN;JUS1711B8MN;JUS1711B8LV;JUS1711B8LV;JUS1711B8LV;JUS1711B8LV;JUS1711B8LV;JUS1711B9FY;JUS1711B9FY;JUS1711B9FY;JUS1711B9FY;JUS1711B9FY;JUS1711BA1J;JUS1711BA1J;JUS1711BA1J;JUS1711BA1J;JUS1711BA1J;JUS1711B8MK;JUS1711B8MK;JUS1711B8MK;JUS1711B8MK;JUS1711B8MK;JUS1711B8MJ;JUS1711B8MJ;JUS1711B8MJ;JUS1711B8MJ;JUS1711B8MJ;JUS1711B8M2;JUS1711B8M2;JUS1711B8M2;JUS1711B8M2;JUS1711B8M2;JUS1711B9FT;JUS1711B9FT;JUS1711B9FT;JUS1711B9FT;JUS1711B9FT;AVD1725AMVM;AVD1725AMVM;AVD1725AMVM;AVD1725AMVM;AVD1725AMVM;FNS18272PGA;FNS18272PGA;FNS18272PGA;FNS18272PGA;FNS18272PGA;FNS182919J4;FNS182919J4;FNS182919J4;FNS182919J4;FNS182919J4;FNS18272NZE;FNS18272NZE;FNS18272NZE;FNS18272NZE;FNS18272NZE;AGD1334302L;AGD1334302L;AGD1334302L;AGD1334302L;AGD1334302L;FNS13370NK7;FNS13370NK7;FNS13370NK7;FNS13370NK7;FNS13370NK7;AGA144646HT;AGA144646HT;AGA144646HT;AGA144646HT;AGA144646HT;FNS182838BQ;FNS182838BQ;FNS182838BQ;FNS182838BQ;FNS182838BQ;FNS18291HFD;FNS18291HFD;FNS18291HFD;FNS18291HFD;FNS18291HFD;AVA1730A95U;AVA1730A95U;AVA1730A95U;AVA1730A95U;AVA1730A95U;AVA1730A9LU;AVA1730A9LU;AVA1730A9LU;AVA1730A9LU;AVA1730A9LU, KeyValue6=null, KeyValue7=null, KeyValue8=null, KeyValue9=10.10.0.2, KeyValue10=00-2A-6A-30-3B-3C, KeyValue11=null, KeyValue12=null, KeyValue13=null, KeyValue14=null, KeyValue15=null, KeyValue16=null, adminStatus=0, notebookId=9695769B497243D1ABD86679C14631DA, sheetID=DB39F1AE5FF74571BE854475739EF8E3, tenantID=null, userCol1=null, userCol2=null, userCol3=null, userCol4=null, userCol5=null, userCol6=null, userCol7=null, userCol8=null, userCol9=null, userCol10=null]
    51163: 2019-12-01 10:14:33,431 ERROR [JMS SOICONNJ02.eyedcny.local] util.JDBCExceptionReporter.logExceptions(78)  - Data truncation
    51164: 2019-12-01 10:14:33,432 ERROR [JMS SOICONNJ02.eyedcny.local] util.JDBCExceptionReporter.logExceptions(78)  - String or binary data would be truncated.
    51165: 2019-12-01 10:14:33,432 ERROR [JMS SOICONNJ02.eyedcny.local] def.AbstractFlushingEventListener.performExecutions(301)  - Could not synchronize database state with session
    51166: org.hibernate.exception.DataException: could not update: [com.ca.sam.manager.hibernate.CIStaging#component[ciNamespaceMapId,connectorID]{connectorID=13, ciNamespaceMapId=0x11603e}]
    51167: 	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
    51168: 	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)


    ------------------------------
    NOC Engineer
    Sizmek Technologies Inc.
    ------------------------------