Cisco Software Manager (CSM) - (DataError) (1406, u"Data too long...

[raichmayer]

HI, I recently installed CSM 3.5, and enabled 2 ASR9ks as hosts. Unfortunately, CSM cannont sucessfully retrieve the inventory.

It ends with this Error:

InvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (DataError) (1406, u"Data too long for column 'hardware_revision' at row 1") 'INSERT INTO inventory (serial_number, host_id, name, model_name, description, hardware_revision, notes, changed_time) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)' ('MTC15240AP9', 2, 'module mau GigabitEthernet501/0/CPU0/0', 'Invalid EEPROM', 'CISCO-METHODE', 'Invalid EEPROM', '', datetime.datetime(2017, 12, 20, 16, 27, 22, 163063))

To me it seems CSM cannot handle unidentified SFPs as the information retrieved does not fit into predefined variables. Is there anything I can do?

Regards, Rene

[alextang · Accepted solution]

Hi Rene,

The SFP has a wrong hardware revision which exceeds the database column name.  To fix this issue, please follow the steps below

1) Stop CSM Server (./csmserver stop)

2) Type, mysql -u root -p (then enter the password)

3) Type, use csmdb;

4) Type, alter table inventory modify hardware_revision VARCHAR(30);

5) Type, alter table host_inventory modify hardware_revision VARCHAR(30);

6) Type, exit

7) Restart CSM Server (./csmserver start)

[raichmayer]

Many thanks, works like a charm.

Cheers,
Rene