Siebel Marketing Installation and Administration Guide > Designing Marketing List Formats >
Acceptable Characters in Marketing Configuration Entries
When entering values in fields in the Marketing Administration screens, make sure to avoid using apostrophes ('). These result in multiple failures of the Marketing Server component during attribute synchronization, campaign generation, and other tasks. This failure is due to SQL relying on apostrophes as a delimiter. The presence of apostrophes in the data columns, such as attribute names, table names, field names, and hierarchy names causes an SQL error.