Rolphy Reyes

Hi! This is the first time I'm trying to make a deployment to IIS. Everything is working fine in my development machine (as always). When I'm trying to make the deployment to IIS, I'm getting this error: HTTP/1.1 500 Internal Server Error Server: Microsoft-IIS/10.0 Date: Sun, 10 Nov 2024 17:07:20 GMT Connection: close Access-Control-Allow-Origin: * Access-Control-Allow-Methods: HEAD,GET,PUT,POST,DELETE,OPTIONS Access-Control-Allow-Headers: X-Requested-With,Content-Type,Authorization Content-Encoding: UTF8 Content-Type: text/plain Content-Length: 12 HTTP/1.1 5 Server: Microsoft-IIS/10.0 Date: Sun, 10 Nov 2024 17:07:20 GMT Connection: close C<�h�t�m�l�>�<�t�i�t�l�e�>�I�n�t�e�r�n�a�l� �S�e�r�v�e�r� �E�r�r�o�r� �5�0�0�<�/�t�i�t�l�e�>� � �<�h�1�>�I�n�t�e�r�n�a�l� �S�e�r�v�e�r� �E�r�r�o�r� �5�0�0�<�/�h�1�>�<�h The call is: https://myserver/myAppPool/ApiLogin.dll/MyBase/security/helloworld Anyone can help me?

This is what I find (I have to "erase" some data): 2024-11-10 16:54:32 10.1.0.4 GET /api/security/helloworld - 443 - 00.000.00.000 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64;+rv:132.0)+Gecko/20100101+Firefox/132.0 - 500 0 0 24 2024-11-10 16:54:52 10.1.0.4 GET /api/security/helloworld - 443 - 00.000.00.000 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64;+rv:132.0)+Gecko/20100101+Firefox/132.0 - 500 0 0 23 2024-11-10 16:56:44 10.1.0.4 GET /api/security/helloworld - 443 - 00.000.00.000 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64;+rv:132.0)+Gecko/20100101+Firefox/132.0 - 500 0 0 24 2024-11-10 16:59:21 10.1.0.4 GET /api/security/helloworld - 443 - 00.000.00.000 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64;+rv:132.0)+Gecko/20100101+Firefox/132.0 - 500 0 0 18 2024-11-10 16:59:52 10.1.0.4 GET /api/security/helloworld - 443 - 00.000.00.000 PostmanRuntime/7.42.0 - 500 0 0 130 2024-11-10 17:00:05 10.1.0.4 GET /api/security/helloworld - 443 - 00.000.00.000 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64;+rv:132.0)+Gecko/20100101+Firefox/132.0 - 500 0 0 75 2024-11-10 17:07:20 10.1.0.4 GET /favicon.ico - 443 - 00.000.00.000 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64;+rv:132.0)+Gecko/20100101+Firefox/132.0 api/security/helloworld 404 0 64 2 2024-11-10 17:15:46 10.1.0.4 GET /api/security/helloworld - 443 - 00.000.00.000 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64;+rv:132.0)+Gecko/20100101+Firefox/132.0 - 500 0 0 385 2024-11-10 17:18:06 10.1.0.4 GET /api/security/helloworld - 443 - 00.000.00.000 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64;+rv:132.0)+Gecko/20100101+Firefox/132.0 - 500 0 0 84 2024-11-10 17:18:06 10.1.0.4 GET /favicon.ico - 443 - 00.000.00.000 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64;+rv:132.0)+Gecko/20100101+Firefox/132.0 api/security/helloworld 404 0 64 0 2024-11-10 17:43:02 10.1.0.4 GET /api/security/helloworld - 443 - 00.000.00.000 PostmanRuntime/7.42.0 - 500 0 0 347 2024-11-10 17:50:55 10.1.0.4 GET /api/security/helloworld - 443 - 5.255.231.71 Mozilla/5.0+(compatible;+YandexBot/3.0;++http://yandex.com/bots) - 500 0 0 137

I have the INI file with this: [DefaultEngine] BasePath=/MyApi ;Port=0 ;PortSSL=0 ThreadPoolSize=100 Seguridad.JWT.Issuer=Bla Bla Seguridad.JWT.Secret=Bla Bla ;DefaultApp.JWT.CookieEnabled=true ;DefaultApp.JWT.CookieName=access_token ;CookieDomain default: hostname of the request ;DefaultApp.JWT.CookieDomain= ;CookiePath default: base path of the request ;DefaultApp.JWT.CookiePath= Seguridad.JWT.Duration=1 ;DefaultApp.JWT.CookieSecure=false Compression.Enabled=True CORS.Enabled=True CORS.Origin=* CORS.Methods=HEAD,GET,PUT,POST,DELETE,OPTIONS CORS.Headers=X-Requested-With,Content-Type,Authorization

Where I can see this log?

I think it load only the INI file of the framework, so to speak.

Hi! Thanks for your time. I've had compiled it for both 32 bit and 64 bit and I get the same error. In the Application Pool on the IIS, I had turn on/off in the enable 32-bit applications param. I don't really understand what's going on. And the sad part is that I have to delivery this ASAP.

Hi! I have the same problem with the current version of the source code of the framework. I put this code in the ServerMainForm unit: initialization ReportMemoryLeaksOnShutdown := True; DefaultMARSJSONSerializationOptions.SkipEmptyValues := False; DefaultMARSJSONSerializationOptions.DateIsUTC := False; DefaultMARSJSONSerializationOptions.UseDisplayFormatForNumericFields := False; DefaultMARSJSONSerializationOptions.DateFormat := ISO8601; And I still can not get all the fields, the fields with empty value are completely ommitted.

Hi! For me the biggest problem is when you need to add some additional "TEdit" in a frame in a certain scenario. I think that with "SubForms" you don't have that problem.

Hi! Maybe the JEDI library.

Hi! Maybe I'm wrong but I think that you get two "different" connections when the AcquireConnection method is call. I would do this: LTransactionRW.Connection := FDManager.AcquireConnection('MY_DB', ''); LTransactionRW.Options.ReadOnly := False; LQueryRW.Connection := LTransactionRW.Connection; LQueryRW.Transaction := LTransactionRW;

Hi! I don't know if you have seen this blog (and may help you): https://www.tmssoftware.com/site/blog.asp?post=1045

Hi! Maybe you can use attributes.