To homepage To homepage

General

Ask general questions

  • 27 Topics
  • 94 Replies

27 Topics

S
Visitor
SBRajaVisitor
asked in General

Acrobat reader pro

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

1
Christian Hauggaard
Community Manager
30 days ago
V
Participant
VictorParticipant
asked in General

Column/field description repository

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

1
Thomas Lind
Community Manager
2 months ago
A
Contributor
aftabpContributor
asked in General

TimeXtender Server Service could not start

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? 

16
A
Contributor
2 months 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!

6
P
Contributor
3 months ago
anders.e.jonsson
Contributor
anders.e.jonssonContributor
posted in General

XPilot guesses a little too wildly

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

3
rory.smith
TimeXtender Xpert
5 months ago
amartinez
Starter
amartinezStarter
asked in General

Index was outside the bounds of the array

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.    

6
Christian Hauggaard
Community Manager
5 months ago
michael.laenen
Starter
michael.laenenStarter
asked in General

TX Legacy 20.10.xx - Silent activation

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  

3
Christian Hauggaard
Community Manager
5 months ago
bas.hopstaken
TimeXtender Xpert
bas.hopstakenTimeXtender Xpert
asked in 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?

5
bas.hopstaken
TimeXtender Xpert
6 months ago
M
Starter
M.DavideStarter
asked in General

Data loss after Deploy And Execute in DSA

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

7
daniel
TimeXtender Xpert
7 months ago
A
Starter
anders.bengtssonStarter
asked in General

open a project will result in an "out of bounds index/array" error,

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. 

3
Christian Hauggaard
Community Manager
7 months ago
L
Visitor
lmeadVisitor
asked in General

Deployment Error - There is already an object named...

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?

3
Thomas Lind
Community Manager
8 months ago
peter.jensen
TimeXtender Xpert
peter.jensenTimeXtender Xpert
asked in General

Repository cleanup

We're experiencing projects to open very slowly using TX 20.10.38 (we're above version 10000 of the project) Is there an easy way to remove old versions of a project ? We are using multi environment with global databases, and don't want to go through the export, create new repo DB and import hustle.We're also trying to delete the logs, but deleting them from within TX seems to take forever.

8
Thomas Lind
Community Manager
8 months ago
V
Starter
VictorVinkStarter
asked in General

Extracting credit usage from portal through api

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.

1
Thomas Lind
Community Manager
9 months 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
11 months 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 year 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
1 year 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
1 year 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
1 year 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
1 year 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
1 year ago
D
Contributor
dsvartzmanContributor
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
Employee
4 years ago
M
Visitor
manuelsobhan.selwinponpandianVisitor
asked in General

Not able to windows resize

Is there way to adjust the window widh according to the screen size. It is not getting resize.

1
S
Contributor
4 years ago
M
Starter
malose.motlhasediStarter
asked in General

Incorrect syntax near the keyword 'SET'.

Morning guys,Hope you can help. I am getting this error and not sure what is causing that. I have attached the screenshot of the error. I have an insert statement which run the query shown and been trying to see what can I be doing wrong.  

2
Thomas Lind
Community Manager
3 years ago
L
Visitor
lschlaepferVisitor
asked in General

ODX Server Notifications on Critical Errors

I am unable to set up my notifications. I get the following error message: I already tried different email addresses (gmail, outlook, hotmail) with different ports. I also enabled the option within my mail accounts to allow external programs to make a connection. But it still isn't working. Is this a know issue or am I doing something wrong?

1
Thomas Lind
Community Manager
2 years ago
E
Contributor
ekw9Contributor
asked in General

Legacy Work Items

Hi all,  Our project has work items that have been left by several folks who have since left the company.  Their accounts no longer exist, so we can't log in as their old users and remove them.  Is it possible to remove these work items some other way?

1
JTreadwell
Employee
2 years ago

Badge winners

Show all badges
Terms and ConditionsCookie settings