The Data Update job is failing when it fills up the transaction log for the SnowLicenseManager database
SLM 9.x
This customer was using High Availability, and the recovery mode is set to Full recovery.
Since the Data Update Job involves a significant amount of data being transferred into the SnowLicenseManager database, this can quickly fill up the transaction log.
Recommended: Increase the Transaction Log size for the SnowLicenseManager database
OR
In this case the customer's database administrator took a decision to remove the SnowLicenseManager database from High Availability Group and switched the recovery mode to Simple. Changes of this type should be made with caution because they may affect recovery should there be a hardware or other database failure. Please also see this article for supported configurations of High Availability and other SQL configuration settings.
Related Articles
Send data update job (DUJ) logs to technical support 511Number of Views Data Update Job fails logging error #16943 78Number of Views ARL Import process can require significant compliance database transaction log space, potentially failing with error: "The… 6Number of Views System.Data.SqlClient.SqlException (0x80131904): The transaction log for database 'FNMSCompliance' is full due to 'LOG_BAC… 78Number of Views Snow Data Update Job fails with the error "Could not complete cursor operation because the table schema changed after the … 70Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago