P6 sdk dictionary60.xls

Keyel;

It is on your installation DVD. Do a repair/re-install and you will see the check box. Check it and then run it and you should be good to go. Suggest you get Primavera support involved, but not essential.

BTW. When you upgrade to 6.2.1 you will have to re-install SDK.

Good luck. I think dictionary is a handy utility.

i got the SDK installed now, but i cant get the databases to work. tried using the pubuser for the username and password for the public login but it says: Bad public user name or password. Database Server Error: Named Pipes Provider: Could not open a connection to SQL Server [2]. ;. whats the public username & password? the same happens to both JSDB & PMSDK. the usernames & passwords i’ve tried were pubuser, privuser, & admin. am using the computer’s name as the HOST. anyone got solution to this?

Hi Keyel,

Try to install again using the correct Host Name & Database Name:

Host Name: (Computer Name\PRIMAVERA) Ex. keyel-PC\PRIMAVERA
Database Name: pmdb$primavera

Login Name: admin
Password: admin

This applicable for both JSDB & PMSDK.

The dictionary6.xls you are looking for is only available in primavera knowledgebase.

Regards,

Arnold

Barry, you can import the resources dictionary to p6 via the sdk, global though. then use the global change. im used to p3, in which importing these things are quite easy to do using the RA automation engine, much like sdk. i just convert the p3 files to p6 after i have imported everything i need in p3.

Barry, you can try the RA automation. Its better than import/export. BTW, check that you have the correct heading in each column. sometimes formatting hinders in import so dont change any of the formatting, just add the data you need. you can also apply the same format to the added data by using the format painter.

This should be discussed in p3 section of the forum. Anyway, the RA automation is an excel file full of macros that extracts & appends data to and from p3 file.

This is what you need to do first: >>>>Important info. here (do this before you create the DB alias or lunch P6 or it will not work and you will need to restart the whole thing agian)......

Start SQL Server Management Studio Express and login with the SA account. (change the Authentication mode to SQL Server Authentication). Password is Prima123Vera

Click on the Database that you created: Right Click and Select New Queary:

Copy and Paste or type the following text into the query window:

EXEC sp_change_users_login ’Update_One’,’pubuser’,’pubuser’
EXEC sp_change_users_login ’Update_One’,’privuser’,’privuser’

(!) execute query

Now: Close SQL Server Management Studio Express

****Connect to new database / create new alias****

Now You can Launch P6.2.1 or whatever ver you got:

Do not hit OK, instead use the … button on the bottom then select Add (to add/create a new DB alias)

Enter Your new name N in the Driver Type Select MS SQL/SQL EXP, OR ORacle???WhATEVER YOUR working on

CLick NExt

On the This window:

HOST NAME: IS YOUR COMPUTER NAME\PRIMAVERA (Sometimes the \primavera after the computer name is needed, sometimes not)

DB NAME: whatever you called your database (Keep database name and alias name the same – be consistent)

Click Next
On the Enter Public Login Info. Window (don’t change anything here)

Use the defaults, click Next

On the Validate DB connection Window:

Just click next (dont’ change anything again)

Now now we hope that you got Successful Connection:

If the connection fails saying bad public username or password run the resync pubuser account steps on the database.

Run the SQL QUERY again (Listed ABOVE) but first run this query: (why because all your on the owners column in sql it should say "sa") if not do the following steps bellow: (1 n 2)

Copy and Paste or type the following text into the query window: exec sp_helpdb

New Query:
next:
1: exec sp_changedbowner
Excute Query: (!) button

New Query:
Next:
2. exec sp_changedbowner ’sa’
Excute Query: (!) button


>>>(If you are getting the error code you listed before this is why: To see what’s happening, open Query Analyzer and run: exec sp_helpdb)


is the database with the missing or corrupt owner.

1) Use

exec sp_changedbowner ’[new user not in db already]’
--this will work & sp_helpdb will execute correctly

2) Then execute the same query using sa & it will work:
Use

exec sp_changedbowner ’sa’
--The dependent aliases were mapped to the new database owner. Database owner changed.


Let me know if you want me to send you a ms word doc with all screen shots to explain the entire procedure how to set up a primavera database. It took me a while to figure this out but it works now perfectly....sorry expl. this with words is harder....

Okay PMSDK is working now well some what:

i am getting the following Errors:

Am Using the Latest: Dictionary.xls - Error Report
Row 0: ct was open.
Row 0: action is not allowed when the object is closed.

What do they mean by "CT"

and

Action is not allowed when Object is closed? What object?

any help out here?

prim72124:Error: “row 0, ct was open” when logging into SDK
Primavera Project Management Add comments

Solution ID: prim72124

Error: "row 0, ct was open" when logging into SDK
Status: Reviewed
Version(s): 6.0, 6.1

Fact: Error occurs after applying/installing a Hotfix/Fix Pack.

Problem: Error: “row 0, ct was open” when logging into SDK

Problem: Unable to log into SDK. Receive error “row 0, ct was open, object is closed”.

Problem: Cannot log into SDK get error “row 0, ct was open”.

Fix: Verify pmsdk.dll is the correct version by copying the pmsdk.dll from the hotfix/Fix Pack files to C:\Program Files\Common Files\Primavera Common\PMSDK\Engines.

PROBLEM SOLVED N ISH FINALLY WORKS:

PMSDK.DLL VER. 6.0.0.1473 (old version and will not work with the new PMSDK DICTIONARY 6X) AND

AND YOU WILL GET ALL THIS ERROR CODES:


Problem: Error: “row 0, ct was open” when logging into SDK

Problem: Unable to log into SDK. Receive error “row 0, ct was open, object is closed”.

Problem: Cannot log into SDK get error “row 0, ct was open”.

THE FIX IS: PMSDK.DLL VER. 6.2.1.1507 (THIS WILL CORRECT ALL THE ISSUES OF CONNECTIVITY)....

WELL, AM GLAD I COULD FIX MY OWN ISSUES....I ROCK MY WORLD....

SO WHEN YOU UPGRADE FROM 6.0.0.1 YOU NEED TO ADD THE SDK KIT ON THE UPGRADE PROCESS...OR WILL HAVE ALL THE SAME ISSUES I HAD TODAY...STUPID ME

just want to know

Dear Jose,

I am having the same PMSDK.DLL VER. 6.0.0.1473.

and I am using P6.0.

Also I get the same error message while using Dictionary6.xls.

How to overcome this problem.

With thanks & Regards,

Anbin Ponnith

Hi Anbin:

PMSDK.DLL VER. 6.0.0.1473 (old version and will not work with the new PMSDK DICTIONARY 6X)

What you need is to update Primavera 6.0 to Primavera 6.2.1

This update will also upgrade the Primavera Software Development Kit to the version required by the Dictoinary6x which is the PMSDK.DLL VER. 6.2.1.1507...

If you have not updated your P6 Here is where you can get the lastest update (P621_Pro_Client_Applications): http://edelivery.oracle.com/