microsoft / wingtipticketssaas-dbpertenant Goto Github PK

It looks like there is an issue in .\Learning Modules\Common\CatalogAndDatabaseManagement.psm1:987 char:34 The path is returning catalog-patrickg.database.windows.net when it should be returning catalog-dpt-patrickg.database.windows.net

I got this error running Demo-LoadGenerator.ps1

It is mentioned in this stackoverflow article that data dependancy routing is an overkill when it comes to single tenant sharding pattern. Can someone please explain on this?

https://stackoverflow.com/questions/50781540/azure-elastic-scale-database-per-tenant-how-to-implement-data-dependent-routing#

cd WingtipTicketsSaaS-DbPerTenant\Learning Modules\Provision and Catalog> .\Demo-ProvisionAndCatalog.ps1

After selecting the subscription I'm getting this:

WingtipTicketsSaaS-DbPerTenant\Learning Modules\Provision and Catalog\Demo-ProvisionAndCatalog.ps1 : The term 'Find-AzureRmResource' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the 
name, or if a path was included, verify that the path is correct and try again.
At line:1 char:1
+ .\Demo-ProvisionAndCatalog.ps1
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Demo-ProvisionAndCatalog.ps1

Looks like the script could do with an update, https://docs.microsoft.com/en-us/troubleshoot/azure/general/find-azurermresource-fails

Hi there!
Thank you for all useful information in your repo and ms docs page!
Today I tried to get the latest of your repo and I can see that the solution is not compatible with Vs2019.- Any idea if you are going to migrate the code to latest version ?

https://github.com/Microsoft/WingtipTicketsSaaS-DbPerTenant/blob/89d9fdee6980b2a3a04fe561afc02214d97760ab/Learning%20Modules/Provision%20and%20Catalog/Demo-ProvisionAndCatalog.ps1#L63

Today I work on a product where we are using:
sql server
reporting services
analisis services
All these product are installed per user in most of the cases and we are looking work with multitenant arch.

I am looking forward your github repo& docs I would like to know if you have more materials related with:
Reporting services working with multitenant
Analysis services working with multitenant
Thanks in advance.

There are important files that Microsoft projects should all have that are not present in this repository. A pull request has been opened to add the missing file(s). When the pr is merged this issue will be closed automatically.

Microsoft teams can learn more about this effort and share feedback within the open source guidance available internally.

Merge this pull request

Does not build. After i download and restore I get below error every time i try to build :(

Error CS0017 Program has more than one entry point defined. Compile with /main to specify the type that contains the entry point. Events-TenantUserApp D:\VSRubbishProjects\WingtipTicketsSaaS-DbPerTenant-master\App\src\Events-TenantUserApp\Program.cs

I am using the most up to date vs 2017 as of this post

This Powershell file fails looking for a Resolve-DnsName cmdlet in Get-ServerNameFromAlias on line 41:
$serverName = Get-ServerNameFromAlias $newTenantAlias

That cmdlet is also used in several other Powershell files and will probably fail there.
Here's the exact error message:

Get-ServerNameFromAlias : The term 'Resolve-DnsName' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was
included, verify that the path is correct and try again.
At C:\Users\pkandra.ATLANTA\Downloads\WingtipTicketsSaaS-DbPerTenant-master\WingtipTicketsSaaS-DbPerTenant-master\Learning Modules\Provision and Catalog\Demo-ProvisionAndCatalog.ps1:41
char:19

• $serverName = Get-ServerNameFromAlias $newTenantAlias
  

•               ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : ObjectNotFound: (Resolve-DnsName:String) [Get-ServerNameFromAlias], CommandNotFoundException
  • FullyQualifiedErrorId : CommandNotFoundException,Get-ServerNameFromAlias

Hello,

I am encountering several issues with the deployment of the "WingtipTicketsSaaS-DbPerTenant" project using both the "Deploy to Azure" button provided in the official documentation and the manual deployment from the GitHub repository. Below are the details of the issues:

1. Missing storageKey in ARM Template: The ARM template lacks the storageKey parameter when deployed through both the "Deploy to Azure" button and manual deployment using the code from the GitHub repository. This omission leads to errors related to invalid storage credentials during the import operation of the .bacpac file. The exact error message encountered in both deployment methods is: "The ImportExport operation failed because of invalid storage credentials."
   
   
   
   
   

2. Inconsistency in storageUri Domain Names: There is a discrepancy in the domain names of the storageUri between the template deployed via the "Deploy to Azure" button and the latest version on GitHub. The domain used by the "Deploy to Azure" is wtdemoresourcestemp.blob.core.windows.net, whereas the GitHub codes uses wingtipsaas1.blob.core.windows.net.
   
   

3. Resource Not Found Error for .bacpac File: Directly accessing the storageUri of the .bacpac file provided in the latest GitHub repository version (https://wingtipsaas1.blob.core.windows.net/bacpacs-dpt/contosoconcerthall.bacpac) results in a "Resource Not Found" error. The error message is as follows:

  <Error>
   <Code>ResourceNotFound</Code>
   <Message>The specified resource does not exist. RequestId:97c12964-f01e-003c-23d9-8fbed1000000 Time:2024-04-16T08:38:33.5851022Z</Message>
   </Error>

These issues are causing significant deployment failures, and it seems that there might be outdated information or errors in the deployment scripts or documentation. Any assistance or updates to resolve these problems would be greatly appreciated.

Thank you.

Is it possible to have tenant databases in sequential numbers like tenantdb0000001 and incrementing and have the tenant names mapped to it so that we can provision databses in advance and assign them to new tenant as they signup/

Accessing the app's URL about 25 minutes after deployment completion returns the result below.

I've tried twice - the second time using a 'random' username in case duplication was the issue.

while visiting the tenant i m getting the https://events-wingtip-dpt-cr4.eastus2.....
Why i m getting cr4 in the location since my location is only eastus2.
when i m removing that cr4 portion then the url is working.
And how can i remove "cr4"