Hi all,
I got a problem in my Connector, the Connector setting, data and log messge listed below :
Excel Data :
| PR Number |
Item No |
Catalog Item name |
Display Name |
Description |
Qty |
UnitCost |
TaxAmount |
Owner |
TotalCost |
CurrencyGuid |
ExchangeRate |
| Batch-PC-002 |
99999999-9999-9999-9999-000000000083 |
Lenovo_ThinkCentre_M72e |
Lenovo_ThinkCentre_M72e |
|
13 |
0 |
|
|
|
|
|
Log :
| |
|
|
Display name column |
Lookup key: Resource Name |
Data class: Line Items |
|
| NS Column: |
|
|
Name |
Catalog Item |
Description |
Line Item ID |
Display Name |
CurrencyGuid |
Unit Cost |
Tax Amount |
ExchangeRate |
Quantity |
Owner |
|
| Foreign column: |
Row # |
Resource Create/Update |
PR Number |
PR Number |
Catalog Item name |
<Null> |
Item No |
Display Name |
<Null> |
Unit Cost |
<Null> |
<Null> |
Qty |
Owner |
Log message |
| |
|
Update |
Batch-PC-002 |
Batch-PC-002 |
Lenovo_ThinkCentre_M72e |
- |
99999999-9999-9999-9999-000000000083 |
Lenovo_ThinkCentre_M72e |
- |
0 |
- |
- |
13 |
CPF/ITS/DC |
Row 1 skipped for data class 'Line Items'. Data class foreign key lookup on column 'Owner' failed. |
| |
|
Row 1 skipped for data class 'Line Items'. An unexpected exception occurred while processing data class data. Error: The parameterized query '(@__RowNumber__ bigint,@__ResourceGuid__ uniqueidentifier,@Param' expects the parameter '@Param7', which was not supplied.. |
I created the catalog item and owner in before, but the connector could import data in to PR. And this rule is work in before with similar data.
would you gude me to slove this error?