j_4jamshaid
Newbie
Karma: 2
Posts: 38
|
 |
« on: April 28, 2008, 11:26:37 am » |
|
Hi,
i am trying to insert a record in LongDescription Table, I created a notify interface and inserting record using webservice. I am geting following exception. Any idea whats wrong here?
Cannot query on field LDKEY. Search type is NONE.
at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:222)
at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:129)
at org.apache.axis.encoding.DeserializationContext.endElement(DeserializationContext.java:1087)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at javax.xml.parsers.SAXParser.parse(Unknown Source)
at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)
at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
at org.apache.axis.client.Call.invoke(Call.java:2767)
at org.apache.axis.client.Call.invoke(Call.java:2443)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at edu.pu.webload.ws.longdesc.longdescnotifystubs.MXLongDescInterfaceBindingStub.processDocument(MXLongDescInterfaceBindingStub.java:311)
at edu.pu.client.TestClient.createDesc(TestClient.java:152)
at edu.pu.client.TestClient.main(TestClient.java:38)
|
|
|
|
|
Logged
|
|
|
|
|
amdisuk
|
|
« Reply #1 on: April 28, 2008, 12:32:19 pm » |
|
I'm not sure about this one. I have never tried inserting into long_description before. Normally you would insert into a long description via another table.
Can I ask why you are trying to insert directly into long_description?
Al
|
|
|
|
|
Logged
|
Big Al
|
|
|
j_4jamshaid
Newbie
Karma: 2
Posts: 38
|
|
« Reply #2 on: April 28, 2008, 04:20:04 pm » |
|
I have a ticket table. i need to add its long description. There is no direct relation of ticket table and Long_desc table. in ticket table we have boolean feild hasLD and in long_desc table we have feilds like LDOWNERTABLE and LDOWNERCOL that defines indirect relation. So i need to add long desc by inserting records in LongDesc directly... Please guide if there is any workway around.
Thnks
|
|
|
|
|
Logged
|
|
|
|
|
amdisuk
|
|
« Reply #3 on: April 29, 2008, 08:19:40 am » |
|
OK, what I would do to insert these records is use the Mbo's. So first get the Mboset and add to that rather than using raw sql. The benefit is that you will also have to comply with the business logic on the records that you are inserting.
It is a lot slower i'm afraid but it's the way you should be doing it. You can access the long_description field that way too.
Al
|
|
|
|
|
Logged
|
Big Al
|
|
|
j_4jamshaid
Newbie
Karma: 2
Posts: 38
|
|
« Reply #4 on: April 29, 2008, 12:18:47 pm » |
|
Thanks Al,
I guess making it through mboset would work. but i have taken another solution. What i was looking to do was to add a record in long_description table for my ticket's longdescriptions. Altough there is no direct relation between Ticket and Long_Description table but maximo handles it internally. What i did in this case was i created a new integration object on ticket mbo and included its non-persistence field "Description_LongDescription". Then i created a notify interface on that intergration object and deployed it as webservice and using it i got the desired results.
My finding is Description_LongDescription Attribute is included for those MBO's whose extra description is desired to be recorded in LongDescription table. Maximo handles its relation internally. How it handles is still a query for me....
Another lesson learnt is when u add/change attributes to mbo's or intergration point these are not reflected to the existing interfaces. What i did, i have to create new Integration Points. May be there is some way to update existing IP's. if any Please Share...
@Jamshaid..
|
|
|
|
|
Logged
|
|
|
|
|
