Hello all!

As you may have seen from my other posts, I am currently involved in the upgrade and migration of a PureConnect site. As part of that, the SQL server has been migrated as the old one was no longer supported.

So, the database was moved successfully.

SUA was re-run and the Database connection was recreated.

The ODBC(32) connections have been verified as correct. (SUA doesn't fully correct these :-/)

The IC Data Sources have been verified (and corrected, as necessary!)

BUT, we aren't seeing any new data since the move. Running reports shows the data from before the migration, which indicates that the connection is OK and the database was successfully moved. I don't see anything stacking up in PMQ either.

Does anyone have any suggestions of where to look next?

TIA

Hello all!

As you may have seen from my other posts, I am currently involved in the upgrade and migration of a PureConnect site. As part of that, the SQL server has been migrated as the old one was no longer supported.

So, the database was moved successfully.

SUA was re-run and the Database connection was recreated.

The ODBC(32) connections have been verified as correct. (SUA doesn't fully correct these :-/)

The IC Data Sources have been verified (and corrected, as necessary!)

BUT, we aren't seeing any new data since the move. Running reports shows the data from before the migration, which indicates that the connection is OK and the database was successfully moved. I don't see anything stacking up in PMQ either.

Does anyone have any suggestions of where to look next?

TIA

Hello all!

As you may have seen from my other posts, I am currently involved in the upgrade and migration of a PureConnect site. As part of that, the SQL server has been migrated as the old one was no longer supported.

So, the database was moved successfully.

SUA was re-run and the Database connection was recreated.

The ODBC(32) connections have been verified as correct. (SUA doesn't fully correct these :-/)

The IC Data Sources have been verified (and corrected, as necessary!)

BUT, we aren't seeing any new data since the move. Running reports shows the data from before the migration, which indicates that the connection is OK and the database was successfully moved. I don't see anything stacking up in PMQ either.

Does anyone have any suggestions of where to look next?

TIA

Thanks to both @Chris Mayo and @Trent Vance!

So, things have moved on a bit (and gotten a little stranger...)

I reviewed the logs you mentioned and could find nothing of note. I also had a play with some reports and discovered that it's not all reports! User Call Detail (both the Legacy and the one in User Reports) and DNIS Call Detail run fine. The legacy Queue Summary report, however, shows no data after the upgrade. I looked at the associated Stored Procedure, View and Table and found that the StatProfile table is missing data since the upgrade.

Does anyone know which subsystem is responsible for generating the data to populate that table? Or if there are any configuration settings I can check?

I'm still debating a server reboot.

TIA

Hello all!

As you may have seen from my other posts, I am currently involved in the upgrade and migration of a PureConnect site. As part of that, the SQL server has been migrated as the old one was no longer supported.

So, the database was moved successfully.

SUA was re-run and the Database connection was recreated.

The ODBC(32) connections have been verified as correct. (SUA doesn't fully correct these :-/)

The IC Data Sources have been verified (and corrected, as necessary!)

BUT, we aren't seeing any new data since the move. Running reports shows the data from before the migration, which indicates that the connection is OK and the database was successfully moved. I don't see anything stacking up in PMQ either.

Does anyone have any suggestions of where to look next?

TIA

Quick update.

It's looking like it's summary data that's mainly affected. Any idea which subsystem I should be targeting?

Thanks to both @Chris Mayo and @Trent Vance!

So, things have moved on a bit (and gotten a little stranger...)

I reviewed the logs you mentioned and could find nothing of note. I also had a play with some reports and discovered that it's not all reports! User Call Detail (both the Legacy and the one in User Reports) and DNIS Call Detail run fine. The legacy Queue Summary report, however, shows no data after the upgrade. I looked at the associated Stored Procedure, View and Table and found that the StatProfile table is missing data since the upgrade.

Does anyone know which subsystem is responsible for generating the data to populate that table? Or if there are any configuration settings I can check?

I'm still debating a server reboot.

TIA

Hello all!

As you may have seen from my other posts, I am currently involved in the upgrade and migration of a PureConnect site. As part of that, the SQL server has been migrated as the old one was no longer supported.

So, the database was moved successfully.

SUA was re-run and the Database connection was recreated.

The ODBC(32) connections have been verified as correct. (SUA doesn't fully correct these :-/)

The IC Data Sources have been verified (and corrected, as necessary!)

BUT, we aren't seeing any new data since the move. Running reports shows the data from before the migration, which indicates that the connection is OK and the database was successfully moved. I don't see anything stacking up in PMQ either.

Does anyone have any suggestions of where to look next?

TIA

Generally speaking I believe that is statserverworkgroup that pushes most of that data to the database, but it also drives real time workgroup data.  Is that being impacted at all?

Quick update.

It's looking like it's summary data that's mainly affected. Any idea which subsystem I should be targeting?

Thanks to both @Chris Mayo and @Trent Vance!

So, things have moved on a bit (and gotten a little stranger...)

I reviewed the logs you mentioned and could find nothing of note. I also had a play with some reports and discovered that it's not all reports! User Call Detail (both the Legacy and the one in User Reports) and DNIS Call Detail run fine. The legacy Queue Summary report, however, shows no data after the upgrade. I looked at the associated Stored Procedure, View and Table and found that the StatProfile table is missing data since the upgrade.

Does anyone know which subsystem is responsible for generating the data to populate that table? Or if there are any configuration settings I can check?

I'm still debating a server reboot.

TIA

Hello all!

As you may have seen from my other posts, I am currently involved in the upgrade and migration of a PureConnect site. As part of that, the SQL server has been migrated as the old one was no longer supported.

So, the database was moved successfully.

SUA was re-run and the Database connection was recreated.

The ODBC(32) connections have been verified as correct. (SUA doesn't fully correct these :-/)

The IC Data Sources have been verified (and corrected, as necessary!)

BUT, we aren't seeing any new data since the move. Running reports shows the data from before the migration, which indicates that the connection is OK and the database was successfully moved. I don't see anything stacking up in PMQ either.

Does anyone have any suggestions of where to look next?

TIA

Generally speaking I believe that is statserverworkgroup that pushes most of that data to the database, but it also drives real time workgroup data.  Is that being impacted at all?

Quick update.

It's looking like it's summary data that's mainly affected. Any idea which subsystem I should be targeting?

Thanks to both @Chris Mayo and @Trent Vance!

So, things have moved on a bit (and gotten a little stranger...)

I reviewed the logs you mentioned and could find nothing of note. I also had a play with some reports and discovered that it's not all reports! User Call Detail (both the Legacy and the one in User Reports) and DNIS Call Detail run fine. The legacy Queue Summary report, however, shows no data after the upgrade. I looked at the associated Stored Procedure, View and Table and found that the StatProfile table is missing data since the upgrade.

Does anyone know which subsystem is responsible for generating the data to populate that table? Or if there are any configuration settings I can check?

I'm still debating a server reboot.

TIA

Hello all!

As you may have seen from my other posts, I am currently involved in the upgrade and migration of a PureConnect site. As part of that, the SQL server has been migrated as the old one was no longer supported.

So, the database was moved successfully.

SUA was re-run and the Database connection was recreated.

The ODBC(32) connections have been verified as correct. (SUA doesn't fully correct these :-/)

The IC Data Sources have been verified (and corrected, as necessary!)

BUT, we aren't seeing any new data since the move. Running reports shows the data from before the migration, which indicates that the connection is OK and the database was successfully moved. I don't see anything stacking up in PMQ either.

Does anyone have any suggestions of where to look next?

TIA

@Aaron Lael,

When I look at Workgroup Overview, Workgroup Details or a Workgroup Queue, I see data showing up, so I don't think that's where the issue lies - good call though! I also checked the statserverworkgroup log, but it didn't contain any errors, so....

We attempted a system reboot last night, but no change.

Generally speaking I believe that is statserverworkgroup that pushes most of that data to the database, but it also drives real time workgroup data.  Is that being impacted at all?

Quick update.

It's looking like it's summary data that's mainly affected. Any idea which subsystem I should be targeting?

Thanks to both @Chris Mayo and @Trent Vance!

So, things have moved on a bit (and gotten a little stranger...)

I reviewed the logs you mentioned and could find nothing of note. I also had a play with some reports and discovered that it's not all reports! User Call Detail (both the Legacy and the one in User Reports) and DNIS Call Detail run fine. The legacy Queue Summary report, however, shows no data after the upgrade. I looked at the associated Stored Procedure, View and Table and found that the StatProfile table is missing data since the upgrade.

Does anyone know which subsystem is responsible for generating the data to populate that table? Or if there are any configuration settings I can check?

I'm still debating a server reboot.

TIA

Hello all!

As you may have seen from my other posts, I am currently involved in the upgrade and migration of a PureConnect site. As part of that, the SQL server has been migrated as the old one was no longer supported.

So, the database was moved successfully.

SUA was re-run and the Database connection was recreated.

The ODBC(32) connections have been verified as correct. (SUA doesn't fully correct these :-/)

The IC Data Sources have been verified (and corrected, as necessary!)

BUT, we aren't seeing any new data since the move. Running reports shows the data from before the migration, which indicates that the connection is OK and the database was successfully moved. I don't see anything stacking up in PMQ either.

Does anyone have any suggestions of where to look next?

TIA

Just a few "silly" questions:

When you ran setup assistant to repoint the database, was the whole system down at the time?  My understanding is that funky things can replicate between the two servers if you do not have the platform completely down -> run SUA on each server to point to the new database server -> then bring a server back online.

Also, have you checked the old database to see if by chance records are being written there?  A lot would need to align for this (firewall rules, etc) but crazier things have happened, especially since you're generating stats successfully with no errors in the system and no backlog in PMQ.

@Aaron Lael,

When I look at Workgroup Overview, Workgroup Details or a Workgroup Queue, I see data showing up, so I don't think that's where the issue lies - good call though! I also checked the statserverworkgroup log, but it didn't contain any errors, so....

We attempted a system reboot last night, but no change.

Generally speaking I believe that is statserverworkgroup that pushes most of that data to the database, but it also drives real time workgroup data.  Is that being impacted at all?

Quick update.

It's looking like it's summary data that's mainly affected. Any idea which subsystem I should be targeting?

Thanks to both @Chris Mayo and @Trent Vance!

So, things have moved on a bit (and gotten a little stranger...)

I reviewed the logs you mentioned and could find nothing of note. I also had a play with some reports and discovered that it's not all reports! User Call Detail (both the Legacy and the one in User Reports) and DNIS Call Detail run fine. The legacy Queue Summary report, however, shows no data after the upgrade. I looked at the associated Stored Procedure, View and Table and found that the StatProfile table is missing data since the upgrade.

Does anyone know which subsystem is responsible for generating the data to populate that table? Or if there are any configuration settings I can check?

I'm still debating a server reboot.

TIA

Hello all!

As you may have seen from my other posts, I am currently involved in the upgrade and migration of a PureConnect site. As part of that, the SQL server has been migrated as the old one was no longer supported.

So, the database was moved successfully.

SUA was re-run and the Database connection was recreated.

The ODBC(32) connections have been verified as correct. (SUA doesn't fully correct these :-/)

The IC Data Sources have been verified (and corrected, as necessary!)

BUT, we aren't seeing any new data since the move. Running reports shows the data from before the migration, which indicates that the connection is OK and the database was successfully moved. I don't see anything stacking up in PMQ either.

Does anyone have any suggestions of where to look next?

TIA