Page 1 of 1
parallel job converted to server job automatically
Posted: Thu May 08, 2008 5:05 am
by tejaswini
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
Posted: Thu May 08, 2008 5:09 am
by ArndW
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?
Posted: Thu May 08, 2008 6:00 am
by ray.wurlod
What symptom suggests that the job is a server job?
Have you been hacking in the Repository, particularly DS_JOBS table?
Posted: Thu May 08, 2008 6:13 am
by tsn
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.
Posted: Thu May 08, 2008 6:21 am
by tejaswini
the icon has changed like server job
Posted: Thu May 08, 2008 7:09 am
by ArndW
What about the contents of the job showing as "server"? Does it compile? Does it run? Does it contain PX or Server stages?
Posted: Thu May 08, 2008 8:42 am
by keshav0307
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.
Posted: Mon May 12, 2008 3:21 am
by tejaswini
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?
Posted: Mon May 12, 2008 6:52 am
by ray.wurlod
Can you please execute the following query from Administrator client's command window?
Code: Select all
SELECT * FROM DS_JOBS WHERE NAME = '<<Job Name>>';