on 02-13-2006 7:38 PM
Hi,
I have a problem during the content import (I am using csv upload). I review after each step the report /CCM/VERIFY_CATALOG
<b>1.- I upload the master catalog schema (.csv)</b>
Content *****************************************
SAP CATALOG CSV 2.0 <;> update;;;
Defaults;ES;;;
Model;;;;
Catalog;/CCM/MASTER_CATALOG;1;cat_prov;{ES-ES}IMP_CAT_PROVEEDORES Characteristic;IDIOMA;/CCM/NAME;false;IDIOMA
Characteristic;UTILIZACION;/CCM/NAME;false;UTILIZACION Characteristic;ATTACHMENT;/CCM/HYPERLINK;false;ATTACHMENT
Characteristic;CENTROS_CORPORATIVOS;/CCM/NAME;false;USO CENTROS CORPORATIVOS Characteristic;CANTIDAD_MAXIMA;/CCM/MINIMUM_QUANTITY;false;CANTIDAD MAXIMA
Schema;1;IDIOMA;UTILIZACION;ATTACHMENT;CENTROS_CORPORATIVOS;CANTIDAD_MAXIMA;Catalogo;{ES-ES}Esquema gral.; Category;100000000;;;IDIOMA;UTILIZACION;ATTACHMENT;CENTROS_CORPORATIVOS;CANTIDAD_MAXIMA; Suministros al negocio
Category;110000000;100000000;;IDIOMA;UTILIZACION;ATTACHMENT;CENTROS_CORPORATIVOS;CANTIDAD_MAXIMA; Marketing y Publicidad Category;110050000;110000000;;IDIOMA;UTILIZACION;ATTACHMENT;CENTROS_CORPORATIVOS;CANTIDAD_MAXIMA; Articulos Promocionales
End of Content ******************************************
<b>2.- I create the supplier catalog
3.- I upload the supplier catalog schema & content (.csv)</b>
Content ****************************
SAP CATALOG CSV 2.0 <;> update;;;
Defaults;ES;;;
Model;;;;
Catalog;CAT1;2;cat_prov;{ES-ES}IMP_CAT_PROVEEDORES Characteristic;IDIOMA;/CCM/NAME;false;IDIOMA
Characteristic;UTILIZACION;/CCM/NAME;false;UTILIZACION Characteristic;ATTACHMENT;/CCM/HYPERLINK;false;ATTACHMENT
Characteristic;CENTROS_CORPORATIVOS;/CCM/NAME;false;USO CENTROS CORPORATIVOS Characteristic;CANTIDAD_MAXIMA;/CCM/MINIMUM_QUANTITY;false;CANTIDAD MAXIMA
Schema;1;IDIOMA;UTILIZACION;ATTACHMENT;CENTROS_CORPORATIVOS;CANTIDAD_MAXIMA;Catalogo;{ES-ES}Esquema gral.; Category;100000000;;;IDIOMA;UTILIZACION;ATTACHMENT;CENTROS_CORPORATIVOS;CANTIDAD_MAXIMA; Suministros al negocio;;;;;;;;
Category;110000000;100000000;;IDIOMA;UTILIZACION;ATTACHMENT;CENTROS_CORPORATIVOS;CANTIDAD_MAXIMA; Marketing y Publicidad;;;;;;;; Category;110050000;110000000;;IDIOMA;UTILIZACION;ATTACHMENT;CENTROS_CORPORATIVOS;CANTIDAD_MAXIMA; Articulos
Promocionales;;;;;;;;
Content;;;;;;;;;;;;;;;;;
ItemValuation;Comment;/CCM/LONG_DESCRIPTION;/CCM/PRODUCT_GROUP;/CCM/SUPPLIER_ID;/CCM/ORDER_UNIT;/CCM/BASE_UOM;/CCM/PRODUCT_ID
;/CCM/CONTRACT_ID;/CCM/CONTRACT_ITEM_ID;/CCM/MINIMUM_QUANTITY#/CCM/QUANTITY_VALUE;/CCM/MINIMUM_QUANTITY#/CCM/UNIT_CODE;ATTACH
MENT;CANTIDAD_MAXIMA#/CCM/QUANTITY_VALUE;CANTIDAD_MAXIMA#/CCM/UNIT_CODE;CENTROS_CORPORATIVOS;IDIOMA;UTILIZACION
100003;110050000;F-Creatividad (Servicios de Agencia) .
Ejemplo;110050000;6000000;EA;EA;3000001;4600000000;10;1;EA;;100;EA;X;CASTELLANO;GRUPO
End of Content ******
<b>after step 3 a error occurs and I can't access to the master catalog.
If I execute the Report /CCM/VERIFY_CATALOG the next message is shown</b>
Catalog: /CCM/MASTER_CATALOG Exception occured
^ Characteristic /CCM/SHORT_DESCRIPTION not found
^ ^ Characteristic /CCM/SHORT_DESCRIPTION not found
^ ^ ^ Characteristic /CCM/SHORT_DESCRIPTION 0000000003 AI_/CCM/MASTER_CATALOG 0000000001 does not exist
Catalog /CCM/MASTER_CATALOG has no schema assigned
Any suggestion, I haven't a clue about it.
Thanks for you attention
JVL
Hi,
Finally it seems that is a very bad thing have the /CCM/Master_Catalog with 'X' in the field active in the table of header of catalog.
I think when this occurs, the system try to generate a new version and the new record is created, the next time you need read the catalog, system is not able to take the GUID and you get dumps.
Thanks evrybody
Jorge
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
Not sure but in your supplier schema/content you don't define /ccm/short_description (standard charateristic) or perhpas it's a require field ? Try to insert it and you'll see.
bertrand
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Thanks Bertrand, but the problem continues.
I upload my master catalog, then I create a supplier catalog and load the supplier catalog schema.
In this point table /CCM/D_CTLG_REQ , has one record per catalog and both of them are active.
When I start to assign characteristics, <b>I realize that a new version of the master catalog is created (with the same GUID!! ) and is inactive (so two versions of the master catalog).</b>
In that moment, whatever funcion, where master catalog read is necessary, I execute a dump is shown.
any idea about it?
thanks
Jorge
Hi again,
More information about my problem
I have been debugging the bsp and the problem is that when I go to Edit Master Catalog, <b><b>id doesn't take the GUID so, the function GUID_CONVERTER returns an error.</b></b>
Any tip to recover? But in the table two occurences with the same GUID.
I have been a lot of SAP Notes included in SP3 and SP4, but they aren't released yet. Anybody knows when they are going to be released?
Thanks again
Jorge
Hi Jorge,
just to make sure: You must use transaction SA38 to run report /CCM/INITIALIZE_CME before you use SAP Catalog Authoring Tool for the first time. The report checks the Customizing settings you have made and, providing those settings are correct, unpacks the predefined characteristics! If these are not unpacked your system can`t find them.
If you had run that report successfully, try first to get rid of the catalogs with the same GUID. Do the following: Delete all your supplier and purchasing catalog. Delete your master catalog latest. Don´t be afraid, your master catalog will be automatically re-generated again. If you can´t delete all catalogs via web-frontend go via SAP-GUI to CCM customizing and delete the catalog entries there (remember: delete the master catalog latest). Again, the master catalog will be automatically re-generated.
I missed in your description that you loaded a schema to your master catalog, did you? Otherwise, you can´t create attributes there.
Hope that helps a bit.
Regards, Bodo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.