7 Answer(s)
-
0
Hi,
Please share the error logs; thanks.
-
0
Which log file should I be looking at for an error on: http://localhost:4200/product-service/product ?
-
0
Hi,
The gateway and product service.
-
0
Gateway:
2023-06-07 08:00:15.520 -05:00 [INF] Request finished HTTP/1.1 GET https://localhost:44325/api/abp/application-localization?cultureName=en&onlyDynamics=false - - - 200 62495 application/json;+charset=utf-8 810.7639ms 2023-06-07 08:01:42.638 -05:00 [INF] Request starting HTTP/1.1 OPTIONS https://localhost:44325/api/product-service/products?skipCount=0&maxResultCount=10 - - 2023-06-07 08:01:42.639 -05:00 [INF] CORS policy execution successful. 2023-06-07 08:01:42.639 -05:00 [INF] Request finished HTTP/1.1 OPTIONS https://localhost:44325/api/product-service/products?skipCount=0&maxResultCount=10 - - - 204 - - 0.6832ms 2023-06-07 08:01:42.644 -05:00 [INF] Request starting HTTP/1.1 GET https://localhost:44325/api/product-service/products?skipCount=0&maxResultCount=10 - - 2023-06-07 08:01:42.644 -05:00 [INF] CORS policy execution successful. 2023-06-07 08:01:42.644 -05:00 [DBG] requestId: 0HMR7ARR0ARKP:00000002, previousRequestId: no previous request id, message: ocelot pipeline started 2023-06-07 08:01:42.644 -05:00 [DBG] requestId: 0HMR7ARR0ARKP:00000002, previousRequestId: no previous request id, message: Upstream url path is /api/product-service/products 2023-06-07 08:01:42.645 -05:00 [DBG] requestId: 0HMR7ARR0ARKP:00000002, previousRequestId: no previous request id, message: downstream templates are /api/product-service/{everything} 2023-06-07 08:01:42.645 -05:00 [INF] requestId: 0HMR7ARR0ARKP:00000002, previousRequestId: no previous request id, message: EndpointRateLimiting is not enabled for /api/product-service/{everything} 2023-06-07 08:01:42.645 -05:00 [INF] requestId: 0HMR7ARR0ARKP:00000002, previousRequestId: no previous request id, message: No authentication needed for /api/product-service/products 2023-06-07 08:01:42.645 -05:00 [INF] requestId: 0HMR7ARR0ARKP:00000002, previousRequestId: no previous request id, message: /api/product-service/{everything} route does not require user to be authorized 2023-06-07 08:01:42.645 -05:00 [DBG] requestId: 0HMR7ARR0ARKP:00000002, previousRequestId: no previous request id, message: Downstream url is https://localhost:44361/api/product-service/products?skipCount=0&maxResultCount=10 2023-06-07 08:01:43.591 -05:00 [WRN] requestId: 0HMR7ARR0ARKP:00000002, previousRequestId: no previous request id, message: 500 (Internal Server Error) status code, request uri: https://localhost:44361/api/product-service/products?skipCount=0&maxResultCount=10 2023-06-07 08:01:43.591 -05:00 [DBG] requestId: 0HMR7ARR0ARKP:00000002, previousRequestId: no previous request id, message: setting http response message 2023-06-07 08:01:43.591 -05:00 [DBG] requestId: 0HMR7ARR0ARKP:00000002, previousRequestId: no previous request id, message: no pipeline errors, setting and returning completed response 2023-06-07 08:01:43.591 -05:00 [DBG] requestId: 0HMR7ARR0ARKP:00000002, previousRequestId: no previous request id, message: ocelot pipeline finished 2023-06-07 08:01:43.591 -05:00 [INF] Request finished HTTP/1.1 GET https://localhost:44325/api/product-service/products?skipCount=0&maxResultCount=10 - - - 500 331 application/json;+charset=utf-8 947.3412ms
-
0
Product Service:
2023-06-07 08:01:42.728 -05:00 [INF] Request starting HTTP/1.1 GET https://localhost:44361/api/product-service/products?skipCount=0&maxResultCount=10 - 0 2023-06-07 08:01:42.749 -05:00 [INF] CORS policy execution failed. 2023-06-07 08:01:42.750 -05:00 [INF] Request origin http://localhost:4200 does not have permission to access the resource. 2023-06-07 08:01:42.993 -05:00 [INF] Executing endpoint 'CarePlus.ProductService.Products.ProductController.GetListAsync (CarePlus.ProductService.HttpApi)' 2023-06-07 08:01:43.000 -05:00 [INF] Route matched with {area = "productService", action = "GetList", controller = "Product"}. Executing controller action with signature System.Threading.Tasks.Task
1[Volo.Abp.Application.Dtos.PagedResultDto
1[CarePlus.ProductService.Products.ProductDto]] GetListAsync(CarePlus.ProductService.Products.GetProductsInput) on controller CarePlus.ProductService.Products.ProductController (CarePlus.ProductService.HttpApi). 2023-06-07 08:01:43.142 -05:00 [DBG] PermissionStore.GetCacheItemAsync: pn:U,pk:3a14c69e-67af-d90d-a106-3a0b568954e7,n:ProductService.Products 2023-06-07 08:01:43.148 -05:00 [DBG] Found in the cache: pn:U,pk:3a14c69e-67af-d90d-a106-3a0b568954e7,n:ProductService.Products 2023-06-07 08:01:43.150 -05:00 [DBG] PermissionStore.GetCacheItemAsync: pn:R,pk:admin,n:ProductService.Products 2023-06-07 08:01:43.155 -05:00 [DBG] Found in the cache: pn:R,pk:admin,n:ProductService.Products 2023-06-07 08:01:43.156 -05:00 [DBG] PermissionStore.GetCacheItemAsync: pn:C,pk:Angular,n:ProductService.Products 2023-06-07 08:01:43.159 -05:00 [DBG] Found in the cache: pn:C,pk:Angular,n:ProductService.Products 2023-06-07 08:01:43.266 -05:00 [ERR] Failed executing DbCommand (5ms) [Parameters=[@__ef_filter__p_0='?' (DbType = Boolean), @__ef_filter__p_1='?' (DbType = Boolean)], CommandType='"Text"', CommandTimeout='30'] SELECT count(*) FROM "Products" AS p WHERE (@__ef_filter__p_0 OR NOT (p."IsDeleted")) AND (@__ef_filter__p_1 OR (p."TenantId" IS NULL)) 2023-06-07 08:01:43.274 -05:00 [ERR] An exception occurred while iterating over the results of a query for context type 'CarePlus.ProductService.EntityFrameworkCore.ProductServiceDbContext'. Npgsql.PostgresException (0x80004005): 42703: column p.TenantId does not existPOSITION: 84 at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|222_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable
1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func
4 operation, Func4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable
1.AsyncEnumerator.MoveNextAsync() Exception data: Severity: ERROR SqlState: 42703 MessageText: column p.TenantId does not exist Position: 84 File: parse_relation.c Line: 3661 Routine: errorMissingColumn Npgsql.PostgresException (0x80004005): 42703: column p.TenantId does not existPOSITION: 84 at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|222_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable
1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func
4 operation, Func4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable
1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken) Exception data: Severity: ERROR SqlState: 42703 MessageText: column p.TenantId does not exist Position: 84 File: parse_relation.c Line: 3661 Routine: errorMissingColumn 2023-06-07 08:01:43.397 -05:00 [ERR] ---------- RemoteServiceErrorInfo ---------- { "code": null, "message": "An internal error occurred during your request!", "details": null, "data": { "Severity": "ERROR", "InvariantSeverity": "ERROR", "SqlState": "42703", "MessageText": "column p.TenantId does not exist", "Position": 84, "File": "parse_relation.c", "Line": "3661", "Routine": "errorMissingColumn" }, "validationErrors": null }2023-06-07 08:01:43.398 -05:00 [ERR] 42703: column p.TenantId does not exist
POSITION: 84 Npgsql.PostgresException (0x80004005): 42703: column p.TenantId does not exist
POSITION: 84 at Npgsql.Internal.NpgsqlConnector.
2023-06-07 08:01:43.404 -05:00 [INF] Executing ObjectResult, writing value of type 'Volo.Abp.Http.RemoteServiceErrorResponse'. 2023-06-07 08:01:43.406 -05:00 [INF] Executed action CarePlus.ProductService.Products.ProductController.GetListAsync (CarePlus.ProductService.HttpApi) in 406.4045ms 2023-06-07 08:01:43.406 -05:00 [INF] Executed endpoint 'CarePlus.ProductService.Products.ProductController.GetListAsync (CarePlus.ProductService.HttpApi)' 2023-06-07 08:01:43.585 -05:00 [DBG] Added 0 entity changes to the current audit log 2023-06-07 08:01:43.589 -05:00 [DBG] Added 0 entity changes to the current audit log 2023-06-07 08:01:43.590 -05:00 [INF] Request finished HTTP/1.1 GET https://localhost:44361/api/product-service/products?skipCount=0&maxResultCount=10 - 0 - 500 - application/json;+charset=utf-8 862.5871ms
-
0
column p.TenantId does not exist
Can you try adding and applying the migration?
Run the
dotnet ef migrations add xxx
anddotnet ef database update
on theProductService.EntityFrameworkCore
folder. -
0
column p.TenantId does not exist
Can you try adding and applying the migration?
Run the
dotnet ef migrations add xxx
anddotnet ef database update
on theProductService.EntityFrameworkCore
folder.