Probelm While Runing the QS Job

divine · Post by **divine** » Wed Apr 26, 2006 11:17 pm

Hi,
I am facing a problem in QS. In the current project there was change in length of a column. Accordingly I have changed the length in the QS and give the proper position. Than again I have deployed the the QS job and while I am trying to run the QS job in the QS environment I got the follwoing Error.

Error exec: /Projects/FP1/Logs/MATCREHI.MTC.StepFREQLDA.log:freqld(12956):27.04.2006 06:51:32 (MSG_vopen.c:10; vopen.c:437) ERROR: opening \Projects\FP1\Data\RESIGLOB
/Projects/FP1/Logs/MATCREHI.MTC.StepFREQLDA.log:freqld(12956):27.04.2006 06:51:32 (MSG_vopen.c:13; vopen.c:627) ERROR: Unable to open file \Projects\FP1\Data\RESIGLOB
/Projects/FP1/Logs/MATCREHI.MTC.StepFREQLDA.log:freqld(12956):27.04.2006 06:51:32 (MSG_vutils.c:13; vutils.c:1287) ERROR: vexit status=1
/Projects/FP1/Logs/MATCREHI.Step001.log:ERROR: freqld FAILED (1)

Op Failed Step001 (1)
EXITVAL=1

AL=1

And the Log file is as follows

pid=8876
*** MATCHING /Projects/FP1/Controls/UNDUPLHR ***
=========== PREPARE =============
=========== dcomp ============
Thu Apr 27 06:34:01 EDT 2006
Thu Apr 27 06:34:01 EDT 2006
=========== mcomp ============
Thu Apr 27 06:34:01 EDT 2006
Thu Apr 27 06:34:01 EDT 2006
=========== freqld ============
Thu Apr 27 06:34:01 EDT 2006
Thu Apr 27 06:34:01 EDT 2006

ERROR: freqld FAILED (1)

Regards

ray.wurlod · Post by **ray.wurlod** » Thu Apr 27, 2006 12:48 am

The problem is reported as an inability to open a file called \Projects\FP1\Data\RESIGLOB (I must assume here that \Projects is your Master Project Directory).

Is this disk full? Do you have appropriate permissions to the parent folder (\Projects\FP1\Data)? Does the RESIGLOB file need to have been emplaced by an earlier job?

Did you change the positions of all subsequent fields in the data file definition (for example by checking the "automatically shift fields" check box) when you changed the field in question?

divine · Post by **divine** » Thu Apr 27, 2006 3:55 am

Dear Roy,
Being not a premimum member I ma not able to see your reply. Yes my Projects is in the Master Project Directory.

Thanks
Biswajit

ray.wurlod · Post by **ray.wurlod** » Thu Apr 27, 2006 5:42 am

For less than $1 per week you can be a premium member.

divine · Post by **divine** » Thu Apr 27, 2006 11:33 pm

Dear Roy,
Yes I have change the data file defination of one file and accordingly I have change the position.

Yes the RESIGLOB file need to have been emplaced by an earlier job from datastage job. In the Datastage job I am using QS plug-in and I call an after subroutine in the job and I am using the following dos command.
bash -c "C:/Projects/FP1/Scripts/MATCHLHR.stp -ipe.env C:/Projects/FP1/Scripts/MATCHLHR.env -ipe.env C:/Projects/FP1/ipe.env.sh" > %LOGFILE% 2>&1

But while I am running the job from Datastage I got the following error.

"UndupOfEmployeeRecords..QualityStage_0: Failed to open QSRT connection: check qsrtmngr is running, job is deployed" And I have checked the for the service and it is running also.

And in Quality Satge I do not get any error if I deployed it but get error while running.

And I also place one old RESIGLOB file in the directory and the data file defination is same as earlier only I have change data file defination for other file and change the position.

Hope to get a reply.

Thanks
Biswajit

ray.wurlod · Post by **ray.wurlod** » Fri Apr 28, 2006 12:40 am

You did not mention originally that you are using a QualityStage plug-in stage from DataStage. Otherwise I would have asked you to check qsrtmngr as well as qsserv processes.

For this combination to work, the qsrtmngr process must be running. If you like, qsrtmngr is the "listener" - like a real-time interface between DataStage and QualityStage.

Do check whether the qsrtmngr process is not running. If it is not, log in as qsadm and start it.

divine · Post by **divine** » Fri Apr 28, 2006 1:40 am

Dear Roy,

I have checked and the service is running. But when I am ruuning the job from QS environment I am getting the Following Problem.

Error exec: /PROJECTS/FPTEST/Logs/GLODEDUP.Step001.log:ERROR: freqld FAILED (1)
/PROJECTS/FPTEST/Logs/GLODEDUP.UND.StepFREQLDA.log:freqld(3740):4/28/2006 1:07:39 PM (MSG_vopen.c:10; vopen.c:437) ERROR: opening \PROJECTS\FPTEST\Data\EMPNOUNI
/PROJECTS/FPTEST/Logs/GLODEDUP.UND.StepFREQLDA.log:freqld(3740):4/28/2006 1:07:39 PM (MSG_vopen.c:13; vopen.c:627) ERROR: Unable to open file \PROJECTS\FPTEST\Data\EMPNOUNI
/PROJECTS/FPTEST/Logs/GLODEDUP.UND.StepFREQLDA.log:freqld(3740):4/28/2006 1:07:39 PM (MSG_vutils.c:13; vutils.c:1287) ERROR: vexit status=1

