Error while creating a document type

, ,
1

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

2

Are you still with the error? or solved?

3

Hi Error,

We still have this issue.

-Pawan

4

Sorry Mahesh.

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

5

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.

6

Its OK :slight_smile:

7

Thanks for the solution Mahesh… it worked

8

Ok, happy weekend :smiley: