• State Not Answered
  • Locked Locked
  • Replies 12 replies
  • Subscribers 94 subscribers
  • Views 7526 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

error while inserting user data into person table via script

suneethk
over 5 years ago

We have script for inserting User data into Person table .Recently there is no insertion is happening due to below error ,

Insert User with ID 00005783
2018-06-25 14:51:28 +02:00 - Serious - Error in line 3051: [810023] Error during execution of statement: insert into Person (AS_CSVObjectID, AS_EMP_UNIQUE_HCM_ID, AS_PAYROLL_ID, AS_PER_ORG, CCC_CorpTitle, CentralAccount, CentralSAPAccount, City, DefaultEmailAddress, Description, EntryDate, FirstName, Initials, InternalName, LastName, PersonalTitle, PersonnelNumber, PreferredName, Street, UID_Department, UID_Locality, UID_Person, UID_PersonHead, UID_ProfitCenter, ZIPCode, xdateinserted, xuserinserted, xdateupdated, xuserupdated, xobjectkey)  values ('xxxxxxx',...............)
[810095] Trying to execute SQL command in canceled transaction: 

is there way to solve this error .Please suggest.

Parents Reply
  • 0 over 5 years ago in reply to suneethk

    As Roman said

    Roman.Demchenko said:
    Also, do you notice any errors on the Database Server itself? 
    Roman.Demchenko said:
    Since you mentioned this recently started happening, has anything changed? Disk usage on SQL server?

    Insert need additional storage for the database data file, updates just need space for the database log file. If they are separated this could explain the error.

    Another option would be, that someone has created or modified an Insert trigger on the table Person that leads to that error.

Children