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. 

3 replies

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • TimeXtender Xpert
  • 707 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
  • 1100 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
  • 14 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. 


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