Solved

Tables in DWH won't load data from Business Unit


I have a weird issue in my new TimeXtender project, where my tables in my dwh layer won't load data from the Business Unit. 

I have a very simple setup to start with. I have one business unit which loads a couple of tables, and the Bussines unit configured to store data on our “VMTXTD001” server in a database. 

The Datawarehouse uses the same database as the Bussiness Unit and should load from that Business Unit. But when I execute the DWH layer I get this message for all tables: 

 

Start Time : 4/19/2023 4:14:08 PM End Time : 4/19/2023 4:14:10 PM on server: VMTXTD001
-Execute Execution Package Default 'Failed'
    Invalid object name 'VMTXTD001.dbo.DM_CRM_Replica_dbo__CustomAccount_DSA_dsa_test_T'.
    
    Details:
    
    SQL Server: 'vmtxtd001'
    SQL Procedure: 'dsa.usp_CrDM_dsa_test_CRM_dbo__CustomAccount'
    SQL Line Number: 12
    SQL Error Number: 208
    
    Invalid object name 'VMTXTD001.dbo.DM_CRM_Replica_dbo__CustomAccount_DSA_dsa_test_T'.
 

To me the issue appears to be that TimeXtender created the procedure incorrectly. Instead of the database name I see my servername. 

FROM [VMTXTD001].[crm].[DM_CRM_Replica_crm_CustomOutstandingPayments_DSA_dsa_CustomOutstandingPayments_T]

Should be 

FROM [Database name].[crm].[DM_CRM_Replica_crm_CustomOutstandingPayments_DSA_dsa_CustomOutstandingPayments_T]

 

Do you guys have any idea why this is and how I can fix this.

 

 

We use TimeXtender version: 20.10.32.64

icon

Best answer by Roy VH 20 April 2023, 08:36

View original

11 replies

Userlevel 6
Badge +5

Hi @Roy VH have you tried a full deploy for the project? Please note that a full load, will fully load incremental tables in your project. In order to fully deploy the project, right click the project and select deploy. Select review tasks and then ensure that the deploy box is checked and select Start.

 

Hello Christian, 

 

Yes I have tried that multiple times, sadly with no results.

I have just found the issue, which I think is kind of a bug. But the issue was that I set the “Direct Read” setting in my dwh layer to “Matching Server”. I just changed this to "Disabled” and now it does work. 

 

The strange thing is that I use this setting in most of my other projects and there it works without issues. Thanks for your reply.

Userlevel 6
Badge +5

@Roy VH is the BU (CRM) on the same server as DW (DSA)?

@Christian Hauggaard The data source from the BU is on another server, but the BU storage is on the same server as the dwh.

Userlevel 1

@Christian Hauggaard 
Found this post becaue i am suddenly experinceing the same issue.
I have fully deploy for the project a couple of times but it was no use

Userlevel 6
Badge +5

Hi @aftabp did you try changing the “Direct Read” setting in your dwh layer as Roy mentions above?  

Userlevel 1

@Christian Hauggaard 
Where do i go to change this setting?

Userlevel 6
Badge +5

@aftabp under edit DW

or in environment properties if you are using global databases

Userlevel 1

@Christian Hauggaard 

I am wondering why has TX suddenly throwing an error. It’s always about some table ending with extension “_T”. It was working fine a week ago.

Luckly it’s my DEV and not PROD so i am not worried (for the moment).

Question, i have a couple of tables and code that i need to transfer to PROD. If i do an environment transfer, will this issue follow from DEV to PROD?

Userlevel 1

@Christian Hauggaard 

I have managed to solve this issue by removing the table, saving the project, adding again and then Executing and Deploying it

Reply