Write failure on hashed file

bigpoppa · Post by **bigpoppa** » Mon May 05, 2003 9:12 am

Just a guess, but is the number bigger than 2^31.. (2,147,483,648).. There might be an issue with writing #'s larger than 2^31 if your operating system is 32 bit.

ray.wurlod · Post by **ray.wurlod** » Mon May 05, 2003 5:04 pm

Not sure what the issue is, but it's not integers. Hashed file keys are always character strings, the default maximum length is 255 characters but this can be increased up to 768. Also the fact that it didn't occur the second time suggests that it was a temporary glitch, possibly with memory allocation. Was write caching enabled for the hashed file at the time? And were you trying to populate the hashed file with more than 2GB of data?

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

bradinmi · Post by **bradinmi** » Tue May 06, 2003 10:17 am

The file is a little over a half gig, nowhere near the max sizes. It hasn't happened since. We rebuild this lookup table each day. I'll just chalk it up to a glitch.

Thanks, gang.

Brad Vincent
Compuware @ The Detroit Medical Center