This content has been marked as final. Show 6 replies
Is this your first Batch validation execution?.
2. Are you the only one having this problem?.
3. Have you logged on as another user and executed Batch validation?. What happened?.
This is a problem with your PSUB process.
To confirm that, you need to submit a job other than batch validation i.e try compiling a procedure or creating a screen layout. if it does not work of hangs, please note the STATUS of the job.
4. Try stopping the psub process and starting it again. Then resubmit the job.
1. What version of OC are you using?.
2. What OS are you using?.
3. And you want answers to your questions with half stories?. Take some pains to give all the information when you want answers from people. Show that you are interested and NOT LAZY.
Do exactly as I have stated in my previous post above.
a. TMS validation takes place first in the BV. Then the derivation procedures and then validation procedures. The batch validation may send a message saying successful even though it has failed.
In your case, the PSUB process is hanging or stalled because the job is entered, submitted, then started but not completed to success or failure. The entire process does not take too long unless there are many studies and tremendous amount of data. But it should all be done within the hour or less.
Thanks for your reply. I am new in OC and I couldn't give details because I didn't know where I have to search for the details, also I haven't an oracle access which allows me to give more information.
My aim was to find someone who has have the same symptoms and perhaps a quick solution because we are always working in emergency here.
Second thing is that I couldn't get a quick answers or quick questions in this forum, everytime I post a message I didn't get quick reply which let me to give you more information. It doesn't matter!
The problem was that the DBA has not done a analyze table at all, so our first BVS took a long time, because we have a lot of data and a lot of updates on the response table. So before doing the analyze tables the BVS run for two days without finishing the execution so we had to stop it, after the analyze table the BVS took 18 hours, after which we decided to run a BVS every night this will handle a little quantity of data every night and this take now 5 minutes and at least 1 hour.
So before a first BVS you have to run some maintenance scripts on the database to make it ready for the job, then you have to wait several hours for this first run.
All I can tell you is this. If you want an answer to your questions, you have to provide all the details. If you cannot provide the details and you want a QUICK ANSWER like you are God's gift to this forum, then you need to call Oracle Support QUICK!!. In fact, you should hurry. Nobody will answer your questions and I surely will not. This is a small piece of advice.