Skip to main content

General

-

  • 32 Topics
  • 79 Replies
32 Topics
H
huub.thuijlsNew Participant
asked in General
Datatype Project 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?

01
R
A
alexander.hauensteinNew Participant
asked in General
Location of Errors and Warnings Messages

Dear CommunityIf I'm clicking on Report->Errors or Warnings then I see a fulll list of them. Where are those records stored? In which table can I find them ? My problem is that once forgot to check the "Error" manually, therefore I want to create a script which regularly should check if errors exists. But wo far, I couldn't the table/view/place where this Infos are stored. Any ideas?   Regards Alex

01
J
S
satish.padarthiKnown Participant
asked in General
TRIM/RTRIM/LTRIM

Did anyone notice that these functions doesnt work directly on a field. I always has to create a new one to use trim function on the original filed. Is this a bug ? Its getting ugly to use additional fields when I have a table which needs TRIM on each and every field.

111
J
L
larsingvar.nilssonNew Participant
asked in General
Invalid column name when transfer from uneven sources

Hi all, I have not been able to find any similar posts. My problem is that I stumble over an execution error when trying to map two different sources with identical columns, except one, that only exist in one source. I except data from one of the sources into the column and expect Null from the other on the lines originating from the other. But however Timextender throws error "Invalid column name 'XXXXX' " on the column at execution. Have tried full deploy. Only if I remove the XXXXX column it will execute. Any ideas?

02
S
C
cwatkinsNew Participant
asked in General
TimeXtender Server Can't Start After Upgrade

I just upgraded from Discovery Hub 20.1.6.64 to TimeXtender 20.10.26.64and upgraded the repository. Everything works well with the deploy and execute, but when I try to restart the service, I get an error in the event log. Service cannot be started. System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 Could someone please assist?

33
J
C
cwatkinsNew Participant
asked in General
TimeXtender Project Load Times

Good afternoon, When I transfer my project from our DEV to PROD environment, it takes over 25 minutes. I also have the same problem when opening the project from PROD to deploy and execute changes.  Is there anything I can do in order to make these times more manageable? Thanks, Chuck

01
S
S
sierd.zuiderveldNew Participant
asked in General
Global Database Catalog missing

I am following the TimeXtender Basics course and at a certain point I am asked to create a new Global Database (specifically Datawarehouse) through the following steps: Create Global Database for DSA In the Tools menu select Environment Properties Click New Global Database Type in DSA in the Name box Select Data Warehouse in the Type drop-down list and click OK Click the settings text box Type localhost in the Server text box Type TX_DSA_DEV in the Catalog text box Right click the settings text box, select Create Database and click OK, when notified of successful creation However at step 7. I get stuck as there is no catalog row. Does someone know how to fix this issue? I'm on version 20.10.23.64  

01
S
H
hparwaniNew Participant
asked in General
Configuring ODX Service Account

Hi, I've been trying to configure the ODX server properly in order tot est TX and complete the course, but I'm having some difficulty. I've downloaded both ODX and TX, I have activated them with the key and client secret; I've made a new local user in the Admin group called TX Service; I've given this user sysadmin rights in the newly created database TX_project_repository. Now if I try to load data on this screen, it fails: With the following error in the log: Seems like it cannot access the database. The service is also not functioning, trying to jumpstart the scheduler manually gives this error: Please advise me on this issue.

07
S
L
lmeadNew Participant
asked in General
Deployment Error - There is already an object named...

I recently had a project get corrupted, and I had to revert back to a prior version.  When I did this, it appears as though some aspect of the metadata got scrambled.  When I open the project, all of the tables and other objects show up.  But when I go to deploy any table, regardless of red/black state, the database throws an error "There is already an object named <mytable> in the database."  It is as though TX is sending a CREATE statement instead of an ALTER.  I can manually delete the table(s) and related function to make this error go away for my one table, but I have hundreds of tables, some of which have many months of history.   All of my tables show up in the treeview controls, however when I use the SQL Database Cleanup Tool, none are listed in "Current Project Objects".  They are all listed in "Unknown Project".  Is there any way to recover from this without having to drop all tables and deploy/execute?

01
S
T
theenemanNew Participant
asked in General
Error when deploying tabular model - "This row has been removed"

