Friday, September 10, 2010

Get free P3, P6, Project tips & tricks, register to
our newsletter!

To be able to post message in forums, please login or register.

Registration is free (also spam-free)!

Cant get in to P6
Last Post 14 Apr 2010 04:26 PM by None. 1 Replies.
AddThis - Bookmarking and Sharing ButtonPrinter Friendly
Sort:
PrevPrev NextNext
AuthorMessages
JimUser is Offline
New Member
New Member
Send Private Message
Posts:2
Jim

--
09 Mar 2010 11:20 PM QuoteQuoteReplyReply  

Hi, I've been using P6 for a few months now and all has been well, the software is delivered to my pc via Citrix. On Monday when I tried to loggin I got the error messages below.

1st error message.
PM.exe.
The exeption unknown software exception (0x0eedfade) occurred in the application at location 0x77e4bee7.

2nd error message.
Application Error
Exception Edatabase Error in module PMexe at 00053B65.
Database Server Error: ORA-00001: unique constraint (ADMUSER.PK_UACCESS) violated
ORA-06512: at "ADMUSER.POPULATE_UACCESS", line 1.
ORA-06512: at line 2.

We created a new user for me and new password and when I tried them on both my laptop and desktop I got the same errors. My colleague can see me logged in under both users although I can't get in to the software. Any ideas?

Tags: P6 Loggin errors
None
Posts:386
None

--
14 Apr 2010 04:26 PM QuoteQuoteReplyReply  
The problem is the OBSPROJ table gets out of synch between the PROJ and WBS values. If you are using Oracle, you can run the following query to find places where the PROJ and WBS don't line up:

* Find Bad OBSPROJ that can be fixed */

select o.obs_id, o.proj_id, o.wbs_id, p.proj_short_name, w.wbs_short_name, wnew.wbs_id new_wbs_id
from obsproj o, project p, projwbs w , projwbs wnew
where o.proj_id=p.proj_id and w.wbs_id=o.wbs_id
and p.proj_short_name<>w.wbs_short_name
and wnew.wbs_short_name(+)=p.proj_short_name and wnew.wbs_short_name is not null

Assuming that your WBS (EBS) is named the same as your PROJECTS, you can run the following script:

update obsproj op set op.wbs_id=(select wbs_id from projwbs where wbs_short_name=(select proj_short_name from project where proj_id=op.proj_id))
where (op.obs_id, op.proj_id) in (select o.obs_id, o.proj_id
from obsproj o, project p, projwbs w , projwbs wnew
where o.proj_id=p.proj_id and w.wbs_id=o.wbs_id
and p.proj_short_name<>w.wbs_short_name
and wnew.wbs_short_name(+)=p.proj_short_name and wnew.wbs_id is not null)

If your DBA wants to debug the problem, they can just look at some of the select queries in the POPULATE_UACCESS trigger and see where the duplicates are occurring if the above doesn't fix the problem.


Quick Reply
toggle
 Username:
Subject:
Body:
Security Code:
CAPTCHA image
Enter the code shown above in the box below

Submit
Active Forums 4.2