Warning Message - Table not found

Raftsman · Post by **Raftsman** » Thu Apr 25, 2013 1:14 pm

We're running PX 8.5 on Unix and during a run, we received a warning message stating that a table was not found. I know from previous experiences with Datastage that it would abort when this happens. The difference I see is, we are using Aliases and there was no data to load.

We are running on DB2.

Has anyone ever experienced this and opened a PMR regarding it.

Thanks in advance

ray.wurlod · Post by **ray.wurlod** » Thu Apr 25, 2013 5:37 pm

"Table not found" is very different from "table exists but has no rows to process". DataStage will abort in the former case but will happily process those zero rows in the latter case.

Check again that you have spelled the table/alias name correctly, that the alias does actually exist, and that your credentialled user has privileges to SELECT. Also that you're executing in the correct schema.

Raftsman · Post by **Raftsman** » Fri Apr 26, 2013 7:44 am

The table really doesn't exist and Datastage is throwing a warning. First time I see this. Other jobs that use this table in other Projects abort. I have setup project and never seen a Error Severity switch to set the different levels. This one is really weird.

Raftsman · Post by **Raftsman** » Mon Apr 29, 2013 10:52 am

We found the answer. When there are no input records and the target table is missing, Datastage throws a warning. As soon as we have records from the input, the Datastage Job aborts.

ray.wurlod · Post by **ray.wurlod** » Mon Apr 29, 2013 4:25 pm

How can you have records from the input if the table is missing?

chulett · Post by **chulett** » Mon Apr 29, 2013 4:52 pm

Target table.

ray.wurlod · Post by **ray.wurlod** » Mon Apr 29, 2013 8:16 pm

Would you believe I once worked on a project where there was a source table called TARGET? Should've been SALES_TARGET, but I didn't have enough weaponry with me at the time to mount a convincing argument.

chulett · Post by **chulett** » Mon Apr 29, 2013 10:16 pm

nikhil_bhasin · Post by **nikhil_bhasin** » Tue Apr 30, 2013 3:40 am

I think Raftsman was pointing towards empty source(file/table) and missing target table...

Raftsman · Post by **Raftsman** » Wed May 01, 2013 10:12 am

I guess I need to clarify information in more detail, my apologies.

Source Records = 0

Target Table Missing

Datastage response: Warning

Source Records = 10

Target Table Missing

Datastage Response: Fatal

chulett · Post by **chulett** » Wed May 01, 2013 10:14 am

Raftsman wrote:I guess I need to clarify information in more detail, my apologies.

No, not really.