Search results

Part of the advisor is also telling you to move those objects into Type II areas with potentially different RPB settings too :-)

Verify that the list fields are in the exact same order in both databases... depending on the data types and the differences in order you might not get errors when loading. But that should be happening on more than one record. If you are 100% sure that it is only for one record then Greg has...

I recognize those tables :-) You would need an index that has the following columns with invoicedt at the very end for the database to be able to use the index properly with date ranges... for this exact query oeel.cono oeel.statustype oeel.whse oeel.specnstype oeel.invoicedt Once you start...

What are you are trying to do is very much not supported by OpenEdge Replication. If you so much as sneeze on the target database you are recreating it from source again. It might be possible to do this with OS copies of the databases for before and after testing, but I would never try and do...

HACMP works very well but the support that OE has for it is marginal at best.. A cluster solution is not really a cluster solution without multiple mirrored databases live at the same time. OE Repl plus isn't quite ready for prime time imo... there are a number of issues with quick failovers...

Glad to hear at least a few people are getting some value out of this. Hard to find time for updates now with my new job but I will try and keep putting a few things in here and there over time. I purposely left out any sizing magic for -B or -B2.. partly because of the issues that Rob...

OpenEdge ABL supports dates that are out of bound for SQL. ABL Date Ranges: 1/1/32768 B.C. to 12/31/32767 A.D. SQL Date Ranges: Year: 1 to 9999; Month: 1 through 12; Date: 1 through the last day of the month It is possible that you have junk dates below or above the SQL limits.

When you have a Progress session open... what does this show? message SEARCH("applhelp.r") SEARCH("applhelp.p"). More than likely it will return a file under your DLC directory in either the gui or tty directory.

Nobody hates a bad UNIX setup like a good Oracle DBA :-)

Off hours would be much better for larger to medium sized indexes. Reading the records will have minimal impact but if your index is fragmented (lots of updates/deletes) idxcompact can generate quite a bit of BI/AI activity. The more often you run idxompact the impact of each run should...

80 is usually acceptable in the majority of cases. Indexes on small static tables almost never get decent index compaction because of the small number of records and the numerous distinct values.

Workgroup and Enterprise will perform poorly over that many network hops. OpenEdge/Progress is very chatty when running in Client Server mode and will suffer greatly from those additional hops and the added latency they introduce. There are some parameters you can try but I would not expect...

When you say update VSTs you mean using updatevst? As far as I know both 1 and 2 require you to restart replication with a new backup.

Check the dataserver broker log files for any errors/messages. If you downloaded SQL Developer, verify that the user has permissions for all of the sys tables. If not... verify through SQL Plus but make sure you add WHERE ROWNUM = 1 or it will output a ton of junk

I am almost 100% certain this would be considered a license violation. “Named User”: A Named User is a single individual, Non-Human Operated Device or Process. They have changed the language around a bit but I know PSC considers this a misuse and would expect you to have appserver or webspeed...

Probably a good idea to get up to speed on Oracle. Especially if the DBAs aren't strong. What we would call a database in Progress is an instance in Oracle. An instance is a collection of user schemas that own objects (tables,views,etc.). The tables you are interested in are owned/connected to...

I doubt that the owner name should be READ_ONLY. That should match the schema name (user) that owns the objects you want to translate into the schema holder. If there is a distributed database in the mix you should be connecting to that DB instead of the one you are connected to.

My two cents on this... if they are already knee deep in the SQL world then the OpenEdge database does not compare well with most of the major players. IF they have heard of it or been introduced to it. PSC doesn't need to catch up with Oracle or SQL Server, but they do need to at least catch up...

If they are using named user licensing it could in theory... usually this does not apply to system accounts unless they outnumber the "butts in seats" count. Most people use CPU based licenses or one of the free versions of Oracle. Them knowing that this user would be transient in nature might...

This is covered quite well in the documentation