Hi Team,

We are trying to create a document type and getting the below error, could you please help.

9999:wm.tn.portal.doctype:add encountered execution error. Database error while adding type 6lrcbt0a9n212pmd00002ul2: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-02291: integrity constraint (P1WM9TN.FK_BDOCTYPATT_ATTID_BDOCATTDEF) violated - parent key not found . (0) java.sql.SQLIntegrityConstraintViolationException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-02291: integrity constraint (P1WM9TN.FK_BDOCTYPATT_ATTID_BDOCATTDEF) violated - parent key not found

Thanks,
Pawan

Are you still with the error? or solved?

Hi Error,

We still have this issue.

-Pawan

Sorry Mahesh.

Wrongly type the name… edit is not working, getting error.

Hi Error,

The problem was that the system document type was not all available. The BizDocAttributeDef table should contain all the 8 system document attribute types (refer the TN guide for more details)

Please backup database before proceeding.

1. Go to /IntegrationServer/packages/WmTN/bin directory.

2. Execute below command in your OS console (.sh/.bat)
   “tnimport.bat -xml init.xml -db”

3. This will add/update standard metadata to your TN db.

4. Reload WmTN package after importing the metadata.

Its OK

Thanks for the solution Mahesh… it worked

Ok, happy weekend