-- 6/8/2020 10:13:58 AM: Aktana.log: Setting up environment
-- 6/8/2020 10:13:58 AM: Aktana.log: Script run by Toad Data Point 5.1.6.206 as oax98339 on US1SAWN01727
-- 6/8/2020 10:13:58 AM: Aktana.log: AppDataDir = C:\Users\oax98339\AppData\Roaming\Quest Software\Toad Data Point 5.1
-- 6/8/2020 10:13:58 AM: Aktana.log: Temp Dir = C:\Users\oax98339\AppData\Local\Temp\
-- 6/8/2020 10:13:58 AM: Aktana.log: Build started
-- 6/8/2020 10:13:58 AM: Aktana.log: Compiling script
-- 6/8/2020 10:13:58 AM: Aktana.log: Start CompileWorkflow
-- 6/8/2020 10:13:58 AM: Aktana.log: Before Compile
-- 6/8/2020 10:14:01 AM: Aktana.log: Return from CompileWorkflow
-- 6/8/2020 10:14:01 AM: Aktana.log: Workflow Compiled without Errors
-- 6/8/2020 10:14:01 AM: Aktana.log: Build completed
-- 6/8/2020 10:14:01 AM: Aktana.log: Create Workflow instance
-- 6/8/2020 10:14:02 AM: Aktana.log: Started workflow instance
-- 6/8/2020 10:14:02 AM: Aktana.log: Begin execution script activities
-- 6/8/2020 10:14:02 AM: Aktana.log: Variable "ROOT_PATH" set to E:\USMA Processes\Aktana\UAT
-- 6/8/2020 10:14:02 AM: Aktana.log: Variable "RUN_MODE" set to Test
-- 6/8/2020 10:14:03 AM: Aktana.log: Scanning the script for prompt bind variables
-- 6/8/2020 10:14:03 AM: Aktana.log: Connection description = USPRD024 (MEDLKPADM_BATCH), MEDLKPADM_BATCH
-- 6/8/2020 10:14:03 AM: Aktana.log: Connection node found
-- 6/8/2020 10:14:04 AM: Aktana.log: Connection to: USPRD024 (MEDLKPADM_BATCH), MEDLKPADM_BATCH
-- 6/8/2020 10:14:05 AM: Aktana.log: Connection successful
-- 6/8/2020 10:14:05 AM: Aktana.log: Connection logon: MEDLKPADM_BATCH
-- 6/8/2020 10:14:05 AM: Aktana.log: Last schema: MEDLKPADM_BATCH
-- 6/8/2020 10:14:06 AM: Aktana.log: Default schema: MEDLKPADM_BATCH
-- 6/8/2020 10:14:06 AM: Aktana.log: Auto Commit: False
-- 6/8/2020 10:14:06 AM: Aktana.log: Running export template E:\USMA Processes\Aktana\UAT\Aktana - Data.txp
-- 6/8/2020 10:14:06 AM: Aktana.log: ValidateSuffix: Using base suffix: yyyy-MM-dd
-- 6/8/2020 10:14:07 AM: Aktana.log: ValidateSuffix: Suffix is predefined literal - returning empty suffix instead
-- 6/8/2020 10:14:07 AM: Aktana.log: Beginning export: <ExportList><Quest.Toad.ImportExport.ExportEngine><FileConfiguration FileFormatType="DelimitedText" ExcelFile="False" Clipboard="False" FileName="USMA Aktana Data " FileOverwrite="True" FileSuffix="yyyy-MM-dd" FileDirectory="E:\USMA Processes\Aktana\UAT\" FileExtension="txt" Delimiter="|" QuoteChar="'" HeaderRow="True" AlwaysQuoteString="False" AlwaysQuoteDateTime="True" RowsIncrement="5000" LineFeed="Windows" Width="60" OnlyQuoteWhenNeeded="False" UpperKeywords="False" TableScript="False" IncludeSQL="False" AppendDelimiterAtEnd="False" UseCurrentLocale="False" SchemaAppend="False" Encoding="" CheckResources="False" BlockInsert="False" BlockInsertValue="500" IdentityInsert="False" Overwrite="False" ExcelUseOpen="True" AddExcelWorksheetsAsNeeded="True" HeaderBackColor="LightGray" ExcelAutoFitColumns="True" ExcelBeforeExportMacros="" ExcelAfterExportMacros="" ExcelAtType="ActiveCell" ExcelAtLocation="" ClearWorksheet="True" AppendTimeStampToNamedWorksheet="False" AppendExistingAccessTable="False" SingleAccessTableName="" AccessRecreate="False" AccessTruncate="False" SPListName="" CreateNewSPList="False" DeleteSPList="False" ExportSPListBlockSize="0" AllowAppend="False" /><Tables><Table>oracle://MEDLKPADM_BATCH@USPRD024/VIEW/MEDLKPADM_BATCH/IE_AKTANA_DATA_V01</Table></Tables><Options><TableOption TableLocation="oracle://MEDLKPADM_BATCH@USPRD024/VIEW/MEDLKPADM_BATCH/IE_AKTANA_DATA_V01" ColumnOrders=""><Fields><Field ColumnName="PRODUCT" ColumnLocation="oracle://MEDLKPADM_BATCH@USPRD024/VIEW/MEDLKPADM_BATCH/IE_AKTANA_DATA_V01/COLUMNS/PRODUCT" Include="True" FixedWidth="150" AlwaysSupport="False" DataType="VARCHAR2(150)" ColumnOriginalOrderID="0" ColumnOrderID="0" /><Field ColumnName="CID" ColumnLocation="oracle://MEDLKPADM_BATCH@USPRD024/VIEW/MEDLKPADM_BATCH/IE_AKTANA_DATA_V01/COLUMNS/CID" Include="True" FixedWidth="120" AlwaysSupport="False" DataType="NVARCHAR2(120)" ColumnOriginalOrderID="1" ColumnOrderID="1" /><Field ColumnName="DATA_NAME" ColumnLocation="oracle://MEDLKPADM_BATCH@USPRD024/VIEW/MEDLKPADM_BATCH/IE_AKTANA_DATA_V01/COLUMNS/DATA_NAME" Include="True" FixedWidth="52" AlwaysSupport="False" DataType="VARCHAR2(52)" ColumnOriginalOrderID="2" ColumnOrderID="2" /><Field ColumnName="DATA_VALUE" ColumnLocation="oracle://MEDLKPADM_BATCH@USPRD024/VIEW/MEDLKPADM_BATCH/IE_AKTANA_DATA_V01/COLUMNS/DATA_VALUE" Include="True" FixedWidth="60" AlwaysSupport="False" DataType="NUMBER(8,2)" ColumnOriginalOrderID="3" ColumnOrderID="3" /><Field ColumnName="EXTRACT_DATE" ColumnLocation="oracle://MEDLKPADM_BATCH@USPRD024/VIEW/MEDLKPADM_BATCH/IE_AKTANA_DATA_V01/COLUMNS/EXTRACT_DATE" Include="True" FixedWidth="13" AlwaysSupport="False" DataType="VARCHAR2(10)" ColumnOriginalOrderID="4" ColumnOrderID="4" /></Fields></TableOption></Options></Quest.Toad.ImportExport.ExportEngine></ExportList>
-- 6/8/2020 10:14:30 AM: Aktana.log: 10:14:07 AM Thread (4) Adding Export Notification Subscriber {0}
-- 6/8/2020 10:14:30 AM: Aktana.log: 10:14:07 AM Thread (4) Export Started [6/8/2020 10:14:07 AM]
-- 6/8/2020 10:14:30 AM: Aktana.log: 10:14:07 AM Thread (4) ** START ** 
-- 6/8/2020 10:14:30 AM: Aktana.log: 10:14:07 AM Thread (4) Export using connection: USPRD024 (MEDLKPADM_BATCH), MEDLKPADM_BATCH
-- 6/8/2020 10:14:31 AM: Aktana.log: 10:14:07 AM Thread (4) Export Wizard: Building object list
-- 6/8/2020 10:14:31 AM: Aktana.log: 10:14:07 AM Thread (4) Build List done.
-- 6/8/2020 10:14:31 AM: Aktana.log: 10:14:07 AM Thread (4) Exporting Data (1 of 1)
-- 6/8/2020 10:14:31 AM: Aktana.log: 10:14:07 AM Thread (4) BEGIN IE_AKTANA_DATA_V01 :
-- 6/8/2020 10:14:32 AM: Aktana.log: 10:14:07 AM Thread (4) Object MEDLKPADM_BATCH.IE_AKTANA_DATA_V01 started.
-- 6/8/2020 10:14:32 AM: Aktana.log: 10:14:29 AM Thread (10) InternalReadBackground - after ExecuteReader - command SELECT /*+ NOPARALLEL (data) */ * FROM {{Quote(:f1)}}.{{Quote(:f2)}} data 
-- 6/8/2020 10:14:32 AM: Aktana.log: 10:14:29 AM Thread (15) DoneReadTreadWriter
-- 6/8/2020 10:14:32 AM: Aktana.log: 10:14:29 AM Thread (15) Writing rows 0 - 4906
-- 6/8/2020 10:14:33 AM: Aktana.log: 10:14:29 AM Thread (15) Exception in WriteRows
-- 6/8/2020 10:14:33 AM: Aktana.log: 10:14:29 AM Thread (15) Object reference not set to an instance of an object.
-- 6/8/2020 10:14:33 AM: Aktana.log: 10:14:29 AM Thread (15) Writing rows Finalize
-- 6/8/2020 10:14:33 AM: Aktana.log: 10:14:29 AM Thread (15) User cancelled
-- 6/8/2020 10:14:34 AM: Aktana.log: 10:14:29 AM Thread (15) DoneReadThreadWriter finally - adapter.RowsRead 4906
-- 6/8/2020 10:14:34 AM: Aktana.log: 10:14:29 AM Thread (4) END IE_AKTANA_DATA_V01 : 
-- 6/8/2020 10:14:34 AM: Aktana.log: 10:14:29 AM Thread (4) Object MEDLKPADM_BATCH.IE_AKTANA_DATA_V01 finished with error: Object reference not set to an instance of an object.
-- 6/8/2020 10:14:35 AM: Aktana.log: 10:14:29 AM Thread (4)    at Quest.Toad.ImportExport.Writers.WriterBase.WriteRows[TRow](Object lockObj, ExportTable`1 table, Int32 highCount, IEnumerable`1 rows)
-- 6/8/2020 10:14:35 AM: Aktana.log:    at Quest.Toad.ImportExport.Writers.WriterBase.WriteRows(FastTable table)
-- 6/8/2020 10:14:35 AM: Aktana.log:    at Quest.Toad.ImportExport.ExportObjectData.DoneReadThreadWriter()
-- 6/8/2020 10:14:35 AM: Aktana.log: 10:14:29 AM Thread (4) Export Finished [6/8/2020 10:14:29 AM]
-- 6/8/2020 10:14:36 AM: Aktana.log: 10:14:29 AM Thread (4) Export time = 00:00:22.5356196
-- 6/8/2020 10:14:36 AM: Aktana.log: Thread (4)   Build Time 00:00:00.0468516
-- 6/8/2020 10:14:36 AM: Aktana.log: Thread (4)   Complete Time 00:00:22.5356196
-- 6/8/2020 10:14:36 AM: Aktana.log: 10:14:29 AM Thread (4) ** END ** 
-- 6/8/2020 10:14:37 AM: Aktana.log: Export_Data - Object reference not set to an instance of an object.

-- 6/8/2020 10:14:37 AM: Aktana.log: Object reference not set to an instance of an object.
-- 6/8/2020 10:14:37 AM: Aktana.log: System.Exception - Export_Data - Object reference not set to an instance of an object.


Inner exception:
System.NullReferenceException - Object reference not set to an instance of an object.
   at Quest.Toad.Workflow.Activities.Database.ExportWizardActivity.Execute(ActivityExecutionContext executionContext)

-- 6/8/2020 10:14:38 AM: Aktana.log: Start error email
-- 6/8/2020 10:14:38 AM: Aktana.log: Email To: Michael.R.Hinkle@gsk.com, From: noreply@gsk.com, cc: 
-- 6/8/2020 10:14:38 AM: Aktana.log: Email Subject: Automation Script Error - Aktana #RUN_MODE# 
-- 6/8/2020 10:14:38 AM: Aktana.log: Generating exception Email
-- 6/8/2020 10:14:39 AM: Aktana.log: Email message: 

Automation script "Aktana" had errors while executing. The exception messages are listed below and the log file is attached. 

Exception Messages:
Export_Data - Object reference not set to an instance of an object.

Object reference not set to an instance of an object.

-- 6/8/2020 10:14:39 AM: Aktana.log: Setting up SMTP email