cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1134
Views
0
Helpful
2
Replies
Beginner

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Cisco Employee

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

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)

View solution in original post

2 REPLIES 2
Highlighted
Cisco Employee

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

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)

View solution in original post

Highlighted
Beginner

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

Many thanks, works like a charm.

Cheers,
Rene
CreatePlease to create content