Data Deploy Error

Hi,

I am trying to deploy DCR content into DB2 database. While running deployment, I am getting the following error.
DBD: SQLException occured in TTableSchemaHelper
DBD: Exception Message: DB2 SQL error: SQLCODE: -551, SQLSTATE: 42501, SQLERRMC: GSTT01ID;SELECT;SYSIBM.SYSCOLUMNS
DBD: Vendor Error Code: -551
DBD: SQL state: 42501

DBD: ERROR:Unable to create TTableSchemaHelper object for [STMT_CPY_RQST].

STMT_CPY_RQST is my table name. I know that this error is related to privileges. What I would like to know,what is TTableSchemaHelper and what does it do? I tried to search in DD admin guide but nothing has been mentioned for this.
Any help on this is appreciated.

Thanks for your help in advance.
Sumit

Find more posts tagged with

Comments

Ambuj

Hi,

I am trying to deploy DCR content into DB2 database. While running deployment, I am getting the following error.
DBD: SQLException occured in TTableSchemaHelper
DBD: Exception Message: DB2 SQL error: SQLCODE: -551, SQLSTATE: 42501, SQLERRMC: GSTT01ID;SELECT;SYSIBM.SYSCOLUMNS
DBD: Vendor Error Code: -551
DBD: SQL state: 42501

DBD: ERROR:Unable to create TTableSchemaHelper object for [STMT_CPY_RQST].

STMT_CPY_RQST is my table name. I know that this error is related to privileges. What I would like to know,what is TTableSchemaHelper and what does it do? I tried to search in DD admin guide but nothing has been mentioned for this.
Any help on this is appreciated.

Thanks for your help in advance.
Sumit

I suspect that it is related to DB so you won't be able to find anything relevant in Open Deploy but let's wait if anybody has any idea on this.

kaalraa

Ask your SQL DBA or search in SQL Help File, you will definitely get an answer. It is no where related to TeamSite / Data Deploy. Smiley Happy

...... What I would like to know,what is TTableSchemaHelper and what does it do? I tried to search in DD admin guide but nothing has been mentioned for this. ....

Adam Stoller

Ask your SQL DBA or search in SQL Help File, you will definitely get an answer. It is no where related to TeamSite / Data Deploy.

Are you 100% positive that this has nothing to do with DD?
I ask only because I just googled TTableSchemaHelper and the only hit I got was: http://www.aviationnow.com/media/images/logs/xml/xml_log_17332.txt which appears to be an excerpt of someone's DD logs - for Oracle (not DB2) using DD 5.6.0 (we don't know what version of DD is being used here - because sumitk didn't say)

While you can find a lot of hits out there for "SchemaHelper" - the scarcity of seeing hits for "TTableSchemaHelper" would tend to make me think that this might be a DD-specific issue - one probably having to do with permissions for creating tables or inserting or updating rows in a table.

I'd suggest contacting IWOV Support - and if it does indeed turn out to be a DD-specific item, file a bug against the DD documentation for not mentioning it anywhere.

sumitk

Hi,
Thanks for your response. I am using DD 6.0.2 and DB2 8.2.
I have tested the same configuration with oracle 10 and I was able to update the database. But somehow it is not working with DB2. Now I am not sure whether DD tries to create "TTableSchemaHelper" in database or does it look for this into the database i.e. this table / view should be present in the database already.

So not sure whether its DD issue or DB issue. Can anyone throw light on this? Smiley Happy

Thanks,
Sumit

Bill Klish

Does the user you are attempting to connect to the DB2 database with have the proper privileges for the database or this table?

sumitk

The problem got resolved when the user was given appropriate privilege on the table. But does anyone have any idea about the TTableSchemaHelper table? Why is this been used internally?

Cheers,
Sumit

Adam Stoller

The problem got resolved when the user was given appropriate privilege on the table. But does anyone have any idea about the TTableSchemaHelper table? Why is this been used internally?

Cheers,
Sumit

I imagine that most of us here could only guess at what it is being used for (e.g. to map the DD schema config to the actual DB schema?) - if you want a definitive response I suggest you contact Support.