SOI 3.3.2 error on SA Manager

View Only

Back to discussions

Expand all | Collapse all

1. SOI 3.3.2 error on SA Manager

Recommend

Orchyl salmasan

Posted Dec 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

Stopped CA Catalyst Container(SCOM connector), CA SAM Integration Services(Spectrum Connector), CA SAM Event management
Stopped UI Server CA SAM User Interface Server and CA SAM Store Indexer
runned soitoolbox.exe --stopAllServices on SA Manager server
Start "CA SAM Application Server" Service
Start "CA UCF Broker" Service
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.
Start "CA SAM Event Management" Service
Started UI Servers.
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 ==== (

)
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.
------------------------------