• State Not Answered
  • Locked Locked
  • Replies 12 replies
  • Subscribers 94 subscribers
  • Views 7546 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.

  • 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 

  • 0 over 5 years ago in reply to Roman.Demchenko

    but updates are working fine without any issue.The problem is with insert .

  • 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.

  • 0 over 5 years ago in reply to Markus Weiss-Ehlers

    Markus,

    How to check whether anyone changed the insert trigger on Person table.

  • 0 over 5 years ago in reply to suneethk

    How about checking the SQL server first?

    You do check the triggers on the person table like you would do with any SQL database. Nothing that is OneIM related.

  • 0 over 5 years ago in reply to Markus Weiss-Ehlers

    we checked the server ,there is enough space available and no issue with server.

  • 0 over 5 years ago

    Hi,

    Did you find the cause/solution for this?

    Just today our DEV environment has started throwing this error when doing check and submit of the shopping cart:

    An exception has occurred while executing the form method F0_ctl00_ControlRef8_ControlRef15_ControlRef15_ControlRef8b_Main_Main_Tab1_ctl00_T0_ctl00_Button4_Method.

    One or more errors occurred.

    One or more errors occurred.

    Error rerunning transaction.

    Trying to execute SQL command in canceled transaction: insert into DialogProcess (GenProcID, BasisObjectType, ObjectKey, ProcessState, DisplayName, XDateInserted, XDateUpdated, XUserInserted, XUserUpdated)

    select '2c0ce3eb-1ba7-4fc9-acca-b4aa8ea477b5', 'PersonWantsOrg', '<Key><T>PersonWantsOrg</T><P>7dba4c48-e3b5-4eb2-8405-518d2c3aafb7</P></Key>', 'G', N'Insert - Thanasis 3 - -', GetUTCDate(), GetUTCDate(), N'VeltenaarE', N'VeltenaarE'

    where not exists (select 1 from dialogprocess where GenProcID = '2c0ce3eb-1ba7-4fc9-acca-b4aa8ea477b5')

    (2018-07-03 10:46:34)d

    We have checked the database server and it has plenty of space ..... we have restarted the IIS server and the database server but the error still appears.

    Thanks, Barry.

  • 0 over 5 years ago in reply to Barry Jackson

    Which version Barry? Are you using an Application Server connection for the web portal?

  • 0 over 5 years ago in reply to Markus Weiss-Ehlers

    1IM - 101!!! ...... Version is 712 ....... pretty sure we use a windows authentication direct connection the the DB.  I see DataProtectionConfigurationProvider in web.config

  • 0 over 5 years ago in reply to Barry Jackson

    DataProtectionConfigurationProvider just means that the section is encrypted.

    I found some special cases around the Application Server and closed transactions but if you have a direct SQL connection I suggest contacting support.

    You could also check the database server logs. Maybe a transaction log or the TEMPDB is at its limits.