This content has been marked as final. Show 4 replies
On the machine where Job Services is installed, reconfigure the JSDB alias to point to the proper Project Management database.1 person found this helpful
Reconfigure the Windows Service to run as a windows domain account or local account that has a PRMBootstrap.xml file (constaining the JSDB alias) in their user profile directory.
EX: C:\Documents and Settings\user01\Local Settings\Application Data\Oracle\Primavera P6\P6 Professional\PrmBootStrap.xml
You can try 899068.1
Thanks for the reply.
I have tried and retried these things to get it to work but to no avail.
I have created a local user account with admin rights and assigned it to the PrmJobSvc service and also configured the DCOM object to use the same user account and password. Just for fun I even created a P6 login with the same name and password and assigned it to the export job. Still the same error. I have specified the output folders for bot the job and the log file to the same user's home folder, still the same error. I even created a folder with full access to 'Everyone' problem persists.
Every time the service is launched the xml Bootstrap profile gets created in the user's (whichever the service is configured to run as) profile directory as you have specified in your example. I have checked the contents and saw nothing that may suggest a problematic config.
I can't accesss 899068.1 as I don't have a valid Support Identifier. Could you please tell me what is that about ?
Failed to load or start non-recurring jobs: PRM DBAccess Error:
Connection attempt to database failed with message SQL Server Error:
ORA-28000: the account is locked
Cause: You are trying to connect to the database with a user for which a profile was defined.
On this profile a value for FAILED_LOGON_ATTEMPTS was set.
You tried to logon with this user but entered an invalid password consequently for maximum
number of times specified by the user’s profile parameter FAILED_LOGIN_ATTEMPTS.
Another possibility is that the DBA locked the account.
Fix: You will have to wait until the value of PASSWORD_LOCK_TIME has been reached so the account gets unlocked
automatically or contact a DBA to unlock the account.
To see what profile is assigned to a certain user, issue following select:
select profile from dba_users where username=’<username>’;
To see the limits set for the profile, issue following select:
select resource_name, resource_type, limit from dba_profiles where profile=’<profile>’;
Thanks AcrHaXX, sorry for the late reply. I haven't visited these forums lately and thus missed your reply.
I have quried those parameters and found them set to 'unlimited' (FAILED_LOGIN_ATTEMPTS set to 10). I haven't tried changing those parameters as when I check the status of the user using the database home page, it appears as unlocked and active. So, I am presuming that the user account doesn't get locked and that is not the cause of the problem.
I did realize that the user account I was using to run the job did not have the PMDB tablespace as the default. I changed that so the PMDB tablespace becomes the default , yet I keep getting the same error message - Missing Database Property.
To reiterate the steps so far, I have created a local windows user with the name P6JSDB and set the password according to the rules laid by the employer's domain which includes special character like @,# etc. (Wonder if these special characters might be the cause).
I have configured the DCOM componenet for job service to use the same user and password combination. I have created a DB user using the Database Home Page with the same name P6JSDB with CONNECT privileges only and the user account is unlocked with 'Password Expires' unchecked and with PMDB as the default database.
I have configured the Primavera Job Service to use the same username and password combination. I have also created a P6 user account with the same username and password combination just for fun !
With all this, I keep getting thsame error and the job service simply bails out. There must be something very minor that I am missing or not doing which is causing this anomaly. Any ideas ?