Skip to end of banner
Go to start of banner

PLM TC Query

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Current »

In this article

Overview

You can use this Snap to execute the saved queries in Teamcenter. PLM TC Query is based on the Teamcenter persistence data model.

Snap Type

The PLM TC Query Snap is a Read-type Snap that executes the saved queries in the Teamcenter.

Prerequisites

  • Valid client ID.

  • A valid account with the required permissions.

Limitations and Known Issues

None.

Snap Views

Type

Format

Number of Views

Examples of Upstream and Downstream Snaps

Description

Input 

Document

  • Min: 0

  • Max: 0

  • N/A

Requires query key, query criteria, and the number of items to be retrieved from Teamcenter.

Output

Document

  • Min: 1

  • Max: 1

  • Snowflake Insert

  • Mapper

  • Teamcenter Info

The output of the executed query.

Error

Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can take the errors that the Snap might encounter when running the pipeline by choosing one of the following options from the When errors occur list under the Views tab:

  • Stop pipeline Execution: Stops the current pipeline execution if the Snap encounters an error.

  • Discard Error Data and Continue: Ignores the error, discards that record, and continues with the remaining records.

  • Route Error Data to Error View: Routes the error data to an error view without stopping the Snap execution.

Learn more about Error handling in Pipelines.

Snap Settings

  • Asterisk ( * ): Indicates a mandatory field.

  • Suggestion icon ((blue star)): Indicates a dynamically populated list based on the configuration.

  • Expression icon ((blue star) ): Indicates the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.

  • Add icon ( (blue star) ): Indicates that you can add fields in the fieldset.

  • Remove icon ( (blue star)): Indicates that you can remove fields from the fieldset.

  • Upload icon ((blue star) ): Indicates that you can upload files.

Field Name

Field Type

Field Dependency

Description

Label*

Default ValuePLM TC Query
ExampleTC query 1

String

None

The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline.

Query Key*

Default Value: N/A
Example: ade_345

String

None

Specify the key name of the query that you want the Snap to execute from Teamcenter.

Max Items*

Default Value: 0
Example: 10

Integer

None

Specify the maximum number of results you want in the query output.

Query Criteria

Specify the name and the value of the query you want the Snap to execute from Teamcenter. Each attribute must be specified as a new row. Click (blue star) to add a row.

Name*

Default ValueN/A
Exampleitem_id

String

None

Specify the name of the query.

Value*

Default ValueN/A
Exampledel_148

String

None

Specify the value of the query.

Wrap Result*

Checkbox

None

Select this checkbox if you want the Snap to return a single document containing the result instead of multiple documents.

Configure Output

Default Valuedeselected

Checkbox

None

Select this checkbox if you want the Snap to specify the configuration of the Teamcenter properties in the output.

Type

 

Default Value: N/A
Example: Diameter

String/Expression

Configure Output

Specify the name of the Teamcenter type.

Expand attributes path

Default Value: N/A
Example: attributes1 → item_response

String/Expression

Configure Output

Specify the path of the expanded attributes in the input document.

Expand Attributes

Specify the attributes you want the Snap to fetch from Teamcenter. Each attribute must be specified as a new row. Click (blue star) to add a row.

Name*

Default Value: None.
ExampleItem_response

String

Configure Output

Specify the name of the attribute.

Snap Execution

Default ValueExecute only
Example: Validate & Execute

Dropdown list

None

Select one of the following three modes in which the Snap executes:

  • Validate & Execute: Performs limited execution of the Snap and generates a data preview during Pipeline validation. Subsequently, performs complete execution of the Snap (unlimited records) during pipeline runtime.

  • Execute only: Performs complete execution of the Snap during pipeline execution without generating preview data.

  • Disabled: Disables the Snap and all Snaps that are downstream from it.

Troubleshooting

Error

Reason

Resolution

Unable to start the embedded Teamcenter Adapter.

The PLM TC requires SOA API Libraries. The required SOA API Libraries are unavailable in the JCC (Java Command Center) environment.

Copy the required API library files to the %SL_ROOT%/teamcenter_lib directory. Then, ensure they are added to SL_CLASSPATH. Verify the correct library setup.

Communication failure with the PLM TC Snap. The host cannot be connected.

The configured hostname cannot be resolved to an IP address.

  • Hostname Check: Verify and correct the hostname.

  • DNS Configuration: Check and correct the DNS configuration.

The connection failed when connecting to the Teamcenter software.

Communication with the Teamcenter Webtier cannot be established because of firewall settings or incorrect URL/port configuration.

Investigate if there's a firewall between the Groundplex and the Teamcenter server. Verify the URL and port settings.

Incorrect account credentials.

The username and password provided in the account configuration are incorrect.

Ensure that the correct username and password are configured in the account.

Invalid user or user does not exist.

The user configured in the account is set to inactive in Teamcenter software.

Reactivate the user account in the Teamcenter software through an authorized user, typically an administrator.

Snap Pack History

 Click here to expand...

Release

Snap Pack Version

Date

Type

Updates

November 2024

main182

Stable

Updated and certified against the current SnapLogic Platform release.

August 2024

main180

21 Aug 2024

Stable

Updated and certified against the current SnapLogic Platform release.

May 2024

main172

Stable

Updated and certified against the current SnapLogic Platform release.

February 2024

main156

Stable

Updated and certified against the current SnapLogic Platform release.

November 2023

main155

Stable

Updated and certified against the current SnapLogic Platform release.

September 2023

main148

Latest/Stable

Introduced the PLM TC. It has the following two accounts:

  • PLM TC Account

  • PLM TC Adapter Account

This Snap Pack includes 35 Snaps that perform various functions, including:

  • BOM Structure Management

  • Data Management

  • Workflow Management

  • Requirements Management

  • Product Management


Related Content

  • No labels