Skip to main content
Kofax

Troubleshooting the "Could not load robot runs. Invalid column name 'BYTES'" message

Summary

12890


This error may be seen in Kapow version 9.5 and later when it is configured to use a log database that has previously been used by an older version of Kapow.

When the log view is opened in Management Console, this message may appear:

"Could not load Robot Runs"

In the RoboServer logs, the following message will be logged:

<Date> <Time> ERROR com.kapowtech.settings.DatabaseRobotLog - Unable to store into the log database.

javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'BYTES'.

Error Code: 207

The cause of this errors are the changes done to the log tables in version 9.5 of Kapow. A number of columns were added to the robot_run table in version 9.5 to include statistics from the robot execution. The new columns added are BYTES, EMAILS, HTTPREQUESTS, JSINSTRUCTIONS, KCUPOINTS, KCUWAIT, STEPS (please see the Release Notes for version 9.5 for more information).
If the new 9.5 installation is configured to use a log database that was previously used by an older version of Kapow, the tables will already be present but with the missing columns.

To fix this error, use one of the following resolutions:

  1. Create a new database for version 9.5 (or later) and set this up as RoboServer Log Database in your Management Console --> Admin --> Settings.
    This will preserve the old logs in case they are needed and the new tables will be created fresh.
  2. Drop the old table and let Kapow recreate the new one (or recreate it using the scripts from the documentation)
    This will delete all the logs created by the previous version (they need to be backed up before, if still needed).
  3. Alter the existing Robot_Run table to add the new columns. All the new columns are of data type NUMERIC(19).
    E.g. When the log database is a Microsoft SQL server database, the statement to alter the table is:
         ALTER TABLE ROBOT_RUN
            ADD BYTES Numeric(19)NULL,
                EMAILS Numeric(19)NULL,
                HTTPREQUESTS Numeric(19)NULL,
                JSINSTRUCTIONS Numeric(19)NULL,
                KCUPOINTS Numeric(19)NULL,
                KCUWAIT Numeric(19)NULL,
                STEPS Numeric(19)NULL

Keywords: Kapow Robot runs, Kapow, Robotic Process Automation