Any clue what would cause this?



PRMILLNBR is getting passed twice as you can see, so there are 10 values when 9 are needed.



This results in error:

SQL0313N: The number of host variables in the EXECUTE or OPEN statement is not equal to the number of values required.



************************** DEBUG INFO ***********************

Command #:    1

Timestamp:    2008-01-10 18:12:12.559

General Command Settings

Command Type:    Text

Object Type:    DDTek.DB2.DB2Command

Connection String:    Database=S1094B1B;User ID=QSECOFR;Server=192.168.42.100:446

Transaction:    False

Command Settings

CommandText:    INSERT INTO "SIGMA"."INSTYPRPF" ("PRMILLNBR", "PRSTYLNBR", "PRUNITMEAS", "PRSIZECODE", "PRCUTCOST", "PRROLLCOST", "PRCUTRETL", "PRROLLRETL", "PRROWVERSION") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

Command Parameters

P0:    '1' [DbType: Decimal | Size: 0 | Direction: Input | SourceColumn: PRMILLNBR | SourceVersion: Current]

P1:    '2' [DbType: Decimal | Size: 0 | Direction: Input | SourceColumn: PRSTYLNBR | SourceVersion: Current]

P2:    '' [DbType: StringFixedLength | Size: 3 | Direction: Input | SourceColumn: PRUNITMEAS | SourceVersion: Current]

P3:    '' [DbType: StringFixedLength | Size: 3 | Direction: Input | SourceColumn: PRSIZECODE | SourceVersion: Current]

P4:    '1' [DbType: Decimal | Size: 0 | Direction: Input | SourceColumn: PRCUTCOST | SourceVersion: Current]

P5:    '0' [DbType: Decimal | Size: 0 | Direction: Input | SourceColumn: PRROLLCOST | SourceVersion: Current]

P6:    '2' [DbType: Decimal | Size: 0 | Direction: Input | SourceColumn: PRCUTRETL | SourceVersion: Current]

P7:    '0' [DbType: Decimal | Size: 0 | Direction: Input | SourceColumn: PRROLLRETL | SourceVersion: Current]

P8:    '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: PRROWVERSION | SourceVersion: Current]

P9:    '1' [DbType: Decimal | Size: 0 | Direction: Input | SourceColumn: PRMILLNBR | SourceVersion: Current]

Keith Chisarik

More info:



It does not do it when I change the primary key to a new field that auto increments.



The key on the table (set via BO Mapper) when it has the above errors was a concatenated key:



PRIMARY KEY( PRMILLNBR, PRSTYLNBR)

Keith Chisarik

I'm looking through the code, and it doesn't look like those primary key fields should be included in the Fields collection of the QueryInfo object, so I'm not sure why that one is showing up twice.  Could you email me the .designer.vb file for that business object?  I'll take a look at it and see if there is something strange there causing the problem.  Thanks.