Topic
  • 3 replies
  • Latest Post - ‏2013-01-22T12:28:52Z by SystemAdmin
SystemAdmin
SystemAdmin
7754 Posts

Pinned topic Changing a data connection object

‏2013-01-17T16:12:15Z |
DataStage 8.5:

I have defined a data connection (I am not using associated parameter sets, I just enter the connection details in the connector properties directly) and use this in a Netezza Connector. The job runs fine.

I then modified the connection details in the data connection object, specifically the database name to point my job to a different database, recompile successfully, but when I run or validate the job I get the following error from the connector stage:

Internal error occured (CC_NZMetadataHelper::reconcileOutputLinkSchema, file CC_NZMetadataHelper.cpp, line 1.041)

Does anyone know what this means and why I'm getting the error?

Thanks in advance.
Updated on 2013-01-22T12:28:52Z at 2013-01-22T12:28:52Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    7754 Posts

    Re: Changing a data connection object

    ‏2013-01-18T09:25:10Z  
    Here's some additional information:

    When I open the connector and make a trivial change to the SQL that is executed (e.g. adding some extra white space in the SELECT) save and compile, the job works again.

    I have also looked at the OSH script generated after the change in the connector object and the recompilation and the XML where the database connection information is stored is the same (I'm referring to the <Connection> ... </Connection> XML segment).

    The OSH script for the job version that does not work does have some additional XML though (as far as I can tell by doing a diff, this is the only difference) which is the following:

    <Common>
    <Context type=\'int\'>1</Context>
    <Variant type=\'string\'>4.5</Variant>
    <DescriptorVersion type=\'string\'>1.0</DescriptorVersion>
    <PartitionType type=\'int\'>-1</PartitionType>
    <RCP type=\'int\'>1</RCP>
    </Common>

    Can anyone provide some information that will help me understand this behavior, why I'm getting the error and whether datastage works as expected or if this is a bug?
  • WalkerDean
    WalkerDean
    28 Posts

    Re: Changing a data connection object

    ‏2013-01-18T17:09:48Z  
    Here's some additional information:

    When I open the connector and make a trivial change to the SQL that is executed (e.g. adding some extra white space in the SELECT) save and compile, the job works again.

    I have also looked at the OSH script generated after the change in the connector object and the recompilation and the XML where the database connection information is stored is the same (I'm referring to the <Connection> ... </Connection> XML segment).

    The OSH script for the job version that does not work does have some additional XML though (as far as I can tell by doing a diff, this is the only difference) which is the following:

    <Common>
    <Context type=\'int\'>1</Context>
    <Variant type=\'string\'>4.5</Variant>
    <DescriptorVersion type=\'string\'>1.0</DescriptorVersion>
    <PartitionType type=\'int\'>-1</PartitionType>
    <RCP type=\'int\'>1</RCP>
    </Common>

    Can anyone provide some information that will help me understand this behavior, why I'm getting the error and whether datastage works as expected or if this is a bug?
    I think you need to start a support enquiry related to APAR JR42412 (v2).
    There were several fixes to Data Connection & Common Connector code at
    the beginning of the 8.5 release.
  • SystemAdmin
    SystemAdmin
    7754 Posts

    Re: Changing a data connection object

    ‏2013-01-22T12:28:52Z  
    I think you need to start a support enquiry related to APAR JR42412 (v2).
    There were several fixes to Data Connection & Common Connector code at
    the beginning of the 8.5 release.
    Thank you for the response. 8.5 Fix Pack 3 which includes APAR JR42412 has been applied to the environment where I experience this behavior. I guess I will have to take this up with support.