Search results

I'm just going to be honest--I'm wiped from a big upgrade this weekend and I'm hoping someone will do a little part of my job for me. The upgrade took a value in a field and appended a huge string to the end of it. And apparently our assistant controller uses that field, so his report is now...

Haven't been here in a while...I was doing a little research on aistall and found this old thread: http://www.progresstalk.com/showthread.php?114322-reg-aistall-and-L Tom says that aistall is an ancient parameter and there's no need to run it anymore after version 8. I've had consultants...

I've got a process that I run manually right now on the first of every month. Right now I feed it two dates--the last day of the previous month, and the last day of the current month one year earlier. I have to format it with dashes between each segment, and a two digit year. Here's what I...

This weekend was supposed to be the crowning jewel in my series of system upgrades over the past two months. I migrated our SX.Enterprise database (and character code and appserver code) to a shiny new VM running Redhat AS5 64bit. The new server is running OE 10.1C (64bit); old server is...

This probably isn't a "Database Admin" question, but I couldn't think of a better place to put it. Anyway, I've got someone from Infor (*shudder*), out of their UK office, asking me to fill out a document for a software audit. What has me a little confused is that, at least as of yet, they...

This has been one of those stupid questions keeping me awake at night. And while every DBMS that supports online backups probably works the same way, the smartest DBMS people I know are here. :) Anyway, when I run an online backup of our ERP system database, what is really getting backed up...

I know that documentation on startup parms is available on the Progress website, but I'm curious if anyone knows of or has put together kindof a cheat sheet for all of them--something that is a page or two that can be glanced over. I have a pretty good idea of what the ones we use are, but I...

I understand the concept--I've even done dump and loads. But I've always used scripts provided by someone else. I'm looking at the script that I used last, and it's pretty straight forward--a "dumpdb" function that gets the table name and the dump folder, which then runs _proutil db -C dump...

I'm installing OE 10.1C 64bit onto a new system (RH4). I've done this seemingly a hundred times with 32bit 10.1B and thought I could do it in my sleep. One of the first things the install used to ask for was the location of my Java install. With this new installation, it just tells me "A JVM...

As I've mentioned in other places, I am not a Progress guy, but I play one on TV. We've got a bolt on Dispatching system that ties into our ERP application; the Dispatching system has an "Importer" process that, once every two minutes, looks for new or updated order records in the ERP database...

My CFO is having his "freak out about something" time of the month. I'm planning on replacing the DB server for our ERP system that runs on OE 10.1b. I've done this before, and the only time there's been any concerns about fees or license costs has been when we moved from AIX to Redhat--and...

There's one thread here discussing VMWare, so it doesn't appear that virtualization is that big of a topic. I'm curious, though, if anyone is using SANs for their disk storage, even if your Progress box is physical. I've always been told that you should have your BI, AI, and DB on separate...

I'm thinking this has been asked before, but I couldn't find anything. I'm trying to do more with SQL SSIS (Integration Services) and Reporting Services and our ERP system's OE10.1b database. In order to expose datasets to the client side report builder tool for Reporting Services, as well as...

I don't do a lot of Progress development; mainly just quick and dirty apps for supporting our ERP system. Occasionally we have need of exporting an entire record from the ERP database to try to find some oddball piece of data. So we use: output to <file>. for each <table> where <criteria>...

BI blew up again for me tonight. I had a feeling it was getting close; my variable bi extent was at 1.9 gig a little while ago, but I was giving my daughter a bath at the time and I decided to risk it and just let the full backup truncate everything in a few hours. Wrong choice. Anyway...

A few months back, our DB shut down because the variable BI extent hit 2GB. Since then, I've monitored the BI variable extent much closer, and I have our alerting system notify me if we grow into it. Our setup right now is 2 128MB BI files, the 2GB one that I had to convert to fixed (need to...

Thankfully, I've never had to do anything with our AI files. The one time I had a DB go really, really south, it was overnight and only a couple of hours after the nightly backup. Since the job scheduler restored to it's previous state anyway, I just let it get the overnight stuff caught up...

Anyone use anything other than the Infor PDF Converter with SX (not sure if it's an option in character, but we're exclusively GUI)? I'm sick of the Infor PDF Converter. For a "free" addon, it cost us enough to get into place (they didn't tell us until during the install that we needed to...

Had our database shutdown in the middle of the night last night; our variable length BI extent filled up. Not sure if it was the right thing to do, but I just added another bi extent. I believe the problem was caused by a piece of code that we run quarterly; it is a big process, and this is...

No, it's not what you think--I do know how to start the 32 bit version of Data Sources Manager. The docs on the Progress Knowledgebase make things sound so simple--install the Client Networking portion of the client onto the 64 bit server, and then fire up the 32 bit version of the Data Sources...