Sometimes While executing the job in DS4.0, I am getting a dialog box(attached) with the below error.
Error: Could not execute the Job. Error returned was 2. Message is:
And I am facing weird issue in memorycache. When I am executing the job, In one dataflow a query transformation is consists of three joins for four source tables in WHERE clause. And in trace log, caches is falling into Cartesian product for that query transform and rising the records count to billions and never completed execution of job. But the same code is perfectly executing in Ds3.1 version.
Can anyone help me on this please. Thanks in advance…
Are you really using DS 4.0? I would step up to a more current version, like 4.2.
In early versions of 4.0 the migration of Dataflows had a problem where it would incorrectly migrate the join expressions. Go back to your Dataflow and verify the join expressions.
Yes, we are using DS4.0. I verified all the joins and looks good. But when I implement NOcache or Join ranks for the huge tables then the job is getting executed without any issues.
But the attached error dialog box is getting every time when I am trying to execute the job.
'Error: Could not execute the Job. Error returned was 2. Message is: ’
Replicate the Dataflow and change the source to a SQL transform. See if that completely resolves the issue. If it does then it sounds like the job server is processing the joins instead of the database.
(BOB member since 2007-09-12)