To homepage To homepage

TimeXtender Desktop Q&A

Ask questions and find answers about the TimeXtender Desktop Application

368 Topics

R
Starter
r.rajStarter
asked in Jobs & Executions

TX- Oracle connector issue

The TX oracle connector drops and creates the complete table during export. Is there a way that we can control this behaviour and the table be not dropped ? This is because we need to move data from Staging Orcle to Main tables based on Triggers and if the table is dropped by TX then the trigger is of no use.

3
JTreadwell
Community Manager
3 years ago
S
Contributor
Søren SørensenContributor
asked in ODX

Synchronized data mapping from ODX Server

I'm currently migrating an Azure MI solution to ADLS Gen2 and Synapse Analytics. The migration includes remapping all DSA table ... instead of using an old ODX, DSA will now use an ADLS Gen2 on ODX Server. Mapping tables bring all data source fields across ... it would be nice to have the usual option to only synchronize existing fields as it's a lot of fields to delete when getting the entire data source table.

2
S
Contributor
3 years ago
B
Visitor
bunyamin.ozkilicVisitor
asked in ODX

Extracting from Azure Service Bus

Hi, Is it possible to extract data from an Azure Service Bus into TX?

1
A
3 years ago
T
Visitor
tejasgVisitor
asked in Jobs & Executions

Continuous Integration in Discovery Hub

Hi, I need more information on how i can do continuous integration in discovery hub.

1
JTreadwell
Community Manager
3 years ago
T
Visitor
tejasgVisitor
asked in Jobs & Executions

How to schedule deployment from Development server to Integrated server

Hi, I am trying to find out how i can schedule deployment from development server to integration server at a particular time on everyday. So, whatever changes I am making in the development will be deployed automatically to integration server. Please let me know in case any one has idea regarding the same. For clarification please ask.

1
S
Contributor
3 years ago
E
Starter
eric.vangemertStarter
asked in Jobs & Executions

Logging around setting "when transfer fails".

We started to use the configuration continue without data in case a transfer fails. The feature works fine, and we also see the message that one or more datasources fail. My question is, how can we easily see which datasources failed, and with what error message?  

6
Thomas Lind
Community Manager
3 years ago
H
Visitor
huub.thuijlsVisitor
asked in Jobs & Executions

Missing objects when executing a package after transfer and full managed deployment

I get the followinf error after transferring the latest version van OT to A environment and full managed deployment: Finished executing project 'RobidusDWH' Execution Package 'Laden ACC' Execution failed Start Time : 4/3/2020 7:16:52 AM End Time : 4/3/2020 7:25:01 AM on server: WIN6682 -Execute Execution Package Laden ACC 'Failed'                Invalid object name 'HDA_V_DMA.DM_HDA_HDA_V_DMA_Feit_OpenstaandeTaken_DMA_DMA_Feit_OpenstaandeTaken_T'.                               Details:                               SQL Server: 'cf15a5af617c.tr6225.westeurope1-a.worker.database.windows.net,11009'                SQL Procedure: 'DMA_TX.usp_CrDM_DMA_TX_Feit_OpenstaandeTaken_HDA_HDA_V_DMA_Feit_OpenstaandeTaken'                SQL Line Number: 12                SQL Error Number: 208                               Invalid object name 'HDA_V_DMA.DM_HDA_HDA_V_DMA_Feit_OpenstaandeTaken_DMA_DMA_Feit_OpenstaandeTaken_T'.                Module: .Net SqlClient Data Provider                System.Data

2
JTreadwell
Community Manager
3 years ago
M
Starter
mcvStarter
asked in Data Warehouse

Implementing SQL "CASE WHEN" Statement using native TX functionality

Hi, I have to do something like this in TX: If productno > 0 then 'Product A' else lookup in table productnames I cannot figure out how to do this in TX. Hope someone can help. Best regards Michael Vaisgaard

