Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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.

Problems importing with V.5.

26 replies [Last post]
Wed, 2006-01-25 08:59
Marcio Sampaio
User offline. Last seen 11 years 34 weeks ago. Offline
Joined: 7 Nov 2005
Posts: 658
Groups: Petro-Chem / Oil & Gas
Dear all,

Have u ever had problems during import in v.5.??

The event code is:

CVRJC-3802-1

TCCustomVirtualRow.getJoinedColItems: UDFVALUE row has blank fk_id

Kind regards,

Marcio Eduardo
Rio de Janeiro - Brazil.
Top

Replies

Tue, 2007-08-28 08:40
#1
Oliver Melling
User offline. Last seen 4 years 31 weeks ago. Offline
Joined: 24 Apr 2007
Posts: 595
Groups: The GrapeVine
All,

I get that error even though I am on P5 SP1 on a stand-alone.

I think when UDF’s are used and the programme isn’t scheduled and refreshed before exporting, an orphaned record error can occur.
Top
Tue, 2007-08-28 04:04
#2
Valentin Sendula
User offline. Last seen 9 years 22 weeks ago. Offline
Joined: 4 Jun 2007
Posts: 12
Groups: Petro-Chem / Oil & Gas
Hi Chris,

I tried using your spreadsheet and got some 13 orphaned records, which I then manually deleted from the UDF_value and used the build xer function. After importing in Primavera though, I am missing most of the budgeted labor units and Units % complete.

Any idea why?

Regards,

Valentin
Top
Tue, 2007-08-28 09:01
#3
Dieter Wambach
User offline. Last seen 7 years 1 week ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Oliver, Valentin

As far as I remember this issue was solved by SP2 and the procedure described by Nimbu.

Dieter
Top
Mon, 2006-12-11 12:21
#4
Nimbu B
User offline. Last seen 17 years 20 weeks ago. Offline
Joined: 18 Oct 2006
Posts: 3
Groups: None
Another solution that worked for me is this:

Download the SP2 from Primavera Knowledgebase and update the database (ConfigAsst.exe file in the SP2 database update folder).

Run database queries/scripts on the source database (the database where the XER was exported from). See steps below.


Run the appropriate script below on the database that the XER was exported from
- For Microsoft SQL Server, run the script as PRIVUSER
- For Oracle , run the script as ADMUSER
- For MSDE Primavera 5.0 Standalone installation, save the appropriate script to the root of the C:\ drive and run the following from a DOS command prompt:
(Start > Run > type ’cmd’ and click OK): osql -U sa -P prima -S localhost\primavera -d pmdb$primavera -i c:\delete_orphaned_UDFVALUE_##.sql


Note: RUN THIS SCRIPT ON A BACKUP OF THE DATABASE FIRST!
Top
Mon, 2006-07-24 20:11
#5
Marcio Sampaio
User offline. Last seen 11 years 34 weeks ago. Offline
Joined: 7 Nov 2005
Posts: 658
Groups: Petro-Chem / Oil & Gas
Thanks for your response Chris.

I’m going to send your answer for IT department.

If problem continue, i will get back to P3e version.

This is not the best solution ... but i have to work.

Regards.
Top
Tue, 2006-07-18 10:28
#6
Chris Hibberd
User offline. Last seen 12 years 48 weeks ago. Offline
Joined: 10 Apr 2006
Posts: 6
Groups: Petro-Chem / Oil & Gas
I too have been plagued by this error. We are running three machines with standalone versions of P5 and have generated this error whilst checking out and checking in between the different PCs.
I have found the easiest work around was to use Primavera’s XER file Parser excel sheet to solve prevent the error.

http://knowledgebase.primavera.com/attachment/PATTLNK_632006_536-xerFile...

You can load the XER file into the spreadsheet and using the diagnostics, identify the orphaned UDF values.
In Diagnostic window, select "Cross check FK"
Then Table "Task" & Field "Task_id"
Then Secondary Table "UDF Value" Field "FK_id"
This will identify all orphaned values
I have written a quick macro then to delete all the orphaned records which I can try to post up if it’s of use to anyone.
You then have to use the build XER function and re-import.

This works well for us, but is still simply a work around for a problem that we still cannot really identify. We cannot have two people working on a schedule at the same time as we are running standalone, which rules out primavera’s documented cause.
Regards
Chris
Top
Tue, 2006-07-18 06:01
#7
Amar Aghana
User offline. Last seen 16 years 37 weeks ago. Offline
Joined: 15 Aug 2005
Posts: 103
Groups: Petro-Chem / Oil & Gas

