To homepage To homepage

General

Ask general questions

  • 20 Topics
  • 56 Replies

20 Topics

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
6 days 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
19 days 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
1 month 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
1 month 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
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!

3
Christian Hauggaard
Community Manager
4 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
4 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
5 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
6 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
7 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
8 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
8 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
1 year 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
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
3 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
2 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
Starter
ekw9Starter
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
Community Manager
2 years ago
H
Starter
hparwaniStarter
asked in General

Configuring ODX Service Account

Hi,I've been trying to configure the ODX server properly in order tot est TX and complete the course, but I'm having some difficulty.I've downloaded both ODX and TX, I have activated them with the key and client secret; I've made a new local user in the Admin group called TX Service; I've given this user sysadmin rights in the newly created database TX_project_repository.Now if I try to load data on this screen, it fails:With the following error in the log:Seems like it cannot access the database.The service is also not functioning, trying to jumpstart the scheduler manually gives this error:Please advise me on this issue.

7
S
Contributor
1 year ago
W
Contributor
WimContributor
asked in General

SQL 2016: worth the upgrade?

Hello fellow TimeXtender users, We were wondering: is it worth upgrading from SQL 2014 to 2016 in the scenario where we use TX traditionally: stage - dw - cubes. Has anyone done it and have you seen performance improvements? Thanks! Wim CALM - Co

5
T
Explorer
6 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