Error when selecting "For Approval" in Change Queu

[harn145]

On any SC4 system, the following can occur:



Situation

In Change Queue, user selects "For Approval" button on the left. The system prompt the user to select the Approval Groups the user wants to approve for.



After selecting 1 or more and the confirmation, the systems errors and return to the main user menu.



Reason

This error occurs when, in the profile definition, the "append.query" field is empty, but not NULL.



Solution

1. These actions are only applicable if you are not currently using Append Query functionality.

Go to Change Management/Maintenance/Profiles

Select all records (true search)

Select Options/Update/Complex Update

On "instructions for action on EACH RECORD" type the following:

append.query in $file=NULL

Select Execute



2. These actions are only applicable if you are currently using Append Query functionality

Go to Change Management/Maintenance/Profiles

Select Options/Advanced Search

Replace the text in the "query" field (true) with the following string:

lng(append.query)=0

Select the search icon

Select Options/Update/Complex Update

On "instructions for action on EACH RECORD" type the following:

append.query in $file=NULL

Select Execute



If you are on a RDBMS back-end, the last query might not work, if you don't have "append.query" indexed or mapped specifically. You will have to execute the action manually, per record.



Regards,

Jos

[launchwise]

Excellent



It works for me.