I have a really strange one.
We have a TI process that loads data from a flat file to a cube, then executes another process to load the new cube data to a different cube.
When executing the process via Server Explorer, everything happens as expected. We have a Canvas app that includes a function to execute this same TI process. It was working fine until a couple of months ago when it started behaving strangely.
The TI process executes via Canvas, updating log files, generating error files (part of the process), but we have found that it doesn’t actually register any objects on TM1 or commit any data to cubes.
For example, I changed the TI process so it didn’t delete the temporary objects for a cube view that is used as a datasource for the follow on TI process. When executing the main process via Server Explorer, the temporary view is created and remains as expected. When executing via Canvas, however, it runs, even apparently loads data, but the view is never created.
I have eliminated every possible option I can think of, even ruling out security as the issue is there for admin users. I am completely stumped as what it’s doing seems impossible! Any suggestions?
We are on Canvas version 3.2.0.