Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3215

External Materialization ON_VDB_START_SCRIPT invocation issues

    Details

    • Steps to Reproduce:
      Hide

      1. Define teiid_rel:ON_VDB_START_SCRIPT property with external materialized view table.
      2. Copy the vdb into deployments folder of stopped server
      3. Start the server
      4. Check that ON_VDB_START_SCRIPT wasn't invoked (Via debug log or expected action performed by the script)

      Show
      1. Define teiid_rel:ON_VDB_START_SCRIPT property with external materialized view table. 2. Copy the vdb into deployments folder of stopped server 3. Start the server 4. Check that ON_VDB_START_SCRIPT wasn't invoked (Via debug log or expected action performed by the script)
    • Affects:
      Documentation (Ref Guide, User Guide, etc.)
    • Workaround:
      Workaround Exists
    • Workaround Description:
      Hide

      Only deploy the VDB to the running server, not copy to the directory and start the server

      Show
      Only deploy the VDB to the running server, not copy to the directory and start the server
    • Estimated Difficulty:
      Low

      Description

      With materialized view I have set teiid_rel:ON_VDB_START_SCRIPT property for the external matview table. (Simple query to increment a column in table to count invocations.)
      Invocation of the script is dependent upon the way the vdb is deployed. The first case (A) doesn't invoke the script, the second (B) does.
      A - 1. Copy the vdbname-vdb.xml into deployments folder
      2. Start the server
      B - 1. Start the server
      2. Copy the vdbname-vdb.xml into deployments folder

      That means that after server stop (maintenance) the script is not invoked on start, which can cause problems when the script is used to initialize running environment (clear table, create temporary table,...)

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                rareddy Ramesh Reddy
                Reporter:
                jstastny Jan Stastny
                Tester:
                Jan Stastny
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: