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