Service Desk Practitioners Forum
cancel

OVSD 4.5 SP17 attachment problem

Highlighted
yap
Super Contributor.

OVSD 4.5 SP17 attachment problem

Hi all,
I've a problem with OVSD where when I click on service call with attachment, the error message "Query Builder got non-persistable attribute type 5 in attribute selection". When I did "sd_dbconfwizard.bat -checkstructure", I saw error below:

Orginal exception:java.lang.Exception: No columns found for table:ifc_attachmentclassifications
java.lang.Exception: Exception in checkTables on query:

Anyone encounter similar error before ? Any solution or workaround available ?

regards,
tenghin
6 REPLIES
Karol Raffay
Super Contributor.

Re: OVSD 4.5 SP17 attachment problem

Have you this problem at new Service calls,too?
Have you set up any value in an attachment classification(Data-Codes-Attachment Clasification Code)?
You try to check a table IFC_ATTACHMENTCLASSIFICATIONS on the server SD.
yap
Super Contributor.

Re: OVSD 4.5 SP17 attachment problem

Hi Karol,
I did not see "Data->Codes->Attachment Classification Code". Is it default code provided by SD ? What is attachment classification ? I can't find any information on it.

Thanks.

regards,
tenghin
JaS_4
Acclaimed Contributor.

Re: OVSD 4.5 SP17 attachment problem

Hi Yap,

In my ifc_attachmentclassifications table on my SP17 db, I see 5 columns : aca_attachment_oid, aca_lockseq, aca_oid, aca_rcd_oid and aca_tem_oid.

Check what your ifc_attachmentclassifications looks like.
Karol Raffay
Super Contributor.

Re: OVSD 4.5 SP17 attachment problem

Hi yap,

Data->Codes->Attachment Classification Code is in OVSD 4.5 SP 17.It uses on classification attachment type for example:
text,picture etc..
In DB Rules - "Alerts" is possibility select from checkbox "Send out Attachment Classification".I uses to send e-mail with or without attachment.

You try to look this link:
http://forums1.itrc.hp.com/service/forums/bizsupport/questionanswer.do?threadId=995213
This is my question,but I reported under colleague nick.
yap
Super Contributor.

Re: OVSD 4.5 SP17 attachment problem

Hi JaS,
My ifc_attachmentclassification table also have five columns:

SQL> desc ifc_attachmentclassifications;
Name Null? Type
----------------------------------------- -------- ----------------------------
ACA_ATTACHMENT_OID NUMBER(18)
ACA_LOCKSEQ NUMBER(9)
ACA_OID NOT NULL NUMBER(18)
ACA_RCD_OID NUMBER(18)
ACA_TEM_OID NUMBER(18)


Hi Karol,
My OVSD is on SP17, however I did not see "Data->Codes->Attachment Classification Codes" ?? Any idea ?

regards,
tenghin
Karol Raffay
Super Contributor.

Re: OVSD 4.5 SP17 attachment problem

You try to look this
Data->Codes->General->Attachment Classification Code

I forgot to write this word "General".Sorry:)

Karol