Administrative Discussions

Resolved! Stitch queries - requirements and troubleshooting

I have two "fact" tables ( one is actually a snapshot table so I'm not trying to get measures from it so much as I'm trying to get point in time attributes from it ) both joined to a date and a customer table where the "fact" is the child.In DW term...

Resolved! Where is the configuration for the cluster email URL ?

I sent a security reset to a user and when they click on the link they are direct to an old ( source for the clone ) URL.Where is the config setting for this in the CMC? Community v Support - who's quicker I'll post the answer here if I get it f...

Resolved! Incorta Metadata DB and credentials

I have a cluster which was cloned from another. I now need to update from <clustername>dev to <clustername> for the _incortametadata connection. However, deleting 'dev' leaves me with an unknown username and using my creds gives me a connection ...

Incorta datatype for a binary data type column?

Had the goofiest thing happen.We have series of MVs consolidating result sets. The origin is SQL against a SQLAnywhere DB. One of the columns is datatype "binary." All was well up until .... yesterday.Yesterday the last build in the sequence fai...

Load fails w/ data agent error, but SQL still returns rows in edit mode

I have a SQL table which just started failing w/ a data agent error:>> INC_03010100: Unknown Error: Extraction failed [com.incorta.connector.dataagent.exception.DataAgentException: Failed to open new channel for executing command [QUERY_DATA]].View ...