Error in importing Data

(0) Share

Report

Posted on by rsingh62

I have written a code in x++ to insert and update data in 3 tables (tstimesheettable, tstimesheetline, tstimesheetlineweek). That is working fine on development server. But getting error on UAT server.

I am attaching screenshot for your reference.

I have the same question (0)

All responses (4)

Answers (0)

Martin Dráb 237,038 Most Valuable Professional on at

Like (0)

Report

Error in importing Data

The error says that you're trying to insert a record to TSTimesheetLine table that violates uniqueness of a unique index, i.e. that there already is a record with the same values of a unique index.

There is only one unique index in the standard application, which consists of these fields: Resource, TimesheetNbr, LineNum and ProjPeriodTimesheetWeek.

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (0)

Report

Error in importing Data

Hi rsingh,

In addition to the Martin comments, you may be missing to insert value to LineNumber field.

In dev server maybe you tested for single record only.

Thanks,

Girish S.

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

Error in importing Data

I would suggest you to debug the uat server. Otherwise you have to use same database in dev vm and have to find the root cause.

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Error in importing Data

Hi, In addition, either your file has duplicate records (as per unique index of table) or the table already has record/s that you are trying to insert.

Was this reply helpful? Yes No