GO Loader Aviation 1.2 is here! Take a look at what's new.
Skip to end of metadata
Go to start of metadata

Database Tables required for GO Publisher Workflow Operation

GO Publisher Workflow requires the following control tables which are used for all publishing jobs.

Control Tables

Control tables are created automatically by the product upon its first start-up. These tables will be created in the GPWorkflow database schema. This database is specified by the 'WorkflowDS' JNDI connection defined in the application servers configuration.

These control tables are required for all publishing jobs and should not be manually edited or deleted. You should not normally need to create or modify these tables as they are managed by the application. The exception to this is if you uninstall GO Publisher Workflow, in which case you may want to drop these tables, or if this is required as part of a GO Publisher Workflow software upgrade, in which case instructions to do so will be issued on the version release note.

If any of these tables already exist in the target schema of the database then they will not be overwritten/altered. 

For reference, these tables are:

  • CHARACTER_RESOURCE
  • COMPOSITION_TEMPLATE
  • CONFLICTS_VIEW_VALUES
  • DIFFERENCES_VIEW_VALUES
  • FEATURE_RELATION
  • JOB_FILE_TEMPLATE
  • JOB_PARAMETER
  • JOB_TEMPLATE
  • JOB_XSLT_PRODUCT
  • MERGED_PUBLISHED_FILE
  • METADATA_VIEW_EXTRACTION
  • MV_PUBLISH_JOB
  • MV_PUBLISHED_FILE
  • PUBLISH_CALLBACK
  • PUBLISH_ERROR_MESSAGE
  • PUBLISH_FRAGMENT_CONFIG
  • PUBLISH_JOB
  • PUBLISH_PRODUCT
  • PUBLISH_PROJECT
  • PUBLISH_SCHEMA_VALIDATION
  • PUBLISH_SCHEMATRON_VALIDATION
  • PUBLISH_TRANSFORMED_FILE
  • PUBLISH_URL
  • PUBLISH_XSLT_PRODUCT
  • PUBLISHED_FILE
  • SELECTION
  • SELECTION_VALUES
  • VALIDATION_RESULT
  • XSLT_DOCUMENTS

Further Reading

Read about the tables you need to create manually: Job Configuration Tables

 

  • No labels