Hi,
I'm getting a problem when business objects (5) tries to write to the BO Repository which is on SQLServer 7 (The database has recently been set up for replication). The error is:
Insert Error: Column name or number of supplied values does not match table definition.
Business Objects does not create tables in it's repository with Primary Keys so I have had to use Merge Replication (It seems to be able to make a change to the format of the tables in order to allow them to be replicated).
There is a bug on the MS site (Q250623) which seems related to the problem we are getting, though the workaround only works with Transactional replication, not merge (It suggests setting the write individual columns setting against each table in the database but says this can only work with Transactional Replication)
Does anyone have any idea what this problem might be and how I might get around it?
Thanks,
Mark
I'm getting a problem when business objects (5) tries to write to the BO Repository which is on SQLServer 7 (The database has recently been set up for replication). The error is:
Insert Error: Column name or number of supplied values does not match table definition.
Business Objects does not create tables in it's repository with Primary Keys so I have had to use Merge Replication (It seems to be able to make a change to the format of the tables in order to allow them to be replicated).
There is a bug on the MS site (Q250623) which seems related to the problem we are getting, though the workaround only works with Transactional replication, not merge (It suggests setting the write individual columns setting against each table in the database but says this can only work with Transactional Replication)
Does anyone have any idea what this problem might be and how I might get around it?
Thanks,
Mark