To homepage To homepage

Legacy & Upgrades

Ask questions about legacy TimeXtender products and upgrading

  • 40 Topics
  • 140 Replies

40 Topics

D
Starter
david.kesselheimStarter
asked in Legacy & Upgrades

Truncation SSIS error

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

1
JTreadwell
Community Manager
5 years ago
M
Visitor
martin.oloughlinVisitor
asked in Legacy & Upgrades

cube filtering

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?  

1
J
Contributor
5 years ago
J
Starter
jyothi.dosiStarter
asked in Legacy & Upgrades

Convert decimal to whole number (Cube measure)

 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?  

1
T
Starter
4 years ago
R
Visitor
rogier.heerkensVisitor
asked in Legacy & Upgrades

Firewall settings

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

2
W
Contributor
4 years ago
J
Starter
jyothi.dosiStarter
asked in Legacy & Upgrades

How to increase font size of TX window

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

4
Thomas Hjermitslev
Community Manager
2 years ago
M
Explorer
mchinskyExplorer
asked in Legacy & Upgrades

Merge projects

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?

3
JTreadwell
Community Manager
3 years ago
J
Starter
jnortonStarter
asked in Legacy & Upgrades

when to use single quotes in Project Variables

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. 

1
JTreadwell
Community Manager
3 years ago
J
Starter
janStarter
asked in Legacy & Upgrades

Error setting up Multiple Environment Deployment

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?

3
J
Starter
3 years ago
P
Starter
p.laadStarter
asked in Legacy & Upgrades

No Zoom functionality version 20.5.8.64

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

1
JTreadwell
Community Manager
2 years ago
M
Starter
malose.motlhasediStarter
asked in Legacy & Upgrades

Class not registered

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.  

1
Thomas Lind
Community Manager
2 years ago
A
Explorer
ajiExplorer
asked in Legacy & Upgrades

Services Cannot Start ERROR 1788

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 ?

6
thagin
Employee
2 years ago
M
Starter
morten-sStarter
asked in Legacy & Upgrades

Cannot read objects from SQL server - Undetermined SQL Server version during read of source schema

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

8
M
Starter
1 year ago
D
Contributor
dan.beggsContributor
asked in Legacy & Upgrades

Executing SSIS package

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?

1
D
Contributor
1 year ago
D
Visitor
d.van.kanVisitor
asked in Legacy & Upgrades

TX Dictionary Tableau errors

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

1
Thomas Lind
Community Manager
1 year ago
D
Starter
dror.svartzmanStarter
asked in Legacy & Upgrades

Import SQL Stored-procedures/ function into ODX

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

3
D
Starter
3 months ago

Badge winners

  • Data Warehouse Expert
    fwagnerhas earned the badge Data Warehouse Expert
  • Data Warehouse Expert
    rory.smithhas earned the badge Data Warehouse Expert
  • Certified Solutions Architect
    DylanW.has earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    KaiMuellerhas earned the badge Certified Solutions Architect
  • Innovator
    devin.tiemenshas earned the badge Innovator
Show all badges
Terms and ConditionsCookie settings