Skip to main content
johng0005
Inspiring
Aug 19, 2021 1:16 PM UTC
Solved

Error Importing Site Object

Hi guys, I'm trying to import a site object and I'm getting the following error in the import-log:

Problems (1):
site 5139d5ff-e29d-4874-912c-6d56ffd81d7b 3 "siteName": An error occurred while updating site [id=3 uuid=5139d5ff-e29d-4874-912c-6d56ffd81d7b]: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update (APNX-1-4071-008)

In the system logs I can see this: 

2021-08-19 13:14:28,076 [ajp-nio-0.0.0.0-8009-exec-9] ERROR org.hibernate.util.JDBCExceptionReporter - (conn=6611215) Duplicate entry 'siteName' for key 'site_urlstub_uc'


Any ideas how to resolve this? We were able to deploy the object to all our other environments without any issues.

Thanks.

    danny.verb
    danny.verbAnswer
    Employee
    Aug 19, 2021 1:26 PM UTC

    Appian Sites contain a URL identifier that must be unique. Based on the error, it seems like your environment already has a site object with the same URL identifier.

    View in thread

    3 replies

    danny.verb
    danny.verbAnswer
    Employee
    Aug 19, 2021 1:26 PM UTC

    Appian Sites contain a URL identifier that must be unique. Based on the error, it seems like your environment already has a site object with the same URL identifier.

      johng0005Author
      Inspiring
      Aug 19, 2021 1:28 PM UTC

      Hey Danny,

      The object already exists in the application, we're trying to import it to update it. Shouldn't it update the existing object, the same as importing any other object would work?

      Terms & ConditionsAccessibility statement