Getting error 'the data source does not define the expected fields' when running a stream in a job in Collaboration and Deployment Services.

Problem

Trying to run a simple stream inside a job. The stream uses an ODBC data source and runs fine on the client (desktop) version of the Modeler but after I store the stream in the Repository, insert it in a job and run the job, I get a failure message: 'The data source does not define the expected fields.' The stream consists of three nodes: a data source, a Select node (that simply grabs the first ten rows) and a table to show the results. Error in Deployment Manager client log: Stream execution started The data source does not define the expected fields Stream execution complete, Elapsed=5.55 sec, CPU=1.47 sec Execution was interrupted The data source does not define the expected fields com.spss.psapi.session.SessionException: The data source does not define the expected fields at com.spss.clementine.psapi.task.TaskManager.execute(Unknown Source) at com.spss.clementine.psapi.task.SessionTaskManager.execute(Unknown Source) at com.spss.clementine.psapi.session.SessionImpl.run(Unknown Source) at com.spss.psapi.ra.internal.PSAPIManagedConnection.run(PSAPIManagedConnection.java:841) at com.spss.psapi.ra.internal.SessionImpl.run(SessionImpl.java:336) at com.spss.work.clementine.ClementineExecutor.executeStream(ClementineExecutor.java:253) at com.spss.work.clementine.ClementineExecutor.doExecute(ClementineExecutor.java:170) at com.spss.work.clementine.ClementineExecutor.execute(ClementineExecutor.java:160) at com.spss.process.internal.execution.WorkEvent.execute(WorkEvent.java:146) at com.spss.process.internal.execution.Event.run(Event.java:226) at com.spss.process.internal.execution.MonitorUtils.runEvent(MonitorUtils.java:622) at com.spss.process.internal.execution.ejb.ProcessEventMDB.runEvent(ProcessEventMDB.java:81) at com.spss.process.internal.execution.ejb.ProcessEventMDB.onMessage(ProcessEventMDB.java:65) at sun.reflect.GeneratedMethodAccessor737.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.invocation.Invocation.performCall(Invocation.java:359) at org.jboss.ejb.MessageDrivenContainer$ContainerInterceptor.invoke(MessageDrivenContainer.java:495) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158) at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63) at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121) at org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:173) at org.jboss.ejb.plugins.MessageDrivenTxInterceptorBMT.invoke(MessageDrivenTxInterceptorBMT.java:47) at org.jboss.ejb.plugins.MessageDrivenInstanceInterceptor.invoke(MessageDrivenInstanceInterceptor.java:116) at org.jboss.ejb.plugins.RunAsSecurityInterceptor.invoke(RunAsSecurityInterceptor.java:109) at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138) at org.jboss.ejb.MessageDrivenContainer.internalInvoke(MessageDrivenContainer.java:402) at org.jboss.ejb.Container.invoke(Container.java:960) at org.jboss.ejb.plugins.jms.JMSContainerInvoker.invoke(JMSContainerInvoker.java:987) at org.jboss.ejb.plugins.jms.JMSContainerInvoker$MessageListenerImpl.onMessage(JMSContainerInvoker.java:1287) at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:266) at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:891) at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:170) at org.jboss.mq.SpySession.run(SpySession.java:323) at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:194) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:743) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.RuntimeException: com.spss.psapi.PredictiveServerException: The data source does not define the expected fields at com.spss.work.clementine.ClementineExecutor.executionFeedback(ClementineExecutor.java:579) at com.spss.clementine.psapi.task.TaskManager.executionFeedback(Unknown Source) at com.spss.clementine.psapi.task.FeedbackEventHelper.raiseExecutionFeedbackEvent(Unknown Source) at com.spss.clementine.psapi.task.FeedbackEventHelper.diagnosticReceived(Unknown Source) at com.spss.clementine.component.Stream.report(Unknown Source) at com.spss.clementine.component.StreamExecutionJob.validate(Unknown Source) at com.spss.clementine.component.StreamExecutionJob.validate(Unknown Source) at com.spss.clementine.component.StreamExecutionJob.parallelExecute(Unknown Source) at com.spss.clementine.component.StreamExecutionJob.execute(Unknown Source) at com.spss.clementine.component.StreamExecutionJob.execute(Unknown Source) at com.spss.clementine.component.Stream.execute(Unknown Source) at com.spss.clementine.component.Stream.execute(Unknown Source) at com.spss.clementine.session.ExecutionManager.executeNodes(Unknown Source) at com.spss.clementine.session.ExecutionManager.executeNodes(Unknown Source) at com.spss.clementine.session.ExecutionManager.executeStream(Unknown Source) at com.spss.clementine.session.ExecutionManager.access$100(Unknown Source) at com.spss.clementine.session.ExecutionManager$2.execute(Unknown Source) at com.spss.clementine.session.ExecutionManager$ExecutionTask.work(Unknown Source) at com.spss.clementine.session.util.Task.callWork(Unknown Source) at com.spss.clementine.session.util.DefaultTaskHarness.taskWork(Unknown Source) at com.spss.clementine.session.util.DefaultTaskHarness$1.run(Unknown Source) ... 1 more Caused by: com.spss.psapi.PredictiveServerException: The data source does not define the expected fields ... 22 more