2
M
Starter
3 years ago
M
Starter
mark.ferrisStarter
asked in Data Warehouse

Use IS NOT NULL as a join condition on lookup

Is there a way to use IS NOT NULL as one of the join conditions on a lookup? I want to get the TOP (1) record where a field is not null, ordered by date. Currently I have to edit the _Clean stored procedure as custom code to add it, which is obviously not the best way to do things. Thanks

15
J
Contributor
2 years ago
A
Contributor
alain.thireContributor
asked in Data Warehouse

Executing stored procedure

How can I execute a stored procedure once a load of a table is done. I know it should be possible. I just don't know where I should configure it  

1
JTreadwell
Community Manager
3 years ago
M
Starter
mcvStarter
asked in Jobs & Executions

Setting a flag when execution is done

Hi, We use TX as a part of our value chain of systems using data. We need to programatically be able to check if the execution is done, so the following jobs can start.I know TX can send an email when completed, but we really do not want to build the check on emails. Does anyone have a good idea on how to do this? Hope you can help. Best regards Michael Vaisgaard

2
JTreadwell
Community Manager
3 years ago
K
Visitor
keith.williamsVisitor
asked in Data Warehouse

Two datasources into one table

Hello,So I am loading historical data into tables in TX created of Excel files. One file for property data, one file for casualty data. After some time the file format changes and they combine these two separate files into one file and add new fields.Can I create a new data source to load the new file but still use the original worksheet tab names such that the data will still load into the existing tables?Thanks in advance.P.S. I am using Discovery Hub 17.12.13.64

7
JTreadwell
Community Manager
2 years ago
H
Contributor
hgrContributor
asked in Jobs & Executions

Notification Execution Packages - Send mails using Google Mail

Hello, Which settings are needed in order to get Google Mail send success and failure emails in TimeXtender?  I tried it with  Servername: smtp.gmail.com Port: 25/465/587 Enable SSL/TLS: Checked Allow invalid certificates: Checked From Email: my.name@gmail.com User name: my.name@gmail.com Password: <my gmail password> To Email: another.email@gmail.com   I get different failure responses:  25: 5.7.0 Authentification required 465: Syntax error, command not recognized 587: 5.7.0 Authentification required   Without SSL/TLS I get: A secure connection is required for the smtp server or the client is not authentificated. Server response was: 5.7.0 Must issue a STARTTLS command first.   The responses are translated from german to english so please don't take them literally.   What are the corrected settings here? Is it something in my google account?  

4
S
Explorer
3 years ago
P
Starter
per.schefferStarter
asked in Data Warehouse

Clustered columnstore index

How do I tell TimeXtender to use a clustered columnstore index for my fact table in Azure Synapse?

2
P
Starter
3 years ago
R
Starter
r.brummansStarter
asked in ODX

Cdata adapter - CSV File 10(GB)

We are trying to get a csv file of 10 gb into TimeXtender but it takes very long for TimeXtender to get this loaded and sometimes we are getting an error (system out of memory). Is there a solution or something else we can try to get big csv files into TimeXtener or can we change the CSV file to get it loaded into TimeXtender? We are now using the Cdata adapter and already used the multiple/single file adapter.   Thanks for the response!

3
JTreadwell
Community Manager
3 years ago
A
Starter
alexander.hauensteinStarter
asked in Data Warehouse

Table classification

How does "Table classification" in Table Settings affect a table ?Can't find any information in the user guide or google.For which cases "Dimension- /Fact Table (normal + large) are use full ?Many thanks for your help.Cheers Alex

3
JTreadwell
Community Manager
3 years ago
A
Visitor
andrew.charltonVisitor
asked in ODX

Cdata connector for Zendesk

