In my first post on Task Factory's Oracle Upsert Destination, I gave you an in-depth "How To" demonstration. In this blog, I'm going to discuss some troubleshooting tips when you encounter errors.
If you’re an avid user of an Oracle Database, you are no stranger to the oddities that are presented when dealing with Oracle Errors. If this is you, then you may very well be familiar with the following scenario.
You’ve been hard at work configuring a process you expect to run at first execution. You smile and gladly select “Execute Task” expecting everything to run smoothly! Suddenly, that moment in time arrives where you expect your hard work to pay off, but instead, you’re greeted with a vague error message and a brand new set of confusing obstacles to overcome!
Lucky you! After you’ve stopped pounding your head against the desk and have taken a walk, you come back determined as ever to get passed the issue at hand.
This is a common scenario encountered daily with many users. The frustration can be exhausting when trying to troubleshoot Oracle. Task Factory does not want to make it difficult for its users running the TF Oracle Upsert Destination; on the contrary! There are many errors that occur and provide a vague error message that are actually being returned by the Oracle Environment itself and not the actual component. Despite the Error Message referencing TF Oracle Upsert Destination, most of these can be diagnosed to an issue with the Oracle Database itself.
I have replicated many of these issues in the Demo below. In this demonstration, I discuss the most common errors that can be encountered when using the Task Factory Oracle Upsert Destination and their resolution.
The error messages we will discuss are as follows:
3) [TF Oracle Upsert Destination ] Error: System.Exception: Could not create temporary destination table: ORA-00955: name is already used by an existing object
at PragmaticWorks.TaskFactory.Components.Destinations.OracleUpsert.OracleTempTableHelper.CreateTempTable(String tableName, List`1 columnMappings, caf49ee4061d0ec700408327966353750 rowFlagColumnSettings, Boolean onlyRunInserts)
Let’s get started on this, our second part series on the Task Factory Oracle Upsert Destination!