Problems importing with V.5.

I have already tried these solutions given by Primavera:

prim16871, prim22467 &
prim4145

But none of them worked.

Kind regards,

Marcio Eduardo

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

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.

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

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.

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.

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

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.

Thx so much for ur help.i’ll let u know at the first time if i have further information.

Best Regards

Sandwind He

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.

obs: This solution was not given by Primavera.

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

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.

Read first and second posts of this thread.

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!

Ronald,

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

Cheers, Amar.

Hello Aleks,

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

Regards.

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

Try Service pack 2!

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

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-xerFileParser&Builder.xls

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

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.

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!

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

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.

Oliver, Valentin

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

Dieter