I'm trying upgrading my solution (ASP.NET Core + Angular) from v10.2.0 to v10.3.0 but I observed that the 'service-proxies.ts' file is generated in a different way than before.
Here is the comparison of generated source code of AuditLogServiceProxy.getAuditLogs() method:
As you can see, one of the parameters, userName is generated from nullable to un-nullable and it will throw new Error("The parameter 'endDate' cannot be null.")
I wonder if there is any way to prevent this behavior, because it makes most of my business logic goes wrong after upgrading.
Here is the full source code of AuditLogServiceProxy.getAuditLogs() method:
Before:
/**
* @param startDate (optional)
* @param endDate (optional)
* @param userName (optional)
* @param serviceName (optional)
* @param methodName (optional)
* @param browserInfo (optional)
* @param hasException (optional)
* @param minExecutionDuration (optional)
* @param maxExecutionDuration (optional)
* @param sorting (optional)
* @param maxResultCount (optional)
* @param skipCount (optional)
* @return Success
*/
getAuditLogs(startDate: DateTime | undefined, endDate: DateTime | undefined, userName: string | null | undefined, serviceName: string | null | undefined, methodName: string | null | undefined, browserInfo: string | null | undefined, hasException: boolean | null | undefined, minExecutionDuration: number | null | undefined, maxExecutionDuration: number | null | undefined, sorting: string | null | undefined, maxResultCount: number | undefined, skipCount: number | undefined): Observable<PagedResultDtoOfAuditLogListDto> {
let url_ = this.baseUrl + "/api/services/app/AuditLog/GetAuditLogs?";
if (startDate === null)
throw new Error("The parameter 'startDate' cannot be null.");
else if (startDate !== undefined)
url_ += "StartDate=" + encodeURIComponent(startDate ? "" + startDate.toJSON() : "") + "&";
if (endDate === null)
throw new Error("The parameter 'endDate' cannot be null.");
else if (endDate !== undefined)
url_ += "EndDate=" + encodeURIComponent(endDate ? "" + endDate.toJSON() : "") + "&";
if (userName !== undefined && userName !== null)
url_ += "UserName=" + encodeURIComponent("" + userName) + "&";
if (serviceName !== undefined && serviceName !== null)
url_ += "ServiceName=" + encodeURIComponent("" + serviceName) + "&";
if (methodName !== undefined && methodName !== null)
url_ += "MethodName=" + encodeURIComponent("" + methodName) + "&";
if (browserInfo !== undefined && browserInfo !== null)
url_ += "BrowserInfo=" + encodeURIComponent("" + browserInfo) + "&";
if (hasException !== undefined && hasException !== null)
url_ += "HasException=" + encodeURIComponent("" + hasException) + "&";
if (minExecutionDuration !== undefined && minExecutionDuration !== null)
url_ += "MinExecutionDuration=" + encodeURIComponent("" + minExecutionDuration) + "&";
if (maxExecutionDuration !== undefined && maxExecutionDuration !== null)
url_ += "MaxExecutionDuration=" + encodeURIComponent("" + maxExecutionDuration) + "&";
if (sorting !== undefined && sorting !== null)
url_ += "Sorting=" + encodeURIComponent("" + sorting) + "&";
if (maxResultCount === null)
throw new Error("The parameter 'maxResultCount' cannot be null.");
else if (maxResultCount !== undefined)
url_ += "MaxResultCount=" + encodeURIComponent("" + maxResultCount) + "&";
if (skipCount === null)
throw new Error("The parameter 'skipCount' cannot be null.");
else if (skipCount !== undefined)
url_ += "SkipCount=" + encodeURIComponent("" + skipCount) + "&";
url_ = url_.replace(/[?&]$/, "");
let options_ : any = {
observe: "response",
responseType: "blob",
headers: new HttpHeaders({
"Accept": "text/plain"
})
};
return this.http.request("get", url_, options_).pipe(_observableMergeMap((response_ : any) => {
return this.processGetAuditLogs(response_);
})).pipe(_observableCatch((response_: any) => {
if (response_ instanceof HttpResponseBase) {
try {
return this.processGetAuditLogs(<any>response_);
} catch (e) {
return <Observable<PagedResultDtoOfAuditLogListDto>><any>_observableThrow(e);
}
} else
return <Observable<PagedResultDtoOfAuditLogListDto>><any>_observableThrow(response_);
}));
}
After:
/**
* @param startDate (optional)
* @param endDate (optional)
* @param userName (optional)
* @param serviceName (optional)
* @param methodName (optional)
* @param browserInfo (optional)
* @param hasException (optional)
* @param minExecutionDuration (optional)
* @param maxExecutionDuration (optional)
* @param sorting (optional)
* @param maxResultCount (optional)
* @param skipCount (optional)
* @return Success
*/
getAuditLogs(startDate: DateTime | undefined, endDate: DateTime | undefined, userName: string | undefined, serviceName: string | undefined, methodName: string | undefined, browserInfo: string | undefined, hasException: boolean | undefined, minExecutionDuration: number | undefined, maxExecutionDuration: number | undefined, sorting: string | undefined, maxResultCount: number | undefined, skipCount: number | undefined): Observable<PagedResultDtoOfAuditLogListDto> {
let url_ = this.baseUrl + "/api/services/app/AuditLog/GetAuditLogs?";
if (startDate === null)
throw new Error("The parameter 'startDate' cannot be null.");
else if (startDate !== undefined)
url_ += "StartDate=" + encodeURIComponent(startDate ? "" + startDate.toJSON() : "") + "&";
if (endDate === null)
throw new Error("The parameter 'endDate' cannot be null.");
else if (endDate !== undefined)
url_ += "EndDate=" + encodeURIComponent(endDate ? "" + endDate.toJSON() : "") + "&";
if (userName === null)
throw new Error("The parameter 'userName' cannot be null.");
else if (userName !== undefined)
url_ += "UserName=" + encodeURIComponent("" + userName) + "&";
if (serviceName === null)
throw new Error("The parameter 'serviceName' cannot be null.");
else if (serviceName !== undefined)
url_ += "ServiceName=" + encodeURIComponent("" + serviceName) + "&";
if (methodName === null)
throw new Error("The parameter 'methodName' cannot be null.");
else if (methodName !== undefined)
url_ += "MethodName=" + encodeURIComponent("" + methodName) + "&";
if (browserInfo === null)
throw new Error("The parameter 'browserInfo' cannot be null.");
else if (browserInfo !== undefined)
url_ += "BrowserInfo=" + encodeURIComponent("" + browserInfo) + "&";
if (hasException === null)
throw new Error("The parameter 'hasException' cannot be null.");
else if (hasException !== undefined)
url_ += "HasException=" + encodeURIComponent("" + hasException) + "&";
if (minExecutionDuration === null)
throw new Error("The parameter 'minExecutionDuration' cannot be null.");
else if (minExecutionDuration !== undefined)
url_ += "MinExecutionDuration=" + encodeURIComponent("" + minExecutionDuration) + "&";
if (maxExecutionDuration === null)
throw new Error("The parameter 'maxExecutionDuration' cannot be null.");
else if (maxExecutionDuration !== undefined)
url_ += "MaxExecutionDuration=" + encodeURIComponent("" + maxExecutionDuration) + "&";
if (sorting === null)
throw new Error("The parameter 'sorting' cannot be null.");
else if (sorting !== undefined)
url_ += "Sorting=" + encodeURIComponent("" + sorting) + "&";
if (maxResultCount === null)
throw new Error("The parameter 'maxResultCount' cannot be null.");
else if (maxResultCount !== undefined)
url_ += "MaxResultCount=" + encodeURIComponent("" + maxResultCount) + "&";
if (skipCount === null)
throw new Error("The parameter 'skipCount' cannot be null.");
else if (skipCount !== undefined)
url_ += "SkipCount=" + encodeURIComponent("" + skipCount) + "&";
url_ = url_.replace(/[?&]$/, "");
let options_ : any = {
observe: "response",
responseType: "blob",
headers: new HttpHeaders({
"Accept": "text/plain"
})
};
return this.http.request("get", url_, options_).pipe(_observableMergeMap((response_ : any) => {
return this.processGetAuditLogs(response_);
})).pipe(_observableCatch((response_: any) => {
if (response_ instanceof HttpResponseBase) {
try {
return this.processGetAuditLogs(<any>response_);
} catch (e) {
return <Observable<PagedResultDtoOfAuditLogListDto>><any>_observableThrow(e);
}
} else
return <Observable<PagedResultDtoOfAuditLogListDto>><any>_observableThrow(response_);
}));
}
We are trying migrating our project (ANZ v7.2.0 - ASP.NET Core + Angular) from MS SQL Server to Oracle 11g but we got this error when running "Update-Database":
PM> update-database --verbose
Applying migration '20170406083347_Initial_Migration'.
2020-07-27 23:02:16.447396 ThreadID:1 (ERROR) OracleRelationalCommand.Execute() : Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00972: identifier is too long
ORA-06512: at line 2
at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, OracleLogicalTransaction& oracleLogicalTransaction, Boolean isFromEF)
at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()
at Oracle.EntityFrameworkCore.Storage.Internal.OracleRelationalCommandBuilderFactory.OracleRelationalCommandBuilder.OracleRelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues)
Failed executing DbCommand (38ms) [Parameters=[], CommandType='Text', CommandTimeout='0']
BEGIN
EXECUTE IMMEDIATE 'CREATE TABLE
"AbpNotifications" (
"Id" RAW(16) NOT NULL,
"CreationTime" TIMESTAMP(7) NOT NULL,
"CreatorUserId" NUMBER(19),
"Data" NCLOB,
"DataTypeName" NVARCHAR2(512),
"EntityId" NVARCHAR2(96),
"EntityTypeAssemblyQualifiedName" NVARCHAR2(512),
"EntityTypeName" NVARCHAR2(250),
"ExcludedUserIds" NCLOB,
"NotificationName" NVARCHAR2(96) NOT NULL,
"Severity" NUMBER(3) NOT NULL,
"TenantIds" NCLOB,
"UserIds" NCLOB,
CONSTRAINT "PK_AbpNotifications" PRIMARY KEY ("Id")
)';
END;
After investigating, we found the problem is because the column name is too long (EntityTypeAssemblyQualifiedName: 31 vs the limitation of Oracle 11g is 30).
Is there any suggestion to solve this issue? I know this limitation is solve from Oracle 12c but we must use Oracle 11g (even older versions as well).
I'm using ASP.NET CORE & Angular (v8.1.0), I want to update Users grid to show ProfilePicture as below:
I've read Show Profile Pictures in Users Grid #5243 and tried updating as following:
user.component.html:
user.comonent.ts:
remoteServiceBaseUrl: string = AppConsts.remoteServiceBaseUrl;
But the picture is not shown:
I've got this error:
If I logged in to the SwaggerUI then refresh the Angular app, I got this error:
Here is my CORS setting in appsettings.json:
"App": { "ServerRootAddress": "http://localhost:22742/", "ClientRootAddress": "http://localhost:4200/", "CorsOrigins": "http://*.mycompany.com,http://localhost:4200,http://localhost:49152", "SwaggerEndPoint": "/swagger/v1/swagger.json", "AllowAnonymousSignalRConnection": "true" },
What am I missing here? Any other way to solve my problem?
Default Theme
Cannot send test email, got the exeption: System.FormatException: The specified string is not in the form required for an e-mail address.
Version: ASP.NET CORE & Angular - v8.1.0
I'm using ASP.NET Core & Angular (v7.0.0). I can deploy to the local IIS and open both the Host and the Web.
But whenever I click on the flag to switch to another localization:
I got an 'HTTP Error 404.0 - Not Found':
Press F5 to refresh is no help. I can only open the Web again if I change the URL from: 'http://localhost:8080/app/admin/hostDashboard' to 'http://localhost:8080/' then click Enter:
