Running a SAS^® Merchandise Data Integration load, you receive an error: ERROR: ORACLE execute error: ORA-02149: Specified partition does not exist.

This error is due to the fact that one of the time periods for a table you are trying to load does not have a partition defined. If you are not sure which one is missing, you can use the following query to find the partition. In this example, the table being queried is mcomp:

select distinct time_id from maxdata.loc_attr order by time_id;
select * from dba_tab_partitions where table_name='MCOMP' order by partition_name;

If you don't receive an error message in the logs that a partition is missing, you can find some clues in the following files:

From mdi_loadfact_fact_mfinc_full.lst - notice that the 201009 partition is missing:

71 MFINC_50_201007 50 201007

72 MFINC_50_201008 50 201008

73 MFINC_50_201010 50 201010

74 MFINC_50_201011 50 201011

75 MFINC_50_201012 50 201012

From mdix_download_mfi_50_201009.log (the name of yours will be slightly different), notice that there is no partition name in the file:

367 %lookfor_killfile(kill_all)

1368 %download(

1369 db_type =ORACLE

1370 ,dbtable =MFINC

1371 ,dbtablesuffix =

1372 ,partition_name =

1373 ,time_level =50

1374 ,time_id =201009

1375 ,outtab =aggdata.agg_mfi_50_201009

1376 ,split_download =y

1377 ,bypass_retrieve =N

1378 ,use_path =Y

1379 ,n_segments =1

1380 ,outtab_postprocess=SORT

You can also do an export to excel of the maxapp.lvXtime (lv1time to lv5time) tables, and look for any missing partitions.

Additional information regarding partitions can be found in the SAS^® Merchandise Data Integration 6.1.3 Administrator Guide.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Merchandise Data Integration	Microsoft Windows Server 2003 Enterprise Edition	6.1.3M3		9.1 TS1M3 SP4
		64-bit Enabled AIX	6.1.3M3		9.1 TS1M3 SP4
		64-bit Enabled Solaris	6.1.3M3		9.1 TS1M3 SP4

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

You receive an Oracle error running an MDI load because you are missing a partition. A query is included to find the missing partition.

Type:	Usage Note
Priority:

Date Modified:	2012-01-09 11:43:13
Date Created:	2010-01-19 09:28:25