Mail merge error in SageCRM 2018 R3

SOLVED

Hi.

I'm reaching out to the community in hopes that someone can tell me why I'm unable to run this particular mail merge.

Before I begin, the mail merge functions works fine with another query that I have.
This is a new query. It's quite an easy one. Not much to it actually.

CREATE VIEW vNewMemberCert
AS
SELECT        dbo.Company.Comp_CompanyId, dbo.NewMemberCert.Comp_IdCust, dbo.NewMemberCert.TEXTLINE, dbo.NewMemberCert.comp_plaque, dbo.Company.Comp_PrimaryUserId, dbo.Company.Comp_SecTerr, dbo.Company.Comp_Name
FROM            dbo.NewMemberCert INNER JOIN
                         dbo.Company ON dbo.NewMemberCert.Comp_CompanyId = dbo.Company.Comp_CompanyId AND dbo.NewMemberCert.Comp_IdCust = dbo.Company.Comp_IdCust

I've set the logs to 5 (max) to try to figure out what it is that its hanging on... and this is where I don't know what to do next.

Here is the error from the log file:

May 1 2020 0:06:17.528	12452	14028	5	Mail Merge Fail: <diagnoses><errorMessages><errorMessage><info>java.lang.NullPointerException

	at com.sage.crm.core.async.task.MailMergeTask.getEntityFields(MailMergeTask.java:565)

	at com.sage.crm.core.async.task.MailMergeTask.setColumnsForSelect(MailMergeTask.java:613)

	at com.sage.crm.core.async.task.MailMergeTask.getData(MailMergeTask.java:661)

	at com.sage.crm.core.async.task.MailMergeTask.generateJsonFileData(MailMergeTask.java:380)

	at com.sage.crm.core.async.task.MailMergeTask.execute(MailMergeTask.java:157)

	at com.sage.crm.core.async.TaskProcessor.process(TaskProcessor.java:82)

	at sun.reflect.GeneratedMethodAccessor809.invoke(Unknown Source)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

	at java.lang.reflect.Method.invoke(Method.java:498)

	at org.springframework.expression.spel.support.ReflectiveMethodExecutor.execute(ReflectiveMethodExecutor.java:113)

	at org.springframework.expression.spel.ast.MethodReference.getValueInternal(MethodReference.java:102)

	at org.springframework.expression.spel.ast.MethodReference.access$000(MethodReference.java:49)

	at org.springframework.expression.spel.ast.MethodReference$MethodValueRef.getValue(MethodReference.java:347)

	at org.springframework.expression.spel.ast.CompoundExpression.getValueInternal(CompoundExpression.java:88)

	at org.springframework.expression.spel.ast.SpelNodeImpl.getTypedValue(SpelNodeImpl.java:131)

	at org.springframework.expression.spel.standard.SpelExpression.getValue(SpelExpression.java:330)

	at org.springframework.integration.util.AbstractExpressionEvaluator.evaluateExpression(AbstractExpressionEvaluator.java:169)

	at org.springframework.integration.util.MessagingMethodInvokerHelper.processInternal(MessagingMethodInvokerHelper.java:317)

	at org.springframework.integration.util.MessagingMethodInvokerHelper.process(MessagingMethodInvokerHelper.java:155)

	at org.springframework.integration.handler.MethodInvokingMessageProcessor.processMessage(MethodInvokingMessageProcessor.java:93)

	at org.springframework.integration.handler.ServiceActivatingHandler.handleRequestMessage(ServiceActivatingHandler.java:89)

	at org.springframework.integration.handler.AbstractReplyProducingMessageHandler.handleMessageInternal(AbstractReplyProducingMessageHandler.java:102)

	at org.springframework.integration.handler.AbstractMessageHandler.handleMessage(AbstractMessageHandler.java:127)

	at org.springframework.integration.endpoint.PollingConsumer.handleMessage(PollingConsumer.java:129)

	at org.springframework.integration.endpoint.AbstractPollingEndpoint.doPoll(AbstractPollingEndpoint.java:272)

	at org.springframework.integration.endpoint.AbstractPollingEndpoint.access$000(AbstractPollingEndpoint.java:58)

	at org.springframework.integration.endpoint.AbstractPollingEndpoint$1.call(AbstractPollingEndpoint.java:190)

	at org.springframework.integration.endpoint.AbstractPollingEndpoint$1.call(AbstractPollingEndpoint.java:186)

	at org.springframework.integration.endpoint.AbstractPollingEndpoint$Poller$1.run(AbstractPollingEndpoint.java:353)

	at org.springframework.integration.util.ErrorHandlingTaskExecutor$1.run(ErrorHandlingTaskExecutor.java:55)

	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

	at java.lang.Thread.run(Thread.java:748)

</info></errorMessage></errorMessages></diagnoses>
May 1 2020 0:06:17.529	12452	14028	5	TWebServerMailMergeProcessing.processing finished

The only thing that I can see in this error code is the at sun.reflect.GeneratedMethodAccessor809.invoke(Unknown Source)&#13;
Which tells me something isn't quite right.

I'm merging but 2 fields:

1) dbo.NewMemberCert.TEXTLINE    and    2) dbo.Company.Comp_Name

I tried only grabbing the Comp_name - but to no avail.
I tried refreshing the METAData several times now.

Hopefully someone can tell me what I can try to get around this problem.

Thanks,

Steph L.

Parents Reply Children
No Data