Does anyone know when that after I created a new loaddb.cfg file for an OD-DD sync - I get the following error about the datatype not being registered for each DCR I create when it get's sent to the Oracle 8i database - the following is the last entry in iwddd.log
Connected to jdbc
racle
ci8:
@PW.FQ.STAGE
Driver Oracle JDBC driver
Version 8.1.7.3.0
Connected to [PW.FQ.STAGE]
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWT_22CD25280B56'
Table [IWT_22CD25280B56] exists.
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWT_21BB99F3E92A'
Table [IWT_21BB99F3E92A] exists.
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWTRACKER'
Table [iwtracker] exists.
DEFAULT_SALES_RESOURCES_SALES_IDEA__SALES_IDEA__MAIN_FII_STAGING not registered
Error occured in TDbSchemaSynchronizer
ERROR:TDbSchemaSynchronizer create failure.
Stat for group [sales_idea]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Stat for group [rel_fund]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Rollback database [PW.FQ.STAGE]...
Deployment[submitlist]
-----------------------------------
DCRs inserted : 0
DCRs updated : 0
DCRs deleted : 0
DCRs failed : 0
DCRs rolled back : 0
DCRs skipped : 0
-----------------------------------
Started : Wed Jul 30 07:30:13 EDT 2003
Finished: Wed Jul 30 07:30:13 EDT 2003
### IWDataDeploy FAILED ###
thread[main] accepted connection(162)!
awaiting msg...
SerialDaemon dispatch
TWorkItem:
oIt --- sock=2345 id=162
msg [cfg="Y:/default/main/fii/WORKAREA/integration/templatedata/commentary/commentary/commentary_dd.cfg" deployment=deltaupdate myarea="/default/main/fii/WORKAREA/integration" mybasearea="/default/main/fii/STAGING" mytable=DEFAULT_COMMENTARY_COMMENTARY__MAIN_FII_WORKAREA_INTEGRATION mybasetable=DEFAULT_COMMENTARY_COMMENTARY__MAIN_FII_STAGING mybasetablenameprefix=DEFAULT_COMMENTARY_COMMENTARY mybasetablenamesuffix=MAIN_FII_STAGING mytablenameprefix=DEFAULT_COMMENTARY_COMMENTARY mytablenamesuffix=MAIN_FII_WORKAREA_INTEGRATION myfilelist=C:\ddtemp\s43k.2 ]
id=162 fDdArgs[0]=[cfg="Y:/default/main/fii/WORKAREA/integration/templatedata/commentary/commentary/commentary_dd.cfg"]
id=162 fDdArgs[1]=[deployment=deltaupdate]
id=162 fDdArgs[2]=[myarea="/default/main/fii/WORKAREA/integration"]
id=162 fDdArgs[3]=[mybasearea="/default/main/fii/STAGING"]
id=162 fDdArgs[4]=[mytable=DEFAULT_COMMENTARY_COMMENTARY__MAIN_FII_WORKAREA_INTEGRATION]
id=162 fDdArgs[5]=[mybasetable=DEFAULT_COMMENTARY_COMMENTARY__MAIN_FII_STAGING]
id=162 fDdArgs[6]=[mybasetablenameprefix=DEFAULT_COMMENTARY_COMMENTARY]
id=162 fDdArgs[7]=[mybasetablenamesuffix=MAIN_FII_STAGING]
id=162 fDdArgs[8]=[mytablenameprefix=DEFAULT_COMMENTARY_COMMENTARY]
id=162 fDdArgs[9]=[mytablenamesuffix=MAIN_FII_WORKAREA_INTEGRATION]
id=162 fDdArgs[10]=[myfilelist=C:\ddtemp\s43k.2]
Database Vendor set to oracle
Max Identifier length set to 20 characters.
SQL datatype for column IW_State is varchar(255)
SQL datatype for column Path is varchar(255)
SQL datatype for column content_id is NUMBER
SQL datatype for column Heading1 is VARCHAR2(255)
SQL datatype for column commentary_type is VARCHAR2(255)
SQL datatype for column commentary_subtype is VARCHAR2(255)
SQL datatype for column madden_comm is VARCHAR2(5)
SQL datatype for column publish_date is DATE
SQL datatype for column expiration_date is DATE
SQL datatype for column audience_category is VARCHAR2(1000)
SQL datatype for column audience_firm is VARCHAR2(500)
SQL datatype for column teaser is VARCHAR2(255)
SQL datatype for column teaser_link_text is VARCHAR2(255)
SQL datatype for column teaser_image is VARCHAR2(255)
SQL datatype for column teaser_byline_name is VARCHAR2(255)
SQL datatype for column search_keywords is VARCHAR2(255)
SQL datatype for column meta_search_phrases is VARCHAR2(255)
# of columns: 17
# of primary key columns specified: 1
SQL datatype for column Path is varchar(255)
SQL datatype for column content_id is NUMBER
SQL datatype for column rep_order is NUMBER
SQL datatype for column audio_type is VARCHAR2(15)
SQL datatype for column linktext is VARCHAR2(255)
SQL datatype for column teaser is VARCHAR2(255)
SQL datatype for column web_ad is VARCHAR2(255)
# of columns: 7
# of primary key columns specified: 2
# of foreign key columns specified: 1
SQL datatype for column Path is varchar(255)
SQL datatype for column content_id is NUMBER
SQL datatype for column rep_order is NUMBER
SQL datatype for column fund_share_id is NUMBER
# of columns: 4
# of primary key columns specified: 2
# of foreign key columns specified: 1
# of groups defined in <dbschema> element: 3
Area VPath:/default/main/fii/WORKAREA/integration
Setting up TDbSchemaSynchronizer.
Assuming TNS name has been specified for "db" attribute.
Validating cached connection...
Cached connection OK
Connected to [PW.FQ.STAGE]
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWT_1C849C7B594'
Table [IWT_1C849C7B594] exists.
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWT_24A510D291D6'
Table [IWT_24A510D291D6] exists.
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWT_241890237103'
Table [IWT_241890237103] exists.
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWTRACKER'
Table [iwtracker] exists.
DEFAULT_COMMENTARY_COMMENTARY__COMM__MAIN_FII_STAGING not registered
Error occured in TDbSchemaSynchronizer
ERROR:TDbSchemaSynchronizer create failure.
Stat for group [comm]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Stat for group [CopySectionDetails]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Stat for group [related_fund_info]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Rollback database [PW.FQ.STAGE]...
Deployment[deltaupdate]
-----------------------------------
DCRs inserted : 0
DCRs updated : 0
DCRs deleted : 0
DCRs failed : 0
DCRs rolled back : 0
DCRs skipped : 0
-----------------------------------
Started : Wed Jul 30 07:38:03 EDT 2003
Finished: Wed Jul 30 07:38:04 EDT 2003
### IWDataDeploy FAILED ###
