575
I am trying to enable the Extended pricing under Sales – Setup – Extended Pricing and get the error below:
[Microsoft][SQL Server Native Client 11.0][SQL Server] Invalid Object Name: 'RTW_PRICELIST_DELETE'
Any suggestion on how to handle this?
*This post is locked for comments
Interesting. If you open up a few of the stored procedures, are there any comments in there or clues in the tables they interact with, as to what they belong to.
I simply am not familiar with whatever module uses RTW so I'm reaching the end of my usefulness.
I still think you have a module or 3rd party product with a corrupt installation that needs fixing up before you can move forward.
Tim.
Hi Tim,
I am seeing a lot of Stored Procedures with the RTW in it. What is RTW?
I am guessing there is a GP addin or modification by RTW involved here, or someone has added a database hack?
Have you any 3rd party products installed, or could have had something installed in the past?
Curious to know what results you get it if you run the following SQL against the company database which should look for any objects named RTW.
|
|
select object_name(object_id) as object_name,definition
from sys.sql_modules
where definition like '%RTW%'
|
Does it find any RTW_ named objects?
You could also look for the call for this object and see where is it by searching the DB- it might not be there, it might be in code.
SELECT DISTINCT
Tim
Did you get this resolved?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (