Solved: Re: Can't loading peojct from Primavera P6 R8.3 by using DSN Login

Anonymous · ‎02-13-2014

Hi, I was used Primavera DSN with my Web Service, and login successful.

But I can not get my project from Database, (PS. XE is successful to got the project)

and i follow this log messages (and i also attachment my log file) :

---------------------------------------------------------------------------------------------------------------------------------------

140214:14:14:34.332 - OnTablesLoaded Summary Assignments from 1 other projects.
140214:14:14:34.335 - Unloading Summary Assignments from 0 projects.
140214:14:14:34.345 - SELECT user_data FROM userdata WHERE user_data_id= :user_data_id
140214:14:14:34.383 - TCProgress.PercentEnd
140214:14:14:34.388 - SELECT * from usession WHERE session_id=35141
140214:14:14:34.397 - USESSION - REFRESHING , (login_time=41684.5936342593), (last_active_time=41684.5936342593), (host_name=Asus@KCCC2779), (user_id=560), (process_num=2576), (app_name=Primavera Project SDK), (hard_drive_code=ECF9-E3D7), (db_engine_type=PM_SDK), (os_user_name=ASUS), (vdb_instance_guid=CdIsogvlmkqEq9oRa3t/Zw)
140214:14:14:34.406 - VDB.Connect: DB = WTSP6, Public Group Id=1, Log File Name=, LogOptions=verbose as "XXX" successful
140214:14:14:34.438 - ++ Select called for table PROJECT, having filter = Filter has 1 filter(s)
Filter 0, type=2, op=16, field=ROOTWBS__parent_wbs_id
** Exception: (EVariantTypeCastError) Could not convert variant of type (Null) into type (String)
140214:14:14:34.441 - VDB.Select [PROJECT] totalrows=1 prefiltered=0 filtered=1 returned=0
140214:14:15:04.391 - Refreshing using refresh time is : 14-2 月-14
140214:14:15:04.409 - JOBSVC is marked dirty
140214:14:15:04.411 - PROJECT is marked dirty
140214:14:15:04.415 - PROJWBS is marked dirty
140214:14:15:04.418 - RSRC is marked dirty
140214:14:15:04.421 - RSRCRATE is marked dirty
140214:14:15:04.423 - USERDATA is marked dirty
140214:14:15:04.426 - USERS is marked dirty
140214:14:15:04.429 - SETTINGS is marked dirty
140214:14:15:04.431 - DASHBOARD is marked dirty
140214:14:15:04.434 - JOBLOG is marked dirty
140214:14:15:04.437 - is marked dirty
140214:14:15:04.478 - Refreshing using refresh time is : 14-2 月-14
140214:14:15:04.488 - JOBSVC is marked dirty
140214:14:15:04.491 - PROJECT is marked dirty
140214:14:15:04.494 - PROJWBS is marked dirty
140214:14:15:04.497 - RSRC is marked dirty
140214:14:15:04.500 - RSRCRATE is marked dirty
140214:14:15:04.502 - USERDATA is marked dirty
140214:14:15:04.505 - USERS is marked dirty
140214:14:15:04.508 - SETTINGS is marked dirty
140214:14:15:04.510 - DASHBOARD is marked dirty
140214:14:15:04.513 - JOBLOG is marked dirty
140214:14:15:04.516 - is marked dirty

---------------------------------------------------------------------------------------------------------------------------------------

is any problem here? and what mean's marked dirty?

Cna anyone please help me how to solve this problem?

Server Product: Primavera P6 Enterprise Project Portfolio Management R8.3
Server Operating System/Version: Microsoft Windows x64 (64-bit)(7)
Server Database/Version: Oracle Database - Enterprise Edition - 11.2.0.1.0
Server Database Platform/Version: Microsoft Windows x64 (64-bit)(7)

Local Product: Navisworks Simulate 2014 (64-bit) v11.0.0.98373

Local Operating System/Version: Microsoft Windows x64 (64-bit)(7)

thomas.schwaiger · ‎04-08-2014

Navisworks 2014 supports up to Primaver P6 8.2 so connecting 8.3 will not work. However we have added 8.3 support with our recent release of Navisworks 2015.

Thomas Schwaiger
Product Manager
Autodesk

Anonymous · ‎05-11-2014

Thanks, i have try to using P6 v8.3 (Web Service) with Navisworks 2015

but i get the new question.

Can you help me try to fix this problem?

My Service:

Server Product: Primavera P6 Enterprise Project Portfolio Management R8.3
Server Operating System/Version: Microsoft Windows x64 (64-bit)(7)
Server Database/Version: Oracle Database - Enterprise Edition - 11.2.0.1.0
Server Database Platform/Version: Microsoft Windows x64 (64-bit)(7)

Local Product: Navisworks Simulate 2015 (64-bit) v11.0.0.98373

Local Operating System/Version: Microsoft Windows x64 (64-bit)(7)

Anonymous · ‎05-18-2014

We Solved this Problem,

we change the Authentication Mode from Username to Cookies.

now, we got it .

Anonymous · ‎05-19-2014

I also have been like that, you hope to overcome

Anonymous · ‎04-12-2021

When using a standalone copy of Primavera P6 Professional, the typical installation options loaded a copy of Oracle’s free Oracle Express (XE) database on your system. Periodically you may go to login to Primavera P6 and get this message. This happens because the Oracle XE database service has failed and thus Primavera P6 cannot connect to it. The cause of XE failures is varied, but the PC coming out of hibernation is one common item that we encountered.

Anonymous · ‎04-13-2021

When using a standalone copy of Primavera P6 Professional, the typical installation options loaded a copy of Oracle’s free Oracle Express (XE) database on your system. Periodically you may go to login to Primavera P6 and get this message. This happens because the Oracle XE database service has failed and thus Primavera P6 cannot connect to it. The cause of XE failures is varied, but the PC coming out of hibernation is one common item that we encountered.

Can't loading peojct from Primavera P6 R8.3 by using DSN Login

Can't loading peojct from Primavera P6 R8.3 by using DSN Login

Can't loading peojct from Primavera P6 R8.3 by using DSN Login

Forums Links

Post to forums