You say: "So in order to import records to AST:ComputerSystem, I imported records to both BMC:BMC_ComputerSystem_ and BMC:BMC_AssetBase with matching Instance IDs."
Do you mean you actually import into each separately? I have not done this in a while but I remember only having to import records into BMC:BMC_ComputerSystem_ which in turn created the BMC:BMC_AssetBase. Could this be the problem? On 11/22/06, Scott Parrish <[EMAIL PROTECTED]> wrote:
Off the top of my head, I believe the ClassId for the imported records must match the ClassId for the class in SHR:SchemaNames . . . if you look at the ClassID of the records that you manually created you will notice that it is the same for each record. You will need to add the ClassID field and it's hard coded value to your import (or create workflow to do a lookup on import). Scott Parrish IT Prophets, LLC (770) 653-5203 http://www.itprophets.com -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Meyer, Jennifer Sent: Wednesday, November 22, 2006 11:06 AM To: [email protected] Subject: Query does not show existing records Hello, Listers, Overview:I have imported a number of test records into AST:ComputerSystem; however, when I perform an unqualified search on the form, no records are retrieved. Details:If I create new records from AST:ComputerSystem, those records are retrieved, but not my imported records. I have run logging on both the submit and the query. AST:ComputerSystem is an inner join of BMC:BMC_ComputerSystem on itself. BMC:BMC_ComputerSystem is an inner join of BMC:BMC_ComputerSystem_ with BMC:BMC_AssetBase. So in order to import records to AST:ComputerSystem, I imported records to both BMC:BMC_ComputerSystem_ and BMC:BMC_AssetBase with matching Instance IDs. I can see the records exist in AST:ComputerSystem using a SQL select statement, but they don't appear in the Remedy query. (select InstanceID from AST_ComputerSystem) Environment: ARS 6.3, ITSM 6.0, Solaris 10, Oracle 9i Does anyone have an idea what I'm doing wrong? Jennifer Meyer Remedy Support Engineer Strategic Technologies Inc. [EMAIL PROTECTED] ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
-- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer www.specificintegration.com 703-376-1249 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
