Symptom
While importing content an error appears saying the transaction is rolled back
- Please report the following error to your system administrator:
- Transaction rolled back because it has been marked as rollback-only
Environment
SAP SuccessFactors Learning Management System (LMS)
Reproducing the Issue
- Go to Content > Tools > Import Content
- Select any method, like Add New Content
- Pick a SCORM package to upload, fill out the import details on the next page, and then select Import Files
- The next screen shows validation successful, but allows you to edit the Content Object IDs
- Edit the Content Object IDs and add special characters (examples ~@#$%^&*?)
- Run the import job and the issue will occur
Cause
- The special characters are causing the import job to fail
- This error may also appear if the content package is too large:
- The Max File Size for Content is controlled by the "maximumFileSizeKB" setting in CONTENT_IMPORT configuration file
- Navigation steps - Please navigate to Admin > System Admin > Configuration > System Configuration > CONTENT_IMPORT
- Please see CONTENT IMPORT System Properties File User Assistance Documenation for more detail
Resolution
When you edit the Content Object IDs do not add special characters
Keywords
SF SuccessFactors Learning LMS, SCORM, import content, iContent, Transaction rolled back rollback-only org.springframework.transaction.UnexpectedRollbackException , KBA , LOD-SF-LMS-CNT , Content , LOD-SF-LMS , Learning Management System , Problem
Product
SAP SuccessFactors Learning all versions