cancel
Showing results for 
Search instead for 
Did you mean: 

import error: invalid mapping error

Former Member
0 Kudos
99

Hello forum,

I am doing a migration from 4.7x200 HP-UX/ORACLE to WIN2003/MSSQL2005.

I am getting the following errors during the start of the import:

ERROR: 2011-05-20 12:21:49

Real file not found using DDL file path 'DDLMSS_LRG.TPL' in DDL mapping file 'W:\distmon_cntrl_commdir\hostname\ddl_mapping_import.txt'.

ERROR: 2011-05-20 12:21:49

Invalid mapping between DDL files and package names in DDL mapping file 'W:\distmon_cntrl_commdir\hostname\ddl_mapping_import.txt'.

Does anyone have any ideas?

I believe the first error is from the fact that R3LDCTL doesn't automatically create the DDLMSS_LRG.TPL file.

thanks,

Joe Wilson

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

For Target MSSQL it is recommend to use Sorted way of Exporting but in some cased you can perform it as Unsorted way.

See note : 1054852

I see that MigMon has issues with the provided file,

You have to maintain

import_monitor_cmd.properties: Mapping -


> imp_ddlmap.txt (contains Tables for importing to target database)

Let me know if you get any error further.

Thanks

Srikanth Mandalapu

Certified Basis/Netweaver

Former Member
0 Kudos

We are using the latest tools available from the SAP marketplace for WAS 6.40.

thanks,

Joe

Former Member
0 Kudos

R3lctl (load control) always create it in format called DDL<DB>.TPL. How did you come up with DDLMSS_LRG.TPL?

Thanks

SM

markus_doehr2
Active Contributor
0 Kudos

> I believe the first error is from the fact that R3LDCTL doesn't automatically create the DDLMSS_LRG.TPL file.

I only know the _LRG* file from Oracle, not from other databases.

Did you use the latest migration tools?

Markus