[LIMITED AVAILABILITY]{class="badge informative" title="Restricted to Campaign Standard migrated users"}

64-bit schemas 64-bit-tables

In order to facilite the transition from Campaign Standard to Campaign v8, several tables have been changed from 32 to 64 bits. Indeed, Campaign Standard supports 64-bit PK in several out-of-the-box schemas, whereas Campaign v8 supports 32-bit PK in most schemas.

Limitations

  • This technical change only applies to customers migrating from Campaign Standard.
  • Schema and broadlog extention is not supported in 64 bits. It will remain in 32 bits.
  • Logs related to deliveries sent to technical users will not be available in Campaign v8.
  • Only PostgreSQL is supported.

Modified schemas

Here is the list of schemas changed to 64 bits and their modified attributes.

Schema name
Atribute name
nms:broadLogRcp
id
nms:trackingLogRcp
id
nms:excludeLogRcp
id
nms:broadLogVisitor
id
nms:trackingLogVisitor
id
nms:propositionRcp
interactionId
nms:propositionVisitor
interactionId
nms:webTrackingLog
id
nms:tmpBroadcast
message-id
nms:tmpMarketingPressure
message-id
nms:tmpBroadcastExclusion
message-id
nms:tmpBroadcastPaper
message-id
nms:broadLogAppSubRcp
id
nms:trackingLogAppSubRcp
id
nms:excludeLogAppSubRcp
id
nms:webEvent
broadLogSrc-id, broadLogRemkt-id
nms:broadLogMid
mktBroadLogId
nms:mirrorPageSearch
remoteMessageId
recommendation-more-help
7167b251-0f24-48cd-a4e0-234fe2acbdea