Why are IWTEMP tables being created?

Bill Klish

TeamSite 6.5 SP1
Solaris 2.9
OpenDeploy 6.0.2

We are attempting to perform a real update using standalone DataDeploy and we are getting a Null Pointer Exception. I am not sure why it looks to be logging into the database again and then creating IWTEMP tables. This is a simple 4 column table that has 2 rows in it. In this deployment, non of these rows were changed, so I am not really sure what DataDeploy is doing. Can someone shed some light on this?

DD : TTableSchemaHelper object for [ts_guest_rooms_amenities2] found in cache.
DD : GetCurrentRowsFromGroupInfo: 2 rows selected from ts_guest_rooms_amenities2
DD : Building Row map tree for group [ts_guest_rooms_amenities2].
DD : This may take a while....
DD : Row map tree for group [ts_guest_rooms_amenities2] built.
DD : TTableSchemaHelper object for [ts_guest_rooms_amenities2] found in cache.
DD : url : jdbc:mysql://brandstest.hilton.com:3306/webdb
DD : login : teamsite
DD : login timeout=3
DD : Connecting to the database...
DD : Try connecting using jdbc:mysql://brandstest.hilton.com:3306/webdb...
DD :
Connected to jdbc:mysql://brandstest.hilton.com:3306/webdb
DD : Driver MySQL-AB JDBC Driver
DD : Version mysql-connector-java-3.0.16-ga ( $Date: 2004/09/30 07:35:03 $, $Revision: 1.27.2.44 $ )
DD : Table [IWTEMP_c4b4d92] does not exist. Creating..
DD : CREATE TABLE IWTEMP_c4b4d92(ctyhocn VARCHAR(7) NOT NULL ,crsrmtype VARCHAR(6) NOT NULL ,gra_sequence INT(11) NOT NULL ,amenity VARCHAR
(30) NOT NULL )
DD : Column CTYHOCN not found in array
DD : WARNING:Value for [CTYHOCN] exceeds column width [ 7 > -1]
DD : Column CRSRMTYPE not found in array
DD : WARNING:Value for [CRSRMTYPE] exceeds column width [ 6 > -1]
DD : Column GRA_SEQUENCE not found in array
DD : WARNING:Value for [GRA_SEQUENCE] exceeds column width [ 1 > -1]
DD : Column AMENITY not found in array
DD : WARNING:Value for [AMENITY] exceeds column width [ 6 > -1]
DD : Column CTYHOCN not found in array
DD : WARNING:Value for [CTYHOCN] exceeds column width [ 7 > -1]
DD : Column CRSRMTYPE not found in array
DD : WARNING:Value for [CRSRMTYPE] exceeds column width [ 6 > -1]
DD : Column GRA_SEQUENCE not found in array
DD : WARNING:Value for [GRA_SEQUENCE] exceeds column width [ 1 > -1]
DD : Column AMENITY not found in array
DD : WARNING:Value for [AMENITY] exceeds column width [ 9 > -1]
DD : Inserted 2 rows into IWTEMP_c4b4d92
DD : TTableSchemaHelper not found in cache for [IWTEMP_C4B4D92]. Creating new.
DD : ERROR:Unable to create TTableSchemaHelper object for [IWTEMP_C4B4D92].
DD : ERROR:Exception occured: null
java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbSchemaUtils.BuildColumnListFromVector(TDbSchemaUtils.java:389)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.BuildSelectStmt(TDbSchemaGroupCfg.java:2302)
at com.interwoven.dd100.dd.TDbSchemaRowSort.BuildSortedRows(TDbSchemaRowSort.java:300)

Migrateduser

IWTEMP tables are temp tables that DD creates to help it figure out what rows to update. They are created and deleted soon after. So DD must have adequate permissions to write to the database to create them.

Below is an excerpt from a support case where a customer asked a similar question.

Mariam
----------------------------------------------------------------------------------------------------------------------------------------------

Just got confirmation that the DD user will need the CREATE table privlege. The IWTEMP tables are temporary tables used to store update information and are dropped after the transaction is over. Here is a KB article that lists the specific privileges the DD user account will need:

https://support.interwoven.com/kb/kb_show_article2.asp?ArticleID=50012

The DataDeploy user must be table owner to create a table. It is not necessary with synonyms like insert, update, and delete but for create table it is mandatory.

The conventional approach would be for the DataDeploy user to have it's own tables but no access to any other schema's tables, and to create (public) synonyms such as:

'create public synonym ddtable for dduser.ddtable'

This allows other applications / users to use 'ddtable' without having to know the owner.

Also, in the OD Databae Administration guide, it says you need the following DB privileges for the DD user account:

OpenDeploy must have the following privileges when accessing a database:


insert


update


delete


create table


create view


query permissions