DBLookup getting no response on version 2022.09.02

[Keith McLeod]

I have an upgrade issue going from cloverleaf 19.1.1.0 to 2022.09.02. I have been using a stored procedure against a SQL database for a PowerPath Application.  In 19.1.1.0 this has been working fine for years.  When I set up the new servers on 2022.09.02 I get no response back that I can tell using this same stored procedure.  It was thought that the PowerPath Database was too old.  It is now current as they too are doing an upgrade.  I can query both the old PowerPath and the new PowerPath from 19.1 and it works perfectly.  When I go to 2022.09.02, neither the old or the new works.  Using the -metacolumnname argument with dblookup, I get the following:

For PowerPath

Cloveleaf 19.1.1.0

{RSMETACOLUMNNAME {{}}} {RSDATA {{{0}}}}

Cloverleaf 2022.09.02

{RSMETACOLUMNNAME {{}}} {RSDATA {{{}}}}

For Epic Caboodle for comparison

Cloverleaf 19.1.1.0

{RSMETACOLUMNNAME {{PrimaryMrn}}} {RSDATA {{{10101010}}}}

Cloverleaf 2022.09.02

{RSMETACOLUMNNAME {{PrimaryMrn}}} {RSDATA {{{10101010}}}}

I don’t see any errors in the logs even with enable_all.  The DBA says all looks fine from their side.  Looking for help in troubleshooting this and getting it fixed.  This is holding up an Upgrade to cloverleaf.  Any suggestions?  I think I have an open ticket on this but have not heard anything back since this morning… May call again.

 

Topic

[Ramachandran R]

Dear Keith,

Please check the below thread and see if it helps.

Intermittent issues with Basic and Advanced Database Lookup tables

[Author]

Replies