Skip to main content
To homepage To homepage

TimeXtender Desktop Q&A

Ask questions and find answers about TimeXtender Data Integration and TimeXtender Classic desktop applications

742 Topics
S
Explorer
svaExplorer
asked in Ingest
Issues Retrieving datetimeoffset Columns with ODBC in TimeXtender

Hello everyone,I'm facing an issue with TimeXtender when trying to retrieve tables containing datetimeoffset columns through the Generic ODBC Data Source connector. The datetimeoffset columns aren’t coming through, and in the ODBC settings, the option to override datetime types is greyed out, which I thought might solve the issue.Has anyone encountered this or found a workaround to retrieve datetimeoffset data through ODBC in TimeXtender?Thanks in advance!

643
rory.smith
TimeXtender Xpert
T
Participant
thzmanParticipant
asked in Prepare
Object reference not set to an instance of an object.

Hi!Getting this error when I try to open the Dev instance. Test and Prod is OK.I could open an earlier version of the project but after I made some changes and tried to save and deploy, I first got a warning that said that this was not the latest version. When I chose to save anyway, I got the same error. Is there some way to “force save” to make this earlier version the latest one and get rid of the error?

651
Thomas Lind
Community Manager
D
Contributor
dsvartzmanContributor
asked in Prepare
Multiple ODX for different enviroments

Hi,I was wondering  if it's possible to use multiple ODX instances for different enviroments (DEV/ACC/PRD).I know that at 20.10 you could only use a single ODX as after multiple enviroment transfer all mapping to ODX would be lost when using multiple ODX instances Is this still the case? Is this issue solved in next-gen?  

10915
D
Contributor
S
Explorer
svaExplorer
asked in Ingest
Issue with Retrieving a Column with the Same Name as a SQL Function

Hi everyone,I'm facing an issue where one of the columns in my destination table has the same name as a SQL function, and because of this, I'm unable to retrieve it in a normal way. To work around this problem, I wanted to use the Query Table Tool to retrieve the column in a parameterized way.However, for this specific data source (which is a Generic ODBC Data Source), the Query Table Tool option is greyed out. I've noticed that the Query Table Tool is available for other data source types.Has anyone encountered this issue before?Thanks in advance!

966
S
Explorer
rory.smith
TimeXtender Xpert
rory.smithTimeXtender Xpert
asked in Deliver
What security options are supported for Deliver REST endpoints

Hi,which kinds of security are available for REST Endpoints and how should they be implemented? Can you directly use row-level security in the Deliver instance? 

401
Christian Hauggaard
Community Manager
D
Contributor
dennishanssenContributor
asked in Ingest
Error when filtering columns BC Online

Using the TimeXtender Dynamics 365 Business Central - Online connector, I'm having trouble filtering columns in the ODX. With all columns selected everything is fine, but once I make a selection in columns I get the error below when running the Transfer Task. Any ideas on why this is happening and how to fix it? (TX Version 6XXX) Executing table customer:failed with error:Exception Type: System.InvalidOperationExceptionMessage: Sequence contains no matching element             Stack Trace: at System.Linq.Enumerable.First[TSource](IEnumerable`1 source, Func`2 predicate)                          at TimeXtender.ODX.Account.BC365CustomDataSource.ExecutionHelper.GetIncrementalLoadPartitionSetups(AccountBC365CustomDataSource accountBC365CustomDataSource, TableModel tableModel)                          at TimeXtender.ODX.Account.BC365CustomDataSource.AccountBC365CustomDataSource.GetIncrementalLoadSetups(TableModel tableModel)                          at DataSourceEngine.Custom.CustomSourceEng

547
D
Contributor
H
Starter
hans.westerhofStarter
asked in Jobs & Executions
TimeXtender API not showing all errors

Hi all,I have a customer that has to deal with an unreliable source system. During transfering specific query tables, it sometimes fails. As there is no retry option on this level, at least we can do right now is to inform the customer that things went wrong.  Unfortunately the TimeXtender API does not tell us there is anything wrong with this run. The “State” is 2, and all the child “JobExecutionLogs” child entries below the job itself all have the “Severity” value of 0. Does someone recognize this situation? Anything we can do differently to inform the customer?

