Author Topic: Query Driven Doc Gen fails  (Read 12294 times)


  • EA User
  • **
  • Posts: 688
  • Karma: +17/-0
  • UML/EA Principal Consultant / Trainer
    • View Profile
Query Driven Doc Gen fails
« 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.

follow me on Twitter


OpenIT Solutions

  • EA User
  • **
  • Posts: 552
  • Karma: +7/-1
    • View Profile
Re: Query Driven Doc Gen fails
« Reply #1 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...