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)
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.