1055
Christian Hauggaard
Community Manager
avanrijn
Contributor
avanrijnContributor
asked in Ingest
Cdata Sharepoint connection Data Model feature

Dear Sir,I am connecting through Cdata to Sharepoint Online.I have hierarchies in my Sharepoint data, I can see them when I connect with PowerBI to my Sharepoint site. Can I use the Data Model feature ‘Flatten Documents’ like you can with JSon connectivity ?It looks like CData for Sharepoint Online doesn't have this capability. Can I somehow bring these ‘hidden fields’ into my TimeXtender  project ?In the attachment (Knipsel.PNG) you can see the hierarchical option in PowerBI with PowerQuery. I miss these fields when I connect with TX Cdata to the same Sharepoint site.Hope you can shine a light on this.Thank you in advance for looking into this case. Regards,Arthur 

452
avanrijn
Contributor
Pontus Olausson
Contributor
Pontus OlaussonContributor
asked in Ingest
Error 'Buffer cannot be null' in ODBC Connection

 Hi,I’m am trying to create a ODBC data source connection in the TimeXtender ODX portal.I have created a ODBC data source on the server on which TimeXtender is run, see picture below. This data source seems to work fine, I am able to test the connection with success and I am able to connect to the database and query the data through PSQL control center on the server.ODBC Data Source on TimeXtender VM In the TimeXtender portal, my configuration is as follows:TimeXtender portal configurationWhen trying to test the connection, I get the error “Buffer cannot be null. Parameter name: buffer”.I have tried adding buffer as an additional property without success.I am unable to find documentation or guidance on how to solve this issue. Since I am able to connect to the database and query the data through PSQL control center on the server on which TimeXtender is run, the ODBC data source on the server seems to be working correctly. It is only through the TimeXtender portal I am unable to use the

11310
Pontus Olausson
Contributor
S
Contributor
sigsolContributor
asked in Ingest
How to use Rolllup task

Hello Community!When running a rollup task, the resulting rollup file ends up in a separate folder inside the same full load folder: After the rollup, new incremental files continue to appear in the DATA folder and the old incremental files are still there. What have we achieved by doing the rollup? Is the new rollup file being used at all? How can we delete the old incremental files given that the delete Storage Management task only removes entire full load folders and we don’t perform full loads?Currently I don’t understand how we can clean up the many incremental files, both for load performance and storage management.Please note: We cannot rely on doing regular full loads because of the size of the tables.Thanks!TX version: 6745.1Connector: TimeXtender SQL Data Source 21.0.2.1We are using Azure Data Lake and ADF.

1308
Christian Hauggaard
Community Manager
J
Explorer
JorisKammaExplorer
asked in Ingest
Business Central Online Connection Error

