when i run the DAS option after modifying/creating the dcrs for particular workarea , i am not able to see the tables created in oracle database.
but my log in datadeploy/iwddd.log_Mon-May-19-11.09.45-IST-2003 says that a tuple is inserted.
How come iam not able to see the db tables
here is the log
Inserting into DEFAULT_INTERNET_AUCTION__MAIN_BDMS_WORKAREA_WDMS:
Parameter Index: 1, Value: templatedata\internet\auction\data\eight, Converting 'templatedata\internet\auction\data\eight' to VARCHAR
Column: Path, field: path, Index: 1,Converting 'templatedata\internet\auction\data\eight' to VARCHAR
Parameter Index: 2, Value: Original, Converting 'Original' to VARCHAR
Column: iw_state, field: state, Index: 2,Converting 'Original' to VARCHAR
Parameter Index: 3, Value: 888, Converting '888' to VARCHAR
Column: ROLEID, field: ROLEID, Index: 3,Converting '888' to VARCHAR
Parameter Index: 4, Value: eight, Converting 'eight' to VARCHAR
Column: ROLENAME, field: ROLENAME, Index: 4,Converting 'eight' to VARCHAR
-- Inserted
Filelist walk done
Filelist C:\temp\s260. deleted
UPDATE iwtracker SET UPDATETIME='Mon May 19 11:09:22 IST 2003' WHERE NAME='DEFAULT_INTERNET_AUCTION__MAIN_BDMS_WORKAREA_WDMS'
1 row(s) updated.
Committing database [localhost:2638]...
Deployment[deltaupdate] Table[DEFAULT_INTERNET_AUCTION__MAIN_BDMS_WORKAREA_WDMS]
-----------------------------------
Tuples inserted : 1
Tuples updated : 0
Tuples deleted : 0
Tuples failed : 0
Tuples rolled back : 0
Tuples skipped : 0
-----------------------------------
Files with EA's [1]
Started : Mon May 19 11:09:22 IST 2003
Finished: Mon May 19 11:09:22 IST 2003
### IWDataDeploy DONE ###
thread[main] accepted connection(4)!
SerialDaemon dispatch
awaiting msg...
msg [stop-daemon=yes]
TWorkItem:
oIt --- sock=2345 id=4
*** stop-daemon ***
Exiting...
where as i execute the sql command in the db here is the out put in oracle 8i database
what is going wrong with respect to database ?why is that iam unable to see the tables which are created as per the logs?
ERROR at line 1:
ORA-00972: identifier is too long
SQL> select * from iwtracker
2 ;
select * from iwtracker
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> select * from IWOV_IDMAPS;
select * from IWOV_IDMAPS
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> select * from DEFAULT_INTERNET_AUCTION__MAIN_BDMS_WORKAREA_WDMS;
select * from DEFAULT_INTERNET_AUCTION__MAIN_BDMS_WORKAREA_WDMS
*
ERROR at line 1:
ORA-00972: identifier is too long
SQL>
(I tried thru the DD GUI na dcommand line also , but same error, tables not shown in DB. )
Environment
teamsite 5.5.2
TST 5.5.2
DD 5.5.2
(Without any SP for TS , TSt and DD)
Any Help?
Thanks
Chandra
