Running DB Stores, Policy Server often report the following error messages in the smps.log :
[2663/32][Thu May 19 2011 09:34:28][CA.XPS:ODBC0012][ERROR] An error occurred when calling "SQLExecute" for "Housekeeping Policy Data Read" query
[2663/32][Thu May 19 2011 09:34:28][CA.XPS:ODBC0002][ERROR] 37:0 [DataDirect][ODBC 20101 driver] 1866073
Why Policy Server is reporting this error?
The error messages are due to a standard ODBC error :
"[DataDirect][ODBC 20101 driver]1866073"
The number 1866073 should be a reference to a localized message. Typically, localized messages are stored in Unix using the file path
"locale/localized_territory_directory/LC_MESSAGES" according to DataDirect documentation (for example, in german this path would look like "local/de/LC_MESSAGES").
Because you get a number (1866073) instead of a text message for the error, localization has not been properly configured and thus, the drivers cannot look up the appropriate message.
From the DataDirect documentation :
"If localized error messages are not available for your locale, then they will contain message numbers instead of text."
Set the localization on the Database side for English in order to get the text error message.