Skip to main content
Kofax

SQLite error: table T Doc has 10 columns but 9 values were supplied

Article # 3035829 - Page views: 218

Issue

What does it mean when KnowledgeBase Learning Server (KBLS) returns this error:

SQLite error: table T_Doc has 10 columns but 9 values were supplied

Cause

If you have got a KTM 6.2 or older project and you open the project with KTM 6.3 or newer in Project Builder, then the KB learning files in the online folder are upgraded.

This relates to the *.ds file within the Online Learning folder. The *.ds file acts as the database for the files being used.

During the upgrade a new column is added. This normally happens if a user would like to test the project with a newer KTM version than the productive system. As soon as the KBLS with the old KTM version would like to access the .ds file it will fail and report this error.

Solution

If possible upgrade all stations using KTM to the newer version. By doing this the existing online learning data can still be used.

If this is a production system with KTM 6.1/6.2 then stop using KTM 6.3 or newer on the same system as this will result in the same problem again.

If you cannot upgrade to a newer version then you can:

  1. either install a backup of the online learning folder
  2. move all files in the online learning folder to a different folder. You can use this folder later to add new files to the project.
    Afterwards you need to open the project in Project Builder, go to the Project settings, remove the check box "Enabled Online Learning", click okay, go to the settings again and set the check box "Enable Online Learning" and confirm to the create files again. This will create an empty document set ready to for KBLS. Verify if the docstorage.ds file size is greater than 10 kBytes. If the file size is 0 then you need to do it again.

 

Level of Complexity 

Moderate

 

Applies to  

Product Version Build Environment Hardware
Kofax Transformation Modules 6.1, 6.2      

 

References

Add any references to other internal or external articles

 

 

Article # 3035829
  • Was this article helpful?