The TIBCO Platform is a real-time, composable data platform that will bring together an evolving set of your TIBCO solutions - and it's available now!
A chart showing the TIBCO Platform vision
Jump to content
Forums
Ask questions and gain insight from discussions

About data on-demand load automatically met cycle dependencies issue


ShihMin Huang

Recommended Posts

Hi,

I have a on-demand table need to load automatically. But when I tick the load automatically, and refresh the data again, met an error

I have no idea why this simple relationship between both tables cause cycle dependencies.

How could I solve this issue

Here is the error description.

Automatic on-demand loading cannot be performed due to cyclic dependencies.

Cycle found:

Data Column: [CustomerHISTORY].[CustomerDescription]

Data Column: [CustomerHISTORY].[CustomerID]

Data Column: [AllCustomer].[CustomerNumber]

The following is its source information

1. Imported data table from data connection.

Connection name: Connection

View name: CustomerHISTORY

Connection type: Oracle MySQL

Server:

Authentication method: Database authentication

Database:

On-demand settings

Column to filter by: CustomerID

Expression: [AllCustomer].[CustomerNumber]

Limited by active filtering scheme: No

Limited by: (None)

Update behavior: Manual

Caching allowed: Yes

Last reload: 1/13/2020 6:36 PM

2. Edit > Data Table Properties > Relations

Added relation: [AllCustomer].[CustomerNumber] [CustomerHISTORY].[CustomerID]

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...