Dear Jose Ramirez,

I am also facing the similar problem like you (Row 0: ct doesn't support this property or method ) , But I couldn't get the fix file PMSDK.DLL VER. 6.2.1.1507 , So would you please send me the fix file to my mail sjustinjames@gmail.com

Thanks in Advance for your assistance.

Regards,
Justin.

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/

just want to know

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.

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....

HI what is RA Automation

This si how I ma trying to do it , I have taken the excell spread sheet , it has teh res id on it and the rate , but i now cant seem to import to p3 , as it was my intention to then import p3 into p6 and i would have all the resources come in , but now i exported resources from p3 to a dbf file then opned it in excdell and just added the resources etc, , when i now try to imp[ort into p3 , it just doesnt work

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

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.