DSXchange

Issue is resolved after making below changes.


Webservice Transformer Stage -> Stage (tab) -> Security -> select SSL Encryption Required and select Trust All Servers.


Found this solution on web.

We are inserting this Dummy record (Surrogate Key = -100) manually to the table.


When source has a Key that matches to the dummy record's key, job is failing.
If I filter out that record from source, job runs fine.

Hi, I'm facing below issue with the webservices call. Datastage version is 9.1.2 and APAR JR45664 was covered. http://www-01.ibm.com/support/docview.wss?uid=swg21647640 http://www-01.ibm.com/support/docview.wss?uid=swg21698557 Any suggestions, please? Fatal: 0026`:`com.ascentialsoftware.wsclient.Ser...

I defined data type as Decimal(38,0).
Is SCD converting Decimal(38,0) to unsigned integer?

If yes, how to avoid it?

Hi, One of my datastage jobs is failling with below error in SCD stage. Fatal Error: APT_Decimal::asIntegerU64: the decimal value is out of range for the integer result. Job design: Source(oracle) ->Transformer -> SCD -> Target(oracle) The issue is with dummy record (Surrogate Key = -100) in the dim...