Teradata Database Message 2809 - 2809 - Analytics Database - Teradata Vantage
Analytics Database Messages
- Deployment
- VantageCloud
- VantageCore
- Edition
- Enterprise
- IntelliFlex
- VMware
- Product
- Analytics Database
- Teradata Vantage
- Release Number
- 15.xx,16.xx,17.xx
- Published
- June 2022
- ft:locale
- en-US
- ft:lastEdition
- 2023-01-05
- dita:mapPath
- sfx1628096178347.ditamap
- dita:ditavalPath
- ft:empty
- dita:id
- B035-1096
- lifecycle
- latest
- Product Category
- Teradata Vantage™
- Message
- Invalid recovery sequence detected
- Explanation
- An illegal sequence of recovery actions has been detected. This could be a cluster Restore of a fallback table that was not preceded by a dictionary restore or a specific-AMP restore operation during a Fast Load or MLoad.
- Generated By
- AMP Software.
- For Whom
- End User.
- Notes
- All cluster restores of fallback tables must be preceded by a dictionary restore. This situation may arise in doing a specific-AMP restore of a no fallback table after CREATE/ DROP INDEX, a Fast Load, or an MLoad.
- Remedy
- To restore a fallback table to AMP clusters, you must first perform a dictionary restore of the table from a dictionary dump. If the problem is CREATE/DROP INDEX, perform an all-AMPs restore followed by a specific-AMPs restore of the no fallback table. Then do the CREATE/DROP INDEX. If the problem is Fast Load or MLoad, the operation must finish prior to issuing the recovery operation, or all-AMPs must be restored first.