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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide