ORA-00934: group function is not allowed here

yuga1234 · Post by **yuga1234** » Tue Jan 17, 2012 2:09 am

I am getting the same error as noted here when tried to UPSERT using oracle connector in datastage 8.5

the auto generated query :

The connector generated the following RETURNING statement at runtime: UPDATE SIDBOR_ETL.tmp_1 SET C=:c,B=:b WHERE A=:a RETURNING COUNT(ROWID) INTO :3.
The connector generated the following UPDATE statement at runtime: UPDATE SIDBOR_ETL.tmp_1 SET C=:c,B=:b WHERE A=:a.
The connector generated the following INSERT statement at runtime: INSERT INTO SIDBOR_ETL.tmp_1(C,A,B) VALUES(:c,:a,:b).

Eventhough i tried with custom query ,But iam getting the same error

Oracle_Connector_3,1: The OCI function OCIStmtExecute returned status -1. Error code: 934, Error message: ORA-00934: group function is not allowed here. (CC_OraStatement::executeUpdate, file CC_OraStatement.cpp, line 1996)

Can any one help me with this error.

v2kmadhav · Post by **v2kmadhav** » Tue Jan 17, 2012 3:26 am

Can you try splitting the job into two steps and see if you still get the same error...

yuga1234 · Post by **yuga1234** » Tue Jan 17, 2012 4:00 am

individually insert and update is working fine

But When we use UPSERT its showing this error

v2kmadhav · Post by **v2kmadhav** » Tue Jan 17, 2012 4:22 am

what is the array size ?

yuga1234 · Post by **yuga1234** » Tue Jan 17, 2012 4:32 am

Array size is 1

v2kmadhav · Post by **v2kmadhav** » Tue Jan 17, 2012 4:40 am

what are the column names in queries that get generated.. im hoping none of them are oracle reserve words

v2kmadhav · Post by **v2kmadhav** » Tue Jan 17, 2012 4:44 am

Sorry, I guess thats a silly question - since you have already used the same metadata to do seperate INSERT/UPDATE query tests.

Could you try deleting that stage and redoing the properties with a new one to ensure you havent got anything hanging in it from another query/job if you copied the stage from somewhere else..

yuga1234 · Post by **yuga1234** » Tue Jan 17, 2012 5:08 am

No its just a temp job to test
i dint copy any metadata or stages from any other job

chulett · Post by **chulett** » Tue Jan 17, 2012 7:47 am

Split into your own post.

Please don't "me too" on the end of older posts, always start your own and then (if it seems like it would help) link to the older post.