ENV: win2k/DD56SP1 + TS61SP1 to Sybase 12.5
configuration files + sample dcrs + database.xml attached.
Hi all, I have a question. I reproduced the following situation:
I have a second backing store named “tui.de”. I set up EventServer and DAS for a deployment to Sybase 12.5
What happened is that submitting a new DCR will result in DAS creating a table named TUI_DE_INTERNET_AUCTION__MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_WORKAREA_GIATA_IMPORT
However the EventServer Subsytem created a table called
TUI.DE_INTERNET_AUCTION__MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_WORKAREA_GIATA_IMPORT
and therefore the DCR EA’s are not written to the table
this event was logged in iwddd.log:
thread[main] waiting to accept...
Deployment Publisher thread running...
Lonely worker thread running...
EventHandler class com.interwoven.dd100.syncdb.TUpdateBaseTables
File type :FILE
Submit file: \templatedata\internet\auction\data\culture_shock Update type: MODIFY
Update type :MODIFY
filepath : /tui.de/main/PRODUKTINFO_GIATA/PRODUCT/MAIN_PRODUCTION/WORKAREA/GIATA_IMPORT/templatedata/internet/auction/data/culture_shock
adds type = internet/auction - /tui.de/main/PRODUKTINFO_GIATA/PRODUCT/MAIN_PRODUCTION/WORKAREA/GIATA_IMPORT/templatedata\internet\auction\data\culture_shock
File: templatedata/internet/auction/data/culture_shock Modified
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\ddt60917.tmp
File list file: C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\ddt60917.tmp
File list:
templatedata/internet/auction/data/culture_shock Modified
Area name: /tui.de/main/PRODUKTINFO_GIATA/PRODUCT/MAIN_PRODUCTION/WORKAREA/GIATA_IMPORT
Base area name: /tui.de/main/PRODUKTINFO_GIATA/PRODUCT/MAIN_PRODUCTION/STAGING
Table name: TUI.DE_INTERNET_AUCTION__MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_WORKAREA_GIATA_IMPORT
BaseTable name: TUI.DE_INTERNET_AUCTION__MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_STAGING
Basetable Prefix: TUI.DE_INTERNET_AUCTION
Basetable Suffix: MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_STAGING
Mytable Prefix: TUI.DE_INTERNET_AUCTION
Mytable Suffix: MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_WORKAREA_GIATA_IMPORT
DD command deployment=submitlist mysubmitlist=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\ddt60917.tmp mybasetablenameprefix=TUI.DE_INTERNET_AUCTION mytablenamesuffix=MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_WORKAREA_GIATA_IMPORT myarea=/tui.de/main/PRODUKTINFO_GIATA/PRODUCT/MAIN_PRODUCTION/WORKAREA/GIATA_IMPORT mytable=TUI.DE_INTERNET_AUCTION__MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_WORKAREA_GIATA_IMPORT mytablenameprefix=TUI.DE_INTERNET_AUCTION cfg=Y:/tui.de/main/PRODUKTINFO_GIATA/PRODUCT/MAIN_PRODUCTION/WORKAREA/GIATA_IMPORT/templatedata/internet/auction/auction_dd.cfg mybasetablenamesuffix=MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_STAGING mybasetable=TUI.DE_INTERNET_AUCTION__MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_STAGING
SerialDaemon dispatch from MessageListener
TWorkItem:
oIt --- sock=0 id=1
msg []
id=1 fDdArgs[0]=[deployment=submitlist]
id=1 fDdArgs[1]=[mysubmitlist=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\ddt60917.tmp]
id=1 fDdArgs[2]=[mybasetablenameprefix=TUI.DE_INTERNET_AUCTION]
id=1 fDdArgs[3]=[mytablenamesuffix=MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_WORKAREA_GIATA_IMPORT]
id=1 fDdArgs[4]=[myarea=/tui.de/main/PRODUKTINFO_GIATA/PRODUCT/MAIN_PRODUCTION/WORKAREA/GIATA_IMPORT]
id=1 fDdArgs[5]=[mytable=TUI.DE_INTERNET_AUCTION__MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_WORKAREA_GIATA_IMPORT]
id=1 fDdArgs[6]=[mytablenameprefix=TUI.DE_INTERNET_AUCTION]
id=1 fDdArgs[7]=[cfg=Y:/tui.de/main/PRODUKTINFO_GIATA/PRODUCT/MAIN_PRODUCTION/WORKAREA/GIATA_IMPORT/templatedata/internet/auction/auction_dd.cfg]
id=1 fDdArgs[8]=[mybasetablenamesuffix=MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_STAGING]
id=1 fDdArgs[9]=[mybasetable=TUI.DE_INTERNET_AUCTION__MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_STAGING]
ERROR
eployment not found
ERROR:ERROR: Unable to determine operation mode
### IWDataDeploy FAILED ###
And iwsyncdb.log says:
net start iwdatadeploy
res=[The Interwoven DataDeploy service is starting.
The Interwoven DataDeploy service was started successfully.
]
EventSubsystem is Enabled
Not registering iwat trigggers
Allowing time for the DataDeploy daemon to come up
...Sleeping 15 seconds...
#####################################################
######## CREATING INTIAL DB TABLES ########
#####################################################
Basetable name: TUI_DE_INTERNET_AUCTION__MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_STAGING
Basetable Prefix: TUI_DE_INTERNET_AUCTION, Basetable Suffix: MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_STAGING
interpreter name: C:\iw-home/iw-perl/bin/iwperl.exe
deployscript name: c:\dd-home/bin/iwdd.ipl
deployconfig name: Y:/tui.de/main/PRODUKTINFO_GIATA/PRODUCT/MAIN_PRODUCTION/STAGING/templatedata/internet/auction/auction_dd.cfg
Y:/tui.de/main/PRODUKTINFO_GIATA/PRODUCT/MAIN_PRODUCTION/STAGING/templatedata/internet/auction/auction_dd.cfg exists
DataDeploy Command=[cfg="Y:/tui.de/main/PRODUKTINFO_GIATA/PRODUCT/MAIN_PRODUCTION/STAGING/templatedata/internet/auction/auction_dd.cfg" deployment=basearea mybasearea="/tui.de/main/PRODUKTINFO_GIATA/PRODUCT/MAIN_PRODUCTION/STAGING" mybasetable=TUI_DE_INTERNET_AUCTION__MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_STAGING mybasetablenameprefix=TUI_DE_INTERNET_AUCTION mybasetablenamesuffix=MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_STAGING mytemplatepath="templatedata/internet/auction/data" ]
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Area name: /tui.de/main/PRODUKTINFO_GIATA/PRODUCT/MAIN_PRODUCTION/WORKAREA/GIATA_IMPORT
Base area name: /tui.de/main/PRODUKTINFO_GIATA/PRODUCT/MAIN_PRODUCTION/STAGING
Table name: TUI_DE_INTERNET_AUCTION__MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_WORKAREA_GIATA_IMPORT
Basetable name: TUI_DE_INTERNET_AUCTION__MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_STAGING
Basetable prefix: TUI_DE_INTERNET_AUCTION
Basetable suffix: MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_STAGING
my_table prefix: TUI_DE_INTERNET_AUCTION
my_table suffix: MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_WORKAREA_GIATA_IMPORT
interpreter name: C:\iw-home/iw-perl/bin/iwperl.exe
deployscript name: c:\dd-home/bin/iwdd.ipl
deployconfig name: Y:/tui.de/main/PRODUKTINFO_GIATA/PRODUCT/MAIN_PRODUCTION/WORKAREA/GIATA_IMPORT/templatedata/internet/auction/auction_dd.cfg
Y:/tui.de/main/PRODUKTINFO_GIATA/PRODUCT/MAIN_PRODUCTION/WORKAREA/GIATA_IMPORT/templatedata/internet/auction/auction_dd.cfg exists
DataDeploy Command=[cfg="Y:/tui.de/main/PRODUKTINFO_GIATA/PRODUCT/MAIN_PRODUCTION/WORKAREA/GIATA_IMPORT/templatedata/internet/auction/auction_dd.cfg" deployment=deltagen myarea="/tui.de/main/PRODUKTINFO_GIATA/PRODUCT/MAIN_PRODUCTION/WORKAREA/GIATA_IMPORT" mybasearea="/tui.de/main/PRODUKTINFO_GIATA/PRODUCT/MAIN_PRODUCTION/STAGING" mytable=TUI_DE_INTERNET_AUCTION__MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_WORKAREA_GIATA_IMPORT mybasetable=TUI_DE_INTERNET_AUCTION__MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_STAGING mybasetablenameprefix=TUI_DE_INTERNET_AUCTION mybasetablenamesuffix=MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_STAGING mytablenameprefix=TUI_DE_INTERNET_AUCTION mytablenamesuffix=MAIN_PRODUKTINFO_GIATA_PRODUCT_MAIN_PRODUCTION_WORKAREA_GIATA_IMPORT mytemplatepath="templatedata/internet/auction/data" ]
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
*** iwsyncdb.ipl DONE ***
Question is whether this is a bug or is this something that should be configured, avoided, etc..? Can anyone tell me?
Regards,
catorarn