or may be "...we have noticed your problem. This is a case for enhancement request...please inform us if you prefer to add your problem to enhancement request..." !!
Top
Tue, 2006-07-18 04:48
#8
Paul Naughton
User offline. Last seen 10 years 17 weeks ago. Offline
Joined: 12 Jul 2006
Posts: 39
Groups: None
Try Service pack 2!
Top
Mon, 2006-07-17 19:28
#9
Marcio Sampaio
User offline. Last seen 11 years 34 weeks ago. Offline
Joined: 7 Nov 2005
Posts: 658
Groups: Petro-Chem / Oil & Gas
About this topic ... when problem happened, Primavera said that the problem was coused becouse i didnt install Service Pack 1 ... so ... i solve the problem, installed SP1 and problem happens again.

What is Primavera going to say now??
Top
Tue, 2006-05-16 07:13
#10
Marcio Sampaio
User offline. Last seen 11 years 34 weeks ago. Offline
Joined: 7 Nov 2005
Posts: 658
Groups: Petro-Chem / Oil & Gas
Hello Aleks,

I didnt try your solution (think it works), but I guarantee that my solution functions.

Regards.
Top
Tue, 2006-05-16 04:04
#11
Amar Aghana
User offline. Last seen 16 years 37 weeks ago. Offline
Joined: 15 Aug 2005
Posts: 103
Groups: Petro-Chem / Oil & Gas
Ronald,

Do you have any suggestion for my problem posted above on 8Hrs in P3 and 10Hrs in Ver 5.0

Cheers, Amar.
Top
Tue, 2006-05-16 03:35
#12
Aleks L
User offline. Last seen 17 years 50 weeks ago. Offline
Joined: 16 May 2006
Posts: 3
Groups: None
Unfortunately this problem occurs also after SP1 is installed. And the reason is that Custom Fields for deleted activities are stored in the *.xer file.

So I have only one solution:
Generate XLS files with Acivity list and all user fields and link them to MS Access database. After that you will be able to write a query showing all user field records that are useless and should be delited.

Otherwise you will have to delete all UFs if they are not so important for you.

The same solution for WBS user fields.

Regards!
Top
Thu, 2006-05-04 07:53
#13
Marcio Sampaio
User offline. Last seen 11 years 34 weeks ago. Offline
Joined: 7 Nov 2005
Posts: 658
Groups: Petro-Chem / Oil & Gas
Read first and second posts of this thread.
Top
Thu, 2006-05-04 07:46
#14
Marcio Sampaio
User offline. Last seen 11 years 34 weeks ago. Offline
Joined: 7 Nov 2005
Posts: 658
Groups: Petro-Chem / Oil & Gas
Are u sure is that a solution for same event code??

The event code of my thread is about udfs ... all the solutions indicated for Primavera were about udfs. I do not believe that it is so simple ... I just tried your solution and it did not worked ...

So ... if it worked for u ... congratulations.

Remember: my solution is for who did not use SP1.

Regards.
Top
Thu, 2006-05-04 03:08
#15
Daniel Sepúlveda
User offline. Last seen 15 years 37 weeks ago. Offline
Joined: 2 Feb 2006
Posts: 6
Groups: None
hi Marcio and P5 user.

I have other solution for this problem:

1.- Copy the project to other EPS.
2.- Now export the project copy to file *.xer and ready.



This method was not given by primavera
Top
Fri, 2006-04-28 12:22
#16
Marcio Sampaio
User offline. Last seen 11 years 34 weeks ago. Offline
Joined: 7 Nov 2005
Posts: 658
Groups: Petro-Chem / Oil & Gas
obs: This solution was not given by Primavera.
Top
Fri, 2006-04-28 12:21
#17
Marcio Sampaio
User offline. Last seen 11 years 34 weeks ago. Offline
Joined: 7 Nov 2005
Posts: 658
Groups: Petro-Chem / Oil & Gas
Hello all P5 users;

I found a solution for this event code - and it works!!

1- Delete all UDFs
2- Export this project (without UDFs) and import to a NEW data-base
3- Rewrite the UDFs

That is the only way.

But remember ... this event code is happening only if Service Pack was not installed.

Regards

Marcio Eduardo
Rio de Janeiro B- razil

Marcio Eduardo.
Top
Mon, 2006-03-27 19:59
#18
Shengyun He
User offline. Last seen 18 years 5 weeks ago. Offline
Joined: 24 Mar 2006
Posts: 6
Groups: None
Thx so much for ur help.i’ll let u know at the first time if i have further information.

