Legacy & Upgrades

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?    

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 it possible to execute a package from the command line of TX Remote Control?

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.    

Thanks in advance for any help.We had a dev deploy but not execute a table before he left for the day. Someone else loaded the table and when he closed the project, no one else could get in. Imported a day-old backup, was able to reload all of the tables. Started working on creating some new dimension and when tried to sync to the source system (Epic Clarity) SQL Server database, got the above error. Full message below: Object reference not set to an instance of an object. Module: timeXtender System.NullReferenceException    at TimeXtender.DataManager.BulkedInformationSchema.ReadSchema(Guid datasourceId, String overrideSql, Boolean deleteExistingRecords)    at TimeXtender.DataManager.DataSource.BulkTransferADO(Boolean readForeignKeys)    at TimeXtender.DataManager.DataSource.RefreshInformationSchema()    at TimeXtender.DataManager.ReadDataSourceObjectsCommand.<>c__DisplayClass6_0.<ExecuteCommand>b__0()    at TimeXtender.DataManager.ConnectingThread.ExecuteConnectingThread(O

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

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

When setting up the global database for the DWH, I get this error:"Databricks direct write requires SQL Server Authentication"However, my environment properties  are straightforward and I can't find anything "databricks" related in the settings.It's a recent (2019) version.Anyone knows what this error could allude to?

what is the right scenario for using single quotes to wrap project variables?  Let's say i have a data constraint added to a field and i am using a dynamic project variable like, soin this scenario, i am comparing a data to another date, and i have the variable encased in single quotes.I always assumed the single quotes was how Discovery Hub "renders" the underlying variable, but i recently found that my assumption was untrue. is the single quotes only to be used when evaluating a character string? or are there some rules to apply wrapping in single quotes. Note: the variable above is a dynamic -> select max({datefield}) from {table} statement, under the covers. 

We are providing clients with a preconfigured data warehouse for an ERP system.  We will continue to make enhancements and improvements.The client will eventually add additional fields and user defined fields for their own needs.What's the easiest way to merge in our improvements to the changes they have already made to an older version?

Hi,to configure the multiple environment setup I used the PDF (https://legacysupport.timextender.com/hc/en-us/articles/360001136526-How-to-configure-Multiple-Environments) , and everything works well when all the firewalls are turned off.We have opened port 10001 and 5001, but when the firewall is turned on, my DEV environment can't connect with the Production environment.My setup now is a Development server and a Production server.When I want to connect from Development to Production, I see the servers negotiating on port 10001 and 5001. But after that, they continue to work with a port in the 64xxx range (examples: 64135,64177,64281 etc) e.g. a random port.My firewall won't except this, and I would like to know if it is possible to work with a standard range / port so we can configure our firewall accordingly.Kind regards,Rogier

Hi, In my scenario, I rely on a stored-procedure in the source (external) database to create the table which will be used in TX. The stored-procedure might have various table/view/functions dependencies. Is it possible to import stored procedure/scalar functions into ODX layer? I know it's possible to recreate (internal) stored-procedure, however I have no access to the underline script in the stored-procedureKind regards.Dror

 HiI know it is quite silly but I am not able to be figure out how to convert a measure which is in 4.97 into whole number as 5?  

Just after some advice about whether something is possible.I have developed a data-warehouse that encompasses all products, However due to the nature of the business what I want to do is create two separate cubes, both that only report on a selection of the products, i am trying to avoid extra security roles in Targit which is used to browse the cubes or creating extra SQL tables which i believe would enable me to achieve the result but with more to manage.Is it possible to add a filter to a cube so that it only includes some dimension members?  

Hi,We are trying to read a csv file and truncating some columns because our table would be too large otherwise. Unfortunately deploy and execute fails with this error:"Data conversion failed. The data conversion for column "name" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page."."We are pretty sure it isn't an encoding problem because when we increase the column size ("Length") in "Edit multiple text files"->"Columns" we can read the data just fine so the error must occur because of the truncation.Does anybody know what options we have to use to let TimeXtender know that we are ok with the truncation of the data in the columns?Thanks,David