datasource not found (Datadeploy)

Hi All,

I have created dbschema and ddconfig files through command prompt. But while deployment using the command

C:\Interwoven\OpenDeployNG\bin>iwodcmd start sample1_dd.xml -k iwdd=basearea -k mybasearea=default/main/MCity/WORKAREA/DhineshWA -k mybasetable=employee_nortel -k mytemplatepath=templatedata/categorydhinesh/sample1/data

But the deployment is not getting done and shows this error,

DBD: Path not found -- interpret as 'NotPresent'
DBD: TUPLE={state=NotPresent, path=templatedata\categorydhinesh\sample1\data}

I attached my ddconfig.xml and log files for ref.

Please reply back if anyone of you know the answer for this.

Find more posts tagged with

Comments

nakumar

1) Make sure DATA is present under templatedata\categorydhinesh\sample1\data

2) You are using more than 30 characters for the column. In oracle you can't define a column more than 30 characters. i.e. the reason you can getting ORA-904 error.

Dhinesh

Hi kumar,

In my ddcfg xml file by automatically the following two columns gets added. Once I deleted these two lines, it is working fine.

column name="Path" data-type="varchar(255)" value-from-field="path"
column name="IW_State" data-type="varchar(255)" value-from field="state"

Also before and after of my table name(employee), some spaces gets added automatically in ddcfg.xml like "__employee__".

Also I need to add '/0' character at the end of all value-from-field in the same ddcfg.xml. Orelse I found this error (InvalidSourceTupleException: Values for PK column [EmployeeID] missing ).

I have to deploy all these DCR's automatically to database from workflows(calling through ipl).

Anyone of you know how to remove those unneccessary two columns,remove unneccessary spaces for table name, and appending '/0' automatically?

nakumar

I don't think "Path" and "iw_state" are unnecessary columns. These columns are internally used by DD.

Path will store the path of the DCR data
IW_State will tell the state of the DCR (Original, New, Modified and Not Present)