When going into the properties for the GenericSQLAgent and clicking the Edit button to retrieve the list of SQL Statements, the following error message is displayed:
"Cannot call method concat of undefined".
WORKAROUND #1
1. Retrieve the list of SQL statements:
a. login to the FMS database
b. run the following SELECT statement:
SELECT encoded_data from persistable_config_model where known_name = '<enter_your_SQL_Statement_list_name>'
c. This should give the original ASP in XML format. You should be able to see the original statement in there.
WORKAROUND #2
2. Delete the offending ASP from the database:
a. use the following SQL command first:
SELECT DISTINCT id, adapter, agent_type, sharing_name, known_name, COUNT(*) FROM persistable_config_model WHERE known_name = '<enter_your_SQL_Statement_list_name>' GROUP BY id;
b. if result has only one row, then there is only one ASP with that known name (the count column may be greater than 1 as there might be multiple versions) and you can now use the following SQL command to delete it:
DELETE FROM persistable_config_model WHERE known_name='<enter_your_SQL_Statement_list_name>';
c. if there are multiple rows in the result, then you would need to figure out which id represents the offending ASP. The SQL result should give you enough information to determine that and then select the id column for deletion.
Once deleted, the config page should be able to load again. In the unlikely event that it does not, please restart the server and try again.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center