12-21-2017 12:02 AM - edited 03-01-2019 03:20 PM
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
Solved! Go to Solution.
12-21-2017 12:32 AM
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)
12-21-2017 12:32 AM
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)
12-21-2017 10:58 PM
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: