Jump to content
Sign in to follow this  
chirag

Interpreter Error

Recommended Posts

We are using CA SDM 12.6

Recently some end users(employee view) got the following error on logging in :

AHD04405:CA Service Desk Manager system internal error

Below is the entry from log for one such user:

8203 Cancelling session chethann1-641274620:0x91e1340 due to interpreter error

Here are a few more lines from the log which were present before the above entry:

4470 SQL parse error: parse error, expecting `'('' at read_pgroup N''

4471 SELECT attmnt_folder.id FROM attmnt_folder WHERE ( attmnt_folder.repository = 'doc_rep:1000' and attmnt_folder.parent_id = 0 ) AND ( attmnt_folder.read_pgroup IN '' )

7816 Unable to receive record for PDM_LIST at kt_tbl_cache.htmpl[25]: parse error, expecting `'('' at read_pgroup N''

4470 SQL parse error: parse error, expecting `'('' at read_pgroup N''

4471 SELECT attmnt_folder.id FROM attmnt_folder WHERE ( attmnt_folder.repository = 'doc_rep:1001' and attmnt_folder.parent_id = 0 ) AND ( attmnt_folder.read_pgroup IN '' )

7816 Unable to receive record for PDM_LIST at kt_tbl_cache.htmpl[25]: parse error, expecting `'('' at read_pgroup N''

4470 SQL parse error: parse error, expecting `'('' at read_pgroup N''

4471 SELECT attmnt_folder.id FROM attmnt_folder WHERE ( attmnt_folder.repository = 'doc_rep:1002' and attmnt_folder.parent_id = 0 ) AND ( attmnt_folder.read_pgroup IN '' )

7816 Unable to receive record for PDM_LIST at kt_tbl_cache.htmpl[25]: parse error, expecting `'('' at read_pgroup N''

4470 SQL parse error: parse error, expecting `'('' at read_pgroup N''

4471 SELECT attmnt_folder.id FROM attmnt_folder WHERE ( attmnt_folder.repository = 'doc_rep:400002' and attmnt_folder.parent_id = 0 ) AND ( attmnt_folder.read_pgroup IN '' )

7816 Unable to receive record for PDM_LIST at kt_tbl_cache.htmpl[25]: parse error, expecting `'('' at read_pgroup N''

4470 SQL parse error: parse error, expecting `'('' at READ_PGROUP N''

4471 SELECT DISTINCT SKELETONS.BU_RESULT,SKELETONS.MODIFY_DATE,SKELETONS.id FROM SKELETONS WHERE ( SKELETONS.ACTIVE_STATE = 0 ) AND ( ( SKELETONS.READ_PGROUP IN '' OR SKELETONS.READ_PGROUP IN ( SELECT pgroup FROM usp_role_pgroup WHERE role = 10005 ) ) and SKELETONS.ACTIVE_STATE = 0 ) ORDER BY SKELETONS.BU_RESULT DESC , SKELETONS.MODIFY_DATE DESC

2006 Error getting 10 top KDs: parse error, expecting `'('' at READ_PGROUP N''

6180 Spell interp failed at GetTopFAQsCustEmp (...) freeaccess.spl:2009 | display_form (...) freeaccess.spl:16603: Math argument type mismatch

6126 Spell interp failed at freeaccess.spl:2010:GetTopFAQsCustEmp | freeaccess.spl:16603:display_form: Reply message [1]: bad index - size is 1

I'm not able to understand what is causing this.

Anyone have any idea or similar experience...?

Share this post


Link to post
Share on other sites

I got the same error. Now looking for resolution. It is only being seen for one user currently.

4016 ERROR parse.c 7724 Unable to receive record for PDM_LIST at kt_tbl_cache.htmpl[25]: parse error, expecting `'('' at read_pgroup N''

4016 ERROR parse.c 7724 Unable to receive record for PDM_LIST at kt_tbl_cache.htmpl[25]: parse error, expecting `'('' at read_pgroup N''

4016 ERROR parse.c 7724 Unable to receive record for PDM_LIST at kt_tbl_cache.htmpl[25]: parse error, expecting `'('' at read_pgroup N''

4016 ERROR parse.c 7724 Unable to receive record for PDM_LIST at kt_tbl_cache.htmpl[25]: parse error, expecting `'('' at read_pgroup N''

4016 ERROR parse.c 7724 Unable to receive record for PDM_LIST at kt_tbl_cache.htmpl[25]: parse error, expecting `'('' at read_pgroup N''

4016 ERROR freeaccess.spl 1994 Error getting 10 top KDs: parse error, expecting `'('' at READ_PGROUP N''

4016 ERROR pcexec.c 6187 Spell interp failed at GetTopFAQsCustEmp (...) freeaccess.spl:1997 | display_form (...) freeaccess.spl:16285: Math argument type mismatch

4016 ERROR pcexec.c 6133 Spell interp failed at freeaccess.spl:1998:GetTopFAQsCustEmp | freeaccess.spl:16285:display_form: Reply message [1]: bad index - size is 1

4016 ERROR session.c 8163 Cancelling session XXX-423558585:0x107e45b8 due to interpreter error

Edited by jonasborg

Share this post


Link to post
Share on other sites

The errors above come from the Data Partition associated with the Role - de-activate the Data Partition constraints for the Knowledge documents for the Role and try again. I know it's an old post, but this might help someone.

Share this post


Link to post
Share on other sites

Hello Mitu,

This is awesome...the issue was resolved after the data partition was deactivated.

This issue was really embarrassing...and the resolution is highly appreciated!

Now the employee is able to login but when he opens any knowledge document, he just gets a popup saying 'parse error, expecting "(" at read_pgroup N"'

This is happening only for a particular employee....any suggestion on this?

Also, wanted to know how did you find out the cause of the issue?

Share this post


Link to post
Share on other sites

My explanation for this behavior is the following - back in the days, permissions on KB docs and categories were done through Groups, but nowadays you have the option to use Roles to set permissions on Categories (and propagate to documents). The Data partition clauses related to KB docs and categories are in place to take care of access based on Groups, however if the user (especially an End User) is not in any Group, these constraints operate on an empty set - hence the error.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...