"Database Read Error: Please Check C:\PRBADDATA.TXT" Or "Cannot create file "c:\prbaddata.txt" When Attempting to Access an SQLite Database

(Doc ID 2226844.1)

Last updated on MARCH 10, 2017

Applies to:

Primavera P6 Professional Project Management - Version 15.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to login to P6 Professional, connected to a standalone SQLite database, the application fails to start and the following error is displayed:

ERROR:

Database Read Error: Please Check C:\PRBADDATA.TXT

OR

Exception EFCreateError in module PM.exe at 000000000012CE71.
Cannot create file "c:\prbaddata.txt". Access Denied

The file location (C:\prbaddata.txt), reported in the error, is not accurate.  Reference:  NOTE 2189841.1 - Can the Location for Errors and Event Codes That Result in "Cannot Create File C:\prbaddata.txt" Be Changed?

The following error is reported in the PRBADATA.TXT file:

Bad Data Row for table UDFVALUE
udf_type_id = 132
fk_id = 36478
proj_id = 368
udf_date = (null)
udf_number = 0.0
udf_text = (null)
udf_code_id = (null)


Additional:

The Control Panel > Region and Language > Formats tab > Advanced Settings > Numbers tab > Decimal Symbol value is set to "," (comma).

This issue can be reproduced using the following steps:

1. Attempt to login to P6 Professional, configured to connect to an SQLite database.
2. Observe the reported error(s)s in the P6 Professional client and the the prbaddata.txt file.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms