Post stopped due to "ORA-904" because there are special characters in the column name (59842)

Post stopped due to ORA-904 Invalid identifier due to special characters in column names.
There are different between table description from the table in the output of object cache. Activating configuration again still has the same result which the column names in the object cache and table are different.

Two Reasons :

1. source table has corrupted column name.

2. shareplex was started without NLS_LANG setting.

In both case NLS_LANG not being set is the root cause.

Resolution:

Make sure NLS_LANG envirnoment variable set correctly and activate configuration again.

I. modify shareplex user profile to include NLS_LANG variable.
II. reactivate config by taking the object out of repilcation and putting it back in.

Refer to SOL4678 for more details.

Workaround:

Disable this object for posting .

Refer to SOL16835 for details.

For example, in an enviroment which is NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1.

When NLS_LANGis not set before sqlplus is started, this occurs.

SQL> create table test(a int primary key,cos�¸ varchar2(10));

Table created.

SQL> desc test
Name Null? Type
----------------------------------------- -------- ----------------------------
A NOT NULL NUMBER(38)
cos?? VARCHAR2(10)

The ,cos�¸ column has been changed to cos??.

If NLS_LANG is set after the table has been created, this is the output of table desc:

SQL> desc test
Name Null? Type
----------------------------------------- -------- ----------------------------
A NOT NULL NUMBER(38)
cos¿¿ VARCHAR2(10)

Drop the table, set NLS_LANG, and recreate the table:

SQL> create table test(a int primary key,cos�¸ varchar2(10));

Table created.

SQL> desc test;
Name Null? Type
----------------------------------------- -------- ----------------------------
A NOT NULL NUMBER(38)
cos�¸ VARCHAR2(10)