General¶

Troubleshooting, documentation and lineage, infrastructure and legal.

Articles by topic¶

Deprecated¶

• Scheduling Executions using Jobs
• Timextender API Endpoints

Documentation & lineage¶

• Access instance metadata with meta collection
• Documentation for Instances
• Lineage and Visualization

Infrastructure & networking¶

• Create a bacpac export
• Enable Remote Connections to SQL Server using IP address
• Single Sign-On Azure AD in Orchestration, Data Quality and Data Enrichment

Legal¶

• CData Add-On Addendum
• Timextender Software License Agreement

Troubleshooting · Assemblies & environment¶

• Error: 'Could not load file or assembly
• Error: 'Requested registry access is not allowed
• Error: Could not load file or assembly 'Microsoft.AnalysisServices.Tabular, Version=15.0.0.0
• Error: Could not load file or assembly 'Microsoft.SqlServer.BatchParser.dll'
• Error: Faulting module OLEAUT32.dll
• Services are not removed on uninstall
• User interface elements blurry, very small or missing

Troubleshooting · Data sources & connectivity¶

• Authentication Failure When Querying REST API Endpoint Due to Lowercase 'bearer' in Authorization Header for Timextender REST data source
• Azure Data Factory Oracle Data Source - Error executing meta data pipeline
• Dynamics 365 Business Central 'Presented multi-factor authentication has expired' error
• Error '401 Unauthorized' while Connecting to Microsoft Dataverse using Timextender OData Data Source
• Error: 'Error while copying content to a stream' for SQL data source transfer task
• Error: No suitable Oracle driver installed
• Error: The type initializer for 'Oracle.DataAccess.Client. OracleConnectionStringBuilder' threw an exception.
• Errors 'Input string was not in a correct format' and 'The given value of type... cannot be converted' in Timextender Excel Connector
• Execution Timeout Expired Error When Running Execution on IBM iSeries data source
• Important notification regarding product authentication
• New ADF data source with a Ingest Instance task error: 'Failed to encrypt sub-resource payload
• Oracle data source Error in command: Could not load file or assembly Oracle.DataAccess
• Set up and use a certificate to connect to data sources
• Synchronizing ADF Oracle data source produces unexpected results
• Timextender REST API Data Source Fails with 'A task was cancelled' error
• Troubleshooting concurrency issues in Ingest Instance data sources

Troubleshooting · Diagnostics & logging¶

• How to use a debugger to review a Timextender process
• Profiling queries to Azure SQL DB
• Tracing to Event Viewer or Text file logs

Troubleshooting · Execution & orchestration¶

• ADF execution error: ADLS Gen2 operation failed for: Operation returned an invalid status code 'Forbidden'
• Error 'Out of Memory' During Scheduled Execution of TDI package in Orchestration
• Error 'PowerShell script contains malicious content and has been blocked by antivirus software' while Executing PowerShell Scripts in Timextender Orchestrator
• Error 'Request body needs client_assertion or client_secret' while Setting Up Email Notifications for Scheduled Executions
• Error: 'OutOfMemoryException' while executing TDI execution package in Orchestration
• Error: 'Timeout expired
• Execution Package Fails to Start in Orchestration After Creating New Instance in TDI
• No Execution Lock on Instance Error When Running PRD Processes from Orchestration in Timextender
• No notification e-mails are send when executing on a schedule
• Timextender Execution Service 7376.1 service terminated unexpectedly
• Timextender Process Orchestration: Configuring Success Mail Notifications for Executions
• Troubleshooting deadlocks in Execution

Troubleshooting · Ingest¶

• Error ingest to prepare instance ADF merge on demand transfer fails
• Error: 'Forbidden' while Starting Timextender Ingest Service
• Executing a Prepare Instance table from an Ingest Instance gives the error: 'Login failed for user
• How to resolve 'Service request failed: Access is denied' error in an Ingest instance
• How to resolve Ingest Instance error: Property 'OwnerId' does not exist for 'object specified'
• Ingest transfer task error: 'The execution unexpectedly stopped with exit code: 0016 - Error
• Using TCPView tool to monitor the Ingest Service

Troubleshooting · Other¶

• CPU consumption related to Indexes in Timextender Classic Repository Database
• Error 'A connection could not be made to the data source with the Name of' while Using PowerBI Premium Endpoint
• Error 'TDI user already exists' When Adding a User to the Timextender Portal
• Error: 'Failed to save modifications to the server. The end of the input was reached' while Executing PowerBI Premium Endpoint
• Error: Link does not work when opening O&DQ Portal in Browser
• Error: The locale id of the source column and the locale id of the destination column do not match

Troubleshooting · Prepare & data warehouse¶

• Error 'Admin consent needed when creating Lakehouse' while authenticating Prepare Instance in Fabric Lakehouse
• Error: Error Ingesting MSSQL Navision to Azure Data Lake - ParquetInvalidColumnName
• Error: Login failed error when executing first dimension
• How to avoid duplicates in a custom table
• New field in an incremental table doesn't populate