Extending Exception Queue
1. Login to the OneData metadata schema.
2. Check the number of columns in the OD_MD_QUEUE_RCD table. The default number of columns are from COLUMN_1 to COLUMN_50. Extend the table OD_MD_QUEUE_RCD to have columns up to COLUMN_200. The following example displays the command to extend columns from 51 to 60 for Oracle and MSSQL.
Oracle:
ALTER TABLE OD_MD_QUEUE_RCD ADD (
COLUMN_51 VARCHAR2(2000 BYTE),
COLUMN_52 VARCHAR2(2000 BYTE),
COLUMN_53 VARCHAR2(2000 BYTE),
COLUMN_54 VARCHAR2(2000 BYTE),
COLUMN_55 VARCHAR2(2000 BYTE),
COLUMN_56 VARCHAR2(2000 BYTE),
COLUMN_57 VARCHAR2(2000 BYTE),
COLUMN_58 VARCHAR2(2000 BYTE),
COLUMN_59 VARCHAR2(2000 BYTE),
COLUMN_60 VARCHAR2(2000 BYTE)
);
MSSQL:
ALTER TABLE OD_MD_QUEUE_RCD ADD
COLUMN_51 [nvarchar](2000) NULL,
COLUMN_52 [nvarchar](2000) NULL,
COLUMN_53 [nvarchar](2000) NULL,
COLUMN_54 [nvarchar](2000) NULL,
COLUMN_55 [nvarchar](2000) NULL,
COLUMN_56 [nvarchar](2000) NULL,
COLUMN_57 [nvarchar](2000) NULL,
COLUMN_58 [nvarchar](2000) NULL,
COLUMN_59 [nvarchar](2000) NULL,
COLUMN_60 [nvarchar](2000) NULL
;
Note:
Skip this step if the table already has columns up to COLUMN_200.
3. Stop the OneData server.
4. Navigate to <Software AG_directory>\profiles\ODE\configuration.
The directory contains the file onedata.properties. The default values for onedata.exceptionqueue.fetchsize and onedata.exceptionqueue.numberofcolumns are as given below:
onedata.exceptionqueue.fetchsize=200
onedata.exceptionqueue.numberofcolumns=50
5. Overwrite the properties of onedata.exceptionqueue.fetchsize and onedata.exceptionqueue.numberofcolumns in the onedata.properties file as given below:
onedata.exceptionqueue.fetchsize=50
onedata.exceptionqueue.numberofcolumns=200
Save the file.
6. Start the OneData server.