CEM job J02350DB receives return code 0008
Article ID: 239634
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.
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.
Feedback
Yes
No
Powered by
