Publishing v Deploying

[wyconian]

Hey guys

Has anyone come up against this issue before?  We've just upgraded to C10 from C841.  I've migrated the model to framework manager on C10.  I'm now getting massive degredation in performance from the published model (reports taking 5+ hours to run) against the deployed version of the same model (repors take 5 minutes to run).

There seems to be some issue with publishing from C10 FM.  Does anyone have any idea whats going on or how I can resolve this?

As always thanks for your help

:)

[blom0344]

Haven't experienced this as yet, but I noticed some really strange quirks with FM 10 as opposed to FM 8.
After importing database tables - for instance - I manually changed the datasource in the sql expression (as FM keeps introducing a new one).

So, I changed:

select * from [datasource1].

to select * from [datasource]. In FM8 I can then delete the datasource1 .  FM10 keeps pointing at  datasource1 though it is removed from the sql definitions!!   I had to manually hack the model xml to get rid of them There are some other quirks as well, getting me rather worried!!

[wyconian]

Thanks Blom

I got a call back from IBM.  It looks like part of the issue was we were using reference shortcuts instead of alias shortcuts. Also need to add some options to the interface property of the data source.  I add OL as we're using a SQLServer2008 db.

I don't really understand why that worked but looks like it did.

The other thing that's a bit wierd is that the model we published in C841 and deployed to C10 didn't have these settings and worked fine.

Yay I love my job :)