Datapage error

[rangerboat72]

Help (please)!

I thought I'd post a link to the Datapage forum here to draw more attention and hopefully get assistance a lil' bit quicker...


http://www.pcdmisforum.com/showthread.php?t=4179


I keep getting this error when trying to open a database. I'm hoping that the file has not been corrupted or something because I just sent data for 15 samples that took 8 hours to run to this specific database. I tried deleting the XSTATS.tmp file but that did not do anything for me.

http://i76.photobucket.com/albums/j2...boat72/111.jpg

http://i76.photobucket.com/albums/j2...rboat72/11.jpg

[craiger_ny]

I use www.dictionary.com mostly.....

[rangerboat72]

I use www.dictionary.com mostly.....

Thanks, that helped a lot.

Did I mis-spell something?

[craiger_ny]

No I have nothing to offer so I thought I'd rib on your "Wrong Dictionary File" error that Datapage is throwing out.

[rangerboat72]

No I have nothing to offer so I thought I'd rib on your "Wrong Dictionary File" error that Datapage is throwing out.

Ah, now I get it...

I'm in deep ***** here. I gotta get another 15 samples (8 more hours worth of work) by the end of the day so I can get a green-button rookie setup to run parts tomorrow so I can begin my vacation next week....

[craiger_ny]

If you don't get it figured out by the weekend write all of the pertinent data to a text file. That way you can still run and have the data to do what you need with. I gave up on Datapage ages ago and whenever I need to gather data I do it like that. You can send a date time stamp and delimit it before the data.

No sense in having your off time compromised.

[rangerboat72]

That's an idea Craiger but on the next fifteen samples I have already corrected the problem by sending the data to a different database that is working. I had forgotten about the Database being corrupted or whatever prior to measuring the first 15 samples. I'm just trying to find a way to save or retrieve all of the data from the previous 15 samples so I do not have to re-run them if you get my drift.

[Matthew D. Hoedeman]

Have you tried opening the database files with WORDPAD or something?

I have enver seen that error myself.

[rangerboat72]

No I haven't tried that yet. I'll give that a shot and let you know...

[rangerboat72]

Well, this is what I get when I tried that:

