Our vBulletin migration is complete.
Welcome vBulletin users! All content and user information from the Micro Focus Forums (vBulletin) site has been migrated to this site. READ MORE.
Honored Contributor.. Ivis Honored Contributor..
Honored Contributor..
770 views

Error in Service Desk after upgrade to 9.31.

Jump to solution

Hi - after upgradring to SM9.31 from 7.10 suddenly get this error when viewing interactions.

This did not happen when we upgraded on the test environment and there has been a freeze period since then.

 

Anyone seen it before?

 

Invalid syntax for query.  Failed parsing (display,show.rio)
incident.id="SD100002" and (
) (display,show.rio)

 

From debug log i can't see where the error is either:

 

foreign.key="SD100002" and slo.id=292)
  3712(  2232) 05/25/2013 16:59:51  RTE D (0x1D069020)      DBACCESS - Fetch Next   against file sloresponse
  3712(  2232) 05/25/2013 16:59:51  RTE D (0x1D069020)      DBACCESS - Fetch Next   against file sloresponse in 0.000000 seconds [rc=9 ]
  3712(  2232) 05/25/2013 16:59:51  RTE D (0x1D069020)      DBACCESS - Fetch Abs(  0) against file sloresponse
  3712(  2232) 05/25/2013 16:59:51  RTE D (0x1D069020)      DBACCESS - Fetch Abs(  0) against file sloresponse in 0.000000 seconds [rc=0 ] (foreign.filename="incidents" and foreign.key="SD100002" and slo.id=292)
  3712(  2232) 05/25/2013 16:59:51  RTE D (0x1D069020)      DBACCESS - Cache Term   against file sloresponse
  3712(  2232) 05/25/2013 16:59:51  RTE D (0x1A404310)      DBACCESS - Cache Find   against file link found 1 record (name="SD.update.interaction")
  3712(  2232) 05/25/2013 16:59:51  RTE D (0x1A404310)      DBACCESS - Cache Find   against file link found 1 record (name="incidents")
  3712(  2232) 05/25/2013 16:59:51  RTE D (0x1CEEC330)      DBACCESS - Cache Init   against file Alert
  3712(  2232) 05/25/2013 16:59:51  RTE D (0x1B63E770)      DBACCESS - Cache Find   against file scaccess found 1 NULL record (filename="Alert" and security.id="")
  3712(  2232) 05/25/2013 16:59:51  RTE D (0x1B63E770)      DBACCESS - Cache Find   against file scaccess found 1 NULL record (filename="Alert" and security.id=NULL)
  3712(  2232) 05/25/2013 16:59:51  RTE D (0x1CEEC330)      DBACCESS - Select       against file Alert
  3712(  2232) 05/25/2013 16:59:51  RTE D DBQUERY^F^Alert(sqlserver I)^4^0.000000^ ^0^0.000000^"unique.key="SD100002" and (alert.type="sla" and file.name="incidents" and active=false)"^ ^0.000000^0.000000 ( [ 1] display show.rio )
  3712(  2232) 05/25/2013 16:59:51  RTE D (0x1CEEC330)      DBACCESS - Select       against file Alert in 0.000000 seconds [rc=9 ]
  3712(  2232) 05/25/2013 16:59:51  RTE D (0x1CEEC330)      DBACCESS - Cache Term   against file Alert
  3712(  2232) 05/25/2013 16:59:51  RTE D (0x1A404310)      DBACCESS - Cache Find   against file link found 1 record (name="SD.update.interaction")
  3712(  2232) 05/25/2013 16:59:51  RTE D (0x1D0FC4A0)      DBACCESS - Cache Init   against file incdepends
  3712(  2232) 05/25/2013 16:59:51  RTE D (0x1B64B210)      DBACCESS - Cache Find   against file scmessage found 1 record (syslanguage="en" and class="scev" and message.id="139")
  3712(  2232) 05/25/2013 16:59:51  RTE E incident.id="SD100002" and (
) (display,show.rio)
  3712(  2232) 05/25/2013 16:59:51  RTE E Invalid syntax for query.  Failed parsing (display,show.rio)
  3712(  2232) 05/25/2013 16:59:51  RTE D (0x1D0FC4A0)      DBACCESS - Cache Term   against file incdepends
  3712(  2232) 05/25/2013 16:59:51  RTE D (0x1A404310)      DBACCESS - Cache Find   against file link found 1 record (name="SD.update.interaction")
  3712(  2232) 05/25/2013 16:59:51  RTE D (0x1CEEC010)      DBACCESS - Cache Init   against file Approval
  3712(  2232) 05/25/2013 16:59:51  RTE D (0x1CEEC010)      DBACCESS - Select       against file Approval
  3712(  2232) 05/25/2013 16:59:51  RTE D DBQUERY^F^Approval(sqlserver I)^1^0.000000^ ^0^0.015000^"unique.key="SD100002" and file.name="incidents""^ ^0.000000^0.000000 ( [ 1] display show.rio )

 

BR Ivis

Tags (1)
0 Likes
1 Solution

Accepted Solutions
Highlighted
Honored Contributor.. Ivis Honored Contributor..
Honored Contributor..

Re: Error in Service Desk after upgrade to 9.31.

Jump to solution

Hi - and thanks for your reply.

I solved the issue by removing 'Required Actions' suborm as we don't use the complete Service Desk module.

 

So issue is solved.

 

BR Ivis.

0 Likes
2 Replies
Absent Member.. hansmaulwurf Absent Member..
Absent Member..

Re: Error in Service Desk after upgrade to 9.31.

Jump to solution

Does this error occur while accessing an interaction or already in the view/queue?

0 Likes
Highlighted
Honored Contributor.. Ivis Honored Contributor..
Honored Contributor..

Re: Error in Service Desk after upgrade to 9.31.

Jump to solution

Hi - and thanks for your reply.

I solved the issue by removing 'Required Actions' suborm as we don't use the complete Service Desk module.

 

So issue is solved.

 

BR Ivis.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.