Our version of OpenEdge is 10.1B and it came with our ERP system. We have a couple records that we would like to remove from the system, but apparently our version of OpenEdge is a developer only version.
Is there anything we can use to modifying these records without using the ERP system...
Thanks for the help. We ended up exporting part,partdescription to Excel using the substitute formula to replace CHR(30) and finally upload using the DMT tool.
Appreciate your time and help.
This query will work, but still receiving an error that the shared variable localizationmanager variable has not been created.
For each Part where ( Part.PartDescription MATCHES "*" + CHR(30) + "*") no-lock :
DEFINE VARIABLE cNewDesc AS CHARACTER NO-UNDO.
cNewDesc =...
If I can output the partnum and partdescription into a CSV file, our DMT tool can run the updates to strip the record separater, but the SQL query still don't like the long part descriptions.
They are located in a Progress DB.
We have a tool called DMT that can update, but we would need to output the partdescription field in one column, and since some of these part descriptions have several rows, we cannot output into a text file.
Thanks! That is the CHR value I was looking for in the database. Unfortunately our database now has several thousands entries with that CHR, which is now crashing Crystal Reports when trying to view reports.
It also looks like our version of Progress will not allow us to update the...
Thank you. That definitely helps. What's the proper syntax to use MATCH in a query for hexadecimal value 0x1E in the partdescription field? I'm trying matches CHR(0x1E), but it does find anything. I've already tried wildcards, but not sure if enclosing in quotes is required and how that will...
We recently used a tool to automatically update a field, unfortunately the person used copy and paste to update a description field for several thousand items. Now the description field has a character which is a return character that is showing up as a square in our application.
Now whenever...
Where are the settings to set the log file size for advserv.log and cmdplugin.log? Currently, our log files are 6 and 5GB, and I need to free up a little disk space.
I would like to delete these files without having to restart the app or db servers?
Thanks.
Fixed. The developers of the software had a file WRITE.r that was causing our mfgsys.bi file to grow very large. Turns out it was triggered when certain users went to complete an operation for a job.
The software we are using is Vantage 8.03
Thanks for all the feedback! You definitely...
Thanks for the great feedback.
The triggers seems to be our front-end software Vantage when trying to complete a job or end an operation. This is only happening with a select group of jobs.
I ran a IDXBUILD and don't think we need to run a dump and load. Not sure what else we can do and...
After restarting the server and app servers, our Windows 2008 Server will run for about 10-15 minutes until the _proapsv.exe processes usually two take up all 100% of the CPU.
We do not have any services or processes running out of the ordinary and this database has been running solid for many...
What's the typically time required for a dump and load of a Progress database that's about 8GB? The system has 8GB of memory running quad core 3.2 procs.
I'm using documentation that's provided by Epicor that runs the database on OpenEdge 10.1B
Our Server 2008 Server is running a full backup of all files and directories on our OpenEdge 10.1B server. Will this suffice for backing up the database if it's online? I'm use to running probkup online instead, but curious if that is now just redundant?
Guess trying running the database from...
Thanks for the advice. Looks like the solution was overwriting the c:\oe101b\bin directory from the working system. Now the sqlexp and ODBC connections are successful.
There were no hardware or events errors logged pertaining to Progress in the Windows event logs.
I was able to recreate...
Okay, all you Progress experts, copied the entire c:\oe101b from a working machine to this machine, and now it will connect using the sqlexp, but I'm concerned there might be some side effect to doing this? There wasn't one thing in the config files I knew of that was different, but after copy...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.