Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Web CMS (TeamSite)
IWOV_IDMAPS not updating
r_pal007
I using TS 6.0.1 on Solaris 9 with OD and DD 6.0.2 and my database is oracle 9i on clustered mode. When I issue iwsyncdb –initial, it complete with successful massage and it also create table and log shows that it only checking IWTRACKER table.
My problem is, where the IWOV_IDMAPS table gone. During this whole process log show nothing about IWOV_IDMAPS. It is not updating IWOV_IDMAPS table. When I deleted both IWOV_IDMAPS and IWTRACKER tables, it only re-create IWTRACKER.
I am not able to figure it out form where it is table IWT_* table name as my log shows, that DAS is validating it from USER_TABLES, and it also validating for IWTRACKER, but then why not IWOV_IDMAPS.
This is my log output….
DAS: SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWT_2FFA2CBF1A5C'
DAS: SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWT_2FFA2CBF1A5C'
DAS: Table [IWT_2FFA2CBF1A5C] does not exist. Creating..
DAS: CREATE TABLE IWT_2FFA2CBF1A5C(Path varchar(255) NOT NULL ,IW_State varchar(255) NOT NULL ,COUNT_CODE number NOT NULL
,CONTACT_TYPE VARCHAR(50) NULL , CONSTRAINT IWT_2FFA2CBF1A5C_key PRIMARY KEY (COUNT_CODE))
DAS: SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWT_26D06A2D5FC'
DAS: SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWT_26D06A2D5FC'
DAS: Table [IWT_26D06A2D5FC] does not exist. Creating..
DAS: CREATE TABLE IWT_26D06A2D5FC(Path varchar(255) NOT NULL ,AIR_CODE NUMBER NOT NULL ,CONTACT_INFO VARCHAR(100) NULL ,CO
UNT_CODE number NOT NULL ,CONTACT_TYPE VARCHAR(50) NULL , CONSTRAINT IWT_26D06A2D5FC_key PRIMARY KEY (AIR_CODE,COUNT_CODE
))
DAS: SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWTRACKER'
DAS: Table [iwtracker] exists.
Thank in advance for sharing for sharing knowledge
Rajesh
Find more posts tagged with
Comments
Migrateduser
yeah mine doesnt update either...very odd. im curious what triggers IWOV_IDMAPS to update?
iwsyncdb.bat -dbschemagen /default/main/fii/WORKAREA/integration customer_svc/forms -force
iwsyncdb.bat -initial /default/main/fii/WORKAREA/integration customer_svc/forms
WoW Profile
TS 6.5 SP1
OD 6.0.2
sbaumann
did you try to restart OD/DD? DAS is caching a lot of information, for example the names of tables created. in my case i had to delete recent rows in IWOV_IDMAPS, IWTRACKER and drop the IWT_**** tables itself. after restarting OD/DD i was able to start iwsyncdb -initial again.
nakumar
If you doesn't see IWOV_IDMAPS at the database end. Try restarting the OD service and run the initial command. It should create IWOV_IDMAPS automatically.
The reason is, we might have deleted IWOV_IDMAPS manually and since the connection details are cached, the deployments might have went as expected and logs might not have entry about IWOV_IDMAPS