Post reply

Insert Error Please Help

  • February 4, 2002 at 2:52 am

    #78513

    [Microsoft][ODBC SQL Server Driver]insert Error:

    Column name or number of supplied values does not match table definition

    I encountered the above message in my financial application after configuring the replication, my application is working before replication.

    thanks

    Peter

    20394


    20394

  • February 4, 2002 at 3:11 am

    #423038

    Peter I want some more info to clarify your doubt. What version of SQL you are using? What kind of replication you are using?

    Ram

  • February 4, 2002 at 3:16 am

    #423039

    Hi RAM

    I am using SQL 2000 standard edition, i already applied the service pack 2

    thanks

    20394


    20394

  • February 4, 2002 at 3:22 am

    #423040

    What type of replication are you using?

  • February 4, 2002 at 4:53 am

    #423044

    Did you modify the table, either on the publisher or subscriber? There will be an insert proc on the subscriber for each table that is being replicated, you can compare that with both the source and destination tables to see if the description matches. The fastest resolution is to just reinit your publication and have it send over a new snapshot.

    Andy

    Andy
    Connect with me on LinkedIn

  • February 4, 2002 at 10:36 pm

    #423144

    I am using Merge replication, I only created the snapshot and theres no subcriber yet and i did not modify the table.

    thanks

    Peter

    20394


    20394

  • February 4, 2002 at 10:57 pm

    #423147

    Are u started the snapshot or not? If you started the snapshot that will create the tables in subscriber database and replicate the data also. So, check whether u started the snapshot or not.

  • February 5, 2002 at 1:54 am

    #423156

    i already created and started the snapshot.

    20394


    20394

  • February 5, 2002 at 5:29 am

    #423167

    Are you dynamically constructing the insert? Merge will have added a rowguid col to the table, this is probably causing the error.

    Andy

    Andy
    Connect with me on LinkedIn

  • February 6, 2002 at 2:09 am

    #423276

    Hi Andy

    you're right, rowguid was added to the table, but why the other tables are replicating with no problem

    20394


    20394

  • February 6, 2002 at 6:35 am

    #423288

    Maybe they already had a uniqueidentifier? Or you were handling inserts differently?

    Andy

    Andy
    Connect with me on LinkedIn

Viewing 11 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply