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.