Jump to content
We've recently updated our Privacy Statement, available here ×
  • Title: Issue while creating datasource with bigger password (encrypted).


    Swapnil Pawar
    • Features: Data Sources Version: v7.9.0 Product: JasperReports® Server

    Issue: 

    Users can get the following data truncation error when creating the datasource with a bigger password:
    ERROR SqlExceptionHelper,http-nio-8080-exec-1:131 - ERROR: value too long for type character varying(250)


    Resolution:

    Please increase the password column length in jijdbcdatasource table which is present inside the Jasperserver database. Please follow the following steps to make suggested changes.
    The following example is for the Postgresql database.

    1) In pgAdmin create a connection by right click on the server.
    2) Follow the path in pgAdmin in where we created the server connection:
    Databases ->jasperserver db -> schema ->public ->tables dropdown ->jijdbcdatasource table. Please expand that column of the jijdbcdatasource table. Right-click on the password column and select the properties option then increase the password column length to more than 250.

    This is a workaround if the upgrade in the future then you need to keep the track of such tables where you increased size of the column and need to manually increase the size of the specifci column/s size in the specific table and import the repository into the target JRS version.

    I hope this will help you!

    Thanks!


    User Feedback

    Recommended Comments

    There are no comments to display.



    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...