I am getting DSNT408I SQLCODE = -204, ERROR: PTI.PTSQL_TEXT_115 IS AN UNDEFINED NAME, how do I address this error?

Document ID : KB000008428
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

User complains about receiving the following error message:

DSNT408I SQLCODE = -204, ERROR: PTI.PTSQL_TEXT_115 IS AN UNDEFINED NAME
DSNT418I SQLSTATE = 42704 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXOTL SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -500 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFE0C' X'00000000' X'00000000'
X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION

Note we also previously ran the 0000, 0001, 0002 jobs (compare, create missing objects, binds) but no new objects were detected.

Resolution:

The PTI.PTSQL_TEXT_115 table would have been created in the ssid0001 job from the post-install process). This job takes as its input an ssidDDL member which is created by the previous job ssid0000. It is that ssidDDL member that should contain the CREATE for that table as well as any others that may be missing.  If the above doesn't help, then the following will be needed for more investigation:

1/ All the job outputs relating to runs done during post-install i.e. all outputs for ssid0000 and ssid0001 

2/ The ssidDDL member(s) that were created as a result of running ssid0000.