V3.00 K datapg6.d01 cdf ( datapg6.d02 cdD < datapg6.d03 cd ¸ datapg6.d04 cd# r datapg6.d05 cd< D datapg6.k01 ckf ( datapg6.k02 ckD < ” B D ¸ n & C * ' + ( 7 ) D * < , 2 / # 3 # 5 ' 7 $ : @ < , @ r B ] I 6 6 K ÿÿ uc B nc' ' [ ns ‚ ns „ ns † ns ˆ ns Š ns Œ ns Ž ns  ns ’ nc ns 8 ns : nf < nf @ nc nc + nc4 4 D nc x nc y nl z nl ~ nf ‚ nf † nf Š nf Ž nf ’ nf – nf š nf ž nf ¢ nf ¦ nf ª nf ® nf ² ns ¶ uk2 ncP P nc * nc nc nc nc + nc nl 8 uk nc nc nl . dk( ns
nc
ns nc nf nl " nc & uc
ns "
nc nc nc " nc 1 nc

nc

nc nc + nc' ' D nc k nl l ns p uk2 nc ncJ J l l l l l l d l l l l

l a * d
l * l 6
8 I 8
% a % a . , a . - a 2 / a 2 0 a H B a H C a PART_REC
GENERIC_REC
VARIABLE_REC
NOTE_REC
VARSET_REC
VARLIST_REC
SHORTSET_REC
SHORT_REC
TRANSACT_REC
SERIAL_REC
TRACE_REC
TNAME_REC
DATA_REC
QUERY_REC
WHERE_REC
PASSWD_REC
ATTRIBUTE_REC
CAUSE_REC
SYSTEM
P_NAME
P_TEXT
P_ICHART
P_SCHART
P_ITEST
P_STEST
P_SGSIZE
P_MINSG
P_MAXSG
P_DECPLACES
P_CAPLIMIT
GEN_ID
IVAL1
IVAL2
FVAL1
FVAL2
V_P_NAME
V_NAME
V_TEXT
V_C_ALARM
V_T_ALARM
V_ACKNOWLEDGE
V_ACCESS
V_NOMINAL
V_UPPER
V_LOWER
V_MEAN
V_SIGMA
LM_IXUCL
LM_IXLCL
LM_IRUCL
LM_IRLCL
LM_SXUCL
LM_SXLCL
LM_SRUCL
LM_SRLCL
V_DISTRIBUTION
VAR_KEY
NOTE_ARRAY
VSET_NAME
VL_NAME
SHORTSET_NAME
SHORTP_NAME
SHORTV_NAME
T_P_NAME
TRANSACT
TRAN_KEY
S_P_NAME
S_NAME
S_TRANSACT
SERIAL_KEY
TRACEINDEX
TRACE
TNAMEINDEX
TNAME
D_VALUE
D_TRANSACT
CAUSE_CODE
QUERY_NAME
SG_SIZ
OPERATOR
TRACE_LABEL
LIMIT1
LIMIT2
EDIT_CODE
SUPER_CODE
A_P_NAME
A_NAME
A_TEXT
A_TYPE
A_ACCESS
SAMPLE
ATT_KEY
C_CODE
C_DESCR
PART_LIST
SHORTSET_LIST
PART_VSET_LIST
PART_TO_NOTE
VSET_VAR_LIST
SHORTSET
VAR_TO_DATA
TRANS_TO_TRACE
TRANS_TO_NOTE
PART_TO_TNAME
WHERE_LIST
PASS_SET
PART_TO_CAUSE
ATT_TO_DATA
GENERIC_LIST
PART_TO_GENERIC
04-04-14-15-15-16 C:\u\mm4\stats\S040325133707 C:\DATAPAGE\PART
04-04-14-15-15-50 Update Failed: Unable to open database
04-04-30-12-11-17 C:\u\mm4\stats\S040325133707 C:\DATAPAGE\PART
04-04-30-12-11-24 Update Failed: Unable to open database

[rangerboat72]

This is one of my good database's:

V3.00 K datapg6.d01 cdf ( datapg6.d02 cdD < datapg6.d03 cd ¸ datapg6.d04 cd# r datapg6.d05 cd< D datapg6.k01 ckf ( datapg6.k02 ckD < ” B D ¸ n & C * ' + ( 7 ) D * < , 2 / # 3 # 5 ' 7 $ : @ < , @ r B ] I 6 6 K ÿÿ uc B nc' ' [ ns ‚ ns „ ns † ns ˆ ns Š ns Œ ns Ž ns  ns ’ nc ns 8 ns : nf < nf @ nc nc + nc4 4 D nc x nc y nl z nl ~ nf ‚ nf † nf Š nf Ž nf ’ nf – nf š nf ž nf ¢ nf ¦ nf ª nf ® nf ² ns ¶ uk2 ncP P nc * nc nc nc nc + nc nl 8 uk nc nc nl . dk( ns
nc
ns nc nf nl " nc & uc
ns "
nc nc nc " nc 1 nc

nc

nc nc + nc' ' D nc k nl l ns p uk2 nc ncJ J l l l l l l d l l l l

l a * d
l * l 6
8 I 8
% a % a . , a . - a 2 / a 2 0 a H B a H C a PART_REC
GENERIC_REC
VARIABLE_REC
NOTE_REC
VARSET_REC
VARLIST_REC
SHORTSET_REC
SHORT_REC
TRANSACT_REC
SERIAL_REC
TRACE_REC
TNAME_REC
DATA_REC
QUERY_REC
WHERE_REC
PASSWD_REC
ATTRIBUTE_REC
CAUSE_REC
SYSTEM
P_NAME
P_TEXT
P_ICHART
P_SCHART
P_ITEST
P_STEST
P_SGSIZE
P_MINSG
P_MAXSG
P_DECPLACES
P_CAPLIMIT
GEN_ID
IVAL1
IVAL2
FVAL1
FVAL2
V_P_NAME
V_NAME
V_TEXT
V_C_ALARM
V_T_ALARM
V_ACKNOWLEDGE
V_ACCESS
V_NOMINAL
V_UPPER
V_LOWER
V_MEAN
V_SIGMA
LM_IXUCL
LM_IXLCL
LM_IRUCL
LM_IRLCL
LM_SXUCL
LM_SXLCL
LM_SRUCL
LM_SRLCL
V_DISTRIBUTION
VAR_KEY
NOTE_ARRAY
VSET_NAME
VL_NAME
SHORTSET_NAME
SHORTP_NAME
SHORTV_NAME
T_P_NAME
TRANSACT
TRAN_KEY
S_P_NAME
S_NAME
S_TRANSACT
SERIAL_KEY
TRACEINDEX
TRACE
TNAMEINDEX
TNAME
D_VALUE
D_TRANSACT
CAUSE_CODE
QUERY_NAME
SG_SIZ
OPERATOR
TRACE_LABEL
LIMIT1
LIMIT2
EDIT_CODE
SUPER_CODE
A_P_NAME
A_NAME
A_TEXT
A_TYPE
A_ACCESS
SAMPLE
ATT_KEY
C_CODE
C_DESCR
PART_LIST
SHORTSET_LIST
PART_VSET_LIST
PART_TO_NOTE
VSET_VAR_LIST
SHORTSET
VAR_TO_DATA
TRANS_TO_TRACE
TRANS_TO_NOTE
PART_TO_TNAME
WHERE_LIST
PASS_SET
PART_TO_CAUSE
ATT_TO_DATA
GENERIC_LIST
PART_TO_GENERIC

[Matthew D. Hoedeman]

Did you get anykind of error when updateing the data base? Is it possible your data is still in the XSTATS11.TMP file?

[SABarber]

You don't say if this has worked in the past & just recently started happening or if you just created a new database and it happens.
By the sounds of it, your "datapg6.dbd" file is not correct. Has someone played with it? Is it read/write locked? If you right click on that file, select Properties, the file size should be 3643 bytes in length. If not, then something is wrong. You could take another copy of this file from another database directory and copy it to this location. This file defines what the internal structure of the databas is and does not contain measured information.

I should also mention, if you open it with any program (such as Notepad/Wordpad) do NOT write it back out.

If there is any error during the update process, the XSTATS file is NOT deleted so the information could be transfered to the database once the error has been corrected.

[rangerboat72]

Did you get anykind of error when updateing the data base? Is it possible your data is still in the XSTATS11.TMP file?

No error when updating. I guess it's possible that it could still be in the XSTATS11.TMP file. Is there any way I can pull that data into a working database?

[Matthew D. Hoedeman]

You should be able to, but you CAN open XSTATS11.TMP with word pad (or just check it's size). If it is empty or too small to hold all the data, then don't bother.

To import it, you do something from a working database, but I am not exaclty sure of the procedure, I think there is a command under FILE in the editor to update or something like that.