DSXchange

Hi Arvindh, It is a requirement in a fixed width file that every line must have the same number of characters and if it is a delimited file there should be correct numebr of delimiters or else the file parsing will fail. We also faced this issue earlier and the records which had lesser length were d...

Hi,

My problem just resolved. I was only checking the IA level configuration for Analysis Database assuming the same will be defaulted at a project level.

But actually the Project level "Analysis ODBC DSN" was not set. Once I set it then the column analysis ran successfully.

Hi,

My problem just resolved. I was only checking the IA level configuration for Analysis Database assuming the same will be defaulted at a project level.

But actually the Project level "Analysis ODBC DSN" was not set. Once I set it then the column analysis ran successfully.

Hi Manuel,

Did you get a resolution for this?

I am currently facing the same issue on IIS 8.7 while doing the column analysis.

Thanks,
Madhumitha

Hi Ernie, We are using an ISDinput Stage and output stage. our requirement is to lookup the incoming record against a table on a database. I used a parameter set to pass the database credentials. This is where we are facing a problem. When we promote the code or the Information Services components w...

Hi Eric,

We have IIS 8.7 and we are facing the same issue. The Node Agent keeps dying and all the connectors go down and we need to restart the NodeAgent and DSEngine.

On your PMR for Memory Leak did you get any resolution for this in terms of configuration changes?

Thanks,
Madhumitha

Hi, We are using parameter sets in a job which we exposed as a web service. But when we configure it in Information Server Console, the parameter set gets split up into individual parameters and we need to hard code the values when we set the binding. This is causing a problem when promoting the ser...

Hi, We are planning to promote IA objects from DEV to PROD just like any regular code. I am just trying to get my options straight for implementing this. Currently we use Harvest as a source control and we promote jobs through DSImportExportServices.sh through a script that reads dsx file from the s...

Hi, We have installed both 8.1 and 8.7 clients. Sometimes when we need to switch to the other version we are getting the following error: The Following problems occured while trying to set the version: Failed to read log file from verification process (C:\WINDOWS\TEMP\MCMD4.tmp) When we restart and ...

Cool!! Thank you so much!

We have DB2 connector but not Classic federation.

Looks like we may have to use datastage to convert CFF to FF I guess.. as pre-processing.

Regards,
Madhumitha

Awesome!!

Thank you so much Robert!! I tried it out and it worked.

Though when I try to edit that table definition through IA it didnt work...

But when i changed the metadata in the XML and reran it the changes got updated.

Regards,
Madhumitha

Hi Robert,

Thank you so much. We have raised a PMR. And also we will try to include it in the Rule Definition.

Will let know know how the PMR goes.

Thanks,
Madhumitha

Hi All,

I was just wondering if we can configure a DB2 mainframes and VSAM files as a source on Information Analyzer.

Thanks,
Madhumitha

Thank you so much for the response, I guess the column analysis is already done.. We are trying to create a virtual table with a valid set of data so that we can build data rules on them. Since we are using scd 2 we need to use records with null expiry_dt. This is where we are facing an issue. Is th...

Hi, I am trying to create a virtual table on Information Analyzer and I need to fetch all the records which have null value in a date field. When I try to do END_DT IS NULL or END_DT = TO_DATE(NULL,'MM-DD-YYYY') in the free form editor it is not working. Though these are working directly on the data...