CA Web Viewer 12.1 SQL State: 42X01 Error Code: 20000 Syntax error: Encountered

book

Article ID: 4727

calendar_today

Updated On:

Products

CA 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= 

Cause

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

Environment

Release: CA Output Management Web Viewer 12.1
Component: WBVLUW

Resolution

Apply RO91467 CUMULATIVE BUILD 158 FOR V12.1 or higher.