Op Failed Step001 (1)
EXITVAL=1

AL=1

I believe once I am able to run the job in QS environment than I can able to call the QS job from my Datastage job.

Regards
Biswajit

jhmckeever · Post by **jhmckeever** » Fri Apr 28, 2006 3:47 am

Hi Biswajit,

I'm assuming that the error messages you're posting are those presented by the QS client GUI.

Have you had a look at the Logs/{jobname}.Step001.log file? This normally contains more useful debugging information.

divine · Post by **divine** » Fri Apr 28, 2006 5:02 am

Yes, the error message are presented by the QS client GUI. I have checked the log file and it shows the following error
1.
pid=480
*** MATCHING /PROJECTS/FP1/Controls/MATCHLHR ***
=========== PREPARE =============
=========== dcomp ============
Fri Apr 28 13:37:26 IST 2006
Fri Apr 28 13:37:26 IST 2006
=========== dcomp ============
Fri Apr 28 13:37:26 IST 2006
Fri Apr 28 13:37:26 IST 2006
=========== mcomp ============
Fri Apr 28 13:37:26 IST 2006
Fri Apr 28 13:37:26 IST 2006

ERROR: mcomp FAILED (4)

egrep: write error on standard output: The pipe is being closed.
egrep: write error on standard output: The pipe is being closed.

2.
pid=3076
*** MATCHING /PROJECTS/FP1/Controls/UNDUPLHR ***
=========== PREPARE =============
=========== dcomp ============
Fri Apr 28 13:37:59 IST 2006
Fri Apr 28 13:37:59 IST 2006
=========== mcomp ============
Fri Apr 28 13:37:59 IST 2006
Fri Apr 28 13:37:59 IST 2006
=========== freqld ============
Fri Apr 28 13:37:59 IST 2006
Fri Apr 28 13:37:59 IST 2006

ERROR: freqld FAILED (1)

Regards

Biswajit

divine · Post by **divine** » Mon May 01, 2006 11:13 pm

HI All,

Any updates to this problem please.

divine · Post by **divine** » Tue May 02, 2006 12:32 am

Hi
Now I am getting this error. Please help me as it is production issue.

Error exec: /PROJECTS/FP1/Logs/MATCHLHR.MTC.StepMCOMP.log:mcomp(2132):5/2/2006 12:01:58 PM (MSG_mcomp.c:27; mcomp.c:458) ERROR: Variable 0.9 could not be found in data dictionary
/PROJECTS/FP1/Logs/MATCHLHR.MTC.StepMCOMP.log:mcomp(2132):5/2/2006 12:01:58 PM (MSG_mcomp.c:35; mcomp.c:1185) ERROR: Invalid variable B name [0.9]
/PROJECTS/FP1/Logs/MATCHLHR.MTC.StepMCOMP.log:mcomp(2132):5/2/2006 12:01:58 PM (MSG_mcomp.c:99; mcomp.c:3181) ERROR: Error occurred in line 10 which follows ....
/PROJECTS/FP1/Logs/MATCHLHR.MTC.StepMCOMP.log:mcomp(2132):5/2/2006 12:01:58 PM (MSG_mcomp.c:27; mcomp.c:458) ERROR: Variable 0.9 could not be found in data dictionary
/PROJECTS/FP1/Logs/MATCHLHR.MTC.StepMCOMP.log:mcomp(2132):5/2/2006 12:01:58 PM (MSG_mcomp.c:35; mcomp.c:1185) ERROR: Invalid variable B name [0.9]
/PROJECTS/FP1/Logs/MATCHLHR.MTC.StepMCOMP.log:mcomp(2132):5/2/2006 12:01:58 PM (MSG_mcomp.c:99; mcomp.c:3181) ERROR: Error occurred in line 11 which follows ....
/PROJECTS/FP1/Logs/MATCHLHR.MTC.StepMCOMP.MCOMP.

Regards
Biswajit

ray.wurlod · Post by **ray.wurlod** » Tue May 02, 2006 12:40 am

I think this is unrelated to the earlier problem and possibly deserves a separate thread. The message Variable 0.9 could not be found in data dictionary suggests that you have - whether advertently or not - created a field name of "0.9". Because it is from B this suggests that it is in your second, or B, file. However, there is no field of that name in the data dictionary for that file.

roy · Post by **roy** » Tue May 02, 2006 1:43 am

Dear Biswajit,
I would like to point out that Ray is helping you and not Roy.

divine wrote:Dear Roy,
Being not a premimum member I ma not able to see your reply. Yes my Projects is in the Master Project Directory.

Thanks
Biswajit

divine · Post by **divine** » Tue May 02, 2006 6:07 am

HI
In QS Environment if I uncheck the wait for completion than I do not get any error while running the job there. So Is it necessary to check the box and secondly after running the job in QS environment I close the application and run the datastage job where I have used the QS plug in. It aborts by showing the following error.

"Failed to open QSRT connection: check qsrtmngr is running, job is deployed".

So where I need to check and what I need to do get out of this problem.

If any one has come accross this kind of problem and have the answer please provide.

Thanks and Regards

Biswajit

ray.wurlod · Post by **ray.wurlod** » Tue May 02, 2006 6:12 am

What exactly IS your problem? That's the third different problem you've posted against this thread.

If qsrtmngr is not running then you won't see it in a ps report.

Code: Select all

ps -ef | grep qsrtmngr | grep -v grep