Cannot Find Or Open File ............

[Jack@dba]

HI Team,

Today we received so many errors in our database log files saying file not exists.
When i checked 2 hours back no files are present in directory but after checking some times files are available.
This is first time we are receiving this alerts.

I not able to understand why this errors are reflecting?
Progress version : 9.1e
OS: Aix 5.3

Fyi....... previously when I checked there is no data inside this path.


/protmp/y280hcr: ls -lrt

total 24

-rw-r--r-- 1 y280hcr prouser 791 Jun 28 07:09 log1660.log

-rw-r--r-- 1 y280hcr prouser 65 Jun 28 07:09 cim1660_load.d

-rw-r--r-- 1 y280hcr prouser 1425 Jun 28 07:24 woisslabel.txt

04:58:15 SRV 26: Logout usernum 978, userid fbarrigasanto, on . (739)
04:58:22 SRV 26: Login usernum 978, userid y281mmc, on p5lp5 36. (742)
04:58:35 SRV 26: ** Cannot find or open file /protmp/y281mmc/[11[A.db, errno = 2. (43)
04:58:35 SRV 26: Previous message sent on behalf of user 978. (5512)
05:00:01 SRV 26: Login usernum 977, userid pgresdba, on p5lp5 batch. (742)
05:00:03 SRV 26: Logout usernum 977, userid pgresdba, on p5lp5 batch. (739)
05:02:33 SRV 16: Logout usernum 1015, userid y287jxr, on p5lp5 119. (739)
05:02:35 SRV 16: Login usernum 1015, userid y287jxr, on p5lp5 119. (742)
05:02:42 SRV 16: ** Cannot find or open file /protmp/y287jxr/[11[A.db, errno = 2. (43)
05:02:42 SRV 16: Previous message sent on behalf of user 1015. (5512)
05:02:52 SRV 16: Logout usernum 1015, userid y287jxr, on p5lp5 119. (739)
05:02:54 SRV 16: Login usernum 1015, userid y287jxr, on p5lp5 119. (742)
05:03:00 SRV 16: ** Cannot find or open file /protmp/y287jxr/[11[A.db, errno = 2. (43)
05:03:00 SRV 16: Previous message sent on behalf of user 1015. (5512)
05:15:00 SRV 26: Login usernum 977, userid pgresdba, on p5lp5 batch. (742)
05:15:02 SRV 26: Logout usernum 977, userid pgresdba, on p5lp5 batch. (739)
05:18:58 SRV 26: Login usernum 977, userid y280mgl, on p5lp5 123. (742)
05:19:02 SRV 26: ** Cannot find or open file /protmp/y280mgl/[11[A.db, errno = 2. (43)
05:19:02 SRV 26: Previous message sent on behalf of user 977. (5512)
05:25:53 SRV 26: Login usernum 976, userid fortiz, on MHLCTXQAD03A. (742)
05:25:59 SRV 27: Started on port 13268 using tcp, pid 372052. (5646)
05:26:00 SRV 27: Unable to open /progdata/prd/reydb1/prdrey.lic, errno = 13. (1295)
05:26:00 SRV 27: Login usernum 975, userid y281sxn, on p5lp5 108. (742)
05:26:08 SRV 27: ** Cannot find or open file /protmp/y281sxn/[11[A.db, errno = 2. (43)
05:26:08 SRV 27: Previous message sent on behalf of user 975. (5512)
05:26:29 SRV 27: Login usernum 974, userid y280pgv, on p5lp5 46. (742)
05:26:39 SRV 27: ** Cannot find or open file /protmp/y280pgv/[11[A.db, errno = 2. (43)
05:26:39 SRV 27: Previous message sent on behalf of user 974. (5512)
05:28:10 SRV 27: Login usernum 973, userid y280mgl, on p5lp5 124. (742)
05:28:18 SRV 27: ** Cannot find or open file /protmp/y280mgl/[11[A.db, errno = 2. (43)
05:28:18 SRV 27: Previous message sent on behalf of user 973. (5512)
05:29:05 SRV 27: Login usernum 972, userid maramos, on mhlctxqad06a. (742)
05:30:00 SRV 27: Login usernum 971, userid pgresdba, on p5lp5 batch. (742)
05:30:01 SRV 28: Started on port 13270 using tcp, pid 543068. (5646)
05:30:02 SRV 27: Logout usernum 971, userid pgresdba, on p5lp5 batch. (739)
05:30:02 SRV 28: Unable to open /progdata/prd/reydb1/prdrey.lic, errno = 13. (1295)
05:30:02 SRV 28: Login usernum 971, userid pgresdba, on p5lp5 batch. (742)
05:30:02 SRV 28: Logout usernum 971, userid pgresdba, on p5lp5 batch. (739)
05:32:37 SRV 27: Login usernum 971, userid y281mmc, on p5lp5 101. (742)
05:32:45 SRV 27: ** Cannot find or open file /protmp/y281mmc/[11[A.db, errno = 2. (43)

 

[Rob Fitzpatrick]

This looks like a client issue, not a database issue.

Error 43, errno 2 means the file cannot be opened because it does not exist. The directory name "protmp" suggests that Progress client temp files are written here, and based on the login messages it appears the various y###xxx subdirectories are for individual users. I don't know what "[11[A.db" is but it isn't a legal Progress database name. So I don't know what these .db files actually are and I can't guess why they're missing. Wild guess: maybe some code is trying to programmatically construct a path to a database and then connect to it, and it mistakenly constructed "[11[A" instead of the correct name. But if the directory contents are what you say they are, there is no .db file to find in such a location anyway. Maybe the paths are wrong too?

This speculation isn't much use. This seems like a question for someone who knows the application.