General Q&A

I am following the TimeXtender Basics course and at a certain point I am asked to create a new Global Database (specifically Datawarehouse) through the following steps:Create Global Database for DSAIn the Tools menu select Environment Properties Click New Global Database Type in DSA in the Name box Select Data Warehouse in the Type drop-down list and click OK Click the settings text box Type localhost in the Server text box Type TX_DSA_DEV in the Catalog text box Right click the settings text box, select Create Database and click OK, when notified of successful creationHowever at step 7. I get stuck as there is no catalog row. Does someone know how to fix this issue? I'm on version 20.10.23.64 

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.

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?

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?

Hello,I tried creating a new TX Dictionary project on our Tableau Server, but I'm running into some problems with opening the Tableau-file and replacing the data source.First of all, the stept to replace the datasource aren't up-to-date anymore with the new Tableau Desktop versions. In the new versions you have to open the new datasource before you can replace it. Not a big problem, just a mention so you can possibly change this.The problems come when I replaced the datasource. All sheets are empty and a few fields keep giving an error. The error states that the field doesn't exist in the database.I'll assume the missing fields are the reason for the empty sheets, as you can see here below:Can you help me with this problem?Kind regards,Damien van Kan

We currently execute an SSIS package via Execute External SSIS Package.  We want to start using SSIS environments to better manage dev/prod values and passwords.  The problem with the Execute External SSIS Package is that we are not able to call the SSIS package using an SSIS Environment.  To get around this, we created a Script Action that executes the SSIS package with an SSIS Environment, and then set this script action as a Post Script on a table that is executed in our Execution Package.  The problem I am facing is that calling the SSIS package in this manor calls it asynchronously.  Is there a way to synchronously call an SSIS package with an SSIS Environment?

HiI am connecting to a SQL database.I can browse the database through SSMS and i can "Test connection" successfully.The problem is that i cannot read objects from the database. I get the following error:If you need assistance, please submit this with your ticket.Undetermined SQL Server version during read of source schemaLocation: Business Unit 'test', Data Source 'test'.Details:Undetermined SQL Server version during read of source schemaModule: timeXtenderSystem.Exceptionat TimeXtender.DataManager.DataSource_Sql.get_IQuery()at TimeXtender.DataManager.SSISEngineBase`1.CreatePackage_InformationSchema(IInformationSchemaProvider informationSchemaProvider, IDataSource_Sql dataSourceSql, ReadInformationSchemaType readInformationSchemaType, Guid sourceId, Boolean deleteExistingRecords, String queryOverride)at TimeXtender.DataManager.DataSource.RefreshInformationSchema()at TimeXtender.DataManager.ReadDataSourceObjectsCommand.Read()at TimeXtender.DataManager.ReadDataSourceObjectsCommand.<&g

Hello guys, i need some help Our environments data are outdated. When we check that the services of Timextender both in Stopped condition As far as i know, the 'Timextender Server' service should be able to start/running.But when i try to run it (both in WServiceTools in TX or in Windows Service apps service) but it just start and stopped it said error 1788 (As on attachment) the account that being used is LocalSystem which is the System Account. I've tried as support.timextender article told but no luck Can somebody give me help whats the problem ?

Afternoon, I am getting this strange error when I run the Cubes on TimeExtender. There were patches that were applied to the server over the weekend where TX is running from. I am not sure if that could be the cause. Please find the attached Error screen.  

There is no zoom in/out option in the version 20.5.8.64. Is it available in the latest releases of TX?    

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.  

Now every time when I deploy my project in environment development, I need to  deploy this project in environment production too. Event I don't want transfer my development project to production. If not, When executing projects on a schedule, the execution finishes without error, but tables end up empty. I don't know because I changed version (version 20.10.2.64)  or I have configured something wrong, in last year I didn't have this issue.

Hi Can anyone please help me as I am struggling to increase the font size of TX window, it is too hard to read table names

I just tried the TXDictionary project from CubeStore and managed to deploy the ODX (Business Unit) but when I start execution I get the following error:Invalid object name 'etl.ExecutionPackageLogs_I'.Running TX 20.10.1.64

Did anyone have a data dictionary that has been pulled from timextender system database. The ideal one I am looking at is either a search option on a html where you can look for a table with all the columns, descriptions and data mapping(source).  Or if anyone did similar one on an excel document will equally help me. 

where the mappings saved in timextender?? Is there any chance to store the Mapping details in SQL Server?

hi since this morning I get the message displayed in title. It is an Azure environment, TimeXtender was working on Friday, nothing changed on the license key... Any idea where to find/how to solve this issue??? thanks in advance Mrt

I have a separate Test and Production environment. Currently each environment has its own ODX database. But some cloud API source systems charge euros for loading records through an API connection. I’m therefor checking how I can limit the data transaction on the source systems. Also we only use production data in Pest and Production. Since we use Azure I don't want to load all the production data twice. One way is to use 1 shared ODX for both Test and Production. Then I only have to load the source data ones. I can think of the following options: 1. Use the ODX server I've tested the ODX server but I can't use historic tables and incremental loads don't work on most API connections. I also encountered limitations on a firebird SQL data source. So the ODX server doesn't seem like a workable solution 2. Use an external ODX business unit A external business unit works. But how can I use a single external ODX for both Test and Production as these environments run on different project repo

I have a question about multi environments and transferring.   In addition to production, we have set up a development and test environment in TimeXtender with separate databases. This all works great. However, we want to work with a limited set of data in the development environment. We don't want to constantly have to wait for an execution in the development environment. We also do not want the test and development environment to fill up the hard disk too much. Now the question: is it possible to use a filter (for example load all data from last 30 days) in the development environment (in stead of incremental load) and to continue to use it incrementally load in the test and production environment? The filter should not overwrite the incremental setting during a transfer! So we want transferring data from different environments with different load settings.

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

We are currently using TX to stage and merge multiple source systems to create a master list of items, customers, vendors, Open AR. Open AP, etc.  Currently, we are using the Data Export on the Semantic Layer to dump out entity data so that it can then be read in by D365 as delimited text files.  I am wondering if anybody knows if there is a way to direct connect to D365 so that TX serves as a source to a D365 system? Thanks, Greg  Laymon

  Due to cost of servers, it would be beneficial to have both a developer and a production on the same server. Is this possible right now? The manual doesn't explicitly mention this. If it is possible to run both environments on the same server, do they need different SQL server instances or can they use the same instance?     

Is it possible to execute a package from the command line of TX Remote Control?

I am trying to replicate some code from SQL, and need to create a custom table insert... my SQL query uses a temp table #ELL.  When I try to deploy & execute, it does not understand the temp table.  Can temp tables be used here?  IE. #ELL.. I just need to have it hold some info that later in the query will populate the new custom table in TimeXtender.

I know you can lock a project from editing, but is there a way to password protect a project we install on a client's server so they can't view how we built it?  We've spent hundreds of hours building an ERP integration that we want to sell multiple times and don't want a client or competitor to simply rebuild it by exporting, or just looking at the project design and mimicking it.