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

Technote (troubleshooting)


Problem(Abstract)

Within Deployment Manager (thick/thin client) unable to run a Query (.dbq), Report (.rpt), or schedule new jobs from a folder created post migration.

Symptom

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

Cause

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

Resolving the problem

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 SUPCDS421/spsscmor_fn_gp ( objid character(18),
rootid character(18)) RETURNS VARGRAPHIC(1024) CCSID 13488 LANGUAGE
SQL READS SQL DATA 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


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

SPSS Collaboration and Deployment Services
Deployment Portal

Software version:

4.2.1

Operating system(s):

IBM i

Software edition:

All Editions

Reference #:

1589319

Modified date:

2013-08-01

Translate my page

Machine Translation

Content navigation