Hi all, When deploying our tabular model/endpoint (Azure Analysis Services), we get a strange error: "This row has been removed from a table and does not have any data. BeginEdit() will allow creation of new data in this row".   In the error message we don't see which table or row this relates to and we don't know if this error relates to a datawarehouse table or a repository table. All our datawarehouse tables in this tabular model contain data and 'look good'. In addition, this error occurs in one of our environments and not in the other environments.    Has anyone experience with this error? Any thought on how we can debug this one?   Thanks.

03
T
E
ekw9New Participant
asked in General
Legacy Work Items

Hi all,  Our project has work items that have been left by several folks who have since left the company.  Their accounts no longer exist, so we can't log in as their old users and remove them.  Is it possible to remove these work items some other way?

01
J
L
lschlaepferNew Participant
asked in General
ODX Server Notifications on Critical Errors

I am unable to set up my notifications. I get the following error message:  I already tried different email addresses (gmail, outlook, hotmail) with different ports. I also enabled the option within my mail accounts to allow external programs to make a connection. But it still isn't working. Is this a know issue or am I doing something wrong?

01
T
D
d.van.kanNew Participant
asked in General
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

01
T
A
ajiParticipating Frequently
asked in General
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 ?

06
T
M
malose.motlhasediNew Participant
asked in General
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.  

01
T
P
p.laadNew Participant
asked in General
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?    

01
J
M
malose.motlhasediNew Participant
asked in General
Incorrect syntax near the keyword 'SET'.

Morning guys, Hope you can help. I am getting this error and not sure what is causing that. I have attached the screenshot of the error. I have an insert statement which run the query shown and been trying to see what can I be doing wrong.  

02
T
H
hongwei.panNew Participant
asked in General
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.

03
H
J
jyothi.dosiNew Participant
asked in General
How to increase font size of TX window

Hi Can anyone please help me as I am struggling to increase the font size of TX window, it is too hard to read table names

04
T
P
pchanduNew Participant
asked in General
Mapping Saving

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

04
P
D
dritzNew Participant
asked in General
Maximize Tabular Custom Measure Script Editor Window

It's really annoying that the window can't be maximized or enlarged.I've asked the support for a long time, unfortunately nothing happened. It shouldn't be a big deal to change that?!

00
D
E
eks_guasParticipating Frequently
asked in General
cdata for dynamics 365 for operation not able to refresh.

I am working on a environment with TimExtender and Dynamics 365 for Operation.  First I must clear out ClientSecret and ClientAuthentication key before I can Authorize to d365.  After that i put in those keys and the session is started.  After a while the sessions is closed and I have to Authenticate myself all over again to be able to extract data form d365.   exept from logfiles> 2020-08-13T09.00.37.158+02:00 0 [Connection: 158] Executed connect: Error: AADSTS7000215: Invalid client secret is provided.Trace ID: e4747361-a17c-448d-a5b9-b2d2fadbf800Correlation ID: 3ab329da-2059-4716-8a08-7f20e7835759Timestamp: 2020-08-13 07:00:37Z. 2020-08-13T09.00.37.160+02:00 0 AADSTS7000215: Invalid client secret is provided.Trace ID: e4747361-a17c-448d-a5b9-b2d2fadbf800Correlation ID: 3ab329da-2059-4716-8a08-7f20e7835759Timestamp: 2020-08-13 07:00:37Z. ffo190j.xaat ffo190j.nna.C(ra , String )at ffo190j.nna.q(String , String , String , Boolean , Boolean , Boolean , BmB , BmB , BmB )at ffo190j.nnI

06
E
M
maarten.vanheurNew Participant
asked in General
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

02
M
H
hgrParticipating Frequently
asked in General
Send mails using Google Mail

Hello, Which settings are needed in order to get Google Mail send success and failure emails in TimeXtender?  I tried it with  Servername: smtp.gmail.com Port: 25/465/587 Enable SSL/TLS: Checked Allow invalid certificates: Checked From Email: my.name@gmail.com User name: my.name@gmail.com Password: <my gmail password> To Email: another.email@gmail.com   I get different failure responses:  25: 5.7.0 Authentification required 465: Syntax error, command not recognized 587: 5.7.0 Authentification required   Without SSL/TLS I get: A secure connection is required for the smtp server or the client is not authentificated. Server response was: 5.7.0 Must issue a STARTTLS command first.   The responses are translated from german to english so please don't take them literally.   What are the corrected settings here? Is it something in my google account?  

04
S
M
manuelsobhan.selwinponpandianNew Participant
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.

01
S

Badge winners

Show all badges
Terms & ConditionsCookie settings