Sparx Systems Forum

Pro Cloud Server / Prolaborate / WebEA => PCS General Board => Topic started by: philchudley on September 29, 2021, 09:07:48 pm

Title: Query Driven Doc Gen fails
Post by: philchudley on September 29, 2021, 09:07:48 pm

Not sure if this is a general issue but:

I have a master /model document model where the model document is driven by a SQL query to get a set of elements in a specific sequence. The query works just fine and it returns the classguid and classtype

If I generate the document using an ODBC connection it works just fine. BUT if i connect via PCS the query simply does not run and I end up with an empty document!

If this is an issue it really needs to be sorted, there appears to be quite a few things that work with ODBC connections but not with PCS connections.

Phil

Title: Re: Query Driven Doc Gen fails
Post by: OpenIT Solutions on October 21, 2021, 07:11:33 pm

Hi Phil,

I have lots of SQL fragments in my docs and build docs using scripts/sql - all seems fine via PCS (and direct OLE DB connection). Only difference by the sounds of things is that we are using OLE DB with the PCS database connection not ODBC. But if PCS is working - ie you can view content in WebEA etc... then this is unlickly to be the issue...