parallel job converted to server job automatically

tejaswini · Post by **tejaswini** » Thu May 08, 2008 5:05 am

Hi,

I had a parallel job. but some how that got converted to server job.
Is there any way to get back the original parallel job?

thanks

ArndW · Post by **ArndW** » Thu May 08, 2008 5:09 am

I know of no way to convert a PX job to a server job automatically. A "Save as" won't work. Does the server job actually compile & run?

ray.wurlod · Post by **ray.wurlod** » Thu May 08, 2008 6:00 am

What symptom suggests that the job is a server job?

Have you been hacking in the Repository, particularly DS_JOBS table?

tsn · Post by **tsn** » Thu May 08, 2008 6:13 am

If you have backup you can reterive the parallel job, otherwise I don't think it is possible. surprise to hear that parallel job was converted automatically to server job.

tejaswini · Post by **tejaswini** » Thu May 08, 2008 6:21 am

the icon has changed like server job

ArndW · Post by **ArndW** » Thu May 08, 2008 7:09 am

What about the contents of the job showing as "server"? Does it compile? Does it run? Does it contain PX or Server stages?

keshav0307 · Post by **keshav0307** » Thu May 08, 2008 8:42 am

i was having the same problem.
your project may corrupt anytime.
not sure, if REINDEX will help.
you may think of re creating the AUDIT logs also.

tejaswini · Post by **tejaswini** » Mon May 12, 2008 3:21 am

keshav0307 wrote:i was having the same problem.
your project may corrupt anytime.
not sure, if REINDEX will help.
you may think of re creating the AUDIT logs also.

Please tell me what do u mean by 'REINDEX' and how will i do it?

ray.wurlod · Post by **ray.wurlod** » Mon May 12, 2008 6:52 am

Can you please execute the following query from Administrator client's command window?

Code: Select all

SELECT * FROM DS_JOBS WHERE NAME = '<<Job Name>>';