"Line 1 does not contain column#" Error When Running Index Function in Identity Governance

Products

• CA Identity Governance
• CA Identity Portal
• CA Identity Suite

Issue/Introduction

After following the 'Indexing the Databases' instructions and defining the User databases (that were tested before creating successful .cfg) and saving the definitions as Mapping file,
the following errors occur when running the 'Run Index' function:

main] FATAL matcher.indexer.Run.main(Run.java:41): config file = C:\Program Files\CA\Identity Governance 140\Client Tools\Software\UUID\UUIDConfig.xml
[Thread-0] INFO config.xml.XmlFile.validateXML(XmlFile.java:68): Configuration file C:\Program Files\CA\Identity Governance 140\Client Tools\Software\UUID\UUIDConfig.xml looks valid ...
[Thread-0] INFO matcher.indexer.IndexCommand.execute(IndexCommand.java:60): Indexing to directory '.\Index\ca-tool-user3.udb'...
[Thread-0] INFO config.xml.XmlFile.validateXML(XmlFile.java:68): Configuration file PreferencesUUID.xml looks valid ...
[Thread-0] FATAL matcher.indexer.IndexSingleUdb.index(IndexSingleUdb.java:78): Error when reading file .\.\UDB CFG Files\ca-tool-user3.udb:
[Thread-0] FATAL matcher.indexer.IndexSingleUdb.index(IndexSingleUdb.java:79): Line 1 does not contain column# 6

 

Environment

Identity Governance 14.x

Cause

These errors usually occur when the UDB file is not encoded as UTF-8.

Resolution

Change the encoding of the .udb file to UTF-8.

1. Edit the udb file in Notepad++ (or a similar utility).
2. For example edit the 'ca-tool-user3.udb' file with Notepad++
3. Then go to 'View > Show Symbol > Show all Characters'
4. Then go to 'Encoding > Encode to UTF-8'
5. and save the file.
6. Then RUN INDEX .. .