To homepage To homepage

General Q&A

Ask general questions

64 Topics

R
Starter
richardrayStarter
asked in Legacy & Upgrades

Use Project Variable as Fixed value for join

v20.10.36.64When setting up the relation between two tables, is there a way to use a project variable as the “Value” when the “Fixed Value” option is used?

6
R
Starter
4 days ago
R
Visitor
robert.kangasVisitor
asked in General

TimeXtender UI is intermittently slow

Hello there, we’ve been experiencing intermittent slowness in the TimeXtender UI within the past few weeks.  Even doing simple things like right clicking on a execution package to view the logs, trying to see the status of an ODX transfer job, etc. will sometimes cause the UI to feel like it’s just not responding (no lotus status UI) for 30 seconds to minutes.This isn’t something that happens all the time and we haven't been able to nail down a root cause.  Our VM where the UI is running is rarely over 30% CPU usage and we usually have over 80% memory free.  Same goes for the VM that the ODX is running on.  How do you even begin to troubleshoot this when the UI is slow to respond?  The TimeXtender UI is on version 20.10.38.64.  The TimeXtender ODX server is on version 20.10.37Thanks!

3
Christian Hauggaard
Community Manager
5 days ago
R
Starter
remcoStarter
asked in General

Transfer TimeXtender to another Server

Dear Community, I have a few questions regarding transferring to another internal server and if you could help me with any of these questions help is appreciated.We have currently two servers running on SQL Server 2016, one server has the DEV and ACC environments and the second server has our PROD Environment (TimeXtender 20.10.39.64).The environments were installed by a supplier but their external employee left, so we want to try and install this on our own (with snapshots/backups in case something goes wrong).We want to try and move the DEV/ACC environment to a new server which has the same TimeXtender version but SQL Server 2019. For this move I have 3 questions:Can I just export and import the project from old server to my new server and load the data again into a new SQL database? How can I set up my environments in such a way that my DEV → ACC → PROD traject isn’t changed. I could not find those settings and had trouble finding them on the legacy page. As the DEV/ACC environments

3
R
Starter
5 days ago
anders.e.jonsson
Contributor
anders.e.jonssonContributor
asked in General

Where is the manual/guide for upgrade of the new version (6xxx)?

Hi,I need it for a customer.I think i have seen something, but can’t find it now.BRAnders

2
anders.e.jonsson
Contributor
1 month ago
S
Explorer
StefanSExplorer
asked in Legacy & Upgrades

Legacy TX only available through Legacy support site?

Hi,Can we only download TX 20.10.x on the Legacy support page?https://legacysupport.timextender.com/hc/en-usI can't find it through the new Support.timextender.com site under Product updates, there I can just find the new SaaS solution.Thanks.

1
Christian Hauggaard
Community Manager
1 month ago
K
Contributor
KajEmergoContributor
asked in Interoperability with other Platforms & Tools

XMLA endpoint stuck on deploy

Hi, in TX v20 we are trying to configure XMLA endpoints. We were having issues with using the Service Principle so now using Windows authentication. When we test the connection, this works OK. But when trying to deploy the endpoint, it runs for an infinite amount of time without any error message. We have put the settings on XMLA Endpoint to ‘Read Write’ but still no change.Also, the workspace is Premium Capacity so I guess the relevant XMLA Endpoint setting in Power BI is like this, correct?So the ‘Read Write’ setting for Premium Per User is irrelevant?

8
K
Contributor
1 month ago
E
Participant
EvidaXremParticipant
asked in Legacy & Upgrades

SQL Server 2022 Compatibility (Source databases and TX Databases incl. Semantic Layer DB) [legacy version]

Any news on SQL Server 2022 Compatibility?Expected release date?

6
E
Participant
1 month ago
peter.jensen
TimeXtender Xpert
peter.jensenTimeXtender Xpert
asked in Legacy & Upgrades

Tables made empty after ADF load from ODX to DSA

Hi,We wonder if someone of you already ran into this issue, and perhaps have an idea on how to solve it ?Setup :TX 20.10.38 using Azure SQL DB for DWH and ADLS gen2 for ODX Server.  ADF used to load data from ODX Server into DSA.  All databases have private endpoint, so SelfHosted Integration Runtime is used by ADF.Issue :From time to time (random - not always on the same tables - for both incremental and full load tables) we notice that the ADF pipeline takes the normal amount of time to load data from ODX to DSA R-table. However the cleansing takes 0 (zero) seconds and the record count log reports 0 (zero) records in the R-table.  ADF nor TimeXtender Execution report an error.In the ODX Service Log we often notice this error : Failed to encrypt sub-resource payload… (not on exact the same moment as the execution - so not sure it has something to do with the issue)Work-around : ADO.netWe had a simular issue last year and started using ADO.net to load data from ODX Server into DSA.  We

