Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

P3 v3.1 and RA : Not working

8 replies [Last post]
Mon, 2007-04-23 22:51
Amri Mansor
User offline. Last seen 3 years 39 weeks ago. Offline
Joined: 12 Dec 2001
Posts: 18
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
Hi everyone,

I’ve installed P3 v3.1. Also copied the RA sample from the disk. After tried the excel sample, it can’t call the P3engine for establish session. Please help and thanks in advance.
Top

Replies

Tue, 2007-04-24 11:22
#1
Rodel Marasigan
User offline. Last seen 22 weeks 3 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Amri,

Another way if you encounter that problem again is to open your P3 program before launching your Excel utilities. That should not ask you any usersname and password because btrive is already running.
Top
Tue, 2007-04-24 03:57
#2
Amri Mansor
User offline. Last seen 3 years 39 weeks ago. Offline
Joined: 12 Dec 2001
Posts: 18
Groups: GPC Malaysia, Petro-Chem / Oil & Gas

Problem solved.

Old Code from CD:
It stops at this code:
bret = Session.Login(sUserName, sPassword, False) ’Login using Ra serial # one line

Rectified:
Change false to True. It works.

bret = Session.Login(sUserName, sPassword, True) ’Login using Ra serial # one line

Top
Tue, 2007-04-24 02:02
#3
Amri Mansor
User offline. Last seen 3 years 39 weeks ago. Offline
Joined: 12 Dec 2001
Posts: 18
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
Okey, I used activity.xls. The macro’s error said
Run-time error ’50217’ Error: Access Denied (eventough the username & password are correct).

It stops at this code:
bret = Session.Login(sUserName, sPassword, False) ’Login using Ra serial # one line


Amri.
p/s how to check my RA engine is installed properly and workable ??
Top
Tue, 2007-04-24 01:34
#4
Rodel Marasigan
User offline. Last seen 22 weeks 3 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Amri,

There are some few examples in RA (Access/Excel/VB Code..etc) You said you try RA Excel, which Excel files did you use? (ProjectMod.xls, ActivityMod.xls, Custom.xls..etc..)

Some of them requires "dll" and "ocx" files on your system.
Top
Tue, 2007-04-24 01:27
#5
Amri Mansor
User offline. Last seen 3 years 39 weeks ago. Offline
Joined: 12 Dec 2001
Posts: 18
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
This one I’m not understand. I just use the sample copied from the P3 CD (which consist of Access/Excel/Notes samples). and assume it supposed to run.

The excel macros stop at the code to establish the session with p3engine. Is it something wrong with my installation or bugs (p3.1 with xp with service 1)

>>Which RA excel utilities are you trying to use?
Really,what you mean by " RA Excel utilities " ? Thanks

Top
Tue, 2007-04-24 00:40
#6
Rodel Marasigan
User offline. Last seen 22 weeks 3 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Hi Amri,

Thanks for the info but actually I’m familiar and expert with RA utilities and its VB code. I wrote so many programs to manipulate P3 using VB and modify some of RA utilities to use another external program like MSP, Access, Visual FoxPro and Visual Basic program itself.

My question is which RA excel utilities are you trying to use? The reason I ask is to check what are the “dll” and “ocx” missing on your excel or P3 which causing you a problem.

Regards,
Rodel
Top
Tue, 2007-04-24 00:28
#7
Amri Mansor
User offline. Last seen 3 years 39 weeks ago. Offline
Joined: 12 Dec 2001
Posts: 18
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
RA is somesort of automation linking between our application (lotus notes, access, excel ) to P3. It’s SDK to P3.

The sample not installed together with P3. We have to copy from the P3 disk itself.

I have tried to use ODBC, but the data only flow from P3 to excel/access only. No direct linking. If you update the excel/access data, nothing affect the P3s.

Yep, Already set my macro level to medium so that I can select which macros can run.

Will try update the btrieve using service pack.


--from google--
RA(TM), an object-oriented OLE automation server and scheduling engine. Designed for use by OEMs, ISVs, Primavera customers, and Primavera’s development team, RA facilitates resource and activity control for the enterprise through an organization’s primary business applications.
----
Top
Mon, 2007-04-23 23:23
#8
Rodel Marasigan
User offline. Last seen 22 weeks 3 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Hi Amri,

What exactly your problems are? What RA excels utilities you’re using?

If the problem is regards to excel security then you have to set your security to medium. Select Tools-> Macro-> Security under your excel menu. Change the security level to medium. Every time you use RA excel utilities when prompted click enable macro.

Another problem that you may encounter is the username and password. It should be the default username and password when you run P3.

Last is the Btrieve. Update your Btrieve using the service pack.

Please let me know what exactly you did so I can help you further.

Regards,
Rodel
Top