Database Error

Hello!

I have a P6 8.4, by 2 years no problems, until today. 

Exception EconvertError in module PM.exe at 0000B846. TCVirtualTable.Refreshappend: UDFVALUE: 460.89 is not a valid floating point -> Data saved to C:\PRBADDATA.TXT

The log file is not on the Disk. The unique difference was the P6 re-installation with JAVA 8 (8.4 came with JAVA 7), it works fine and corrected another XML error (error to import by bad Java address), not imported the XML, but I could work with the other files and xer. Closed it and restarted, then this error appeared.

Any suggest will be welcomed!

Thanks, Nelson

Hi! I corrected my problem by rewriting the DB.
Nelson.

compress the database, compress the file and clean pobs tables file here is how

compress the data base

Click on start All Programs, Microsoft SQl Server 2005, SLQ Server Management Studio

Authentication: Should be SQL Server Authentication

Login: sa

Password: Prima123Vera

Then click connect

on the left Expand the database folder and click on pmdb$primavera

now right click on pmdb$primavera and select task

now select shrink

now select database

at the bottom select OK

when it is done 

right click on pmdb$primavera and select task

now select shrink

now select file

the select ok

colse Microsoft SQl Server 2005, SLQ Server Management Studio

Clean the POBS tables

Click on start All Programs, Microsoft SQl Server 2005, SLQ Server Management Studio

Authentication: Should be SQL Server Authentication

Login: sa

Password: Prima123Vera

Then click connect

Expand the database folder and click on pmdb$primavera

Then up top select new query

Then type this

updatestatistics project with fullscan ,all

updatestatistics task with fullscan, all

execsp_updatestats

then right click and select execute

you can then celan the POBS tables

up top select new query

then type this

delete POBS;

the right click and select execute

now you can close and exit out of sql

NO either delete project that you no longer need 

or select file sed project and email then to yourself

you can also create ANOTHER database

Kandarp,

To run Database Configuration: (by default)

Select Start-> Primavera-> Help & Utilities-> Database configurations

A Database Configuration Dialog box will pop-up then click Next. Tick "configure my database Connection" then click Next..Next...until reaching User Name and Password. Enter pubuser (for both user name & password) then click Next until the Dialog says "Connection Successful!" then click Finish and run Primavera again.

Kandarp,

Try to run Database configuration and it may help.