Skip to main content
Question

Error message on executing tables says table doesn't exist


rbrandsma
Contributor
Forum|alt.badge.img

Hi!

recently I helped a customer who was changing IT providers with installing their TimeXtender in the new environment. 

At this moment when executing a table they get an error message saying the following: 

Cannot find the object "O_BAE_BTW_CODES_R" because it does not exist or you do not have permissions.

Details:

SQL Server: 'ohs-sql1'

SQL Procedure: ''

SQL Line Number: 2

SQL Error Number: 1088

 

This concerns a table in the DSA layer of their TX environment. And is a table that does actually exist when we check the database in SSMS. The error message appears on the following step: 

Execute DSA dbo.O_BAE_BTW_CODES ODX transfers

Permissions have been checked multiple times, the concerned user accounts have db_datareader & db_datawriter privileges at the very least. 

6 replies

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • TimeXtender Xpert
  • 715 replies
  • July 16, 2025

Hi,

is the table stored in the schema TimeXtender is expecting to find it? If the schema does not exist yet, you will need more rights dan db_datawriter to create it.

Given that the step is an ODX transfer, your ODX service account will likely be pushing the data to DSA and will need the appropriate rights.


Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1119 replies
  • July 16, 2025

Hi ​@rbrandsma 

Does your user have owner rights of the databases? That is a requirement as well.


rbrandsma
Contributor
Forum|alt.badge.img
  • Author
  • Contributor
  • 15 replies
  • July 16, 2025

Hi ​@rory.smith 

We changed the rights of the ODX service account and set that to db_owner, this did not help unfortunately. 

@Thomas Lind 

I have just asked them to change this, will let you know if this helped. 


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

@rbrandsma do you have an update on this? thanks


rbrandsma
Contributor
Forum|alt.badge.img
  • Author
  • Contributor
  • 15 replies
  • August 1, 2025

Hi ​@Christian Hauggaard 

Yes, I have an update. 

The customer has been retracing the dataflow from ODX to DSA and then to MDW and notices the following (with a different table than the example in the opening post, which shows the same error message): 

  1. [TX_ODX].[Viewpoint_VIEWPOINT_ODS].O_NPO_WERKVERZOEKEN_DATA_2025_08_01__02_00_05_0285240 is an existing table and holds recent data. This shows that the ODX is receiving data from the ViewPoint appliction. That connection is working as intended.
  2. [DSA].[dbo].[O_NPO_WERKVERZOEKEN_R] contains data, but not recent, the DW_TimeStamp column shows 2025-06-25. Which means the data isn't flowing from the ODX to the DSA
  3. Both the _L & _M tables in DSA are empty and show no errors or warnings
  4. [DSA].[dbo].[O_NPO_WERKVERZOEKEN] contains data but has the same DW_TimeStamp as the _R table.
  5. [MDW].[dbo].[Werkverzoeken_R] contains data but also not recently, has the same DW_TimeStamp and the same goes for the [MDW].[dbo].[Werkverzoeken] version of the table. 
  6. Also in the MDW the _L & _M tables contain no errors or warnings

Another thing they mention is that it seems like the TX_ODX database is dropped every day because they needed to re-apply the accessrights for the user account every day. They have ‘fixed’ this by using a script that re-applies the accessrights for db_owner. 

The execution log in TimeXtender shows that the Database cleanup, Transfer en Synchronise all run successfully since 2025-07-22


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

@rbrandsma 

I have a few questions below, can you please get back regarding

1. Which version of TimeXtender are you using?

2. Just to confirm - you are getting the error message

“Cannot find the object "O_NPO_WERKVERZOEKEN_R" because it does not exist or you do not have permissions.”

when you try to execute [DSA].[dbo].[O_NPO_WERKVERZOEKEN] ?

3. Have you tried to fully load the DSA table? to do this right-click on the table and click deploy and execute and then click review tasks.

 

select deployment task, as well as the execution task and click Start. Please note this will fully load all records in incremental tables.

 

4. Have you tried synchronizing objects for the ODX?

In 20.10, right click the ODX and select synchronize objects. Also please try to right-click and select remove unused objects

In TimeXtender Data Integration, sync the prepare against the ingest instance by right-clicking the prepare instance and select “Synchronize with Ingest instance”

 


Reply


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