SSIS Package Providex Occasional Extract Issue

SOLVED

We use SSIS to grab all the information from MAS for use in reporting. We use the ODBC driver to do this.

This works with no issues the majority of the time. Occasionally, but still often enough, there will be an issue with the extraction, causing the job to fail.

The job will then continue to fail until the MAS server gets restarted, then there are no issue.  

My question is if there is a way to determine which pvxwin32.exe process is doing what? My hunch is that the one for the extraction gets hung up... thus why the refresh fails until MAS gets restarted.

  • 0
    verified answer
    Yes but it requires manual intervention. If you open the application server you will see all the users and their pvxwin32.exe processes. You can match the ID with the ID in TaskManager and determine which is the extraction process.

    Are you using the SOTAMAS90 DSN or a "silent" DSN?
  • 0 in reply to BigLouie
    SOTAMAS90 to the best of my knowledge.

    I see the PID in master console to match with task manager / tasklist, but it does not appear to be showing the process. But I am seeing the user PIDs so, I can just find the one that doesn't look like them. I'll see if killing the process related to the extract helps.

    Thanks!