Best Regards

Sandwind He
Top
Mon, 2006-03-27 08:27
#19
Ronald Winter
User offline. Last seen 3 years 7 weeks ago. Offline
Joined: 4 Jan 2003
Posts: 928
Groups: None
External Early Start and External Late Finish are two data fields that were just added with Version 5.0. In the data base documentation, they call it "Early Start/Late Finish dates for sharing schedules with Primavera Contractor."

More than this, I do not know at present time. Let me know if you come up with further information.
Top
Fri, 2006-03-24 04:47
#20
Shengyun He
User offline. Last seen 18 years 5 weeks ago. Offline
Joined: 24 Mar 2006
Posts: 6
Groups: None
i found that i can not fill the external early start and finish data in Primavera5.0.and i dont know in which case i should use it...why~who can tell me the reason?


Thx & Best Regards

Sandwind He
Top
Wed, 2006-03-22 07:39
#21
Marcio Sampaio
User offline. Last seen 11 years 34 weeks ago. Offline
Joined: 7 Nov 2005
Posts: 658
Groups: Petro-Chem / Oil & Gas
Hi Dinesh ...

Thanks for your explanation. But it didn’t work. We are thinking that it’is becouse we didn’t install service pack of v.5.0.

Maybe our database was corrupted. We are trying a solution with Primavera.

Kind regards.

Marcio Eduardo.
Top
Wed, 2006-03-22 03:20
#22
Amar Aghana
User offline. Last seen 16 years 37 weeks ago. Offline
Joined: 15 Aug 2005
Posts: 103
Groups: Petro-Chem / Oil & Gas
Dinesh, Thanks for your suggestions. Unfortunately, I think my problem is different. I am the only user in the company. When you get time, can you please revisit my query? THanks, Amar.
Top
Wed, 2006-03-22 01:07
#23
Dinesh Kumar Dama...
User offline. Last seen 8 years 15 weeks ago. Offline
Joined: 24 Feb 2002
Posts: 68
Groups: Civil Engineering
Hi there,

"This can happen for a variety of reasons. For example, if multiple users are in a project and user 1 runs a global change or fill down for a user defined field and user 2 is deleting an activity at the same time. The global change will run, however when you export the XER file and try to import it, the program will check and not find the activity the UDF is pointing to".

Do an new export of the same file and import it again and it will work.

Regards

Dinesh
Top
Tue, 2006-02-21 03:22
#24
Amar Aghana
User offline. Last seen 16 years 37 weeks ago. Offline
Joined: 15 Aug 2005
Posts: 103
Groups: Petro-Chem / Oil & Gas
Friends,

By Default, the number of hours per day in Version 5.0 and 3.1 is 8 Hours.

I have 10 Hours per day as per our company norms and the same is set in Version 5.0

I have to import a file from Version 3.1 and provide links to a project in Version 5.0

When links are given from file imported to Version 5.0 (Project 1) and the file created in Ver 5.0 (Project 2) , the links are not seem to be realstic.

For Eg:
Imported File: Project 1

Activity ID 10 : Finish on : Jan 01

Created File: Project 2

Activity ID 101 : FS with Activity ID 10
Duration 1 day

Now after scheduling

Activity ID 101 Starts on Jan 01 and ends on Jan 02.

This is because, for Project 2, still 2 hours left on Jan 01 and the activity completed 2 hours before the closing hours on Jan 02.

Practically, I wish the activity 101 to start on Jan 02.

How to set this? ( Giving lag is one option but laborious)

Cheers, Amar.






Top
Thu, 2006-02-02 21:38
#25
Daniel Sepúlveda
User offline. Last seen 15 years 37 weeks ago. Offline
Joined: 2 Feb 2006
Posts: 6
Groups: None
YOU HAVE FOUND SOLUTION TO THE PROBLEM "CVRJC-3802-1", OF BEING THEREFORE I REQUEST TO YOU TO MAKE IT TO ME ARRIVE BEEN THANKFUL

Kind regards,

DANIEL S.

[Deleted by Moderator - English only, please.]
Top
Wed, 2006-01-25 12:31
#26
Marcio Sampaio
User offline. Last seen 11 years 34 weeks ago. Offline
Joined: 7 Nov 2005
Posts: 658
Groups: Petro-Chem / Oil & Gas
I have already tried these solutions given by Primavera:

prim16871, prim22467 &
prim4145

But none of them worked.

Kind regards,

Marcio Eduardo
Top