• State Not Answered
  • Locked Locked
  • Replies 12 replies
  • Subscribers 94 subscribers
  • Views 7528 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
  • 0 over 5 years ago

    Hello,

    You might need to add some debug output in the script to see where it fails. Since you mentioned this recently started happening, has anything changed? Disk usage on SQL server?

    Also, do you notice any errors on the Database Server itself? 

    -Roman 

Reply
  • 0 over 5 years ago

    Hello,

    You might need to add some debug output in the script to see where it fails. Since you mentioned this recently started happening, has anything changed? Disk usage on SQL server?

    Also, do you notice any errors on the Database Server itself? 

    -Roman 

Children