Search results

Good point; you're correct in your assumption. Redhat to Redhat.

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...

I didn't know you could do that, no matter what the source. I could be wrong, but if I'm not, here's how I do it: DataReader Source, setup with a SQL Statement without my Where clause (so it can get the field layout). I create a project wide variable to hold my SQL statement On the...

I'm detecting a little bit of dislike for SQL Server. None the less, if you think you can design a database that can effectively query (indexed or not) 5 years of sales data and accumulate totals for numerous periods for comparison, all while having no performance affect on your production...

I'm admittedly a novice...but I really don't see any benefit of even trying this (let alone paying for something to do it) when it's so easy to use After Imaging and just archive off the files. Is this just one of those cases where someone asks "Is it possible for me to jam this stick in my...

Report development in SQL Report Services works just fine with Progress, but creating models to enable the client tool is what breaks. My solution is data warehousing things into SQL, and building report models off of that. Sure, on the one hand, it's duplicating some data, but ultimately I...

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...

It's even worse--I'm going to have to understand how to write the underlying XML for a Data Source View. Visual Studio creates it with brackets, and it won't save it (or let you see the underlying XML, from what I can tell) until it verifies the code. Since it can't verify, it can't save, so I...

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...

Tried that as well, same issue. Looking at it more this afternoon, I'm even less concerned that I was earlier; the script will run at 3am (first automated run is tomorrow morning), and the server does nothing else overnight. I'm not sure why I am at all concerned about it taking an extra 20-30...

Just to dig this back up, is there any way of using this with prorest, when passing a list of backup files as well? One of my Progress books recommends doing this: echo y | prorest /db/database /backup/file1 < /backup/filelist.txt But it doesn't take the y when it asks if I want to...

I actually know almost nothing about triggers, so most of what we do is just done by nightly report jobs. To do what you're talking about, this should work. First, create a file in your /rd/cust folder on your database server and name it appropriately--but keep the name at 8 characters or less...

I should note that I'm not a Progress developer, but I know enough to be dangerous. Seems like this might be better handled either with a database trigger of some sort, or just a quick and dirty to run on a regular basis looking for product records that don't have a note attached yet. I...

The first time I ran dbtool I was concerned as well, simply because it was something I'd never done before. So I ran it in Test with our test system up and running...and found that it didn't hurt anything at all. I wound up running dbtool against our live system to update that DB mid day, and...

Cool...I think I can see what it is doing. You're my hero for the day. It looks like I can probably add criteria for what records get exported by adding a variable (sCriteria) for my criteria and then just modifying this line hQuery:QUERY-PREPARE("FOR EACH " + hBuffer:NAME + " NO-LOCK")...

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...

Did the DB come up? When this happened to us a few months ago, on a fast system with *very* fast IO, it took almost an hour to roll back. A 2GB+ transaction is a hefty bit of data. Unfortunately, I never found out what caused it, but now I monitor bi size and I get an alert if the variable...

Wow, you are truly a mind reader. :) Never thought about it that way; my guess is that they came up with their procedures in more of a "You backup your database for protection; AI is a secondary tool" train of thought. Thanks for the info; makes me feel a lot more comfortable about the...