Solved

How to resolve the error 'FATAL: Invalid YAML file: Both database and table must be set when metadata destination is RAW'

  • 5 October 2023
  • 1 reply
  • 54 views

Badge

I am getting below error while executing Documentum Extractor.

 

FATAL: Invalid YAML file: Both database and table must be set when metadata destination is RAW
com.cognite.connector.dctm.config.InvalidConfigException: Invalid YAML file: Both database and table must be set when metadata destination is RAW.

 

I have gone through the cognite documentation for possible configuration, it is not mentioned in the documentation. There is no parameter for metadata_destination, database, table. Please help me with details, from where we can get this parameter info? or how can I configure it in YAML?

 

Please find my config.yaml file contents as below:

 

version: 1

logger:
    console:
        level: INFO

cognite:
    # Read these from environment variables
    host: #${COGNITE_BASE_URL}
    project: #${COGNITE_PROJECT}

    idp-authentication:
        # token-url: ${COGNITE_TOKEN_URL}
        tenant: #${tenant}
        client-id: #${COGNITE_CLIENT_ID}
        secret: #${COGNITE_CLIENT_SECRET}
        scopes:
            - #${SCOPE}

    external-id-prefix: ABC
    source: documentum
    data-set-id: #${DATASET_ID}
    
extractor:
    sync-mode: full

documentum: 
    mode: DFC
    query: SELECT * FROM dm_document WHERE FOLDER('/temp/')

icon

Best answer by Dilini Fernando 6 October 2023, 12:17

View original

1 reply

Userlevel 4
Badge +2

Hi @Shubham Satish Nalawade,

I will create a Support ticket, so our team can follow up and help you.

Best regards,
Dilini

Reply