SSIS Service Crashes on SSIS dataflow

More
2 years 7 months ago #13823 by pmurphytc
For tables with long names (e.g. 35 characters) transferring data from a postgres database to SQL Server via SSIS, ISSService.exe crashes with a Termination Failure error. It works via Visual Studio 2012, but does not work execution the package via Mgmt Studio or SQLAgent. Details below:

Faulting application name: ISServerExec.exe, version: 11.0.5058.0, time stamp: 0x53741839
Faulting module name: PGNP64.dll, version: 1.4.0.3218, time stamp: 0x53260265
Exception code: 0xc0000409
Fault offset: 0x00000000001b74a4
Faulting process id: 0x21e4
Faulting application start time: 0x01d0763f449f70ef
Faulting application path: c:\Program Files\Microsoft SQL Server\110\DTS\Binn\ISServerExec.exe
Faulting module path: C:\Program Files (x86)\Intellisoft\PGNP\PGNP64.dll
Report Id: 830f3a19-e232-11e4-9463-0e7a48014daf
Faulting package full name:
Faulting package-relative application ID:

Please Log in or Create an account to join the conversation.

More
2 years 7 months ago #13824 by pmurphytc
After a lot of time spent on this, I changed the SQL Agent configuration to run the SSIS runtime in 32-bit mode. Any input from anyone else would be appreciated on this.

Thanks.

Please Log in or Create an account to join the conversation.

More
2 years 7 months ago #13825 by Moderator
We have tested the product with very long identifiers, and very long queries (over 1M characters). No crash, leak or other issue was identified.

However, the build 3218 you used is 1+ year old, and the issue could have been fixed since the build was created. Could you update the product to the latest build?

Please Log in or Create an account to join the conversation.

More
2 years 7 months ago #13827 by pmurphytc
Yes, I can upgrade. I did try that, but when I ran the update, it told me my license wasn't valid, which I know is incorrect.

Please Log in or Create an account to join the conversation.

More
2 years 7 months ago #13828 by Moderator
The "Invalid License" is very generic and too overloaded message. During upgrade it indicates that the Support and Updates period for the license had expired and needs to be renewed. Sometimes it indicates SKU mismatch, when Desktop installation is upgraded over with Server module. Please contact our support, and we will help in troubleshooting the issue.

Please Log in or Create an account to join the conversation.

Time to create page: 0.144 seconds
Powered by Kunena Forum