Skip to main content

General Q&A

Ask general questions

110 Topics
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
Employee
5 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
Employee
4 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
4 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
Employee
3 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
3 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
3 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
3 years 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
3 years 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
3 years 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
1 year ago

Badge winners

  • Certified Solutions Architect
    gfredheihas earned the badge Certified Solutions Architect
  • Innovator
    Bennyhas earned the badge Innovator
  • Certified Solutions Architect
    Roy Vhas earned the badge Certified Solutions Architect
  • ODX Expert
    ignaciohas earned the badge ODX Expert
  • TimeXtender Xpert
    danielhas earned the badge TimeXtender Xpert
Show all badges
Terms and ConditionsCookie settings