I’m trying to connect to Business Central Online using the Time Xtender connector. I’m using a service principal which has an app registration in Azure and I’ve run through all the steps in the BC/TX tutorial.I’m getting the following error message when I try to add the data source. Any ideas what might happen Service request failed: Sequence contains no matching element (System.InvalidOperationException)Details:Service request failed: Sequence contains no matching element (System.InvalidOperationException)Module: TimeXtender.ODX.EngineTimeXtender.ODX.Engine.ODXFaultException   at TimeXtender.ODX.Engine.ODXEngine.SendServiceRequest[C,T](WcfServerSettings serverSettings, Func`3 func)   at TimeXtender.DataManager.AddODXDataSourceWizard_SelectConnectionStep.<>c__DisplayClass11_0.<Validate>b__0()   at TimeXtender.DataManager.ConnectingThread.ExecuteConnectingThread(Object dummy)Service request failed: Sequence contains no matching element (System.InvalidOperationException)Modul

1048
J
Explorer
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Prepare
Buid dependency Graph

This is the first time that I see it: What it is?

411
Christian Hauggaard
Community Manager
R
Participant
Remy Kamphuis | VictaParticipant
asked in Ingest
Error BC365 connection after testing connection

Hi support,Following this ticket I will make one myself to keep things clear. We have set up a Business Central 365 connection, both via OAuth2.0 as service to service authentication. We have succesfully tested the connection with both authentication options. However, when we want to read objects, we receive the error “Invalid response from Business Central retrieving table Field for company”. Full log is added to this ticket as an attachment. We have walked through all steps from the prerequisites guide. Hence, we have a succesful connection. From the other ticket I understand that there are more versions of the Jet Analytics for Business Central extension. It has to be the newest one and I have to keep on trying. In the Extension Marketplace we only find two versions of the Jet Analytics for Business Central extension. The first from Jet Global Data Technologies is not available anymore and they point to the second; the one from insightsoftware. This is the one we have installed; ver

13710
Thomas Lind
Community Manager
Roy V
Problem Solver
Roy VProblem Solver
asked in Prepare
snowflake depoyment message 'skipped - uses unsupported feautures' -> apparantly key stores

I am deploying a project to Snowflake and see a lof of tables are skipped.Then we get the messages below (as an example) Apparantly the tales are skipped as key stores / supernatural keys  are not supported .Is this a feature to become available on short notice as our entire datawarehouse uses these?Besides that, is there a way I can see what any other unsupported feautures we have?

525
Roy V
Problem Solver
T
Participant
thzmanParticipant
asked in Ingest
TimeXtender REST dynamic values - error on Sync

Hi!I’m doing some tests and trying to set up som e form of incremental load with this connector to an API endpoint. It works fine with the two static parameters but as soon as I add the parameter for lastSynchronizedRowVersion with its dynamic value I get an error with I run the Synchronize job.Is there something obvious that I have missed here?I tried to follow the article Connect to Fixer IO with the TimeXtender REST data source | CommunitySetup for the endpoint: Error message: 

562
T
Participant
H
Starter
HansZZVStarter
asked in Ingest
Error when opening project on TX version 20.10.51.64

Hello,when i try to open my project on my development server i get the below message; Details:Error loading steps for execution package Refresh PowerBI - PModule: timeXtenderSystem.Exception   at TimeXtender.DataManager.ExecutionPackage.LoadSteps(HashSet`1 projectSteps)   at TimeXtender.DataManager.Project.LoadExecutionpackages(List`1 listToUpdateWhenAllIsLoaded)   at TimeXtender.DataManager.Project.InitProject(Int32 version, DsProject loadDsProject, DataSet adaptersDataSet, ProjectsRow projectRow)   at TimeXtender.DataManager.Project.LoadProject(DsProject _dsProject)   at TimeXtender.DataManager.Project.<>c__DisplayClass136_0.<LoadProject>b__0()   at TimeXtender.DataManager.ConnectingThread.ExecuteConnectingThread(Object dummy) Error loading steps for execution package Refresh PowerBI - PModule: timeXtenderTimeXtender.DataManager.ExceptionWrapperException   at TimeXtender.DataManager.ConnectingThread.HandleError()   at TimeXtender.DataManager.ConnectingThread.Execute(Strin

382
Thomas Lind
Community Manager
P
Contributor
Paul BridgeContributor
asked in Deliver
Redundant Objects Dropped Using the 'SQL Database Cleanup Tool' Reappear

HiI originally set up my semantic layer data models with dynamic RLS, using rules defined in a table in TX, but then switched to using a setup with manual RLS. I then removed the dynamic tables from the semantic layer and preceding data pipelines, but when I redeploy my semantic models the removed security table reappears. Any advice?TX Version: 6745.1

375
rory.smith
TimeXtender Xpert
T
Participant
thzmanParticipant
asked in Ingest
TimeXtender REST data source doesn't update endpoint names

Hi!I have set up a REST connection in my Ingest instance to an API with multiple endpoints. The first time I misspelled two of the endpoint names, which I later changed. Then I noticed that the “old” names are still active in the ODX and does not get updated despite multiple refreshes (see attached screenshot). We have already done some work on some of the endpoints so I’m a bit reluctant to delete the whole connection and set it up again just to get these names updated. Is there some other way to fix this?  

493
T
Participant
B
Contributor
BennyContributor
asked in Ingest
Failed to read metadata from XmlDocument for endpoint X with transformation 'T' Input string was not in a correct format.

The sync of my ODX datasource returns the following error.  The datasource is a REST API endpoint of the form URL/{foreign_ID}, where foreign_id is a dynamic value that comes from a different endpoint within the same data source. The option "Perform exhaustive meta data scan” is enabled. The error returned is this:Failed to read metadata from XmlDocument for endpoint X with transformation 'T'Input string was not in a correct format.There is no further information.  The sync does work when I replace foreign_ID by a fixed value.  The endpoint contains a field that has a lot of values that look like integers, but some values contain letters. Since the above error message is the most verbose info I’ve got, I assumed that's probably the cause. However this conflicts with my understanding of what an “exhaustive meta data scan” should do.  Any help is appreciated. 

1039
Christian Hauggaard
Community Manager
P
Contributor
Paul BridgeContributor
asked in Prepare
Issue with Data Area When Attempting to View Report / Errors

HiI have an issue whereby I get the following message when running the ‘Report / Errors’ menu option in one of my data areas. However, when I click OK I do not get any further information to help me identify the issue. Please advise what I need to do to troubleshoot this further.TimeXtender Data Integration version 6745.1Thanks

10012
daniel
TimeXtender Xpert
kerry_bespoke
Contributor
kerry_bespokeContributor
asked in Jobs & Executions
Notified if Execution Package does not run on Schedule

Good DayIs there a way to be notified when a scheduled Execution Package does not run on the scheduled time?We had a scheduled package not able to run due to a lock on a table but were not aware as there was no error on the job since it was not able to start. Would like to be made aware of these issues instead of having to check each day to see if scheduled jobs ran.Kerry

492
Thomas Lind
Community Manager
daniel
TimeXtender Xpert
danielTimeXtender Xpert
asked in Ingest
Connecting to Azure Active Directory (AAD)

Dear Community,I’m having some issues with connecting to the Azure Active Directory. We want to use this data for RLS and feed this from the DWH.I’ve set up the Active Directory Connector and put in credentials:  After a minute or so I get an timeout. If I leave out the OAuth stuff I get an not authorized. What do I need to set up here to get the data from the AAD? Thanks!

1353
Thomas Lind
Community Manager
daniel
TimeXtender Xpert
danielTimeXtender Xpert
asked in Ingest
JSON connector only get 1st JSON file from Blob

Dear Comunity,I’ve got a blob folder which contains 10 JSON files. I’ve set everything up but it only gets 1 file (the first) from the blob. Also only 1 RSD files get created. Is there something in the connector that needs to change in order for the connector to get more then 1 file? Thanks in advance

461
Christian Hauggaard
Community Manager
F
Contributor
FenchContributor
asked in Prepare
Persistent mapping error message on syncing MDW with ODX

Dear all,When synchronizing the mdw with the odx through right mouse click on the odx and selecting “Synchronize (...)”, the error messages as attached always show up. “Synchronize with Remapping (...)” only leads to complete removal of the field mappings in the subject tables.As there are other ways to sync the mdw with the odx, it’s still possible to work with the subject tables in the mdw. Nevertheless i wonder what causes the error messages and would like to eliminate them along with the risk of having to redo all work on the tables in a later stage.

894
F
Contributor
L
Visitor
lmeadVisitor
asked in Jobs & Executions
Pass Table Name Parameter to a Script Action

I have a generic stored procedure that does some custom post processing based on the table that has just been reloaded (Executed).  The stored procedure takes a parameter "TableName".  I've created a Script Action that executes the stored procedure.  I need this Script Action to run as a Post Step after the last execution step is run for one of several tables.  I can create one script action per table with the tablename hardcoded, but I've got a lot of tables to work with and would really prefer do this as a parameter containing the current table name.  Is the currently executing table name available in a system parameter somewhere and/or is there a way to create one that can be referenced by a script action?

904
M
Starter

Badge winners

Show all badges
Terms and ConditionsCookie settings