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.

File sent as requested, thank you.

Keith Chisarik

Is the PR_PK field an auto-assigned value within DB2?

For some reason, that field was completely left out of the INSERT...

Let me see if I can't dump this designer file into a project and test it.

No clue, Keith, because I can't get it to fail... it might be that my source has changed since you got the version when you purchased the provider... I'll email you the latest version and we'll see if that makes a difference.