- - Knowledge base overview
Product Updates
Training
Portal
For Partners
Legacy

Home
Community overview
General Q&A

General Q&A

Ask general questions

51 Topics

Recently active

Most replies Most views Newest first

alfred.kristinssonStarter

asked in Legacy & Upgrades

I'm encountering a truncation error when synchronizing Dynamic AX Adapter data source in my Business Unit

We have an upgraded MS Dynamics 365 environment, from which we publish to an Azure SQL database. When I attempt to attach an existing project to it to synchronize data source (using a SQL data source connector as the project normally does) I can connect with a test connect, but then after building the selection tree, TimeXtender throws the error “The given value of type String from the data source cannot be converted to type nvarchar of the specified target column. String or binary data would be truncated." Since it isn’t yet part of project execution but rather a TimeXtender comparison operation, I’m somewhat befuddled as to how to proceed. I’m not sure if this belongs in data sources or desktop, so took a guess on placement.

4 days ago

bas.hopstakenParticipant

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?

14 days ago

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.

17 days ago

mikkel.hansenStarter

asked in Legacy & Upgrades

General Database for multiple TextFiles

Hi.I want to create a global Data Source Database for a multiple Text File import. But there seems to be no available type?Do i just use the single text file option?

17 days ago

mirjam.bleuminkStarter

asked in Legacy & Upgrades

Schedule job stops executing

Once in a while my scheduled job does not finish without an error. It just stops doing anything.My event log states that around the time my job stopped running, both the server and the scheduler started.I do not find anything in the logs where it says the server and scheduler stopped running, so I have no idea why they restarted.Would the server/scheduler being down explain why the job stops running rather than failing and providing an error?Does anybody experience the same? Any ideas where I can find more information on why the server/scheduler stopped or restarted? And possibly how I can prevent this of course?

17 days ago

brandon.spencerContributor

asked in Legacy & Upgrades

Does anyone have experience switching from ADO.NET to SSIS?

We would like to possibly switch from ADO.NET to SSIS. At the moment, both the TX application (ODX is not being used) and the SQL server are on the same box using ADO.NET. We want to split off TX to its own server and use SSIS instead of ADO.NET. Has anybody done this and can share the high level steps? Or even how you think it might be best accomplished? Specifically, once the application server is up and running with all the pertinent software, how would one make this transition?

6 months ago

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?

5 months ago

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 years ago

rnistalaExplorer

asked in Legacy & Upgrades

How to identify modified objects using TimeXtender repository

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

2 years ago

greg.laymonStarter

asked in Interoperability with other Platforms & Tools

Seeking Best Approach to Add a Counter to a Table That Resets Based on Another Field

I have a table and I need to have a counter that restarts based on another field on the table. In my case I have a JournalBatchNumber field. For each new batch, I need to generate a LineNumber restarting with 1 for each record of the same batch. Is this available in TX natively, or do I need to write a post processing script using rownumber (). Thanks,Greg

2 years ago

joeoatesVisitor

asked in Legacy & Upgrades

Reconnecting to a source getting "Object reference not set to an instance of an object" error

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

2 years ago

purnima.ozaStarter

asked in Interoperability with other Platforms & Tools

Can you use temp tables (sql - #tablename) in custom table insert SQL queries? This is for a custom insert table.

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.

2 years ago

mchinskyExplorer

asked in Legacy & Upgrades

Can you protect your project from piracy?

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.

2 years ago

niclas.lofbladStarter

asked in Infrastructure & Networking

Multiple environments on same SQL-server?

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?

2 years ago

greg.laymonStarter

asked in Interoperability with other Platforms & Tools

Using TX as a source to Dynamics 365

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

2 years ago

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.

2 years ago

p.ruijterStarter

asked in Legacy & Upgrades

Multiple environments, different load settings

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.

2 years ago

coen.dondersStarter

asked in Legacy & Upgrades

How to create one central ODX fot both Test and Production environment

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

2 years ago

mark.ferrisStarter

asked in Legacy & Upgrades

Use tables from one project in another project (from the same database)

We have multiple TimeXtender projects that use the same databases for their ODX/DSA/MDWs. What is the best way to use tables from one project in another one of the other projects? "Add External SQL Connection" seems to be an option, should this still be used if the table we want to connect to is in the same database?

2 years ago

maarten.vanheurStarter

asked in Legacy & Upgrades

subscription license activation failed with following reason: access to codeletter.xml is denied.

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

2 years ago

pchanduStarter

asked in Legacy & Upgrades

Mapping Saving

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

2 years ago

hongwei.panStarter

asked in Legacy & Upgrades

Issue: after deploy project in development environment, Data missing on scheduled execution with no errors in production environment

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.

1 year ago

Page 1 / 3

Badge winners

Stefanhas earned the badge Certified Solutions Architect
Trine Stuhrhas earned the badge Certified Solutions Architect
Christian Hauggaardhas earned the badge Data Warehouse Expert
rvgfoxhas earned the badge Innovator
cbutcherhas earned the badge Certified Solutions Architect

Show all badges

Terms and Conditions Cookie settings

Sign up

Already have an account? Login

Login with SSO

SSO login

Username *

E-mail address *

Full Name

(Private)

Only you and moderators can see this information

TX Partner / Customer *

Company

(Private)

Only you and moderators can see this information

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Login with SSO

SSO login

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.