iPrint Appliance web console page returns RPC error after import appliance 1.1 configuration

  • Document ID:7017851
  • Creation Date:15-Jul-2016
  • Modified Date:21-Jul-2016
    • Micro Focus Products:
      iPrint

Environment

iPrint Appliance 2.0
iPrint Appliance 2.0 patch 1

Situation

After import iprintconfig.zip from 1.1 iPrint Appliance into an iPrint 2.0 Appliance, accessing the 2.0 web console's configuration page returns an RPC error.  Clicking on the details returns the following:

Jul 14, 2016 4:35:25 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Allocate exception for servlet appServlet
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'Generic+PostScript+Printer+Foomatic%2FPostscript+%28recommended%' for key 'UK_5spxwd4doey4jvgem7dgda955'
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:86)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:58)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:542)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    at com.mysql.jdbc.Util.getInstance(Util.java:381)

Resolution

  1. Apply Patch 5 to the 1.1 iPrint Appliance.
    • This will bring the iPrint Appliance server to version 420.
  2. Again export the iprintconfig.zip
  3. Configure a new 2.x iPrint Appliance.
  4. Use the newly generated iprintconfig.zip to Upgrade or Migrate to the 2.x iPrint Appliance.

Cause

Having Patch 5 applied to 1.1 iPrint Appliance is a requirement to upgrading to 2.x.  Without having Patch 5, the default driver will not be set on the MYSQL database, resulting in a MYSQL syntax violation.