R98403/XJDE0021 not copying tables

[EONECNC]

Trying create custom environment on SQL server 2005/E812/Windows. Created 2 databases for Business data and Central objects. Also created datbase datasources using the application P986115. There are no tables in the database. When R98403/Xjde0021 is run to transfer tables from Production Environment (PD812) to Cusom Environment, getting error "Table exists" under target environment column in the pdf. But actually, there are no tables under custom environment databases. Can anyone tell me what could be the problem ?
The processing options of the report given below
1. Target Environment : SE812
2. Target datasource : Blank
3. Dataload : 1 Production
4. Source datasource : Blank
5. Source Environment : PD812
7. Recreate tables : A
8. Copy only tables that exists in the datasource : 1

 

[tomw]

You are not defining the source and target data. See the attached procedure and the white paper included

 

[jdeKrnl]

From document entitled "Environment Database Creation Batch Application (R98403)," J.D. EDWARDS @ WORK SERIES, Hands-on OneWorld Documentation, by John J. Phillips, Worldwide Advanced Technologies:

Option Three – Copy Source Location Data to Target Location?

Enter a '1' to load Production Data or a '2' to load Demonstration Data. The default is to load production data. If this report is called from another process, this flag is passed in.

This determines whether or not the source location data is copied to the target location, but does not really determine whether production or demonstration data is loaded (even though that is what is indicated). A value of '2' copies the data. A value of '1' is cross-referenced with the Copy Data object code value (discussed in more detail later) on the Object Librarian record for the table being processed.

For example, consider the two tables, the General Constants table (F0009) and the Address Book Master (F0101). The General Constants table has a Copy Data value of 'Y'. Regardless of the value in processing option number three, this table is copied with data. The Address Book Master has a Copy Data value of 'N'. If production data is chosen, the data from this table is not copied. If "Demonstration Data" is chosen, all the data from this table is copied.


In addition:

Target Data Source Parameters

Table and data source sizing records exist on all data sources. Similar to the Object Configuration Manager (OCM), records can be specified for specific tables or a default record can be specified for all tables without an overriding record. On each type of record there are two parameters that are important: Copy Data and Create Tables. Currently, only the Create Tables parameter is utilized.

The Create Tables parameter can be blank, '0' or '1' With either a blank or '0', the customer and/or developer must manually create the tables because the system will never create tables. With a value of '1', the system automatically generates tables in this data source.

To view the Table and Data Source Sizing information:

1. In Database Data Sources (P98611), highlight the row of the data source you wish to view.
2. Select Row|Database Params and highlight the row you wish to view.
3. Select Row|Overrides.

NOTE: A value of blank, '1', or a non-existent DEFAULT (uppercase) record can overlay tables and data. If you have created new data sources, the DEFAULT record may not exist for these new data sources. If a DEFAULT record does not exist, please create one. The standard values are Copy Data = 'N' and Create Tables = '1'.

 

[jdeKrnl]

Nice doc. Thanks!

I think WJT would still be OK using environment instead of data source as long as the environment has OCM in System pointing DEFAULT TBLE to the data source he created and UBE is run locally.

Cheers,

 

[klwong]

But since WJT is creating this new environment, whether or not there are OCM mappings is an iffy proposition. Probably safer to populate the data source fields instead of the environment fields, and make sure to run it against all 4 environment-specific data sources (Business Data, Control Tables, Central Objects, and Versions).

The other thing to note is the Data Load processing option. Set to 1, you will get a bunch of empty transaction tables (blank F0101, blank F0011, blank F0911, etc.). If you set it to 2, you will have a full copy of Production's data.

For Business Data, that will depend on what you are doing. For Control Tables, that will also depend on what you are doing, but you would generally want it set to 2, else you would have no UDCs, no Solution Explorer menus, etc. For Central Objects, you must set it to 2, or you have no objects at all, no programs to run, and what would be the point?

For Versions, again you should set it to 2, or you would have no Versions of any UBE or APPL, but you have now another consideration. You have copied the PD812 Versions, and there is a field in the Versions table (F983051) that specifically holds the path code information. You will have to manually update this field to your custom path code name, or run the UBE that will automatically copy the Versions table and make the path code switch (R9830512?).

Next, will Object Librarian contain the records for your custom path code, or are you going to have to populate that one too? (R989861)

 

[EONECNC]

Hi

Thanks to Everyone.

I noticed that while copying screen displays

From Environment: JDEPLAN
To Environment : JDEPLAN

Hence i was getting table exists error. But my processing options for source and target environments are different. I have no idea about this problem !!!


Regards
WJT

 

[Adrian_Chimirel]

As Ken was saying, clear the environments and use Data Sources instead, and let us know how it's going.
Start with CTRL tables, first - it's a fast one.

 

[EONECNC]

Hi Adrian,

Even i tried copying control tables by changing to datasouces. But it copies Datasouce-source to Datasouce-source only instead of copying to Target datasouce.
Regards

WJT

 

[Adrian_Chimirel]

WJT,
1 - Use a Fat Client (not the Deployment Server) to run R98403
2 - Copy only F0101
3 - Let us know what you're getting (please attach your Proc Options)