Reset Search
 

 

Article

Unable to create event report with "Upload to cloud" option checked

« Go Back

Information

 
TitleUnable to create event report with "Upload to cloud" option checked
Symptoms
  • Unable to start Venue Reports "Event Report"
  • Error... A truncation error was encountered trying to shrink VARCHAR
  • Following Exception seen in server.log:
    ERROR [com.enterasys.fusion.oneview.OneViewStadiumReportUtility] Error: : java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR 'task=radiocsv;ssid=fanTM;cloud=box;start=1533418200000;stop=&' to length 255.
Environment
  • Extreme Management Center 8.x
  • Venue Reports Module
Cause
File path has grown too large for database field
Resolution
SSH to the Extreme Management Server and run the following commands: 
  1. cd /usr/local/Extreme_Networks/NetSight/java/db/bin
  2. cp ij /root/ij
  3. vi ij
  4. Once you are editing the ij file search for DERBY_LIB="${DERBY_HOME}/lib" and add the following line before it: 
    JAVA_HOME=/usr/local/Extreme_Networks/NetSight/java
    
    It will look like this: 
    JAVA_HOME=/usr/local/Extreme_Networks/NetSight/java 
    # set DERBY_LIB location 
    DERBY_LIB="${DERBY_HOME}/lib
  5. chmod 755 ij
  6. ./ij
  7. Connect to the scheduler database with the following command: 
    connect 'jdbc:derby://127.0.0.1:1527/../standalone/configuration/connect/oneFabricConnectRpt;user=ofc;password=OneFabricConnect';
  8. Run the following SQL query to increase the column size: 
    alter table REPORTSCHEDULER alter column PARAMS set data type varchar(512);
  9. Run the following SQL query to confirm the field has changed: 
    describe REPORTSCHEDULER;
You should see: 
COLUMN_NAME |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL& 
------------------------------------------------------------------------------ 
RUNON |BIGINT |0 |10 |19 |NULL |NULL |YES 
CATEGORY |VARCHAR |NULL|NULL|128 |NULL |256 |YES 
NAME |VARCHAR |NULL|NULL|128 |NULL |256 |YES 
PARAMS |VARCHAR |NULL|NULL|512 |NULL |1024 |YES 
CUSTOM1 |VARCHAR |NULL|NULL|255 |NULL |510 |YES 
CUSTOM2 |VARCHAR |NULL|NULL|255 |NULL |510 |YES 
CUSTOM3 |VARCHAR |NULL|NULL|255 |NULL |510 |YES
 

 

 
Additional notes

Feedback

 

Was this article helpful?


   

Feedback

Please tell us how we can make this article more useful.

Characters Remaining: 255