File locking?

[sylnau]

Hello,

I'm using PowerHouse 8.41F Build 3059.15
On a Windows 2003 Enterprise server with 8gb of RAM.

Sometimes when two QTP access the same file (witch is DISAM type), I have those two error message:

Data access error.
  File: $env/filename

System error 13. Permission denied
  File: $env/filename

I'm using the command SET LOCK RECORD UPDATE in each of my program.

Anybody have an idea?

Thank you,
SYLNAU

[MFGF]

Is there a chance that each QTP job could be trying to update the same record at the same moment?  Are they reading from this file and writing back to the same file, or is the file you are writing to different from those in the ACCESS statement?

MF.

[sylnau]

Is there a chance that each QTP job could be trying to update the same record at the same moment?  Are they reading from this file and writing back to the same file, or is the file you are writing to different from those in the ACCESS statement?

MF.

I have the SET LOCK RECORD UPDATE option in my QTP so that won't suppose to be a problem.
It is supposed to lock the file and wait to start the other QTP if they are talking to the same record.

[MFGF]

If you are writing to a file that you are referencing in your ACCESS statement, QTP will need to use a scratch file for processing.  If this is the case, is it possible that the error is being produced by lack of disk space to accommodate two scratch files at the same time?

MF.

[sylnau]

If you are writing to a file that you are referencing in your ACCESS statement, QTP will need to use a scratch file for processing.  If this is the case, is it possible that the error is being produced by lack of disk space to accommodate two scratch files at the same time?

MF.

I have 125gb free on a 195gb drive. I don't think this is the problem.
I'm not always getting this problem on the same files.
I never had this problem while PowerHouse was running on SCO Unix.
I'm having this problem since I migrate to the Windows 2003 Ent server.

Always the same error:
Data access error.
  File: $ENV/filename

System error 13.  Permission denied
  File $ENV/filename

Thanks for the reply... if you have another idea, please let me know.

[sylnau]

Hello,

I have more information.

PowerHouse is install on a Windows 2003 Ent. server.
I'm using Telnet and the software Reflection to open a session on PowerHouse.
Anybody know if a Telnet connection drop while a Quick is open, is the file use by the Quick stay open?
Is there a services in PowerHouse that I can restart at night to be sure that all the connection to my files are close?

It looks like the file is open too many times.

Thanks!

[sylnau]

Any idea?

[sylnau]

So, any idea?

[sylnau]

Still the same issue today, but with a QUIZ (witch I though would be impossible):

*E* Data access error. (FILENAME)?                                           
*E* System error 13. Permission denied (FILENAME)?

Still no solution, still no help.

Anybody has an idea?

[MFGF]

It sounds suspiciously like something else may be applying file locks.  Are there any other systems accessing the same data files?

[sylnau]

It sounds suspiciously like something else may be applying file locks.  Are there any other systems accessing the same data files?

No

We are using an IBMSystem X 3650 server and a IBM DS3200 SAN... so we are all IBM.
And PowerHouse is supported on Windows 2003 Server.

And there is no Antivirus on the server.

[MFGF]

All I can suggest is that you raise a PMR request with IBM support.  You don't appear to have any other obvious contributing factors, but the IBM experts may be able to suggest other avenues to explore.

Regards,

MF.