Skip to main content
Kofax

Reporting issues resolved in KTA 7.5 Fix Packs

3014675

Question / Problem: 

What issues related to reporting have been resolved in KTA 7.5 Fix Packs?

Answer / Solution: 

The following reporting issues are included in the release notes of the listed fix pack (unless noted with *).  If encountering an issue with reporting, it is best to update to the latest fix pack so that all cumulative fixes are applied.

  • 7.5.0.27
    • 1545034 Case 26176670: Duplicate entry in Reporting tfs_class_dim table causes Reporting ETL failure “The MERGE statement attempted to UPDATE or DELETE the same row more than once    
    • 1542389 Case 26189941: Error during data extraction on message using reverted compressed flag: Invalid character in the given encoding
  • 7.5.0.26
    • 1530838 Case 26172354: [Reporting] extr_batch_sess_key reported after confirmation field  
    •  1524240 Case 26172354: Reclassification affects field reporting data
      • Scenario 1: If a document is reclassified after extraction, such as in Validation, reporting data for fields of the previous type will persist and be associated with a document type that does not have those fields. This causes KAFTA reports to show fields that do not belong to the given document type.
      • Scenario 2: If a document is reclassified from a type where a field has “Include in analytics” is yes to a type where the same field has “Include in analytics” is no, then the reporting data for the field will persist. In KAFTA this causes this field inappropriately show up on a type where it isn't intended to be reported on. It also has the appearance of sporadic behavior, because it will only happen when the document is reclassified from a type where the field is reported on.
  • 7.5.0.25
  • 7.5.0.23
    • 1461143 Case 26116779: Reporting: Error data transformation task TransformStatusKcDoc  
    • 1452925 Case 26084690: Reporting - Error PerformUpdates task - Execution Timeout Expired 
  • 7.5.0.21
    • 1396585 Case 26058595: Reporting stops processing messages in wsa_messages if the orphaned entries count is bigger than default number of processed records (1500)  
  • 7.5.0.19
    • 1373937 Case 25051197: The MERGE statement attempted to UPDATE or DELETE the same row more than once
    • 1369116 Case 25064261: Reporting data stuck in WSA_MESSAGES table with error "TryDeserializeWithPatchingXml spent more than 1000 cycles" 
      • Note: despite the name of the bug, no error is logged for this problem.  Instead the service hangs with no further processing or log output.
  • 7.5.0.17
    • 1327287 Case 25056955: [Reporting] Confirming table cells without modification shows as a changed field
  • 7.5.0.16
    • 1319589 Case 25041119, 25056138: Timeout Issues Related To Kofax Reporting Causing SQL Performance Problems
  • 7.5.0.14
    • *1306384: Performance degradation between KTA 7.5.0.11 and 7.5.0.12 with frequent spikes in response times
  • 7.5.0.13
    • 1299446 Case 25034013: Some reported field should contain the symbols which are not allowed in XML
    • 1295368 Case 25040416: Document type with apostrophe is causing the reporting system task to fail
    • 1294724 Case 25040509: Arithmetic overflow error converting IDENTITY to data type int
    • 1293316 Case 25028123: Reporting system task fails with error "Violation of UNIQUE KEY constraint 'user_logon_name_user_type_uq'. Cannot insert duplicate key in object 'dbo.user_dim'"
  • 7.5.0.12
    • 1286204 Case 25036079: Reporting - apostrophe to a folder name causing Unclosed quotation mark after the character string ' '
  • 7.5.0.8
    • 1238225 Case 25010893: Reporting Service fail with apostrophe in resource user name
  • 7.5.0.6
    • 1214937 Case 25001973: Reporting data not linking with pre-7.5 data
  • 7.5.0.5
    • 1209224 Case 24082899: Cannot insert duplicate key row in object 'dbo.field_accum_fact' with unique index 'idx_faf_pk_lkp'.
  • 7.5.0.4
    • *1195308: Reporting: 'Exception: Transaction (Process ID 67) was deadlocked on lock resources(...)' occurs in log
    • *1196183: Performance Issue: Excessive calls for selecting values for path_dim appears in Reporting
  • 7.5.0.3
    • 1191586 Case 24088423: Reporting: After upgrading to v7.5, Kofax TotalAgility reporting throws the error - "Error during Deserialize: There is an error in XML document."
  • 7.5.0.2
    • *1184705: 'Exception: A MERGE statement cannot UPDATE/DELETE the same row of the target table multiple times' occurs in Reporting logs
  • 7.5.0.1
    • 1149132 Case 24061127: SQL timeouts on Update batch_accum_fact from Kofax.CEBPM.Reporting.AzureETL.
    • *1169524: Document Review does not properly report time against each document in doc_sess_snapshot_fact.doc_sess_duration_ms
    • *1169525: Classification activity sometimes creates 2 system classification events