Intermittent Error UDA-SQL-0023 while running the report from cognos server

[cognos8573893]

There is a scheduled report that intermittently gets an UDA-SQL-0023 error but then runs fine when ran again. The message is:

   [Error]       RQP-DEF-0177 An error occurred while performing operation 'sqlStart' status='-90'. UDA-SQL-0023 The connection to the "Blankedout" database has been terminated due to an unrecoverable error. [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Unexpected Network Error. ErrNum = 10054 QE-DEF-0030 Expression parsing error. QE-DEF-0360 The query contains a reference to at least one object '[DivisionWarehouseQuery].[whse]' that does not exist. Possible cause is the use of 2-part reference to a model query item, which is a deprecated feature. QE-DEF-0030 Expression parsing error. QE-DEF-0360 The query contains a reference to at least one object '[DivisionWarehouseQuery].[divno]' that does not exist. Possible cause is the use of 2-part reference to a model query item, which is a deprecated feature. RQP-DEF-0149 The query specification is incorrect. RQP-DEF-0457 Referenced Query 'FinalQuery' is not defined or its query items contain unresolved references.

I have been unable to figure out what is causing this issue as the connection is fine and many tenants connect without issues.

Any thoughts?

thanks,
Billy

[MFGF]

There is a scheduled report that intermittently gets an UDA-SQL-0023 error but then runs fine when ran again. The message is:

   [Error]       RQP-DEF-0177 An error occurred while performing operation 'sqlStart' status='-90'. UDA-SQL-0023 The connection to the "Blankedout" database has been terminated due to an unrecoverable error. [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Unexpected Network Error. ErrNum = 10054 QE-DEF-0030 Expression parsing error. QE-DEF-0360 The query contains a reference to at least one object '[DivisionWarehouseQuery].[whse]' that does not exist. Possible cause is the use of 2-part reference to a model query item, which is a deprecated feature. QE-DEF-0030 Expression parsing error. QE-DEF-0360 The query contains a reference to at least one object '[DivisionWarehouseQuery].[divno]' that does not exist. Possible cause is the use of 2-part reference to a model query item, which is a deprecated feature. RQP-DEF-0149 The query specification is incorrect. RQP-DEF-0457 Referenced Query 'FinalQuery' is not defined or its query items contain unresolved references.

I have been unable to figure out what is causing this issue as the connection is fine and many tenants connect without issues.

Any thoughts?

thanks,
Billy

Hi,

From the error, it looks like you are using a DataDirect Progress OpenEdge ODBC connection to connect to your data source? It also looks like the ODBC is reporting an unexpected network error:

Code Select Expand

Unexpected Network Error. ErrNum = 10054

There are a few hits for this when searching online:

https://community.progress.com/community_groups/openedge_rdbms/f/18/t/14577
https://knowledgebase.progress.com/articles/Article/P192303
https://knowledgebase.progress.com/articles/Article/000054041
https://knowledgebase.progress.com/articles/Article/8500

I would be looking closely at your ODBC connection - and it's worth turning on ODBC Trace to see if you can pinpoint what is causing it to crash?

Cheers!

MF.

[cognos8573893]

I would agree on the network error expect there are other tenants running scheduled reports at the same time connecting to that progress database cluster and do not have that failure. Due to how we have things setup (multi-tenant) based with additional security we cannot enable ODBC trace so troubleshooting is difficult. I will run it by our dev team and double check.

Thanks,
Billy