Search results

The extend are already exsit in the database location. We need to distribute it to multiple drives as it was before. d "Schema Area":6,32;1 /db/production/production.d1 # d "Data Area 1":7,64;512 /db/production/production_7.d1 f 1048576 d "Data Area 1":7,64;512 /db/production/production_7.d2 #...

The Bulk load is ETL and non-Pro2 bulk load. Kindly advise this can loaded via Pro2 bulk load (1000 m records).

Since we have 300 Gb data (1000 m records)i snot possible to Replicate via pro2 might take longer time, Hence we do Bulk load via ETL and enable the Pro2 once data loaded nearly, Hence the Column PRROWID how to handle and populate data from target side.

Since 1000-m record not possible to load via Pro2, Hence we need to kick start initial load via ETL, Please advise on this.

Thanks for your input: Out of these columns, the “PRROWID” column is having NOT NULL constraint in the target table in schema. But we don’t have any mapping column from the source for this target column. When we load the data via Pro2 the PRROWID value has - 0x0000000039eaf8b1 Please let us...

PRROWID what basis is working on Pro2 side, is there any logic behind ?

The Bulk data (1000-m records approx) need to load into the target Oracle database. It needs to be handled via ETl. Once data loaded we need to sync up with Pro2 the same value will patch the table. The PRROWID Column doesn't exist in Source Progress side. Question: When the pro2 replicates...

Yes I need both table along with index as well. Is there any way to find out size in GB.

Hi, Check the Table size in the Progress 4GL database. Is there any commends it would be really helpful full to find the table size in GB. Thank you

PROMON Record Locking Table There are many locks waits. Did we get the chance to export a report for the report from Proenv session ?

Update - I have modified the path and directory remain are same. Still the same error.. prorest M:\databases\sports2000\sports2000 N:\backup\Target_Restore\sports2000.bk -verbose OpenEdge Release 11.7.4 as of Wed Oct 10 19:02:14 EDT 2018 ** Cannot find or open file...

Hi, Any idea how to resolve the issue. It would be greatly appreciated !!! Note: Restoring an existing database. 11.7.4 Tried transferred new back and restore getting same error.

While restoring getting below error: We have sufficient .st file and .d file. Tried with different direct path to restore getting the same error. Source backup: probkup online sports2000 R\sports2000_target.bkp -REPLTargetCreation target restore: prorest S:\databases\ob30\sports2000\sports2000...

Thank you I'm able to add the .st file online.

While adding st file getting an below error. It is possible to add without stopping the database ? If so, please let me know the steps, thanks. prostrct add sports2000 addai.st OpenEdge Release 11.7.4 as of Wed Oct 10 19:02:14 EDT 2018 ** The database sports2000 is in use in multi-user mode. (276)

Please see the below probkup online sports2000 sports.bkp -REPLTargetCreation prorest sports.bkp -verbose Proutil sports2000 –C Truncate Bi prostrct add sports2000 addai.st rfutil sports2000 -C aimage begin Proutil sports2000 -C enableSiteReplication target If I disable the Replication in...

Unable to start Target 1 REPL Database gets an below error: 17:45:29 BROKER ** This process terminated with exit code 1. (8619) 17:45:29 BROKER : Removed shared memory with segment_id: 904605401088 (16869) 17:45:29 BROKER 0: Access to database C:\Progress\Test_Target_1\sports2000\sports2000 not...

I have enabled the Replication on source and up & running source. While enabling to target Dr getting an below error. Proutil sports2000 -C enableSiteReplication target OpenEdge Release 11.7.4 as of Wed Oct 10 19:02:14 EDT 2018 Replication (target) cannot be enabled on a database that has not...

How to switch over and switch back Progress database 11 1. Current process 2. Using Replication Set 3. Does 2 have any advantages over 1. Does 2 help in transition to avoid reseeding of the database.

I'm getting the error while login to the SQL using sqlexp. Error: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Remote Database Name not valid.. (8933). Seems DB is correct only. Kindly provide any suggestions.