Table of Contents

Search

  1. Preface
  2. Understanding Pipeline Partitioning
  3. Partition Points
  4. Partition Types
  5. Pushdown Optimization
  6. Pushdown Optimization and Transformations
  7. Real-time Processing
  8. Commit Points
  9. Row Error Logging
  10. Workflow Recovery
  11. Stopping and Aborting
  12. Concurrent Workflows
  13. Grid Processing
  14. Load Balancer
  15. Workflow Variables
  16. Parameters and Variables in Sessions
  17. Parameter Files
  18. FastExport
  19. External Loading
  20. FTP
  21. Session Caches
  22. Incremental Aggregation
  23. Session Log Interface
  24. Understanding Buffer Memory
  25. High Precision Data

Advanced Workflow Guide

Advanced Workflow Guide

Troubleshooting Orphaned Sequences and Views

Troubleshooting Orphaned Sequences and Views

The Integration Service might not drop a sequence or view object from a database if the Integration Service, session, or connectivity fails. In this case, manually remove these objects from the database.
Orphaned sequence and view objects in the database do not affect performance.
Complete the following tasks to remove an orphaned sequence or view object from a database:
  1. Identify the orphaned objects in the database.
    You can identify orphaned objects based on the session logs or a query on the database. Analyze the session log to determine orphaned objects from a session run. Run the database query to determine all orphaned objects in the database at a given time.
  2. Remove the orphaned objects from the database.
    You can execute SQL statements to drop the orphaned objects you identified.


Updated August 27, 2020