Jobs & Executions

We started to use the configuration continue without data in case a transfer fails. The feature works fine, and we also see the message that one or more datasources fail. My question is, how can we easily see which datasources failed, and with what error message?  

When I do Deploy and Execute on my fact table, I get the following exception: Must declare the scalar variable "@batchFirstId".Details:SQL Server: 'abea5b3595a5-0.tr624.northeurope1-a.worker.database.windows.net,11014'SQL Procedure: ''SQL Line Number: 1SQL Error Number: 137Must declare the scalar variable "@batchFirstId".Module: .Net SqlClient Data ProviderSystem.Data.SqlClient.SqlException at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asy

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.

I get the followinf error after transferring the latest version van OT to A environment and full managed deployment: Finished executing project 'RobidusDWH' Execution Package 'Laden ACC' Execution failed Start Time : 4/3/2020 7:16:52 AM End Time : 4/3/2020 7:25:01 AM on server: WIN6682 -Execute Execution Package Laden ACC 'Failed'                Invalid object name 'HDA_V_DMA.DM_HDA_HDA_V_DMA_Feit_OpenstaandeTaken_DMA_DMA_Feit_OpenstaandeTaken_T'.                               Details:                               SQL Server: 'cf15a5af617c.tr6225.westeurope1-a.worker.database.windows.net,11009'                SQL Procedure: 'DMA_TX.usp_CrDM_DMA_TX_Feit_OpenstaandeTaken_HDA_HDA_V_DMA_Feit_OpenstaandeTaken'                SQL Line Number: 12                SQL Error Number: 208                               Invalid object name 'HDA_V_DMA.DM_HDA_HDA_V_DMA_Feit_OpenstaandeTaken_DMA_DMA_Feit_OpenstaandeTaken_T'.                Module: .Net SqlClient Data Provider                System.Data

Is it possible to execute a package from the command line of TX Remote Control?

Hi, I am trying to find out how i can schedule deployment from development server to integration server at a particular time on everyday. So, whatever changes I am making in the development will be deployed automatically to integration server. Please let me know in case any one has idea regarding the same. For clarification please ask.

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

The TX oracle connector drops and creates the complete table during export. Is there a way that we can control this behaviour and the table be not dropped ? This is because we need to move data from Staging Orcle to Main tables based on Triggers and if the table is dropped by TX then the trigger is of no use.

Can you pass project variable values at run time via the command line? We need to trigger the package and pass on user defined variable values that has been used in the package creation. Like a date that a user can pass whenever he intends to run a package.

So based on what I'm reading about TX, it seems to me that even if only say 5 records changed on a source file, TX loads the entire source table into a Raw table (all 40 gigs of it) and then finds the 5 records.   Is there a way to get it to just pull the 5 changed records into TX?  My incremental executions seem to take about 50% of the time of a full execution even though there is little to no data change.      

Hello, one of several incremental tables won't execute. upon execution the transfer fails stating "invalid column name " & name of the incremental column. The problem occurred in Version 19.2.7.64 and is still present after an upgrade and redeployment to Version 19.11.7.64. What I tried so far. I tried to change the column from Incremntal_date to id. Redeployed the full table configuration. Upgraded to Version 19.11.7.64. Help is much appreciated.   Best regards Peter  

Just for anybody interested: I just found out that you just update the _I table to some older values, to reload all data greater than the value you set. Previously, I always reloaded the full table in these cases. This is not necessary and saves me some time from now on.

Hello, I have the following setup for an incrementally loaded table: I would expect, that it loads all rows, with either an id greater than max id - 1000 or datum_post greater than max datum_post - one week. In fact, when I execute the query, it is not returning any rows. This is interesting, because removing the datum_post condition returns rows. Other tables with such a double condition (id + date) also work. I am wondering, whether it is necessary to have an index on datum_post in the source table? The queries can take quite a while on the datum_post field. The example query takes 2 minutes on the source database, but TimeXtender finishes after 30 seconds. TimeXtender says it is finished with "Success", but there are no rows. Also the following query yields results when querying the source database directly:  I think this is the equivalent query to what TimeXtender should load. I am using Discovery Hub 19.6.7.64 and the source database is using (an old) mysql version:  I am conne

Hello, Since a couple of days I created a second execution package to execute +- 10 tables, some dimension and 1 cube. After this execution the other cubes are not reachable, I need to deploy and execute them all to get it solved. Any clue why an execution pack would block access ? Thanks, Ronny

Hi, I have a source table in Navision which contains inventory data. The data is sometimes changed back in time due to miscellaneous reasons. I have sofar handled this with change tracking in Sql Server and then I do a merge statement that either inserts new data or does an update on older data already in the fact table.  So my question is how could I handle this in TX and do a inceremental load?   Regards Birkir

Hi all I recently changed the environment properties of the development environment to have the AX data source point to the live environment instead of the test environment. I hoped that executing (without deploying) the staging area would refill all staging tables with live data instead of test data (all full loads, no incrementals), but it didn't. In fact, what needs to be done, is deploying by manually marking all tables to be redeployed in the deployment screen, as nothing has changed according to TimeXtender. Is it possible to make the SSIS package connections dynamically looking at the environment properties (this way an execute would suffice)? Or mark the staging tables to be redeployed? TimeXtender version 16.8.1.64; project is using SSIS. Thanks!