P6 sdk dictionary60.xls
Forum Sponsor
Top Posters
Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts
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 [email protected]
Thanks in Advance for your assistance.
Regards,
Justin.
Hi everyone,
Were do i can find the PMSDK.DLL VER. 6.2.1.1507.
Jose is right, an updated version of the sdk is the way to do it.
Khalid, I have't tried to use access with p6 before, so I dont know the answer to your question. Maybe others will be able to help.
Hello every body
I wish some one help me with clear steps to link P6.7 with MS Access , i tried some steps from internet but it does not work ........Thanks
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/
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
just want to know
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
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.
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?
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 (dont 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 whats 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....
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.
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.
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.
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
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 ive tried were pubuser, privuser, & admin. am using the computers name as the HOST. anyone got solution to this?
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.