Highlighted
Trusted Contributor.
Trusted Contributor.
291 views

API error while configuring CIT scenario

Hi

Getting below API error while processing the CDW data file in CIT and AM kindly suggest what is the issue here ?

[(amEmplDeptDst) amEmplDept] (16384) 'AssetCenter/Asset Manager' API error: 'ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'dbo.amEmplDept' with unique index 'EmplDept_FullName'. The duplicate key value is (/, , /). SQLSTate: 23000\nODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. SQLSTate: 01000\nIndex error: A record in table 'Employees and departments (amEmplDept)' with the value '/, , /' for field 'Full name (FullName)' already exists in the database.'
2019/09/26 06:16:11.178 0 1 [(amEmplDeptDst) amEmplDept] (16384) 1Pass;Pass2Order-OrderElement rejected due to rejection of a sub-element or an unrecoverable error.

 

Execution summary

Scenario:

E:\ProgramFiles(x86)\MicroFocus\Connect-It9.80en\scenario\CDW Data Import-v01.scn

Start of scenario:

9/25/2019 11:40:18 AM

End of scenario:

9/25/2019 11:40:20 AM

Status:

Documents were processed with errors



Scenario document statistics

Documents produced:

 

 

 

Document status

N

Percentage

 

Document(s) produced successfully

2

100 %

 

Documents consumed:

 

 

 

 

Document status

N

Percentage

 

Document(s) consumed with errors

1

50 %

 

 

 

Document(s) consumed successfully

1

50 %

 

 



Time statistics for scenario

Length of session:01.766s

Details:

Connector

Time

Percentage

Time in scripts

Connect-It monitor

00.000s

0 %

 

N/A

 

 

Asset Manager

01.546s

87 %

 

 

N/A

 

 

Mapping

00.000s

0 %

 

N/A

 

 

Database

00.172s

9 %

 

 

N/A

 

 



List of statistics sorted by element

Statistic

Details

Value

Connect-It monitor

 

 

 

Total time

 

00.000s

 

Asset Manager

 

 

 

Total time

 

01.546s

 

Time required for selections

 

171

 

Time required for selections

amAsset

78

 

Time required for selections

amBrand

16

 

Time required for selections

amCostCenter

62

 

Time required for selections

amPortfolio

15

 

Time required for insertions

 

1297

 

Time required for insertions

amBrand

1297

 

Document(s) consumed with errors

 

1

 

Document(s) consumed with errors

amPortfolioDst

1

 

Connection test(s)

 

1

 

Record(s) read

 

1

 

Record(s) read

amCostCenter

1

 

Mapping

 

 

 

Total time

 

00.000s

 

Time in scripts

 

00.000s

 

Document(s) consumed successfully

 

1

 

Document(s) consumed successfully

CDW_Asset.csvSrc

1

 

Document(s) produced successfully

 

1

 

Document(s) produced successfully

amPortfolioDst

1

 

Basic script(s) evaluated

 

4

 

Basic script(s) evaluated

amPortfolioDst

4

 

Database

 

 

 

Total time

 

00.172s

 

Document(s) produced successfully

 

1

 

Document(s) produced successfully

CDW_Asset.csvSrc

1

 

Record(s) read

 

1

 

Record(s) read

CDW_Asset.csv

1

 



List of statistics sorted by type of value

Element

Details

Value

Total time

 

 

 

Connect-It monitor

 

00.000s

 

Asset Manager

 

01.546s

 

Mapping

 

00.000s

 

Database

 

00.172s

 

Time in scripts

 

 

 

Mapping

 

00.000s

 

Time required for selections

 

 

 

Asset Manager

 

171

 

Asset Manager

amAsset

78

 

Asset Manager

amBrand

16

 

Asset Manager

amCostCenter

62

 

Asset Manager

amPortfolio

15

 

Time required for insertions

 

 

 

Asset Manager

 

1297

 

Asset Manager

amBrand

1297

 

Document(s) consumed successfully

 

 

 

Mapping

 

1

 

Mapping

CDW_Asset.csvSrc

1

 

Document(s) consumed with errors

 

 

 

Asset Manager

 

1

 

Asset Manager

amPortfolioDst

1

 

Document(s) produced successfully

 

 

 

Mapping

 

1

 

Mapping

amPortfolioDst

1

 

Database

 

1

 

Database

CDW_Asset.csvSrc

1

 

Basic script(s) evaluated

 

 

 

Mapping

 

4

 

Mapping

amPortfolioDst

4

 

Connection test(s)

 

 

 

Asset Manager

 

1

 

Record(s) read

 

 

 

Asset Manager

 

1

 

Asset Manager

amCostCenter

1

 

Database

 

1

 

Database

CDW_Asset.csv

1

 

 

0 Likes
2 Replies
Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..

Hi Chetu_7845,

Without your scenario (CDW Data Import-v01.scn) it's difficult to give you the proper answer.

It seems you are using a wrong reconciliation key in your mapping box.

BR,

Eric

 

0 Likes
Highlighted
Acclaimed Contributor.. Acclaimed Contributor..
Acclaimed Contributor..

The process is trying to insert a record which has the same 'Full name (FullName)' value as another record.  Since the error states the value as "'/, , /'", this means you have a blank source record which will need to be ignored.  It looks like your source is a CSV file so somewhere in this file you have either a blank row or enough special characters "hidden carriage returns" which the process interprets as a blank row.  If the latter, then copy/paste CSV contents into a spreadsheet application (ie. Microsoft Excel) to help identify the location of these special characters. 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.