Issue with DS 12.2.2.0 wrking with DS 12.2.0.0 Job

dataservices job design
1

We are implementing a pre-built application built on Data Services 12.1.0.0 from a vendor. Our Environment is 12.2.0.0
When we import the Vendor’s Code into our Local Repository, we are experiencing the following issues:

  1. Key Generation’s Transformations’ generated key column is getting empty.
  2. Then when the Job is validated, it throws no error but when the Job is executed it throws error as:

Note: When the code is re-done in 3.2 it is working fine. But because of feasibility and licensing we cannot alter the code and there are something like 100+ dataflows which have to be changed.

Any inputs will be appreciated.

SantoshNirmala :india: (BOB member since 2006-03-15)

2

Do you have a 12.1 version of DS available?

If so - try the following:

  1. Import the 12.1 ATL into a 12.1 repository.
  2. Upgrade that repository to 12.2.2.
  3. Export to 12.2.2 ATL file.
  4. Import 12.2.2 ATL file into your normal 12.2.2 environment.

It seems to me that something isn’t going right when importing a 12.1.0 ATL file into a 12.2.2 environment - specifically with the Key Generation transform. Somehow some of the metadata seems to get lost or isn’t updated correctly.

Otherwise disconnect the Key Generation transform from input and output objects (which probably are a History Preservation transform on your left and a target SCD2 table on your right?).

Reconnect the Key Generation transform and validate the data flow to see if it is okay now.

(@Werner: is this a possible bug?)

Is the vendor supporting DS 12.2.2? If so - ask the vendor to provide you with a DS 12.2.2 compatible version.

ErikR :new_zealand: (BOB member since 2007-01-10)

3

Datastore configurations??? But how is that related to key_gen??? No, can’t be, can it?

Werner Daehn :de: (BOB member since 2004-12-17)