6
peter.jensen
TimeXtender Xpert
2 months ago
T
Visitor
theenemanVisitor
asked in Legacy & Upgrades

Error when deploying tabular model - "This row has been removed"

Hi all,When deploying our tabular model/endpoint (Azure Analysis Services), we get a strange error: "This row has been removed from a table and does not have any data. BeginEdit() will allow creation of new data in this row".In the error message we don't see which table or row this relates to and we don't know if this error relates to a datawarehouse table or a repository table. All our datawarehouse tables in this tabular model contain data and 'look good'. In addition, this error occurs in one of our environments and not in the other environments. Has anyone experience with this error? Any thought on how we can debug this one?Thanks.

6
anders.e.jonsson
Contributor
2 months ago
andrew.gebhard
Participant
andrew.gebhardParticipant
asked in General

TX Solutions Architect Badge

Hi,I previously obtained my TimeXtender Solutions Architect certificate. How can I get the badge to show up in the community? Kind regards,Andrew

1
Christian Hauggaard
Community Manager
2 months ago
L
Starter
LuukNTSStarter
asked in Legacy & Upgrades

Using PowerBI Premium Tabular for TimeXtender Legacy instead of AAS

There's loads of documentation about AAS and PowerBI Premium tabular models being mostly identical in use. Currently we are using 2 expensive AAS servers to host our development and testing semantic models. Transferring these 2 environments to a PPU environment within PowerBI would save allot of money. Within the current version of TimeXtender there is a separate option to select a Premium Tabular model instead of AAS. This is something the legacy version does not have. But why would TimeXtender need to know the difference. In working with either Premium or AAS their XMLA connection is exactly the same. Setting a migration from AAS to Premium and then simply exchanging the links within the environment properties seems like a simple enough plan. As i found in the following link the important part would be having an updated library to do this data transfer. https://learn.microsoft.com/en-us/analysis-services/client-libraries?view=azure-analysis-services-currentOther than this i don't see

12
andrew.gebhard
Participant
2 months ago
R
Starter
richardrayStarter
asked in Legacy & Upgrades

Pre-script results in error

v20.10.36.64Hi,I have set up a simple script action as follows to set the LAST_CHANGE_DATETIME column to the ENTRY_DATETIME value if it is NULL.Script action This works fine when selecting from the table in SSMS:SSMS results using same script actionThe script is set as a pre-script to the ADO.NET transfer on the execute step, but when I execute the table, the following error appears:Incorrect syntax near 'LAST_CHANGE_DATETIME'.Can I implement this simple script action as a pre-script? The idea is that I can then use a fully populated LAST_CHANGE_DATETIME column for incremental loads on my ledger table.Thanks,Richard 

4
rory.smith
TimeXtender Xpert
3 months ago
A
Starter
alfred.kristinssonStarter
asked in Legacy & Upgrades

Data Export - From Business Unit

I have used the data export tool to export to .csv files. However I can not do it straight from the Business Unit. Is that a feature that can be added? Or maybe not included in client license. The client wants a few tables from source to be transfered to Azure Data Lake as a csv file and do some tranformation there.

4
Christian Hauggaard
Community Manager
3 months ago
C
Starter
cwatkinsStarter
asked in General

TimeXtender Project Load Times

Good afternoon, When I transfer my project from our DEV to PROD environment, it takes over 25 minutes. I also have the same problem when opening the project from PROD to deploy and execute changes.  Is there anything I can do in order to make these times more manageable? Thanks, Chuck

2
Christian Hauggaard
Community Manager
3 months ago
W
Starter
wilsb01Starter
asked in Legacy & Upgrades

I'm encountering a truncation error when synchronizing Dynamic AX Adapter data source in my Business Unit

We have an upgraded MS Dynamics 365 environment, from which we publish to an Azure SQL database.  When I attempt to attach an existing project to it to synchronize data source (using a SQL data source connector as the project normally does) I can connect with a test connect, but then after building the selection tree, TimeXtender throws the error “The given value of type String from the data source cannot be converted to type nvarchar of the specified target column. String or binary data would be truncated."  Since it isn’t yet part of project execution but rather a TimeXtender comparison operation, I’m somewhat befuddled as to how to proceed.  I’m not sure if this belongs in data sources or desktop, so took a guess on placement.

7
Christian Hauggaard
Community Manager
3 months ago
bas.hopstaken
TimeXtender Xpert
bas.hopstakenTimeXtender Xpert
asked in General

How to earn badges?

Hi all,Congratulations with the TimeXtender Community portal. It looks way better than the ‘old portal’.I have a question about the badges. Because I passed the ‘Solution Architect’ exam, I’ve earned a badge.I’m wondering, what badges are available, what do they mean and how to earn them?

