Return
-
Title
Error committing SQL statement in SSB Oracle source (is not accepted by the pattern '.*\S.*'.) -
Description
While committing an Oracle source SQL statement in SSB, it throws the following error:
Error validating configuration
xsd_file: /opt/ssb/share/xml/ssb.xsd
db_file: /opt/ssb/var/db/ssb.xml
error: [Error 1839]: Element 'fetch_query': [facet 'pattern'] The value ' <<SQL Query>>' is not accepted by the pattern '.*\S.*'.
-
Cause
Newline has been used (user "enter" key in the keyboard) in the SQL statement.
Sample:
SELECT SESSIONID AS "uid",
EVENT_TIMESTAMP AS "DATETIME",
AUTHENTICATION_TYPE AS "message",
USERHOST AS "HOST"
FROM TABLE; -
Resolution
SQL statement in the SSB has to be in the same line otherwise it will provide the above mentioned error while committing.
A sample working SQL statement:
SELECT SESSIONID AS "uid",EVENT_TIMESTAMP AS "DATETIME",AUTHENTICATION_TYPE AS "message",USERHOST AS "HOST" FROM TABLE;
Here, the full statement is in one line and it should commit without any issue.