Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / CRT Deployment Error o...
Supply chain | Supply Chain Management, Commerce
Answered

CRT Deployment Error on LCS Due to DBO Schema

(0) ShareShare
ReportReport
Posted on by Aman Soni 45

Hi experts,

I have one requirement in which I have to play around with all the orders that have been created via Ecom Site. In order to implement this feature, I found these two tables from DBO schema that could be used.

  • SalesTable
  • RetailTransactionTable

As the SalesTable is in the DBO schema, I created a view in EXT schema that combines records from both tables, but when I deployed it to LCS it threw an error invalid object name SalesTable.

Since we cannot directly fire queries on DBO schema with an extension script, I thought a view in EXT schema might be helpful.

Below is the demo query that I used to create a view.

Create View EXT.Demo as(
SELECT SALESID AS ID  FROM [DBO].SALESTABLE
)

GRANT SELECT ON OBJECT::[ext].[Demo] TO [UsersRole]
GO
GRANT SELECT ON OBJECT::[ext].[Demo] TO [DeployExtensibilityRole]
GO

I have basically two queries:

  • Is there a way use data from DBO schema in CRT extension scripts?
  • What tables in AX schema can I use to fetch the records for sales order?

Regards,

Aman Soni

  • Aman Soni Profile Picture
    Aman Soni 45 on at
    RE: CRT Deployment Error on LCS Due to DBO Schema

    Hi Judy ,

    I appreciate your response. 

    Regards,

    Aman Soni

  • Verified answer
    huijij Profile Picture
    huijij 19,811 on at
    RE: CRT Deployment Error on LCS Due to DBO Schema

    Hi Aman,

    In Finance and Commerce there is a now schema called the ext schema to support extensions. In previous versions, if you wanted to add an extension to channel DB, you would add it to the CRT or AX schema. In both Finance and Commerce, you cannot change the CRT, AX, or DBO schemas. All changes must be made in the ext schema. If you modify anything in the CRT or AX schemas, then deployment in Lifecycle Services (LCS) will fail. Please don't use any of the crt, ax or dbo schema data types in ext schema. Create custom types in ext schema and use it.

    learn.microsoft.com/.../channel-db-extensions

    You can use SalesTable,SalesLine etc. to fetch the records for sales order.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans