When using the Surrogate Key Generator Stage, the following errors are being generated:
Surrogate_Key_Generator_33,1: Error Idx = 1; DB2Driver Embedded SQL message: SQL0552N "ETLUSER" does not have the privilege to perform operation "IMPLICIT CREATE SCHEMA". SQLSTATE=42502; sqlcode = -552; sqlstate = 42502
and
Surrogate_Key_Generator_33,1: Program not bound to database
Attempting to bind /opt/app/IBM/InformationServer/Server/DSComponents/bin/db2esql80.bnd to the database ETLDB ....failed
I'm trying to use the same connection parameters used for DB2 UDB stages (DB2 EE stages are not an option for us). Do you need a DB2 EE connection for the Surrogate Key Generator Stage, or am I just missing something with the properties?
Surrogate Key Stage Error
Moderators: chulett, rschirm, roy
Surrogate Key Stage Error
- Stephen -
Re: Surrogate Key Stage Error
Seems Either Key column name( ie is the one you are generating using the Surrogate Key Generator) is not there in the Target table.
Thanks
Manish
Manish
Re: Surrogate Key Stage Error
Seems Either Key column name( ie is the one you are generating using the Surrogate Key Generator) is not there in the Target table.
Thanks
Manish
Manish
It turns out this error was truly what it said, database permissions. ETLUSER was in a group which did not have 'Indirect Implicit Schema' authority. The error does seem misleading though as the Surrogate Key Generator does not need to 'CREATE SCHEMA.'
Anyways, you can use the Surrogate Key Generator Stage without DB2 Enterprise connectivity.
Anyways, you can use the Surrogate Key Generator Stage without DB2 Enterprise connectivity.
- Stephen -