General

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

Hi,Is there a way to view the data lineage for tables populated using the Custom Table Insert method? When we select the “Data Lineage” option for a column in a Custom Table Insert table, it only shows the data lineage with that table as the source, rather than displaying the tables used within the Custom Table Insert itself.I saw that this post had a similar question like mine, but I couldn't find an update about it: data lineage for custom table insert | CommunityThank you in advance!

Hi everyone, we're migrating from onprem to an azure SQL db. (version 6x).What would be the approach to migrate history tables? Can't find much on the forums that fits our usecase.

Hi all,our customer has tables that are SCD2 historized with valid_from and valid_to columns and a “version” column, where 1 is the most recent entry, 2 the next older entry and so on.Is there a possibility to load these tables into TimeXtender, preserve the history (make it useable for TimeXtender) and continue historizing in TimeXtender, so that they can turn off the historization in their source table?

Dear Sir,I am looking for a sql query on my local sql repository to create a list of all my datasources in my projects.I am using v20.10.45.Thanks in advance.Regards,Arthur 

I would like to know what the best way of working is if you have multiple environments (DEV, TST, PRD) with the new version. In the old version you had to open a different project repository that you could set a different color, so you were always aware on what you had open.In the new version all the environments are available in the desktop and a mistake is very easily made on what environment you open. Names are also shared between environments so you never know what DSA you have open.Love to hear some comments on how other customers are working. 

Hi,  Is Acrobat Reader a pre-requisite for ETL Agile scheduler to work? We have a client that has uninstalled Acrobat Reader Pro and now the Excel Macros no longer work.The Acrobat Reader was uninstalled on a client PC/laptop.Thanks & RegardsShahid

Hello,TimeXtender 20.10.40.64.In one of our projects we are adding descriptions to every column in a table and we want to be able to get this data querying the database.However, we can’t find a good place in the repository where the description is stored on a column level and how to effectively exctract this data. Looking at the [TxObjectDescriptions] table in the repository there is a column called Description that is a long string. This string includes the description we added to the field, however it also has alot of other data. On top of this, the string seems to have different structures from case to case and I can’t find a good way to always get the value we need.Does anyone have a good way to get this data or knows if there is data saved in another place in a better format?Thank you,Victor

We are in a process of moving from on-prem to AZUREWhy do i get this error? How do i solve it?The user svc_timextender is local admin and its alreay running ODX. Why cant i start it for TiimeXtender Server Service? 

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!

Hi,I think that XPilot needs to learn to be a little humble, and tell you when it's just making things up.Sometimes what looks like useful info is actually just crap.Otherwise, the risk is that you stop using it.BRAnders

Hi team,I’m facing the following issue when Multiple Text File connector to pull in *.TXT files. I’m getting the following error “Index was outside the bounds of the array” when i execute table in the ODX.    

Hello, I’ve got a customer who asking me this question related to the activation of TX (v. 20.10) .The TX developers use the TX desktop through a Virtual Desktop interface (VmWare horizon). For any reason the IT department has decided to rebuilt (full reinstall)  all VDI servers at least one a week.  Despite I provide the activation file (.lic) they didn’t succeed to automate the TX Desktop license activation and ask me if there is another way to activate the software. My answer was that the only way to get this TX desktop unlocking is to migrate to new version with the cloud repo that will unlock the Desktop when opening the project.Could you confirm there is no alternative for the legacy version regarding the activation? Maybe possible to set at least the license key is a config file then pref-filled in Desktop and  the TX developers jsut need to press activate (assuming requried ports is open to reach the TX license server.?Thx for your helpMichael  

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?

Hello to all the community!😃When I make any change to any table and run deploy and execute, at the end of the procedure, I find he table with very little data compared to what should be present (example out of 90.000 records it loads only 4.100). I tried to check the various settings but I don't see anything wrong, can you give me some advice? TimeXtender vers. 20.10.32.64 Thank you in advance

After saving a version of timextender, probably we where two person who incidentally did it at the same time, we run into "out of bounds index/array".Now we can’t open the latest version and when trying to deploy an earlier version we get the “out of bounds index/array” anyway.The environment is all in azure so we have the repository database accessible.Would it be possible to just restore the database to a point in time before we hade the incident.I talked with a colleague and he recommended using this community for advise. 

I recently had a project get corrupted, and I had to revert back to a prior version.  When I did this, it appears as though some aspect of the metadata got scrambled.  When I open the project, all of the tables and other objects show up.  But when I go to deploy any table, regardless of red/black state, the database throws an error "There is already an object named <mytable> in the database."  It is as though TX is sending a CREATE statement instead of an ALTER.  I can manually delete the table(s) and related function to make this error go away for my one table, but I have hundreds of tables, some of which have many months of history.   All of my tables show up in the treeview controls, however when I use the SQL Database Cleanup Tool, none are listed in "Current Project Objects".  They are all listed in "Unknown Project".  Is there any way to recover from this without having to drop all tables and deploy/execute?

hi, I’d like to have the option to extract the credit usage from our portal per month through an API or another endpoint. Are there any possibilities?This will help me monitor the environment and usage across multiple developers.

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

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

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

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

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?

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.

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?