ERROR: SQLException SQL State:42X01 Error Code: 20000 OM Web Viewer 12.1
search cancel

ERROR: SQLException SQL State:42X01 Error Code: 20000 OM Web Viewer 12.1

book

Article ID: 4727

calendar_today

Updated On:

Products

Output Management Web Viewer

Issue/Introduction

The following error messages are in the wvtrace logs.  Product usage does not appear to be affected.

----- SQLException ----- 
SQL State: 42X01 
Error Code: 20000 
Message: 

and this: 
----- SQLException ----- 
SQL State: 42X01 
Error Code: 20000 
Message: Syntax error: Encountered "-" at line 1, column 31. 
Trace: 2016/01/08 12:57:14.986 02 t=9C00D0 c=UNK key=P8 tag= 

Environment

  • Output Management Web Viewer 12.1
  • Microsoft SQL Server

Cause

OM Web Viewer attempts to create a table name that includes an illegal character.

Resolution

Apply RO91467 CUMULATIVE BUILD 158 FOR V12.1 or higher.   It is recommended to apply the latest build for all security fixes and enhancements. It does not matter what platform you choose, the fixes are all the same.