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:
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.
Remove the orphaned objects from the database.
You can execute SQL statements to drop the orphaned objects you identified.