SQL Server Database Mail failures: sysmail_faileditems.description is truncated, how can I see the full message?

I’m configuring SQL Server Database Mail – always a fun task – and am getting an error message from the mail server, which I can see in the Database Mail Log from Log File Viewer and I can see by querying msdb.dbo.sysmail_faileditems. However, the server response is clearly longer than msdb.dbo.sysmail_faileditems.description column allows. Is there any way to see the full server response?

Here’s an example description (I’ve edited the IP address but it shows my server’s external IP address):

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2021-10-13T11:40:56). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Invalid credentials for relay []. The IP address you’ve). )

In this case I’m using Gmail’s SMTP Relay with allowed IP Addresses. I’d like to know what the rest of the message is. I’ve configured a different server to successfully use the same account and smtp relay server, so it’s probably an IP config problem.

Defining a function as a truncated taylors series

I am trying to numerically find the error of a truncated series. To do so I want to first define a function that is the truncated sum, I cannot seem to do that. All I am tried is not working.

f[x_]:=Normal[Series[ArcTan[x], {x, 0, 100}]] 

Does not work as f[1] evaluates $ x$ inside $ \arctan$ . I also tried

Normal[Series[ArcTan[x], {x, 0, 100}]] f[x_]:=% 

But that did not work. When I copy and paste the result of

Normal[Series[ArcTan[x], {x, 0, 100}]] 

It works fine. What am I doing wrong?

Scheduling to minimize the truncated gaps

I have a single job of unit length, a set of $ n$ slots, and a budget of $ B$ units. If the job is scheduled at slot $ t$ , then it will consume $ c(t)$ units of the budget $ B$ . If the job is not scheduled for a period of $ x$ consecutive slots, then a penalty of $ \lfloor x/2\rfloor$ occurs. The objective is to schedule the job in order to minimize the sum of penalties.

For example, for $ n=12$ , if the job is scheduled at slot 1, at slot 3, at slot 6, and at slot $ 12$ , then the sum of penalties is $ \lfloor 1/2\rfloor + \lfloor 2/2\rfloor + \lfloor 6/2\rfloor = 0+1+3=4$ .

Is this problem NP-hard?

I am trying to reduce the knapsack problem to it. Transforming the values in the knapsack problem to the penalties is somehow difficult, because once the job is scheduled at $ t$ , the penalty is initialized.

Ubuntu bug unreportable due to truncated core dump. How to fix?

Sometimes after logging in I get a message saying:

Sorry, Ubuntu 19.04 has experienced an internal error.

Send problem report to the developers?

I always click Send, but don’t think it really works for me. If I click Show Details before that, I see:

ExecutablePath: /usr/bin/dbus-daemon UnreportableReason: Invalid core dump: BFD: warning: /tmp/apport_core_3znvp3mb is truncated: expected core file size >= 2981888, found: 61440

The information seems to come from /var/crash/_usr_bin_dbus-daemon.1000.crash. I saw a similar discussion on a mailing list and I checked:

  • /var/log/apport.log is empty
  • /tmp is not full (has 6.8G available)
  • ulimit -c is 0

What could be cause for the truncated core dump?

Erro de String or binary data would be truncated – SQL

Essa é a estrutura da minha tabela;

CREATE TABLE Pessoaldesenv.dbo.Conformidade (     [ID numeric] numeric(19,0) IDENTITY(1,1) NOT NULL,     Validacao int NULL,     Arquivo varchar(100) COLLATE SQL_Latin1_General_CP1_CI_AI NULL,     CodigoAudinUJ varchar(6) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL,     Remessa numeric(19,0) NULL,     ChaveRegistro varchar(MAX) COLLATE SQL_Latin1_General_CP1_CI_AI NULL,     NaoConformidade varchar(MAX) COLLATE SQL_Latin1_General_CP1_CI_AI NULL,     Detalhe varchar(MAX) COLLATE SQL_Latin1_General_CP1_CI_AI NULL,     Reincidencia int NULL,     FalsoPositivo numeric(1,0) DEFAULT 0 NULL,     Resolvida int NULL,     Observacao varchar(MAX) COLLATE SQL_Latin1_General_CP1_CI_AI NULL,     DataEntrada date NULL,     DataFalsoPositivo date NULL,     CONSTRAINT PK__NaoConfo__ADCA4E927FFBBC86 PRIMARY KEY ([ID numeric]) ) GO; 

Esse é o insert que estou fazendo na tabela;

INSERT INTO Pessoaldesenv.dbo.Conformidade ( Validacao,  Arquivo,  CodigoAudinUJ,  Remessa,  ChaveRegistro,  NaoConformidade,  Detalhe,  Reincidencia,  FalsoPositivo,  Resolvida,  Observacao,  DataEntrada,  DataFalsoPositivo) VALUES( 1,  'ARQUIVO1', 'CodigoAudinUJ',  0,  'CHAVE_REGISTRO1',   'NAO CONFORMIDADE1',  '',  0,  0,  0,  '',  '2004-07-12',  '2004-07-12' ); 

Estou utilizando SQL serve, porque será que está dando o erro de String or binary data would be truncated ?

Find $ \int_{S_{c}} \underset{\bar{}}{F}.d \underset{\bar{}}{S}\;$ for truncated cone.

$ \int_{S_{c}} \underset{\bar{}}{F}.d \underset{\bar{}}{S}\;$ where $ S_{c}$ is the curved part of the truncated cone $ x^2 + y^2 = (a-z)^2 , 0≤z≤(1/2)a$

Where $ \underset{\bar{}}{F}$ = $ (2x + y^2)\underset{\bar{}}{i} + (y+xz)\underset{\bar{}}{j} + z\underset{\bar{}}{k}$ . Use a normal to $ S_{c}$ that points away from the z axis and give answer in the form $ pπa^3/q$ .

Hints: a) Use the divergence theorem

b) The surface of the truncated cone can be split into 2 flat pieces and a curved part.

c) The volume of a cone is 1/3 * base * height

Despite the hints given, i’m still not sure where to start. Would really appreciate some guidance.

How can I get the full content of a PHPUnit test truncated response?

I’m writing a Functional test (extending BrowserTestBase) for a Drupal REST resource. My resource works fine in real life, but the test (running with –verbose and –debug options) throws a server error

...resulted in a '500 500 Service unavailable (with message)' response: The website encountered an unexpected error. Please try again later.</br></br><em class="placeholder">Drupal\Component\P (truncated...)

This happens when I make the request, before I can try to catch it in an assertion. I’m pretty sure that truncated output has the information I need to solve this, but I’m having no luck getting to it. Drupal console docs say there’s a test:run command but when I try that (v1.8.0), it tells me that’s not a valid command name. I’ve tried running my test through the debugger but no help there, either.

Is there any way I can get to see what’s in the truncated part of the response?

URLs getting truncated in QuarkXpress 2018 running on macOS Mojave

I’ve just noticed a problem with QuarkXPress 2018 that may or may not be related to macOS Mojave.

Sometimes when I add a new hyperlink or edit an existing one, the full URL path is being truncated and this breaks the link.

Has anyone else experiencing the same? If yes, did they manage to fix it?