Excel Project Is Unviewable
Project Locked Project Is Unviewable Access System
Access Vba Project Unviewable

Troubleshooting

Tools - VBA Project Properties Also pops the same 'Project Locked' 'Project is unviewable' msgbox.:(If there is a password I can guess it but I'm never prompted for one. Nor do any settings hint it's protected. I recently needed to unlock an Access VBA Project for which my client had lost the password. The project you are attempting to view is locked. Refer to documentation for the host application for Help on how to make the project viewable. For additional information, select the item in question and press F1 (in Windows) or HELP (on the Macintosh). Synonyms for secret include mystery, puzzle, enigma, conundrum, paradox, riddle, problem, question, mystification and poser. Find more similar words at wordhippo.com! When I right-click on a module in the Objects column, 'Design View' is greyed out. When I go to Database Tools-Visual Basic, double-clicking on any object brings up a pop-up saying 'Project Locked: Project is unviewable'. When I click Help, just the regular table of contents comes.

Problem

'ACCESS DENIED: Project currently locked. This project is currently locked by the Administrator. Try again later or see your Administrator' error message opening Designer/Director

Cause

Access vba project locked project is unviewable

Either :
1 - lack of disk space :
(particularly if you are able to connect to a project located on another file system)
2 - network quality :
(an Administrator session was opened and during that session was a network outage)
3 - project or sql catalog corruption :
(rare)
4 - lock parameter overflow :
(this case is when you fullfill all the three following conditions
- symptom happens in all projects
- 'LIST.READU EVERY' shows no lock
- you have the right number of users allowed by your license to connect simultaneously to DataStage
In this case the cause of the problem is that users opened so many designer, manager, director sessions that the lock table got full !
So the lock displayed in the error message is not a real lock despite what indicated in the error message.)
e.g : There are 4 developpers but each open a dozen of sessions.

Excel Project Is Unviewable

Diagnosing The Problem

- The main question is : does it happen to all projects ?
- When the problem occurs, outputs of LIST.READU EVERY command can help to determine
involved locks. To do so, login with administrator's privilege in DataStage Administration and type LIST.READU EVERY (in upper case letters, without quotes) in 'DataStage Administration' > 'Project properties > Command (you may need to press the 'Execute' button several times until you get button 'Close' and do several screenshots

Resolving The Problem

1 - lack of disk space :
free disk space
2 - network quality :
check with your network administrator, an audit may be necessary
3 - project or sql catalog corruption
contact Information Server support
4 - lock parameter overflow :
Raise GLTABSZ and RLTABSZ both to 200 and see if symptoms happen less.
Go to dshome directory, backup and edit uvconfig file with 'vi' (or 'Notepad')
Modify GLTABSZ and RLTABSZ
Save the file.
Then open a command console and go to DSEngine (you MUST be exactly in that directory) and from there type :
./bin/uvregen (or .binuvregen)
this will generate a binary file which will be read by Information Server after you stop start engine.
Be careful to stop/start DataStage engine when there is no client connected and no job running.
N.B : There is no need to modify other uvconfig file parameter.

Project Locked Project Is Unviewable Access System

[{'Product':{'code':'SSH2AX','label':'InfoSphere DataStage Pack for SAS'},'Business Unit':{'code':'BU053','label':'Cloud & Data Platform'},'Component':'Not Applicable','Platform':[{'code':'PF002','label':'AIX'},{'code':'PF010','label':'HP-UX'},{'code':'PF016','label':'Linux'},{'code':'PF027','label':'Solaris'},{'code':'PF033','label':'Windows'}],'Version':'7.5;8.0;8.0.2;8.1','Edition':'All Editions','Line of Business':{'code':'LOB10','label':'Data and AI'}}]

Document Information

Access Vba Project Unviewable

Modified date:
16 June 2018