Community

Recently active
Help others
Categories

Execution succesful but notification e-mail

Hi all, at a client we have encountered a curious situation with execution e-mail notifications, hopefully you will be able to help us figure it out.There are 5 scheduled execution packages for BU's that run every morning. Since two days we are getting e-mail notifications saying these have failed, but when we look in in TimeXtender they in fact have executed successfully.Each BU execution throws a different connection error message:ERROR [HY000] [MySQL][ODBC 8.0(w) Driver]Can't connect to MySQL server on 'XXXXXX' (10060) Unable to connect to any of the specified MySQL hosts. The remote server returned an error: (400) Bad Request. [500] Could not execute the specified command: HTTP protocol error. 500 Internal Server Error. ERROR [08001] could not connect to server: Connection refused (0x0000274D/10061) I will take the top one as an example to show you how it looks. Attached is the full fail notification e-mail.This package includes has the following settings: This is what the executi

8 minutes ago

bas.hopstakenTimeXtender Xpert

General

TempDB is growing rapidly in terms of disk space, how to avoid/troubleshoot this?

Hi community,I have a question about the Temp DB in SQL Server. We have a customer where the TempDB is growing rapidly, the disk is expanded multiple times. Although it is not a problem to expand this disk again for this customer. I want to understand how we can avoid the TempDB growing rapidly?I do not have a DBA background.The TempDB for this customer is 40 GB at the moment. All ‘heavy’ tables are loaded incrementally and batch cleansing is enabled for these tables. I have some questions:I know batch cleansing is preventing the logs will grow rapidly, but does it also have impact on the TempDB? Are there any other table settings in TimeXtender can help reducing the TempDB size? Does the number of threads in a execution package have impact on the TempDB? Are there any best practices in determining the correct/optimal disk size for the TempDB? Are there any troubleshooting ideas/tools for this?Any other suggestions?

1 hour ago

FENStarter

General

Benefits of pre defining a Relation or just defining the Relation while Adding a Conditional look Up

Hallo,Iam really new to all of the Timextender functionalities, so i have a small case/question for the Community: I would like to join two tables and i dont know, if I first define the relation between the two tables or just drag the field into the othe table and create a lookup field then I will have the option to define a specific relation for this field. Where are the benefits of creating a relation first ? ty in advance FEN

2 hours ago

amartinezStarter

Legacy & Upgrades

License code cannot be empty error

Hello Support,We are receiving the following error in one of clients TX environment version 20.1.6.64 when attempting to activate using offline license file. If you need assistance, please submit this with your ticket.License code cannot be empty.Details:License code cannot be empty.Module: timeXtenderSystem.Exception at TimeXtender.DataManager.TXWizardController.DoNext() at TimeXtender.DataManager.TXWizardDialog.btnNext_Click(Object sender, EventArgs e)Time: 2023-09-28 10:45:28UTC: 2023-09-28 14:45:28Title: Discovery Hub 20.1.6.64Application: 20.1.6.64Repository: 20.1.6.64 (in Azure)SQL Server: Microsoft SQL Azure (RTM) - 12.0.2000.8 Sep 18 2023 12:22:37 Copyright (C) 2022 Microsoft CorporationUser: freshtxsrvDomain: NAOS: Microsoft Windows Server 2019 DatacenterOS version: Microsoft Windows NT 6.2.9200.0Machine name: xxxxx013CPU count: 2Build: 64 bit

14 hours ago

Thomas LindCommunity Manager

Data Warehouse

Date TableTutorial

To analyze data over time, it's common to include a date dimension in your data model. By adding a date table to your data area, you can provide the semantic instance with a time dimension that can be used in calculations. Date tables are typically added to semantic instances because they simplify the calculation needed to compare different dates related to each other. In addition to using various components of the date value as time dimensions (Day, Week, Month, Quarter, Year), date tables also contain indexes that help determine the relation of any date value to the current date.Updating a Date TableCustom time periods can be added to account for special periods of time such as holidays or yearly sales campaigns. These custom periods can be comprised of one or more individual time periods and provide a quick and convenient way to account for these special periods of time.Adding a date table Add a Date Hierarchy. Set up a Fiscal year Set up custom periods Set up custom names Adding

4453

23 hours ago

BernarddbContributor

ODX

bas.hopstakenTimeXtender Xpert

General

TempDB is growing rapidly in terms of disk space, how to avoid/troubleshoot this?

1 hour ago

amartinezStarter

Legacy & Upgrades

License code cannot be empty error

14 hours ago

r.miltenburgStarter

Data Warehouse

Unable to add job for Data Warehouse and Semantic model

Hi guys,Somehow I am unable to create a job for my semantic models or my datawarehouse/ data area. I can’t select the model when I’m trying to add a new job.

3 days ago

Pontus OlaussonVisitor

Jobs & Executions

Excel Online connector sometimes fail with "Error while listing workbooks for drive"

