Dear Listers,
I am trying to import data from a csv file into the Computer system class in CMDB 2.1.0 p002. In doing this when I run the data exchange, I get the following errors. The csv file was created from a remedy application report feature. When I check the field type in the Computer System class and in the csv file, they all are character fields. When I run the exchange, AIE wrote the following error messages while trying to import the data into CMDB. Even Date fields in the CSV are stored as Character fields. Any idea why I get this error message and how should I overcome this problem? AR Server 7.1.0 p002 MS SQL 7 Windows 2003 CMDB 2.1.0 p002 AIE 7.1.0 p003 Regards Satya [Wed Jul 30 2008 10:01:58.1390] - <TID: 001> <STS > Scheduled Only mode [Wed Jul 30 2008 10:01:58.1860] - <TID: 001> <STS > StartDataHandlers: Connection established to both AR/CMDB and vendor application. [Wed Jul 30 2008 10:01:58.8110] - <TID: 001> <ERR > *** Field Mapping Error for Serial Number *** [Wed Jul 30 2008 10:01:58.8110] - <TID: 001> <ERR > --> Data type undefined [Wed Jul 30 2008 10:01:58.8110] - <TID: 001> <ERR > *** Field Mapping Error for Inventory CI Name *** [Wed Jul 30 2008 10:01:58.8110] - <TID: 001> <ERR > --> Data type undefined [Wed Jul 30 2008 10:01:58.8110] - <TID: 001> <ERR > *** Field Mapping Error for Asset Tag *** [Wed Jul 30 2008 10:01:58.8110] - <TID: 001> <ERR > --> Data type undefined [Wed Jul 30 2008 10:01:58.8110] - <TID: 001> <ERR > *** Field Mapping Error for Live Date *** [Wed Jul 30 2008 10:01:58.8110] - <TID: 001> <ERR > --> Data type undefined [Wed Jul 30 2008 10:01:58.8110] - <TID: 001> <ERR > *** Field Mapping Error for Delivery Date *** [Wed Jul 30 2008 10:01:58.8110] - <TID: 001> <ERR > --> Data type undefined [Wed Jul 30 2008 10:01:58.8110] - <TID: 001> <ERR > *** Field Mapping Error for Server Role *** [Wed Jul 30 2008 10:01:58.8110] - <TID: 001> <ERR > --> Data type undefined [Wed Jul 30 2008 10:01:58.8110] - <TID: 001> <ERR > *** Field Mapping Error for Installation Date *** [Wed Jul 30 2008 10:01:58.8110] - <TID: 001> <ERR > --> Data type undefined [Wed Jul 30 2008 10:01:58.8110] - <TID: 001> <ERR > *** Field Mapping Error for Heat Rating *** [Wed Jul 30 2008 10:01:58.8110] - <TID: 001> <ERR > --> Data type undefined [Wed Jul 30 2008 10:01:58.8110] - <TID: 001> <ERR > *** Error: Validation of rules failed. No data exchange will start until the problem is fixed. [Wed Jul 30 2008 10:01:58.8110] - <TID: 001> <STS > StopDataHandlers: Disconnected from both AR/CMDB and Vendor application. -- Thanks & Regards Satya Gandhi Consultant - Remedy _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"