Issue
When importing Tableau Online site to on-premises Tableau Server "insert or update on table "users" violates foreign key constraint"Messages similar to the following will be logged in the tabadmin.log
2018-04-09 10:08:02.168 -0700_FATAL_<IP_Address>:<HOST_NAME>_:_pid=5332_0x1b7a52dd__user=__request=__ org.springframework.orm.jpa.JpaSystemException: org.hibernate.TransactionException: commit failed; nested exception is javax.persistence.PersistenceException: org.hibernate.TransactionException: commit failed 2018-04-09 10:08:02.168 -0700_DEBUG_<IP_Address>:<HOST_NAME>_:_pid=5332_0x1b7a52dd__user=__request=__ NativeException: org.springframework.orm.jpa.JpaSystemException: org.hibernate.TransactionException: commit failed; nested exception is javax.persistence.PersistenceException: org.hibernate.TransactionException: commit failed
A message similar to the following will be logged in the tabsvc - tabadmin -java.log file
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "users" violates foreign key constraint "users_system_user_id_fkey" Detail: Key (system_user_id)=(-39840) is not present in table "system_users".