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.

All responses (4)

Answers (0)

Mohit Rampal 12,554 Super User 2024 Season 1 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.
Bharani Preetham Pe... 3,587 Super User 2024 Season 1 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.
GirishS 27,821 Super User 2024 Season 1 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.
Martin Dráb 230,868 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.