Skip to main content
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

Best answer by Roy VH

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.

View original
Did this topic help you find an answer to your question?

11 replies

Christian Hauggaard
Community Manager
Forum|alt.badge.img+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.

 


  • Author
  • Starter
  • 4 replies
  • April 20, 2023

Hello Christian, 

 

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


  • Author
  • Starter
  • 4 replies
  • Answer
  • April 20, 2023

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.


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

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


  • Author
  • Starter
  • 4 replies
  • April 20, 2023

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


Forum|alt.badge.img
  • Problem Solver
  • 112 replies
  • July 1, 2024

@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


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

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


Forum|alt.badge.img
  • Problem Solver
  • 112 replies
  • July 1, 2024

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


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

@aftabp under edit DW

or in environment properties if you are using global databases


Forum|alt.badge.img
  • Problem Solver
  • 112 replies
  • July 1, 2024

@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?


Forum|alt.badge.img
  • Problem Solver
  • 112 replies
  • July 2, 2024

@Christian Hauggaard 

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


Cookie policy

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

 
Cookie settings