ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

CEM job J02350DB receives return code 0008

book

Article ID: 239634

calendar_today

Updated On:

Products

Compliance Event Manager

Issue/Introduction

 Running Compliance Event Manger job J02350DB and receiving DBSQLPR is completing with return code 0008, SQL error -14.

Environment

Release : 6.0

Component : COMPLIANCE EVENT MANAGER

Resolution

The DBSQLPR program will generally complete with 8 when it experiences any SQL error.
In this instance, the SQL error is -14 which means the table does not exist. This is because the DROP command tried to drop a table that did not exist yet because the table is new.
The DROP command means to delete a table in a database.   DROPs are done for each table we try to create to ensure the latest definition is in place. If the DROP was not done an error would be received that the table already exists and it would not be created. 
Another way to look at the DROP command is that it is refreshing the tables.  When a -14 SQL error is returned it is because the table never existed before and despite the message it creates the new table.
When creating tables for the first time the -14 SQL error code is expected.  If the job is rerun it will end in a return code of 0000.