Unable to understand this error message

avunoori · Post by **avunoori** » Fri Dec 17, 2010 9:50 am

Tera_Con_ENGR_ITM_VERS: [IIS-CONN-TERA-005009] Query returned 0 row(s). SQL statement: LOCK ROW FOR ACCESS SELECT TRIM(TableKind) FROM DBC.Tables WHERE DatabaseName = 'DB_NAME' AND TableName = 'Table_Nm' (CC_TeraConnection::getTableKind, file CC_TeraConnection.cpp, line 1,714)

When i try to Load data into Table it throws up this error and Job aborts. Can any body understand me what kind of error and why do we get this?

Need any more info please ask, I will provide.

chulett · Post by **chulett** » Fri Dec 17, 2010 10:41 am

What happens when you execute the same query under the same userid outside of DataStage? Does it return any rows?

avunoori · Post by **avunoori** » Fri Dec 17, 2010 12:09 pm

Yes , it does return rows when i do a select on that table. but I think i am unable to insert right?

chulett · Post by **chulett** » Fri Dec 17, 2010 12:23 pm

Let's make sure we're talking about the same "that table"... I meant can you run the query in the error message, not can you select from your target table.

ray.wurlod · Post by **ray.wurlod** » Fri Dec 17, 2010 2:43 pm

Maybe you don't (and shouldn't have?) INSERT privilege to this table?

PaulVL · Post by **PaulVL** » Fri Dec 17, 2010 5:00 pm

What is the initial SQL statement and which stage are you using?

pg_smh · Post by **pg_smh** » Sun Dec 19, 2010 6:23 am

Try this:

SELECT TRIM(TableKind) as TableKind FROM DBC.Tables WHERE DatabaseName = 'DB_NAME' AND TableName = 'Table_Nm'