1
Christian Hauggaard
Community Manager
4 months ago
S
Participant
satish.padarthiParticipant
asked in General

SourceCode modification on System Fields

Did anyone tried to rename or modify the source code on system fields from being 'customdata' based on the filename or business unit you are unloading a text or excel file?I would really love this as this source code is one of my primary keys and it's uniform irrespective of the business unit I unload the data becoz of excel docs being used.

1
Thomas Lind
Community Manager
4 months ago
M
Starter
mikkel.hansenStarter
asked in Legacy & Upgrades

General Database for multiple TextFiles

Hi.I want to create a global Data Source Database for a multiple Text File import. But there seems to be no available type?Do i just use the single text file option? 

3
Christian Hauggaard
Community Manager
4 months ago
M
Starter
mirjam.bleuminkStarter
asked in Legacy & Upgrades

Schedule job stops executing

Once in a while my scheduled job does not finish without an error. It just stops doing anything.My event log states that around the time my job stopped running, both the server and the scheduler started.I do not find anything in the logs where it says the server and scheduler stopped running, so I have no idea why they restarted.Would the server/scheduler being down explain why the job stops running rather than failing and providing an error?Does anybody experience the same? Any ideas where I can find more information on why the server/scheduler stopped or restarted? And possibly how I can prevent this of course? 

3
Christian Hauggaard
Community Manager
4 months ago
B
Contributor
brandon.spencerContributor
asked in Legacy & Upgrades

Does anyone have experience switching from ADO.NET to SSIS?

We would like to possibly switch from ADO.NET to SSIS.  At the moment, both the TX application (ODX is not being used) and the SQL server are on the same box using ADO.NET.  We want to split off TX to its own server and use SSIS instead of ADO.NET.  Has anybody done this and can share the high level steps?  Or even how you think it might be best accomplished?  Specifically, once the application server is up and running with all the pertinent software, how would one make this transition?

5
W
Contributor
10 months ago
H
Visitor
huub.thuijlsVisitor
asked in General

Datatype Project / Instance Variable

Hello,I defined a Project Variable where I casted the output as date,When using the variable in a view TX returns an int.What am I doing wrong?

1
rory.smith
TimeXtender Xpert
9 months ago
D
Explorer
dsvartzmanExplorer
asked in General

working with multiple project

Hi , our DH setup consists of multi-layered datawarehouse whereas BI client (tableau ) only interfaces the upper tier: MDW DWH.Having semantic layer for each dashboards (we have quite a few), we would like to move out of the single core TX project with multiple semantic layers to a project for each dashboard (semantic layer). By doing so, we can make sure that each developer works on his own project without "stepping on each other toes" (I'm aware of collabaration features of TX) and keeping our core project unharmed. So, the challenge is how to reuse objects created in the core project (preferably VIEW to reduce space/redundencies) in entire new project (same server/database)My approach was creating a new project, add MDW datawarehouse and then utilize External SQL Connection to connect to the same DWH (transfer type connection). I've also created a seperate database schema with valid behaivor. The problem we ran in was that designated table was the same as similar table in the daatab

3
JTreadwell
Community Manager
3 years ago
R
Starter
r.rajStarter
asked in Legacy & Upgrades

Oracle connector with Oracle materialized view

Hi Team, Is it posible from TX Oracle connector to export data to a materialized view in Oracle instead of a table ?

2
R
Starter
3 years ago
R
Explorer
rnistalaExplorer
asked in Legacy & Upgrades

How to identify modified objects using TimeXtender repository

Hi , We have a need to identify the objects modified in last few days to deploy as part of differential deployment to various environments. To do this, we were looking at DiscoveryHub metadata database, which contains various tables like DataTables, DataColumns, Transformations etc.  However, to identify the delta, we have two columns ValidFrom and ValidTo which are stored as integers. We need a way to identify the data, either by converting these to dates or based on a range of dates. Please help

9
JTreadwell
Community Manager
3 years ago
G
Starter
glaymonStarter
asked in Interoperability with other Platforms & Tools

Seeking Best Approach to Add a Counter to a Table That Resets Based on Another Field

I have a table and I need to have a counter that restarts based on another field on the table. In my case I have a JournalBatchNumber field.  For each new batch, I need to generate a LineNumber restarting with 1 for each record of the same batch. Is this available in TX natively, or do I need to write a post processing script using rownumber ().  Thanks,Greg

2
M
Explorer
3 years ago

Badge winners

  • Certified Solutions Architect
    ParcifalVGhas earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    rasmusgadensgaardhas earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    JensFylkissonhas earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    f_keferhas earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    kerry_bespokehas earned the badge Certified Solutions Architect
Show all badges
Terms and ConditionsCookie settings