Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Commerce forum / CRT Deployment Error o...
Commerce forum
Answered

CRT Deployment Error on LCS Due to DBO Schema

Posted on by 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,803 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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans