Unable to run any queries, reports nor run scheduled jobs created from NEW folders within Deployment Manager after migration.

Additional symptoms:
1. The Job Name column within the job history of a newly created job, even one that runs successfully, may be blank.

2. Deployment Portal error:
-Exception occurred while parsing the SOAP response to get the Document object.

3. Errors in PES.log:
- General Exception saving submit work
- Cannot find parent folder

The stored procedure/UDF (spsscmor_fn_gp) became corrupted sometime during the install/migration of C&DS.

The stored procedure/UDF (spsscmor_fn_gp) became corrupted during the install/migration of C&DS and needs to be recreated within the C&DS library. To resolve this issue, you need to drop the existing User Defined Function (SPSSC00001 SQL FUNCTION SPSSCMOR_FN_GP getPath) and recreate it within SQL.

Steps to perform:

1. Stop your C&DS Server (WebSphere profile)

2. Need to logon to the iSeries with the Same profile that was used to run the Install Setup (clisetup) of C&DS. To verify what profile was used, perform the following:
· Note: replace C&DS with the name of your C&DS server name.
· WRKOBJ OBJ(C&DS/*ALL) OBJTYPE(*SRVPGM) Press Enter
· Take a Option 8 =Display Description next to: SPSSC00002 FUNCTION SPSSCMOR_FN_GL
· Then locate who the owner is in the upper right corner.
· This will be the profile that you will need to log onto the iSeries with to perform the Drop & Create commands below.

3. Start SQL using commands:
CHGJOB CCSID(37)
STRSQL

4. Steps to DROP the existing function in SQL (SPSSC00001 SQL FUNCTION SPSSCMOR_FN_GP).
Ø NOTE: Replace <C&DS_Library> with the name of your C&DS library name.

------------------------------------------------------------
Command to drop the existing function:
------------------------------------------------------------

drop function <C&DS_library>/spsscmor_fn_gp
------------------------------------------------------------


5. Steps to CREATE the new function in SQL (SPSSC00001 SQL FUNCTION SPSSCMOR_FN_GP).
Ø NOTE: Replace <C&DS_Library> with the name of your C&DS library name.
Ø NOTE: In order to get the entire Create function statement into STRSQL, try the following:
a. Copy the entire Create function statement listed below.
(Use F6 (Insert Line) until you have nothing but empty lines on the screen)
b. Then use the Edit/ PASTE function to paste in the entire command.
c. Then run it by pressing ENTER.
d. You should receive message: Function SPSSCMOR_FN_GP was created in <C&DS_library>.

Command to create the new function:
------------------------------------------------------------

create function <C&DS library>/spsscmor_fn_gp ( objid
character(18), rootid character(18)) RETURNS VARGRAPHIC(1024) CCSID
13488 LANGUAGE SQL READS SQL DATA DETERMINISTIC NO EXTERNAL ACTION
BEGIN ATOMIC DECLARE rtnval VARGRAPHIC(1024) CCSID 13488 default
N''; DECLARE tempval VARGRAPHIC(1024) CCSID 13488 default N'';
DECLARE tempobjid character(18) default ''; DECLARE nextnsid
character(18) default ''; DECLARE rootfound smallint default 0; SET
tempobjid = objid; SET rtnval = ''; IF rootid IS NULL OR rootid =
objid THEN SET rootfound = 1; ELSE SET rootfound = 0; END IF; WHILE
tempobjid IS NOT NULL DO SET nextnsid = NULL; SELECT nsid, objname
INTO nextnsid, tempval FROM SPSSCMOR_NAMEDOBJECT N WHERE N.objid =
tempobjid AND (rootid IS NULL OR N.objid <> rootid); SET tempobjid
= nextnsid; IF tempobjid IS NOT NULL THEN IF length(rtnval) > 0
THEN SET rtnval = tempval || '/' || rtnval; ELSE SET rtnval =
tempval; END IF; IF nextnsid = rootid THEN SET rootfound = 1; END
IF; END IF; END WHILE; IF rootfound = 0 THEN RETURN NULL; END IF;
RETURN '/' || rtnval; END

6. When create is finished, restart C&DS Server (WebSphere profile).
7. Note: a repository re-index (via Deployment Manager web browser) might be required to fully resolve the issue after recreating the function