On 5/13/2012 1:06 AM, eden silva wrote:
> Hi,
> I want make a test with IDM 4.0.1, MSSQLSERVER2005 and Driiver JDBC.
> The Publisher channel is disabled, I need make a Subcription but the
> table in mssqlserver 2005 not contain "primary key", then I see the
> following message:

There needs to be a column named pk_something. The pk_ part tells the
driver this is the primary key column. If you cannot modify the table,
you make aview which renames the column to pk_columnName and make sure
the values are all unique in it.

> DirXML Log Event -------------------
> Driver: \SSP-TREE\system\driverset1\SSP-IPH
> Channel: Subscriber
> Status: Fatal
> Message: Code(-9005) The driver returned a "fatal" status
> indicating that the driver should be shut down.
> Detail from driver:<description>Table 'dbo.NOPASA' is not
> syncable. It must have a primary key constraint.</description>
> How resolve this problem?
> Thanks.