Skip to main content

Jobs & Executions

-

  • 41 Topics
  • 92 Replies
41 Topics
E
eric.vangemertNew Participant
asked in Jobs & Executions
Logging around setting "when transfer fails".

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?

06
T
P
per.schefferNew Participant
asked in Jobs & Executions
Must declare the scalar variable "@batchFirstId"

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 asyncWrite) at

00
P
P
p.ruijterNew Participant
asked in Jobs & Executions
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.

110
J
H
huub.thuijlsNew Participant
asked in Jobs & Executions
Missing objects when executing a package after transfer and full managed deployment

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.SqlClient.SqlException at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsPars

02
J
T
t.daoNew Participant
asked in Jobs & Executions
executing a package from the command line of TX Remote Control

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

05
T
T
tejasgNew Participant
asked in Jobs & Executions
How to schedule deployment from Development server to Integrated server

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.

11
S
R
r.rajNew Participant
asked in Jobs & Executions
Oracle connector with Oracle materialized view

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

02
R
R
r.rajNew Participant
asked in Jobs & Executions
TX- ORacle connector issue

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.

03
J
R
r.rajNew Participant
asked in Jobs & Executions
Pass project parameters at run time

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.

02
R
M
mchinskyParticipating Frequently
asked in Jobs & Executions
Trying to Understand Incremental Performance

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.

02
E
P
Picanova BINew Participant
asked in Jobs & Executions
Transfer Error - Invalid column name - Incremental Execution MDW

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

01
J
H
hgrParticipating Frequently
asked in Jobs & Executions
Manually reloading recent data

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.

03
J
H
hgrParticipating Frequently
asked in Jobs & Executions
Incremental Load not Delivering Data

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 connecting

01
H
R
rluytenNew Participant
asked in Jobs & Executions
Execution blocking access to cubes

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

03
E
B
birkirNew Participant
asked in Jobs & Executions
Change data management or incremental loading with changing data

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

04
R
K
kgtsNew Participant
asked in Jobs & Executions
Changing environment properties

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!

11
J

Badge winners

Show all badges
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept or continue browsing you agree to our cookie policy. Learn more about our cookies.

 
Cookie settings