Hi I am trying to connect to Zendesk using the Cdata connector.I am getting the following error. Does anyone have this working. 'Initiate OAuth' does not have a  'REFRESH' option it only has NONE and GETANDREFRESHDetails:When using OAuth the 'Initiate OAuth' setting must be set to 'REFRESH'Module: timeXtenderSystem.Exceptionat TimeXtender.DataManager.DataSource_CData.CreateConnection()at TimeXtender.DataManager.DataSource_CData.TestConnection()at TimeXtender.DataManager.ConnectingThread.ExecuteConnectingThread(Object dummy)When using OAuth the 'Initiate OAuth' setting must be set to 'REFRESH'Module: timeXtenderTimeXtender.DataManager.ExceptionWrapperExceptionat TimeXtender.DataManager.ConnectingThread.HandleError()at TimeXtender.DataManager.ConnectingThread.Execute(String title, Int32 progressSteps, List`1 actions)at TimeXtender.DataManager.ConnectingThread.ExecuteFastAction(String title, Action action, IWin32Window parentForm, CancelBehaviors cancelBehavior, ErrorBehaviors errorBehavi

1
thagin
Employee
3 years ago
A
Visitor
andrew.charltonVisitor
asked in ODX

Cdata XML Connector

Hi I am trying retrieve data through an API using XMLI am getting the following error. The API requires I use a wildcard  to retrieve all values. My XML works if I use Postman / Swagger to test.Error obtaining value for column 'ProductList.Product.ProductCode': Error parsing long value [ * ].Details:Error parsing long value [ * ].Module: System.Data.CData.XMLdvo200m.hqat dvo200m.Uw.qM(String )at dvo200m.Uw.u(String , Int32 , Int32 , Boolean )at dvo200m.fZ.Na(String , Int32 , Int32 )at dvo200m.ZG.H(Int32 , Int32 , Int32 )Error obtaining value for column 'ProductList.Product.ProductCode': Error parsing long value [ * ].Module: System.Data.CData.XMLdvo200m.hqat dvo200m.ZG.H(Int32 , Int32 , Int32 )at dvo200m.ZG.GetValue(Int32 , Int32 )at CData.Sql.ResultSetBase.GetValue(Int32 colIndex, Int32 dataType)at dvo200m.Zv.L(Int32 , Int32 , Int32 )Error obtaining value for column 'ProductList.Product.ProductCode': Error parsing long value [ * ].Module: System.Data.CData.XMLdvo200m.hqat dvo200m.Zv.L

4
JTreadwell
Community Manager
2 years ago
M
Starter
mgcStarter
asked in Jobs & Executions

Could not load file or assembly 'Microsoft.SqlServer.BatchParser.dll'

I have enabled simple mode on a project with 1 data source and 1 Business Unit. I have also updated the settings for all tables to support simple mode:When i try to deploy the project i get the error:Could not load file or assembly 'Microsoft.SqlServer.BatchParser.dll' or one of its dependencies. The specified module could not be found.Location: Business Unit 'ABC'.Details:Could not load file or assembly 'Microsoft.SqlServer.BatchParser.dll' or one of its dependencies. The specified module could not be found.Module: mscorlibSystem.IO.FileNotFoundExceptionat System.Reflection.RuntimeAssembly.GetType(RuntimeAssembly assembly, String name, Boolean throwOnError, Boolean ignoreCase, ObjectHandleOnStack type)at System.Reflection.RuntimeAssembly.GetType(String name, Boolean throwOnError, Boolean ignoreCase)at Microsoft.SqlServer.Management.Common.ServerConnection.GetStatements(String query, ExecutionTypes executionType, Int32& statementsToReverse)at Microsoft.SqlServer.Management.Common.S

2
M
Starter
3 years ago
N
Starter
niclas.lofbladStarter
asked in Jobs & Executions

Full load doesn't update the _I table?

Hi!Can you clearify that if I run a full load ( on a source based incremental table), it doesn't update the _I table with the current max value? In our scenario, I run a full load very early in the morning and then run incremental loads during the day. But I have seen that the first incremental load of the day takes a very long time to run which I suspect is due to there being a lot of changes since the last incremental load, i.e. the full load's transfer is ignored by the incremental load?So the first incremental load, more or less, transfers the same data that the full load did?Version 19.11.7.64RegardsNiclas

1
JTreadwell
Community Manager
2 years ago
L
Visitor
lindaj.bekkerVisitor
asked in ODX

Exception from HRESULT: 0xC020801C

Error creating DTS package Exception from HRESULT: 0xC020801C I can't deploy the data and can't syncronize the datasource. I am getting this error. Exception from HRESULT: 0xC020801C Please help

2
Thomas Lind
Community Manager
2 years ago
A
Visitor
atgVisitor
asked in Data Warehouse

Partition Scheme

Hi, I have a large FACT-tables in my DWH (copy from a view in stage). I have tried to add partitions. I didn't help that much, so I removed it again.But since I removed it, the table can't be deployed. I get the below error. I can re-add the partition, but still the same error: An error occurred during drop partition function. See exception details for the failing objectAn error occurred during drop user defined function. See exception details for the failing object: Drop failed for PartitionFunction 'FactSalesOrder_History_PartitionFunction'.An exception occurred while executing a Transact-SQL statement or batch.Partition function 'FactSalesOrder_History_PartitionFunction' is being used by one or more partition schemes. Details: SQL Server: '.'SQL Procedure: ''SQL Line Number: 2SQL Error Number: 7706 I'm not sure how to find and drop what-ever TX is complaining about.Tried this:DROP PARTITION FUNCTION FactSalesOrder_History_PartitionFunction and then get this:Partition function 'FactS

3
J
Contributor
2 years ago
H
Visitor
huub.thuijlsVisitor
asked in Data Warehouse

Column-store index

Is it possible to create a clustered column-store index in TimeXtender 20.103.64?

1
Thomas Lind
Community Manager
2 years ago
M
Starter
mark.ferrisStarter
asked in Data Warehouse

_L and _M Table Behavior

I am using the Field Validation to test our ETL. Using this as source data:And these rules in the DSA:And this query to check for errors:I get the following result:The _L table is linking to the records in the _R table that were removed when they failed the validation step on FIRST_NAME. Also the Warning level notification is not present in the table.As it stands the _L, _R, and _M tables as joined above are showing incorrect or at least confusing information. Am I using them as they were intended to be used, and has anyone done anything to get around this?Thanks,Mark

2
M
Starter
2 years ago
M
Starter
maarten.vanheur
asked in ODX

Unable to update the provider. The provider is currently locked by the application.

hi  am trying to update my CData Datasource providers (Update available) but when i click on the update button, this is what i get: Unable to update the provider.The provider is currently locked by the application. Details: Unable to update the provider. ...Module: timeXtenderSystem.Exceptionat TimeXtender.DataManager.CDataComponentInstallHelper.UninstallComponent(DataSourceComponentModel dataSourceComponentModel, Boolean isUpdate)at TimeXtender.DataManager.ManageCDataDataSourceProvidersCommand.UninstallProvider(Form parentWindow, CDataComponentModelWrapper componentModelWrapper, Boolean isUpdate) Time: 2020-12-09 09:00:29UTC: 2020-12-09 08:00:29Title: CloudDWH - TimeXtender 20.10.6.64Application: 20.10.6.64Repository: 20.10.6.64 (in Azure)SQL Server: Microsoft SQL Azure (RTM) - 12.0.2000.8 Oct 1 2020 18:48:35 Copyright (C) 2019 Microsoft Corporation Any idea what is causing this and what to do to make it work? thanks! M

2
Thomas Lind
Community Manager
2 years ago

Badge winners

  • Certified Solutions Architect
    vrowsehas earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    omarin23has earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    Marco_Bitmetrichas earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    LarsBoyenhas earned the badge Certified Solutions Architect
  • Innovator
    anders.e.jonssonhas earned the badge Innovator
Show all badges
Terms and ConditionsCookie settings