""Database Driver Error. (30,11)" When Running a Query on Record With Translate Values Defined

The cause of getting into this erro was determined as being related to all queries that do contain a field having translate value defined in the record but does not have actual translate values.

In order to correct this behavior please follow the steps below:

1. Open Application Designer
2. Open the affected record
3. Modify the record definition and select no edit for the xlat field

OR

1. Open Application Designer
2. Open the PS Query Tool
3. Open the affected query
4. Modify the query and set the xlat option to None

In addition, the following Query SQL could be run to see if there are existing record with similar issues.

Here is the SQL to find out XLATT-3 for Oracle database:

select
A.RECNAME,
A.FIELDNAME
FROM PSRECFIELD A
WHERE (TRUNC(A.USEEDIT/512, 0) - (TRUNC(A.USEEDIT/1024, 0)*2)) <> 0
AND NOT EXISTS
   (SELECT 'X'
      FROM PSXLATDEFN B
     WHERE A.FIELDNAME = B.FIELDNAME)
ORDER BY A.RECNAME,  A.FIELDNAME