Hi,I am running a legacy version of TimeXtender (version 20.10.40.64), where we have an Excel Online connection set up using CData ADO.NET Provider for Microsoft Excel Online 2022 (22.0.8389.0) as data source.This data source is configured to authenticate via Azure ‘client flow’, see picture. The app registration in Azure has the following permissions: The data source works properly most of the time. It is able to list the worksheets it finds on the SharePoint site, and can fetch data. However, scheduled execution packages sometimes fails with the following error message:[500] Could not execute the specified command: Error while listing workbooks for drive: [generalException] General exception while processing. Details: Error while listing workbooks for drive: [generalException] General exception while processing. Module: System.Data.CData.ExcelOnline fx220l.yg at fx220l.IIu.m(Boolean ) at fx220l.IIu.X(tbp`1 , Boolean ) at fx220l.IIu.YI(LoL )

10 days ago

Roy VContributor

Interoperability with other Platforms & Tools

Full deployment functionality to Snowflake

HelloAt the moment we are processing our MDW datawarehouse to an Azure SQL Database and then we copy data to Snowflake.We want to change this to Snowflake directly however only when it is possible to fully deploy to Snowflake (transformations included).I know it is hard to give an exact timeline when this becomes available but do I need to think in a couple of months or in a couple of quarters or is this even low priority at the moment?Looking forward to your response,Greetings, Roy

15 days ago

boyclaesenContributor

ODX

Date field is converted to an integer.

Hello, To my understanding TimeXtender determines the data type of a column based on first x amount of rows, depending on your setup in the portal. The fields in my source come in as (dd.mm.yyy) for example: "05.03.2021”. I use a Storage Account with a CSV connection. I would expect that TimeXtender creates a "date” date type out of this. However, is seems that if a field character starts with a '0’, it skips it. In the ODX it shows an Integer value '5032023’.ODX: Depending if a character starts with a '0’ the fields (dates) show up like: It counts for all date fields and costs me a lot of time to create a work around each time. I tried to override the datatype in my data source but without succes. Help would be much appreciated.

15 days ago

BernarddbContributor

ODX

Execution log warning column already exists

Hi all,For one of my current client's we are rectrieving a warning while syncing the odx. The task is completed and we can transfer the data. but the warning is a bit odd.We already tried to remove the folder from the data lake and try a full load. but this didn't fix the warning. Anyone any ideas?

1 month ago

jacqueline.hofmeijerExplorer

REST APIs

Use variables on Query tables

Hi,I have a project that is using the cdata connector as a datasource, and because of issues with paging and nested call we have created query tables to get the correct results (using queryslicer in the rsd-files).Because of performance issues the tables have to be setup for incremental loading, but I cannot get this working because I need the incremental value in the call.Is it somehow possible to use a variable or a field from another table in the Quey tables to get the incremental value?When using a fixed date the logic is working fine (as shown below) but that's not workable: SELECT * FROM [REST].[EventRegistration_Detail] WHERE [file_name] IN (SELECT [Name] FROM [REST].[EventRegistration_List] WHERE [Properties.Last-Modified] > '2023-01-01') (using TX 20.10.30.64 with Business Units) Any good suggestions on this? Kind regards,Jacqueline

1 month ago

Pontus OlaussonVisitor

Legacy & Upgrades

Mail notifications not working - SMTP server does not support authentication

Hi,I am using legacy TimeXtender 20.10.40.64, and am attempting to set up email notifications for execution package failures.I have been given the information for the destination (email load balancing relay):IP: 150.xx.xx.1Port: 25The destination firewall supposedly has all necessary ports open, although I don’t have direct access to check this. When I test the notification, I receive the error “The SMTP server does not support authentication.” (see the picture below). The app registration on Azure has the following API permissions (all delegated and granted admin consent):Microsoft Graph User.Read Microsoft Graph Mail.Send Microsoft Graph SMTP.Send I haven’t been able to find any information about the error message and what could be causing it. Any help or pointers for troubleshooting this further would be appreciated. Best regards,Pontus

1 month ago

TimeXtender Desktop Q&A

Ask questions and find answers about the TimeXtender Desktop Application

ODX

110 topics
541 Replies

Data Warehouse

140 topics
535 Replies

Semantic Models

38 topics
177 Replies

Jobs & Executions

83 topics
316 Replies

TimeXtender Portal Q&A

Ask questions about the TimeXtender Portal

General

18 topics
66 Replies

Data Sources Q&A

Ask questions of about setting up data sources

General

28 topics
120 Replies

REST APIs

17 topics
111 Replies

RSD File Customization

18 topics
105 Replies

SAP

1 topic
1 Reply

Oracle

6 topics
33 Replies

ODBC

4 topics
28 Replies

General Q&A

Ask general questions

General

21 topics
59 Replies

Interoperability with other Platforms & Tools

7 topics
30 Replies

Legacy & Upgrades

50 topics
180 Replies

Security & Compliance

0 topics
0 Replies

Infrastructure & Networking

3 topics
9 Replies

Learn & Share

Share tips and best practices, show what you've created and inspire others

Success Stories

1 topic
0 Replies

Tips, Tricks and Best Practices

13 topics
13 Replies

TimeXtender Tuesdays

29 topics
40 Replies

Community Announcements

Everything you need to know about this community

Getting started in the community

7 topics
5 Replies

Company Announcements

7 topics
25 Replies

User leaderboard

Show full leaderboard

Badges

Maarsenhas earned the badge Certified Solutions Architect
danielhas earned the badge ODX Expert
vrowsehas earned the badge Certified Solutions Architect
omarin23has earned the badge Certified Solutions Architect
Marco_Bitmetrichas earned the badge Certified Solutions Architect

Show all badges

Community Categories

Date TableTutorial

User leaderboard

Badges

Need more help?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded